Document

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