Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

Document

This guide provides an overview of Data Warehouse Document and its table definitions.

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
  • Was this article helpful?