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 |
Friendly Column Name |
|---|---|---|---|
|
OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Object Unique Code |
|
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Object Title |
|
OBJECT_IS_EMBEDDED |
VARCHAR2(5) |
VARCHAR(5) |
Object Is Embedded |
|
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_OPENED_ON_DATE |
DATE |
DATETIME |
Project Opened On Date |
|
PROJECT_CLOSED_ON_DATE |
DATE |
DATETIME |
Project Closed On Date |
|
DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
Default Category |
|
DEFAULT_CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
Default Category Tree Position |
|
CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
Current Phase |
|
CURRENT_PHASE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Current Phase Unique Code |
|
CONTACT_PRIMARY_KEY |
NUMBER |
INT |
Contact Primary Key |
|
CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
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 |
|
CONTACT_ROLE |
VARCHAR2(250) |
VARCHAR(250) |
Contact Role |
|
MAIN_ASSIGNEE_CONTACT_PK |
NUMBER |
INT |
Main Assignee Contact Primary Key |
|
MAIN_ASSIGNEE_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
Main Assignee Contact Type |
|
MAIN_ASSIGNEE_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Main Assignee First Name |
|
MAIN_ASSIGNEE_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Main Assignee Middle Name |
|
MAIN_ASSIGNEE_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Main Assignee Name |
|
MAIN_ASSIGNEE_ROLE |
VARCHAR2(50) |
VARCHAR(50) |
Main Assignee Role |
|
MAIN_ASSIGNEE_ROLE_TREE_POSITI |
VARCHAR2(250) |
VARCHAR(250) |
Main Assignee Role Tree Position |
|
MAIN_ASSIGNEE_ASSIGNED_ON_DATE |
DATE |
DATETIME |
Main Assignee Assigned On Date |
|
PARENT_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Parent Object Unique Code |
|
PARENT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Parent Object Title |
|
PARENT_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Parent Project Primary Key |
|
PARENT_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Parent Project Number |
|
PARENT_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Parent Project Name |
|
DOCUMENT_FOLDER_PRIMARY_KEY |
NUMBER |
INT |
Document Folder Primary Key |
|
CREATED_ON |
DATE |
DATETIME |
Created On |
|
MODIFIED_ON |
DATE |
DATETIME |
Modified On |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
Created By Contact Primary Key |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
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 |
|
BEHALF_OF_CONTACT_PRIMARY_KEY |
NUMBER |
INT |
Behalf Of Contact Primary Key |
|
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
Modified By Contact Primary Key |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
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 |
|
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
Security |
|
WORKFLOW_CURRENT_STATUS |
VARCHAR2(15) |
VARCHAR(15) |
Workflow Current Status |
|
WORKFLOW_CURRENT_ACTION |
VARCHAR2(50) |
VARCHAR(50) |
Workflow Current Action |
|
DISPLAY_NAME |
VARCHAR2(305) |
VARCHAR(305) |
Display Name |
|
CURRENT_APPROVER_CONTACT_PK |
NUMBER |
INT |
Current Approver Contact Primary Key |
|
CURRENT_APPROVER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Current Approver Name |
|
CURRENT_APPROVER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Current Approver First Name |
|
CURRENT_APPROVER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Current Approver Middle Name |
|
CURRENT_APPROVER_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
Current Approver Type |
|
LAST_PERFRMR_CONTACT_PK |
NUMBER |
INT |
Last Performer Contact Primary Key |
|
LAST_PERFRMR_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Last Performer Name |
|
LAST_PERFRMR_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Last Performer First Name |
|
LAST_PERFRMR_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Last Performer Middle Name |
|
LAST_PERFRMR_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
Last Performer Type |
|
MULTIPLE_APPROVERS |
VARCHAR2(3) |
VARCHAR(3) |
Multiple Approvers |
|
PROJECT_CLOSED_ON_DATE_KEY |
NUMBER |
DATETIME |
Project Closed On Date Key |
|
PROJECT_OPENED_ON_DATE_KEY |
NUMBER |
DATETIME |
Project Opened On Date Key |
|
CREATED_ON_DATE_KEY |
NUMBER |
DATETIME |
Created On Date Key |
|
MODIFIED_ON_DATE_KEY |
NUMBER |
DATETIME |
Modified On Date Key |
|
MAIN_ASSIGNEE_ASSIGN_ON_DT_KEY |
NUMBER |
DATETIME |
Main Assignee Assign On Date Key |
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 |
Friendly Column Name |
|---|---|---|---|
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Project Primary Key |
|
INVOICE_PRIMARY_KEY |
NUMBER |
INT |
Invoice Primary Key |
WH_PROJECT_ASSIGNEES
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Object Title |
|
OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Object 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 |
|
ASSIGNEE_ASSIGNED_ON_DATE |
DATE |
DATETIME |
Assignee Assigned On Date |
|
ASSIGNEE_UNASSIGNED_ON_DATE |
DATE |
DATETIME |
Assignee Unassigned On Date |
|
ASSIGNEE_CONTACT_PK |
NUMBER |
INT |
Assignee Contact Primary Key |
|
ASSIGNEE_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
Assignee Contact Type |
|
ASSIGNEE_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Assignee First Name |
|
ASSIGNEE_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Assignee Middle Name |
|
ASSIGNEE_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Assignee Name |
|
ASSIGNEE_ROLE |
VARCHAR2(50) |
VARCHAR(50) |
Assignee Role |
|
ASSIGNEE_ROLE_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
Assignee Role Tree Position |
|
ASSIGNEE_STATUS |
VARCHAR2(10) |
VARCHAR(10) |
Assignee Status |
|
IS_MAIN_ASSIGNEE |
VARCHAR2(5) |
VARCHAR(5) |
Is Main Assignee |
|
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
Security |
|
ASSIGNEE_ASSIGNED_ON_DATE_KEY |
NUMBER |
DATETIME |
Assignee Assigned On Date Key |
|
ASSIGNEE_UNASSIGNED_ON_DT_KEY |
NUMBER |
DATETIME |
Assignee Unassigned On Date Key |
WH_PROJECT_CATEGORIES
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Object Unique Code |
|
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
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 |
|
IS_CATEGORY_MANUALLY_ADDED |
VARCHAR2(1) |
VARCHAR(1) |
Is Category Manually Added |
|
CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Category Name |
|
CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
Category Tree Position |
|
IS_DEFAULT_CATEGORY |
VARCHAR2(5) |
VARCHAR(5) |
Is Default Category |
|
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
Security |
WH_PROJECT_PHASES
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Object Unique Code |
|
OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
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 |
|
PHASE_DURATION |
NUMBER |
INT |
Phase Duration |
|
PHASE_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Phase Name |
|
PHASE_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Phase Unique Code |
|
PHASE_SET_BY_CONTACT_PK |
NUMBER |
INT |
Phase Set By Contact Primary Key |
|
PHASE_SET_BY_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
Phase Set By Contact Type |
|
PHASE_SET_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Phase Set By First Name |
|
PHASE_SET_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Phase Set By Middle Name |
|
PHASE_SET_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Phase Set By Name |
|
PHASE_SET_ON_DATE |
DATE |
DATETIME |
Phase Set On Date |
|
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
Security |
|
PHASE_SET_ON_DATE_KEY |
NUMBER |
DATETIME |
Phase Set On Date Key |
WH_PROJECTS_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 |
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_PROJECT_TREE
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
TREE_KEY |
VARCHAR2(700) |
VARCHAR(700) |
Tree Key |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Project Primary Key |
|
LEVEL1_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Level1 Object Unique Code |
|
LEVEL1_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Level1 Object Title |
|
LEVEL1_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Level1 Project Primary Key |
|
LEVEL1_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Level1 Project Number |
|
LEVEL1_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Level1 Project Name |
|
LEVEL1_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Level1 Default Category Name |
|
LEVEL1_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
Level1 Default Category Tree |
|
LEVEL1_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
Level1 Current Phase |
|
LEVEL1_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
Level1 Current Phaseuniquecode |
|
LEVEL2_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Level2 Object Unique Code |
|
LEVEL2_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Level2 Object Title |
|
LEVEL2_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Level2 Project Primary Key |
|
LEVEL2_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Level2 Project Number |
|
LEVEL2_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Level2 Project Name |
|
LEVEL2_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Level2 Default Category Name |
|
LEVEL2_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
Level2 Default Category Tree |
|
LEVEL2_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
Level2 Current Phase |
|
LEVEL2_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
Level2 Current Phaseuniquecode |
|
LEVEL3_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Level3 Object Unique Code |
|
LEVEL3_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Level3 Object Title |
|
LEVEL3_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Level3 Project Primary Key |
|
LEVEL3_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Level3 Project Number |
|
LEVEL3_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Level3 Project Name |
|
LEVEL3_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Level3 Default Category Name |
|
LEVEL3_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
Level3 Default Category Tree |
|
LEVEL3_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
Level3 Current Phase |
|
LEVEL3_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
Level3 Current Phaseuniquecode |
|
LEVEL4_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Level4 Object Unique Code |
|
LEVEL4_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Level4 Object Title |
|
LEVEL4_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Level4 Project Primary Key |
|
LEVEL4_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Level4 Project Number |
|
LEVEL4_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Level4 Project Name |
|
LEVEL4_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Level4 Default Category Name |
|
LEVEL4_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
Level4 Default Category Tree |
|
LEVEL4_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
Level4 Current Phase |
|
LEVEL4_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
Level4 Current Phaseuniquecode |
|
LEVEL5_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Level5 Object Unique Code |
|
LEVEL5_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Level5 Object Title |
|
LEVEL5_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Level5 Project Primary Key |
|
LEVEL5_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Level5 Project Number |
|
LEVEL5_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Level5 Project Name |
|
LEVEL5_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Level5 Default Category Name |
|
LEVEL5_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
Level5 Default Category Tree |
|
LEVEL5_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
Level5 Current Phase |
|
LEVEL5_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
Level5 Current Phase Uniquecode |
|
LEVEL6_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Level6 Object Unique Code |
|
LEVEL6_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Level6 Object Title |
|
LEVEL6_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Level6 Project Primary Key |
|
LEVEL6_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Level6 Project Number |
|
LEVEL6_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Level6 Project Name |
|
LEVEL6_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Level6 Default Category Name |
|
LEVEL6_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
Level6 Default Category Tree |
|
LEVEL6_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
Level6 Current Phase |
|
LEVEL6_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
Level6 Current Phase Uniquecode |
|
LEVEL7_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Level7 Object Unique Code |
|
LEVEL7_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Level7 Object Title |
|
LEVEL7_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Level7 Project Primary Key |
|
LEVEL7_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Level7 Project Number |
|
LEVEL7_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Level7 Project Name |
|
LEVEL7_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Level7 Default Category Name |
|
LEVEL7_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
Level7 Default Category Tree |
|
LEVEL7_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
Level7 Current Phase |
|
LEVEL7_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
Level7 Current Phaseuniquecode |
|
LEVEL8_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Level8 Object Unique Code |
|
LEVEL8_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Level8 Object Title |
|
LEVEL8_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Level8 Project Primary Key |
|
LEVEL8_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Level8 Project Number |
|
LEVEL8_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Level8 Project Name |
|
LEVEL8_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Level8 Default Category Name |
|
LEVEL8_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
Level8 Default Category Tree |
|
LEVEL8_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
Level8 Current Phase |
|
LEVEL8_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
Level8 Current Phase Uniquecode |
|
LEVEL9_OBJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Level9 Object Unique Code |
|
LEVEL9_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Level9 Object Title |
|
LEVEL9_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Level9 Project Primary Key |
|
LEVEL9_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Level9 Project Number |
|
LEVEL9_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Level9 Project Name |
|
LEVEL9_DEFAULT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Level9 Default Category Name |
|
LEVEL9_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
Level9 Default Category Tree |
|
LEVEL9_CURRENT_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
Level9 Current Phase |
|
LEVEL9_CURRENT_PHASEUNIQUECODE |
VARCHAR2(4) |
VARCHAR(4) |
Level9 Current Phase Uniquecode |
WH_PROJECT_GROUP_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Project Primary Key |
|
GROUP_PRIMARY_KEY |
NUMBER |
INT |
Group Primary Key |
|
ALLOW_DENY_IID |
CHAR(1) |
CHAR(1) |
Allow Deny IID |
|
OPERATION_IID |
NUMBER |
INT |
Operation IID |
| IS_DELETE | NUMBER | INT | Is Deleted |
|
IS_MANUAL |
NUMBER |
INT |
Is Manual |
| IS_PERM | NUMBER | INT | Is Permanent |
| IS_READ | NUMBER | INT | Is Read |
| IS_UPDATE | NUMBER | INT | Is Updated |
|
VERSION |
NUMBER |
INT |
Version Number |
WH_PROJECT_USER_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Project Primary Key |
|
USER_PRIMARY_KEY |
NUMBER |
INT |
User Primary Key |
|
ALLOW_DENY_IID |
CHAR(1) |
CHAR(1) |
Allow Deny IID |
|
OPERATION_IID |
NUMBER |
INT |
Operation IID |
| IS_DELETE | NUMBER | INT | Is Deleted |
|
IS_MANUAL |
NUMBER |
INT |
Is Manual |
| IS_PERM | NUMBER | INT | Is Permanent |
| IS_READ | NUMBER | INT | Is Read |
| IS_UPDATE | NUMBER | INT | Is Updated |
|
VERSION |
NUMBER |
INT |
Version Number |
WH_PROJECT_SECURITY
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
OBJECT_UNIQUE_CODE |
NVARCHAR2(4) |
NVARCHAR(4) |
Object Unique Code |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Project Primary Key |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
Created By Contact Primary Key |
|
SECURITY |
NVARCHAR2(10) |
NVARCHAR(10) |
Security |
WH_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 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 |
WH_PROJECT_WORKFLOW_HISTORY
|
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_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 |
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 |
|
ACTIVITY |
VARCHAR2(250) |
VARCHAR(250) |
Activity |
|
DATE_TIME |
DATE |
DATETIME |
Date Time |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
Internal Comment |
|
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 |
WH_PROJECT_WORKFLOW_RECIPIENT
|
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 |
|
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 |
|
EVENT |
VARCHAR2(20) |
VARCHAR2(20) |
Event |
|
RECIPIENT_CONTACT_PK |
NUMBER |
INT |
Recipient Contact Primary Key |
|
RECIPIENT_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
Recipient Contact Type |
|
RECIPIENT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
Recipient First Name |
|
RECIPIENT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
Recipient Middle Name |
|
RECIPIENT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
Recipient Name |
|
VERSION |
NUMBER |
INT |
Version |
|
CREATED_ON |
DATE |
DATETIME |
Created On |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
Created By Contact Primary Key |
|
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
Created By Contact Type |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
Created By Contact Name |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
Created By Contact Middle Name |
|
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(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) |
VARCHAR2(7) |
Modified By Contact Type |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
Modified By Contact Name |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
Modified By Contact First Name |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
Modified By Contact Middle Name |
WH_PROJECT_WORKFLOW_REVIEW
|
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 |
|
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 |