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