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 |