Table Detail Report

BB_QC_SCHEDULE_SEGMENT



Column Section Top of Page


Table-level Detail

Description: Blood Bank Quality Control Schedule Segment
Definition: This reference table contains a record for each blood bank QC schedule segment defined for a segment.
Table Type: REFERENCE





Column Detail - BB_QC_SCHEDULE_SEGMENT


Column Name Type Null? Definition
COMPONENT1_NBR DOUBLE N This field stores the first component of a schedule segment.
COMPONENT2_NBR DOUBLE N This field stores the second component of a schedule segment.
COMPONENT3_NBR DOUBLE N This field stores the third component of a schedule segment.
DAYS_OF_WEEK_BIT DOUBLE N This bit map field indicates which days of the week have been selected for the schedule segment.
SCHEDULE_CD DOUBLE N This field contains the code value used to join to schedule segments to a specific schedule.
SCHEDULE_SEGMENT_ID DOUBLE N This field contains the unique value that identifies the QC schedule segment.
SEGMENT_SEQ DOUBLE N This field uniquely identifies a segment within a specific schedule.
SEGMENT_TYPE_FLAG DOUBLE N This field indicates the type of schedule segment.
TIME_NBR DOUBLE N This field stores the time for a schedule segment. (Stored as a number)
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.


BB_QC_TROUBLESHOOTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Blood Bank Quality Control Troubleshooting Steps
Definition: This table contains the possible troubleshooting steps that users can select from when a quality control result is determined to be out of control.
Table Type: REFERENCE





Column Detail - BB_QC_TROUBLESHOOTING


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.
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.
TROUBLESHOOTING_ID DOUBLE N This field contains the unique value that identifies troubleshooting step.
TROUBLESHOOTING_TEXT_ID DOUBLE N This field contains the foreign key identifier to the LONG_TEXT_REFERENCE table.
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 - BB_QC_TROUBLESHOOTING


Child Column in BB_QC_TROUBLESHOOTING(FK) Parent Table Name Parent Column Name
Parents: TROUBLESHOOTING_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in BB_QC_TROUBLESHOOTING (PK) Child Table Name Child Column Name
Children: TROUBLESHOOTING_ID BB_QC_RESULT_TROUBLESHOOTING_R TROUBLESHOOTING_ID