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 |