Helper Table Definitions
Helper tables are used by the Data Warehouse transformations to aid in the population process. These tables are used for refresh and delete, as well as for data conversions. Normally you would not query these tables directly, but would instead query the views.
WHCC_MAPPINGS and WHCF_MAPPINGS resolve cases where two custom fields, associated with different categories, may have the same field name. In a view that combines information from multiple categories, there is the possibility that the two identical field names would cause identical column names, an error. Instead, these tables make sure that column names are always unique. The name used by the view is contained in column FIELD_NAME_MAP and the original name for the field is in column FIELD_NAME. Use WH_CC_MAPPINGS for WH_CC_XXXX, and use WH_CF_MAPPINGS for WH_CF_XXXX.
WH_CUSTOM_NUMB, WH_CUSTOM_DATE, WH_CUSTOM_MEMO, WH_CUSTOM_TEXT, WH_CUSTOM_OBJE, and WH_CUSTOM_OBJF contain values for custom fields. The six tables correspond to the six kinds of datatypes that can be used by custom fields.
WH_MAPPING table contains the mapping between TeamConnect transactional tables to the Data Warehouse tables. These are system fields and are static.
In addition to the other helper tables described above, there are many workflow-related helper tables, two for each system object (for example, WH_HELPER_ACCOUNT_WORKFLOW and WH_HELPER_ACCOUNT_WORKFLOW_RVW, for the Account object.)
WH_CC_MAPPINGS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
ENTITY_CODE |
VARCHAR2(9) |
VARCHAR(9) |
|
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
OBJECT_IS_EMBEDDED |
VARCHAR2(5) |
VARCHAR(5) |
|
CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
|
DETAIL_FIELD_TYPE |
VARCHAR2(20) |
VARCHAR(20) |
|
ORIGINAL_FIELD_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
TABLE_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
TABLE_SEQ |
NUMBER |
INT |
|
ID_COLUMN |
VARCHAR2(30) |
VARCHAR(30) |
|
FIELD_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
FIELD_LABEL |
VARCHAR2(50) |
VARCHAR(50) |
|
COLUMN_TYPE |
VARCHAR2(40) |
VARCHAR(40) |
|
FIELD_NAME_MAP |
VARCHAR2(30) |
VARCHAR(30) |
|
LOOKUP_TABLE_PRIMARY_KEY |
NUMBER |
INT |
|
LOOKUP_TABLE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
LOOKUP_TABLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
| IS_TCBI_DATA_MART | NUMBER | INT |
WH_CF_MAPPINGS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
ENTITY_CODE |
VARCHAR2(9) |
VARCHAR(9) |
|
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
OBJECT_IS_EMBEDDED |
VARCHAR2(5) |
VARCHAR(5) |
|
CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
|
DETAIL_FIELD_TYPE |
VARCHAR2(20) |
VARCHAR(20) |
|
ORIGINAL_FIELD_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
TABLE_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
TABLE_SEQ |
NUMBER |
INT |
|
ID_COLUMN |
VARCHAR2(30) |
VARCHAR(30) |
|
FIELD_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
FIELD_LABEL |
VARCHAR2(50) |
VARCHAR(50) |
|
COLUMN_TYPE |
VARCHAR2(40) |
VARCHAR(40) |
|
FIELD_NAME_MAP |
VARCHAR2(30) |
VARCHAR(30) |
|
LOOKUP_TABLE_PRIMARY_KEY |
NUMBER |
INT |
|
LOOKUP_TABLE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
LOOKUP_TABLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
| IS_TCBI_DATA_MART | NUMBER | INT |
| IS_TIME_ZONE_INDEPENDENT | VARCHAR2(5) | VARCHAR(5) |
| INDEX_NAME | VARCHAR2(30) | VARCHAR(30) |
WH_CUSTOM_DATE
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
VALUE_PK |
NUMBER |
INT |
|
ENTITY_CODE |
VARCHAR2(9) |
VARCHAR(9) |
|
DETAIL_VALUE |
DATE |
DATETIME |
|
TABLE_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
COLUMN_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
OBJECT_ID |
NUMBER |
INT |
|
OBJECT_ID_NAME |
VARCHAR2(30) |
VARCHAR(30) |
WH_CUSTOM_MEMO
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
VALUE_PK |
NUMBER |
INT |
|
ENTITY_CODE |
VARCHAR2(9) |
VARCHAR(9) |
|
DETAIL_VALUE |
CLOB |
NTEXT |
|
TABLE_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
COLUMN_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
OBJECT_ID |
NUMBER |
INT |
|
OBJECT_ID_NAME |
VARCHAR2(30) |
VARCHAR(30) |
WH_CUSTOM_NUMB
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
VALUE_PK |
NUMBER |
INT |
|
ENTITY_CODE |
VARCHAR2(9) |
VARCHAR(9) |
|
DETAIL_VALUE |
NUMBER |
INT |
|
TABLE_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
COLUMN_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
OBJECT_ID |
NUMBER |
INT |
|
OBJECT_ID_NAME |
VARCHAR2(30) |
VARCHAR(30) |
WH_CUSTOM_OBJE
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
VALUE_PK |
NUMBER |
INT |
|
ENTITY_CODE |
VARCHAR2(9) |
VARCHAR(9) |
|
DETAIL_VALUE |
VARCHAR2(700) |
VARCHAR(700) |
|
TABLE_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
COLUMN_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
OBJECT_ID |
NUMBER |
INT |
|
OBJECT_ID_NAME |
VARCHAR2(30) |
VARCHAR(30) |
WH_CUSTOM_OBJF
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
VALUE_PK |
NUMBER |
INT |
|
ENTITY_CODE |
VARCHAR2(9) |
VARCHAR(9) |
|
DETAIL_VALUE_FID |
NUMBER |
INT |
|
TABLE_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
COLUMN_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
OBJECT_ID |
NUMBER |
INT |
|
OBJECT_ID_NAME |
VARCHAR2(30) |
VARCHAR(30) |
WH_CUSTOM_TEXT
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
VALUE_PK |
NUMBER |
INT |
|
ENTITY_CODE |
VARCHAR2(9) |
VARCHAR(9) |
|
DETAIL_VALUE |
VARCHAR2(2000) |
VARCHAR(2000) |
|
TABLE_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
COLUMN_NAME |
VARCHAR2(30) |
VARCHAR(30) |
|
OBJECT_ID |
NUMBER |
INT |
|
OBJECT_ID_NAME |
VARCHAR2(30) |
VARCHAR(30) |
WH_HELPER_CONTACT
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
CONTACT_PK |
NUMBER |
INT |
|
CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
|
CONTACT_DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
WH_HELPER_CONTACT_RELATIONS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
LEFT_CONTACT_PRIMARY_KEY |
NUMBER |
INT |
|
LEFT_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
|
LEFT_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
LEFT_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
LEFT_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
RELATION_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
RELATION_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
|
RIGHT_CONTACT_PRIMARY_KEY |
NUMBER |
INT |
|
RIGHT_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
|
RIGHT_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
RIGHT_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
RIGHT_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
WH_HELPER_PROJECT
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
PROJECT_PK |
NUMBER |
INT |
|
OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
|
DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_PHASE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
WH_HELPER_PROJECTS_RELATIONS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
LEFT_OBJECT_UNIQUE_CODE |
VARCHAR2(10) |
VARCHAR(10) |
|
LEFT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
LEFT_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
LEFT_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
LEFT_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
RELATION_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
RELATION_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
|
RIGHT_OBJECT_UNIQUE_CODE |
VARCHAR2(10) |
VARCHAR(10) |
|
RIGHT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
RIGHT_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
RIGHT_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
RIGHT_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
WH_LAST_REFRESH
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
ENTITY_CODE |
VARCHAR2(9) |
VARCHAR(9) |
|
LAST_REFRESH_DATE |
DATE |
DATETIME |
|
LAST_REFRESH_SYSTEM_DATE |
DATE |
DATETIME |
Note: Unlike all the other tables described in this chapter which exist in the "target" database, table WH_REMOVED_RECORDS exists in the "source database.
WH_REMOVED_RECORDS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
ENTITY_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
APPLICATION_ID |
NUMBER |
INT |
|
PRIMARY_KEY |
NUMBER |
INT |
|
MODIFIED_ON |
DATE |
DATETIME |
|
REMOVED_ON |
DATE |
DATETIME |
WH_VERSION
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
VERSION_PRIMARY_KEY |
NUMBER |
INT |
|
UPGRADE_DATE |
DATE |
DATETIME |
|
VERSION |
VARCHAR2(50) |
VARCHAR(50) |
|
PRODUCT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
WH_HELPER_ACCOUNT_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
|
ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
|
ACCOUNT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
|
ACCOUNT_OVERDRAFT_TYPE |
VARCHAR2(30) |
VARCHAR2(30) |
|
ACCOUNT_PERIOD_START_ON_DATE |
DATE |
DATETIME |
|
ACCOUNT_PERIOD_END_ON_DATE |
DATE |
DATETIME |
|
ACCOUNT_STATUS |
VARCHAR2(8) |
VARCHAR2(8) |
|
ACCOUNT_ALLOW_POSTING |
VARCHAR2(1) |
VARCHAR2(1) |
|
ACCOUNT_ALLOCATION_LIMIT |
NUMBER |
DECIMAL(28,12) |
|
ACCOUNT_TOTAL_ALLOCATED |
NUMBER |
DECIMAL(28,12) |
|
ACCOUNT_TOTAL_USED |
NUMBER |
DECIMAL(28,12) |
|
ACCOUNT_BALANCE |
NUMBER |
DECIMAL(28,12) |
|
PARENT_ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
|
PARENT_ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR2(30) |
|
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR2(30) |
|
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR2(250) |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR2(30) |
|
REJECT_REASON |
VARCHAR2(50) |
VARCHAR2(50) |
|
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR2(105) |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
|
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
|
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
|
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR2(40) |
|
ACTION_DATE |
DATE |
DATETIME |
|
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR2(2000) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
STOP_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
WH_HELPER_ACCOUNT_WORKFLOW_RVW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
|
ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
ACCOUNT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
ACCOUNT_OVERDRAFT_TYPE |
VARCHAR2(30) |
VARCHAR(30) |
|
ACCOUNT_PERIOD_START_ON_DATE |
DATE |
DATETIME |
|
ACCOUNT_PERIOD_END_ON_DATE |
DATE |
DATETIME |
|
ACCOUNT_STATUS |
VARCHAR2(8) |
VARCHAR(8) |
|
ACCOUNT_ALLOW_POSTING |
VARCHAR2(1) |
VARCHAR(1) |
|
ACCOUNT_ALLOCATION_LIMIT |
NUMBER |
DECIMAL(28,12) |
|
ACCOUNT_TOTAL_ALLOCATED |
NUMBER |
DECIMAL(28,12) |
|
ACCOUNT_TOTAL_USED |
NUMBER |
DECIMAL(28,12) |
|
ACCOUNT_BALANCE |
NUMBER |
DECIMAL(28,12) |
|
PARENT_ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
|
PARENT_ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
REVIEW_ACTION_DATE |
DATE |
DATETIME |
|
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
WH_HELPER_APPOINTMENT_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
APPOINTMENT_PRIMARY_KEY |
NUMBER |
INT |
|
APPOINTMENT_SUBJECT |
VARCHAR2(250) |
VARCHAR2(250) |
|
APPOINTMENT_LOCATION |
VARCHAR2(250) |
VARCHAR2(250) |
|
APPOINTMENT_AREA |
VARCHAR2(50) |
VARCHAR2(50) |
|
APPOINTMENT_START_ON |
DATE |
DATETIME |
|
APPOINTMENT_END_ON |
DATE |
DATETIME |
|
APPOINTMENT_IS_ALL_DAY |
VARCHAR2(1) |
VARCHAR2(1) |
|
APPOINTMENT_DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR2(50) |
|
APPOINTMENT_DEFAULT_CAT_TREE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
|
MILESTONE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
MILESTONE_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_PRIMARY_KEY |
NUMBER |
INT |
|
MILESTONE_SUBJECT |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_DATE |
DATE |
DATETIME |
|
MILESTONE_DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
|
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
ACTION_DATE |
DATE |
DATETIME |
|
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
STOP_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
WH_HELPER_APPOINTMENT_WKFL_RVW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
APPOINTMENT_PRIMARY_KEY |
NUMBER |
INT |
|
APPOINTMENT_SUBJECT |
VARCHAR2(250) |
VARCHAR(250) |
|
APPOINTMENT_LOCATION |
VARCHAR2(250) |
VARCHAR(250) |
|
APPOINTMENT_AREA |
VARCHAR2(50) |
VARCHAR(50) |
|
APPOINTMENT_START_ON |
DATE |
DATETIME |
|
APPOINTMENT_END_ON |
DATE |
DATETIME |
|
APPOINTMENT_IS_ALL_DAY |
VARCHAR2(1) |
VARCHAR(1) |
|
APPOINTMENT_DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
|
APPOINTMENT_DEFAULT_CAT_TREE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
REVIEW_ACTION_DATE |
DATE |
DATETIME |
|
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
WH_HELPER_CONTACT_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
CONTACT_PRIMARY_KEY |
NUMBER |
INT |
|
CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
|
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
ACTION_DATE |
DATE |
DATETIME |
|
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
STOP_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
WH_HELPER_CONTACT_WORKFLOW_RVW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
CONTACT_PRIMARY_KEY |
NUMBER |
INT |
|
CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
REVIEW_ACTION_DATE |
DATE |
DATETIME |
|
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
WH_HELPER_DOCUMENT_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
DOCUMENT_PRIMARY_KEY |
NUMBER |
INT |
|
DOCUMENT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
DOCUMENT_TREE_KEY |
VARCHAR2(700) |
VARCHAR(700) |
|
DOCUMENT_FILE_TYPE |
VARCHAR2(50) |
VARCHAR(50) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
|
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
ACTION_DATE |
DATE |
DATETIME |
|
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
STOP_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
WH_HELPER_DOCUMENT_WKFL_RVW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
DOCUMENT_PRIMARY_KEY |
NUMBER |
INT |
|
DOCUMENT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
DOCUMENT_TREE_KEY |
VARCHAR2(700) |
VARCHAR(700) |
|
DOCUMENT_FILE_TYPE |
VARCHAR2(50) |
VARCHAR(50) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
REVIEW_ACTION_DATE |
DATE |
DATETIME |
|
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
WH_HELPER_EXPENSE_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
EXPENSE_PRIMARY_KEY |
NUMBER |
INT |
|
EXPENSE_DATE |
DATE |
DATETIME |
|
EXPENSE_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
|
EXPENSE_POSTING_STATUS |
VARCHAR2(19) |
VARCHAR(19) |
|
EXPENSED_BY_CONTACT_PK |
NUMBER |
INT |
|
EXPENSED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
EXPENSED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
EXPENSED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
EXPENSED_BY_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
EXPENSE_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
|
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
ACTION_DATE |
DATE |
DATETIME |
|
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
STOP_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
WH_HELPER_EXPENSE_WORKFLOW_RVW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
EXPENSE_PRIMARY_KEY |
NUMBER |
INT |
|
EXPENSE_DATE |
DATE |
DATETIME |
|
EXPENSE_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
|
EXPENSE_POSTING_STATUS |
VARCHAR2(19) |
VARCHAR(19) |
|
EXPENSED_BY_CONTACT_PK |
NUMBER |
INT |
|
EXPENSED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
EXPENSED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
EXPENSED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
EXPENSED_BY_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
EXPENSE_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
REVIEW_ACTION_DATE |
DATE |
DATETIME |
|
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
WH_HELPER_HISTORY_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
HISTORY_PRIMARY_KEY |
NUMBER |
INT |
|
HISTORY_DATE |
DATE |
DATETIME |
|
HISTORY_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
|
PARENT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
HISTORY_PARENT_TYPE |
VARCHAR2(17) |
VARCHAR(17) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
|
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
ACTION_DATE |
DATE |
DATETIME |
|
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
STOP_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
WH_HELPER_HISTORY_WORKFLOW_RVW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
HISTORY_PRIMARY_KEY |
NUMBER |
INT |
|
HISTORY_DATE |
DATE |
DATETIME |
|
HISTORY_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
|
PARENT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
HISTORY_PARENT_TYPE |
VARCHAR2(17) |
VARCHAR(17) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
REVIEW_ACTION_DATE |
DATE |
DATETIME |
|
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
WH_HELPER_INVOICE_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
INVOICE_PRIMARY_KEY |
NUMBER |
INT |
|
INVOICE_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
INVOICE_DATE |
DATE |
DATETIME |
|
INVOICE_RECEIVED_DATE |
DATE |
DATETIME |
|
INVOICE_PERIOD_END_ON |
DATE |
DATETIME |
|
INVOICE_PERIOD_START_ON |
DATE |
DATETIME |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
|
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
ACTION_DATE |
DATE |
DATETIME |
|
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
STOP_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
WH_HELPER_INVOICE_WORKFLOW_RVW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
INVOICE_PRIMARY_KEY |
NUMBER |
INT |
|
INVOICE_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
INVOICE_DATE |
DATE |
DATETIME |
|
INVOICE_RECEIVED_DATE |
DATE |
DATETIME |
|
INVOICE_PERIOD_END_ON |
DATE |
DATETIME |
|
INVOICE_PERIOD_START_ON |
DATE |
DATETIME |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
REVIEW_ACTION_DATE |
DATE |
DATETIME |
|
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
WH_HELPER_INVOLVED_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
INVOICE_PRIMARY_KEY |
NUMBER |
INT |
|
INVOLVED_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
INVOLVED_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
INVOLVED_PRIMARY_KEY |
NUMBER |
INT |
|
INVOLVED_CONTACT_PK |
NUMBER |
INT |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CONTACT_DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
|
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
ACTION_DATE |
DATE |
DATETIME |
|
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
STOP_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
WH_HELPER_INVOLVED_WKFL_RVW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
INVOLVED_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
INVOLVED_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
INVOLVED_PRIMARY_KEY |
NUMBER |
INT |
|
INVOLVED_CONTACT_PK |
NUMBER |
INT |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CONTACT_DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
REVIEW_ACTION_DATE |
DATE |
DATETIME |
|
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
WH_HELPER_MILESTONE_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
MILESTONE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
MILESTONE_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_PRIMARY_KEY |
NUMBER |
INT |
|
MILESTONE_SUBJECT |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_MILESTONE_DATE |
DATE |
DATETIME |
|
MILESTONE_STATUS |
VARCHAR2(10) |
VARCHAR(10) |
|
MILESTONE_COMPLETION_STATUS |
VARCHAR2(3) |
VARCHAR(3) |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
|
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
ACTION_DATE |
DATE |
DATETIME |
|
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
STOP_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
WH_HELPER_MILESTONE_WKFL_RVW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
MILESTONE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
MILESTONE_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_PRIMARY_KEY |
NUMBER |
INT |
|
MILESTONE_SUBJECT |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_MILESTONE_DATE |
DATE |
DATETIME |
|
MILESTONE_STATUS |
VARCHAR2(10) |
VARCHAR(10) |
|
MILESTONE_COMPLETION_STATUS |
VARCHAR2(3) |
VARCHAR(3) |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
REVIEW_ACTION_DATE |
DATE |
DATETIME |
|
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
WH_HELPER_PROJECT_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(100) |
VARCHAR(100) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
|
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
ACTION_DATE |
DATE |
DATETIME |
|
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
STOP_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
WH_HELPER_PROJECT_WORKFLOW_RVW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(100) |
VARCHAR(100) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
REVIEW_ACTION_DATE |
DATE |
DATETIME |
|
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
WH_HELPER_TASK_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
TASK_PRIMARY_KEY |
NUMBER |
INT |
|
TASK_SUBJECT |
VARCHAR2(250) |
VARCHAR(250) |
|
TASK_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
MILESTONE_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_PRIMARY_KEY |
NUMBER |
INT |
|
MILESTONE_SUBJECT |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_DATE |
DATE |
DATETIME |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
|
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
|
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
ACTION_DATE |
DATE |
DATETIME |
|
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
STOP_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY_EXTRA |
NUMBER |
INT |
WH_HELPER_TASK_WORKFLOW_RVW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|
|
TASK_PRIMARY_KEY |
NUMBER |
INT |
|
TASK_SUBJECT |
VARCHAR2(250) |
VARCHAR(250) |
|
TASK_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
|
MILESTONE_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_PRIMARY_KEY |
NUMBER |
INT |
|
MILESTONE_SUBJECT |
VARCHAR2(250) |
VARCHAR(250) |
|
MILESTONE_DATE |
DATE |
DATETIME |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
|
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REQUESTED_ON |
DATE |
DATETIME |
|
COMPLETED_ON |
DATE |
DATETIME |
|
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
|
EXPIRES_ON |
DATE |
DATETIME |
|
CURRENT_STOP_NO |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
|
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
STOP_PRIMARY_KEY |
NUMBER |
INT |
|
STOP |
NUMBER |
INT |
|
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
|
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
|
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
|
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
|
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
|
REVIEW_ACTION_DATE |
DATE |
DATETIME |
|
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_ON |
DATE |
DATETIME |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
|
MODIFIED_ON |
DATE |
DATETIME |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
WH_MAPPING
|
Column Name |
NULL TYPE |
Oracle Data Type |
MSSQL Data Type |
|---|---|---|---|
|
TABLE_NAME |
NOT NULL |
VARCHAR2(30) |
VARCHAR(30) |
|
COLUMN_NAME |
NOT NULL |
VARCHAR2(30) |
VARCHAR(30) |
|
SOURCE_TABLE |
VARCHAR2(30) |
VARCHAR(30) |
|
|
SOURCE_COLUMN |
VARCHAR2(30) |
VARCHAR(30) |
|
|
MAPPING |
NOT NULL |
VARCHAR2(30) |
VARCHAR(30) |