Contact

WH_CONTACT

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_PREFIX	VARCHAR2(50)	VARCHAR(50)
CONTACT_SUFFIX	VARCHAR2(50)	VARCHAR(50)
CONTACT_NUMBER	VARCHAR2(50)	VARCHAR(50)
CONTACT_ALIAS	VARCHAR2(250)	VARCHAR(250)
CONTACT_JOB_TITLE	VARCHAR2(250)	VARCHAR(250)
SALUTATION	VARCHAR2(50)	VARCHAR(50)
DRIVER_LICENSE	VARCHAR2(50)	VARCHAR(50)
SOCIAL_SECURITY_OR_TAX_ID	VARCHAR2(50)	VARCHAR(50)
BIRTH_DATE	DATE	DATETIME
COMPANY_CONTACT_PK	NUMBER	INT
COMPANY	VARCHAR2(250)	VARCHAR(250)
ADDRESS_TYPE	VARCHAR2(50)	VARCHAR(50)
STREET	VARCHAR2(250)	VARCHAR(250)
CITY	VARCHAR2(50)	VARCHAR(50)
STATE	VARCHAR2(50)	VARCHAR(50)
ZIP_CODE	VARCHAR2(50)	VARCHAR(50)
COUNTY	VARCHAR2(50)	VARCHAR(50)
COUNTRY	VARCHAR2(50)	VARCHAR(50)
GUIDE_NO	VARCHAR2(50)	VARCHAR(50)
ADDRESS_CURRENT_AS_OF	DATE	DATETIME
PHONE_TYPE	VARCHAR2(50)	VARCHAR(50)
PHONE_NUMBER	VARCHAR2(50)	VARCHAR(50)
FAX_TYPE	VARCHAR2(50)	VARCHAR(50)
FAX_NUMBER	VARCHAR2(50)	VARCHAR(50)
EMAIL_TYPE	VARCHAR2(50)	VARCHAR(50)
EMAIL_ADDRESS	VARCHAR2(250)	VARCHAR(250)
INTERNET_ADDRESS_TYPE	VARCHAR2(50)	VARCHAR(50)
INTERNET_ADDRESS	VARCHAR2(50)	VARCHAR(50)
CONTACT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)
CONTACT_DEFAULT_CATEGORY_TREE	VARCHAR2(250)	VARCHAR(250)
CONTACT_DEFAULT_RATE_VALUE	NUMBER	DECIMAL(28,12)
CURRENCY_NAME	VARCHAR2(50)	VARCHAR(50)
CURRENCY_CODE	VARCHAR2(3)	VARCHAR(3)
CURRENCY_SYMBOL	VARCHAR2(3)	VARCHAR(3)
DOCUMENT_FOLDER_PRIMARY_KEY	NUMBER	INT
CREATED_ON	DATE	DATETIME
MODIFIED_ON	DATE	DATETIME
CREATED_BY_CONTACT_PK	NUMBER	INT
CREATED_BY_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
CREATED_BY_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
MODIFIED_BY_CONTACT_PK	NUMBER	INT
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
BEHALF_OF_CONTACT_PRIMARY_KEY	NUMBER	INT
SECURITY	VARCHAR2(10)	VARCHAR(10)
WORKFLOW_CURRENT_STATUS	VARCHAR2(15)	VARCHAR(15)
WORKFLOW_CURRENT_ACTION	VARCHAR2(50)	VARCHAR(50)
NOTES	CLOB	NTEXT
ADDRESS_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)
EMAIL_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)
FAX_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)
INTERNET_ADDRESS_TYPE_TREE_POS	VARCHAR2(250)	VARCHAR(250)
PHONE_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)
COUNTRY_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)
CURRENT_APPROVER_CONTACT_PK	NUMBER	INT
CURRENT_APPROVER_NAME	VARCHAR2(250)	VARCHAR(250)
CURRENT_APPROVER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CURRENT_APPROVER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CURRENT_APPROVER_TYPE	VARCHAR2(7)	VARCHAR(7)
LAST_PERFRMR_CONTACT_PK	NUMBER	INT
LAST_PERFRMR_NAME	VARCHAR2(250)	VARCHAR(250)
LAST_PERFRMR_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
LAST_PERFRMR_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
LAST_PERFRMR_TYPE	VARCHAR2(7)	VARCHAR(7)
MULTIPLE_APPROVERS	VARCHAR2(3)	VARCHAR(3)
CREATED_ON_DATE_KEY	DATE	DATETIME
MODIFIED_ON_DATE_KEY	DATE	DATETIME

WH_CONTACT_ADDRESSES

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
IS_ADDRESS_CURRENT	NUMBER	INT
ADDRESS_TYPE	VARCHAR2(50)	VARCHAR(50)
STREET	VARCHAR2(250)	VARCHAR(250)
CITY	VARCHAR2(50)	VARCHAR(50)
STATE	VARCHAR2(50)	VARCHAR(50)
ZIP_CODE	VARCHAR2(50)	VARCHAR(50)
COUNTY	VARCHAR2(50)	VARCHAR(50)
COUNTRY	VARCHAR2(50)	VARCHAR(50)
GUIDE_NO	VARCHAR2(50)	VARCHAR(50)
ADDRESS_CURRENT_AS_OF	DATE	DATETIME
IS_DEFAULT_ADDRESS	VARCHAR2(5)	VARCHAR(5)
SECURITY	VARCHAR2(10)	VARCHAR(10)
ADDRESS_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)

WH_CONTACT_CATEGORIES

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
IS_CATEGORY_MANUALLY_ADDED	VARCHAR2(3)	VARCHAR(3)
CATEGORY_NAME	VARCHAR2(50)	VARCHAR(50)
CATEGORY_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)
IS_DEFAULT_CATEGORY	VARCHAR2(5)	VARCHAR(5)
SECURITY	VARCHAR2(10)	VARCHAR(10)

WH_CONTACT_DEFAULT_RATES

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
RATE_AMOUNT	NUMBER	DECIMAL(28,12)
EFFECTIVE_FROM	DATE	DATETIME
EFFECTIVE_TO	DATE	DATETIME
SECURITY	VARCHAR2(10)	VARCHAR(10)

WH_CONTACT_EMAILS

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
EMAIL_TYPE	VARCHAR2(50)	VARCHAR(50)
EMAIL_ADDRESS	VARCHAR2(250)	VARCHAR(250)
IS_DEFAULT_EMAIL	VARCHAR2(5)	VARCHAR(5)
SECURITY	VARCHAR2(10)	VARCHAR(10)
EMAIL_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)

WH_CONTACT_FAXES

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
FAX_TYPE	VARCHAR2(50)	VARCHAR(50)
FAX_NUMBER	VARCHAR2(50)	VARCHAR(50)
IS_DEFAULT_FAX	VARCHAR2(5)	VARCHAR(5)
SECURITY	VARCHAR2(10)	VARCHAR(10)
FAX_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)

WH_CONTACT_GROUP_MEMBERS

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_GROUP_PRIMARY_KEY	NUMBER	INT
CONTACT_GROUP_NAME	VARCHAR2(250)	VARCHAR(250)
CONTACT_GROUP_IS_PUBLIC	VARCHAR2(5)	VARCHAR(5)
CONTACT_GROUP_MEMBER_PK	NUMBER	INT
CONTACT_PRIMARY_KEY	NUMBER	INT
CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
CREATED_ON	DATE	DATETIME
MODIFIED_ON	DATE	DATETIME
CREATED_BY_CONTACT_PK	NUMBER	INT
CREATED_BY_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
CREATED_BY_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
MODIFIED_BY_CONTACT_PK	NUMBER	INT
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)

WH_CONTACT_INTERNET_ADDRESSES

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
INTERNET_ADDRESS_TYPE	VARCHAR2(50)	VARCHAR(50)
INTERNET_ADDRESS	VARCHAR2(50)	VARCHAR(50)
IS_DEFAULT_INTERNET_ADDRESS	VARCHAR2(5)	VARCHAR(5)
SECURITY	VARCHAR2(10)	VARCHAR(10)
INTERNET_ADDRESS_TYPE_TREE_POS	VARCHAR2(250)	VARCHAR(250)

WH_CONTACT_PHONES

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
CONTACT_PHONE	VARCHAR2(50)	VARCHAR(50)
CONTACT_PHONE_TYPE	VARCHAR2(50)	VARCHAR(50)
IS_DEFAULT_PHONE	VARCHAR2(5)	VARCHAR(5)
SECURITY	VARCHAR2(10)	VARCHAR(10)
CONTACT_PHONE_TYPE_TREE_POS	VARCHAR2(250)	VARCHAR(250)

WH_CONTACT_RATES

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
RATE_AMOUNT	NUMBER	DECIMAL(28,12)
EFFECTIVE_FROM	DATE	DATETIME
EFFECTIVE_TO	DATE	DATETIME
TASK_CATEGORY_NAME	VARCHAR2(50)	VARCHAR(50)
TASK_CATEGORY_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)
SECURITY	VARCHAR2(10)	VARCHAR(10)

WH_CONTACT_RELATIONS

Column Name	Oracle Data Type	MSSQL Data Type
LEFT_CONTACT_PRIMARY_KEY	NUMBER	INT
LEFT_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)
LEFT_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
LEFT_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
LEFT_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
RELATION_NAME	VARCHAR2(50)	VARCHAR(50)
RELATION_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)
RIGHT_CONTACT_PRIMARY_KEY	NUMBER	INT
RIGHT_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)
RIGHT_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
RIGHT_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
RIGHT_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)

WH_CONTACT SKILLS

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
LEVEL_OF_EXPERTISE	NUMBER	INT
SKILL_TYPE	VARCHAR2(50)	VARCHAR(50)
SECURITY	VARCHAR2(10)	VARCHAR(10)

WH_CONTACT_TERRITORIES

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
TERRITORY	VARCHAR2(50)	VARCHAR(50)
SECURITY	VARCHAR2(10)	VARCHAR(10)

WH_CONTACT_GROUP_ACCESS

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
GROUP_PRIMARY_KEY	NUMBER	INT
ALLOW_DENY_IID	CHAR(1)	CHAR(1)
OPERATION_IID	NUMBER	INT
IS_MANUAL	NUMBER	INT
VERSION	NUMBER	INT

WH_CONTACT_USER_ACCESS

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
USER_PRIMARY_KEY	NUMBER	INT
ALLOW_DENY_IID	CHAR(1)	CHAR(1)
OPERATION_IID	NUMBER	INT
IS_MANUAL	NUMBER	INT
VERSION	NUMBER	INT

WH_CONTACT_SECURITY

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
CREATED_BY_CONTACT_PK	NUMBER	INT
SECURITY	NVARCHAR2(10)	NVARCHAR(10)

WH_CONTACT_WORKFLOW

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
WORKFLOW_PRIMARY_KEY	NUMBER	INT
REQUEST_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_CONTACT_PK	NUMBER	INT
REQUESTED_BY_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_NAME	VARCHAR2(250)	VARCHAR(250)
REQUESTED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
REQUESTED_ON	DATE	DATETIME
COMPLETED_ON	DATE	DATETIME
WORKFLOW_STATUS	VARCHAR2(30)	VARCHAR(30)
COMMENT_TO_REQUESTOR	VARCHAR2(2000)	VARCHAR(2000)
EXPIRES_ON	DATE	DATETIME
EXPIRE_ACTION	VARCHAR2(30)	VARCHAR(30)
TRANSACTION_STATUS	VARCHAR2(250)	VARCHAR(250)
CURRENT_STOP_NO	NUMBER	INT
REJECT_ACTION	VARCHAR2(30)	VARCHAR(30)
REJECT_REASON	VARCHAR2(50)	VARCHAR(50)
UPDATE_WHILE_PENDING	VARCHAR2(105)	VARCHAR(105)
PROCESS_MANAGER_CONTACT_PK	NUMBER	INT
PROCESS_MANAGER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
PROCESS_MANAGER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
PROCESS_MANAGER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
PROCESS_MANAGER_NAME	VARCHAR2(250)	VARCHAR(250)
STOP_MEMBER_PRIMARY_KEY	NUMBER	INT
STOP_PRIMARY_KEY	NUMBER	INT
STOP	NUMBER	INT
PERFORMER_CONTACT_PK	NUMBER	INT
PERFORMER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
PERFORMER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
PERFORMER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
PERFORMER_NAME	VARCHAR2(250)	VARCHAR(250)
STOP_STATUS	VARCHAR2(40)	VARCHAR(40)
ACTION_DATE	DATE	DATETIME
STOP_EXPIRATION_DATE	DATE	DATETIME
INTERNAL_COMMENT	VARCHAR2(2000)	VARCHAR(2000)
EMAIL_SENT	VARCHAR2(3)	VARCHAR(3)
CREATED_BY_CONTACT_PK	NUMBER	INT
CREATED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
CREATED_BY_CONTACT_MIDDLE_NA ME	VARCHAR2(50)	VARCHAR(50)
CREATED_BY_CONTACT_FIRST_NAM E	VARCHAR2(50)	VARCHAR(50)
CREATED_ON	DATE	DATETIME
MODIFIED_BY_CONTACT_PK	NUMBER	INT
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
MODIFIED_BY_CONTACT_MID_NAM E	VARCHAR2(50)	VARCHAR(50)
MODIFIED_BY_CONTACT_FIRST_NA ME	VARCHAR2(50)	VARCHAR(50)
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
MODIFIED_ON	DATE	DATETIME

WH_CONTACT_WORKFLOW_HISTORY

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
WORKFLOW_PRIMARY_KEY	NUMBER	INT
REQUEST_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_CONTACT_PK	NUMBER	INT
REQUESTED_BY_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_NAME	VARCHAR2(250)	VARCHAR(250)
REQUESTED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
REQUESTED_ON	DATE	DATETIME
COMPLETED_ON	DATE	DATETIME
WORKFLOW_STATUS	VARCHAR2(30)	VARCHAR(30)
COMMENT_TO_REQUESTOR	VARCHAR2(2000)	VARCHAR(2000)
EXPIRES_ON	DATE	DATETIME
EXPIRE_ACTION	VARCHAR2(30)	VARCHAR(30)
TRANSACTION_STATUS	VARCHAR2(250)	VARCHAR(250)
CURRENT_STOP_NO	NUMBER	INT
REJECT_ACTION	VARCHAR2(30)	VARCHAR(30)
REJECT_REASON	VARCHAR2(50)	VARCHAR(50)
UPDATE_WHILE_PENDING	VARCHAR2(105)	VARCHAR(105)
PROCESS_MANAGER_CONTACT_PK	NUMBER	INT
PROCESS_MANAGER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
PROCESS_MANAGER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
PROCESS_MANAGER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
PROCESS_MANAGER_NAME	VARCHAR2(250)	VARCHAR(250)
STOP_MEMBER_PRIMARY_KEY	NUMBER	INT
STOP_PRIMARY_KEY	NUMBER	INT
STOP	NUMBER	INT
PERFORMER_CONTACT_PK	NUMBER	INT
PERFORMER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
PERFORMER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
PERFORMER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
PERFORMER_NAME	VARCHAR2(250)	VARCHAR(250)
ACTIVITY	VARCHAR2(250)	VARCHAR(250)
ACTION_DATE	DATE	DATETIME
INTERNAL_COMMENT	VARCHAR2(2000)	VARCHAR(2000)
CREATED_BY_CONTACT_PK	NUMBER	INT
CREATED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
CREATED_BY_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CREATED_ON	DATE	DATETIME
MODIFIED_BY_CONTACT_PK	NUMBER	INT
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
MODIFIED_ON	DATE	DATETIME

WH_CONTACT_WORKFLOW_RECIPIENT

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
WORKFLOW_PRIMARY_KEY	NUMBER	INT
REQUEST_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_CONTACT_PK	NUMBER	INT
REQUESTED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
REQUESTED_BY_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_NAME	VARCHAR2(250)	VARCHAR(250)
REQUESTED_ON	DATE	DATETIME
COMPLETED_ON	DATE	DATETIME
WORKFLOW_STATUS	VARCHAR2(30)	VARCHAR(30)
EXPIRES_ON	DATE	DATETIME
CURRENT_STOP_NO	NUMBER	INT
PROCESS_MANAGER_CONTACT_PK	NUMBER	INT
PROCESS_MANAGER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
PROCESS_MANAGER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
PROCESS_MANAGER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
PROCESS_MANAGER_NAME	VARCHAR2(250)	VARCHAR(250)
EVENT	VARCHAR2(250)	VARCHAR2(250)
RECIPIENT_CONTACT_PK	NUMBER	INT
RECIPIENT_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)
RECIPIENT_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)
RECIPIENT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR2(50)
RECIPIENT_NAME	VARCHAR2(250)	VARCHAR2(250)
VERSION	NUMBER	INT
CREATED_ON	DATE	DATETIME
CREATED_BY_CONTACT_PK	NUMBER	INT
CREATED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR2(250)
CREATED_BY_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR2(50)
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)
MODIFIED_ON	DATE	DATETIME
MODIFIED_BY_CONTACT_PK	NUMBER	INT
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR2(250)
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR2(50)

WH_CONTACT_WORKFLOW_REVIEW

Column Name	Oracle Data Type	MSSQL Data Type
CONTACT_PRIMARY_KEY	NUMBER	INT
CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
WORKFLOW_PRIMARY_KEY	NUMBER	INT
REQUEST_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_CONTACT_PK	NUMBER	INT
REQUESTED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
REQUESTED_BY_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
REQUESTED_BY_NAME	VARCHAR2(250)	VARCHAR(250)
REQUESTED_ON	DATE	DATETIME
COMPLETED_ON	DATE	DATETIME
WORKFLOW_STATUS	VARCHAR2(30)	VARCHAR(30)
EXPIRES_ON	DATE	DATETIME
CURRENT_STOP_NO	NUMBER	INT
PROCESS_MANAGER_CONTACT_PK	NUMBER	INT
PROCESS_MANAGER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
PROCESS_MANAGER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
PROCESS_MANAGER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
PROCESS_MANAGER_NAME	VARCHAR2(250)	VARCHAR(250)
STOP_PRIMARY_KEY	NUMBER	INT
STOP	NUMBER	INT
STOP_MEMBER_PRIMARY_KEY	NUMBER	INT
STOP_STATUS	VARCHAR2(40)	VARCHAR(40)
EMAIL_SENT	VARCHAR2(3)	VARCHAR(3)
REVIEW_PRIMARY_KEY	NUMBER	INT
REVIEW_PERFORMER_CONTACT_PK	NUMBER	INT
REVIEW_PERFORMER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
REVIEW_PERFORMER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
REVIEW_PERFORMER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
REVIEW_PERFORMER_NAME	VARCHAR2(250)	VARCHAR(250)
REVIEW_STATUS	VARCHAR2(20)	VARCHAR(20)
REVIEW_ACTION_DATE	DATE	DATETIME
REVIEW_APPROVAL_COMMENT	VARCHAR2(250)	VARCHAR(250)
REVIEW_REQUEST_COMMENT	VARCHAR2(250)	VARCHAR(250)
CREATED_ON	DATE	DATETIME
CREATED_BY_CONTACT_PK	NUMBER	INT
CREATED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
CREATED_BY_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)
MODIFIED_ON	DATE	DATETIME
MODIFIED_BY_CONTACT_PK	NUMBER	INT
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)