Table Detail Report
ORDER_SENTENCE_FILTER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ORDER_SENTENCE_FILTER |
Definition: | Contains filter information for order sentence. |
Table Type: | REFERENCE |
Column Detail - ORDER_SENTENCE_FILTER
Column Name | Type | Null? | Definition |
---|---|---|---|
AGE_MAX_VALUE | DOUBLE | N | Maximum value for the age range |
AGE_MIN_VALUE | DOUBLE | N | minimum value for the age range |
AGE_UNIT_CD | DOUBLE | N | Age code valueCode Set: 54The unit of the age: hours, days, weeks, months, years |
ORDER_SENTENCE_FILTER_ID | DOUBLE | N | Unique generated number that identifies a single row on the ORDER_SENTENCE_FILTER table. |
ORDER_SENTENCE_ID | DOUBLE | N | The unique identifier for the order sentence in order_sentence table. |
PMA_MAX_VALUE | DOUBLE | N | Maximum value for the PMA range |
PMA_MIN_VALUE | DOUBLE | N | minimum value for the PMA range |
PMA_UNIT_CD | DOUBLE | N | The unit of the PMA: days, weeks |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
WEIGHT_MAX_VALUE | DOUBLE | N | Maximum value for the weight range |
WEIGHT_MIN_VALUE | DOUBLE | N | Minimum value for the weight range |
WEIGHT_UNIT_CD | DOUBLE | N | weight code value. The unit of the weight: oz, lb, g, kg |
Relationship Detail - ORDER_SENTENCE_FILTER
Child Column in ORDER_SENTENCE_FILTER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORDER_SENTENCE_ID | ORDER_SENTENCE | ORDER_SENTENCE_ID |
ORDER_STAGING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Orders_Staging |
Definition: | This table store orders staging data |
Table Type: | ACTIVITY |
Column Detail - ORDER_STAGING
Column Name | Type | Null? | Definition |
---|---|---|---|
CHARTED_ORDER_ID | DOUBLE | N | Identifier of a charted order id |
CLIENT_IDENT | VARCHAR(255) | N | Client appication Identifier which inserted this row. |
DATA_BLOB | LONGBLOB | Y | |
ENCOUNTER_ID | DOUBLE | N | Encounter id for the patient encounter |
ORDER_STAGING_ID | DOUBLE | N | PRIMARY KEY |
PERSON_ID | DOUBLE | N | Identifier of a person / patient |
STAGING_STATUS_TXT | VARCHAR(20) | N | The staging status of the medication order. |
START_DT_TM | DATETIME | Y | Start Date Time of a medication |
STATUS_TXT | VARCHAR(20) | N | The status of the medication order. |
STOP_DT_TM | DATETIME | Y | Stop date time of a medication |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - ORDER_STAGING
Child Column in ORDER_STAGING(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCOUNTER_ID | ENCOUNTER | ENCNTR_ID |
CHARTED_ORDER_ID | ORDERS | ORDER_ID | |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in ORDER_STAGING (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ORDER_STAGING_ID | ORDER_STAGING_ERX_INFO | ORDER_STAGING_ID |
ORDER_STAGING_EXT_IDENT | ORDER_STAGING_ID |
ORD_CAT_SENT_R
Column Section | Top of Page |
Table-level Detail
Description: | ORDER CATALOG SENTENCE RELATIONSHIP |
Definition: | Table is used to store the relationships between order catalogs/synonyms and order sentences. |
Table Type: | REFERENCE |
Column Detail - ORD_CAT_SENT_R
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
CATALOG_CD | DOUBLE | N | The code value of the orderable. |
DISPLAY_SEQ | DOUBLE | Y | contains user-defined sequencing for the display order of order sentences |
ORDER_CAT_SENT_R_ID | DOUBLE | N | The key to the table. |
ORDER_SENTENCE_DISP_LINE | VARCHAR(255) | Y | The display line of the order sentence. |
ORDER_SENTENCE_ID | DOUBLE | N | The id of the order sentence |
SYNONYM_ID | DOUBLE | N | The id of the order catalog synonym |
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. |
ORD_LOC_PHARM_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order Location Pharmacy Relation |
Definition: | Stores the association between various locations to corresponding pharmacies for a given pharmacy type. This table will be utilized by Orders and Plans services which will perform add, update and remove operations on the table. These services are primarily utilized by bedrock tool to associate facility/facilities with a pharmacy of given type. User can also update the association and remove this association throuugh the tool. |
Table Type: | REFERENCE |
Column Detail - ORD_LOC_PHARM_RELTN
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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
LOC_CD | DOUBLE | N | Code value of the facility, building or nurse unit with which the pharmacy will be associated. Codeset: 220 |
ORD_LOC_PHARM_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the ORD_LOC_PHARM_RELTN table. |
PHARM_IDENT | VARCHAR(100) | N | The Cerner millennium identifier for a pharmacy. |
PHARM_TYPE_CD | DOUBLE | N | Code value of the type of the pharmacy that needs to be associated to the facility. Codeset: 4644007 |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - ORD_LOC_PHARM_RELTN
Child Column in ORD_LOC_PHARM_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOC_CD | LOCATION | LOCATION_CD |
OS_RBLD_MSG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OS_RBLD_MSG |
Definition: | Log table for order sentence rebuild utility |
Table Type: | ACTIVITY |
Column Detail - OS_RBLD_MSG
Column Name | Type | Null? | Definition |
---|---|---|---|
MESSAGE_SEQUENCE | DOUBLE | N | The sequence of the message |
MESSAGE_TXT | VARCHAR(500) | N | The message text |
OS_RBLD_MSG_ID | DOUBLE | N | Unique generated number that identifies a single row on the OS_RBLD_MSG table. |
OS_RBLD_ORD_SENT_DET_ID | DOUBLE | N | The identifier of the rebuilt order sentence detail this detail record belongs to. |
OS_RBLD_ORD_SENT_ID | DOUBLE | N | The identifier of the rebuilt order sentence this detail record belongs to. |
SEVERITY_FLAG | DOUBLE | N | The severity of the message. 1=informational 2=warning 3=error |
TYPE_FLAG | DOUBLE | N | Indicates where the message was generated. 1=rebuild 2=ensure |
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 - OS_RBLD_MSG
Child Column in OS_RBLD_MSG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OS_RBLD_ORD_SENT_ID | OS_RBLD_ORD_SENT | OS_RBLD_ORD_SENT_ID |
OS_RBLD_ORD_SENT_DET_ID | OS_RBLD_ORD_SENT_DET | OS_RBLD_ORD_SENT_DET_ID |