Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

Involved

This guide provides an overview of the Custom Object Involved table and its Oracle and MSSQL data types.

The custom object Involved tables include:

  • WH_INVOLVED_XXXX (where XXXX is the unique entity code for a custom object type)
  • WH_INVOLVED_RELATIONS
  • WH_INVOLVED_ROLES
  • WH_INVOLVED_GROUP_ACCESS*
  • WH_INVOLVED_USER_ACCESS*
  • WH_INVOLVED_SECURITY
  • WH_INVOLVED_WORKFLOW
  • WH_INVOLVED_WORKFLOW_HISTORY
  • WH_INVOLVED_WORKFLOW_RECIPIENT
  • WH_INVOVED_WORKFLOW_REVIEW

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

WH_INVOLVED_XXXX

Column Name Oracle Data Type MSSQL Data Type Friendly Column Name
INVOLVED_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Involved Unique Code
INVOLVED_OBJECT_TITLE VARCHAR2(250) VARCHAR(250) Involved Object Title
INVOLVED_PRIMARY_KEY NUMBER INT Involved Primary Key
INVOLVED_ROLE VARCHAR2(50) VARCHAR(50) Involved Role
INVOLVED_ROLE_TREE_POSITION VARCHAR2(250) VARCHAR(250) Involved Role Tree Position
INVOLVED_CONTACT_PK NUMBER INT Involved Contact Primary Key
CONTACT_TYPE VARCHAR2(10) VARCHAR(10) Contact Type
INVOLVED_ACTIVE_DATE DATE DATETIME Involved Active Date
INVOLVED_INACTIVE_DATE DATE DATETIME Involved Inactive Date
INVOLVED_INACTIVE_DATE_KEY NUMBER INT Involved Inactive Date Key
INVOLVED_IS_ACTIVE VARCHAR2(10) VARCHAR(10) Involved Is Active
CONTACT_FIRST_NAME VARCHAR2(50) VARCHAR(50) Contact First Name
CONTACT_MIDDLE_NAME VARCHAR2(50) VARCHAR(50) Contact Middle Name
CONTACT_LAST_FIRST_MID_NAME VARCHAR2(410) VARCHAR2(410) Contact Last First Mid Name
CONTACT_NAME VARCHAR2(250) VARCHAR(250) Contact Name
CONTACT_DEFAULT_CATEGORY VARCHAR2(50) VARCHAR(50) Contact Default Category
CONTACT_CATEGORY_TREE_POSITION VARCHAR2(250) VARCHAR(250) Contact Category Tree Position
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_CATEGORY VARCHAR2(50) VARCHAR(50) Project Category
PROJECT_CATEGORY_TREE_POSITION VARCHAR2(250) VARCHAR(250) Project Category Tree Position
PROJECT_NAME VARCHAR2(250) VARCHAR(250) Project Name
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_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
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_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
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 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
INVOLVED_ACTIVE_DATE_KEY NUMBER INT Involved Active Date Key
INVOVLED_INACTIVE_DATE_KEY NUMBER INT Invovled Inactive Date Key
CREATED_ON_DATE_KEY NUMBER INT Created On Date Key
MODIFIED_ON_DATE_KEY NUMBER INT Modified On Date Key

WH_INVOLVED_RELATIONS

Column Name Oracle Data Type MSSQL Data Type Friendly Column Name
LEFT_INVOLVED_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Left Involved Unique Code
LEFT_INVOLVED_TITLE VARCHAR2(250) VARCHAR(250) Left Involved Title
LEFT_INVOLVED_PRIMARY_KEY NUMBER INT Left Involved Primary Key
LEFT_INVOLVED_DEFAULT_ROLE VARCHAR2(50) VARCHAR(50) Left Involved Default Role
LEFT_INVOLVED_ROLE_TREE VARCHAR2(250) VARCHAR(250) Left Involved Role Tree
LEFT_PROJECT_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Left Project Unique Code
LEFT_PROJECT_TITLE VARCHAR2(250) VARCHAR(250) Left Project Title
LEFT_PROJECT_PRIMARY_KEY NUMBER INT Left Project Primary Key
LEFT_PROJECT_NUMBER VARCHAR2(50) VARCHAR(50) Left Project Number
LEFT_PROJECT_NAME VARCHAR2(250) VARCHAR(250) Left Project Name
LEFT_CONTACT_PRIMARY_KEY NUMBER INT Left Contact Primary Key
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
LEFT_CONTACT_TYPE VARCHAR2(10) VARCHAR(10) Left Contact Type
RELATION_NAME VARCHAR2(50) VARCHAR(50) Relation Name
RELATION_TREE_POSITION VARCHAR2(250) VARCHAR(250) Relation Tree Position
RIGHT_INVOLVED_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Right Involved Unique Code
RIGHT_INVOLVED_TITLE VARCHAR2(250) VARCHAR(250) Right Involved Title
RIGHT_INVOLVED_PRIMARY_KEY NUMBER INT Right Involved Primary Key
RIGHT_INVOLVED_DEFAULT_ROLE VARCHAR2(50) VARCHAR(50) Right Involved Default Role
RIGHT_INVOLVED_ROLE_TREE VARCHAR2(250) VARCHAR(250) Right Involved Role Tree
RIGHT_PROJECT_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Right Project Unique Code
RIGHT_PROJECT_TITLE VARCHAR2(250) VARCHAR(250) Right Project Title
RIGHT_PROJECT_PRIMARY_KEY NUMBER INT Right Project Primary Key
RIGHT_PROJECT_NUMBER VARCHAR2(50) VARCHAR(50) Right Project Number
RIGHT_PROJECT_NAME VARCHAR2(250) VARCHAR(250) Right Project Name
RIGHT_CONTACT_PRIMARY_KEY NUMBER INT Right Contact Primary Key
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
RIGHT_CONTACT_TYPE VARCHAR2(10) VARCHAR(10) Right Contact Type

WH_INVOLVED_ROLES

Column Name Oracle Data Type MSSQL Data Type Friendly Column Name
INVOLVED_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Involved Unique Code
INVOLVED_OBJECT_TITLE VARCHAR2(250) VARCHAR(250) Involved Object Title
INVOLVED_PRIMARY_KEY NUMBER INT Involved Primary Key
INVOLVED_CONTACT_PK NUMBER INT Involved Contact Primary key
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_TYPE VARCHAR2(10) VARCHAR(10) Contact Type
CONTACT_DEFAULT_CATEGORY VARCHAR2(50) VARCHAR(50) Contact Default Category
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
ROLE_NAME VARCHAR2(50) VARCHAR(50) Role Name
ROLE_TREE_POSITION VARCHAR2(250) VARCHAR(250) Role Tree Position
IS_ROLE_MANUALLY_ADDED VARCHAR2(1) VARCHAR(1) Is Role Manually Added
IS_DEFAULT_ROLE VARCHAR2(5) VARCHAR(5) Is Default Role
SECURITY VARCHAR2(10) VARCHAR(10) Security

WH_INVOLVED_GROUP_ACCESS

Column Name Oracle Data Type MSSQL Data Type Friendly Column Name
INVOLVED_PRIMARY_KEY NUMBER INT Involved Primary Key
GROUP_PRIMARY_KEY NUMBER INT Group Primary Key
ALLOW_DENY_IID CHAR(1) CHAR(1) Allow Deny IID
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_INVOLVED_USER_ACCESS

Column Name Oracle Data Type MSSQL Data Type Friendly Column Name
INVOLVED_PRIMARY_KEY NUMBER INT Involved Primary Key
USER_PRIMARY_KEY NUMBER INT Group Primary Key
ALLOW_DENY_IID CHAR(1) CHAR(1) Allow Deny IID
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_INVOLVED_DELTA

Column Name Oracle Data Type MSSQL Data Type Friendly Column Name
PRIMARY_KEY NUMBER INT Primary Key

WH_INVOLVED_SECURITY

Column Name Oracle Data Type MSSQL Data Type Friendly Column Name
INVOLVED_UNIQUE_CODE NVARCHAR2(4) NVARCHAR(4) Involved Unique Code
INVOLVED_PRIMARY_KEY NUMBER INT Involved Primary Key
CREATED_BY_CONTACT_PK NUMBER INT Created By Contact Primary Key
SECURITY NVARCHAR2(10) NVARCHAR(10) Security

WH_INVOLVED_WORKFLOW

Column Name Oracle Data Type MSSQL Data Type Friendly Column Name
INVOLVED_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Involved Unique Code
INVOLVED_OBJECT_TITLE VARCHAR2(250) VARCHAR(250) Involved Object Title
INVOLVED_PRIMARY_KEY NUMBER INT Involved Primary Key
INVOLVED_CONTACT_PK NUMBER INT Involved Contact Primary Key
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_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Project Unique Code
PROJECT_OBJECT_TITLE VARCHAR2(250) VARCHAR(250) Project Object Title
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_TYPE VARCHAR2(7) VARCHAR(7) Contact Type
CONTACT_DEFAULT_CATEGORY VARCHAR2(50) VARCHAR(50) Contact Default Category
WORKFLOW_PRIMARY_KEY NUMBER INT Workflow Primary Key
REQUEST_NAME VARCHAR2(50) VARCHAR(50) Request Name
RULE_SHORT_DESCRIPTION VARCHAR2(50) VARCHAR(50) 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(20) VARCHAR(20) 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_INVOLVED_WORKFLOW_HISTORY

Column Name Oracle Data Type MSSQL Data Type Friendly Column Name
INVOLVED_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Involved Unique Code
INVOLVED_OBJECT_TITLE VARCHAR2(250) VARCHAR(250) Involved Object Title
INVOLVED_PRIMARY_KEY NUMBER INT Involved Primary Key
INVOLVED_CONTACT_PK NUMBER INT Involved Contact Primary Key
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_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Project Unique Code
PROJECT_OBJECT_TITLE VARCHAR2(250) VARCHAR(250) Project Object Title
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_TYPE VARCHAR2(7) VARCHAR(7) Contact Type
CONTACT_DEFAULT_CATEGORY VARCHAR2(50) VARCHAR(50) Contact Default Category
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(20) VARCHAR(20) 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) VARCHAR2(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 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_INVOLVED_WORKFLOW_RECIPIENT

Column Name Oracle Data Type MSSQL Data Type Friendly Column Name
INVOLVED_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Involved Unique Code
INVOLVED_OBJECT_TITLE VARCHAR2(250) VARCHAR(250) Involved Object Title
INVOLVED_PRIMARY_KEY NUMBER INT Involved Primary Key
INVOLVED_CONTACT_PK NUMBER INT Involved Contact Primary Key
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
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_TYPE VARCHAR2(7) VARCHAR(7) Contact Type
CONTACT_DEFAULT_CATEGORY VARCHAR2(50) VARCHAR(50) Contact Default Category
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(20) VARCHAR(20) 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 Mid Name
MODIFIED_BY_CONTACT_FIRST_NAME VARCHAR2(50) VARCHAR2(50) Modified By Contact First Name

WH_INVOLVED_WORKFLOW_REVIEW

Column Name Oracle Data Type MSSQL Data Type Friendly Column Name
INVOLVED_UNIQUE_CODE VARCHAR2(4) VARCHAR(4) Involved Unique Code
INVOLVED_OBJECT_TITLE VARCHAR2(250) VARCHAR(250) Involved Object Title
INVOLVED_PRIMARY_KEY NUMBER INT Involved Primary Key
INVOLVED_CONTACT_PK NUMBER INT Involved Contact Primary Key
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
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_TYPE VARCHAR2(7) VARCHAR(7) Contact Type
CONTACT_DEFAULT_CATEGORY VARCHAR2(50) VARCHAR(50) Contact Default Category
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(20) VARCHAR(20) 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(2000) VARCHAR2(2000) Review Approval Comment
REVIEW_REQUEST_COMMENT VARCHAR2(2000) VARCHAR2(2000) 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
  • Was this article helpful?