Table Detail Report

PFT_CM_ERROR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Accounting Cerner Contract Management Error
Definition: Stores a list of Cerner Contract Management error for a bill record.
Table Type: ACTIVITY





Column Detail - PFT_CM_ERROR


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 Y 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.
CORSP_ACTIVITY_ID DOUBLE N Uniquely identifies the related row on the BILL_REC table.
ENCNTR_ID DOUBLE N Uniquely identifies the related Encounter.
END_EFFECTIVE_DT_TM DATETIME Y 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.
ENTITY_TYPE_TXT VARCHAR(40) Y The entity for which the CCM has sent error information.
ERROR_DT_TM DATETIME Y The date and time when the error information for this entity was received from Cerner Contract Management.
EXTERNAL_GROUP_IDENT VARCHAR(20) Y
PFT_CM_ERROR_ID DOUBLE N Uniquely generated number that identifies a single row on the PFT_CM_ERROR 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_CM_ERROR


Child Column in PFT_CM_ERROR(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in PFT_CM_ERROR (PK) Child Table Name Child Column Name
Children: PFT_CM_ERROR_ID PFT_CM_ERROR_DETAIL PFT_CM_ERROR_ID


PFT_CM_ERROR_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Accounting Cerner Contract Management Error Detail
Definition: Stores a list of Cerner Contract Management Error Details for a Bill Record
Table Type: ACTIVITY





Column Detail - PFT_CM_ERROR_DETAIL


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 Y 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.
CCM_ERROR_CAT_CD DOUBLE N Code value for the Error Category
CCM_ERROR_CODE VARCHAR(20) Y Code provided for the error from Cerner Contract Management.
CCM_ERROR_DESC VARCHAR(1000) Y Error description received from Cerner Contract Management
END_EFFECTIVE_DT_TM DATETIME Y 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.
PFT_CM_ERROR_DETAIL_ID DOUBLE N Uniquely generated number that identifies a single row on the PFT_CM_ERROR_DETAIL table.
PFT_CM_ERROR_ID DOUBLE N Uniquely identifies the related row on the PFT_CM_ERROR table.
RESOLUTION_ACTION_DT_TM DATETIME Y Date and Time of a resolution action being applied.
RESOLUTION_ACTION_FLAG DOUBLE Y Flag denoting the resolution action applied.
RESOLUTION_ACTION_PRSNL_ID DOUBLE N Identifier for the personnel applying 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_CM_ERROR_DETAIL


Child Column in PFT_CM_ERROR_DETAIL(FK) Parent Table Name Parent Column Name
Parents: PFT_CM_ERROR_ID PFT_CM_ERROR PFT_CM_ERROR_ID


PFT_CM_EVENT_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Profit Contract Management Event Log
Definition: Contains transaction log entries for contract management changes.
Table Type: ACTIVITY





Column Detail - PFT_CM_EVENT_LOG


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
BILL_ITEM_GROUP2_ID DOUBLE N Identifies the associated Bill Item "inclusion" Group
BILL_ITEM_GROUP_ID DOUBLE N Identifies the associated Bill Item "exclusion" Group
BO_HP_RELTN_ID DOUBLE N Associates the log record to the BO Health Plan
DAYS_OF_SERVICE_CNT DOUBLE N Days of service = admit_dt_tm - disch_dt_tm
EXCLUDED_CHRG_AMT DOUBLE N The total dollar amount of all charges in the excluded list
MAX_PRICE_AMT DOUBLE N The maximum price the package can have
NOMENCLATURE_ID DOUBLE N Associates the log record to its Nomenclature
OUTLIER_COST_AMT DOUBLE N The cost of the package for each day after the outlier days
OUTLIER_DAYS_CNT DOUBLE N The number of days the package is effective
PFT_CM_EVENT_LOG_ID DOUBLE N Uniquely identifies each contract management event log
PRICE_AMT DOUBLE N The price of the package being coded
TOTAL_CHRG_AMT DOUBLE N The total dollar amount of all charges on the invoice
TRANS_ALIAS_ID DOUBLE N Related alias for combination of trans_type_cd, trans_sub_type_cd and trans_reason_cd
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_CM_EVENT_LOG


Child Column in PFT_CM_EVENT_LOG(FK) Parent Table Name Parent Column Name
Parents: BO_HP_RELTN_ID BO_HP_RELTN BO_HP_RELTN_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
TRANS_ALIAS_ID PFT_TRANS_ALIAS PFT_TRANS_ALIAS_ID


PFT_DUNNING_MSG



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT DUNNING MSG
Definition: Dunning Message Definitions
Table Type: REFERENCE





Column Detail - PFT_DUNNING_MSG


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
DUNNING_MSG_TXT VARCHAR(255) Y Dunning Message Text
DUNNING_MSG_TYPE_CD DOUBLE N Types of dunning message formats
END_EFFECTIVE_DT_TM DATETIME Y 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.
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_DUNNING_MSG_ID DOUBLE N Primary Key
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_DUNNING_MSG


Child Column in PFT_DUNNING_MSG(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in PFT_DUNNING_MSG (PK) Child Table Name Child Column Name
Children: PFT_DUNNING_MSG_ID PFT_DUNNING_MSG_RELTN PFT_DUNNING_MSG_ID


PFT_DUNNING_MSG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT DUNNING MSG RELTN
Definition: Relates messages to cycles or billing entities (for global messages)
Table Type: REFERENCE





Column Detail - PFT_DUNNING_MSG_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
DUNNING_RELTN_TYPE_CD DOUBLE N Encounter or Statement Level Relations
END_EFFECTIVE_DT_TM DATETIME Y 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.
PARENT_ENTITY_ID DOUBLE N statement cycle or billing entity
PARENT_ENTITY_NAME VARCHAR(40) Y STMT_CYCLE or BILLING_ENTITY
PFT_DUNNING_MSG_ID DOUBLE N Foreign Key to PFT_Dunning_Msg table
PFT_DUNNING_MSG_RELTN_ID DOUBLE N Primary Key
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_DUNNING_MSG_RELTN


Child Column in PFT_DUNNING_MSG_RELTN(FK) Parent Table Name Parent Column Name
Parents: PFT_DUNNING_MSG_ID PFT_DUNNING_MSG PFT_DUNNING_MSG_ID