Table Detail Report
AV_CONSISTENCY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Autoverification Consistency |
Definition: | Stores autoverification consistency parameters. |
Table Type: | REFERENCE |
Column Detail - AV_CONSISTENCY
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. |
AV_CONSISTENCY_FLAG | DOUBLE | N | Defines the type of result flag (such as Reference, Critical, Linear, and so on) to which this row of consistency parameters applies. |
AV_REF_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific autoverification reference row associated with the consistency parameters. Creates a relationship to the autoverify reference table. |
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. |
CONSISTENCY_IND | DOUBLE | N | Indicates whether consistency checking is turned on or off. |
CONSISTENCY_MINUTES | DOUBLE | N | Defines the number of minutes in which a result must be entered in order to be checked for consistency. |
CONSISTENCY_TYPE_FLAG | DOUBLE | N | Defines the type of consistency checking (such as percent or absolute) that will be performed. |
CONSISTENCY_UNITS_CD | DOUBLE | N | A unique code value that identifies a specific unit of time in which the Consistency_Minutes column was defined originally. This can equate to either hours or minutes. |
CONSISTENCY_VARIANCE | DOUBLE | N | Defines the result variance within which a previous result must be to pass consistency checking. This is either an absolute value or a percentage. |
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. |
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 - AV_CONSISTENCY
Child Column in AV_CONSISTENCY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AV_REF_ID | AUTO_VERIFY | AV_REF_ID |
AV_ORDER_HOLD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Auto Verification Order Hold |
Definition: | Contains the order relationships which are preventing autoverification results from being released when the trigger order is autoverified. |
Table Type: | ACTIVITY |
Column Detail - AV_ORDER_HOLD
Column Name | Type | Null? | Definition |
---|---|---|---|
AV_ORDER_HOLD_ID | DOUBLE | N | Unique generated number that identifies a single row on the AV_ORDER_HOLD table. |
HELD_ORDER_ID | DOUBLE | N | Identifies the order which is being held from releasing autoverified results. |
TRIGGER_ORDER_ID | DOUBLE | N | Identifies the order which the held order is waiting to be autoverified. |
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 - AV_ORDER_HOLD
Child Column in AV_ORDER_HOLD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HELD_ORDER_ID | ORDERS | ORDER_ID |
TRIGGER_ORDER_ID | ORDERS | ORDER_ID |
AV_RES_CAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Automatic Verificaton Service Resource Code Catalog Code |
Definition: | Defines the orderables for a resource that have specific autoverify requirements |
Table Type: | REFERENCE |
Column Detail - AV_RES_CAT
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. |
ASSOC_CATALOG_CD | DOUBLE | N | A unique code value that identifies an associated order catalog item. For an av_res_cat_flag of "3" the associated catalog code indicates the orderable that should not be verified because the other orderable was not verified. |
AV_RES_CAT_FLAG | DOUBLE | Y | Defines the values of how to use the order catalog item.1 - Autoverify within the orderable; 2 - Never autoverify the orderable; 3 - Don't autoverify this associated orderable;4 - Do not autoverify when order comment or note is present; 5 - Do not autoverify when order comment is present; 6 - Do not autoverify when order note is present.;7 - Hold result autoverification(av) until all required task assays with av criteria for the orderable qualify to be av regardless of the # of msg |
AV_RES_CAT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific autoverification resource catalog row. |
CATALOG_CD | DOUBLE | N | A unique code value that identifies a specific order catalog item. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies a specific service resource. |
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 - AV_RES_CAT
Child Column in AV_RES_CAT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
AV_STATUS_EVENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Auto Verify Status Event |
Definition: | This table used as a event table. Rows are written when an user runs loads the AVStatus.dll and turns on/off autoverification for an instrument. |
Table Type: | ACTIVITY |
Column Detail - AV_STATUS_EVENT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific accession for which autoverification was turned on or off. Creates a relationship to the accession table. |
AV_EVENT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific autoverification event row. |
AV_IND | DOUBLE | N | Indicates whether this event was to turn on or off autoverification. A value of 0 indicates autoverification was turned off. A value of 1 indicates autoverification was turned on. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal, system-assigned number. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies the specific service resource for which autoverification was turned on or off. |
TASK_ASSAY_CD | DOUBLE | N | A unique code value that identifies the specific task assay for which autoverification was turned on or off. |
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 - AV_STATUS_EVENT
Child Column in AV_STATUS_EVENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |
CONTAINER_LAB_HANDLING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Container Lab Handling |
Definition: | Defines lab handling information for a specific container. |
Table Type: | ACTIVITY |
Column Detail - CONTAINER_LAB_HANDLING
Column Name | Type | Null? | Definition |
---|---|---|---|
CONTAINER_ID | DOUBLE | N | Uniquely identifies the related container |
CONTAINER_LAB_HANDLING_ID | DOUBLE | N | Uniquely identifies lab handling information for a given container. |
LAB_HANDLING_CD | DOUBLE | N | A code used to identify the different ways a container should be handled. |
LAB_HANDLING_ORDER_SEQ | DOUBLE | N | Used to sort lab handling values for a given container. |
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 - CONTAINER_LAB_HANDLING
Child Column in CONTAINER_LAB_HANDLING(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONTAINER_ID | CONTAINER | CONTAINER_ID |