Table Detail Report
TPM_RESULT_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TPM RESULT HISTORY |
Definition: | TPM RESULT HISTORY table |
Table Type: | REFERENCE |
Column Detail - TPM_RESULT_HIST
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 | Credit Billing Entity ID |
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 | Debit Billing Entity ID |
DR_GL_ACCT_ID | DOUBLE | N | DEBIT GENERAL 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_HIST_ID | DOUBLE | N | TPM RESULT HISTORY ID |
TPM_RESULT_ID | DOUBLE | N | TPM RESULT ID |
TPM_RESULT_VRSN_NBR | DOUBLE | N | Stores the version number |
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_HIST
Child Column in TPM_RESULT_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TPM_RESULT_ID | TPM_RESULT | TPM_RESULT_ID |
TPM_RULE_DEF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TPM RULE DEF |
Definition: | Store the definition of a TPM rule. |
Table Type: | REFERENCE |
Column Detail - TPM_RULE_DEF
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_IND | DOUBLE | Y | Indicator telling the collection priority. |
ENCNTR_TYPE_IND | DOUBLE | Y | Encounter Type Indicator |
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_IND | DOUBLE | Y | Financial Class Indicator. |
MED_SERVICE_IND | DOUBLE | Y | Med Service Indicator |
ORD_LOC_IND | DOUBLE | Y | Ordering location Indicator |
ORD_PHY_IND | DOUBLE | Y | Ordering physician indicator |
PATIENT_LOC_IND | DOUBLE | Y | Patient Location Indicator |
PERF_LOC_IND | DOUBLE | Y | Performing location ind. |
PERF_PHY_IND | DOUBLE | Y | Performing physician ind. |
TPM_CHRG_TIER_ID | DOUBLE | N | Foreign key reference to the tpm_chrg_tier table. |
TPM_RULE_DEF_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_RULE_DEF
Child Column in TPM_RULE_DEF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TPM_CHRG_TIER_ID | TPM_CHRG_TIER | TPM_CHRG_TIER_ID |
TPM_RULE_TIER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TPM RULE TIER |
Definition: | Stores the tpm default rule information related to the billing entity. |
Table Type: | REFERENCE |
Column Detail - TPM_RULE_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. |
BILLING_ENTITY_ID | DOUBLE | N | Foreign key reference to the billing_entity table. |
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 | Foreign key reference to the tpm_result table. |
TPM_RULE_TIER_ID | DOUBLE | N | Primary Key |
TRANS_TYPE_CD | DOUBLE | N | Code value identifying the type of transaction (e.g. charge, adjustment, payment etc.). |
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_RULE_TIER
Child Column in TPM_RULE_TIER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
TPM_RESULT_ID | TPM_RESULT | TPM_RESULT_ID |
Parent Column in TPM_RULE_TIER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TPM_RULE_TIER_ID | TPM_CHRG_TIER | TPM_RULE_TIER_ID |
TPM_SUBTYPE_TIER | TPM_RULE_TIER_ID |
TPM_SUBTYPE_TIER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TPM SUBTYPE TIER |
Definition: | Stores the TPM rule information related to the adjustments, payments etc. |
Table Type: | REFERENCE |
Column Detail - TPM_SUBTYPE_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. |
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. |
TPM_SUBTYPE_TIER_ID | DOUBLE | N | Primary Key |
TRANS_SUBTYPE_CD | DOUBLE | N | Code value identifying the transaction type code (e.g. charge, payment, adjustment). |
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_SUBTYPE_TIER
Child Column in TPM_SUBTYPE_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_SUBTYPE_TIER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TPM_SUBTYPE_TIER_ID | TPM_TRANS_RSN_TIER | TPM_SUBTYPE_TIER_ID |
TPM_TRANS_RSN_TIER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TPM Transaction Reason |
Definition: | TPM Transaction Reason table |
Table Type: | REFERENCE |
Column Detail - TPM_TRANS_RSN_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. |
TPM_RESULT_ID | DOUBLE | N | Foreign key reference to the tpm_result table. |
TPM_SUBTYPE_TIER_ID | DOUBLE | N | Foreign key reference to the tpm_subtype_tier table. |
TPM_TRANS_RSN_TIER_ID | DOUBLE | N | Primary Key |
TRANS_REASON_CD | DOUBLE | N | Code value identifying the transaction reason. |
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_TRANS_RSN_TIER
Child Column in TPM_TRANS_RSN_TIER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TPM_RESULT_ID | TPM_RESULT | TPM_RESULT_ID |
TPM_SUBTYPE_TIER_ID | TPM_SUBTYPE_TIER | TPM_SUBTYPE_TIER_ID |