Table Detail Report

PFT_WF_ISSUE_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Work Flow Issue Event
Definition: Stores all the events information related to issues/work items.
Table Type: REFERENCE





Column Detail - PFT_WF_ISSUE_EVENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DAY_OF_MONTH DOUBLE N The column has the day of the month on which the event will be processed.
DELAYED_PROCESS_DT_TM DATETIME Y The delayed date and time for a work item.
DELAY_OFFSET_HRS DOUBLE Y Stores the number of hours to delay processing the workflow issue
EVENT_CD DOUBLE N The event code of the event identifying the work item.
EVENT_TYPE_FLAG DOUBLE N Identifies the type of event: 0 - Undefined; 1 - Cancel Event; 2 - Complete Event
PFT_WF_ISSUE_EVENT_ID DOUBLE N Uniquely identifies an event related to issues/work items.
PFT_WF_ISSUE_ID DOUBLE N Uniquely identifies the related work flow issue.
PROCESSING_TYPE_CD DOUBLE N Contains the processing key (asynchonous or synchronous_in_process)
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PFT_WF_ISSUE_EVENT


Child Column in PFT_WF_ISSUE_EVENT(FK) Parent Table Name Parent Column Name
Parents: PFT_WF_ISSUE_ID PFT_WF_ISSUE PFT_WF_ISSUE_ID


PFT_WF_ISSUE_PRIORITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Workflow Issue Priority
Definition: This table stores the information that is needed to determine the work item priority.
Table Type: REFERENCE





Column Detail - PFT_WF_ISSUE_PRIORITY


Column Name Type Null? Definition
ANALYSIS_STATUS_FLAG DOUBLE N The analysis status flag, used to determine the type of update for the analysis.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
IMPACT_LOWER_BOUND_VALUE DOUBLE N This column stores the lower bound value of the data point on the impact graph.
IMPACT_UPPER_BOUND_VALUE DOUBLE N This column stores the upper bound value of the data point on the impact graph.
ORIG_PFT_WF_ISSUE_PRIORITY_ID DOUBLE N Used to track versions of the workflow issue priority information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PFT_WF_ISSUE_ID DOUBLE N Unique generated number that identifies a row on the PFT_WF_ISSUE_ID table.
PFT_WF_ISSUE_PRIORITY_ID DOUBLE N Unique generated number that identifies a row on the PFT_WF_ISSUE_PRIORITY table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
URGENCY_LOWER_BOUND_VALUE DOUBLE N This column stores the lower bound value of the data point on the urgency graph.
URGENCY_UPPER_BOUND_VALUE DOUBLE N This column stores the upper bound value of the data point on the urgency graph.



Relationship Detail - PFT_WF_ISSUE_PRIORITY


Child Column in PFT_WF_ISSUE_PRIORITY(FK) Parent Table Name Parent Column Name
Parents: PFT_WF_ISSUE_ID PFT_WF_ISSUE PFT_WF_ISSUE_ID
ORIG_PFT_WF_ISSUE_PRIORITY_ID PFT_WF_ISSUE_PRIORITY PFT_WF_ISSUE_PRIORITY_ID




Parent Column in PFT_WF_ISSUE_PRIORITY (PK) Child Table Name Child Column Name
Children: PFT_WF_ISSUE_PRIORITY_ID PFT_WF_ISSUE_PRIORITY ORIG_PFT_WF_ISSUE_PRIORITY_ID
PFT_WF_ISSUE_PRIORITY_LT PFT_WF_ISSUE_PRIORITY_ID


PFT_WF_ISSUE_PRIORITY_LT



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Work Flow Issue Priority Long Text
Definition: This table stores the long text information that is needed to determine the work item priority.
Table Type: REFERENCE





Column Detail - PFT_WF_ISSUE_PRIORITY_LT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LONG_TEXT LONGTEXT Y Used to store the information that is used to determine work item priority information.
LONG_TEXT_TYPE_FLAG DOUBLE N Type of long text that this row represents.1 - Impact Raw Long Text2 - Urgency Raw Long Text
ORIG_ISSUE_PRIORITY_LT_ID DOUBLE N Used to track versions of the workflow issue priority long text information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PFT_WF_ISSUE_PRIORITY_ID DOUBLE N Unique generated number that identifies a single row on the PFT_WF_ISSUE_PRIORITY table.
PFT_WF_ISSUE_PRIORITY_LT_ID DOUBLE N Unique generated number that identifies a row on the PFT_WF_ISSUE_PRIORITY_LT table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PFT_WF_ISSUE_PRIORITY_LT


Child Column in PFT_WF_ISSUE_PRIORITY_LT(FK) Parent Table Name Parent Column Name
Parents: PFT_WF_ISSUE_PRIORITY_ID PFT_WF_ISSUE_PRIORITY PFT_WF_ISSUE_PRIORITY_ID
ORIG_ISSUE_PRIORITY_LT_ID PFT_WF_ISSUE_PRIORITY_LT PFT_WF_ISSUE_PRIORITY_LT_ID




Parent Column in PFT_WF_ISSUE_PRIORITY_LT (PK) Child Table Name Child Column Name
Children: PFT_WF_ISSUE_PRIORITY_LT_ID PFT_WF_ISSUE_PRIORITY_LT ORIG_ISSUE_PRIORITY_LT_ID


PFT_WF_NOTIFICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Workflow Norification
Definition: This reference table stores all the application that needs to be notified for a given process model, when work item is identified or transitions to a different state.
Table Type: REFERENCE





Column Detail - PFT_WF_NOTIFICATION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ASSESSMENT_IND DOUBLE N Indicates if the notification needs to be sent to an application if the work item is in the assessment state.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LISTENER_IDENT VARCHAR(250) N Identifier for the listener that will be notified about the work item into and out of state.
PFT_WF_NOTIFICATION_ID DOUBLE N Uniquely identifies a ProFit Workflow Notification
PFT_WF_PROCESS_MODEL_ID DOUBLE N Uniquely identifies the related workflow process model.
PREV_PFT_WF_NOTIFICATION_ID DOUBLE N Used to track versions of the ProFit Workflow Notification information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
RESOLUTION_IND DOUBLE N Indicates if the notification needs to be sent to an application if the work item is in a resolution state.
REVIEW_IND DOUBLE N Indicates if the notification needs to be sent to an application if the work item is in a review state.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PFT_WF_NOTIFICATION


Child Column in PFT_WF_NOTIFICATION(FK) Parent Table Name Parent Column Name
Parents: PREV_PFT_WF_NOTIFICATION_ID PFT_WF_NOTIFICATION PFT_WF_NOTIFICATION_ID
PFT_WF_PROCESS_MODEL_ID PFT_WF_PROCESS_MODEL PFT_WF_PROCESS_MODEL_ID




Parent Column in PFT_WF_NOTIFICATION (PK) Child Table Name Child Column Name
Children: PFT_WF_NOTIFICATION_ID PFT_WF_NOTIFICATION PREV_PFT_WF_NOTIFICATION_ID


PFT_WF_PROCESS_MODEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Workflow Process Model
Definition: Reference table to hold ProFit workflow process models.
Table Type: REFERENCE





Column Detail - PFT_WF_PROCESS_MODEL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
APPROVE_ACTION_CD DOUBLE N Action code defining the approval action.
ASSESSMENT_STATE_CD DOUBLE N Code that defines the workflow state for the assessment.
ASSESSOR_ENTITY_ID DOUBLE N Uniquely identifies the related assessor.
ASSESSOR_ENTITY_NAME VARCHAR(30) N Identifies from which table the assessment comes, personnel or department, etc.
ASSESSOR_TYPE_CD DOUBLE N Type of assessment owner either personnel or department, etc.
BILLING_HOLD_CD DOUBLE N Code defining the billing hold.
CATEGORY_CD DOUBLE N Used to classify workflow model created by the user using category.
COMPLETE_ACTION_CD DOUBLE N Code defining the completion action
DENY_ACTION_CD DOUBLE N Code defining the denial action.
DESCRIPTION_LONG_TEXT_ID DOUBLE N Uniquely identifies the related row in the long_text_reference table that will store the model description.
DYNAMIC_DELAY_CD DOUBLE N The column stores the code of the dynamic delay defined in the codeset. the code value will map CCL script to calculate the dynamic delay.
ENTITY_TYPE_CD DOUBLE N Identifies the entity type to which the model belongs.
INCOMPLETE_ACTION_CD DOUBLE N Action code defining the incompletion action.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PFT_WF_PROCESS_MODEL_ID DOUBLE N Uniquely identifies a given workflow process model.
PROCESS_MODEL_NAME VARCHAR(255) N Name of the workflow process model.
REQ_MAN_ASSIGN_IND DOUBLE N Determines if this process model requires manual assignment of a resolution owner.
RESOLUTION_STATE_CD DOUBLE N Defines the workflow state for the resolution.
RESOLVER_ENTITY_ID DOUBLE N Contains the owner ID of the resolution state.
RESOLVER_ENTITY_NAME VARCHAR(30) N Contains the Name of the table for the resolver, based on the type of resolution. For example: personnel, department, etc.
RESOLVER_TYPE_CD DOUBLE N Contains the type of resolution owner, either personnel, department, etc.
RESOLVE_ACTION_CD DOUBLE N Action Cdoe defining the resolution action.
REVIEWER_ENTITY_ID DOUBLE N Contains the owner id of the review state.
REVIEWER_ENTITY_NAME VARCHAR(30) N Contains the Name of the table for the reviewer, based on the type of review. For example: personnel, department, etc.
REVIEWER_TYPE_CD DOUBLE N Type of reviewer owner either personnel or department, etc.
REVIEW_STATE_CD DOUBLE N Contains the workflow state for the review.
SUBCATEGORY_CD DOUBLE N Used to further classify workflow model inside a category.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
WI_ASSIGNMENT_TYPE_CD DOUBLE Y This column stores the workitem assignment type information.



Relationship Detail - PFT_WF_PROCESS_MODEL


Child Column in PFT_WF_PROCESS_MODEL(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
DESCRIPTION_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in PFT_WF_PROCESS_MODEL (PK) Child Table Name Child Column Name
Children: PFT_WF_PROCESS_MODEL_ID PFT_WF_ISSUE PFT_WF_PROCESS_MODEL_ID
PFT_WF_NOTIFICATION PFT_WF_PROCESS_MODEL_ID
PFT_WF_STATE_ACTION_RELTN PFT_WF_PROCESS_MODEL_ID