Skip to main content
Mitratech Success Center
Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

Helper Table Definitions

This guide provides an overview of the Helper Table Definitions and its Oracle and MSSQL data types.

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

Friendly Column Name

UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Unique Code

ENTITY_CODE

VARCHAR2(9)

VARCHAR(9)

Entity Code

OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Object Title

OBJECT_IS_EMBEDDED

VARCHAR2(5)

VARCHAR(5)

Object Is Embedded

CATEGORY_NAME

VARCHAR2(50)

VARCHAR(50)

Category Name

TREE_POSITION

VARCHAR2(250)

VARCHAR(250)

Tree Position

DETAIL_FIELD_TYPE

VARCHAR2(20)

VARCHAR(20)

Detail Field Type

ORIGINAL_FIELD_NAME

VARCHAR2(30)

VARCHAR(30)

Original Field Name

TABLE_NAME

VARCHAR2(30)

VARCHAR(30)

Table Name

TABLE_SEQ

NUMBER

INT

Table Seq

ID_COLUMN

VARCHAR2(30)

VARCHAR(30)

ID Column

FIELD_NAME

VARCHAR2(30)

VARCHAR(30)

Field Name

FIELD_LABEL

VARCHAR2(50)

VARCHAR(50)

Field Label

COLUMN_TYPE

VARCHAR2(40)

VARCHAR(40)

Column Type

FIELD_NAME_MAP

VARCHAR2(30)

VARCHAR(30)

Field Name Map

LOOKUP_TABLE_PRIMARY_KEY

NUMBER

INT

Lookup Table Primary Key

LOOKUP_TABLE_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Lookup Table Unique Code

LOOKUP_TABLE_NAME

VARCHAR2(50)

VARCHAR(50)

Lookup Table Name
IS_TCBI_DATA_MART NUMBER INT Is TCBI Data Smart

WH_CF_MAPPINGS

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Unique Code

ENTITY_CODE

VARCHAR2(9)

VARCHAR(9)

Entity Code

OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Object Title

OBJECT_IS_EMBEDDED

VARCHAR2(5)

VARCHAR(5)

Object Is Embedded

CATEGORY_NAME

VARCHAR2(50)

VARCHAR(50)

Category Name

TREE_POSITION

VARCHAR2(250)

VARCHAR(250)

Tree Position

DETAIL_FIELD_TYPE

VARCHAR2(20)

VARCHAR(20)

Detail Field Type

ORIGINAL_FIELD_NAME

VARCHAR2(30)

VARCHAR(30)

Original Field Name

TABLE_NAME

VARCHAR2(30)

VARCHAR(30)

Table Name

TABLE_SEQ

NUMBER

INT

Table Seq

ID_COLUMN

VARCHAR2(30)

VARCHAR(30)

Id Column

FIELD_NAME

VARCHAR2(30)

VARCHAR(30)

Field Name

FIELD_LABEL

VARCHAR2(50)

VARCHAR(50)

Field Label

COLUMN_TYPE

VARCHAR2(40)

VARCHAR(40)

Column Type

FIELD_NAME_MAP

VARCHAR2(30)

VARCHAR(30)

Field Name Map

LOOKUP_TABLE_PRIMARY_KEY

NUMBER

INT

Lookup Table Primary Key

LOOKUP_TABLE_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Lookup Table Unique Code

LOOKUP_TABLE_NAME

VARCHAR2(50)

VARCHAR(50)

Lookup Table Name
IS_TCBI_DATA_MART NUMBER INT Is TCBI Data Mart
IS_TIME_ZONE_INDEPENDENT VARCHAR2(5) VARCHAR(5) Is Time Zone Independent
INDEX_NAME VARCHAR2(30) VARCHAR(30) Index

WH_CUSTOM_DATE

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

VALUE_PK

NUMBER

INT

Value Primary Key

ENTITY_CODE

VARCHAR2(9)

VARCHAR(9)

Entity Code

DETAIL_VALUE

DATE

DATETIME

Detail Value

TABLE_NAME

VARCHAR2(30)

VARCHAR(30)

Table Name

COLUMN_NAME

VARCHAR2(30)

VARCHAR(30)

Column Name

OBJECT_ID

NUMBER

INT

Object ID

OBJECT_ID_NAME

VARCHAR2(30)

VARCHAR(30)

Object ID Name

WH_CUSTOM_MEMO

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

VALUE_PK

NUMBER

INT

Value Primary Key

ENTITY_CODE

VARCHAR2(9)

VARCHAR(9)

Entity Code

DETAIL_VALUE

CLOB

NTEXT

Detail Value

TABLE_NAME

VARCHAR2(30)

VARCHAR(30)

Table Name

COLUMN_NAME

VARCHAR2(30)

VARCHAR(30)

Column Name

OBJECT_ID

NUMBER

INT

Object ID

OBJECT_ID_NAME

VARCHAR2(30)

VARCHAR(30)

Object ID Name

WH_CUSTOM_NUMB

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

VALUE_PK

NUMBER

INT

Value Primary Key

ENTITY_CODE

VARCHAR2(9)

VARCHAR(9)

Entity Code

DETAIL_VALUE

NUMBER

INT

Detail Value

TABLE_NAME

VARCHAR2(30)

VARCHAR(30)

Table Name

COLUMN_NAME

VARCHAR2(30)

VARCHAR(30)

Column Name

OBJECT_ID

NUMBER

INT

Object ID

OBJECT_ID_NAME

VARCHAR2(30)

VARCHAR(30)

Object ID Name

WH_CUSTOM_OBJE

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

VALUE_PK

NUMBER

INT

Value Primary Key

ENTITY_CODE

VARCHAR2(9)

VARCHAR(9)

Entity Code

DETAIL_VALUE

VARCHAR2(700)

VARCHAR(700)

Detail Value

TABLE_NAME

VARCHAR2(30)

VARCHAR(30)

Table Name

COLUMN_NAME

VARCHAR2(30)

VARCHAR(30)

Column Name

OBJECT_ID

NUMBER

INT

Object ID

OBJECT_ID_NAME

VARCHAR2(30)

VARCHAR(30)

Object ID Name

WH_CUSTOM_OBJF

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

VALUE_PK

NUMBER

INT

Value Primary Key

ENTITY_CODE

VARCHAR2(9)

VARCHAR(9)

Entity Code

DETAIL_VALUE_FID

NUMBER

INT

Detail Value Fid

TABLE_NAME

VARCHAR2(30)

VARCHAR(30)

Table Name

COLUMN_NAME

VARCHAR2(30)

VARCHAR(30)

Column Name

OBJECT_ID

NUMBER

INT

Object ID

OBJECT_ID_NAME

VARCHAR2(30)

VARCHAR(30)

Object ID Name

WH_CUSTOM_TEXT

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

VALUE_PK

NUMBER

INT

Value Primary Key

ENTITY_CODE

VARCHAR2(9)

VARCHAR(9)

Entity Code

DETAIL_VALUE

VARCHAR2(2000)

VARCHAR(2000)

Detail Value

TABLE_NAME

VARCHAR2(30)

VARCHAR(30)

Table Name

COLUMN_NAME

VARCHAR2(30)

VARCHAR(30)

Column Name

OBJECT_ID

NUMBER

INT

Object ID

OBJECT_ID_NAME

VARCHAR2(30)

VARCHAR(30)

Object ID Name

WH_HELPER_CONTACT

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

CONTACT_PK

NUMBER

INT

Contact Primary Key

CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Contact Name

CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Contact Middle Name

CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Contact First Name
CONTACT_LAST_FIRST__MID_NAME VARCHAR2(250) VARCHAR(250) Contact Last First Middle Name

CONTACT_TYPE

VARCHAR2(10)

VARCHAR(10)

Contact Type

CONTACT_DEFAULT_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Contact Default Category

CONTACT_DEFAULT_CATEGORY_TREE

VARCHAR2(250)

VARCHAR(250)

Contact Default Category Tree

WH_HELPER_CONTACT_RELATIONS

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

LEFT_CONTACT_PRIMARY_KEY

NUMBER

INT

Left Contact Primary Key

LEFT_CONTACT_TYPE

VARCHAR2(10)

VARCHAR(10)

Left Contact Type

LEFT_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Left Contact First Name

LEFT_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Left Contact Middle Name

LEFT_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Left Contact Name

RELATION_NAME

VARCHAR2(50)

VARCHAR(50)

Relation Name

RELATION_TREE_POSITION

VARCHAR2(250)

VARCHAR(250)

Relation Tree Position

RIGHT_CONTACT_PRIMARY_KEY

NUMBER

INT

Right Contact Primary Key

RIGHT_CONTACT_TYPE

VARCHAR2(10)

VARCHAR(10)

Right Contact Type

RIGHT_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Right Contact First Name

RIGHT_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Right Contact Middle Name

RIGHT_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Right Contact Name

WH_HELPER_PROJECT

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

PROJECT_PK

NUMBER

INT

Project Primary Key

OBJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Object Unique Code

OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Object Title

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

DEFAULT_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Default Category

DEFAULT_CATEGORY_TREE

VARCHAR2(250)

VARCHAR(250)

Default Category Tree

CURRENT_PHASE

VARCHAR2(250)

VARCHAR(250)

Current Phase

CURRENT_PHASE_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Current Phase Unique Code

WH_HELPER_PROJECT_RELATIONS

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

LEFT_OBJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Left Object Unique Code

LEFT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Left Object Title

LEFT_PROJECT_PRIMARY_KEY

NUMBER

INT

Left Project Primary Key

LEFT_PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Left Project Number

LEFT_PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Left Project Name

RELATION_NAME

VARCHAR2(50)

VARCHAR(50)

Relation Name

RELATION_TREE_POSITION

VARCHAR2(250)

VARCHAR(250)

Relation Tree Position

RIGHT_OBJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Right Object Unique Code

RIGHT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Right Object Title

RIGHT_PROJECT_PRIMARY_KEY

NUMBER

INT

Right Project Primary Key

RIGHT_PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Right Project Number

RIGHT_PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Right Project Name

WH_HELPER_INVOLVED_RELATIONS

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

LEFT_INVOLVED_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Left Involved Unique Code

LEFT_INVOLVED_TITLE

VARCHAR2(250)

VARCHAR(250)

Left Involved Title
LEFT_INVOLVED_PRIMARY_KEY NUMBER INT Left Involved Primary Key
LEFT_INVOLVED_DEFAULT_ROLE VARCHAR2(50) VARCHAR(50) Left Involved Default Role
LEFT_INVOLVED_ROLE_TREE VARCHAR2(250) VARCHAR(250) Left Involved Role Tree
LEFT_PROJECT_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Left Project Unique Code
LEFT_PROJECT_TITLE VARCHAR2(250) VARCHAR(250) Left Project Title

LEFT_PROJECT_PRIMARY_KEY

NUMBER

INT

Left Project Primary Key

LEFT_PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Left Project Number

LEFT_PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Left Project Name
LEFT_CONTACT_PRIMARY_KEY NUMBER INT Left Contact Primary Key
LEFT_CONTACT_FIRST_NAME VARCHAR2(50) VARCHAR(50) Left Contact First Name
LEFT_CONTACT_MIDDLE_NAME VARCHAR2(50) VARCHAR(50) Left Contact Middle Name
LEFT_CONTACT_NAME VARCHAR2(250) VARCHAR(250) Left Contact Name
LEFT_CONTACT_TYPE VARCHAR2(10) VARCHAR(10) Left Contact Type

RELATION_NAME

VARCHAR2(50)

VARCHAR(50)

Relation Name

RELATION_TREE_POSITION

VARCHAR2(250)

VARCHAR(250)

Relation Tree Position

RIGHT_INVOLVED_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Right Involved Unique Code

RIGHT_INVOLVED_TITLE

VARCHAR2(250)

VARCHAR(250)

Right Involved Title
RIGHT_INVOLVED_PRIMARY_KEY NUMBER INT Right Involved Primary Key
RIGHT_INVOLVED_DEFAULT_ROLE VARCHAR2(50) VARCHAR(50) Right Involved Default Role
RIGHT_INVOLVED_ROLE_TREE VARCHAR2(250) VARCHAR(250) Right Involved Role Tree
RIGHT_PROJECT_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Right Project Unique Code
RIGHT_PROJECT_TITLE VARCHAR2(250) VARCHAR(250) Right Project Title 

RIGHT_PROJECT_PRIMARY_KEY

NUMBER

INT

Right Project Primary Key

RIGHT_PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Right Project Number

RIGHT_PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Right Project Name
RIGHT_CONTACT_PRIMARY_KEY NUMBER INT Right Contact Primary Key
RIGHT_CONTACT_FIRST_NAME VARCHAR2(50) VARCHAR(50) Right Contact First Name 
RIGHT_CONTACT_MIDDLE_NAME VARCHAR2(50) VARCHAR(50) Right Contact Middle Name
RIGHT_CONTACT_NAME VARCHAR2(250) VARCHAR(250) Right Contact Name
RIGHT_CONTACT_TYPE VARCHAR2(10) VARCHAR(10)  Right Contact Type

WH_LAST_REFRESH

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

ENTITY_CODE

VARCHAR2(9)

VARCHAR(9)

Entity Code

LAST_REFRESH_DATE

DATE

DATETIME

Last Refresh Date

LAST_REFRESH_SYSTEM_DATE

DATE

DATETIME

Last Refresh System Date

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

Friendly Column Name

ENTITY_CODE

VARCHAR2(4)

VARCHAR(4)

Entity Code

APPLICATION_ID

NUMBER

INT

Application ID

PRIMARY_KEY

NUMBER

INT

Primary Key

MODIFIED_ON

DATE

DATETIME

Modified On

REMOVED_ON

DATE

DATETIME

Removed On

WH_VERSION

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

VERSION_PRIMARY_KEY

NUMBER

INT

Version Primary Key

UPGRADE_DATE

DATE

DATETIME

Upgrade Date

VERSION

VARCHAR2(50)

VARCHAR(50)

Version

PRODUCT_NAME

VARCHAR2(250)

VARCHAR(250)

Product Name

DESCRIPTION

VARCHAR2(250)

VARCHAR(250)

Description

WH_HELPER_ACCOUNT_WORKFLOW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

ACCOUNT_PRIMARY_KEY

NUMBER

INT

Account Primary Key

ACCOUNT_NAME

VARCHAR2(250)

VARCHAR2(250)

Account Name

ACCOUNT_TYPE

VARCHAR2(7)

VARCHAR2(7)

Account Type

ACCOUNT_OVERDRAFT_TYPE

VARCHAR2(30)

VARCHAR2(30)

Account Overdraft Type

ACCOUNT_PERIOD_START_ON_DATE

DATE

DATETIME

Account Period Start On Date

ACCOUNT_PERIOD_END_ON_DATE

DATE

DATETIME

Account Period End On Date

ACCOUNT_STATUS

VARCHAR2(8)

VARCHAR2(8)

Account Status

ACCOUNT_ALLOW_POSTING

VARCHAR2(1)

VARCHAR2(1)

Account Allow Posting

ACCOUNT_ALLOCATION_LIMIT

NUMBER(28,12)

DECIMAL(28,12)

Account Allocation Limit

ACCOUNT_TOTAL_ALLOCATED

NUMBER(28,12)

DECIMAL(28,12)

Account Total Allocated

ACCOUNT_TOTAL_USED

NUMBER(28,12)

DECIMAL(28,12)

Account Total Used

ACCOUNT_BALANCE

NUMBER(28,12)

DECIMAL(28,12)

Account Balance

PARENT_ACCOUNT_PRIMARY_KEY

NUMBER

INT

Parent Account Primary Key

PARENT_ACCOUNT_NAME

VARCHAR2(250)

VARCHAR2(250)

Parent Account Name

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR2(50)

Request Name

RULE_SHORT_DESCRIPTION

VARCHAR2(250)

VARCHAR2(250)

Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR2(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR2(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR2(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR2(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR2(30)

Workflow Status

COMMENT_TO_REQUESTOR

VARCHAR2(2000)

VARCHAR(2000)

Comment To Requestor

EXPIRES_ON

DATE

DATETIME

Expires On

EXPIRE_ACTION

VARCHAR2(30)

VARCHAR2(30)

Expire Action

TRANSACTION_STATUS

VARCHAR2(250)

VARCHAR2(250)

Transaction Status

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

REJECT_ACTION

VARCHAR2(30)

VARCHAR2(30)

Reject Action

REJECT_REASON

VARCHAR2(50)

VARCHAR2(50)

Reject Reason

UPDATE_WHILE_PENDING

VARCHAR2(105)

VARCHAR2(105)

Update While Pending

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR2(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR2(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR2(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR2(250)

Process Manager Name

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

PERFORMER_CONTACT_PK

NUMBER

INT

Performer Contact Primary Key

PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR2(7)

Performer Contact Type

PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR2(50)

Performer First Name

PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR2(50)

Performer Middle Name

PERFORMER_NAME

VARCHAR2(250)

VARCHAR2(250)

Performer Name

STOP_STATUS

VARCHAR2(40)

VARCHAR2(40)

Stop Status

ACTION_DATE

DATE

DATETIME

Action Date

STOP_EXPIRATION_DATE

DATE

DATETIME

Stop Expiration Date

INTERNAL_COMMENT

VARCHAR2(2000)

VARCHAR2(2000)

Internal Comment

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

CREATED_ON

DATE

DATETIME

Created On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_ON

DATE

DATETIME

Modified On

STOP_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Primary Key Extra

STOP_MEMBER_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Member Primary Key Extra

WH_HELPER_ACCOUNT_WORKFLOW_RVW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

ACCOUNT_PRIMARY_KEY

NUMBER

INT

Account Primary Key

ACCOUNT_NAME

VARCHAR2(250)

VARCHAR(250)

Account Name

ACCOUNT_TYPE

VARCHAR2(7)

VARCHAR(7)

Account Type

ACCOUNT_OVERDRAFT_TYPE

VARCHAR2(30)

VARCHAR(30)

Account Overdraft Type

ACCOUNT_PERIOD_START_ON_DATE

DATE

DATETIME

Account Period Start On Date

ACCOUNT_PERIOD_END_ON_DATE

DATE

DATETIME

Account Period End On Date

ACCOUNT_STATUS

VARCHAR2(8)

VARCHAR(8)

Account Status

ACCOUNT_ALLOW_POSTING

VARCHAR2(1)

VARCHAR(1)

Account Allow Posting

ACCOUNT_ALLOCATION_LIMIT

NUMBER(28,12)

DECIMAL(28,12)

Account Allocation Limit

ACCOUNT_TOTAL_ALLOCATED

NUMBER(28,12)

DECIMAL(28,12)

Account Total Allocated

ACCOUNT_TOTAL_USED

NUMBER(28,12)

DECIMAL(28,12)

Account Total Used

ACCOUNT_BALANCE

NUMBER(28,12)

DECIMAL(28,12)

Account Balance

PARENT_ACCOUNT_PRIMARY_KEY

NUMBER

INT

Parent Account Primary Key

PARENT_ACCOUNT_NAME

VARCHAR2(250)

VARCHAR(250)

Parent Account Name

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name

RULE_SHORT_DESCRIPTION

VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

EXPIRES_ON

DATE

DATETIME

Expires On

CURRENT_STOP_NO

NUMBER

INT

Current Stop No

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

REVIEW_PRIMARY_KEY

NUMBER

INT

Review Primary Key

REVIEW_PERFORMER_CONTACT_PK

NUMBER

INT

Review Performer Contact Primary Key

REVIEW_PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Review Performer Contact Type

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer First Name

REVIEW_PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer Middle Name

REVIEW_PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Review Performer Name

REVIEW_STATUS

VARCHAR2(20)

VARCHAR(20)

Review Status

REVIEW_ACTION_DATE

DATE

DATETIME

Review Action Date

REVIEW_APPROVAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Approval Comment

REVIEW_REQUEST_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Request Comment

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

WH_HELPER_APPOINTMENT_WORKFLOW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

APPOINTMENT_PRIMARY_KEY

NUMBER

INT

Appointment Primary Key

APPOINTMENT_SUBJECT

VARCHAR2(250)

VARCHAR2(250)

Appointment Subject

APPOINTMENT_LOCATION

VARCHAR2(250)

VARCHAR2(250)

Appointment Location

APPOINTMENT_AREA

VARCHAR2(50)

VARCHAR2(50)

Appointment Area

APPOINTMENT_START_ON

DATE

DATETIME

Appointment Start On

APPOINTMENT_END_ON

DATE

DATETIME

Appointment End On

APPOINTMENT_IS_ALL_DAY

VARCHAR2(1)

VARCHAR2(1)

Appointment Is All Day

APPOINTMENT_DEFAULT_CATEGORY

VARCHAR2(50)

VARCHAR2(50)

Appointment Default Category

APPOINTMENT_DEFAULT_CAT_TREE

VARCHAR2(250)

VARCHAR(250)

Appointment Default Cat Tree

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_DEFAULT_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Project Default Category

MILESTONE_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Milestone Unique Code

MILESTONE_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Milestone Object Title

MILESTONE_PRIMARY_KEY

NUMBER

INT

Milestone Primary Key

MILESTONE_SUBJECT

VARCHAR2(250)

VARCHAR(250)

Milestone Subject

MILESTONE_DATE

DATE

DATETIME

Milestone Date

MILESTONE_DEFAULT_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Milestone Default Category

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name

RULE_SHORT_DESCRIPTION

VARCHAR2(250) VARCHAR2(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

COMMENT_TO_REQUESTOR

VARCHAR2(2000)

VARCHAR(2000)

Comment To Requestor

EXPIRES_ON

DATE

DATETIME

Expires On

EXPIRE_ACTION

VARCHAR2(30)

VARCHAR(30)

Expire Action

TRANSACTION_STATUS

VARCHAR2(250)

VARCHAR(250)

Transaction Status

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

REJECT_ACTION

VARCHAR2(30)

VARCHAR(30)

Reject Action

REJECT_REASON

VARCHAR2(50)

VARCHAR(50)

Reject Reason

UPDATE_WHILE_PENDING

VARCHAR2(105)

VARCHAR(105)

Update While Pending

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

PERFORMER_CONTACT_PK

NUMBER

INT

Performer Contact Primary Key

PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Performer Contact Type

PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Performer First Name

PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Performer Middle Name

PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Performer Name

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

ACTION_DATE

DATE

DATETIME

Action Date

STOP_EXPIRATION_DATE

DATE

DATETIME

Stop Expiration Date

INTERNAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Internal Comment

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

CREATED_ON

DATE

DATETIME

Created On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_ON

DATE

DATETIME

Modified On

STOP_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Primary Key Extra

STOP_MEMBER_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Member Primary Key Extra

WH_HELPER_APPOINTMENT_WKFL_RVW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

APPOINTMENT_PRIMARY_KEY

NUMBER

INT

Appointment Primary Key

APPOINTMENT_SUBJECT

VARCHAR2(250)

VARCHAR(250)

Appointment Subject

APPOINTMENT_LOCATION

VARCHAR2(250)

VARCHAR(250)

Appointment Location

APPOINTMENT_AREA

VARCHAR2(50)

VARCHAR(50)

Appointment Area

APPOINTMENT_START_ON

DATE

DATETIME

Appointment Start On

APPOINTMENT_END_ON

DATE

DATETIME

Appointment End On

APPOINTMENT_IS_ALL_DAY

VARCHAR2(1)

VARCHAR(1)

Appointment Is All Day

APPOINTMENT_DEFAULT_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Appointment Default Category

APPOINTMENT_DEFAULT_CAT_TREE

VARCHAR2(250)

VARCHAR(250)

Appointment Default Cat Tree

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_DEFAULT_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Project Default Category

MILESTONE_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Milestone Unique Code

MILESTONE_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Milestone Object Title

MILESTONE_PRIMARY_KEY

NUMBER

INT

Milestone Primary Key

MILESTONE_SUBJECT

VARCHAR2(250)

VARCHAR(250)

Milestone Subject

MILESTONE_DATE

DATE

DATETIME

Milestone Date

MILESTONE_DEFAULT_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Milestone Default Category

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR2(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

EXPIRES_ON

DATE

DATETIME

Expires On

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

REVIEW_PRIMARY_KEY

NUMBER

INT

Review Primary Key

REVIEW_PERFORMER_CONTACT_PK

NUMBER

INT

Review Performer Contact Primary Key

REVIEW_PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Review Performer Contact Type

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer First Name

REVIEW_PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer Middle Name

REVIEW_PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Review Performer Name

REVIEW_STATUS

VARCHAR2(20)

VARCHAR(20)

Review Status

REVIEW_ACTION_DATE

DATE

DATETIME

Review Action Date

REVIEW_APPROVAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Approval Comment

REVIEW_REQUEST_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Request Comment

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Mid Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

WH_HELPER_CONTACT_WORKFLOW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

CONTACT_PRIMARY_KEY

NUMBER

INT

Contact Primary Key

CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Contact Type

CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Contact First Name

CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Contact Middle Name

CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Contact Name

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

COMMENT_TO_REQUESTOR

VARCHAR2(2000)

VARCHAR(2000)

Comment To Requestor

EXPIRES_ON

DATE

DATETIME

Expires On

EXPIRE_ACTION

VARCHAR2(30)

VARCHAR(30)

Expire Action

TRANSACTION_STATUS

VARCHAR2(250)

VARCHAR(250)

Transaction Status

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

REJECT_ACTION

VARCHAR2(30)

VARCHAR(30)

Reject Action

REJECT_REASON

VARCHAR2(50)

VARCHAR(50)

Reject Reason

UPDATE_WHILE_PENDING

VARCHAR2(105)

VARCHAR(105)

Update While Pending

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

PERFORMER_CONTACT_PK

NUMBER

INT

Performer Contact Primary Key

PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Performer Contact Type

PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Performer First Name

PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Performer Middle Name

PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Performer Name

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

ACTION_DATE

DATE

DATETIME

Action Date

STOP_EXPIRATION_DATE

DATE

DATETIME

Stop Expiration Date

INTERNAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Internal Comment

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

CREATED_ON

DATE

DATETIME

Created On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_ON

DATE

DATETIME

Modified On

STOP_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Primary Key Extra

STOP_MEMBER_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Member Primary Key Extra

WH_HELPER_CONTACT_WORKFLOW_RVW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

CONTACT_PRIMARY_KEY

NUMBER

INT

Contact Primary Key

CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Contact Type

CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Contact Middle Name

CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Contact First Name

CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Contact Name

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

EXPIRES_ON

DATE

DATETIME

Expires On

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

REVIEW_PRIMARY_KEY

NUMBER

INT

Review Primary Key

REVIEW_PERFORMER_CONTACT_PK

NUMBER

INT

Review Performer Contact Primary Key

REVIEW_PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Review Performer Contact Type

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer First Name

REVIEW_PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer Middle Name

REVIEW_PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Review Performer Name

REVIEW_STATUS

VARCHAR2(20)

VARCHAR(20)

Review Status

REVIEW_ACTION_DATE

DATE

DATETIME

Review Action Date

REVIEW_APPROVAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Approval Comment

REVIEW_REQUEST_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Request Comment

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

WH_HELPER_DOCUMENT_WORKFLOW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

DOCUMENT_PRIMARY_KEY

NUMBER

INT

Document Primary Key

DOCUMENT_NAME

VARCHAR2(250)

VARCHAR(250)

Document Name

DOCUMENT_TREE_KEY

VARCHAR2(700)

VARCHAR(700)

Document Tree Key

DOCUMENT_FILE_TYPE

VARCHAR2(50)

VARCHAR(50)

Document File Type

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

COMMENT_TO_REQUESTOR

VARCHAR2(2000)

VARCHAR(2000)

Comment To Requestor

EXPIRES_ON

DATE

DATETIME

Expires On

EXPIRE_ACTION

VARCHAR2(30)

VARCHAR(30)

Expire Action

TRANSACTION_STATUS

VARCHAR2(250)

VARCHAR(250)

Transaction Status

CURRENT_STOP_NO

NUMBER

INT

Current Stop No

REJECT_ACTION

VARCHAR2(30)

VARCHAR(30)

Reject Action

REJECT_REASON

VARCHAR2(50)

VARCHAR(50)

Reject Reason

UPDATE_WHILE_PENDING

VARCHAR2(105)

VARCHAR(105)

Update While Pending

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

PERFORMER_CONTACT_PK

NUMBER

INT

Performer Contact Primary Key

PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Performer Contact Type

PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Performer First Name

PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Performer Middle Name

PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Performer Name

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

ACTION_DATE

DATE

DATETIME

Action Date

STOP_EXPIRATION_DATE

DATE

DATETIME

Stop Expiration Date

INTERNAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Internal Comment

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

CREATED_ON

DATE

DATETIME

Created On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_ON

DATE

DATETIME

Modified On

STOP_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Primary Key Extra

STOP_MEMBER_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Member Primary Key Extra

WH_HELPER_DOCUMENT_WKFL_RVW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

DOCUMENT_PRIMARY_KEY

NUMBER

INT

Document Primary Key

DOCUMENT_NAME

VARCHAR2(250)

VARCHAR(250)

Document Name

DOCUMENT_TREE_KEY

VARCHAR2(700)

VARCHAR(700)

Document Tree Key

DOCUMENT_FILE_TYPE

VARCHAR2(50)

VARCHAR(50)

Document File Type

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

EXPIRES_ON

DATE

DATETIME

Expires On

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

REVIEW_PRIMARY_KEY

NUMBER

INT

Review Primary Key

REVIEW_PERFORMER_CONTACT_PK

NUMBER

INT

Review Performer Contact Primary Key

REVIEW_PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Review Performer Contact Type

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer First Name

REVIEW_PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer Middle Name

REVIEW_PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Review Performer Name

REVIEW_STATUS

VARCHAR2(20)

VARCHAR(20)

Review Status

REVIEW_ACTION_DATE

DATE

DATETIME

Review Action Date

REVIEW_APPROVAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Approval Comment

REVIEW_REQUEST_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Request Comment

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

WH_HELPER_EXPENSE_WORKFLOW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

EXPENSE_PRIMARY_KEY

NUMBER

INT

Expense Primary Key

EXPENSE_DATE

DATE

DATETIME

Expense Date

EXPENSE_DESCRIPTION

VARCHAR2(250)

VARCHAR(250)

Expense Description

EXPENSE_POSTING_STATUS

VARCHAR2(19)

VARCHAR(19)

Expense Posting Status

EXPENSED_BY_CONTACT_PK

NUMBER

INT

Expensed By Contact Primary Key

EXPENSED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Expensed By First Name

EXPENSED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Expensed By Name

EXPENSED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Expensed By Middle Name

EXPENSED_BY_TYPE

VARCHAR2(7)

VARCHAR(7)

Expensed By Type

EXPENSE_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Expense Category

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

COMMENT_TO_REQUESTOR

VARCHAR2(2000)

VARCHAR(2000)

Comment To Requestor

EXPIRES_ON

DATE

DATETIME

Expires On

EXPIRE_ACTION

VARCHAR2(30)

VARCHAR(30)

Expire Action

TRANSACTION_STATUS

VARCHAR2(250)

VARCHAR(250)

Transaction Status

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

REJECT_ACTION

VARCHAR2(30)

VARCHAR(30)

Reject Action

REJECT_REASON

VARCHAR2(50)

VARCHAR(50)

Reject Reason

UPDATE_WHILE_PENDING

VARCHAR2(105)

VARCHAR(105)

Update While Pending

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

PERFORMER_CONTACT_PK

NUMBER

INT

Performer Contact Primary Key

PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Performer Contact Type

PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Performer First Name

PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Performer Middle Name

PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Performer Name

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

ACTION_DATE

DATE

DATETIME

Action Date

STOP_EXPIRATION_DATE

DATE

DATETIME

Stop Expiration Date

INTERNAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Internal Comment

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

CREATED_ON

DATE

DATETIME

Created On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Mid Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_ON

DATE

DATETIME

Modified On

STOP_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Primary Key Extra

STOP_MEMBER_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Member Primary Key Extra

WH_HELPER_EXPENSE_WORKFLOW_RVW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

EXPENSE_PRIMARY_KEY

NUMBER

INT

Expense Primary Key

EXPENSE_DATE

DATE

DATETIME

Expense Date

EXPENSE_DESCRIPTION

VARCHAR2(250)

VARCHAR(250)

Expense Description

EXPENSE_POSTING_STATUS

VARCHAR2(19)

VARCHAR(19)

Expense Posting Status

EXPENSED_BY_CONTACT_PK

NUMBER

INT

Expensed By Contact Primary Key

EXPENSED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Expensed By First Name

EXPENSED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Expensed By Name

EXPENSED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Expensed By Middle Name

EXPENSED_BY_TYPE

VARCHAR2(7)

VARCHAR(7)

Expensed By Type

EXPENSE_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Expense Category

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

EXPIRES_ON

DATE

DATETIME

Expires On

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

REVIEW_PRIMARY_KEY

NUMBER

INT

Review Primary Key

REVIEW_PERFORMER_CONTACT_PK

NUMBER

INT

Review Performer Contact Primary Key

REVIEW_PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Review Performer Contact Type

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer First Name

REVIEW_PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer Middle Name

REVIEW_PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Review Performer Name

REVIEW_STATUS

VARCHAR2(20)

VARCHAR(20)

Review Status

REVIEW_ACTION_DATE

DATE

DATETIME

Review Action Date

REVIEW_APPROVAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Approval Comment

REVIEW_REQUEST_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Request Comment

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

WH_HELPER_HISTORY_WORKFLOW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

HISTORY_PRIMARY_KEY

NUMBER

INT

History Primary Key

HISTORY_DATE

DATE

DATETIME

History Date

HISTORY_DESCRIPTION

VARCHAR2(250)

VARCHAR(250)

History Description

PARENT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Parent Unique Code

HISTORY_PARENT_TYPE

VARCHAR2(17)

VARCHAR(17)

History Parent Type

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

COMMENT_TO_REQUESTOR

VARCHAR2(2000)

VARCHAR(2000)

Comment To Requestor

EXPIRES_ON

DATE

DATETIME

Expires On

EXPIRE_ACTION

VARCHAR2(30)

VARCHAR(30)

Expire Action

TRANSACTION_STATUS

VARCHAR2(250)

VARCHAR(250)

Transaction Status

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

REJECT_ACTION

VARCHAR2(30)

VARCHAR(30)

Reject Action

REJECT_REASON

VARCHAR2(50)

VARCHAR(50)

Reject Reason

UPDATE_WHILE_PENDING

VARCHAR2(105)

VARCHAR(105)

Update While Pending

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

PERFORMER_CONTACT_PK

NUMBER

INT

Performer Contact Primary Key

PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Performer Contact Type

PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Performer First Name

PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Performer Middle Name

PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Performer Name

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

ACTION_DATE

DATE

DATETIME

Action Date

STOP_EXPIRATION_DATE

DATE

DATETIME

Stop Expiration Date

INTERNAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Internal Comment

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

CREATED_ON

DATE

DATETIME

Created On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_ON

DATE

DATETIME

Modified On

STOP_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Primary Key Extra

STOP_MEMBER_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Member Primary Key Extra

WH_HELPER_HISTORY_WORKFLOW_RVW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

HISTORY_PRIMARY_KEY

NUMBER

INT

History Primary Key

HISTORY_DATE

DATE

DATETIME

History Date

HISTORY_DESCRIPTION

VARCHAR2(250)

VARCHAR(250)

History Description

PARENT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Parent Unique Code

HISTORY_PARENT_TYPE

VARCHAR2(17)

VARCHAR(17)

History Parent Type

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

EXPIRES_ON

DATE

DATETIME

Expires On

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

REVIEW_PRIMARY_KEY

NUMBER

INT

Review Primary Key

REVIEW_PERFORMER_CONTACT_PK

NUMBER

INT

Review Performer Contact Primary Key

REVIEW_PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Review Performer Contact Type

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer First Name

REVIEW_PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer Middle Name

REVIEW_PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Review Performer Name

REVIEW_STATUS

VARCHAR2(20)

VARCHAR(20)

Review Status

REVIEW_ACTION_DATE

DATE

DATETIME

Review Action Date

REVIEW_APPROVAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Approval Comment

REVIEW_REQUEST_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Request Comment

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

WH_HELPER_INVOICE_WORKFLOW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

INVOICE_PRIMARY_KEY

NUMBER

INT

Invoice Primary Key

INVOICE_NUMBER

VARCHAR2(50)

VARCHAR(50)

Invoice Number

INVOICE_DATE

DATE

DATETIME

Invoice Date

INVOICE_RECEIVED_DATE

DATE

DATETIME

Invoice Received Date

INVOICE_PERIOD_END_ON

DATE

DATETIME

Invoice Period End On

INVOICE_PERIOD_START_ON

DATE

DATETIME

Invoice Period Start On

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

COMMENT_TO_REQUESTOR

VARCHAR2(2000)

VARCHAR(2000)

Comment To Requestor

EXPIRES_ON

DATE

DATETIME

Expires On

EXPIRE_ACTION

VARCHAR2(30)

VARCHAR(30)

Expire Action

TRANSACTION_STATUS

VARCHAR2(250)

VARCHAR(250)

Transaction Status

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

REJECT_ACTION

VARCHAR2(30)

VARCHAR(30)

Reject Action

REJECT_REASON

VARCHAR2(50)

VARCHAR(50)

Reject Reason

UPDATE_WHILE_PENDING

VARCHAR2(105)

VARCHAR(105)

Update While Pending

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

PERFORMER_CONTACT_PK

NUMBER

INT

Performer Contact Pk

PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Performer Contact Type

PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Performer First Name

PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Performer Middle Name

PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Performer Name

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

ACTION_DATE

DATE

DATETIME

Action Date

STOP_EXPIRATION_DATE

DATE

DATETIME

Stop Expiration Date

INTERNAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Internal Comment

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

CREATED_ON

DATE

DATETIME

Created On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_ON

DATE

DATETIME

Modified On

STOP_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Primary Key Extra

STOP_MEMBER_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Member Primary Key Extra

WH_HELPER_INVOICE_WORKFLOW_RVW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

INVOICE_PRIMARY_KEY

NUMBER

INT

Invoice Primary Key

INVOICE_NUMBER

VARCHAR2(50)

VARCHAR(50)

Invoice Number

INVOICE_DATE

DATE

DATETIME

Invoice Date

INVOICE_RECEIVED_DATE

DATE

DATETIME

Invoice Received Date

INVOICE_PERIOD_END_ON

DATE

DATETIME

Invoice Period End On

INVOICE_PERIOD_START_ON

DATE

DATETIME

Invoice Period Start On

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

EXPIRES_ON

DATE

DATETIME

Expires On

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

REVIEW_PRIMARY_KEY

NUMBER

INT

Review Primary Key

REVIEW_PERFORMER_CONTACT_PK

NUMBER

INT

Review Performer Contact Primary Key

REVIEW_PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Review Performer Contact Type

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer First Name

REVIEW_PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer Middle Name

REVIEW_PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Review Performer Name

REVIEW_STATUS

VARCHAR2(20)

VARCHAR(20)

Review Status

REVIEW_ACTION_DATE

DATE

DATETIME

Review Action Date

REVIEW_APPROVAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Approval Comment

REVIEW_REQUEST_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Request Comment

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

WH_HELPER_INVOLVED_WORKFLOW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

INVOICE_PRIMARY_KEY

NUMBER

INT

Invoice Primary Key

INVOLVED_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Involved Unique Code

INVOLVED_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Involved Object Title

INVOLVED_PRIMARY_KEY

NUMBER

INT

Involved Primary Key

INVOLVED_CONTACT_PK

NUMBER

INT

Involved Contact Primary Key

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Contact First Name

CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Contact Middle Name

CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Contact Name

CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Contact Type

CONTACT_DEFAULT_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Contact Default Category

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(20)

VARCHAR(20)

Workflow Status

COMMENT_TO_REQUESTOR

VARCHAR2(2000)

VARCHAR(2000)

Comment To Requestor

EXPIRES_ON

DATE

DATETIME

Expires On

EXPIRE_ACTION

VARCHAR2(30)

VARCHAR(30)

Expire Action

TRANSACTION_STATUS

VARCHAR2(250)

VARCHAR(250)

Transaction Status

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

REJECT_ACTION

VARCHAR2(30)

VARCHAR(30)

Reject Action

REJECT_REASON

VARCHAR2(50)

VARCHAR(50)

Reject Reason

UPDATE_WHILE_PENDING

VARCHAR2(105)

VARCHAR(105)

Update While Pending

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

PERFORMER_CONTACT_PK

NUMBER

INT

Performer Contact Primary Key

PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Performer Contact Type

PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Performer First Name

PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Performer Middle Name

PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Performer Name

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

ACTION_DATE

DATE

DATETIME

Action Date

STOP_EXPIRATION_DATE

DATE

DATETIME

Stop Expiration Date

INTERNAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Internal Comment

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

CREATED_ON

DATE

DATETIME

Created On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_ON

DATE

DATETIME

Modified On

STOP_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Primary Key Extra

STOP_MEMBER_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Member Primary Key Extra

WH_HELPER_INVOLVED_WKFL_RVW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

INVOLVED_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Involved Unique Code

INVOLVED_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Involved Object Title

INVOLVED_PRIMARY_KEY

NUMBER

INT

Involved Primary Key

INVOLVED_CONTACT_PK

NUMBER

INT

Involved Contact Primary Key

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Contact First Name

CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Contact Middle Name

CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Contact Name

CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Contact Type

CONTACT_DEFAULT_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Contact Default Category

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(20)

VARCHAR(20)

Workflow Status

EXPIRES_ON

DATE

DATETIME

Expires On

CURRENT_STOP_NO

NUMBER

INT

Current Stop No

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

REVIEW_PRIMARY_KEY

NUMBER

INT

Review Primary Key

REVIEW_PERFORMER_CONTACT_PK

NUMBER

INT

Review Performer Contact Primary Key

REVIEW_PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Review Performer Contact Type

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer First Name

REVIEW_PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer Middle Name

REVIEW_PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Review Performer Name

REVIEW_STATUS

VARCHAR2(20)

VARCHAR(20)

Review Status

REVIEW_ACTION_DATE

DATE

DATETIME

Review Action Date

REVIEW_APPROVAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Approval Comment

REVIEW_REQUEST_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Request Comment

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

WH_HELPER_MILESTONE_WORKFLOW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

MILESTONE_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Milestone Unique Code

MILESTONE_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Milestone Object Title

MILESTONE_PRIMARY_KEY

NUMBER

INT

Milestone Primary Key

MILESTONE_SUBJECT

VARCHAR2(250)

VARCHAR(250)

Milestone Subject

MILESTONE_MILESTONE_DATE

DATE

DATETIME

Milestone Milestone Date

MILESTONE_STATUS

VARCHAR2(10)

VARCHAR(10)

Milestone Status

MILESTONE_COMPLETION_STATUS

VARCHAR2(3)

VARCHAR(3)

Milestone Completion Status

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

COMMENT_TO_REQUESTOR

VARCHAR2(2000)

VARCHAR(2000)

Comment To Requestor

EXPIRES_ON

DATE

DATETIME

Expires On

EXPIRE_ACTION

VARCHAR2(30)

VARCHAR(30)

Expire Action

TRANSACTION_STATUS

VARCHAR2(250)

VARCHAR(250)

Transaction Status

CURRENT_STOP_NO

NUMBER

INT

Current Stop No

REJECT_ACTION

VARCHAR2(30)

VARCHAR(30)

Reject Action

REJECT_REASON

VARCHAR2(50)

VARCHAR(50)

Reject Reason

UPDATE_WHILE_PENDING

VARCHAR2(105)

VARCHAR(105)

Update While Pending

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

PERFORMER_CONTACT_PK

NUMBER

INT

Performer Contact Primary Key

PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Performer Contact Type

PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Performer First Name

PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Performer Middle Name

PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Performer Name

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

ACTION_DATE

DATE

DATETIME

Action Date

STOP_EXPIRATION_DATE

DATE

DATETIME

Stop Expiration Date

INTERNAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Internal Comment

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

CREATED_ON

DATE

DATETIME

Created On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_ON

DATE

DATETIME

Modified On

STOP_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Primary Key Extra

STOP_MEMBER_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Member Primary Key Extra

WH_HELPER_MILESTONE_WKFL_RVW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

MILESTONE_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Milestone Unique Code

MILESTONE_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Milestone Object Title

MILESTONE_PRIMARY_KEY

NUMBER

INT

Milestone Primary Key

MILESTONE_SUBJECT

VARCHAR2(250)

VARCHAR(250)

Milestone Subject

MILESTONE_MILESTONE_DATE

DATE

DATETIME

Milestone Milestone Date

MILESTONE_STATUS

VARCHAR2(10)

VARCHAR(10)

Milestone Status

MILESTONE_COMPLETION_STATUS

VARCHAR2(3)

VARCHAR(3)

Milestone Completion Status

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

EXPIRES_ON

DATE

DATETIME

Expires On

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

REVIEW_PRIMARY_KEY

NUMBER

INT

Review Primary Key

REVIEW_PERFORMER_CONTACT_PK

NUMBER

INT

Review Performer Contact Primary Key

REVIEW_PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Review Performer Contact Type

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer First Name

REVIEW_PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer Middle Name

REVIEW_PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Review Performer Name

REVIEW_STATUS

VARCHAR2(20)

VARCHAR(20)

Review Status

REVIEW_ACTION_DATE

DATE

DATETIME

Review Action Date

REVIEW_APPROVAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Approval Comment

REVIEW_REQUEST_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Request Comment

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name
MODIFIED_BY_CONTACT_FIRST_NAME VARCHAR2(50) VARCHAR(50) Modified By Contact First Name

WH_HELPER_PROJECT_WORKFLOW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(100)

VARCHAR(100)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

COMMENT_TO_REQUESTOR

VARCHAR2(2000)

VARCHAR(2000)

Comment To Requestor

EXPIRES_ON

DATE

DATETIME

Expires On

EXPIRE_ACTION

VARCHAR2(30)

VARCHAR(30)

Expire Action

TRANSACTION_STATUS

VARCHAR2(250)

VARCHAR(250)

Transaction Status

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

REJECT_ACTION

VARCHAR2(30)

VARCHAR(30)

Reject Action

REJECT_REASON

VARCHAR2(50)

VARCHAR(50)

Reject Reason

UPDATE_WHILE_PENDING

VARCHAR2(105)

VARCHAR(105)

Update While Pending

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

PERFORMER_CONTACT_PK

NUMBER

INT

Performer Contact Primary Key

PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Performer First Name

PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Performer Middle Name

PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Performer Name

PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Performer Contact Type

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

ACTION_DATE

DATE

DATETIME

Action Date

STOP_EXPIRATION_DATE

DATE

DATETIME

Stop Expiration Date

INTERNAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Internal Comment

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_ON

DATE

DATETIME

Created On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_ON

DATE

DATETIME

Modified On

STOP_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Primary Key Extra

STOP_MEMBER_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Member Primary Key Extra

WH_HELPER_PROJECT_WORKFLOW_RVW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(100)

VARCHAR(100)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

EXPIRES_ON

DATE

DATETIME

Expires On

CURRENT_STOP_NO

NUMBER

INT

Current Stop Number

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

REVIEW_PRIMARY_KEY

NUMBER

INT

Review Primary Key

REVIEW_PERFORMER_CONTACT_PK

NUMBER

INT

Review Performer Contact Primary Key

REVIEW_PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Review Performer Contact Type

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer First Name

REVIEW_PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer Middle Name

REVIEW_PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Review Performer Name

REVIEW_STATUS

VARCHAR2(30)

VARCHAR(30)

Review Status

REVIEW_ACTION_DATE

DATE

DATETIME

Review Action Date

REVIEW_APPROVAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Approval Comment

REVIEW_REQUEST_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Request Comment

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

WH_HELPER_TASK_WORKFLOW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

TASK_PRIMARY_KEY

NUMBER

INT

Task Primary Key

TASK_SUBJECT

VARCHAR2(250)

VARCHAR(250)

Task Subject

TASK_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Task Category

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

MILESTONE_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Milestone Unique Code

MILESTONE_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Milestone Object Title

MILESTONE_PRIMARY_KEY

NUMBER

INT

Milestone Primary Key

MILESTONE_SUBJECT

VARCHAR2(250)

VARCHAR(250)

Milestone Subject

MILESTONE_DATE

DATE

DATETIME

Milestone Date

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

COMMENT_TO_REQUESTOR

VARCHAR2(2000)

VARCHAR(2000)

Comment To Requestor

EXPIRES_ON

DATE

DATETIME

Expires On

EXPIRE_ACTION

VARCHAR2(30)

VARCHAR(30)

Expire Action

TRANSACTION_STATUS

VARCHAR2(250)

VARCHAR(250)

Transaction Status

CURRENT_STOP_NO

NUMBER

INT

Current Stop No

REJECT_ACTION

VARCHAR2(30)

VARCHAR(30)

Reject Action

REJECT_REASON

VARCHAR2(50)

VARCHAR(50)

Reject Reason

UPDATE_WHILE_PENDING

VARCHAR2(105)

VARCHAR(105)

Update While Pending

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

PERFORMER_CONTACT_PK

NUMBER

INT

Performer Contact Primary Key

PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Performer Contact Type

PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Performer First Name

PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Performer Middle Name

PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Performer Name

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

ACTION_DATE

DATE

DATETIME

Action Date

STOP_EXPIRATION_DATE

DATE

DATETIME

Stop Expiration Date

INTERNAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Internal Comment

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

CREATED_ON

DATE

DATETIME

Created On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact First Name

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_ON

DATE

DATETIME

Modified On

STOP_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Primary Key Extra

STOP_MEMBER_PRIMARY_KEY_EXTRA

NUMBER

INT

Stop Member Primary Key Extra

WH_HELPER_TASK_WORKFLOW_RVW

Column Name

Oracle Data Type

MSSQL Data Type

Friendly Column Name

TASK_PRIMARY_KEY

NUMBER

INT

Task Primary Key

TASK_SUBJECT

VARCHAR2(250)

VARCHAR(250)

Task Subject

TASK_CATEGORY

VARCHAR2(50)

VARCHAR(50)

Task Category

PROJECT_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Project Unique Code

PROJECT_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Project Object Title

PROJECT_PRIMARY_KEY

NUMBER

INT

Project Primary Key

PROJECT_NUMBER

VARCHAR2(50)

VARCHAR(50)

Project Number

PROJECT_NAME

VARCHAR2(250)

VARCHAR(250)

Project Name

MILESTONE_UNIQUE_CODE

VARCHAR2(4)

VARCHAR(4)

Milestone Unique Code

MILESTONE_OBJECT_TITLE

VARCHAR2(250)

VARCHAR(250)

Milestone Object Title

MILESTONE_PRIMARY_KEY

NUMBER

INT

Milestone Primary Key

MILESTONE_SUBJECT

VARCHAR2(250)

VARCHAR(250)

Milestone Subject

MILESTONE_DATE

DATE

DATETIME

Milestone Date

WORKFLOW_PRIMARY_KEY

NUMBER

INT

Workflow Primary Key

REQUEST_NAME

VARCHAR2(50)

VARCHAR(50)

Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(250) VARCHAR(250) Rule Short Description

REQUESTED_BY_CONTACT_PK

NUMBER

INT

Requested By Contact Primary Key

REQUESTED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Requested By Contact Type

REQUESTED_BY_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By First Name

REQUESTED_BY_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Requested By Middle Name

REQUESTED_BY_NAME

VARCHAR2(250)

VARCHAR(250)

Requested By Name

REQUESTED_ON

DATE

DATETIME

Requested On

COMPLETED_ON

DATE

DATETIME

Completed On

WORKFLOW_STATUS

VARCHAR2(30)

VARCHAR(30)

Workflow Status

EXPIRES_ON

DATE

DATETIME

Expires On

CURRENT_STOP_NO

NUMBER

INT

Current Stop No

PROCESS_MANAGER_CONTACT_PK

NUMBER

INT

Process Manager Contact Primary Key

PROCESS_MANAGER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Process Manager Contact Type

PROCESS_MANAGER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager First Name

PROCESS_MANAGER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Process Manager Middle Name

PROCESS_MANAGER_NAME

VARCHAR2(250)

VARCHAR(250)

Process Manager Name

STOP_PRIMARY_KEY

NUMBER

INT

Stop Primary Key

STOP

NUMBER

INT

Stop

STOP_MEMBER_PRIMARY_KEY

NUMBER

INT

Stop Member Primary Key

STOP_STATUS

VARCHAR2(40)

VARCHAR(40)

Stop Status

EMAIL_SENT

VARCHAR2(3)

VARCHAR(3)

Email Sent

REVIEW_PRIMARY_KEY

NUMBER

INT

Review Primary Key

REVIEW_PERFORMER_CONTACT_PK

NUMBER

INT

Review Performer Contact Primary Key

REVIEW_PERFORMER_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Review Performer Contact Type

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer First Name

REVIEW_PERFORMER_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Review Performer Middle Name

REVIEW_PERFORMER_NAME

VARCHAR2(250)

VARCHAR(250)

Review Performer Name

REVIEW_STATUS

VARCHAR2(20)

VARCHAR(20)

Review Status

REVIEW_ACTION_DATE

DATE

DATETIME

Review Action Date

REVIEW_APPROVAL_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Approval Comment

REVIEW_REQUEST_COMMENT

VARCHAR2(2000)

VARCHAR(2000)

Review Request Comment

CREATED_ON

DATE

DATETIME

Created On

CREATED_BY_CONTACT_PK

NUMBER

INT

Created By Contact Primary Key

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Created By Contact Type

CREATED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Created By Contact Name

CREATED_BY_CONTACT_MIDDLE_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact Middle Name

CREATED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

Created By Contact First Name

MODIFIED_ON

DATE

DATETIME

Modified On

MODIFIED_BY_CONTACT_PK

NUMBER

INT

Modified By Contact Primary Key

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

Modified By Contact Type

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

Modified By Contact Name

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

Modified By Contact Middle Name
MODIFIED_BY_CONTACT_FIRST_NAME VARCHAR2(50) VARCHAR(50) Modified By Contact First Name

WH_MAPPING 

Column Name

NULL TYPE

Oracle Data Type

MSSQL Data Type

Friendly Column NaSource Tableme

TABLE_NAME

NOT NULL

VARCHAR2(30)

 VARCHAR(30)

Table Name

COLUMN_NAME

NOT NULL

VARCHAR2(30)

 VARCHAR(30)

Column Name

SOURCE_TABLE  

 

VARCHAR2(30)

 VARCHAR(30)

Source Table

SOURCE_COLUMN

 

VARCHAR2(30)

 VARCHAR(30)

Source Column

MAPPING

NOT NULL

VARCHAR2(30)

 VARCHAR(30)

Mapping
  • Was this article helpful?