ASSAY_RESOURCE_LOT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Assay Resource Lot
Definition: Creates a relationship between the assays for a resource that will be used for a given control lot.
Table Type: REFERENCE





Column Detail - ASSAY_RESOURCE_LOT


Column Name Type Null? Definition
ABS_HIGH DOUBLE Y Defines the high value for comparing a result value against to see if the result should be flagged as high.
ABS_LOW DOUBLE Y Defines the low value for comparing a result value against to see if the result should be flagged as low.
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.
ARL_ID DOUBLE N A unique internal system assigned number that identifies a specific relationship between a service resource, discrete task assay, and a control lot.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CLINICAL_STD_DEV DOUBLE Y Defines the standard deviation for a clinically significant value.
END_EFFECTIVE_DT_TM DATETIME Y 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.
LOT_ID DOUBLE N A unique internal system assigned number that identifies a specific control lot. Creates a relationship to the control lot table.
MANF_HIGH DOUBLE Y Defines the manufacturer defined high level for the discrete task assay and the control.
MANF_LOW DOUBLE Y Defines the manufacturer defined low level for the discrete task assay and control.
MANF_MEAN DOUBLE Y Defines the manufacturer defined mean for the discrete task assay and control.
MANF_STD_DEV DOUBLE Y Defines the manufacturer defined standard deviation for the discrete task assay and control.
MEAN DOUBLE Y Defines the expected mean for results to be compared against for the control lot.
RULE_ID DOUBLE N A unique internal system assigned number that identifies a specific quality control rule to be applied for the discrete task assay.
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies the specific service resource (i.e. instrument, bench) associated with the discrete task assay and control lot.
STATISTICAL_STD_DEV DOUBLE Y Defines the standard deviation for the discrete task assay. Used to determine the high and low value.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies the specific discrete task assay associated with the control lot.
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 - ASSAY_RESOURCE_LOT


Child Column in ASSAY_RESOURCE_LOT(FK) Parent Table Name Parent Column Name
Parents: LOT_ID CONTROL_LOT LOT_ID
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


ASSEMBLY_PART



Column Section Relationship Section Top of Page


Table-level Detail

Description: Assembly Part
Definition: Provides the list of parts for an assembly created by a lab system.
Table Type: ACTIVITY





Column Detail - ASSEMBLY_PART


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_IDENT VARCHAR(40) Y The unique identifier of the assembly this part is for from the source system.
ASSEMBLY_PART_ID DOUBLE N Uniquely identifies a list of parts for an assembly created by a lab system.
ASSEMBLY_PUBLICATION_ID DOUBLE N Uniquely identifies the related assembly publication for the assembly this part is for.
COMPONENT_TYPE_FLAG DOUBLE N The type of component for this assembly part on the assembly.
EFFECTIVE_DT_TM DATETIME N The date from which the assembly part is effective.
LOCATOR_LAB_SYSTEM_NAME VARCHAR(40) N The lab system that created the assembly part for the assembly.
LOCATOR_NAME VARCHAR(40) N The locator name in the lab system that created the assembly part for the assembly.
LOCATOR_TAG_TXT VARCHAR(40) N The tag for the locator in the lab system that created the assembly part for the assembly.
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_PART


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




Parent Column in ASSEMBLY_PART (PK) Child Table Name Child Column Name
Children: ASSEMBLY_PART_ID ASSEMBLY_PART_LOCATOR ASSEMBLY_PART_ID
ASSEMBLY_TWEET_LOCATOR ASSEMBLY_PART_ID


ASSEMBLY_PART_LOCATOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Assembly Part Locator
Definition: Provides record locators for assembly parts.
Table Type: ACTIVITY





Column Detail - ASSEMBLY_PART_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 N Uniquely identifies the assembly part the locator is for
ASSEMBLY_PART_LOCATOR_ID DOUBLE N Uniquely identifies record locators for assembly parts.
EFFECTIVE_DT_TM DATETIME N The date from which the locator is effective.
LAB_SYSTEM_ENTITY_ID DOUBLE N Uniquely identifies the record in the lab system that is referenced by the locator for the assembly.
LAB_SYSTEM_ENTITY_NAME VARCHAR(40) N The name of the record identifier in the lab system that is referenced by the locator for the assembly.
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.
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_PART_LOCATOR


Child Column in ASSEMBLY_PART_LOCATOR(FK) Parent Table Name Parent Column Name
Parents: ASSEMBLY_PART_ID ASSEMBLY_PART ASSEMBLY_PART_ID


ASSEMBLY_PUBLICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Assembly Publication
Definition: Provides a list of publications of assemblies to which t the lab system provides or subscribes..
Table Type: ACTIVITY





Column Detail - ASSEMBLY_PUBLICATION


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 a list of publications of assemblies to which the lab system provides or subscribes.
EFFECTIVE_DT_TM DATETIME N The date from which the publication is effective.
LAST_LOCK_ELAPSED_SECS DOUBLE N The time duration over which the last lock of the publication lasted.
LAST_PUBLISHED_DT_TM DATETIME Y The data and time of the most recent publishing.
PUBLICATION_NAME VARCHAR(60) N The name of the publication
PUBLISHER_NAME VARCHAR(60) N Name of the Publisher
PUBLISH_ANCHOR_DT_TM DATETIME Y The anchor date and time of the publishing attempt.
PUBLISH_EXPIRATION_DT_TM DATETIME Y The expiration date and time of the publishing attempt.
PUBLISH_FREQUENCY_SECS DOUBLE N The frequency in seconds for the publishing interval.
PUBLISH_STATUS_FLAG DOUBLE N The publishing status flag. 0 - Inactive; 1 - Ready; 2 - Started; 3 - Completed
SOURCE_LAB_SYSTEM_NAME VARCHAR(40) N The lab system that is the source of the publication.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - ASSEMBLY_PUBLICATION




Parent Column in ASSEMBLY_PUBLICATION (PK) Child Table Name Child Column Name
Children: ASSEMBLY_PUBLICATION_ID ASSEMBLY_PART ASSEMBLY_PUBLICATION_ID
ASSEMBLY_PUBLICATION_VIEW ASSEMBLY_PUBLICATION_ID
ASSEMBLY_SUBSCRIPTION ASSEMBLY_PUBLICATION_ID


ASSEMBLY_PUBLICATION_VIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Assembly Publication View
Definition: Provides a list of views for a publication of assemblies.
Table Type: ACTIVITY





Column Detail - ASSEMBLY_PUBLICATION_VIEW


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 the view is for.
ASSEMBLY_PUBLICATION_VIEW_ID DOUBLE N Uniquely identifies a view for a publication of assemblies.
EFFECTIVE_DT_TM DATETIME N The date from which the publication view is effective.
MODEL_VIEW_NAME VARCHAR(40) N The view name in the data model.
MODEL_VIEW_TYPE_FLAG DOUBLE N The type of use provided by the view.
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_PUBLICATION_VIEW


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