Contact

WH_CONTACT

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)	Person Or Company
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_PREFIX	VARCHAR2(50)	VARCHAR(50)	Contact Prefix
CONTACT_SUFFIX	VARCHAR2(50)	VARCHAR(50)	Contact Suffix
CONTACT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Contact Number
CONTACT_ALIAS	VARCHAR2(250)	VARCHAR(250)	Contact Alias
CONTACT_JOB_TITLE	VARCHAR2(250)	VARCHAR(250)	Contact Job Title
SALUTATION	VARCHAR2(50)	VARCHAR(50)	Salutation
DRIVER_LICENSE	VARCHAR2(50)	VARCHAR(50)	Driver License
SOCIAL_SECURITY_OR_TAX_ID	VARCHAR2(50)	VARCHAR(50)	Social Security Or Tax Id
BIRTH_DATE	DATE	DATETIME	Birth Date
COMPANY_CONTACT_PK	NUMBER	INT	Company Contact Primary key
COMPANY	VARCHAR2(250)	VARCHAR(250)	Company
ADDRESS_TYPE	VARCHAR2(50)	VARCHAR(50)	Address Type
STREET	VARCHAR2(250)	VARCHAR(250)	Street
CITY	VARCHAR2(50)	VARCHAR(50)	City
STATE	VARCHAR2(50)	VARCHAR(50)	State
ZIP_CODE	VARCHAR2(50)	VARCHAR(50)	Zip Code
COUNTY	VARCHAR2(50)	VARCHAR(50)	County
COUNTRY	VARCHAR2(50)	VARCHAR(50)	Country
GUIDE_NO	VARCHAR2(50)	VARCHAR(50)	Guide No
ADDRESS_CURRENT_AS_OF	DATE	DATETIME	Address Current As Of
PHONE_TYPE	VARCHAR2(50)	VARCHAR(50)	Phone Type
PHONE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Phone Number
FAX_TYPE	VARCHAR2(50)	VARCHAR(50)	Fax Type
FAX_NUMBER	VARCHAR2(50)	VARCHAR(50)	Fax Number
EMAIL_TYPE	VARCHAR2(50)	VARCHAR(50)	Email Type
EMAIL_ADDRESS	VARCHAR2(250)	VARCHAR(250)	Email Address
INTERNET_ADDRESS_TYPE	VARCHAR2(50)	VARCHAR(50)	Internet Address Type
INTERNET_ADDRESS	VARCHAR2(50)	VARCHAR(50)	Internet Address
CONTACT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Contact Default Category
CONTACT_DEFAULT_CATEGORY_TREE	VARCHAR2(250)	VARCHAR(250)	Contact Default Category Tree
CONTACT_DEFAULT_RATE_VALUE	NUMBER	DECIMAL(28,12)	Contact Default Rate Value
CURRENCY_NAME	VARCHAR2(50)	VARCHAR(50)	Currency Name
CURRENCY_CODE	VARCHAR2(3)	VARCHAR(3)	Currency Code
CURRENCY_SYMBOL	VARCHAR2(3)	VARCHAR(3)	Currency Symbol
DOCUMENT_FOLDER_PRIMARY_KEY	NUMBER	INT	Document Folder Primary Key
CREATED_ON	DATE	DATETIME	Created On
MODIFIED_ON	DATE	DATETIME	Modified 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_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
LAST_FIRST_NAME	VARCHAR2(310)	VARCHAR2(310)	Last First Name
LAST_FIRST_MID_NAME	VARCHAR2(410)	VARCHAR2(410)	Last First Mid Name
FIRST_LAST_NAME	VARCHAR2(310)	VARCHAR2(310)	First Last Name
FIRST_MID_LAST_NAME	VARCHAR2(410)	VARCHAR2(410)	First Mid Last Name
NOTES	CLOB	NTEXT	Notes
ADDRESS_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Address Type Tree Position
EMAIL_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Email Type Tree Position
FAX_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Fax Type Tree Position
INTERNET_ADDRESS_TYPE_TREE_POS	VARCHAR2(250)	VARCHAR(250)	Internet Address Type Tree Position
PHONE_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Phone Type Tree Position
COUNTRY_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Country Tree Position
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
CREATED_ON_DATE_KEY	DATE	DATETIME	Created On Date Key
MODIFIED_ON_DATE_KEY	DATE	DATETIME	Modified On Date Key

WH_CONTACT_ADDRESSES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)	Person Or Company
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
IS_ADDRESS_CURRENT	NUMBER	INT	Is Address Current
ADDRESS_TYPE	VARCHAR2(50)	VARCHAR(50)	Address Type
STREET	VARCHAR2(250)	VARCHAR(250)	Street
CITY	VARCHAR2(50)	VARCHAR(50)	City
STATE	VARCHAR2(50)	VARCHAR(50)	State
ZIP_CODE	VARCHAR2(50)	VARCHAR(50)	Zip Code
COUNTY	VARCHAR2(50)	VARCHAR(50)	County
COUNTRY	VARCHAR2(50)	VARCHAR(50)	Country
COUNTRY_TP	VARCHAR2(250)	VARCHAR(250)	Country Type
GUIDE_NO	VARCHAR2(50)	VARCHAR(50)	Guide No
ADDRESS_CURRENT_AS_OF	DATE	DATETIME	Address Current As Of
IS_DEFAULT_ADDRESS	VARCHAR2(5)	VARCHAR(5)	Is Default Address
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security
ADDRESS_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Address Type Tree Position

WH_CONTACT_CATEGORIES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)	Person Or Company
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
IS_CATEGORY_MANUALLY_ADDED	VARCHAR2(3)	VARCHAR(3)	Is Category Manually Added
CATEGORY_NAME	VARCHAR2(50)	VARCHAR(50)	Category Name
CATEGORY_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Category Tree Position
IS_DEFAULT_CATEGORY	VARCHAR2(5)	VARCHAR(5)	Is Default Category
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security

WH_CONTACT_DEFAULT_RATES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)	Person Or Company
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
RATE_AMOUNT	NUMBER	DECIMAL(28,12)	Rate Amount
EFFECTIVE_FROM	DATE	DATETIME	Effective From
EFFECTIVE_TO	DATE	DATETIME	Effective To
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security
PROJECT_ID	NUMBER	INT	Project Id

WH_CONTACT_EMAILS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)	Person Or Company
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
EMAIL_TYPE	VARCHAR2(50)	VARCHAR(50)	Email Type
EMAIL_ADDRESS	VARCHAR2(250)	VARCHAR(250)	Email Address
IS_DEFAULT_EMAIL	VARCHAR2(5)	VARCHAR(5)	Is Default Email
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security
EMAIL_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Email Type Tree Position

WH_CONTACT_FAXES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)	Person Or Company
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
FAX_TYPE	VARCHAR2(50)	VARCHAR(50)	Fax Type
FAX_NUMBER	VARCHAR2(50)	VARCHAR(50)	Fax Number
IS_DEFAULT_FAX	VARCHAR2(5)	VARCHAR(5)	Is Default Fax
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security
FAX_TYPE_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Fax Type Tree Position

WH_CONTACT_GROUP_MEMBERS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_GROUP_PRIMARY_KEY	NUMBER	INT	Contact Group Primary Key
CONTACT_GROUP_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Group Name
CONTACT_GROUP_IS_PUBLIC	VARCHAR2(5)	VARCHAR(5)	Contact Group Is Public
CONTACT_GROUP_MEMBER_PK	NUMBER	INT	Contact Group Member Primary key
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Contact Type
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
CREATED_ON	DATE	DATETIME	Created On
MODIFIED_ON	DATE	DATETIME	Modified 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_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

WH_CONTACT_INTERNET_ADDRESSES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)	Person Or Company
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
INTERNET_ADDRESS_TYPE	VARCHAR2(50)	VARCHAR(50)	Internet Address Type
INTERNET_ADDRESS	VARCHAR2(50)	VARCHAR(50)	Internet Address
IS_DEFAULT_INTERNET_ADDRESS	VARCHAR2(5)	VARCHAR(5)	Is Default Internet Address
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security
INTERNET_ADDRESS_TYPE_TREE_POS	VARCHAR2(250)	VARCHAR(250)	Internet Address Type Tree Position

WH_CONTACT_PHONES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)	Person Or Company
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
CONTACT_PHONE	VARCHAR2(50)	VARCHAR(50)	Contact Phone
CONTACT_PHONE_TYPE	VARCHAR2(50)	VARCHAR(50)	Contact Phone Type
IS_DEFAULT_PHONE	VARCHAR2(5)	VARCHAR(5)	Is Default Phone
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security
CONTACT_PHONE_TYPE_TREE_POS	VARCHAR2(250)	VARCHAR(250)	Contact Phone Type Tree Position

WH_CONTACT_RATES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)	Person Or Company
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
RATE_AMOUNT	NUMBER	DECIMAL(28,12)	Rate Amount
EFFECTIVE_FROM	DATE	DATETIME	Effective From
EFFECTIVE_TO	DATE	DATETIME	Effective To
TASK_CATEGORY_NAME	VARCHAR2(50)	VARCHAR(50)	Task Category Name
TASK_CATEGORY_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Task Category Tree Position
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security
PROJECT_ID	NUMBER	INT	Project Id

WH_CONTACT_RELATIONS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
LEFT_CONTACT_PRIMARY_KEY	NUMBER	INT	Left Contact Primary Key
LEFT_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Left Contact Type
LEFT_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Left Contact First Name
LEFT_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Left Contact Middle Name
LEFT_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Left Contact Name
RELATION_NAME	VARCHAR2(50)	VARCHAR(50)	Relation Name
RELATION_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Relation Tree Position
RIGHT_CONTACT_PRIMARY_KEY	NUMBER	INT	Right Contact Primary Key
RIGHT_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Right Contact Type
RIGHT_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Right Contact First Name
RIGHT_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Right Contact Middle Name
RIGHT_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Right Contact Name

WH_CONTACT SKILLS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)	Person Or Company
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
LEVEL_OF_EXPERTISE	NUMBER	INT	Level Of Expertise
SKILL_TYPE	VARCHAR2(50)	VARCHAR(50)	Skill Type
SKILL_TYPE_TP	VARCHAR2(250)	VARCHAR(250)	Skill Type Type
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security

WH_CONTACT_TERRITORIES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
PERSON_OR_COMPANY	VARCHAR2(10)	VARCHAR(10)	Person Or Company
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
TERRITORY	VARCHAR2(50)	VARCHAR(50)	Territory
TERRITORY_TP	VARCHAR2(250)	VARCHAR(250)	Territory Type
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security

WH_CONTACT_GROUP_ACCESS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact 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_CONTACT_USER_ACCESS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
USER_PRIMARY_KEY	NUMBER	INT	User 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_CONTACT_SECURITY

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
CREATED_BY_CONTACT_PK	NUMBER	INT	Created By Contact Primary Key
SECURITY	NVARCHAR2(10)	NVARCHAR(10)	Security

WH_CONTACT_WORKFLOW

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Contact Type
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
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_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_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Requested By Contact Type
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)	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_NA ME	VARCHAR2(50)	VARCHAR(50)	Created By Contact Middle Na me
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Created By Contact First Nam e
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_NAM E	VARCHAR2(50)	VARCHAR(50)	Modified By Contact Mid Name
MODIFIED_BY_CONTACT_FIRST_NA ME	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_CONTACT_WORKFLOW_HISTORY

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Contact Type
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
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_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_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Requested By Contact Type
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)	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
ACTIVITY	VARCHAR2(250)	VARCHAR(250)	Activity
DATE_TIME	DATE	DATETIME	Date Time
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 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_CONTACT_WORKFLOW_RECIPIENT

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
CONTACT_PRIMARY_KEY	NUMBER	INT	Contact Primary Key
CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Contact Type
CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Contact Middle Name
CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Contact First Name
CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Contact Name
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