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 |