Table Detail Report

STRT_MODEL_EVENT_LIST



Column Section Top of Page


Table-level Detail

Description: Contains the errors that can be returned by a laboratory analyzer.
Definition: Contains the errors that can be returned by a laboratory analyzer by discrete assay.
Table Type: REFERENCE





Column Detail - STRT_MODEL_EVENT_LIST


Column Name Type Null? Definition
DESCRIPTION VARCHAR(50) Y Contains a description of the error returned by the analyzer.
INSTRU_ERROR_CODE VARCHAR(20) N Contains the error returned by the model by discrete assay.
STRT_ASSAY_ID DOUBLE N Contains the DBMS assigned unique key field value from strt_assay table.
STRT_MODEL_ID DOUBLE N Contains the DBMS assigned unique key field value from strt_model table.
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.


STRT_MODEL_SUB_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Starter Model Sub Field
Definition: This table will describe the sub fields that make up a composite assay.
Table Type: REFERENCE





Column Detail - STRT_MODEL_SUB_FIELD


Column Name Type Null? Definition
DELIMITER CHAR(1) Y This is the character that will be used as the delimiter between sub-fields. The default is "|", if this field is empty.
DESCRIPTION VARCHAR(200) Y Description of the assay sub field.
DIRECTION_FLAG DOUBLE N Flag used to determine the direction of an alias; 1-Upload, 2- Download, 3 - Both.
DISPLAY VARCHAR(30) Y The header information for the Sub Field
STRT_MODEL_ID DOUBLE N The defined SUB_FIELD is related to this Starter Model.
STRT_MODEL_SUB_FIELD_ID DOUBLE N Primary Key
SUB_FIELD_SEQ DOUBLE Y The sequence position of this record in regards to the associated strt_model_id
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 - STRT_MODEL_SUB_FIELD


Child Column in STRT_MODEL_SUB_FIELD(FK) Parent Table Name Parent Column Name
Parents: STRT_MODEL_ID STRT_MODEL STRT_MODEL_ID


STRT_SUPPLIER



Column Section Top of Page


Table-level Detail

Description: Stores a list of all suppliers of laboratory analyzers.
Definition: Stores a list of all suppliers and related information about the supplier.
Table Type: REFERENCE





Column Detail - STRT_SUPPLIER


Column Name Type Null? Definition
CONTACT VARCHAR(200) Y Contains a primary contact at the laboratory analyzer supplier facility.
CONTACT_FAX_NBR VARCHAR(33) Y Contains the fax number of the primary contact at a laboratory analyzer supplier facility.
CONTACT_PH_NBR VARCHAR(33) Y Contains the phone number of a primary contact at a laboratory analyzer supplier facility.
DESCRIPTION VARCHAR(50) Y Contains the name of the laboratory analyzer supplier.
STRT_SUPPLIER_ID DOUBLE N Key Field. Contains the DBMS supplied unique value.
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.


STRT_SUPPLIER_MFG_R



Column Section Top of Page


Table-level Detail

Description: This is a many-to-many relationship resolution table.
Definition: This is a many-to-many relationship resolution table between strt_supplier and strt_mfg tables.
Table Type: REFERENCE





Column Detail - STRT_SUPPLIER_MFG_R


Column Name Type Null? Definition
STRT_MFG_ID DOUBLE N Contains the DBMS assigned unique key field value from strt_mfg table.
STRT_SUPPLIER_ID DOUBLE N Contains the DBMS assigned unique key field value frmo strt_supplier table.
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.