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 |