Table Detail Report
BB_WORKLIST_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Blood Bank Worklist Detail |
Definition: | Stores the order-level information for a particular Blood Bank worklist. |
Table Type: | ACTIVITY |
Column Detail - BB_WORKLIST_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
ORDER_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the associated order. |
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. |
WORKLIST_DETAIL_ID | DOUBLE | N | Contains the internal identification code that uniquely identifies the worklist and order relationship. |
WORKLIST_ID | DOUBLE | N | Contains the internal identification code that uniquely identifiers the associated worklist |
Relationship Detail - BB_WORKLIST_DETAIL
Child Column in BB_WORKLIST_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | WORKLIST_ID | BB_WORKLIST | WORKLIST_ID |
ORDER_ID | ORDERS | ORDER_ID |
CELL_GROUP
Column Section | Top of Page |
Table-level Detail
Description: | Cell_group |
Definition: | A reference of user-defined groupings of control cells used to do testing, entered in result entry. |
Table Type: | REFERENCE |
Column Detail - CELL_GROUP
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. |
CELL_CD | DOUBLE | N | The code value that represents the control cell that is built within this control cell grouping. This cell will be displayed within the Result Entry application when this control cell grouping is chosen by the user. |
CELL_GROUP_CD | DOUBLE | N | The code value that represents the cell group that would be entered by the user within the Result Entry application for testing. |
CELL_ID | DOUBLE | N | The primary key of this table. An internal system-assigned number that ensures the uniqueness of each row. |
DISPLAY_SEQ | DOUBLE | Y | The sequence in which the cells should display underneath the accession within the Result Entry application, when this cell group is entered by the user. |
SEQUENCE | DOUBLE | Y | Not currentlly used at this time. |
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. |
INTERP_COMPONENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Interpretation Component |
Definition: | The discrete task assays that should be used to create interpretation. |
Table Type: | REFERENCE |
Column Detail - INTERP_COMPONENT
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. |
CROSS_DRAWN_DT_TM_IND | DOUBLE | Y | The value of this indicator will be a 1 if the interpretation should be made across different drawn dates and times for the specimens used in the testing. The value of this indicator will be a 0 if the interpretation should only be made across the same drawn dates and times for the specimens used in the testing. |
INCLUDED_ASSAY_CD | DOUBLE | N | This column is the code value that represents the discrete task assay that is included in the interpretation pattern. |
INTERP_DETAIL_ID | DOUBLE | N | This is a unique number that identifies the interpretation detail. |
INTERP_ID | DOUBLE | N | This column is a unique number that identifies the interpretation. |
RESULT_REQ_FLAG | DOUBLE | Y | This column determines whether a result for the component of the interpretation is required or not, for the pattern to be valid. |
SEQUENCE | DOUBLE | Y | A sequence number used to list and display the components of the interpretation pattern in the correct sequence. |
TIME_WINDOW_MINUTES | DOUBLE | Y | The number of minutes defined for the time window in which this interpretation can be made. |
TIME_WINDOW_UNITS_CD | DOUBLE | N | The code value that represents the unit of measure for the time window (ex. "Days"). |
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. |
VERIFIED_FLAG | DOUBLE | Y | This flag determines whether the components of the interpretation have to be verified or not, for the interpretation to be valid. |
Relationship Detail - INTERP_COMPONENT
Child Column in INTERP_COMPONENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INCLUDED_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
INTERP_ID | INTERP_TASK_ASSAY | INTERP_ID |
Parent Column in INTERP_COMPONENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | INTERP_DETAIL_ID | INTERP_RANGE | INTERP_DETAIL_ID |
RESULT_HASH | INTERP_DETAIL_ID |
INTERP_RANGE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Interpretation Range |
Definition: | The result ranges defined for each discrete task assay used within an interpretation. |
Table Type: | REFERENCE |
Column Detail - INTERP_RANGE
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. |
AGE_FROM_MINUTES | DOUBLE | Y | The "from" age of the patient within the age range which should be used to determine the pattern of the interpretation. |
AGE_FROM_UNITS_CD | DOUBLE | N | The code value that represents the unit of measure for the "from age" of the patient (ex. "Minutes"). |
AGE_TO_MINUTES | DOUBLE | Y | The "to" age of the patient within the age range which should be used to determine the pattern of the interpretation. |
AGE_TO_UNITS_CD | DOUBLE | N | The code value that represents the unit of measure for the "to age" of the patient (ex. "Minutes"). |
GENDER_CD | DOUBLE | N | The code value that represents the gender of the patient, which should be used in determining the interpretation pattern. |
INCLUDED_ASSAY_CD | DOUBLE | N | This column is the code value that represents the discrete task assay that is included in the interpretation pattern. |
INTERP_DETAIL_ID | DOUBLE | N | This unique number identifies the interpretation detail. |
INTERP_ID | DOUBLE | N | This is a unique number that identifies the interpretation. |
INTERP_RANGE_ID | DOUBLE | N | This unique number identifies the interpretation range. |
RACE_CD | DOUBLE | N | The code value that represents the race of the patient, which should be used in determining the interpretation pattern. |
SEQUENCE | DOUBLE | Y | An internal sequential number that is used to determine the sequence of the components of the interpretation pattern, which is used to organize and display the components within the Interpretation Tool. |
SPECIES_CD | DOUBLE | N | A code value that represents the species of the patient, which is used in determining the interpretation pattern. Allows different patterns to be defined for the same procedure, but for humans versus animals. |
UNKNOWN_AGE_IND | DOUBLE | Y | Client can specify an unknown age for their interp. |
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 - INTERP_RANGE
Child Column in INTERP_RANGE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INCLUDED_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
INTERP_DETAIL_ID | INTERP_COMPONENT | INTERP_DETAIL_ID | |
INTERP_ID | INTERP_TASK_ASSAY | INTERP_ID |
Parent Column in INTERP_RANGE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | INTERP_RANGE_ID | RESULT_HASH | INTERP_RANGE_ID |
INTERP_RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Interpretation Result |
Definition: | A reference of the result associated with the interpretation pattern. |
Table Type: | REFERENCE |
Column Detail - INTERP_RESULT
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. |
DAYS_INELIGIBLE | DOUBLE | N | This field will only be used for donor interpretations. It will be used to indicate the number of days the donor should be deferred if the result is a temporary deferral. |
DONOR_ELIGIBILITY_CD | DOUBLE | N | This is the eligibility code that will post to the donor's record for the defined hash pattern. |
HASH_PATTERN | VARCHAR(255) | Y | The hash pattern defined for this interpretation (ex. "1, 0, 1, 0, 1"). |
INTERP_ID | DOUBLE | N | The primary key to the INTERP_TASK_ASSAY table. An internal system-assigned number that ties each row in this table to the INTERP_TASK_ASSAY table. |
INTERP_RESULT_ID | DOUBLE | N | The primary key to this table. An internal system-assigned number that ensures the uniqueness of each row on this table. |
LONG_TEXT_ID | DOUBLE | N | Links the long text for an interpretation pattern to the row on the LONG_TEXT table where the actual text is stored. |
RESULT_CD | DOUBLE | N | The code value that represents the result which should be associated with this interpretation pattern. The code set will vary depending on the result. |
RESULT_NOMENCLATURE_ID | DOUBLE | N | Links this table to the nomenclature table for the result associated with this pattern. |
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 - INTERP_RESULT
Child Column in INTERP_RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INTERP_ID | INTERP_TASK_ASSAY | INTERP_ID |
LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID | |
RESULT_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID |