The custom object Project tables include:
•WH_PROJECT_XXXX
•WH_PROJECT_INVOICE
•WH_PROJECT_ASSIGNEES
•WH_PROJECT_CATEGORIES
•WH_PROJECT_PHASES
•WH_PROJECTS_RELATIONS
•WH_PROJECTS_TREE
•WH_PROJECT_GROUP_ACCESS*
•WH_PROJECT_USER_ACCESS*
•WH_PROJECT_SECURITY
•WH_PROJECT_WORKFLOW
•WH_PROJECT_WORKFLOW_HISTORY
•WH_PROJECT_WORKFLOW_RECIPIENT
•WH_PROJECT_WORKFLOW_REVIEW
* These tables support the user access and security feature and should not be queried directly.
Shown below is the main table for a hypothetical custom object. Note that column DISPLAY_NAME can be helpful in reporting, since it contains an output-friendly name string that your report would otherwise have to create through concatenating other columns in this table. "XXXX" represents the unique entity code of this hypothetical custom object.
WH_PROJECT_XXXX
Column Name |
Oracle Data Type |
MSSQL Data Type |
OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
OBJECT_IS_EMBEDDED |
VARCHAR2(5) |
VARCHAR(5) |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
PROJECT_OPENED_ON_DATE |
DATE |
DATETIME |
PROJECT_CLOSED_ON_DATE |
DATE |
DATETIME |
DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
DEFAULT_CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
CURRENT_PHASE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
CONTACT_PRIMARY_KEY |
NUMBER |
INT |
CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CONTACT_ROLE |
VARCHAR2(250) |
VARCHAR(250) |
MAIN_ASSIGNEE_CONTACT_PK |
NUMBER |
INT |
MAIN_ASSIGNEE_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
MAIN_ASSIGNEE_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MAIN_ASSIGNEE_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MAIN_ASSIGNEE_NAME |
VARCHAR2(250) |
VARCHAR(250) |
MAIN_ASSIGNEE_ROLE |
VARCHAR2(50) |
VARCHAR(50) |
MAIN_ASSIGNEE_ROLE_TREE_POSITI |
VARCHAR2(250) |
VARCHAR(250) |
MAIN_ASSIGNEE_ASSIGNED_ON_DATE |
DATE |
DATETIME |
PARENT_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
PARENT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
PARENT_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
PARENT_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
PARENT_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
DOCUMENT_FOLDER_PRIMARY_KEY |
NUMBER |
INT |
CREATED_ON |
DATE |
DATETIME |
MODIFIED_ON |
DATE |
DATETIME |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
CREATED_BY_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
BEHALF_OF_CONTACT_PRIMARY_KEY |
NUMBER |
INT |
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
WORKFLOW_CURRENT_STATUS |
VARCHAR2(15) |
VARCHAR(15) |
WORKFLOW_CURRENT_ACTION |
VARCHAR2(50) |
VARCHAR(50) |
DISPLAY_NAME |
VARCHAR2(305) |
VARCHAR(305) |
CURRENT_APPROVER_CONTACT_PK |
NUMBER |
INT |
CURRENT_APPROVER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CURRENT_APPROVER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CURRENT_APPROVER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CURRENT_APPROVER_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
LAST_PERFRMR_CONTACT_PK |
NUMBER |
INT |
LAST_PERFRMR_NAME |
VARCHAR2(250) |
VARCHAR(250) |
LAST_PERFRMR_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LAST_PERFRMR_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LAST_PERFRMR_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
MULTIPLE_APPROVERS |
VARCHAR2(3) |
VARCHAR(3) |
PROJECT_CLOSED_ON_DATE_KEY |
DATE |
DATETIME |
PROJECT_OPENED_ON_DATE_KEY |
DATE |
DATETIME |
CREATED_ON_DATE_KEY |
DATE |
DATETIME |
MODIFIED_ON_DATE_KEY |
DATE |
DATETIME |
MAIN_ASSIGNEE_ASSIGN_ON_DT_KEY |
DATE |
DATETIME |
WH_PROJECT_INVOICES is useful in situations where users enter all invoice line items against a single project. In such a case, you can use this table, and bypass WH_LINEITEM, when determining which project an invoice belongs to.
WH_PROJECT_INVOICE
Column Name |
Oracle Data Type |
MSSQL Data Type |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
INVOICE_PRIMARY_KEY |
NUMBER |
INT |
WH_PROJECT_ASSIGNEES
Column Name |
Oracle Data Type |
MSSQL Data Type |
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
ASSIGNEE_ASSIGNED_ON_DATE |
DATE |
DATETIME |
ASSIGNEE_UNASSIGNED_ON_DATE |
DATE |
DATETIME |
ASSIGNEE_CONTACT_PK |
NUMBER |
INT |
ASSIGNEE_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
ASSIGNEE_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
ASSIGNEE_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
ASSIGNEE_NAME |
VARCHAR2(250) |
VARCHAR(250) |
ASSIGNEE_ROLE |
VARCHAR2(50) |
VARCHAR(50) |
ASSIGNEE_ROLE_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
ASSIGNEE_STATUS |
VARCHAR2(10) |
VARCHAR(10) |
IS_MAIN_ASSIGNEE |
VARCHAR2(5) |
VARCHAR(5) |
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
ASSIGNEE_ASSIGNED_ON_DATE_KEY |
DATE |
DATETIME |
ASSIGNEE_UNASSIGNED_ON_DT_KEY |
DATE |
DATETIME |
WH_PROJECT_CATEGORIES
Column Name |
Oracle Data Type |
MSSQL Data Type |
OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
IS_CATEGORY_MANUALLY_ADDED |
VARCHAR2(1) |
VARCHAR(1) |
CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
IS_DEFAULT_CATEGORY |
VARCHAR2(5) |
VARCHAR(5) |
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
WH_PROJECT_PHASES
Column Name |
Oracle Data Type |
MSSQL Data Type |
OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
PHASE_DURATION |
NUMBER |
INT |
PHASE_NAME |
VARCHAR2(250) |
VARCHAR(250) |
PHASE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
PHASE_SET_BY_CONTACT_PK |
NUMBER |
INT |
PHASE_SET_BY_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
PHASE_SET_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PHASE_SET_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PHASE_SET_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
PHASE_SET_ON_DATE |
DATE |
DATETIME |
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
PHASE_SET_ON_DATE_KEY |
DATE |
DATETIME |
WH_PROJECTS_RELATIONS
Column Name |
Oracle Data Type |
MSSQL Data Type |
LEFT_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
LEFT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
LEFT_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
LEFT_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
LEFT_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
RELATION_NAME |
VARCHAR2(50) |
VARCHAR(50) |
RELATION_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
RIGHT_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
RIGHT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
RIGHT_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
RIGHT_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
RIGHT_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
The WH_PROJECTS_TREE table contains information about parent-child relationships among project records. Each project record will have at least one row in this table with the LEVEL1_* columns populated with information about that project record. If the project record has child records and grandchild records, then there will be additional rows where LEVEL2_* columns and LEVEL_3* columns will be populated.
WH_PROJECTS_TREE
Column Name |
Oracle Data Type |
MSSQL Data Type |
TREE_KEY |
VARCHAR2(700) |
VARCHAR(700) |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
LEVEL1_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL1_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL1_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
LEVEL1_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL1_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL1_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL1_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL1_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL1_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL2_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL2_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL2_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
LEVEL2_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL2_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL2_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL2_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL2_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL2_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL3_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL3_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL3_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
LEVEL3_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL3_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL3_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL3_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL3_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL3_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL4_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL4_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL4_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
LEVEL4_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL4_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL4_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL4_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL4_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL4_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL5_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL5_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL5_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
LEVEL5_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL5_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL5_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL5_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL5_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL5_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL6_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL6_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL6_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
LEVEL6_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL6_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL6_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL6_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL6_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL6_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL7_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL7_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL7_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
LEVEL7_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL7_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL7_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL7_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL7_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL7_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL8_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL8_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL8_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
LEVEL8_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL8_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL8_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL8_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL8_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL8_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL9_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
LEVEL9_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL9_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
LEVEL9_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL9_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL9_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LEVEL9_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL9_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
LEVEL9_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
WH_PROJECT_GROUP_ACCESS
Column Name |
Oracle Data Type |
MSSQL Data Type |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
GROUP_PRIMARY_KEY |
NUMBER |
INT |
ALLOW_DENY_IID |
CHAR(1) |
CHAR(1) |
OPERATION_IID |
NUMBER |
INT |
IS_MANUAL |
NUMBER |
INT |
VERSION |
NUMBER |
INT |
WH_PROJECT_USER_ACCESS
Column Name |
Oracle Data Type |
MSSQL Data Type |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
USER_PRIMARY_KEY |
NUMBER |
INT |
ALLOW_DENY_IID |
CHAR(1) |
CHAR(1) |
OPERATION_IID |
NUMBER |
INT |
IS_MANUAL |
NUMBER |
INT |
VERSION |
NUMBER |
INT |
WH_PROJECT_SECURITY
Column Name |
Oracle Data Type |
MSSQL Data Type |
OBJECT_UNIQUE_CODE |
NVARCHAR2(4) |
NVARCHAR(4) |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
SECURITY |
NVARCHAR2(10) |
NVARCHAR(10) |
WH_PROJECT_WORKFLOW
Column Name |
Oracle Data Type |
MSSQL Data Type |
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
REQUEST_NAME |
VARCHAR2(100) |
VARCHAR(100) |
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
REQUESTED_ON |
DATE |
DATETIME |
COMPLETED_ON |
DATE |
DATETIME |
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
EXPIRES_ON |
DATE |
DATETIME |
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
CURRENT_STOP_NO |
NUMBER |
INT |
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
STOP_PRIMARY_KEY |
NUMBER |
INT |
STOP |
NUMBER |
INT |
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
PERFORMER_CONTACT_PK |
NUMBER |
INT |
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
ACTION_DATE |
DATE |
DATETIME |
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_BY_CONTACT_FIRST_NAM E |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
CREATED_ON |
DATE |
DATETIME |
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
MODIFIED_ON |
DATE |
DATETIME |
WH_PROJECT_WORKFLOW_HISTORY
Column Name |
Oracle Data Type |
MSSQL Data Type |
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
REQUEST_NAME |
VARCHAR2(100) |
VARCHAR(100) |
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
REQUESTED_ON |
DATE |
DATETIME |
COMPLETED_ON |
DATE |
DATETIME |
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
EXPIRES_ON |
DATE |
DATETIME |
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
CURRENT_STOP_NO |
NUMBER |
INT |
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
ACTIVITY |
VARCHAR2(250) |
VARCHAR(250) |
ACTION_DATE |
DATE |
DATETIME |
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_ON |
DATE |
DATETIME |
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
MODIFIED_ON |
DATE |
DATETIME |
WH_PROJECT_WORKFLOW_RECIPIENT
Column Name |
Oracle Data Type |
MSSQL Data Type |
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
REQUEST_NAME |
VARCHAR2(100) |
VARCHAR(100) |
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
REQUESTED_ON |
DATE |
DATETIME |
COMPLETED_ON |
DATE |
DATETIME |
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
EXPIRES_ON |
DATE |
DATETIME |
CURRENT_STOP_NO |
NUMBER |
INT |
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
EVENT |
VARCHAR2(250) |
VARCHAR2(250) |
RECIPIENT_CONTACT_PK |
NUMBER |
INT |
RECIPIENT_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
RECIPIENT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
RECIPIENT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
RECIPIENT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
VERSION |
NUMBER |
INT |
CREATED_ON |
DATE |
DATETIME |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
MODIFIED_ON |
DATE |
DATETIME |
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
WH_PROJECT_WORKFLOW_REVIEW
Column Name |
Oracle Data Type |
MSSQL Data Type |
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
REQUEST_NAME |
VARCHAR2(100) |
VARCHAR(100) |
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
REQUESTED_ON |
DATE |
DATETIME |
COMPLETED_ON |
DATE |
DATETIME |
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
EXPIRES_ON |
DATE |
DATETIME |
CURRENT_STOP_NO |
NUMBER |
INT |
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
STOP_PRIMARY_KEY |
NUMBER |
INT |
STOP |
NUMBER |
INT |
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
REVIEW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
REVIEW_ACTION_DATE |
DATE |
DATETIME |
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
CREATED_ON |
DATE |
DATETIME |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_ON |
DATE |
DATETIME |
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
