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. |