Show/Hide Toolbars

The system object Contact tables include:

WH_CONTACT

WH_CONTACT_ADDRESSES

WH_CONTACT_CATEGORIES

WH_CONTACT_DEFAULT_RATES

WH_CONTACT_EMAILS

WH_CONTACT_FAXES

WH_CONTACT_GROUP_MEMBERS

WH_CONTACT_INTERNET_ADDRESSES

WH_CONTACT_PHONES

WH_CONTACT_RATES

WH_CONTACT_RELATIONS

WH_CONTACT_SKILLS

WH_CONTACT_TERRITORIES

WH_CONTACT_GROUP_ACCESS*

WH_CONTACT_USER_ACCESS*

WH_CONTACT_SECURITY

WH_CONTACT_WORKFLOW

WH_CONTACT_WORKFLOW_HISTORY

WH_CONTACT_WORKFLOW_RECIPIENT

WH_CONTACT_WORKFLOW_REVIEW

* These tables support the user access and security feature and should not be queried directly.

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_TYP E

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_NA ME

VARCHAR2(50)

VARCHAR2(50)

CREATED_BY_CONTACT_FIRST_NAM E

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_NAM E

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_TYP E

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_TY PE

VARCHAR2(7)

VARCHAR(7)

REVIEW_PERFORMER_FIRST_NAME

VARCHAR2(50)

VARCHAR(50)

REVIEW_PERFORMER_MIDDLE_NAM E

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_NA ME

VARCHAR2(50)

VARCHAR(50)

CREATED_BY_CONTACT_FIRST_NAM E

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_NAM E

VARCHAR2(50)

VARCHAR(50)

MODIFIED_BY_CONTACT_FIRST_NA ME

VARCHAR2(50)

VARCHAR(50)