Table Detail Report

FAV_FOLDER_LIST



Column Section Top of Page


Table-level Detail

Description: Favorites Folder List
Definition: Contains sub folders and/or bill item reference.
Table Type: REFERENCE





Column Detail - FAV_FOLDER_LIST


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.
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 N 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.
BILL_ITEM_ID DOUBLE N Bill Item ID
CHILD_FAV_FOLDER_CAT_ID DOUBLE N Child favorites folder category id
FAV_FOLDER_CAT_ID DOUBLE N Favorites folder category id
FAV_FOLDER_LIST_ID DOUBLE N Favorites folder list id
LIST_TYPE DOUBLE N List 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.


INTERFACE_CHARGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interface Charge
Definition: A batch process populates this file from the charge and charge mod tables with charge information to be used by the ESO server.
Table Type: ACTIVITY





Column Detail - INTERFACE_CHARGE


Column Name Type Null? Definition
ABN_STATUS_CD DOUBLE N This field displays the status of the charge regarding whether it was required, present, present & required, required and not present, or not 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_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.
ADDITIONAL_ENCNTR_PHYS1_ID DOUBLE N This field holds the ID from the person table of an additional physician that was involved in the encounter. This is the value of the unique primary identifier of the person table.
ADDITIONAL_ENCNTR_PHYS2_ID DOUBLE N This field holds the ID from the person table of an additional physician that was involved in the encounter. This is the value of the unique primary identifier of the person table.
ADDITIONAL_ENCNTR_PHYS3_ID DOUBLE N This field holds the ID from the person table of an additional physician that was involved in the encounter. This is the value of the unique primary identifier of the person table.
ADMIT_TYPE_CD DOUBLE N This is the value from codeset 71 that represents the visit/encounter type from this encounter, if available.
ADM_PHYS_ID DOUBLE N This field holds the ID from the person table of the admitting physician. This is the value of the unique primary identifier of the person table.
ATTENDING_PHYS_ID DOUBLE N This field holds the ID from the person table of the attending physician. This is the value of the unique primary identifier of the person table.
BATCH_NUM DOUBLE Y Uniquely identifies a batch of charges based on when they were written to the interface_charge table.
BED_CD DOUBLE N Value from 220 that represents the bed in the patient location hierarchy.
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_CODE1 VARCHAR(50) Y Bill code from charge_mod table with priority 2.
BILL_CODE1_DESC VARCHAR(200) Y Description from bill code from charge_mod table with priority 2.
BILL_CODE2 VARCHAR(50) Y Bill code from charge_mod table with priority 3.
BILL_CODE2_DESC VARCHAR(200) Y Description from bill code from charge_mod table with priority 3.
BILL_CODE3 VARCHAR(50) Y Bill code from charge_mod table with priority 4.
BILL_CODE3_DESC VARCHAR(200) Y Description from bill code from charge_mod table with priority 4.
BILL_CODE_MORE_IND DOUBLE Y This field indicates that there are more bill codes than are listed on interface_charge.
BILL_CODE_TYPE_CDF VARCHAR(12) Y This field contains the cdf meaning for additional bill codes that were defined on the interface file
BUILDING_CD DOUBLE N Value from 220 that represents the building in the patient location hierarchy.
CHARGE_DESCRIPTION VARCHAR(200) Y This is the charge description from the charge table.
CHARGE_ITEM_ID DOUBLE N This is the value of the unique primary identifier of the charge table.
CHARGE_TYPE_CD DOUBLE N Value from 13028 that represents whether the charge event is a debit, credit, collection, no charge, etc.
CODE_MODIFIER1_CD DOUBLE N This field contains the code modifier from the charge mod table with priority of 1.
CODE_MODIFIER2_CD DOUBLE N This field contains the code modifier on the charge mod table with a priority of 2.
CODE_MODIFIER3_CD DOUBLE N This is the field that contains the code modifier on the charge mod table with priority of 3.
CODE_MODIFIER_MORE_IND DOUBLE Y This field indicates that there are more code modifiers than are listed on the table.
CODE_REVENUE_CD DOUBLE N Stores the revenue code value
CODE_REVENUE_MORE_IND DOUBLE Y indicates that there are additional revenue codes on the charge_mod table
COST_CENTER_CD DOUBLE N This field is the cost center that a charge is associated with
DEPARTMENT_CD DOUBLE N Value from 221 that represents the department in the service resource hierarchy.
DIAG_CODE1 VARCHAR(50) Y Diagnosis code from charge_mod with priority 1 with ICD-9 meaning.
DIAG_CODE2 VARCHAR(50) Y Diagnosis code from charge_mod with priority 2 with ICD-9 meaning.
DIAG_CODE3 VARCHAR(50) Y Diagnosis code from charge_mod with priority 3 with ICD-9 meaning.
DIAG_DESC1 VARCHAR(200) Y The description associated with the primary diagnosis code.
DIAG_DESC2 VARCHAR(200) Y The description associated with the secondary diagnosis.
DIAG_DESC3 VARCHAR(200) Y The description associated with the tertiary diagnosis.
DIAG_MORE_IND DOUBLE Y This field indicates that there are more icd9 diagnosis codes on the charge mod table than there are listed on interface charge.
DISCOUNT_AMOUNT DOUBLE Y The amount of the discount that was applied to the gross price.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_TYPE_CD DOUBLE N Value from 71 that represents the visit type.
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.
EXT_BILL_QTY DOUBLE Y Stores the product of multiplying the item_quantity by the QCF value that gets associated to a JCode for Pharmacy charges.
FACILITY_CD DOUBLE N Value from 220 that represents the facility in the patient location hierarchy.
FIN_NBR VARCHAR(50) Y Either the research account ID, institutional financial number or the financial number from encounter table.
FIN_NBR_TYPE_FLG DOUBLE Y Identifies from where the fin nbr came.
GROSS_PRICE DOUBLE Y The price of the procedure before any discounts have been applied.
ICD9_PROC_MORE_IND DOUBLE Y This field indicates that there are more ICD9 procedure codes on the charge mod table that are not listed on the interface charge table.
INSTITUTION_CD DOUBLE N Value from 221 that represents the institution in the service resource hierarchy.
INTERFACE_CHARGE_ID DOUBLE N This is the value of the unique primary identifier of the interface_charge table. It is an internal system assigned number.
INTERFACE_FILE_ID DOUBLE N This is the value of the unique primary identifier of the interface_file table.
LEVEL5_CD DOUBLE N Value from 221 that represents level 5 (exam room, bench, instrument) in the service resource hierarchy.
MANUAL_IND DOUBLE Y Indicates if the charge was once on hold as a manual charge.
MED_NBR VARCHAR(50) Y Medical record number from encounter table.
MED_SERVICE_CD DOUBLE N This is the value from codeset 34 that represents the category of treatment, surgery or general resources.
NDC_IDENT VARCHAR(40) N A value used to uniquely identify drug products.
NET_EXT_PRICE DOUBLE Y Quantity X Price.
NURSE_UNIT_CD DOUBLE N Value from 220 that represents the nurse unit or ambulatory in the patient location hierarchy.
ORDER_DEPT DOUBLE Y not used.
ORDER_NBR VARCHAR(200) Y The order number based on the contributor_system_cd on the interface_file table.
ORD_DOC_NBR VARCHAR(20) Y This contains the doctor number from prsnl_alias table with alias_pool_cd of XXXXX.
ORD_PHYS_ID DOUBLE N This field holds the ID from the person table of the ordering physician. This is the value of the unique primary identifier of the person table.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table.
OVERRIDE_DESC VARCHAR(200) Y This field will contain the description of the charge if the manual_ind is 1 on the charge that is being interfaced.
PAYOR_ID DOUBLE N This is the value of the unique primary identifier of the bill_org_payor table.
PERF_LOC_CD DOUBLE N Value from codeset 220 that represents the location at which the services were provided
PERF_PHYS_ID DOUBLE N Unique identifier to the person 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.
PERSON_NAME VARCHAR(100) Y Person name from person table.
POSTED_DT_TM DATETIME Y The date and time that a custom program pulled the interface charge onto an interface file.
PRICE DOUBLE Y The gross price that was used in calculating the net_ext_price.
PRIM_CDM VARCHAR(50) Y Bill code from charge_mod table with priority 1 with CDM_SCHED as the meaning.
PRIM_CDM_DESC VARCHAR(200) Y Bill code description for the charge description master with priority of 1.
PRIM_CPT VARCHAR(50) Y Bill code from charge_mod table with priority 1 with CPT-4 meaning.
PRIM_CPT_DESC VARCHAR(200) Y Description of the CPT code that has a priority of 1.
PRIM_ICD9_PROC VARCHAR(50) Y Bill code from charge_mod table with priority 1 with PROCCODE meaning.
PRIM_ICD9_PROC_DESC VARCHAR(200) Y Description of the Primary ICD9 Procedure Code
PROCESS_FLG DOUBLE Y Shows the status of the interface charge. This flag will be used to determine if the interface charge qualifies for the interface file.
QTY_CONV_FACTOR DOUBLE Y Stores the multiplier value that gets associated with a JCode used for Pharmacy charges.
QUANTITY DOUBLE Y The number by which the price has been extended, which indicates a quantity of products or services.
REFERRING_PHYS_ID DOUBLE N This field holds the ID from the person table of the referring physician. This is the value of the unique primary identifier of the person table.
ROOM_CD DOUBLE N Value from 220 that represents the room in the patient location hierarchy.
SECTION_CD DOUBLE N Value from 221 that represents the section in the service resource hierarchy.
SERVICE_DT_TM DATETIME Y Service date and time.
SUBSECTION_CD DOUBLE N Value from 221 that represents the subsection in the service resource hierarchy.
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.
USER_DEF_IND DOUBLE Y This field stores an indicator that tells whether there are user-defined charge mods.
VERIFY_PHYS_ID DOUBLE N This field holds the prsnl_id for the physician on the verified or complete event. This is the value of the unique primary identifier of the person table



Relationship Detail - INTERFACE_CHARGE


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


INTERFACE_FILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interface File
Definition: Contains information about how charges will be written to the inteface_charge table.
Table Type: REFERENCE





Column Detail - INTERFACE_FILE


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.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
BATCH_FREQUENCY DOUBLE Y not used.
BILLING_ENTITY_ID DOUBLE N Uniquely identifies the Billing Entity related to this interface file.
CDM_ID_SUSPEND_IND DOUBLE Y Indicates whether the charges for this interface file will suspend if not linked to a CHARGE_DESC_MASTER_ID.
CDM_SCHED_CD DOUBLE N Indicates which cdm schedule of bill code to look for before posting the charge to the interface_charge table. If the cdm from that particular schedule is not there, it will be marked as suspended. If the code value with a cdf_meaning of "ALL" is in this field, then if there isn't a cdm at all on the charge, it will suspend. If this is 0, the charge can successfully be written to the interface_charge table without a bill code in this schedule.
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.
COST_CENTER_SUSPEND_IND DOUBLE Y Indicates whether the charges for this interface file will suspend if not linked to a cost center.
CPT_SCHED_CD DOUBLE N Indicates which cpt schedule of bill code to look for before posting the charge to the interface_charge table. If the cpt from that particular schedule is missing, the charge will be marked as suspended. If the code value with the cdf_meaning of "ALL" is in this field, then if the charge is missing a cpt at all, the charge will suspendd. If this is 0, the charge can successfully be written to the interface_charge table without a bill code in this schedule.
DESCRIPTION VARCHAR(100) N A description of the interface file, such as "T01". Do not use spaces or periods in this name.
DOC_NBR_CD DOUBLE N Value that indicates whether the doctor numbers written to the interface_charge table will be UPIN or organization identifiers. It defaults to the organization identifier.
EXPLODE_IND DOUBLE Y Indicates what afc_post_interface_charge will do with the quantity column. If this indicator is 1, the quantity will not be written to the interface_charge table, but will instead "explode" into that number of interface_charge records with a quantity of 1. If the indicator is 0, the quantity will be written to the interface_charge table.
FILE_NAME VARCHAR(32) Y The name of the file to be created by the interface program, including the directory in which to put the file, such as "CER_SCRIPT:T01.DAT". This file name cannot be longer than 30 characters (including the path name).
FIN_NBR_SUSPEND_IND DOUBLE Y If this value is a 1, then if a charge is missing a financial number, it will be marked as suspended by afc_post_interface_charge. If the value is a 0, then if the charge is missing a financial number, it will not be marked as suspended and will be processed like any other pending charge.
HL7_IND DOUBLE Y Indicates whether or not an interface file is HL7 instead of batch proprietary.
HOLD_PERIOD DOUBLE Y not used.
INTERFACE_FILE_ID DOUBLE N This is the value of the unique primary identifier of the interface_file table. It is an internal system assigned number.
INTERFACE_TYPE_FLAG DOUBLE N Defines an interface file type for use in other Millennium solutions.
LOGICAL_DOMAIN_ID DOUBLE N 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.
MAX_FT1 CHAR(5) Y If the hl7_ind is checked for the interface_file, the number in this column is maximum number of FT1's that can be sent per detail segment. This number is pulled from code set 23169. The default is 15, so if this column has a value of 0 in it, 15 will be the maximum number of FT1's.
MULT_BILL_CODE_SCHED_CD DOUBLE N This determines from what bill code schedule the extra bill codes on the interface_charge table will come. This affects bill_code1, bill_code2, bill_code3, bill_code1_desc, bill_code2_desc, bill_code3_desc.
ORDER_PHYS_COPY_IND DOUBLE N This column holds a value of 1 if the ord_phys_id on the charge table will be copied to the verify_phys_id of the charge table when verify_phys_id is empty.
PERF_PHYS_CONT_IND DOUBLE Y This field holds a value of 0 if the perf_phys_id on the interface_charge table will be populated with the verify_phys_id from the charge table or a 1 if the perf_phys_id on the interface_charge table will be populated with the perf_phys_id from the charge table.
PROFIT_TYPE_CD DOUBLE N This code value is the billing indicator for a particular interface file. It specifies what type of billing is done, whether it be patient accounting or client billing, in each interface file.
REALTIME_IND DOUBLE Y Indicates whether the charges for this interface file are transmitted realtime. The alternative to realtime is batch.
REPROCESS_CPT_IND DOUBLE N Determines whether or not charges that have this interface file should be reprocessed due to an encounter modification. 0 - Don't reprocess changes when an encounter modification occurs and the CPT code changes; 1- Reprocess changes when an encounter modification occurs and the CPT code changes.
REPROCESS_IND DOUBLE N Determines whether or not charges that have this interface file should be reprocessed due to an encounter modification. 0 - Don't reprocess changes when an encounter modification occurs; 1 - reprocess changes when an encounter modification occurs.
REV_SCHED_CD DOUBLE N Stores the revenue code schedule. Used to determine if a charge should be suspended or not if they are missing the specified revenue code schedule.
ROUND_METHOD_FLAG DOUBLE Y Standard Rounding = 0, Always Round Up = 1, Always Round Down = 2. Defines how rounding should occur for non-Profit JCode processing
SERVICE_BASED_IND DOUBLE Y Indicates whether or not an interface tile is service based.
SF_HL7_IND DOUBLE Y Indicates that this interface file is used for Sorian Financials HL Interface.
SUSP_CHRG_PROCESS_FLAG DOUBLE N Defines how the suspended charges should be dealt with during the encounter mods process.0 - Disable 1 - Enable
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 - INTERFACE_FILE


Child Column in INTERFACE_FILE(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in INTERFACE_FILE (PK) Child Table Name Child Column Name
Children: INTERFACE_FILE_ID BT_COND_CRIT_GRP_RELTN INTERFACE_FILE_ID
CHARGE INTERFACE_FILE_ID


INTERVAL_TABLE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interval Table
Definition: Contains intervals of values to be used in price calculations.
Table Type: REFERENCE





Column Detail - INTERVAL_TABLE


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.
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.
BEG_VALUE DOUBLE N The starting value of this interval.
CALC_TYPE_CD DOUBLE N Code value from code_set 14275 that indicates how prices in this interval should be calculated. Valid values are price/interval, price/unit, and price/interval unit.
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.
END_VALUE DOUBLE N The ending value of this interval.
INTERVAL_ID DOUBLE N This is the value of the unique primary identifier of the interval_table table. It is an internal system assigned number.
INTERVAL_TEMPLATE_CD DOUBLE N Code value from code_set 14274 that indicates to what template this interval belongs.
UNIT_TYPE_CD DOUBLE N Code value from code_set 14276 that indicates what units this interval is expecting such as miles, minutes, hours.
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 - INTERVAL_TABLE




Parent Column in INTERVAL_TABLE (PK) Child Table Name Child Column Name
Children: INTERVAL_ID ITEM_INTERVAL_TABLE INTERVAL_ID


ITEM_INTERVAL_TABLE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Interval Table
Definition: Contains the price to be used within a particular price schedule for a particular bill item within a particular interval. Used only for interval price calculations.
Table Type: REFERENCE





Column Detail - ITEM_INTERVAL_TABLE


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.
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_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.
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.
INTERVAL_ID DOUBLE N This is the value of the unique primary identifier of the interval_table table. It is an internal system assigned number.
INTERVAL_TEMPLATE_CD DOUBLE N Code value from codeset 14274 that represents the template to which this price and interval are associated.
ITEM_INTERVAL_ID DOUBLE N This is the value of the unique primary identifier of the item_interval table. It is an internal system assigned number.
PARENT_ENTITY_ID DOUBLE N Indicates the id from either the workload code table or the price_sched_item table.
PARENT_ENTITY_NAME VARCHAR(200) N Workload_code or Price_sched_item to indicate where the parent_entity_id is from.
PRICE DOUBLE Y The price that will be used in calculating the total charge if the quantity passed falls into this interval.
UNITS DOUBLE Y Used to store the number of workload units if interval calculations are being 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 - ITEM_INTERVAL_TABLE


Child Column in ITEM_INTERVAL_TABLE(FK) Parent Table Name Parent Column Name
Parents: INTERVAL_ID INTERVAL_TABLE INTERVAL_ID




Parent Column in ITEM_INTERVAL_TABLE (PK) Child Table Name Child Column Name
Children: ITEM_INTERVAL_ID CHARGE ITEM_INTERVAL_ID