Appointment

WH_APPOINTMENT

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
APPOINTMENT_PRIMARY_KEY	NUMBER	INT	Appointment Primary Key
APPOINTMENT_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Appointment Subject
APPOINTMENT_LOCATION	VARCHAR2(250)	VARCHAR(250)	Appointment Location
APPOINTMENT_AREA	VARCHAR2(50)	VARCHAR(50)	Appointment Area
APPOINTMENT_START_ON	DATE	DATETIME	Appointment Start On
APPOINTMENT_END_ON	DATE	DATETIME	Appointment End On
APPOINTMENT_IS_ALL_DAY	VARCHAR2(4)	VARCHAR(4)	Appointment Is All Day
APPOINTMENT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Appointment Default Category
APPOINTMENT_DEFAULT_CAT_TREE	VARCHAR2(250)	VARCHAR(250)	Appointment Default Cat Tree
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PROJECT_PRIMARY_KEY	NUMBER	INT	Project Primary Key
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Project Default Category
MILESTONE_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Milestone Unique Code
MILESTONE_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Milestone Object Title
MILESTONE_PRIMARY_KEY	NUMBER	INT	Milestone Primary Key
MILESTONE_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Milestone Subject
MILESTONE_DATE	DATE	DATETIME	Milestone Date
MILESTONE_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Milestone Default Category
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
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 Perfrmr Contact Primary Key
LAST_PERFRMR_NAME	VARCHAR2(250)	VARCHAR(250)	Last Perfrmr Name
LAST_PERFRMR_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Last Perfrmr First Name
LAST_PERFRMR_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Last Perfrmr Middle Name
LAST_PERFRMR_TYPE	VARCHAR2(7)	VARCHAR(7)	Last Perfrmr Type
MULTIPLE_APPROVERS	VARCHAR2(3)	VARCHAR(3)	Multiple Approvers
APPOINTMENT_START_ON_DATE_KEY	NUMBER	DATETIME	Appointment Start On Date Key
APPOINTMENT_END_ON_DATE_KEY	NUMBER	DATETIME	Appointment End On Date Key
CREATED_ON_DATE_KEY	NUMBER	DATETIME	Created On Date Key
MODIFIED_ON_DATE_KEY	NUMBER	DATETIME	Modified On Date Key
APPOINTMENT_NOTIFY_STATUS	VARCHAR2(3)	VARCHAR(3)	Appointment Notify Status
APPOINTMENT_REMINDER_ALERT	NUMBER	DATETIME	Appointment Reminder Alert

WH_APPOINTMENT_ATTENDEES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
APPOINTMENT_PRIMARY_KEY	NUMBER	INT	Appointment Primary Key
APPOINTMENT_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Appointment Subject
APPOINTMENT_LOCATION	VARCHAR2(250)	VARCHAR(250)	Appointment Location
APPOINTMENT_AREA	VARCHAR2(50)	VARCHAR(50)	Appointment Area
APPOINTMENT_START_ON	DATE	DATETIME	Appointment Start On
APPOINTMENT_END_ON	DATE	DATETIME	Appointment End On
APPOINTMENT_IS_ALL_DAY	VARCHAR2(4)	VARCHAR(4)	Appointment Is All Day
APPOINTMENT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Appointment Default Category
APPOINTMENT_DEFAULT_CAT_TREE	VARCHAR2(250)	VARCHAR(250)	Appointment Default Cat Tree
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PROJECT_PRIMARY_KEY	NUMBER	INT	Project Primary Key
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Project Default Category
MILESTONE_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Milestone Unique Code
MILESTONE_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Milestone Object Title
MILESTONE_PRIMARY_KEY	NUMBER	INT	Milestone Primary Key
MILESTONE_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Milestone Subject
MILESTONE_DATE	DATE	DATETIME	Milestone Date
MILESTONE_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Milestone Default Category
ATTENDANCE	VARCHAR2(20)	VARCHAR(20)	Attendance
ATTENDANCE_START_ON	DATE	DATETIME	Attendance Start On
ATTENDANCE_END_ON	DATE	DATETIME	Attendance End On
ATTENDEE_CONTACT_PRIMARY_KEY	NUMBER	INT	Attendee Contact Primary Key
ATTENDEE_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Attendee Contact Type
ATTENDEE_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Attendee First Name
ATTENDEE_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Attendee Middle Name
ATTENDEE_NAME	VARCHAR2(250)	VARCHAR(250)	Attendee Name
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security
APPOINTMENT_START_ON_DATE_KEY	NUMBER	DATETIME	Appointment Start On Date Key
APPOINTMENT_END_ON_DATE_KEY	NUMBER	DATETIME	Appointment End On Date Key
ATTENDANCE_START_ON_DATE_KEY	NUMBER	DATETIME	Attendance Start On Date Key
ATTENDANCE_END_ON_DATE_KEY	NUMBER	DATETIME	Attendance End On Date Key

WH_APPOINTMENT_CATEGORIES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
APPOINTMENT_PRIMARY_KEY	NUMBER	INT	Appointment Primary Key
APPOINTMENT_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Appointment Subject
APPOINTMENT_AREA	VARCHAR2(50)	VARCHAR(50)	Appointment Area
APPOINTMENT_START_ON	DATE	DATETIME	Appointment Start On
APPOINTMENT_END_ON	DATE	DATETIME	Appointment End On
APPOINTMENT_IS_ALL_DAY	VARCHAR2(4)	VARCHAR(4)	Appointment Is All Day
APPOINTMENT_LOCATION	VARCHAR2(250)	VARCHAR(250)	Appointment Location
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PROJECT_PRIMARY_KEY	NUMBER	INT	Project Primary Key
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Project Default Category
MILESTONE_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Milestone Unique Code
MILESTONE_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Milestone Object Title
MILESTONE_PRIMARY_KEY	NUMBER	INT	Milestone Primary Key
MILESTONE_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Milestone Subject
MILESTONE_DATE	DATE	DATETIME	Milestone Date
MILESTONE_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Milestone Default Category
APPOINTMENT_CATEGORY_NAME	VARCHAR2(50)	VARCHAR(50)	Appointment Category Name
APPOINTMENT_CATEGORY_TREE	VARCHAR2(250)	VARCHAR(250)	Appointment Category Tree
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_APPOINTMENT_RESOURCES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
APPOINTMENT_PRIMARY_KEY	NUMBER	INT	Appointment Primary Key
APPOINTMENT_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Appointment Subject
APPOINTMENT_LOCATION	VARCHAR2(250)	VARCHAR(250)	Appointment Location
APPOINTMENT_AREA	VARCHAR2(50)	VARCHAR(50)	Appointment Area
APPOINTMENT_START_ON	DATE	DATETIME	Appointment Start On
APPOINTMENT_END_ON	DATE	DATETIME	Appointment End On
APPOINTMENT_IS_ALL_DAY	VARCHAR2(4)	VARCHAR(4)	Appointment Is All Day
APPOINTMENT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Appointment Default Category
APPOINTMENT_DEFAULT_CAT_TREE	VARCHAR2(250)	VARCHAR(250)	Appointment Default Cat Tree
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PROJECT_PRIMARY_KEY	NUMBER	INT	Project Primary Key
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Project Default Category
MILESTONE_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Milestone Unique Code
MILESTONE_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Milestone Object Title
MILESTONE_PRIMARY_KEY	NUMBER	INT	Milestone Primary Key
MILESTONE_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Milestone Subject
MILESTONE_DATE	DATE	DATETIME	Milestone Date
MILESTONE_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Milestone Default Category
RESOURCE_NAME	VARCHAR2(50)	VARCHAR(50)	Resource Name
RESOURCE_START_ON	DATE	DATETIME	Resource Start On
RESOURCE_END_ON	DATE	DATETIME	Resource End On
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security

WH_APPOINTMENT_GROUP_ACCESS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
APPOINTMENT_PRIMARY_KEY	NUMBER	INT	Appointment Primary Key
GROUP_PRIMARY_KEY	NUMBER	INT	Group Primary Key
ALLOW_DENY_IID	CHAR(1)	CHAR(1)	Allow Deny Identifier
IS_DELETE	NUMBER	INT	Is Deleted
OPERATION_IID	NUMBER	INT	Operation Identifier
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_APPOINTMENT_USER_ACCESS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
APPOINTMENT_PRIMARY_KEY	NUMBER	INT	Appointment Primary Key
USER_PRIMARY_KEY	NUMBER	INT	User Primary Key
ALLOW_DENY_IID	CHAR(1)	CHAR(1)	Allow Deny Identifier
IS_DELETE	NUMBER	INT	Is Deleted
OPERATION_IID	NUMBER	INT	Operation Identifier
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_APPOINTMENT_SECURITY

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

WH_APPOINTMENT_WORKFLOW

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
APPOINTMENT_PRIMARY_KEY	NUMBER	INT	Appointment Primary Key
APPOINTMENT_SUBJECT	VARCHAR2(250)	VARCHAR2(250)	Appointment Subject
APPOINTMENT_LOCATION	VARCHAR2(250)	VARCHAR2(250)	Appointment Location
APPOINTMENT_AREA	VARCHAR2(50)	VARCHAR2(50)	Appointment Area
APPOINTMENT_START_ON	DATE	DATETIME	Appointment Start On
APPOINTMENT_END_ON	DATE	DATETIME	Appointment End On
APPOINTMENT_IS_ALL_DAY	VARCHAR2(1)	VARCHAR2(1)	Appointment Is All Day
APPOINTMENT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR2(50)	Appointment Default Category
APPOINTMENT_DEFAULT_CAT_TREE	VARCHAR2(250)	VARCHAR(250)	Appointment Default Cat Tree
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PROJECT_PRIMARY_KEY	NUMBER	INT	Project Primary Key
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Project Default Category
MILESTONE_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Milestone Unique Code
MILESTONE_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Milestone Object Title
MILESTONE_PRIMARY_KEY	NUMBER	INT	Milestone Primary Key
MILESTONE_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Milestone Subject
MILESTONE_DATE	DATE	DATETIME	Milestone Date
MILESTONE_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Milestone Default Category
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_APPOINTMENT_WORKFLW_HISTORY

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
APPOINTMENT_PRIMARY_KEY	NUMBER	INT	Appointment Primary Key
APPOINTMENT_SUBJECT	VARCHAR2(250)	VARCHAR2(250)	Appointment Subject
APPOINTMENT_LOCATION	VARCHAR2(250)	VARCHAR2(250)	Appointment Location
APPOINTMENT_AREA	VARCHAR2(50)	VARCHAR2(50)	Appointment Area
APPOINTMENT_START_ON	DATE	DATETIME	Appointment Start On
APPOINTMENT_END_ON	DATE	DATETIME	Appointment End On
APPOINTMENT_IS_ALL_DAY	VARCHAR2(1)	VARCHAR2(1)	Appointment Is All Day
APPOINTMENT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR2(50)	Appointment Default Category
APPOINTMENT_DEFAULT_CAT_TREE	VARCHAR2(250)	VARCHAR(250)	Appointment Default Cat Tree
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PROJECT_PRIMARY_KEY	NUMBER	INT	Project Primary Key
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Project Default Category
MILESTONE_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Milestone Unique Code
MILESTONE_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Milestone Object Title
MILESTONE_PRIMARY_KEY	NUMBER	INT	Milestone Primary Key
MILESTONE_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Milestone Subject
MILESTONE_DATE	DATE	DATETIME	Milestone Date
MILESTONE_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Milestone Default Category
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	NUMBER	NUMBER	Stop
PERFORMER_CONTACT_PK	NUMBERN	NUMBER	Performer Contact Primary Key
PERFORMER_CONTACT_TYPE	NVARCHAR2(7 CHAR)	VARCHAR(7)	Performer Contact Type
PERFORMER_FIRST_NAME	NVARCHAR2(50 CHAR)	VARCHAR2(50)	Performer First Name
PERFORMER_MIDDLE_NAME	NVARCHAR2(50 CHAR)	VARCHAR2(50)	Performer Middle Name
PERFORMER_NAME	NVARCHAR2(250 CHAR)	VARCHAR2(250)	Performer Name
ACTIVITY	VARCHAR2(250)	VARCHAR(250)	Activity
DATE_TIME	DATE		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_APPOINTMENT_WORKFLW_RECEPNT

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
APPOINTMENT_PRIMARY_KEY	NUMBER	INT	Appointment Primary Key
APPOINTMENT_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Appointment Subject
APPOINTMENT_LOCATION	VARCHAR2(250)	VARCHAR(250)	Appointment Location
APPOINTMENT_AREA	VARCHAR2(50)	VARCHAR(50)	Appointment Area
APPOINTMENT_START_ON	DATE	DATETIME	Appointment Start On
APPOINTMENT_END_ON	DATE	DATETIME	Appointment End On
APPOINTMENT_IS_ALL_DAY	VARCHAR2(1)	VARCHAR(1)	Appointment Is All Day
APPOINTMENT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Appointment Default Category
APPOINTMENT_DEFAULT_CAT_TREE	VARCHAR2(250)	VARCHAR(250)	Appointment Default Cat Tree
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PROJECT_PRIMARY_KEY	NUMBER	INT	Project Primary Key
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Project Default Category
MILESTONE_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Milestone Unique Code
MILESTONE_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Milestone Object Title
MILESTONE_PRIMARY_KEY	NUMBER	INT	Milestone Primary Key
MILESTONE_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Milestone Subject
MILESTONE_DATE	DATE	DATETIME	Milestone Date
MILESTONE_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Milestone Default Category
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
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	NVARCHAR2(20 CHAR)	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	NVARCHAR2(50 CHAR)	VARCHAR2(50)	Modified By Contact First Name

WH_APPOINTMENT_WORKFLOW_REVIEW

Column Name	Oracle Data Type	MSSQL Data Type	Column Name
APPOINTMENT_PRIMARY_KEY	NUMBER	INT	Appointment Primary Key
APPOINTMENT_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Appointment Subject
APPOINTMENT_LOCATION	VARCHAR2(250)	VARCHAR(250)	Appointment Location
APPOINTMENT_AREA	VARCHAR2(50)	VARCHAR(50)	Appointment Area
APPOINTMENT_START_ON	DATE	DATETIME	Appointment Start On
APPOINTMENT_END_ON	DATE	DATETIME	Appointment End On
APPOINTMENT_IS_ALL_DAY	VARCHAR2(1)	VARCHAR(1)	Appointment Is All Day
APPOINTMENT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Appointment Default Category
APPOINTMENT_DEFAULT_CAT_TREE	VARCHAR2(250)	VARCHAR(250)	Appointment Default Cat Tree
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PROJECT_PRIMARY_KEY	NUMBER	INT	Project Primary Key
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Project Default Category
MILESTONE_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Milestone Unique Code
MILESTONE_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Milestone Object Title
MILESTONE_PRIMARY_KEY	NUMBER	INT	Milestone Primary Key
MILESTONE_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Milestone Subject
MILESTONE_DATE	DATE	DATETIME	Milestone Date
MILESTONE_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Milestone Default Category
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
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	NVARCHAR2(2000 CHAR)	VARCHAR(250)	Review Approval Comment
REVIEW_REQUEST_COMMENT	NVARCHAR2(2000 CHAR)	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