Document
The system object Documents tables include:
- WH_DOCUMENT
- WH_DOCUMENT_CATEGORIES
- WH_DOCUMENT_GROUP_ACCESS*
- WH_DOCUMENT_USER_ACCESS*
- WH_DOCUMENT_SECURITY
- WH_DOCUMENT_WORKFLOW
- WH_DOCUMENT_WORKFLOW_HISTORY
- WH_DOCUMENT_WORKFLOW_RECIPIENT
- WH_DOCUMENT_WORKFLOW_REVIEW
* These tables support the user access and security feature and should not be queried directly.
WH_DOCUMENT
DOCUMENT_FILE_TYPE_PK
NUMBER
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
---|---|---|---|
DOCUMENT_PRIMARY_KEY |
NUMBER |
INT |
Document Primary Key |
DOCUMENT_SIZE |
NUMBER |
INT |
Document Size |
DOCUMENT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Document Name |
DOCUMENT_TREE_KEY |
VARCHAR2(700) |
VARCHAR(700) |
Document Tree Key |
DOCUMENT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
Document Category |
DOCUMENT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
Document Category Tree |
DOCUMENT_URL_STRING |
VARCHAR2(2000) |
VARCHAR(2000) |
Document Url String |
DOCUMENT_TYPE |
VARCHAR2(9) |
VARCHAR(9) |
Document Type |
DOCUMENT_FILE_TYPE |
VARCHAR2(50) |
VARCHAR(50) |
Document File Type |
DOCUMENT_IS_EMAIL_FOLDER |
VARCHAR2(3) |
VARCHAR(3) |
Document Is Email Folder |
DOCUMENT_FILE_TYPE_PK |
NUMBER |
INT |
Document File Type Primary key |
DOCUMENT_AUTHOR_DATE |
DATE |
DATETIME |
Document Author Date |
DOCUMENT_VERSION |
VARCHAR2(250) |
VARCHAR(250) |
Document Version |
PARENT_FOLDER_ID |
NUMBER |
INT |
Parent Folder Id |
DOCUMENT_LOCATION |
VARCHAR2(4000) |
VARCHAR(4000) |
Document Location |
SHORTCUT_TO_DOCUMENT_ID |
NUMBER |
INT |
Shortcut To Document Id |
SHORTCUT_TO_DOCUMENT |
VARCHAR2(250) |
VARCHAR(250) |
Shortcut To Document |
AUTHOR_CONTACT_PK |
NUMBER |
INT |
Author Contact Primary key |
AUTHOR_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
Author Contact Type |
AUTHOR_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Author Contact Name |
AUTHOR_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Author Contact Middle Name |
AUTHOR_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Author Contact First Name |
CHECKED_OUT_ON |
DATE |
DATETIME |
Checked Out On |
CHECK_OUT_CONTACT_PK |
NUMBER |
INT |
Check Out Contact Primary key |
CHECK_OUT_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
Check Out Contact Type |
CHECK_OUT_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Check Out Contact Name |
CHECK_OUT_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Check Out Contact Middle Name |
CHECK_OUT_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Check Out Contact First Name |
CHECKOUT_LOCATION |
VARCHAR2(250) |
VARCHAR(250) |
Checkout Location |
CHECKED_IN_ON |
DATE |
DATETIME |
Checked In On |
CHECK_IN_CONTACT_PK |
NUMBER |
INT |
Check In Contact Primary key |
CHECK_IN_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
Check In Contact Type |
CHECK_IN_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Check In Contact Name |
CHECK_IN_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Check In Contact Middle Name |
CHECK_IN_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Check In Contact First Name |
CREATED_ON |
DATE |
DATETIME |
Created 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 |
MODIFIED_ON |
DATE |
DATETIME |
Modified On |
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 Mid Name |
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Modified By Contact First Name |
BEHALF_OF_CONTACT_PRIMARY_KEY |
NUMBER |
INT |
Behalf Of Contact Primary Key |
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 |
NOTES |
CLOB |
NTEXT |
Notes |
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 |
DOCUMENT_AUTHOR_DATE_KEY |
NUMBER |
DATETIME |
Document Author Date Key |
CHECKED_OUT_ON_DATE_KEY |
NUMBER |
DATETIME |
Checked Out On Date Key |
CHECKED_IN_ON_DATE_KEY |
NUMBER |
DATETIME |
Checked In On Date Key |
CREATED_ON_DATE_KEY |
NUMBER |
DATETIME |
Created On Date Key |
MODIFIED_ON_DATE_KEY |
NUMBER |
DATETIME |
Modified On Date Key |
WH_DOCUMENT_CATEGORIES
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
---|---|---|---|
CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Category Name |
CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
Category Tree Position |
DOCUMENT_FILE_TYPE |
VARCHAR2(50) |
VARCHAR(50) |
Document File Type |
DOCUMENT_LOCATION |
VARCHAR2(4000) |
VARCHAR(4000) |
Document Location |
DOCUMENT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Document Name |
DOCUMENT_PRIMARY_KEY |
NUMBER |
INT |
Document Primary Key |
DOCUMENT_TREE_KEY |
VARCHAR2(700) |
VARCHAR(700) |
Document Tree Key |
IS_CATEGORY_MANUALLY_ADDED |
VARCHAR2(1) |
VARCHAR(1) |
Is Category Manually Added |
IS_DEFAULT_CATEGORY |
VARCHAR2(5) |
VARCHAR(5) |
Is Default Category |
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
Security |
WH_DOCUMENT_GROUP_ACCESS
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
---|---|---|---|
DOCUMENT_PRIMARY_KEY |
NUMBER |
INT |
Document Primary Key |
GROUP_PRIMARY_KEY |
NUMBER |
INT |
Group Primary Key |
ALLOW_DENY_IID |
CHAR(1) |
CHAR(1) |
Allow Deny Identifier |
OPERATION_IID |
NUMBER |
INT |
Operation Identifier |
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_DOCUMENT_USER_ACCESS
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
---|---|---|---|
DOCUMENT_PRIMARY_KEY |
NUMBER |
INT |
Document Primary Key |
USER_PRIMARY_KEY |
NUMBER |
INT |
User Primary Key |
ALLOW_DENY_IID |
CHAR(1) |
CHAR(1) |
Allow Deny Idenifier |
OPERATION_IID |
NUMBER |
INT |
Operation Identifier |
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_DOCUMENT_SECURITY
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
---|---|---|---|
DOCUMENT_PRIMARY_KEY |
NUMBER |
INT |
Document Primary Key |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
Created By Contact Primary key |
SECURITY |
NVARCHAR2(10) |
NVARCHAR(10) |
Security |
WH_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 |
NVARCHAR2(250 CHAR) |
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 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_DOCUMENT_WORKFLOW_HISTORY
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 |
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 |
DATE_TIME |
DATE | DATETIME | Date Time |
ACTIVITY |
VARCHAR2(250) |
VARCHAR(250) |
Activity |
ACTION_DATE |
DATE |
DATETIME |
Action Date |
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 jkey |
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_DOCUMENT_WORKFLOW_RECIPIENT
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) | 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 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 |
EVENT |
VARCHAR2(250) |
VARCHAR2(250) |
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_MID_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
Modified By Contact Mid Name |
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
Modified By Contact First Name |
WH_DOCUMENT_WORKFLOW_REVIEW
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) | 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 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(250) |
VARCHAR(250) |
Review Approval Comment |
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR(250) |
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 |