Table Detail Report
BILL_ORG_PAYOR
Column Section | Top of Page |
Table-level Detail
Description: | Bill Organization Payor |
Definition: | Contains information about organizations that have been given a type of "client" in the organization, such as what tier group to use, and whether to generate an additional charge for the performing organization. |
Table Type: | REFERENCE |
Column Detail - BILL_ORG_PAYOR
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 | 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. |
BILL_ORG_TYPE_CD | DOUBLE | N | Value from 13031 that represents the type of information in this row such as "bill performing org", "clientbill", "t01bill", "tiergroup1", and "tiergroup2". |
BILL_ORG_TYPE_ID | DOUBLE | N | Depending on the value in bill_org_type_cd, this either indicates whether to create a charge for the performing org (1=yes, 0=no), or it is the value from 13035 that represents the tier group to use for each charge that should be generated. |
BILL_ORG_TYPE_IND | DOUBLE | Y | This field stores the indicator to determine whether the clientbill or billperforg columns in CSMiscsetup are checked. |
BILL_ORG_TYPE_STRING | VARCHAR(50) | Y | This field will contain the financial number of the bill performing org if the bill org type cd field has a value of "FINNUM" from codeset 13031 |
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. |
INTERFACE_FILE_CD | DOUBLE | N | not used. |
ORGANIZATION_ID | DOUBLE | N | ID from the organization table. Only organizations of "client" type will appear on this table. |
ORG_PAYOR_ID | DOUBLE | N | This is the value of the unique primary identifier of the bill_org_payor table. It is an internal system assigned number. |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | Indicates from what table the bill_org_type_id comes, such as code_value. |
PRIORITY | DOUBLE | Y | not used |
TIER_GROUP_CD | 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. |
CHARGE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Charge |
Definition: | Processed charge events. |
Table Type: | ACTIVITY |
Column Detail - CHARGE
Column Name | Type | Null? | Definition |
---|---|---|---|
ABN_STATUS_CD | DOUBLE | N | This field displays the status of the charge regarding whether it was required, required & missing, or present. |
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 |
ACTIVITY_SUB_TYPE_CD | DOUBLE | N | The Activity_Sub_Type_Cd field identifies the Activity Sub Type or modality that the radiologist wants to restrict proxy for. |
ACTIVITY_TYPE_CD | DOUBLE | N | A code value that uniquely identifies to which "net" (PathNet, RadNet) and/or what department (General Lab, Microbiology) an order belongs. |
ADJUSTED_DT_TM | DATETIME | Y | The date and time associated with an adjustment. |
ADMIT_TYPE_CD | DOUBLE | N | This is the value from codeset 71 that represents the visit/encounter type from this encounter, if available. |
ALPHA_NOMEN_ID | DOUBLE | N | alpha_nomen_id, which will hold the alpha nomen id for alpha response charges, will help the charging server when creating offsets so it will match up a debit with a credit correctly if the offset already exists. |
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. |
BILL_ITEM_ID | DOUBLE | N | The ID of the bill item from the bill_item table. |
BUNDLE_ID | DOUBLE | N | Identifies charges that were bundled by the charge transformation tool. |
CHARGE_DESCRIPTION | VARCHAR(200) | Y | Description from the bill item table. |
CHARGE_EVENT_ACT_ID | DOUBLE | N | This is the unique primary identifier from the charge_event_act table. |
CHARGE_EVENT_ID | DOUBLE | N | The is the unique primary identifier from the charge_event table. |
CHARGE_ITEM_ID | DOUBLE | N | This is the value of the unique primary identifier of the charge table. It is an internal system assigned number. |
CHARGE_TYPE_CD | DOUBLE | N | Value from 13028 that represents whether the charge event is a debit, credit, collection, no charge, etc. |
COMBINE_IND | DOUBLE | Y | Indicates if this charge has been combined "away". This is set on the "from" charges in the combine scripts so that the batch process that runs in operations to find the "stragglers" knows which charges on an encounter or person have already been processed. |
COST_CENTER_CD | DOUBLE | N | This field is the cost center that a charge is associated with. |
CREDITED_DT_TM | DATETIME | Y | The date and time associated with a credit. |
CS_CPP_UNDO_ID | DOUBLE | N | Uniquely identifies a specific undo record related to this charge record. |
CS_CPP_UNDO_QUAL_ID | DOUBLE | N | Uniquely identifies a specific undo record id from the CS_CPP_UNDO table_ related to the new charge record created from this as an action from this charge qualifying rule. |
DEF_BILL_ITEM_ID | DOUBLE | N | This is the unique id of the default parent or child bill item. |
DEPARTMENT_CD | DOUBLE | N | This is the value from codeset 221 that represents the department in the service resource hierarchy. |
DISCOUNT_AMOUNT | DOUBLE | Y | The amount of discount applied to the gross_price to arrive at the item_price (before extending by the quantity). |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
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. |
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. |
FIN_CLASS_CD | DOUBLE | N | Patient's financial class |
GROSS_PRICE | DOUBLE | Y | The price of an item before applying any discount. |
HEALTH_PLAN_ID | DOUBLE | N | Identifies the person's health plan. It is the unique primary identifier from the health_plan table. |
INSTITUTION_CD | DOUBLE | N | This is the value from codeset 221 that represents the institution in the service resource hierarchy. |
INST_FIN_NBR | VARCHAR(50) | Y | This field will contain the financial number of the bill performing org |
INTERFACE_FILE_ID | DOUBLE | N | This is the value of the unique primary identifier of the interface_file table. |
ITEM_ALLOWABLE | DOUBLE | Y | not used |
ITEM_COPAY | DOUBLE | Y | This field is passed from Pharmacy. Original data source is from one of two places. Either the Health Plan Benefit indicates a Copay amount or percent, or through the Online Claims process the Copay amount will be calculated and electronically received via real time interface. |
ITEM_DEDUCTIBLE_AMT | DOUBLE | Y | The deductible amount for a given item. |
ITEM_EXTENDED_PRICE | DOUBLE | Y | The final price as calculated by multiplying the item_price by the item_quantity. |
ITEM_INTERVAL_ID | DOUBLE | N | If this charge was written as a result of qualifying in an interval for which multiple charges are created, this is the unique identifier of the item interval on which the charge was created. |
ITEM_LIST_PRICE | DOUBLE | Y | The price associated with the List Price schedule that was identified in the tier. |
ITEM_PRICE | DOUBLE | Y | The price as determined through tier logic, after discounting has been applied. |
ITEM_PRICE_ADJ_AMT | DOUBLE | Y | Indicates the offset that the item price was adjusted by using the Price Adjustment Factor |
ITEM_QUANTITY | DOUBLE | Y | The quantity the price should be multiplied by to arrive at the item_extended_price. |
ITEM_REIMBURSEMENT | DOUBLE | Y | Indicates the portion of Item_Extended_Price that is the patient's Health Plan's responsibility. This field will be sent outbound to Billing Systems, Accounts Receivable systems, or used for reporting purposes. If the Health Plan does not cover the Retail prescription, then this field will be zero. The difference between the Item_price_extended, copay_amt and Reimbursement_amt will be the contract write off. |
LEVEL5_CD | DOUBLE | N | This is the value from codeset 221 that represents the level 5 (exam room, bench, instrument) in the service resource hierarchy. |
LIST_PRICE_SCHED_ID | DOUBLE | N | The price schedule identifier associated with the list price schedule identified in the tier. |
MANUAL_IND | DOUBLE | Y | Indicates if this charge is currently on hold as a manual charge or if it has ever been on hold as a manual charge. |
MED_SERVICE_CD | DOUBLE | N | This is the value from codeset 34 that represents the category of treatment, surgery, or general resources. |
OFFSET_CHARGE_ITEM_ID | DOUBLE | N | The charge item identifier of the offsetting charge. The charge that was generated to completely offset this charge item. |
ORDER_ID | DOUBLE | N | This is the unique primary identifier from the order table. |
ORD_LOC_CD | DOUBLE | N | Value from 220 that represents the location to which the person was registered. |
ORD_PHYS_ID | DOUBLE | N | ID from prsnl table of the ordering physician. |
ORIGINAL_ENCNTR_ID | DOUBLE | Y | Contains the original clinical encounter ID for every charge that is posted. |
ORIGINAL_ORG_ID | DOUBLE | Y | This field Is used to store the Original Organization Id from where the charges are posted |
PARENT_CHARGE_ITEM_ID | DOUBLE | N | The charge_item_id of the parent charge associated with this charge item. |
PATIENT_RESPONSIBILITY_FLAG | DOUBLE | N | Flag to determine whether the patient is responsible or not. 0 - unknown; 1 - patient responsible; 2 - patient not responsible |
PAYOR_ID | DOUBLE | N | ID from the organization table that represents the client organization associated with this charge. |
PAYOR_TYPE_CD | DOUBLE | N | The code value in this field, from code set 25089, describes where the payor_id (or organization_id) was derived from. |
PERF_LOC_CD | DOUBLE | N | Value from 220 that represents the location at which the services were provided. |
PERF_PHYS_ID | DOUBLE | N | ID from prsnl table of the performing physician. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
POSTED_CD | DOUBLE | N | Indicates if the charge has been billed or interfaced. |
POSTED_DT_TM | DATETIME | Y | Indicates the date and time the charge was billed or interfaced. |
POSTED_ID | DOUBLE | N | Stores the person id who actually created this charge. |
PRICE_SCHED_ID | DOUBLE | N | The id from the price_sched table that identifies the price schedule used to price this charge item. Tier logic determines this value. This is also the unique primary identifier from the price_sched table. |
PRICING_STATUS_CD | DOUBLE | N | Describes the status of the charge |
PROCESS_FLG | DOUBLE | Y | Indicates if the charge is pending, suspended/held, skipped, interfaced, combined or bundled. 0 - Pending; 1 - Suspended; 2 - Review; 3 - On Hold; 4 - Manual; 5 - Skipped; 6 - Combined; 7 - Absorbed; 8 - ABN Required; 10 - Offset; 11 - Adjusted; 12 - Grouped; 100 - Posted; 177 - Bundled - Profit; 222 - Temporary Near Time In-Process Flag; 777 - Bundled; 977 - Bundled - Interfaced; 996 - OMF Stats ONly; 997 - Statistics Only; 998 - Pharmacy No Charge; 999 - Interfaced |
PROVIDER_SPECIALTY_CD | DOUBLE | Y | Stores the rendering physicians specialty if one applies to the charge so that pricing may be driven by specialty. |
REASON_COMMENT | VARCHAR(200) | Y | obsolete - not currently being used |
REF_PHYS_ID | DOUBLE | N | ID from prsnl table of the referring physician. |
RESEARCH_ACCT_ID | DOUBLE | N | not used |
SECTION_CD | DOUBLE | N | This is the value from codeset 221 that represents the section in the service resource hierarchy. |
SERVER_PROCESS_FLAG | DOUBLE | Y | Flag used to determine if the server has finished processing: 0 - unknown; 1 - server has not finished processing; 2 - server has finished processing; 3 - Reporcessing of interval charges |
SERVICE_DT_TM | DATETIME | Y | The service date and time (from the cea_dt_tm on Charge Event Activity table). |
SERVICE_INTERFACE_FLAG | DOUBLE | Y | Flag to determine whether the charge is interfaced through service based approach or not. |
START_DT_TM | DATETIME | Y | The date and time the service was started. |
STOP_DT_TM | DATETIME | Y | The date and time the service ended. |
SUBSECTION_CD | DOUBLE | N | This is the value from codeset 221 that represents the subsection in the service resource hierarchy. |
SUSPENSE_RSN_CD | DOUBLE | N | not used |
TIER_GROUP_CD | DOUBLE | N | This is the tier that was responsible for creating the charge. |
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. |
VERIFY_PHYS_ID | DOUBLE | N | ID of the physician who verified the result. This is used mostly for the "read" in Radiology. |
Relationship Detail - CHARGE
Child Column in CHARGE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILL_ITEM_ID | BILL_ITEM | BILL_ITEM_ID |
DEF_BILL_ITEM_ID | BILL_ITEM | BILL_ITEM_ID | |
OFFSET_CHARGE_ITEM_ID | CHARGE | CHARGE_ITEM_ID | |
CHARGE_EVENT_ID | CHARGE_EVENT | CHARGE_EVENT_ID | |
CHARGE_EVENT_ACT_ID | CHARGE_EVENT_ACT | CHARGE_EVENT_ACT_ID | |
CS_CPP_UNDO_ID | CS_CPP_UNDO | CS_CPP_UNDO_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
ORIGINAL_ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID | |
INTERFACE_FILE_ID | INTERFACE_FILE | INTERFACE_FILE_ID | |
ITEM_INTERVAL_ID | ITEM_INTERVAL_TABLE | ITEM_INTERVAL_ID | |
ALPHA_NOMEN_ID | NOMENCLATURE | NOMENCLATURE_ID | |
ORDER_ID | ORDERS | ORDER_ID | |
ORIGINAL_ORG_ID | ORGANIZATION | ORGANIZATION_ID | |
PAYOR_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID | |
LIST_PRICE_SCHED_ID | PRICE_SCHED | PRICE_SCHED_ID | |
PRICE_SCHED_ID | PRICE_SCHED | PRICE_SCHED_ID | |
POSTED_ID | PRSNL | PERSON_ID |
Parent Column in CHARGE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CHARGE_ITEM_ID | CHARGE | OFFSET_CHARGE_ITEM_ID |
CHARGE_MOD | CHARGE_ITEM_ID | ||
CHARGE_TRANS_LOG | RELATED_CHARGE_ITEM_ID | ||
CS_CPP_UNDO_DETAIL | CHARGE_ITEM_ID | ||
INTERFACE_CHARGE | CHARGE_ITEM_ID | ||
PCS_CHARGE_MOD_ABN | CHARGE_ITEM_ID | ||
PFT_CHARGE | CHARGE_ITEM_ID | ||
PFT_CHARGE | MV_ORIG_CHRG_ITEM_ID | ||
PFT_COMBINE_LOG | CHARGE_ITEM_ID | ||
RCR_TRANS_DIST | CHARGE_ITEM_ID |
CHARGE_BATCH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Charge Batch |
Definition: | Contains user and system generated batches with associated batch information for all batches created in the RCA Charge Entry framework. |
Table Type: | ACTIVITY |
Column Detail - CHARGE_BATCH
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSED_DT_TM | DATETIME | Y | The date and time this batch was last accessed. |
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. |
ASSIGNED_PRSNL_ID | DOUBLE | N | The person_id of the personnel who is assigned to the batch. |
BATCH_ALIAS | VARCHAR(50) | N | Stores an alias to a batch. The possible aliases are pulled from an alias pool. |
BATCH_DT_TM | DATETIME | Y | Store a batch level date and time. |
CHARGE_BATCH_ID | DOUBLE | N | Uniquely identifies a user batch or system generated batch and related batch information for every batch in the RCA Charge Entry framework. |
CREATED_DT_TM | DATETIME | Y | Date and time the record was created. |
CREATED_PRSNL_ID | DOUBLE | N | Unique identifier of the person that created the record. |
STATUS_CD | DOUBLE | N | Stores the status of the batch. |
STATUS_DT_TM | DATETIME | Y | The date and time of the last status change. |
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. |
USER_DEFINED_IND | DOUBLE | N | Indicates whether a user or system created the batch1 - user created the batch2 - system created the batch |
Relationship Detail - CHARGE_BATCH
Child Column in CHARGE_BATCH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ASSIGNED_PRSNL_ID | PRSNL | PERSON_ID |
CREATED_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in CHARGE_BATCH (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CHARGE_BATCH_ID | CHARGE_BATCH_DETAIL | CHARGE_BATCH_ID |
CHARGE_BATCH_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Charge Batch Detail |
Definition: | Stores all service item events for a given batch. |
Table Type: | ACTIVITY |
Column Detail - CHARGE_BATCH_DETAIL
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. |
BILL_ITEM_ID | DOUBLE | N | Uniquely identifies the service item being ordered. |
CHARGE_BATCH_DETAIL_ID | DOUBLE | N | Uniquely identifies a service item event entered for a given batch. |
CHARGE_BATCH_ID | DOUBLE | N | Uniquely identifies the charge batch related to this service item event. |
CREATED_DT_TM | DATETIME | N | The date and time the row was inserted into the database. |
DIAGNOSIS_POINTER_NBR | DOUBLE | N | OBSOLETE - NO LONGER USED. Pointer value to the diagnosis code placement on the encounter. |
DIAGNOSIS_POINTER_TXT | VARCHAR(50) | Y | Pointer value to the diagnosis code placement on the encounter. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the encounter related to this service item event. |
ITEM_COPAY_AMT | DOUBLE | N | Contains the Copay amount for the item. |
ITEM_DEDUCTIBLE_AMT | DOUBLE | N | Contains the deductible amount for the item. |
ORDERING_PHYS_ID | DOUBLE | N | Uniquely identifies the health care provider who ordered the service. |
PATIENT_RESPONSIBILITY_FLAG | DOUBLE | N | Flag used to Identify Patient Responsibility Check. 0 - Unknown; 1 - Patient Responsible; 2 - Patient Not Responsible |
PERF_LOC_CD | DOUBLE | N | Represents the location at which the services were provided. |
RENDERING_PHYS_ID | DOUBLE | N | Uniquely identifies the health care provider who rendered the service. |
SERVICE_DT_TM | DATETIME | Y | The date and time that the service was rendered. |
SERVICE_ITEM_DESC | VARCHAR(200) | N | The description of the service item being ordered. |
SERVICE_ITEM_IDENT | VARCHAR(50) | N | Contains the identifier used to look up the service item. |
SERVICE_ITEM_IDENT_TYPE_CD | DOUBLE | N | Contains the value that identifies the type of service item identifier used to look up the service item. |
SERVICE_ITEM_PRICE_AMT | DOUBLE | N | The price of the service item being ordered. |
SERVICE_ITEM_QTY | DOUBLE | N | The quantity of the service item being ordered. |
SERVICE_RESOURCE_CD | DOUBLE | Y | value from 221 that represents the service resource where the activity/event occurred |
STATUS_CD | DOUBLE | N | Designates the status of the service item within a batch. |
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
Child Column in CHARGE_BATCH_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILL_ITEM_ID | BILL_ITEM | BILL_ITEM_ID |
CHARGE_BATCH_ID | CHARGE_BATCH | CHARGE_BATCH_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
ORDERING_PHYS_ID | PRSNL | PERSON_ID | |
RENDERING_PHYS_ID | PRSNL | PERSON_ID |
Parent Column in CHARGE_BATCH_DETAIL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CHARGE_BATCH_DETAIL_ID | CHARGE_BATCH_DETAIL_CODE | CHARGE_BATCH_DETAIL_ID |
CHARGE_BATCH_DETAIL_FIELD | CHARGE_BATCH_DETAIL_ID |
CHARGE_BATCH_DETAIL_CODE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Charge Batch Detail Code |
Definition: | Stores bill codes associated to each charge detail. |
Table Type: | ACTIVITY |
Column Detail - CHARGE_BATCH_DETAIL_CODE
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_CODE_ID | DOUBLE | N | Uniquely identifies a bill code that is associated to a charge detail. |
CHARGE_BATCH_DETAIL_ID | DOUBLE | N | Uniquely identifies the related charge batch detail record. |
PARENT_ENTITY_ID | DOUBLE | N | Identifies the id of the related parent entity. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The table that is the source for the id value in the parent_entity_id field. |
PRIORITY_SEQ | DOUBLE | N | The priority of the bill code. |
TYPE_CD | DOUBLE | N | Identifies the type of bill code row. |
TYPE_IDENT | VARCHAR(50) | N | Contains the bill code value input by the user. |
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_CODE
Child Column in CHARGE_BATCH_DETAIL_CODE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHARGE_BATCH_DETAIL_ID | CHARGE_BATCH_DETAIL | CHARGE_BATCH_DETAIL_ID |