BCE_EVENT_BILL_MOD_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Batch Charge Entry Bill Item Modifier Relation
Definition: Identifies the associated BCE_EVENT_LOG charges to the BILL_ITEM_MODIFIER bill item prompts.
Table Type: ACTIVITY





Column Detail - BCE_EVENT_BILL_MOD_RELTN


Column Name Type Null? Definition
BCE_EVENT_BILL_MOD_RELTN_ID DOUBLE N Uniquely identifies an associated BCE_EVENT_LOG charge to a BILL_ITEM_MODIFIER bill item prompt.
BCE_EVENT_LOG_ID DOUBLE N Uniquely identifies a batch charge entry
BILL_ITEM_MOD_ID DOUBLE N Identifies the related Bill Item Modifier
PROMPT_VALUE VARCHAR(250) N Stores the value entered for a given prompt associated to a charge and a bill item.
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 - BCE_EVENT_BILL_MOD_RELTN


Child Column in BCE_EVENT_BILL_MOD_RELTN(FK) Parent Table Name Parent Column Name
Parents: BCE_EVENT_LOG_ID BCE_EVENT_LOG BCE_EVENT_LOG_ID
BILL_ITEM_MOD_ID BILL_ITEM_MODIFIER BILL_ITEM_MOD_ID


BCE_EVENT_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Batch Charge Entry Event Log
Definition: This table holds an audit trail of all the activity data generated by CSBatchChargeEntry.
Table Type: ACTIVITY





Column Detail - BCE_EVENT_LOG


Column Name Type Null? Definition
ABN_STATUS_CD DOUBLE N This field displays the status of the advanced beneficiary notice of the charge event - whether it was required, required and missing, or present.
ACCESSION VARCHAR(200) 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_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.
ADJUSTMENT_AMT DOUBLE N This column is obsolete and no longer used.
BATCH_ALIAS VARCHAR(200) N Stores and alias of internal batch number
BATCH_ALIAS_KEY VARCHAR(200) N Stores the corresponding string values of the batch alias column in upper case, less spaces or special characters to improve performance on searches.
BATCH_DESCRIPTION VARCHAR(200) N A brief textual description of the batch.
BATCH_DT_TM DATETIME N Batch date and time
BATCH_NUM DOUBLE Y The number assigned to a specific batch of charges entered in BCE.
BCE_EVENT_LOG_ID DOUBLE N This is the value of the unique primary identifier of the bce_event_log table. It is an internal system assigned number.
BILL_CODE_TXT VARCHAR(200) Y Text associated with the Bill Code.
BILL_ITEM_ID DOUBLE N The ID of the bill item that was ordered in BCE. This ID comes from the bill_item table.
CHARGE_DESCRIPTION VARCHAR(200) Y The description of what was ordered in BCE.
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 holds hte CPT-4 modifier code with the priority of 1.
CODE_MODIFIER2_CD DOUBLE N This field holds the CPT-4 modifier with a priority of 2.
CODE_MODIFIER3_CD DOUBLE N This field holds the CPT-4 modifier with a priority of 3.
CODE_MODIFIER4_CD DOUBLE N This field holds the CPT-4 modifier with a priority of 4.
DEPARTMENT_CD DOUBLE N Value from 221 that represents the department in the service resource hierarchy.
DIAG_CODE1 VARCHAR(200) Y This field holds the ICD-9 diagnosis code with a priority of 1.
DIAG_CODE1_DESC VARCHAR(200) Y This field holds the description of the ICD-9 diagnosis code with a priority of 1.
DIAG_CODE2 VARCHAR(200) Y This field holds the ICD-9 diagnosis code with a priority of 2.
DIAG_CODE2_DESC VARCHAR(200) Y This field holds the description of the ICD-9 diagnosis code with a priority of 2.
DIAG_CODE3 VARCHAR(200) Y This field holds the ICD-9 diagnosis code with a priority of 3.
DIAG_CODE3_DESC VARCHAR(200) Y This field holds the description of the ICD-9 diagnosis code with a priority of 3.
DIAG_CODE4 VARCHAR(200) Y This field holds the ICD-9 diagnosis code with a priority of 4.
DIAG_CODE4_DESC VARCHAR(200) Y This field holds the description of the ICD-9 diagnosis code with a priority of 4.
DIAG_CODE5 VARCHAR(200) Y This field holds the ICD-9 diagnosis code with a priority of 5.
DIAG_CODE5_DESC VARCHAR(200) Y This field holds the description of the ICD-9 diagnosis code with a priority of 5.
DIAG_CODE6 VARCHAR(200) Y This field holds the ICD-9 diagnosis code with a priority of 6.
DIAG_CODE6_DESC VARCHAR(200) Y This field holds the description of the ICD-9 diagnosis code with a priority of 6.
DIAG_CODE7 VARCHAR(200) Y This field holds the ICD-9 diagnosis code with a priority of 7.
DIAG_CODE7_DESC VARCHAR(200) Y This field holds the description of the ICD-9 diagnosis code with a priority of 7.
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
EXT_MASTER_EVENT_ID DOUBLE N This field holds a system generated number that uniquely identifies the charge entered in BCE.
INSTITUTION_CD DOUBLE N This is the value from codeset 221 that represents the institution in the service resource hierarchy.
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.
MISC_IND DOUBLE Y This field indicates whether or not a charge has been labelled as miscellaneous, which means the user will be prompted for the price and description when the item is ordered.
MODE_IND DOUBLE Y This column is used to determine which CSBatchChargeEntry mode added the record to the bce_event_log table. 0 = Profit View, 1 = Default View.
ORD_PHYS_ID DOUBLE N This is the unique identifier from the Prsnl table for the ordering physician.
PAYMENT_AMT DOUBLE N This column is obsolete and no longer used.
PERF_LOC_CD DOUBLE N Either the location_cd from the encounter table or the nurse unit/ambulatory location that the user chooses from the tree view.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRICE DOUBLE Y The price entered by the user for a miscellaneous bill item.
QUANTITY DOUBLE Y The quantity entered by the user on the charge.
REASON_CD DOUBLE N The credit reason entered on the charge.
REASON_COMMENT VARCHAR(200) Y Any comments entered by the user when crediting a charge.
REF_PHYS_ID DOUBLE N This is the unique identifier from the Prsnl table for the referring physician.
REN_PHYS_ID DOUBLE N This is the unique identifier from the Prsnl table for the rendering physician.
SECTION_CD DOUBLE N This is the value from codeset 221 that represents the section in the service resource hierarchy.
SERVICE_DT_TM DATETIME Y The service date and time entered on the charge.
SUBMIT_IND DOUBLE Y This field indicates whether or not the charge has been submitted to the CS Charging Server.
SUBSECTION_CD DOUBLE N This is the value from codeset 221 that represents the subsection in the service resource hierarchy.
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 - BCE_EVENT_LOG


Child Column in BCE_EVENT_LOG(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ACTIVE_STATUS_PRSNL_ID PERSON PERSON_ID
PERSON_ID PERSON PERSON_ID




Parent Column in BCE_EVENT_LOG (PK) Child Table Name Child Column Name
Children: BCE_EVENT_LOG_ID BCE_EVENT_BILL_MOD_RELTN BCE_EVENT_LOG_ID


BILL_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Item.
Definition: Contains all items/activities that can be billed for.
Table Type: REFERENCE





Column Detail - BILL_ITEM


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_ITEM_ID DOUBLE N This is the value of the unique primary identifier of the bill item .....
CALC_TYPE_CD DOUBLE N not used
CARESET_IND DOUBLE Y Identifies a bill item as a careset (an orderable is a group of other orderables and/or tasks).
CHARGE_POINT_CD DOUBLE N not used
CHILD_SEQ DOUBLE Y The child sequence is used for caresets only, to allow an orderable to be added into a careset multiple times.
COST_BASIS_AMT DOUBLE N This is the cost on which the final charge price is based on (before markups, discounts, tax, etc.)
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.
EXT_CHILD_CONTRIBUTOR_CD DOUBLE N Value from 13016 that represents the source of the child bill item. It makes the child reference id unique (in the case of multiple child reference id sources)
EXT_CHILD_ENTITY_NAME VARCHAR(32) Y Indicates whether the contributor was another bill item as in the case of specific addons as indicated by 'bill_item', or if it was an external contributor as indicated by 'code_value'. Primarily used for data merging.
EXT_CHILD_REFERENCE_ID DOUBLE N The id used to cross reference external child information to internal bill items during charging/pricing. For example, this contains the catalog_cd for order catalog items, or the task_assay_cd for discrete task assays, or the task_id for tasks.
EXT_DESCRIPTION VARCHAR(200) Y The description that will be used to define the bill item.
EXT_OWNER_CD DOUBLE N Code that indicates from what entry in codeset 106 this bill item was contributed. 106 entry examples include General Lab, Radiology, etc.
EXT_PARENT_CONTRIBUTOR_CD DOUBLE N Code that makes the parent reference id unique (in the case of multiple parent reference id sources)
EXT_PARENT_ENTITY_NAME VARCHAR(32) Y Indicates whether the contributor for the parent was another bill item as in the case of specific as indicated by 'bill_item', or if it was an external contributor as indicated by 'code_value'. This is blank for default children.
EXT_PARENT_REFERENCE_ID DOUBLE N The id used to cross reference external parent information to internal bill items during charging/pricing.
EXT_SHORT_DESC VARCHAR(50) Y The short description sent from the contributor.
EXT_SUB_OWNER_CD DOUBLE N Code that indicates from what entry in codeset 5801 this bill item was contributed. 5801 entry examples include Toxicology, Immunology, etc.
LATE_CHRG_EXCL_IND DOUBLE Y Allows the user to designate that a bill item should always be excluded from Profit's late charge processing logic.
LOGICAL_DOMAIN_ENABLED_IND DOUBLE N The indicator for logical domain is enabled or not.
LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which this bill item is related.
MISC_IND DOUBLE Y This field is used by CSBatchChargeEntry to determine if it needs to prompt for price, description, etc.
NUM_HITS DOUBLE Y This field is essentially a counter that keeps track of the number of times this particular bill item is hit by the server.
PARENT_QUAL_CD DOUBLE N Indicates if the bill item is a parent. Should not have the "cd" extension.
PARENT_QUAL_IND DOUBLE Y Indicates if the bill item is a parent.
PHYSICIAN_QUAL_CD DOUBLE N not used
STATS_ONLY_IND DOUBLE Y This field indicates that a charge generated for this item will not be interfaced. It is captured for statistical purposes only.
TAX_IND DOUBLE Y Tax indicator
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.
WORKLOAD_ONLY_IND DOUBLE Y Determines whether this bill item is for workload use only. It is used to filter bill items from the Pricing Tool when not in workload mode.



Relationship Detail - BILL_ITEM


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




Parent Column in BILL_ITEM (PK) Child Table Name Child Column Name
Children: BILL_ITEM_ID BH_GROUP_DOC PROPOSED_BILL_ITEM_ID
BH_GROUP_DOC_PATIENT_CS BILL_ITEM_ID
BILL_ITEM_MODIFIER BILL_ITEM_ID
BILL_ITEM_MODIFIER_HIST BILL_ITEM_ID
BT_COND_CRIT_GRP_RELTN BILL_ITEM_ID
CHARGE BILL_ITEM_ID
CHARGE DEF_BILL_ITEM_ID
CHARGE_BATCH_DETAIL BILL_ITEM_ID
GL_TRANS_QUALIFIER BILL_ITEM_ID
PFT_BILL_ITEM_COND_CRIT_RELTN BILL_ITEM_ID
PFT_REVENUE_SUMMARY BILL_ITEM_ID
PRICE_SCHED_ITEMS BILL_ITEM_ID
PRICE_SCHED_ITEMS_HIST BILL_ITEM_ID
UM_CHARGE_EVENT_ST BILL_ITEM_ID
UM_CHARGE_EVENT_ST PARENT_BILL_ITEM_ID
VISITCODING_BILLITEM BILL_ITEM_ID
WORKLOAD BILL_ITEM_ID


BILL_ITEM_MODIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Item Modifier
Definition: Additional information connected to a bill item that may modify pricing of bill items such as addon items, charge points, bill codes. Bill_item_type_cd defines the type of modification.
Table Type: REFERENCE





Column Detail - BILL_ITEM_MODIFIER


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_ITEM_ID DOUBLE N ID of the bill item on the bill_item table to which this modification is associated. This is the unique primary identifier of the bill_item table.
BILL_ITEM_MOD_ID DOUBLE N This is the value of the unique primary identifier of the bill item modifier table. It is an internal system assigned number.
BILL_ITEM_TYPE_CD DOUBLE N Code from 13019 that indicates what type of bill item modifier this row is, such as addon, bill code, or charge point.
BIM1_IND DOUBLE Y This field holds the indicator for result as quantity for workload.
BIM1_INT DOUBLE Y This field stores the quantity, priority or binary representation based on the type cd.
BIM1_NBR DOUBLE Y This field holds the unit override for workload. This will allow the user to override the units default off of the workload_code table and enter a different value.
BIM2_INT DOUBLE Y This field stores a multiplier based on the type code.
BIM_IND DOUBLE Y This field stores the projected indicator based on the type cd.
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.
KEY1 VARCHAR(200) Y not used
KEY10 VARCHAR(200) Y not used
KEY11 VARCHAR(200) Y not used
KEY11_ID DOUBLE N For Workload only, contains an override value for the multiplier, or (-1) if there is no override.
KEY12 VARCHAR(200) Y not used
KEY12_ID DOUBLE N For Workload only, contains the code value of the template to be used for interval calculation of Workload units. This is an optional value. Still considering whether this value can be specified here or if it must come from the Workload Standard.
KEY13 VARCHAR(200) Y not used
KEY13_ID DOUBLE N Indicates whether this workload row should be considered projected or not. This is used primarily by Work Assignment in pulling projected workload values into the application.
KEY14 VARCHAR(200) Y not used
KEY14_ID DOUBLE N The unique identifier to the workload_standard table.
KEY15 VARCHAR(200) Y not used
KEY15_ID DOUBLE N Unique identifier to the code_value table for the item for count on the workload. This is usually going to be a (-1) to indicate that the value on the standard is not being overridden.
KEY1_ENTITY_NAME VARCHAR(32) Y not used
KEY1_ID DOUBLE N Depending on the bill_item_type_cd, this is the code value of the charge point or bill code schedule from 14002, or it is the bill_item_id of the addon from the bill_item table.
KEY2 VARCHAR(200) Y not used
KEY2_ENTITY_NAME VARCHAR(32) Y not used
KEY2_ID DOUBLE N Depending on the bill_item_type_cd, this is the priority of bill codes; for charge points it is the code value from 13029 for the actual charge point; and for addons, is the code value from 106 (external owner).
KEY3 VARCHAR(200) Y not used
KEY3_ENTITY_NAME VARCHAR(32) Y not used
KEY3_ID DOUBLE N Depending on the bill_item_type_cd, this is not used for bill codes; it indicates whether the charge point is manual for charge points; and represents the quantity of the addon.
KEY4 VARCHAR(200) Y not used
KEY4_ENTITY_NAME VARCHAR(32) Y not used
KEY4_ID DOUBLE N not used
KEY5 VARCHAR(200) Y not used
KEY5_ENTITY_NAME VARCHAR(32) Y not used
KEY5_ID DOUBLE N not used
KEY6 VARCHAR(200) Y Depending on the bill_item_type_cd, this is the bill code; not used for charge points; is the description of the addon.
KEY7 VARCHAR(350) Y Depending on the bill_item_type_cd, it is the description of the bill code; not used for charge points; not used for addons.
KEY8 VARCHAR(200) Y not used
KEY9 VARCHAR(200) Y not used
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - BILL_ITEM_MODIFIER


Child Column in BILL_ITEM_MODIFIER(FK) Parent Table Name Parent Column Name
Parents: BILL_ITEM_ID BILL_ITEM BILL_ITEM_ID




Parent Column in BILL_ITEM_MODIFIER (PK) Child Table Name Child Column Name
Children: BILL_ITEM_MOD_ID BCE_EVENT_BILL_MOD_RELTN BILL_ITEM_MOD_ID
BILL_ITEM_MODIFIER_HIST BILL_ITEM_MOD_ID
PFT_FEE_SCHED_RELTN BILL_ITEM_MOD_ID


BILL_ITEM_MODIFIER_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Item Modifier History
Definition: Stores all the Charge service Pricing, Bill Item related modifications and for tracking the History of changes.
Table Type: ACTIVITY





Column Detail - BILL_ITEM_MODIFIER_HIST


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.
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_ITEM_ID DOUBLE N ID of the bill item on the bill_item table to which this modification is associated. This is the unique primary identifier of the bill_item table.
BILL_ITEM_MODIFIER_HIST_ID DOUBLE N Unique generated number that identifies a single row on the BILL_ITEM_MODIFIER_HIST table.
BILL_ITEM_MOD_ID DOUBLE N This is the value of the unique primary identifier of the bill item modifier table. It is an internal system assigned number.
BILL_ITEM_TYPE_CD DOUBLE N Code from 13019 that indicates what type of bill item modifier this row is, such as addon, bill code, or charge point.
BIM1_IND DOUBLE Y This field holds the indicator for result as quantity for workload.
BIM1_INT DOUBLE Y To persist priority, quantity or Order based on the bill code type as per the original table.
BIM1_NBR DOUBLE Y This field holds the unit override for workload. This will allow the user to override the units default off of the workload_code table and enter a different value. To persist QCF, workload units as per the original table
BIM2_INT DOUBLE Y This field stores a multiplier based on the type code. To persist multiplier override as per the original table.
BIM_IND DOUBLE Y This field stores the projected indicator based on the type cd.
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.
KEY1 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY10 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY11 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY11_ID DOUBLE N Reserved for future use as per the original table.
KEY12 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY12_ID DOUBLE N For Workload only, contains the code value of the template to be used for interval calculation of Workload units. This is an optional value. Still considering whether this value can be specified here or if it must come from the Workload Standard. To persist the possible values as per the modifications on the bill items.template_cd (14274), CODE_ VALUE parent entity.
KEY13 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY13_ID DOUBLE N Indicates whether this workload row should be considered projected or not. This is used primarily by Work Assignment in pulling projected workload values into the application.
KEY14 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY14_ID DOUBLE N To persist the possible values as per the modifications on the bill items.workload_standard_id, WORKLOAD_STANDARD parent entity
KEY15 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY15_ID DOUBLE N Unique identifier to the code_value table for the item for count on the workload. This is usually going to be a (-1) to indicate that the value on the standard is not being overridden. To persist the possible values as per the modifications on the bill items.item_for_count_cd(15229), CODE_ VALUE parent entity.
KEY1_ENTITY_NAME VARCHAR(30) Y To persist the Key1 Entity Name which is usually 'CODE_VALUE' as per the original table Bill_Item_Modifier.
KEY1_ID DOUBLE N To persist the possible values as per the modifications on the bill items.14002 (code schedules,charge point schedules,code schedules),value from 305570 (stores prompts),bill item id of the addon
KEY2 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY2_ENTITY_NAME VARCHAR(30) Y To persist the Key2 Entity Name which is usually 'CODE_VALUE' as per the original table Bill_Item_Modifier.
KEY2_ID DOUBLE N Depending on the bill_item_type_cd, this is the priority of bill codes; for charge points it is the code value from 13029 for the actual charge point; and for addons, is the code value from 106 (external owner).
KEY3 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY3_ENTITY_NAME VARCHAR(30) Y To persist the Key3 Entity Name which is usually 'CODE_VALUE' as per the original table Bill_Item_Modifier.
KEY3_ID DOUBLE N To persist the possible values as per the modifications on the bill items.workload_code_id, nomen_id
KEY4 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY4_ENTITY_NAME VARCHAR(30) Y To persist the Key4 Entity Name which is usually 'CODE_VALUE' as per the original table Bill_Item_Modifier.
KEY4_ID DOUBLE N To persist the possible values as per the modifications on the bill items.charge level from 13020
KEY5 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY5_ENTITY_NAME VARCHAR(30) Y To persist the Key5 Entity Name which is usually 'CODE_VALUE' as per the original table Bill_Item_Modifier.
KEY5_ID DOUBLE N To persist the possible values as per the modifications on the bill items.code value forrevenue codes(20769) and modifiers (17769)
KEY6 VARCHAR(200) Y To persist Key information associated to a bill item except the prices. (Bill codes).
KEY7 VARCHAR(200) Y To persist Key information associated to a bill item except the prices. (Description)
KEY8 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
KEY9 VARCHAR(200) Y To persist Key information associated to a bill item except the prices.
MODIFICATION_DT_TM DATETIME N Represents the modified date and time of the parent record.
PERMANENT_DEL_IND DOUBLE N The indicator to mark History records that are no longer needed and are made eligible for permanent deletion.
TASK_ACTION_FLAG DOUBLE N To persist and represent the type of Task action performed/ or the correspodning history row represents.(Values 0= Add, 1= Update, 2= Delete)
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 - BILL_ITEM_MODIFIER_HIST


Child Column in BILL_ITEM_MODIFIER_HIST(FK) Parent Table Name Parent Column Name
Parents: BILL_ITEM_ID BILL_ITEM BILL_ITEM_ID
BILL_ITEM_MOD_ID BILL_ITEM_MODIFIER BILL_ITEM_MOD_ID