Table Detail Report

NOMEN_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: NOMEN GROUP RELTN
Definition: Nomenclature Group Relation
Table Type: REFERENCE





Column Detail - NOMEN_GROUP_RELTN


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 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.
BT_COND_CRIT_R_ID DOUBLE N Bill Template Condition Criteria Relation
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.
NOMEN_GROUP_R_ID DOUBLE N Nomenclature Group Relation ID
NOMEN_ID DOUBLE N Nomenclature ID
SOURCE_VOCAB_CD DOUBLE N Source Vocabulary Code
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 - NOMEN_GROUP_RELTN


Child Column in NOMEN_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: BT_COND_CRIT_R_ID BT_COND_CRIT_RELTN BT_COND_CRIT_R_ID
NOMEN_ID NOMENCLATURE NOMENCLATURE_ID


PFT_CHARGE_GLOBAL_DAYS



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Charge Global Days
Definition: Stores the charge related information which qualifies for the global billing.
Table Type: ACTIVITY





Column Detail - PFT_CHARGE_GLOBAL_DAYS


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.
ENCNTR_ID DOUBLE N Uniquely identifies the related encounter record.
GLOBAL_DAYS DOUBLE N Once a person has a medical procedure, there is a period of time that if that same person were to come back to the hospital for the same procedure within a given time frame the services will not be covered by insurance. This timeframe is referred to as global days.
GLOBAL_DAYS_END_DT_TM DATETIME N Contains the service date plus the global days.
MOD_NOMEN_ID DOUBLE N Stores the CPT modifier nomenclature identifier
ORGANIZATION_ID DOUBLE N Uniquely identifies the related organization.
PERSON_ID DOUBLE N Uniquely Identifies the related person.
PFT_CHARGE_GLOBAL_DAYS_ID DOUBLE N Uniquely identifies charge related information that qualifies for the global billing.
PFT_CHARGE_ID DOUBLE N Uniquely identifies a related ProFit charge.
PROC_NOMEN_ID DOUBLE N Stores the HCPCS/CPT Nomenclature Identifier
SERVICE_DT_TM DATETIME Y Stores the service date on which the charge is dropped.
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.
VERIFY_PHYS_ID DOUBLE N Stores the verifying physician identifier



Relationship Detail - PFT_CHARGE_GLOBAL_DAYS


Child Column in PFT_CHARGE_GLOBAL_DAYS(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
MOD_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
PROC_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PFT_CHARGE_ID PFT_CHARGE PFT_CHARGE_ID
VERIFY_PHYS_ID PRSNL PERSON_ID


PRICE_SCHED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Price Schedule
Definition: Describes Price Schedules.
Table Type: REFERENCE





Column Detail - PRICE_SCHED


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.
APPLY_MARKUP_TO_FLAG DOUBLE N Indicates whether markup and fees are calculated on the entire dose or by product units (applies only to records with Pharm_ind = 1) 0 - Dose, 1 - Product Unit
APPLY_SVC_FEE_IND DOUBLE Y Indicates whether or not to apply a Service Fee (valid only on records w/pharm_ind = 1).
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.
COMPLIANCE_CHECK_IND DOUBLE Y Used for compliance checking for rate
CONVERSION_FACTOR_CD DOUBLE N This column in longer used
COST_BASIS_CD DOUBLE N The code value from 4050 indicating the cost basis to be used in calculating PharmNet charges.
CREATE_DT_TM DATETIME Y The date and time the price schedule was created.
CREATE_PRSNL_ID DOUBLE N The person ID from the prsnl table who created the price schedule.
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.
FORMULA_TYPE_FLG DOUBLE Y Indicates whether the formula type is order or ingredient (applies only to records with pharm_ind = 1)
MARKUP_LEVEL_FLG DOUBLE Y Indicates where the markup level is order or ingredient (applies only to records w/pharm_ind = 1).
MIN_PRICE DOUBLE Y This column represents the minimum price that an item can be regardless of any algorithms applied to calculate price.
OPERATING_MARGIN_PCT DOUBLE N This column in longer used
PHARM_IND DOUBLE N Indicates if this record is a pharmacy price schedule.
PHARM_TYPE_CD DOUBLE N Indicates the pharmacy domain related to the Price Schedule. The Price Schedule is tailored to a Retail Pharmacy's specific needs to calculate the price of a prescription.
PRICE_SCHED_DESC VARCHAR(200) Y The description given to the price schedule.
PRICE_SCHED_ID DOUBLE N This is the value of the unique primary identifier of the price_sched table. It is an internal system assigned number.
PRICE_SCHED_SHORT_DESC VARCHAR(50) Y The short description given to the price schedule.
RANGE_TYPE_CD DOUBLE N Indicates the type of range for the FROM and TO parameters on the Price Range table. This includes COST, QTY and DAYS SUPPLY.
ROUNDING_RATE_FLAG DOUBLE N Per price schedule to round up/down/standard
ROUND_UP DOUBLE Y This column represents a value to be applied towards the price based on defined rounding methods.
SELF_PAY_IND DOUBLE N The self pay indicator identifies if the bill is the patient's responsibility or not.
STANDARD_SCHED_IND DOUBLE Y Indicates whether or not the price schedule is the standard price schedule for the related organization.
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.
WARNING_DT_TM DATETIME Y The warning date and time specified when the price schedule was created.
WARNING_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that specified the warning date, time and type code for this price schedule.
WARNING_TYPE_CD DOUBLE N The code value from 13032 indicating the mechnism by which a warning will be issued. Options include telephone and send email.



Relationship Detail - PRICE_SCHED


Child Column in PRICE_SCHED(FK) Parent Table Name Parent Column Name
Parents: WARNING_PRSNL_ID PRSNL PERSON_ID




Parent Column in PRICE_SCHED (PK) Child Table Name Child Column Name
Children: PRICE_SCHED_ID CHARGE LIST_PRICE_SCHED_ID
CHARGE PRICE_SCHED_ID
DISPENSE_CATEGORY PRICE_SCHED_ID
MEDICATION_DEFINITION PRICE_SCHED_ID
MED_OE_DEFAULTS PRICE_SCHED_ID
MM_CS_PATIENT_PRICE PRICE_SCHED_ID
MM_PRICE_FORMULA PRICE_SCHED_ID
ORDER_DISPENSE PRICE_SCHEDULE_ID
PRICE_CODE_EXCEPTION COPAY_PRICE_SCHED_ID
PRICE_CODE_EXCEPTION PRICE_SCHED_ID
PRICE_RANGE PRICE_SCHED_ID
PRICE_SCHED_ITEMS PRICE_SCHED_ID
PRICE_SCHED_ITEMS_HIST PRICE_SCHED_ID
PROD_DISPENSE_HX PRICE_SCHED_ID
RX_ADMIN_PROD_DISPENSE_HX PRICE_SCHED_ID


PRICE_SCHED_ITEMS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Price Schedule Items
Definition: Associates Bill Items with Price Schedules. Prices the item.
Table Type: REFERENCE





Column Detail - PRICE_SCHED_ITEMS


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.
ALLOWABLE DOUBLE Y not used
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.
BILLING_DISCOUNT_PRIORITY_SEQ DOUBLE N Billing priority on the bill item for the associated price schedule
BILL_ITEM_ID DOUBLE N This is the value of the unique primary identifier of the bill item table. It is an internal system assigned number.
CAPITATION_IND DOUBLE Y Indicates whether or not the price schedule item is a capitated, meaning that insurance will pay a per member/per month fee instead of a fee for service.
CHARGE_LEVEL_CD DOUBLE N not used..
COPAY DOUBLE Y not used
COST_ADJ_AMT DOUBLE N The markup or discount amount reflected in the final charge price.
DEDUCTIBLE DOUBLE Y not used
DETAIL_CHARGE_IND DOUBLE Y For a detail (child) bill item, indicates whether a charge should be created. This flag is set by the "charge" check box in the Pricing Tool.
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.
EXCLUSIVE_IND DOUBLE N Determines whether or not the tax amount will show up as a separate line item on the invoice. 0 = it will not show up as a separate line item on the invoice, 1 = it will show up as a separate line item on the invoice.
INTERVAL_TEMPLATE_CD DOUBLE N The code value from 14274 that indicates which interval template to use in determining what price to assign to a charge. A value of 0 indicates to use the price without any interval logic.
PERCENT_REVENUE DOUBLE Y not used
PRICE DOUBLE Y The price to associate with this bill item for this price schedule.
PRICE_SCHED_ID DOUBLE N This is the value of the unique primary identifier of the price_sched table. It is an internal system assigned number.
PRICE_SCHED_ITEMS_ID DOUBLE N This is the value of the unique primary identifier of the price_sched_items table. It is an internal system assigned number.
REFERRAL_REQ_IND DOUBLE Y Indicates whether or not the price schedule item requires a referral
STATS_ONLY_IND DOUBLE Y This allows the user to track statistics at the price schedule level instead of at the bill item level like it currently exists.
TAX DOUBLE N The tax amount for a given price schedule for a given bill item based on a tax percentage.
UNITS_IND DOUBLE Y This indicates whether a price is stored or if units are stored. This was included to accommodate LMS Billing requirements (Canadian).
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 - PRICE_SCHED_ITEMS


Child Column in PRICE_SCHED_ITEMS(FK) Parent Table Name Parent Column Name
Parents: BILL_ITEM_ID BILL_ITEM BILL_ITEM_ID
PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID




Parent Column in PRICE_SCHED_ITEMS (PK) Child Table Name Child Column Name
Children: PRICE_SCHED_ITEMS_ID PFT_FEE_SCHED_RELTN PRICE_SCHED_ITEMS_ID
PRICE_SCHED_ITEMS_HIST PRICE_SCHED_ITEMS_ID


PRICE_SCHED_ITEMS_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Price Schedule Items History.
Definition: Stores all the Charge service Bill Item's Price Schedules related modifications and for tracking the History of changes.
Table Type: ACTIVITY





Column Detail - PRICE_SCHED_ITEMS_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.
ALLOWABLE DOUBLE Y To persist Allowable information associated to a bill item for this price schedule.
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.
BILLING_DISCOUNT_PRIORITY_SEQ DOUBLE N To persist the billing priority on the bill item for the associated price schedule.
BILL_ITEM_ID DOUBLE N This is the value of the unique primary identifier of the bill item table. It is an internal system assigned number.
CAPITATION_IND DOUBLE Y Indicates whether or not the price schedule item is a capitated, meaning that insurance will pay a per member/per month fee instead of a fee for service.
CHARGE_LEVEL_CD DOUBLE N To persist Charge Level Code information associated to a bill item for this price schedule.
COPAY DOUBLE Y To persist Copay information associated to a bill item for this price schedule.
COST_ADJ_AMT DOUBLE N The markup or discount amount reflected in the final charge price.
DEDUCTIBLE DOUBLE Y To persist Deductible information associated to a bill item for this price schedule.
DETAIL_CHARGE_IND DOUBLE Y For a detail (child) bill item, indicates whether a charge should be created. This flag is set by the "charge" check box in the Pricing Tool.
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.
EXCLUSIVE_IND DOUBLE N Determines whether or not the tax amount will show up as a separate line item on the invoice. 0 = it will not show up as a separate line item on the invoice, 1 = it will show up as a separate line item on the invoice.
INTERVAL_TEMPLATE_CD DOUBLE N The code value from 14274 that indicates which interval template to use in determining what price to assign to a charge. A value of 0 indicates to use the price without any interval logic.
MODIFICATION_DT_TM DATETIME N Represents the modified date and time of the parent record.
PERCENT_REVENUE DOUBLE Y To persist Percent Revenue information associated to a bill item for this price schedule.
PERMANENT_DEL_IND DOUBLE N The indicator to mark History records that are no longer needed and are made eligible for permanent deletion.
PRICE DOUBLE Y The price to associate with this bill item for this price schedule.
PRICE_SCHED_ID DOUBLE N This is the value of the unique primary identifier of the price_sched table. It is an internal system assigned number.
PRICE_SCHED_ITEMS_HIST_ID DOUBLE N Bill Item's Price Schedule History Identifier - Unique generated number that identifies a single row on the PRICE_SCHED_ITEMS_HIST table.
PRICE_SCHED_ITEMS_ID DOUBLE N Identifies the corresponding Price Schedule Items record from the original PRICE_SCHED_ITEMS table for which the history of modified records is to be persisted.
REFERRAL_REQ_IND DOUBLE Y Indicates whether or not the price schedule item requires a referral
STATS_ONLY_IND DOUBLE Y This allows the user to track statistics at the price schedule level instead of at the bill item level like it currently exists.
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)
TAX DOUBLE N The tax amount for a given price schedule for a given bill item based on a tax percentage.
UNITS_IND DOUBLE Y This indicates whether a price is stored or if units are stored. This was included to accommodate LMS Billing requirements (Canadian).
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 - PRICE_SCHED_ITEMS_HIST


Child Column in PRICE_SCHED_ITEMS_HIST(FK) Parent Table Name Parent Column Name
Parents: BILL_ITEM_ID BILL_ITEM BILL_ITEM_ID
PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID
PRICE_SCHED_ITEMS_ID PRICE_SCHED_ITEMS PRICE_SCHED_ITEMS_ID