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 |