Table Detail Report

CHARGE_BATCH_DETAIL_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Batch Detail Field
Definition: Store additional data element fields related to CHARGE_BATCH_DETAIL.
Table Type: ACTIVITY





Column Detail - CHARGE_BATCH_DETAIL_FIELD


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.
CHARGE_BATCH_DETAIL_FIELD_ID DOUBLE N Uniquely identifies a data element field.
CHARGE_BATCH_DETAIL_ID DOUBLE N Uniquely identifies the related Charge Batch Detail record.
FIELD_TYPE_CD DOUBLE N Identifies the field that is being used.
FIELD_VALUE_CD DOUBLE N Stores the related code value. The code values that are stored here could be from different code sets.
FIELD_VALUE_CHAR VARCHAR(200) N Stores the related string values.
FIELD_VALUE_DT_TM DATETIME Y Stores related date and time values.
FIELD_VALUE_END_DT_TM DATETIME Y Stores the related end date and time values.
FIELD_VALUE_IND DOUBLE N Store related short numeric values.
FIELD_VALUE_NBR DOUBLE N Stores related numeric values.
FIELD_VALUE_PRSNL_ID DOUBLE N Store the related personnel id.
FIELD_VALUE_START_DT_TM DATETIME Y Sortes related start date and time values.
PRIORITY_SEQ DOUBLE N Identifies a sequencing priority to be used when there is more than one set of related rows.
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_BATCH_DETAIL_FIELD


Child Column in CHARGE_BATCH_DETAIL_FIELD(FK) Parent Table Name Parent Column Name
Parents: CHARGE_BATCH_DETAIL_ID CHARGE_BATCH_DETAIL CHARGE_BATCH_DETAIL_ID
FIELD_VALUE_PRSNL_ID PRSNL PERSON_ID


CHARGE_DESC_MASTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Description Master
Definition: Each row in the charge_desc_master table represents an unique service that can be charged.
Table Type: REFERENCE





Column Detail - CHARGE_DESC_MASTER


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.
CDM_CODE_TXT VARCHAR(254) Y Client defined code used to represent a service or charge
CHARGE_DESC_MASTER_ID DOUBLE N A system generated number used to uniquely identify a row on the CHARGE_DESC_MASTER table.
DESCRIPTION VARCHAR(254) Y Client defined description used to represent a service or charge.
LOGICAL_DOMAIN_ID DOUBLE Y 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.
SERVICE_TYPE_FLAG DOUBLE Y Indicates the type of service to be billed.
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_DESC_MASTER


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


CHARGE_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Event
Definition: Activity table that holds all charging activity. As each charge point is achieved, a 'foreign system' triggers a charge event entry.
Table Type: ACTIVITY





Column Detail - CHARGE_EVENT


Column Name Type Null? Definition
ABN_STATUS_CD DOUBLE N This field displays the status of the charge whether it was required, required and missing, or present
ACCESSION VARCHAR(50) Y The accession number assigned to the specimen or case number assigned to the case.
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_DT_TM DATETIME Y The date and time that the active_status_cd was set.
BILL_ITEM_ID DOUBLE N The ID of the bill item that will be billed as a result of this charge event.
CANCELLED_DT_TM DATETIME Y Indicates the date and time the order was cancelled.
CANCELLED_IND DOUBLE Y Indicates whether the order was cancelled.
CHARGE_EVENT_ID DOUBLE N This is the value of the unique primary identifier of the charge_event table. It is an internal system assigned number.
COLLECTION_PRIORITY_CD DOUBLE N Value from 2054 that represents the collection priority of the order.
CONTRIBUTOR_SYSTEM_CD DOUBLE N 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.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EPSDT_IND DOUBLE Y This field indicates whether or not the patient participates in an EPSDT. EPSDT is an entitlement provided by Medicaid. It is a service available to all individuals age 20 and younger that are eligible for medical assistance through their participating state Medicaid programs. The program includes early detection of illness or defects through regular and periodic screening examinations, follow up care, and promotion of healthy lifestyles.
EXT_I_EVENT_CONT_CD DOUBLE N Value from 13016 that represents from where the ext_i_event_id came ("RESULT ID" for General Lab).
EXT_I_EVENT_ID DOUBLE N The item event id contains the cs_order_id for the careset charge event, order_id for orderables, and a unique id depending on from where the event came (RESULT_ID from General Lab).
EXT_I_REFERENCE_CONT_CD DOUBLE N Value from 13016 that represents "ORD ID".
EXT_I_REFERENCE_ID DOUBLE N TASK_ID from the order.
EXT_M_EVENT_CONT_CD DOUBLE N Value from 13016 that represents "ORD ID".
EXT_M_EVENT_ID DOUBLE N The master event id contains the cs_order_id for caresets or the order_id for regular orderables. This ties back to the order table.
EXT_M_REFERENCE_CONT_CD DOUBLE N Value from 13016 that represents "ORD CAT".
EXT_M_REFERENCE_ID DOUBLE N ID from the order catalog for the ordered item.
EXT_P_EVENT_CONT_CD DOUBLE N The parent event contributor code contains the value from 13016 that represents "ORD ID" for orderables within a careset and children of the orderables within the careset, and zero for the charge event associated with the order.
EXT_P_EVENT_ID DOUBLE N The parent event id contains zero for the charge event associated with the order, the cs_order_id from the order table for orderables within a careset, and the order_id from the order table for the children of the orderables within the careset.
EXT_P_REFERENCE_CONT_CD DOUBLE N The parent event contributor code contains the value from 13016 that represents "ORD CAT" for orderables within a careset and children of the orderables within the careset, and zero for the charge event associated with the order.
EXT_P_REFERENCE_ID DOUBLE N ID from the order catalog for the ordered item for orderables within a careset and children of the orderables within the careset, and zero for the charge event associated with the order.
HEALTH_PLAN_ID DOUBLE N The ID of the health plan associated with the encounter.
M_BILL_ITEM_ID DOUBLE N This is the value of the unique primary identifier of the bill_item table for the master (careset) bill item. It is an internal system assigned number.
M_CHARGE_EVENT_ID DOUBLE N This is the value of the unique primary identifier of the charge_event table for the master (careset) bill item. It is an internal system assigned number.
ORDER_ID DOUBLE N The order_id from the order table.
PERF_LOC_CD DOUBLE N Value from codeset 220 that represents the locaiton at which the services were provided.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
P_BILL_ITEM_ID DOUBLE N This is the value of the unique primary identifier of the bill_item table for the parent bill item. It is an internal system assigned number.
P_CHARGE_EVENT_ID DOUBLE N This is the value of the unique primary identifier of the charge_event table for the parent bill item. It is an internal system assigned number.
REFERENCE_NBR VARCHAR(60) Y This value is populated by CSChargeRecovery. The application prompts the user for a reference number when reprocessing missing events. CSChargeRecovery sends the missing events through the AFC Server to be processed. The reference_nbr field is then populated with the reference nbr from the CSChargeRecovery application when the event is reprocessed by the server.
REPORT_PRIORITY_CD DOUBLE N Value from 1905 that represents the reporting priority of the order.
RESEARCH_ACCOUNT_ID DOUBLE N This is the unique identifier to the research_account table. It identifies the research account to be used in charge creation.
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


Child Column in CHARGE_EVENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
PERSON_ID PERSON PERSON_ID




Parent Column in CHARGE_EVENT (PK) Child Table Name Child Column Name
Children: CHARGE_EVENT_ID CHARGE CHARGE_EVENT_ID
CHARGE_EVENT_ACT CHARGE_EVENT_ID
CHARGE_EVENT_MOD CHARGE_EVENT_ID
UM_CHARGE_EVENT_ST CHARGE_EVENT_ID
WORKLOAD CHARGE_EVENT_ID


CHARGE_EVENT_ACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Event Activity
Definition: Information regarding who triggered a charge, where the charge was created, and when a charge event took place.
Table Type: ACTIVITY





Column Detail - CHARGE_EVENT_ACT


Column Name Type Null? Definition
ACCESSION_ID DOUBLE N The unique identifier to the accession table.
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.
ACTIVITY_DT_TM DATETIME Y The date and time that the actual event occurred. For example, the activity date and time on the ordered event would be the date and time that the item was actually ordered.
ALPHA_NOMEN_ID DOUBLE N This is the value of the unique primary identifier of the nomenclature table. This is used in alpha response pricing logic.
CEA_MISC1 VARCHAR(200) Y String field that holds miscellaneous information about the charge event.
CEA_MISC1_ID DOUBLE N Numeric field to hold miscellaneous information about the charge event.
CEA_MISC2 VARCHAR(200) Y String field that holds miscellaneous information about the charge event.
CEA_MISC2_ID DOUBLE N Numeric field to hold miscellaneous information about the charge event.
CEA_MISC3 VARCHAR(200) Y String field that holds miscellaneous information about the charge event.
CEA_MISC3_ID DOUBLE N Numeric field to hold miscellaneous information about the charge event.
CEA_MISC4_ID DOUBLE N Numeric field to hold miscellaneous information about the charge event.
CEA_MISC5_ID DOUBLE N Numeric value that holds the item_copay passed in from pharmacy and will be written to the item_copay field on the charge table. For pharmacy charges only.
CEA_MISC6_ID DOUBLE N Numeric value that holds the item_reimbursement passed in from pharmacy and will be written to the item_reimbursement field on the charge table. For pharmacy charges only.
CEA_MISC7_ID DOUBLE N Numeric value that holds the discount_amount passed in from pharmacy and will be written to the discount_amount field on the charge table. For pharmacy charges only.
CEA_PRSNL_ID DOUBLE N ID from the prsnl table of the person associated with the event activity.
CEA_TYPE_CD DOUBLE N Value from 13039 that represents the event such as performed, verified, complete.
CHARGE_DT_TM DATETIME Y The date and time the charge was created.
CHARGE_EVENT_ACT_ID DOUBLE N This is the value of the unique primary identifier of the charge_event_act table. It is an internal system assigned number.
CHARGE_EVENT_ID DOUBLE N ID of the charge event to which this activity is associated. This is the unique primary identifier of the charge_event table.
CHARGE_TYPE_CD DOUBLE N Value from 13028 that represents whether the charge event is a debit, credit, collection, no charge, etc.
DISCOUNT_AMOUNT DOUBLE N Stores the discount amount
INSERT_DT_TM DATETIME Y The date and time the row was originally inserted.
IN_LAB_DT_TM DATETIME Y The date and time the specimen reached the "INLAB" status. This is derived by comparing the receiving location to the login location; when they are the same the specimen is considered "INLAB".
ITEM_COPAY DOUBLE N Stores the copay amount
ITEM_DEDUCTIBLE_AMT DOUBLE Y Contains the deductible amount for the item.
ITEM_EXT_PRICE DOUBLE N Stores the price multiplied by the quantity for a charge when the price is sent in the request (i.e. miscellaneous bill items)
ITEM_PRICE DOUBLE N Stores the price for a charge when the price is sent in the request (i.e. miscellaneous bill items)
ITEM_REIMBURSEMENT DOUBLE N Store the item reimbursement
MISC_IND DOUBLE Y This field, when sent in the server request, indicates a miscellaneous item. For CSBatchChargeEntry, this means the user is prompted for the description, price and quantity. For Pharmacy, it means to use the description sent instead of the description on the bill item.
PATIENT_LOC_CD DOUBLE N Value from 220 that represents the location to which the patient presented.
PATIENT_RESPONSIBILITY_FLAG DOUBLE N Flag to determine the responsibility of the patient. 0 - Unknown; 1 - Patient Responsible; 2 - Patient Not Responsible
PRIORITY_CD DOUBLE N This is the priority code passed to the charge server and used to evaluate the tier. Code set 1304.
QUANTITY DOUBLE N The number of items that should be used to extend the price.
REASON_CD DOUBLE N not used.
REFERENCE_RANGE_FACTOR_ID DOUBLE N This is the value of the unique primary identifier of the reference_range_factor table. This is used in alpha response pricing logic.
REPEAT_IND DOUBLE Y Indicates if this event is a repeat workload event activity. This occurs when a test is performed more than once.
RESULT VARCHAR(200) Y Stores the numeric result for result is quantity charge calculation.
SERVICE_DT_TM DATETIME Y The date and time the service was provided.
SERVICE_LOC_CD DOUBLE N Value from 221 that represents the service resource where the activity/event occurred.
SERVICE_RESOURCE_CD DOUBLE N Value from 221 that represents the service resource where the activity/event occurred.
SRV_DIAG1_ID DOUBLE N This stores a code value that helps to diagnose why charges did not get created.
SRV_DIAG2_ID DOUBLE N This stores a code value that helps to diagnose why charges did not get created.
SRV_DIAG3_ID DOUBLE N This stores a value such as a code set that helps to diagnose why charges did not get created.
SRV_DIAG4_ID DOUBLE N This value helps to diagnose why charges were not created. Stores id fields such as organization id or price_sched_id.
SRV_DIAG_CD DOUBLE N This is the value from code set 18269 that defines the type of diagnosis code that the server has processed.
UNITS DOUBLE N The number of units that should be used in interval calculations.
UNIT_TYPE_CD DOUBLE N Value from 14276 that represents the type of unit such as miles, minutes, or hours.
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_EVENT_ACT


Child Column in CHARGE_EVENT_ACT(FK) Parent Table Name Parent Column Name
Parents: ACCESSION_ID ACCESSION ACCESSION_ID
CHARGE_EVENT_ID CHARGE_EVENT CHARGE_EVENT_ID
ALPHA_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
CEA_PRSNL_ID PRSNL PERSON_ID
REFERENCE_RANGE_FACTOR_ID REFERENCE_RANGE_FACTOR REFERENCE_RANGE_FACTOR_ID




Parent Column in CHARGE_EVENT_ACT (PK) Child Table Name Child Column Name
Children: CHARGE_EVENT_ACT_ID CHARGE CHARGE_EVENT_ACT_ID
CHARGE_EVENT_ACT_PRSNL CHARGE_EVENT_ACT_ID


CHARGE_EVENT_ACT_PRSNL



Column Section Relationship Section Top of Page


Table-level Detail

Description: charge_event_act_prsnlq
Definition: Stores all physicians associated with a charge.
Table Type: ACTIVITY





Column Detail - CHARGE_EVENT_ACT_PRSNL


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.
CHARGE_EVENT_ACT_ID DOUBLE N Foreign key to the charge_event_act table.
PRSNL_ID DOUBLE N Foreign key to the prsnl table.
PRSNL_TYPE_CD DOUBLE N Value from code_set 13029. This denotes the type of physician.
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_EVENT_ACT_PRSNL


Child Column in CHARGE_EVENT_ACT_PRSNL(FK) Parent Table Name Parent Column Name
Parents: CHARGE_EVENT_ACT_ID CHARGE_EVENT_ACT CHARGE_EVENT_ACT_ID