Table Detail Report

TASK_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Task Criteria
Definition: Task Criteria table
Table Type: REFERENCE





Column Detail - TASK_CRITERIA


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.
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.
MANDATORY_IND DOUBLE Y Mandatory Indicator
MANDATORY_VALUE VARCHAR(250) Y Mandatory Value
PFT_CRITERIA_NAME VARCHAR(250) Y ProFit Criteria Name
PFT_CRITERIA_TYPE DOUBLE Y ProFit Criteria Type
PFT_TASK_CRITERIA_ID DOUBLE N Uniquely identifies a given Task Criteria
PFT_TASK_ID DOUBLE N ProFit Task ID
TABLE_NAME VARCHAR(30) Y Table Name
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 - TASK_CRITERIA




Parent Column in TASK_CRITERIA (PK) Child Table Name Child Column Name
Children: PFT_TASK_CRITERIA_ID PFT_CA_CRITERIA_VALUE PFT_TASK_CRITERIA_ID
SELECTED_CRITERIA PFT_TASK_CRITERIA_ID


TEXT_COND_CRIT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Text Condition Criteria Relation
Definition: Relates text condition criterea to charge group condition criteria.
Table Type: REFERENCE





Column Detail - TEXT_COND_CRIT_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.
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.
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.
BT_COND_CRIT_R_ID DOUBLE N Uniquely identifies the related row on the BT_COND_CRIT_RELTN table.
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.
TEXT_COND_CRIT_CD DOUBLE N Code value for any free text criteria definition currently used for CDM code value.
TEXT_COND_CRIT_RELTN_ID DOUBLE N Uniquely identifies a relationship between a criteria to a build tool.
TEXT_COND_CRIT_VALUE VARCHAR(200) N Code Value for any free text criteria definition currently used for CDM code values.
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 - TEXT_COND_CRIT_RELTN


Child Column in TEXT_COND_CRIT_RELTN(FK) Parent Table Name Parent Column Name
Parents: BT_COND_CRIT_R_ID BT_COND_CRIT_RELTN BT_COND_CRIT_R_ID


TPM_CHRG_TIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: TPM CHRG TIER
Definition: Stores TPM rule information related to a charge.
Table Type: REFERENCE





Column Detail - TPM_CHRG_TIER


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.
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.
TIER_GROUP_CD DOUBLE N Code value identifying the tier group (e.g. surgery , pharmacy etc.)
TPM_CHRG_TIER_ID DOUBLE N Primary Key
TPM_RESULT_ID DOUBLE N Foreign key reference to the tpm_result table.
TPM_RULE_TIER_ID DOUBLE N Foreign key reference to the tpm_rule_tier table.
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 - TPM_CHRG_TIER


Child Column in TPM_CHRG_TIER(FK) Parent Table Name Parent Column Name
Parents: TPM_RESULT_ID TPM_RESULT TPM_RESULT_ID
TPM_RULE_TIER_ID TPM_RULE_TIER TPM_RULE_TIER_ID




Parent Column in TPM_CHRG_TIER (PK) Child Table Name Child Column Name
Children: TPM_CHRG_TIER_ID TPM_CONDITION TPM_CHRG_TIER_ID
TPM_RULE_DEF TPM_CHRG_TIER_ID


TPM_CONDITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: TPM CONDITION
Definition: Stores the parameters related to a TPM condition.
Table Type: REFERENCE





Column Detail - TPM_CONDITION


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.
COLLECTION_PRIORITY_CD DOUBLE N Code value identifying the collection priority (e.g. ASAP, before first etc.).
ENCNTR_TYPE_CD DOUBLE N Code value indicating the type of encounter (e.g. Inpatient, outpatient).
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.
FIN_CLASS_CD DOUBLE N Financial class code value
MED_SERVICE_CD DOUBLE N Code value identifying the medical service.
ORD_LOC_CD DOUBLE N Code value identifying the ordering location.
ORD_PHY_ID DOUBLE N Unique identifier of the ordering physician. Foreign key reference to the person table.
PATIENT_LOC_CD DOUBLE N Code value identifying the location of the patient.
PERF_LOC_CD DOUBLE N Performing Location Cd
PERF_PHY_ID DOUBLE N Performing Physician ID
TPM_CHRG_TIER_ID DOUBLE N Foreign key reference to the tpm_chrg_tier table.
TPM_CONDITION_ID DOUBLE N Primary Key
TPM_RESULT_ID DOUBLE N Foreign key reference to the tpm_result table.
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 - TPM_CONDITION


Child Column in TPM_CONDITION(FK) Parent Table Name Parent Column Name
Parents: TPM_CHRG_TIER_ID TPM_CHRG_TIER TPM_CHRG_TIER_ID
TPM_RESULT_ID TPM_RESULT TPM_RESULT_ID


TPM_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: TPM RESULT
Definition: TPM RESULT table
Table Type: REFERENCE





Column Detail - TPM_RESULT


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.
CR_ACCT_ID DOUBLE N CREDIT ACCOUNT ID
CR_ACCT_TEMPL_ID DOUBLE N CREDIT ACCOUNT TEMPLATE ID
CR_BE_ID DOUBLE N Unique identifier of the billing entity related to the credit account. Candidate key reference to the billing_entity table.
CR_GL_ACCT_ID DOUBLE N CREDIT GENERAL LEDGER ACCOUNT ID
DR_ACCT_ID DOUBLE N DEBIT ACCOUNT ID
DR_ACCT_TEMPL_ID DOUBLE N DEBIT ACCOUNT TEMPLATE ID
DR_BE_ID DOUBLE N Unique identifier of the billing entity related to the debit account. Foreign key reference to the billing_entity table.
DR_GL_ACCT_ID DOUBLE N DEBIT GENERAL LEDGER ACCOUNT ID
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.
TPM_RESULT_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 - TPM_RESULT




Parent Column in TPM_RESULT (PK) Child Table Name Child Column Name
Children: TPM_RESULT_ID TPM_CHRG_TIER TPM_RESULT_ID
TPM_CONDITION TPM_RESULT_ID
TPM_RESULT_HIST TPM_RESULT_ID
TPM_RULE_TIER TPM_RESULT_ID
TPM_SUBTYPE_TIER TPM_RESULT_ID
TPM_TRANS_RSN_TIER TPM_RESULT_ID