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 |