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 |