Skip to main content
Mitratech Success Center

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.

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)

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)

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)

  • Was this article helpful?