Helper Table Definitions
Helper tables are used by the Data Warehouse transformations to aid in the population process. These tables are used for refresh and delete, as well as for data conversions. Normally you would not query these tables directly, but would instead query the views.
WHCC_MAPPINGS and WHCF_MAPPINGS resolve cases where two custom fields, associated with different categories, may have the same field name. In a view that combines information from multiple categories, there is the possibility that the two identical field names would cause identical column names, an error. Instead, these tables make sure that column names are always unique. The name used by the view is contained in column FIELD_NAME_MAP and the original name for the field is in column FIELD_NAME. Use WH_CC_MAPPINGS for WH_CC_XXXX, and use WH_CF_MAPPINGS for WH_CF_XXXX.
WH_CUSTOM_NUMB, WH_CUSTOM_DATE, WH_CUSTOM_MEMO, WH_CUSTOM_TEXT, WH_CUSTOM_OBJE, and WH_CUSTOM_OBJF contain values for custom fields. The six tables correspond to the six kinds of datatypes that can be used by custom fields.
WH_MAPPING table contains the mapping between TeamConnect transactional tables to the Data Warehouse tables. These are system fields and are static.
In addition to the other helper tables described above, there are many workflow-related helper tables, two for each system object (for example, WH_HELPER_ACCOUNT_WORKFLOW and WH_HELPER_ACCOUNT_WORKFLOW_RVW, for the Account object.)
WH_CC_MAPPINGS
Column Name |
Oracle Data Type |
MSSQL Data Type |
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 |