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 |