Table Detail Report
STRT_MODEL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores a list of all laboratory analyzer models that Cerner has an interface for |
Definition: | Stores a description, name, program name for each model. |
Table Type: | REFERENCE |
Column Detail - STRT_MODEL
Column Name | Type | Null? | Definition |
---|---|---|---|
DESCRIPTION | VARCHAR(100) | Y | Contains a laboratory analyzer's specific model name. |
DEVICE_CATEGORY_CD | DOUBLE | N | Category of the bedside medical device - monitor, ventilator, pump etc. |
DEVICE_CATEGORY_TYPE_CD | DOUBLE | N | Category type of the bedside medical device - heart monitor, fetal monitor etc. |
ID_TYPE | CHAR(1) | Y | Contains micro id type of "A" or "N" to indicate if a micro analyzer accepts an alpha/numeric or just numeric identifier, respectively. |
INTFC_PROGNAME | CHAR(15) | Y | Contains the interface program name used by the model. |
ISOLATE_NUMBER_SIZE | CHAR(1) | Y | Contains the maximum number of characters a micro analyzer can use for it's isolate number. |
LAB_TYPE | CHAR(5) | Y | Contains a character indication the lab type of the model either General Lab or Microbiology. |
MAX_ID_SIZE | DOUBLE | Y | This field sets the maximum id size that an analyzer may send. |
STRT_MODEL_CD | DOUBLE | N | This value is used to standardize Model information across systems. |
STRT_MODEL_ID | DOUBLE | N | Key field. Contains a DBMS assigned value as the unique key. |
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
Parent Column in STRT_MODEL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | STRT_MODEL_ID | BMDI_MONITORED_DEVICE | STRT_MODEL_CHILD_ID |
BMDI_MONITORED_DEVICE | STRT_MODEL_ID | ||
LAB_INSTRUMENT | STRT_MODEL_ID | ||
STRT_BMDI_MODEL_NOMENCLATURE | STRT_MODEL_ID | ||
STRT_BMDI_MODEL_PARAMETER | STRT_MODEL_ID | ||
STRT_MFG_MODEL_R | STRT_MODEL_ID | ||
STRT_MODEL_ASSAY_ALIAS | STRT_MODEL_ID | ||
STRT_MODEL_ASSAY_R | STRT_MODEL_ID | ||
STRT_MODEL_CUSTOM | STRT_MODEL_ID | ||
STRT_MODEL_FORMAT | STRT_MODEL_ID | ||
STRT_MODEL_HL7_MAP | STRT_MODEL_ID | ||
STRT_MODEL_LAB_TYPE_R | STRT_MODEL_ID | ||
STRT_MODEL_SUB_FIELD | STRT_MODEL_ID |
STRT_MODEL_ASSAY_ALIAS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Starter Model Assay Alias |
Definition: | This table holds pre-defined instrument aliases and relates them to STRT_ASSAYs. |
Table Type: | REFERENCE |
Column Detail - STRT_MODEL_ASSAY_ALIAS
Column Name | Type | Null? | Definition |
---|---|---|---|
ALIAS | VARCHAR(100) | Y | An alias that relates to the given Assay/Model combination. |
DIRECTION_FLAG | DOUBLE | N | Flag used to determine the direction of an alias; 1-Upload, 2- Download, 3 - Both. |
STRT_ALIAS_SEQ | DOUBLE | Y | This is the sequence position of the alias in regards to the STRT_MODEL_ID and STRT_ASSAY_ID. |
STRT_ASSAY_ID | DOUBLE | N | The defined Alias is related to this Starter Assay. |
STRT_MODEL_ASSAY_ALIAS_ID | DOUBLE | N | Primary Key |
STRT_MODEL_ID | DOUBLE | N | The defined ALIAS is related to this Starter Model. |
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_ASSAY_ALIAS
Child Column in STRT_MODEL_ASSAY_ALIAS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | STRT_ASSAY_ID | STRT_ASSAY | STRT_ASSAY_ID |
STRT_MODEL_ID | STRT_MODEL | STRT_MODEL_ID |
STRT_MODEL_ASSAY_ERROR
Column Section | Top of Page |
Table-level Detail
Description: | Contains all errors for each discrete assay that can be performed by a model. |
Definition: | Contains each error that can be returned by an analyzer by assay and model. |
Table Type: | REFERENCE |
Column Detail - STRT_MODEL_ASSAY_ERROR
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION | DOUBLE | Y | Contains the code_value from code_set 14001 which describes an action to take when an error is received from an analyzer. |
DATA_TYPE_FLAG | DOUBLE | N | Future use. Currently not defined |
DESCRIPTION | VARCHAR(50) | Y | Contains a description of the error returned by the analyzer for the assay. |
ERROR_CODE | DOUBLE | N | Contains the error code returned by the analyzer for the assay. |
SEVERITY_FLAG | DOUBLE | Y | Reserved for future use. |
STRT_ASSAY_ID | DOUBLE | N | Contains the DBMS assigned key field value from the strt_assay table. |
STRT_MODEL_ID | DOUBLE | N | Contains the DBMS assigned key field value from the 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_ASSAY_R
Column Section | Relationship 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_model and strt_assay. |
Table Type: | REFERENCE |
Column Detail - STRT_MODEL_ASSAY_R
Column Name | Type | Null? | Definition |
---|---|---|---|
ASSAY_ALIAS | VARCHAR(50) | Y | Contains the assay alias returned by the model. |
DESCRIPTION | CHAR(100) | Y | A description of the assay's relationship to the model. |
FLUID_TYPE | CHAR(2) | Y | This column holds the fluid type for the associated assay. |
MODIFY_ALIAS_IND | DOUBLE | Y | Contains a Boolean integer indicating if the assay alias can be modified. |
PROCESS_SEQ | DOUBLE | Y | Reserved for future use. |
RESULT_TYPE_CD | DOUBLE | N | Contains the result type of the discrete assay for the model. |
STRT_ASSAY_ID | DOUBLE | N | Contains the DBMS assigned key field value from strt_assay table. |
STRT_MODEL_ID | DOUBLE | N | Contains the DBMS assigned 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. |
Relationship Detail - STRT_MODEL_ASSAY_R
Child Column in STRT_MODEL_ASSAY_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | STRT_MODEL_ID | STRT_MODEL | STRT_MODEL_ID |
STRT_MODEL_CUSTOM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores interface specific codes. |
Definition: | Stores interface specific codes that turns on/off site specific custom functionality. |
Table Type: | REFERENCE |
Column Detail - STRT_MODEL_CUSTOM
Column Name | Type | Null? | Definition |
---|---|---|---|
CUSTOM_OPTION | VARCHAR(50) | Y | Contains a string that is an interface specific flag to turn on/off custom interface functionality. |
DESCRIPTION | LONGTEXT | Y | Contains a description of the custom option. |
DISPLAY | VARCHAR(50) | Y | Reserved for future use. |
PROCESS_FLAG | DOUBLE | N | This field indicates how the software flag should be processed. 1 - RTL, 2 - Interface, 3 - Both. |
RESULT_SIZE | DOUBLE | Y | Size of the user-defined options |
STRT_CONFIG_ID | DOUBLE | N | Key field. Contains the DBMS assigned unique value. |
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. |
Relationship Detail - STRT_MODEL_CUSTOM
Child Column in STRT_MODEL_CUSTOM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | STRT_MODEL_ID | STRT_MODEL | STRT_MODEL_ID |