Table Detail Report

PFT_RULE_TABLE_QUAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Rule Table Qualification
Definition: This table contains qualification information for tables that are built from pft_rule_maint. These tables are uses to query data that pertains to the particular claim that is being generated.
Table Type: REFERENCE





Column Detail - PFT_RULE_TABLE_QUAL


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CONDITIONAL_CD DOUBLE N Conditional logic to be applied for the qualification (i.e. AND, OR, etc.)
PRIORITY_SEQ DOUBLE N Priority of each qualification establishing order of sequence.
QUALIFIER_CD DOUBLE N Qualifier predicate to be used in qualification (i.e. =, <, >, etc.)
QUAL_FIELD_NAME VARCHAR(100) N Name of field to be used on left side of qualifier predicate
QUAL_TABLE_NAME VARCHAR(100) N Table to be used on left side of qualifier predicate
RULE_GROUP_ID DOUBLE N Identifies the information concerning the grouping of qualifications on PFT_RULE_GROUP
TABLE_QUAL_ID DOUBLE N Identifies qualification information for tables built from the pft_rule_maint. Tables are used to query data pertaining to particular claims being generated.
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.
VALUE_DISP VARCHAR(100) Y String constant value to be used on right side of qualifier predicate
VALUE_FIELD_NAME VARCHAR(100) Y Name of field to be used on left side of qualifier predicate.
VALUE_NUMERIC DOUBLE Y Numeric constant value to be used on right side of qualifier
VALUE_TABLE_NAME VARCHAR(100) Y Table to be used on left side of qualifier predicate.
VALUE_TYPE_FLAG DOUBLE Y Type of value to be used on right side of qualifier predicate. 1- string value (uses the value_disp field), 2 - numeric value (uses the value_numeric field), 3 - table/field value ( uses the value_tablename and value_fieldname), 4 - date value ( uses the value_disp field)



Relationship Detail - PFT_RULE_TABLE_QUAL


Child Column in PFT_RULE_TABLE_QUAL(FK) Parent Table Name Parent Column Name
Parents: RULE_GROUP_ID PFT_RULE_GROUP GROUP_ID


PFT_WF_DEPARTMENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Workflow Department Relationship
Definition: This table holds the type of department for Patient Accounting workflow.
Table Type: REFERENCE





Column Detail - PFT_WF_DEPARTMENT_RELTN


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.
DEPARTMENT_ID DOUBLE N Unique number that identifies the related department.
DEPARTMENT_OWNER_ID DOUBLE N Uniquely identifies the related owner of the department.
DEPARTMENT_TYPE_CD DOUBLE N Identifies the specific department type.
PFT_WF_DEPARTMENT_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the PFT_WF_DEPARTMENT_RELTN 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_DEPARTMENT_RELTN


Child Column in PFT_WF_DEPARTMENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: DEPARTMENT_OWNER_ID PRSNL PERSON_ID
DEPARTMENT_ID PRSNL_GROUP PRSNL_GROUP_ID


PFT_WF_HIST_REMINDER_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Work Flow History Reminder Relationship
Definition: Stores information about a work item escalation/reminder.
Table Type: ACTIVITY





Column Detail - PFT_WF_HIST_REMINDER_RELTN


Column Name Type Null? Definition
CREATED_DT_TM DATETIME N The time the reminder was enqueued.
DUE_DT_TM DATETIME N The time that the reminder is intended to be sent out.
PFT_QUEUE_ITEM_WF_HIST_ID DOUBLE N References the pft_queue_item_wf_hist row that is/was active when the reminder was sent.
PFT_WF_HIST_REMINDER_RELTN_ID DOUBLE N Uniquely identifies information about a work item escalation/reminder
PFT_WF_ISSUE_CRITERIA_ID DOUBLE N References the pft_wf_issue_criteria that defines the reminder options for the work item (at the time this reminder was sent)
PRSNL_ID DOUBLE N The personnel who received the reminder, or 0 if the reminder hasn't been sent yet.
RECIPIENT_TYPE_FLAG DOUBLE N The recipient of the reminder, which indicates who the reminder will be sent to relative to the work item.
REMINDER_TYPE_FLAG DOUBLE N The method of sending the reminder (via Discern Notify or a work item).
SENT_DT_TM DATETIME Y The time the reminder was sent out, or null if it hasn't been sent yet.
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.
WORKFLOW_STATE_FLAG DOUBLE N The state of the work item that the reminder is sent out on (assessment, resolution, review). 0 - Assessment; 1 - Resolution; 2 - Review; 3 - Manual



Relationship Detail - PFT_WF_HIST_REMINDER_RELTN


Child Column in PFT_WF_HIST_REMINDER_RELTN(FK) Parent Table Name Parent Column Name
Parents: PFT_QUEUE_ITEM_WF_HIST_ID PFT_QUEUE_ITEM_WF_HIST PFT_QUEUE_ITEM_WF_HIST_ID
PFT_WF_ISSUE_CRITERIA_ID PFT_WF_ISSUE_CRITERIA PFT_WF_ISSUE_CRITERIA_ID
PRSNL_ID PRSNL PERSON_ID


PFT_WF_ISSUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Workflow Issue
Definition: Contains workflow issue definitions.
Table Type: REFERENCE





Column Detail - PFT_WF_ISSUE


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALIAS VARCHAR(100) N Alias used to find issues.
ALIAS_KEY VARCHAR(100) N Searcheable key value of the alias column. Contains all caps and no special characters.
APPROVE_ACTION_CD DOUBLE N Action code defining the approval action.
AUTO_RESOLVE_ACTION_ID DOUBLE N *** obsolete - no longer being used ***Identifier of the action stored on the long_blob_reference table that symbolizes the action to be taken when an issue is assigned to the resolution state.
BILLING_HOLD_CD DOUBLE N Billing Hold to be applied when an issue is logged.
COMPLETE_ACTION_CD DOUBLE N Action code defining the completion
DENY_ACTION_CD DOUBLE N Action code defining the denial action.
DISPLAY VARCHAR(100) N Display value depicting what the issue represents.
DISPLAY_KEY VARCHAR(100) N Searchable key value of the display column. This column will contain all caps and no special characters.
EVENT_DEFINITION_ID DOUBLE N Uniquely identifies a reference to the JSON definition for the system event associated to this issue.
INCOMPLETE_ACTION_CD DOUBLE N Action code defining the incompletion action
ISSUE_CD DOUBLE N Codified issue from various data sources.
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.
LONG_TEXT_ID DOUBLE N Uniquely identifies the related issue description.
MODEL_CD DOUBLE N Uniquely identifies the workflow model to which the issue belongs.
ORGANIZATION_ID DOUBLE N Uniquely identifies the organization for which the issue is defined. If it is zero, it implies it is a system default issue definition.
PFT_WF_ISSUE_ID DOUBLE N Uniquely identifies a workflow issue.
PFT_WF_PROCESS_MODEL_ID DOUBLE N Uniquely Identifies the related workflow process model.
PRODUCTIVITY_IND DOUBLE N Indicates if Productivity Weight is set
PRODUCTIVITY_WEIGHT_NBR DOUBLE N Productivity Weight for the Work Item
RESOLVE_ACTION_CD DOUBLE N Action code defining the resolution action.
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


Child Column in PFT_WF_ISSUE(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
EVENT_DEFINITION_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PFT_WF_PROCESS_MODEL_ID PFT_WF_PROCESS_MODEL PFT_WF_PROCESS_MODEL_ID




Parent Column in PFT_WF_ISSUE (PK) Child Table Name Child Column Name
Children: PFT_WF_ISSUE_ID PFT_QUEUE_ITEM PFT_WF_ISSUE_ID
PFT_QUEUE_ITEM_WF_HIST PFT_WF_ISSUE_ID
PFT_WF_ISSUE_CRITERIA PFT_WF_ISSUE_ID
PFT_WF_ISSUE_EVENT PFT_WF_ISSUE_ID
PFT_WF_ISSUE_PRIORITY PFT_WF_ISSUE_ID
WORK_ITEM_RELTN CHILD_PFT_WF_ISSUE_ID
WORK_ITEM_RELTN PARENT_PFT_WF_ISSUE_ID


PFT_WF_ISSUE_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Workflow Issue Criteria
Definition: Stores reference build data for ProFit workflow issues.
Table Type: REFERENCE





Column Detail - PFT_WF_ISSUE_CRITERIA


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.
CRITERIA_TYPE_CD DOUBLE N Identifies the type of criteria.
PARENT_ENTITY_ID DOUBLE N Uniquely identifies a row on the parent table.
PARENT_ENTITY_NAME VARCHAR(30) N Identifies which entity is the related parent.
PFT_WF_ISSUE_CRITERIA_ID DOUBLE N Uniquely identifies build data for pft workflow issues.
PFT_WF_ISSUE_ID DOUBLE N Uniquely identifies the related workflow issue.
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_ISSUE_CRITERIA


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




Parent Column in PFT_WF_ISSUE_CRITERIA (PK) Child Table Name Child Column Name
Children: PFT_WF_ISSUE_CRITERIA_ID PFT_WF_HIST_REMINDER_RELTN PFT_WF_ISSUE_CRITERIA_ID