Table Detail Report

TIER_MATRIX



Column Section Top of Page


Table-level Detail

Description: Tier Matrix
Definition: Contains the tier data. These are the rules needed to assign prices, bill codes, and charge points to charges.
Table Type: REFERENCE





Column Detail - TIER_MATRIX


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.
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.
TIER_CELL_ENTITY_NAME VARCHAR(32) Y The table in which the tier_cell_value_id can be found.
TIER_CELL_ID DOUBLE N This is the value of the unique primary identifier of the tier cell. It is an internal system assigned number.
TIER_CELL_STRING VARCHAR(50) Y This is the field will contain alphanumeric values such as the institutional financial number based on the value in the tier cell type cd field.
TIER_CELL_TYPE_CD DOUBLE N The value from 13036 that represents the type of information that will be contained within the cell.
TIER_CELL_VALUE DOUBLE Y The value stores most all other values that tier_cell_value_id does not store such as flat discount, check diagnosis and check physician.
TIER_CELL_VALUE_ID DOUBLE N This is the value based on the tier_cell_entity_name and tier_cell_type_cd. It will either be a code_value or a id from another table such as price_sched, organization or interface_file.
TIER_COL_NUM DOUBLE Y The number of the column in the matrix. This determines the order the columns will display in the Tier Maintenance tool.
TIER_GROUP_CD DOUBLE N The value from 13035 that represents the tier group that this cell is contained within.
TIER_ROW_NUM DOUBLE Y The number of the row in the matrix. This determines the priority of the rule, and the order it displays in the Tier Maintenance tool.
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.


WORKLOAD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workload
Definition: Holds workload information at the discrete level. This is not statistical data.
Table Type: ACTIVITY





Column Detail - WORKLOAD


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y The accession number associated with the service or activity. It represents a specimen or case. This will not be associated with every workload row.
ACCRUED_DT_TM DATETIME Y The date and time the charge was created.
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.
ACTIVITY_TYPE_CD DOUBLE N This value identifies what "net" (PathNet, RadNet) and/or what department (General Lab, Micro) a bill item belongs to.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BILL_ITEM_ID DOUBLE N This is the value of the unique primary identifier of the bill_item table.
CHARGE_EVENT_ACT_ID DOUBLE N This is the value of the unique primary identifier of the charge_event_act table. It is an internal system assigned number.
CHARGE_EVENT_ID DOUBLE N This is the value of the unique primary identifier of the charge_event table.
DEF_BILL_ITEM_ID DOUBLE N This is the value of the unique primary identifier of the bill_item table. It represents the bill item id of the default child bill item when a unique or default bill item have been used in accruing workload.
DEPT_CD DOUBLE N The code value from code_set 220 that represents the department where the service or activity was performed. The service resource on the charge event is used to determine the department. If the charge event is associated with a clinical event that occur
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 This field is the value from codeset 71 that represents visit type.
EXTENDED_UNITS DOUBLE Y The number of units that were calculated by the server using the multiplier and interval logic if necessary.
INSTITUTION_CD DOUBLE N This is the value from code set 221 that represents the institution in the service resource heirarchy.
ITEM_FOR_COUNT_CD DOUBLE N This code value indicates accrual frequency for the item. An example might be per specimen.
MANUAL_ENTRY_IND DOUBLE Y Indicates that this workload row was added using Workload Entry, it was not automatically accrued based on clinical activity.
MED_SERVICE_CD DOUBLE N This is the value from codeset 34 that represents the category of treatment, surgery, or general resources.
MULTIPLIER DOUBLE Y The raw number of units that were assigned based on the standard or the number of units entered in the Pricing Tool.
ORD_PHYS_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number. It represents the physician who ordered the service or activity.
ORG_ID DOUBLE N This is the value of the unique primary identifier of the organization table. .
PARENT_WORKLOAD_ID DOUBLE N This is the value of the unique primary identifier of the workload table. . It represents the identifier of the workload row that resulted from the parent bill item.
PAT_LOC_CD DOUBLE N The code value of the patient location from codeset 221. This is at the nurse unit/amulatory location level.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
POSITION_CD DOUBLE N This value represents the position of the person in the prsn_id field. For example, RN, LPN etc.
PROJECTED_DT_TM DATETIME Y Not used
PROJECTED_IND DOUBLE Y Not used
PRSNL_ID DOUBLE N This is the value of the unique primary identifier of the workload_standard table. It is an internal system assigned number. It represents the person who completed the event that resulted in this workload row.
QTY DOUBLE Y This field contains the quantity for the number of units that will be multiplied to the workload multiplier in order to figure the volume of workload.
RAW_COUNT DOUBLE Y Raw procedure count.
REASON_CD DOUBLE N This is the field for the reason code
REASON_COMMENT VARCHAR(200) Y This field has the description for the reason code
REPEAT_IND DOUBLE Y Indicates whether this row is a result of repeated tests, used only for PathNet.
SECTION_CD DOUBLE N The code value from code_set 220 that represents the section where the service or activity was performed. The service resource on the charge event is used to determine the section if the charge event is associated with a clinical event that occurs before.
SERVICE_DT_TM DATETIME Y The date and time that the service was complete for the event that resulted in this workload row.
SERVICE_RESOURCE_CD DOUBLE N The code value from code_set 220 that represents the performing location of the service or activity. This could be an instrument, bench, exam room, or a role for tasks.
SUBSECTION_CD DOUBLE N The code value from code_set 220 that represents the subsection where the service or activity was performed. The service resource on the charge event is used to determine the subsection If the charge event is associated with a clinical event that occurs
UNITS DOUBLE Y The number of units that were calculated by the server using the multiplier and interval logic if necessary.
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.
WL_BOOK_CD DOUBLE N This value represents the book that this particular item's code was within.
WL_CHAPTER_CD DOUBLE N This value represents the chapter that the item's code was within.
WL_CODE VARCHAR(50) Y The code associated with this service or activity as assigned by the server using either the workload standard or the code entered in the Pricing Tool.
WL_CODE_DESC VARCHAR(200) Y The description associated with the workload code. This is either from the standard, or is entered in the Pricing Tool.
WL_CODE_SCHED_CD DOUBLE N This value represents the workload schedule from code set 14002 that the workload code belongs to.
WL_SECTION_CD DOUBLE N This value represents the section that the item's code was within.
WORKLOAD_ID DOUBLE N This is the value of the unique primary identifier of the workload table. It is an internal system assigned number.
WORKLOAD_STANDARD_ID DOUBLE N This is the value of the unique primary identifier of the workload_standard table.
WORKLOAD_TYPE_CD DOUBLE N Indicates if the workload is accrued, modified, or credited.



Relationship Detail - WORKLOAD


Child Column in WORKLOAD(FK) Parent Table Name Parent Column Name
Parents: BILL_ITEM_ID BILL_ITEM BILL_ITEM_ID
CHARGE_EVENT_ID CHARGE_EVENT CHARGE_EVENT_ID
WORKLOAD_STANDARD_ID WORKLOAD_STANDARD WORKLOAD_STANDARD_ID


WORKLOAD_CODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores workload codes
Definition: workload code
Table Type: REFERENCE





Column Detail - WORKLOAD_CODE


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.
CODE VARCHAR(50) Y The workload code, eventually this will be tied back to nomenclature.
DESCRIPTION VARCHAR(200) Y The description of the workload code. This would usually come directly from the standard.
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.
EVENT_CD DOUBLE N Value from 13029 that represents the event that will trigger this workload code.
INTERVAL_TEMPLATE_CD DOUBLE N Value from 14274 that represents the intervals to be used in calculating the workload units to accrue for a particular workload code for this unit_type.
ITEM_FOR_COUNT_CD DOUBLE N The code value from codeset 15229 that shows the recommended method for counting workload for this code. Examples include plate/bottle/tube, test, analyte, specimen, person, etc.
LABOR_TYPE DOUBLE Y not used
MULTIPLIER DOUBLE Y Number by which to multiply the number of units.
NOMEN_ID DOUBLE N This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number.
NOTE VARCHAR(200) Y Free text area for the user to enter extra notes that are either specific to the organization's use of this workload code, or could be extra notes that are defined in the standard.
UNITS DOUBLE Y Number of units. This is usually the value recommended by the standard.
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_CODE_ID DOUBLE N This is the value of the unique primary identifier of the workload_code table. It is an internal system assigned number.
WORKLOAD_STANDARD_ID DOUBLE N This is the value of the unique primary identifier of the workload_standard table.



Relationship Detail - WORKLOAD_CODE


Child Column in WORKLOAD_CODE(FK) Parent Table Name Parent Column Name
Parents: WORKLOAD_STANDARD_ID WORKLOAD_STANDARD WORKLOAD_STANDARD_ID




Parent Column in WORKLOAD_CODE (PK) Child Table Name Child Column Name
Children: WORKLOAD_CODE_ID WORKLOAD_GROUP WORKLOAD_CODE_ID


WORKLOAD_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Workload Group
Definition: Holds the relationships between the standards, books, chapters, and sections within workload standards.
Table Type: REFERENCE





Column Detail - WORKLOAD_GROUP


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.
BOOK_CD DOUBLE N The code value from codeset 15230 that represents the book that this code is within.
CHAPTER_CD DOUBLE N The code value from codeset 15230 that represents the book that this code is within.
SECTION_CD DOUBLE N The code value from codeset 15230 that represents the book that this code is within.
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_CODE_ID DOUBLE N This is the value of the unique primary identifier of the wrokload_code table.
WORKLOAD_GROUP_ID DOUBLE N This is the value of the unique primary identifier of the workload_group table. It is an internal system assigned number.
WORKLOAD_STANDARD_ID DOUBLE N This is the value of the unique primary identifier of the workload_standard table.



Relationship Detail - WORKLOAD_GROUP


Child Column in WORKLOAD_GROUP(FK) Parent Table Name Parent Column Name
Parents: WORKLOAD_CODE_ID WORKLOAD_CODE WORKLOAD_CODE_ID
WORKLOAD_STANDARD_ID WORKLOAD_STANDARD WORKLOAD_STANDARD_ID


WORKLOAD_STANDARD



Column Section Relationship Section Top of Page


Table-level Detail

Description: workload standards
Definition: defines workload standards
Table Type: REFERENCE





Column Detail - WORKLOAD_STANDARD


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.
BILL_CODE_IND DOUBLE Y Tells whether the codes entered for this standard are on an existing bill code schedule (such as the CDM or CPT4) or if it is a workload code schedule.
CODE_FORMAT DOUBLE Y Not Used
CODE_SCHED_CD DOUBLE N The code value of the code schedule that will be used to hold the workload codes for each activity.
DEPARTMENT_CD DOUBLE N Not Used
DESCRIPTION VARCHAR(200) N Textual description of this standard, such as CAP, LMIP, Canada.
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_STANDARD_ID DOUBLE N This is the value of the unique primary identifier of the workload_standard table. This is an internal system assigned number.



Relationship Detail - WORKLOAD_STANDARD




Parent Column in WORKLOAD_STANDARD (PK) Child Table Name Child Column Name
Children: WORKLOAD_STANDARD_ID WORKLOAD WORKLOAD_STANDARD_ID
WORKLOAD_CODE WORKLOAD_STANDARD_ID
WORKLOAD_GROUP WORKLOAD_STANDARD_ID