Skip to main content
Mitratech Success Center

Project

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_NAME

VARCHAR2(50)

VARCHAR(50)

CREATED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

CREATED_ON

DATE

DATETIME

MODIFIED_BY_CONTACT_PK

NUMBER

INT

MODIFIED_BY_CONTACT_NAME

VARCHAR2(250)

VARCHAR(250)

MODIFIED_BY_CONTACT_MID_NAME

VARCHAR2(50)

VARCHAR(50)

MODIFIED_BY_CONTACT_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

MODIFIED_BY_CONTACT_TYPE

VARCHAR2(7)

VARCHAR(7)

MODIFIED_ON

DATE

DATETIME

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)

  • Was this article helpful?