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