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