Milestone
Note: Although there are several database tables related to Milestone, both in the TeamConnect database and in the Data Warehouse database, the Milestone feature itself has been removed from TeamConnect version 3.0. Thus these tables may contain data from earlier versions, but they will not be refreshed with ongoing data from version 3.0.
The custom object Milestone tables include:
- WH_MILESTONE_XXXX
- WH_MILESTONE_CATEGORIES
- WH_MILESTONE_GROUP_ACCESS*
- WH_MILESTONE_USER_ACCESS*
- WH_MILESTONE_SECURITY
- WH_MILESTONE_WORKFLOW
- WH_MILESTONE_WORKFLOW_HISTORY
- WH_MILESTONE_WORKFLOW_RECEIPNT
- WH_MILESTONE_WORKFLOW_REVIEW
* These tables support the user access and security feature and should not be queried directly.
WH_MILESTONE_XXXX
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
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_COMPLETION_DATE |
DATE |
DATETIME |
Milestone Completion Date |
|
MILESTONE_EXTENSION_DATE |
DATE |
DATETIME |
Milestone Extension Date |
|
MILESTONE_MILESTONE_DATE |
DATE |
DATETIME |
Milestone Milestone Date |
|
MILESTONE_PROJECTED_DATE |
DATE |
DATETIME |
Milestone Projected Date |
|
MILESTONE_STATUS |
VARCHAR2(10) |
VARCHAR(10) |
Milestone Status |
|
MILESTONE_MARK_COMPLETE |
VARCHAR2(3) |
VARCHAR(3) |
Milestone Mark Complete |
|
MILESTONE_COMPLETION_STATUS |
VARCHAR2(3) |
VARCHAR(3) |
Milestone Completion Status |
|
MILESTONE_COMPLETION_PHASE |
VARCHAR2(250) |
VARCHAR(250) |
Milestone Completion Phase |
|
MILESTONE_IS_UNKNOWN |
VARCHAR2(3) |
VARCHAR(3) |
Milestone Is Unknown |
|
MILESTONE_DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
Milestone Default Category |
|
MILESTONE_DEFAULT_CAT_TREE |
VARCHAR2(250) |
VARCHAR(250) |
Milestone Default Category 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_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
Project Category |
|
PROJECT_CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
Project Category Tree Position |
|
DOCUMENT_FOLDER_PRIMARY_KEY |
NUMBER |
INT |
Document Folder Primary Key |
|
CREATED_ON |
DATE |
DATETIME |
Created 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_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Created By Contact First Name |
|
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Created By Contact Middle Name |
|
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Created By Contact Name |
|
BEHALF_OF_CONTACT_PRIMARY_KEY |
NUMBER |
INT |
Behalf Of Contact Primary Key |
|
MODIFIED_ON |
DATE |
DATETIME |
Modified On |
|
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_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Modified By Contact First Name |
|
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Modified By Contact Middle Name |
|
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Modified By Contact Name |
|
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 |
|
MILESTONE_COMPLETION_DATE_KEY |
NUMBER |
INT |
Milestone Completion Date Key |
|
MILESTONE_EXTENSION_DATE_KEY |
NUMBER |
INT |
Milestone Extension Date Key |
|
MILESTONE_MILESTONE_DATE_KEY |
NUMBER |
INT |
Milestone Milestone Date Key |
|
MILESTONE_PROJECTED_DATE_KEY |
NUMBER |
INT |
Milestone Projected Date Key |
|
CREATED_ON_DATE_KEY |
NUMBER |
INT |
Created On Date Key |
|
MODIFIED_ON_DATE_KEY |
NUMBER |
INT |
Modified On Date Key |
| 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 CHAR) | VARCHAR(250) | Last Performer Name |
| LAST_PERFRMR_FIRST_NAME | VARCHAR2(50 CHAR) | VARCHAR(50) | Last Performer First Name |
| LAST_PERFRMR_MIDDLE_NAME | VARCHAR2(50 CHAR) | VARCHAR(50) | Last Performer Middle Name |
| LAST_PERFRMR_TYPE | VARCHAR2(7 CHAR) | VARCHAR(7) | Last Performer Type |
| MULTIPLE_APPROVERS | VARCHAR2(3 CHAR) | VARCHAR(3) | Multiple Approvers |
WH_MILESTONE_CATEGORIES
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
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_MILESTONE_DATE |
DATE |
DATETIME |
Milestone Completion Date |
|
MILESTONE_STATUS |
VARCHAR2(10) |
VARCHAR(10) |
Milestone Status |
|
MILESTONE_COMPLETION_STATUS |
VARCHAR2(3) |
VARCHAR(3) |
Milestone Completion Status |
|
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 |
|
CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Category Name |
|
CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
Category Tree Position |
|
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_MILESTONE_GROUP_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
MILESTONE_PRIMARY_KEY |
NUMBER |
INT |
Milestone 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 |
|
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_MILESTONE_USER_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
MILESTONE_PRIMARY_KEY |
NUMBER |
INT |
Milestone 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 |
|
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_MILESTONE_SECURITY
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
MILESTONE_UNIQUE_CODE |
NVARCHAR2(4) |
NVARCHAR(4) |
Milestone Unique Code |
|
MILESTONE_PRIMARY_KEY |
NUMBER |
INT |
Milestone Primary Key |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
Created by Contact Primary Key |
|
SECURITY |
NVARCHAR2(10) |
NVARCHAR(10) |
Security |
WH_MILESTONE_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
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_MILESTONE_DATE |
DATE |
DATETIME |
Milestone Milestone Date |
|
MILESTONE_STATUS |
VARCHAR2(10) |
VARCHAR(10) |
Milestone Status |
|
MILESTONE_COMPLETION_STATUS |
VARCHAR2(3) |
VARCHAR(3) |
Milestone Completion Status |
|
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 |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
Workflow Primary Key |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Request Name |
| RULE_SHORT_DESCRIPTION | VARCHAR2(250) | VARCHAR(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 Number |
|
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_MILESTONE_WORKFLOW_HISTORY
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
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_MILESTONE_DATE |
DATE |
DATETIME |
Milestone Milestone Date |
|
MILESTONE_STATUS |
VARCHAR2(10) |
VARCHAR(10) |
Milestone Status |
|
MILESTONE_COMPLETION_STATUS |
VARCHAR2(3) |
VARCHAR(3) |
Milestone Completion Status |
|
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 |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
Workflow Primary Key |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Request Name |
| RULE_SHORT_DESCRIPTION | VARCHAR2(250) | VARCHAR(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 Number |
|
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 |
|
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 Middle 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_MILESTONE_WORKFLOW_RECEIPNT
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
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_MILESTONE_DATE |
DATE |
DATETIME |
Milestone Milestone Date |
|
MILESTONE_STATUS |
VARCHAR2(10) |
VARCHAR(10) |
Milestone Status |
|
MILESTONE_COMPLETION_STATUS |
VARCHAR2(3) |
VARCHAR(3) |
Milestone Completion Status |
|
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 |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
Workflow Primary Key |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Request Name |
| RULE_SHORT_DESCRIPTION | VARCHAR2(250) | VARCHAR(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 Number |
|
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 Middle Name |
| MODIFIED_BY_CONTACT_FIRST_NAME | VARCHAR2(50) | VARCHAR(50) | Modified by Contact First Name |
WH_MILESTONE_WORKFLOW_REVIEW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Name Column |
|---|---|---|---|
|
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_MILESTONE_DATE |
DATE |
DATETIME |
Milestone Milestone Date |
|
MILESTONE_STATUS |
VARCHAR2(10) |
VARCHAR(10) |
Milestone Status |
|
MILESTONE_COMPLETION_STATUS |
VARCHAR2(3) |
VARCHAR(3) |
Milestone Completion Status |
|
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 |
|
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 Number |
|
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 |
VARCHAR2(250) |
VARCHAR(250) |
Review Approval Comment |
|
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
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 Middle Name |
| MODIFIED_BY_CONTACT_FIRST_NAME | VARCHAR2(50) | VARCHAR2(50) | Modified by Contact First Name |