Table Detail Report

CHARGE_EVENT_MOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Event Modification
Definition: Contains ICD-9 codes that are entered at order entry time.
Table Type: ACTIVITY





Column Detail - CHARGE_EVENT_MOD


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.
ACTIVITY_DT_TM DATETIME Y Stores the activity date and time for the charge event modifier, primarily used for FLEX fields which are date inputs.
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.
CHARGE_EVENT_ID DOUBLE N ID from the charge_event table for the charge_event this mod is associated with.
CHARGE_EVENT_MOD_ID DOUBLE N This is the value of the unique primary identifier of the charge_event_mod table. It is an internal system assigned number.
CHARGE_EVENT_MOD_TYPE_CD DOUBLE N Indicates what type of mod this is, such as BILL CODE for ICD9.
CM1_NBR DOUBLE N Generic field to store floating point data. When charge_event_mod_type_cd is the code value for "BILL CODE" from code_set 13019 and field1_id is the code value for "HCPCS" from code_set 14002 this field will store the QCF (Quantity Conversion Factor) value.
CODE1_CD DOUBLE N not used
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.
FIELD1 VARCHAR(200) Y Code value from 14002 that indicates this is an ICD9.
FIELD10 VARCHAR(200) Y not used
FIELD1_ID DOUBLE N Code value from 14002 that indicates this is an ICD9.
FIELD2 VARCHAR(200) Y Source identifier from nomenclature table.
FIELD2_ID DOUBLE N Priority.
FIELD3 VARCHAR(200) Y Source string from nomenclature table.
FIELD3_ID DOUBLE N Nomenclature identifier.
FIELD4 VARCHAR(200) Y Priority. This will continue to be populated until schema change has been rolled out to all sites.
FIELD4_ID DOUBLE N not used.
FIELD5 VARCHAR(200) Y Nomenclature id. This will continue to be populated until the schema change has been rolled out to all sites.
FIELD5_ID DOUBLE N not used
FIELD6 VARCHAR(200) Y not used
FIELD7 VARCHAR(200) Y not used
FIELD8 VARCHAR(200) Y not used
FIELD9 VARCHAR(200) Y not used
NOMEN_ID DOUBLE N not used
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 - CHARGE_EVENT_MOD


Child Column in CHARGE_EVENT_MOD(FK) Parent Table Name Parent Column Name
Parents: CHARGE_EVENT_ID CHARGE_EVENT CHARGE_EVENT_ID


CHARGE_MOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Modifier
Definition: Suspense reasons and bill codes for processed charge events. Charge_mod_type_cd defines the type of modification.
Table Type: ACTIVITY





Column Detail - CHARGE_MOD


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.
ACTIVITY_DT_TM DATETIME Y not used
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.
CHARGE_ITEM_ID DOUBLE N ID from the charge table for the charge this mod is associated with.
CHARGE_MOD_ID DOUBLE N This is the value of the unique primary identifier of the charge_mod table. It is an internal system assigned number.
CHARGE_MOD_SOURCE_CD DOUBLE Y This column specifies where the charge modification came from: upstream, reference build or modified manually.
CHARGE_MOD_TYPE_CD DOUBLE N Value from 13019 that represents the type of modification this row is such as bill code or suspense.
CM1_NBR DOUBLE N Generic field to store floating point data. When charge_mode_type_cd is the code value for 'BILL_CODE' from code_set 13019 and field1_id is the code value for "HCPCS' from code_set 14002 this field will store the QCF (Quantity Conversion Factor) value.
CODE1_CD DOUBLE N reserved for future use. Depending on the value in charge_mod_type_cd, this is either the value from 13030 that represents the suspense reason, or it is the value from 14002 that represents the bill code schedule.
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.
FIELD1 VARCHAR(200) Y No longer used. Depending on the value in charge_mod_type_cd, this is either the value from 13030 that represents the suspense reason, or it is the value from 14002 that represents the bill code schedule.
FIELD10 VARCHAR(200) Y not used
FIELD1_ID DOUBLE N Depending on the value in charge_mod_type_cd, this is either the value from 13030 that represents the suspense reason, or it is the value from 14002 that represents the bill code schedule.
FIELD2 VARCHAR(200) Y Depending on the value in charge_mod_type_cd, this is either the suspense description, or it is the bill code that has been assigned (in the case of ICD9 bill codes, this is the source_identifier from the nomenclature table).
FIELD2_ID DOUBLE N Priority on bill codes or sequence on the suspense reason.
FIELD3 VARCHAR(350) Y Depending on the value of charge_mod_type_cd, this is either a counter of suspense reasons for the charge_item_id starting with zero, or it is the bill code description (in the case of ICD9 bill ocdes, this is the source_string from nomenclature table).
FIELD3_ID DOUBLE N Nomenclature ID on ICD9 bill codes.
FIELD4 VARCHAR(200) Y If the charge_mod_type_cd represents bill code, this is the priority for multiple bill codes assigned to the same charge_item_id, otherwise it is null.
FIELD4_ID DOUBLE N not used
FIELD5 VARCHAR(200) Y reserved for future use. If the charge_mod_type_cd represents bill code of type ICD9, this is the nomenclature_id for the diagnosis code.
FIELD5_ID DOUBLE N not used
FIELD6 VARCHAR(200) Y not used
FIELD7 VARCHAR(200) Y not used
FIELD8 VARCHAR(200) Y not used
FIELD9 VARCHAR(200) Y not used
NOMEN_ID DOUBLE N This is the unique primary identifier from the nomenclature table for a corresponding bill code. It is mostly used for Charge Transformation.
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 - CHARGE_MOD


Child Column in CHARGE_MOD(FK) Parent Table Name Parent Column Name
Parents: CHARGE_ITEM_ID CHARGE CHARGE_ITEM_ID


CHARGE_TRANS_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Transaction Log
Definition: Charge Services API transaction log table.
Table Type: ACTIVITY





Column Detail - CHARGE_TRANS_LOG


Column Name Type Null? Definition
ACTION_FLG DOUBLE Y The flag to indicate the type of a charge transaction
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 Y 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 Y The person who caused the active_status_cd to be set or change.
CHARGE_TRANS_LOG_ID DOUBLE N A system generated number used to uniquely identify a row on the CHARGE_TRANS_LOG table.
CHARGE_TRANS_UUID VARCHAR(100) Y Unique identifier for charge transactions.
CLIENT_UUID VARCHAR(100) Y Unique identifier for the client
CONTRIBUTOR_SYSTEM_CD DOUBLE Y Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_DT_TM DATETIME Y The date and time the row was created.
ENCNTR_ID DOUBLE Y Uniquely identifies the related row on the Encounter table.
RELATED_CHARGE_ITEM_ID DOUBLE Y The charge item id to which the transaction is related
RELATED_CHARGE_TRANS_LOG_ID DOUBLE Y The charge transaction log id to which this transaction is related.
STATUS_FLG DOUBLE Y The flag to indicate the status of a charge transaction
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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 - CHARGE_TRANS_LOG


Child Column in CHARGE_TRANS_LOG(FK) Parent Table Name Parent Column Name
Parents: RELATED_CHARGE_ITEM_ID CHARGE CHARGE_ITEM_ID
RELATED_CHARGE_TRANS_LOG_ID CHARGE_TRANS_LOG CHARGE_TRANS_LOG_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in CHARGE_TRANS_LOG (PK) Child Table Name Child Column Name
Children: CHARGE_TRANS_LOG_ID CHARGE_TRANS_LOG RELATED_CHARGE_TRANS_LOG_ID


CLIENT_BATCH



Column Section Top of Page


Table-level Detail

Description: Client Batch
Definition: The client batch table is a reference of client entities in the system. It is used for the interim client billing solution.
Table Type: REFERENCE





Column Detail - CLIENT_BATCH


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 Y 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 Y The person who caused the active_status_cd to be set or change.
BATCH_CD DOUBLE Y The batch code is the code value from code set 15569.
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.
CLIENT_BATCH_ID DOUBLE N The Unique Identifier to the CLIENT_BATCH table.
CLIENT_ID DOUBLE Y This is the unique identifier of the organization table or it is the application number of CSReports (951400).
CLIENT_NAME VARCHAR(50) Y This is the name of the client in the system, or it is the name of the group of reports for CSReports.
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.
KEY1 VARCHAR(200) Y Key1 is a string field which stores parameters of a report for the CSReport application.
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.


CNVT_RATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Convert Rate
Definition: Convert Rate
Table Type: REFERENCE





Column Detail - CNVT_RATE


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.
CNVT_RATE_ID DOUBLE N Unique identifier
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.
EXCHANGE_RATE DOUBLE Y This is that value of the rate of exchange.
EXCHNG_RATE DOUBLE Y This is that value of the rate of exchange. This column is obsolete.
RESULT_CURRENCY_CD DOUBLE N The converted Currency Type
SOURCE_CURRENCY_CD DOUBLE N The orginal currency type
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 - CNVT_RATE




Parent Column in CNVT_RATE (PK) Child Table Name Child Column Name
Children: CNVT_RATE_ID PFT_BE_CNVT_RATE_RELTN CNVT_RATE_ID