Contact
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_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) |