Table Detail Report

ROP_ECL



Column Section Relationship Section Top of Page


Table-level Detail

Description: ROP ECL
Definition: MDI rules for encounter selection.
Table Type: REFERENCE





Column Detail - ROP_ECL


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.
CODE_SET DOUBLE N The codeset to which the "qual_value" applies to.
CREATE_DT_TM DATETIME N Date/Time the record was createdColumn
DEFAULT_OPERATOR_ID DOUBLE N The operator id that will be passed to PathNet when the device fails to send an operator id or the operator id sent does not match one on the prsnl_alias table.
PRSNL_ALIAS_POOL_CD DOUBLE N The personnel alias pool code used to translate operator ids for this ROP service resource.
PRSNL_ALIAS_TYPE_CD DOUBLE N The personnel alias type code used to translate operator ids for this ROP service resource.
QUAL_VALUE DOUBLE N Code Value of the qualifier to which the rule it built against.
ROP_CONFIG_BIT DOUBLE Y A bit mapped variable where each bit represents a ROP function. If the bit is 0 the functionality is off, if the bit is 1 the functionality is on.
SERVICE_RESOURCE_CD DOUBLE N POC service resource to which a specific rule applies
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 - ROP_ECL


Child Column in ROP_ECL(FK) Parent Table Name Parent Column Name
Parents: DEFAULT_OPERATOR_ID PRSNL PERSON_ID


STRT_ASSAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Starter assay
Definition: Cerner-owned information about assays that will be used to facilitate database building and maintenance for medical device interfaces
Table Type: REFERENCE





Column Detail - STRT_ASSAY


Column Name Type Null? Definition
ASSAY_TYPE DOUBLE Y Used to store the assay type for a specific starter assay. Valid types are 1-Chemistry, 2-Coagulation, 3-Hematology, 4-immunology/Serology, 5-Cytopathology, 6-Therapeutic Monitoring/Toxicology/Drugs, 7-Microbiology, 8-Urinalysis, 99- All
DESCRIPTION VARCHAR(100) Y Used to store the Cerner-owned description for the assay
MNEMONIC VARCHAR(100) Y Used to store the abbreviated description for the assay
STRT_ASSAY_CD DOUBLE N This value is used to standardize Assay information across systems.
STRT_ASSAY_ID DOUBLE N RDBMS assigned unique key field.
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_ASSAY




Parent Column in STRT_ASSAY (PK) Child Table Name Child Column Name
Children: STRT_ASSAY_ID DISCRETE_TASK_ASSAY STRT_ASSAY_ID
STRT_MODEL_ASSAY_ALIAS STRT_ASSAY_ID


STRT_ASSAY_SUFFIX



Column Section Top of Page


Table-level Detail

Description: Contains suffix's to an assay alias
Definition: Contains suffix's to an assay alias.
Table Type: ACTIVITY





Column Detail - STRT_ASSAY_SUFFIX


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.
DNLD_SUFFIX CHAR(15) Y The suffix to the assay alias
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.
STRT_SUFFIX_ID DOUBLE N Contains the DBMS assigned key.
SUFFIX_DESC CHAR(50) Y Contains the description of the suffix
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.
UPLD_SUFFIX CHAR(15) Y Contains the upload suffix to the alias


STRT_MFG



Column Section Top of Page


Table-level Detail

Description: STRT MFG
Definition: Stores a complete list of laboratory analyzer manufacturers.
Table Type: REFERENCE





Column Detail - STRT_MFG


Column Name Type Null? Definition
DESCRIPTION VARCHAR(100) Y Contains the complete manufacturer name of a laboratory analyzer(s).
STRT_MFG_ID DOUBLE N Key field. Contains a DBMS assigned 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_MFG_MODEL_R



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - STRT_MFG_MODEL_R


Column Name Type Null? Definition
STRT_MFG_ID DOUBLE N DBMS Assigned key from strt_mfg table.
STRT_MODEL_ID DOUBLE N DBMS Assigned key 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_MFG_MODEL_R


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