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