Table Detail Report

ASSEMBLY_SUBSCRIPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Assembly Subscription
Definition: Provides a list of subscriptions of publications the lab system provides or subscribes to.
Table Type: ACTIVITY





Column Detail - ASSEMBLY_SUBSCRIPTION


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.
ASSEMBLY_PUBLICATION_ID DOUBLE N Uniquely identifies the publication being subscribed to.
ASSEMBLY_SUBSCRIPTION_ID DOUBLE N Uniquely identifies a subscription of publications the lab system provides or subscribes to.
EFFECTIVE_DT_TM DATETIME N The date from which the subscription is effective.
EPC_COMPONENT_IDENT VARCHAR(40) Y The scheme of an RFID tag. This is the Component/Part Identifier (AI 8010) in the GS1 standards.
SUBSCRIBER_LAB_SYSTEM_NAME VARCHAR(40) N The lab system that is a subscriber of the publication.
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 - ASSEMBLY_SUBSCRIPTION


Child Column in ASSEMBLY_SUBSCRIPTION(FK) Parent Table Name Parent Column Name
Parents: ASSEMBLY_PUBLICATION_ID ASSEMBLY_PUBLICATION ASSEMBLY_PUBLICATION_ID


ASSEMBLY_TWEET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Assembly Tweet
Definition: A tweet for assemblies created in a lab system
Table Type: ACTIVITY





Column Detail - ASSEMBLY_TWEET


Column Name Type Null? Definition
ACTION_DIRECTIONAL_FLAG DOUBLE N The direction of the action.
ACTION_FLAG DOUBLE N The action that was tweeted about.
ACTION_LOCATION_CD DOUBLE N Uniquely identifies the location the action occurred.
ACTION_LOCATION_NAME VARCHAR(60) N The location the action occurred.
ACTION_USER_NAME VARCHAR(60) N The user that performed the action in the tweet.
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.
ASSEMBLY_TWEET_ID DOUBLE N Uniquely identifies a tweet for assemblies created in a lab system.
EFFECTIVE_DT_TM DATETIME N The date from which the tweet is effective.
FROM_LAB_SYSTEM_NAME VARCHAR(40) N The name of the lab system that provided the tweet.
ISSUED_DT_TM DATETIME N The date and time the tweet was issued.
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 - ASSEMBLY_TWEET




Parent Column in ASSEMBLY_TWEET (PK) Child Table Name Child Column Name
Children: ASSEMBLY_TWEET_ID ASSEMBLY_TWEET_LOCATOR ASSEMBLY_TWEET_ID


ASSEMBLY_TWEET_LOCATOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Assembly Tweet Locator
Definition: Provides record locators for assembly tweets.
Table Type: ACTIVITY





Column Detail - ASSEMBLY_TWEET_LOCATOR


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.
ASSEMBLY_PART_ID DOUBLE Y Uniquely identifies the assembly part the locator is for.
ASSEMBLY_TWEET_ID DOUBLE N Uniquely identifies the assembly tweet the locator is for.
ASSEMBLY_TWEET_LOCATOR_ID DOUBLE N Uniquely identifies record locators for assembly tweets.
EFFECTIVE_DT_TM DATETIME N The date from which the locator is effective.
LAB_SYSTEM_NAME VARCHAR(40) N The lab system that created the locator for the assembly.
LOCATOR_NAME VARCHAR(40) N The name of the locator in the lab system that created the locator for the assembly.
LOCATOR_TAG_TXT VARCHAR(40) N The tag for the locator in the lab system that created the locator for the assembly.
MATCHED_IND DOUBLE N Indicates that this locator was matched to the tweet from an assembly part.
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 - ASSEMBLY_TWEET_LOCATOR


Child Column in ASSEMBLY_TWEET_LOCATOR(FK) Parent Table Name Parent Column Name
Parents: ASSEMBLY_PART_ID ASSEMBLY_PART ASSEMBLY_PART_ID
ASSEMBLY_TWEET_ID ASSEMBLY_TWEET ASSEMBLY_TWEET_ID


AUTO_VERIFY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Automatic Verification
Definition: Defines the parameters used to check whether a procedure result should be autoverified.
Table Type: REFERENCE





Column Detail - AUTO_VERIFY


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_REF_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific autoverification reference row.
AV_STATUS_FLAG DOUBLE N Flag to indicate the status of this service resource and assay combination. It indicates whether this is turned on or off from AVStatus.dll or whether it has been turned off because QC is out of control.
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.
CONSISTENT_MAP CHAR(50) Y Field no longer used.
CONS_NBR_HRS DOUBLE Y Field no longer used.
CRIT_RANGE_IND DOUBLE N Indicates whether the system should check for critical result values to prevent autoverification. A value of 0 does not check for critical to prevent autoverification. A value of 1 does check for critical to prevent autoverification.
DELTA_CHK_FLAG DOUBLE N Defines whether the delta check flag on a specific result will be used in determining whether to autoverify the result.
DELTA_CHK_IND DOUBLE N Field no longer used.
DEST_CODES VARCHAR(50) Y Field no longer used.
DUP_ASSAY_IND DOUBLE N Indicates whether the system should check for a duplicate/equivalent assay to prevent autoverification. A value of 0 does not check for a duplicate/equivalent assay to prevent autoverification. A value of 1 does check for a duplicate/equivalent assay to prevent autoverification.
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.
FEAS_RANGE_IND DOUBLE N Indicates whether the system should check for a feasibility limit to prevent autoverification. A value of 0 does not check for feasible limit to prevent autoverification. A value of 1 does check for a feasible limit to prevent autoverification.
INSTR_ERROR_CODE_IND DOUBLE N Indicates whether the system should check the posting of instrument error codes with the result to prevent autoverification. A value of 0 does not check for instrument error codes posted with the result. A value of 1 does check for instrument error codes posted with the result to prevent autoverification.
LIN_RANGE_IND DOUBLE N Indicates whether the system should check for a result exceeding a linear limit to prevent autoverification. A value of 0 does not check for exceeding linearity to prevent autoverification. A value of 1 does check for exceeding linearity to prevent autoverification.
NOTIFY_RANGE_IND DOUBLE N Indicates that auto verification will be restricted if the notify flag is applied to the result.
PREV_RSLT_IND DOUBLE N Field no longer used.
PREV_VERF_IND DOUBLE N Indicates whether the system should prevent autoverification of associated discrete task assays. A value of 0 does not prevent autoverification of the associated assay. A value of 1 does prevent autoverification of the associated assay.
QC_INSTR_ERROR_CODE_IND DOUBLE N Indicates whether the system should check the posting of instrument error codes with the result to prevent autoverification for QC results. A value of 0 does not check for instrument error codes posted with the result. A value of 1 does check for instrument error codes posted with the result to prevent autoverification.
REF_RANGE_IND DOUBLE N Indicates whether the system should check for a result that exceeds a reference range to prevent autoverification. A value of 0 does not check for exceeding reference ranges to prevent autoverification. A value of 1 does check for a exceeding reference ranges to prevent autoverification.
REPEAT_FLAG DOUBLE N Field no longer used.
REPEAT_MAP CHAR(50) Y Defines how repeats should be performed when autoverification fails.
REV_RANGE_IND DOUBLE N Indicates whether the system should check for results exceeding a review limit to prevent autoverification. A value of 0 does not check for exceeding the review limit to prevent autoverification. A value of 1 does check for exceeding the review limit to prevent autoverification.
SCRIPT CHAR(20) Y Defines a user-created script that should be run to check autoverify parameters. (Currently not implemented)
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies a specific service resource (i.e. instrument) for which autoverification parameters are defined.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies the specific discrete task assay for which autoverification parameters are defined.
UNVERF_PREV_RSLT_IND DOUBLE N Indicates whether the system should check for an unverified previous result to prevent autoverification. A value of 0 does not check for an unverified previous result to prevent autoverification. A value of 1 does check for an unverified previous result to prevent autoverification.
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.
VALIDATE_QC_SCHEDULE_IND DOUBLE N Indicates whether the system should check whether to validate the QC schedule for this instrument/assay. A value of 0 does not validate the QC schedule for this instrument/assay. A value of 1 does validate the QC schedule for this instrument/assay.



Relationship Detail - AUTO_VERIFY


Child Column in AUTO_VERIFY(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in AUTO_VERIFY (PK) Child Table Name Child Column Name
Children: AV_REF_ID AV_CONSISTENCY AV_REF_ID


AUTO_VERIFY_CODE



Column Section Top of Page


Table-level Detail

Description: Automatic Verification Codes
Definition: Stores processing and error codes encountered by autoverification while processing results.
Table Type: ACTIVITY





Column Detail - AUTO_VERIFY_CODE


Column Name Type Null? Definition
AUTO_VERIFY_CD DOUBLE N A unique code value that identifies a specific autoverification processing code sent by the GLB Result server while processing results.
PARENT_ENTITY_ID DOUBLE N A unique, internal, system-assigned number that identifies the relationship between the autoverify codes and a parent result table (i.e. perform_result, qc_result).
PARENT_ENTITY_NAME VARCHAR(30) N Defines the name of the parent result table in uppercase (i.e. PERFORM_RESULT, QC_RESULT) that relates to the autoverify code row.
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.