Table Detail Report

MIC_QC_RESULT_SCHEDULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Result Schedule
Definition: This table contains the schedule information for the Microbiology QC setup/results and sub-media tasks.
Table Type: ACTIVITY





Column Detail - MIC_QC_RESULT_SCHEDULE


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N This field contains the code value of the panel component scheduled to be setup/resulted.
COMPLETE_IND DOUBLE N This field indicates whether all of the setup/sub-media actions have been completed for the component.
COMPNT_LOT_INFO_ID DOUBLE N This field contains the unique identifier of the component lot associated with the scheduled QC setup/result.
DETAIL_BIOCHEMICAL_CD DOUBLE N This field contains the code value of the detail biochemical component scheduled to be setup/resulted.
GROUP_BIOCHEMICAL_CD DOUBLE N This field contains the code value of the group biochemical component scheduled to be setup/resulted.
LOCK_PERSONNEL_ID DOUBLE N This field contains the unique identifier of the personnel that currently has the schedule item lost.
MEDIA_CD DOUBLE N This field contains the code value of the media component scheduled to be setup/resulted.
PANEL_CD DOUBLE N This field contains the code value of the panel component scheduled to be setup/resulted.
QC_ITEM_ID DOUBLE N This field contains the unique identifier of the QC item scheduled to have sub-media created.
RESULT_SCHEDULE_ID DOUBLE N This field contains the unique identifier for the QC setup/result or sub-media schedule
RESULT_SCHED_DT_TM DATETIME Y This field contains the date and time that the QC result was scheduled to be completed.
SETUP_SCHED_DT_TM DATETIME Y This field contains the date and time that the QC setup/sub-media was scheduled to be completed.
SUB_MEDIA_IND DOUBLE N This field indicates the action that is scheduled to be completed. 0 = Setup; 1 = Sub-media.
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 - MIC_QC_RESULT_SCHEDULE


Child Column in MIC_QC_RESULT_SCHEDULE(FK) Parent Table Name Parent Column Name
Parents: COMPNT_LOT_INFO_ID PCS_LOT_INFORMATION LOT_INFORMATION_ID
LOCK_PERSONNEL_ID PRSNL PERSON_ID


MIC_QC_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Rule
Definition: This reference table contains a record for each microbiology QC rule.
Table Type: REFERENCE





Column Detail - MIC_QC_RULE


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 N 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.
FORMAT_FLAG DOUBLE N This field indicates the rule format.
RULE_ID DOUBLE N This field contains the unique value that identifies the QC rule.
RULE_NAME VARCHAR(40) N This field contains the unique name for the QC rule.
RULE_NAME_KEY VARCHAR(40) N This filed is the same as the rule_name field, only converted to uppercase.
RULE_NAME_KEY_A_NLS VARCHAR(160) Y RULE_NAME_KEY_A_NLS column
RULE_NAME_KEY_NLS VARCHAR(82) N This field is the same as the Rule_Name_Key, except it is 2 times the length + 2. It is used for sorting in non-English format.
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 - MIC_QC_RULE




Parent Column in MIC_QC_RULE (PK) Child Table Name Child Column Name
Children: RULE_ID MIC_QC_NODE_RULE_RELTN RULE_ID
MIC_QC_RULE_COMPONENT RULE_ID


MIC_QC_RULE_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Rule Component
Definition: This reference table contains a record for each microbiology QC component defined for a rule.
Table Type: REFERENCE





Column Detail - MIC_QC_RULE_COMPONENT


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 N 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.
COMPONENT_SEQ DOUBLE N This field uniquely identifies a component within a specific QC rule.
RULE_COMPONENT_ID DOUBLE N This filed contains the unique value that identifies the QC rule component.
RULE_ID DOUBLE N This field contains the foreign key used to join rule components to a specific QC rule.
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.
VALUE_NBR DOUBLE Y This field stores the value of a QC rule component.



Relationship Detail - MIC_QC_RULE_COMPONENT


Child Column in MIC_QC_RULE_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: RULE_ID MIC_QC_RULE RULE_ID


MIC_QC_SCHEDULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Schedule
Definition: This reference table contains a record for each microbiology QC schedule
Table Type: REFERENCE





Column Detail - MIC_QC_SCHEDULE


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 N 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.
SCHEDULE_ID DOUBLE N This field contains the unique value that identifies the QC schedule
SCHEDULE_NAME VARCHAR(40) N This field contains the unique name for the QC schedule
SCHEDULE_NAME_KEY VARCHAR(40) N This field is the same as the schedule_name field, only converted to uppercase
SCHEDULE_NAME_KEY_A_NLS VARCHAR(160) Y SCHEDULE_NAME_KEY_A_NLS column
SCHEDULE_NAME_KEY_NLS VARCHAR(82) N NLS form of the schedule name key.
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 - MIC_QC_SCHEDULE




Parent Column in MIC_QC_SCHEDULE (PK) Child Table Name Child Column Name
Children: SCHEDULE_ID MIC_QC_ITEM SCHEDULE_ID
MIC_QC_NODE SCHEDULE_ID
MIC_QC_SCHEDULE_SEGMENT SCHEDULE_ID


MIC_QC_SCHEDULE_SEGMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Schedule Segment
Definition: This reference table contains a record for each microbiology QC schedule segment defined for a segment.
Table Type: REFERENCE





Column Detail - MIC_QC_SCHEDULE_SEGMENT


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 N 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.
COMPONENT1_NBR DOUBLE Y This field stores the first component of a schedule segment.
COMPONENT2_NBR DOUBLE Y This field stores the second component of a schedule segment.
COMPONENT3_NBR DOUBLE Y This field stores the third component of a schedule segment.
DAYS_OF_WEEK_BIT DOUBLE Y This bit map field indicates which days of the week have been selected for the schedule segment.
SCHEDULE_ID DOUBLE N This field contains the foreign key 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.



Relationship Detail - MIC_QC_SCHEDULE_SEGMENT


Child Column in MIC_QC_SCHEDULE_SEGMENT(FK) Parent Table Name Parent Column Name
Parents: SCHEDULE_ID MIC_QC_SCHEDULE SCHEDULE_ID