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