Table Detail Report
GRACE_PERIOD_RANGE
Column Section | Top of Page |
Table-level Detail
Description: | GRACE_PERIOD_RANGE |
Definition: | Stores grace period ranges for future orders. |
Table Type: | REFERENCE |
Column Detail - GRACE_PERIOD_RANGE
Column Name | Type | Null? | Definition |
---|---|---|---|
GRACE_PERIOD_IN_DAYS | DOUBLE | N | The grace period in days. |
GRACE_PERIOD_RANGE_ID | DOUBLE | N | Unique generated number that identifies a single row on the GRACE_PERIOD_RANGE table. |
MAX_NUMBER_OF_DAYS | DOUBLE | N | The maximum number of days. |
MIN_NUMBER_OF_DAYS | DOUBLE | N | The minimum number of days. |
TYPE_MEAN | VARCHAR(12) | N | Denotes the type of grace period range. |
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. |
OCS_CONFIDENTIAL_DEFAULTS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order Catalog Synonym Confidentiality default values |
Definition: | This table will store the confidentiality defaults at synonym level |
Table Type: | REFERENCE |
Column Detail - OCS_CONFIDENTIAL_DEFAULTS
Column Name | Type | Null? | Definition |
---|---|---|---|
CONFIDENTIAL_REASON_CD | DOUBLE | Y | Stores the Confidentiality reason code value |
OCS_CONFIDENTIAL_DEFAULTS_ID | DOUBLE | N | PRIMARY KEY |
SYNONYM_ID | DOUBLE | Y | Identifies the orderable item. Foreign Key from ORDER_CATALOG_SYNONYM table. |
UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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 - OCS_CONFIDENTIAL_DEFAULTS
Child Column in OCS_CONFIDENTIAL_DEFAULTS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |
OCS_DEF_DOSE_CALC_METHOD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order Management Default Dose Calculator Method |
Definition: | Table used to store the default weight adjustment and CRCL method of an Order Synonym. |
Table Type: | REFERENCE |
Column Detail - OCS_DEF_DOSE_CALC_METHOD
Column Name | Type | Null? | Definition |
---|---|---|---|
FACILITY_CD | DOUBLE | N | Stores the facility code of the facility for which default method is configured. |
METHOD_CD | DOUBLE | N | Stores the code value of the default method selected. |
METHOD_MEAN | VARCHAR(100) | N | The CDF_MEANING of the method from code set 4016. |
OCS_DEF_DOSE_CALC_METHOD_ID | DOUBLE | N | Unique generated number that identifies a single row on the OCS_DEF_DOSE_CALC_METHOD table. |
SYNONYM_ID | DOUBLE | N | Identifies the synonym. Foreign Key from ORDER_CATALOG_SYNONYM table. |
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 - OCS_DEF_DOSE_CALC_METHOD
Child Column in OCS_DEF_DOSE_CALC_METHOD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |
OCS_FACILITY_FORMULARY_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order Catalog Synonym Facility Formulary Relationship |
Definition: | Used to define the formulary status of synonyms. |
Table Type: | REFERENCE |
Column Detail - OCS_FACILITY_FORMULARY_R
Column Name | Type | Null? | Definition |
---|---|---|---|
FACILITY_CD | DOUBLE | N | Identifies the facility (zero means all facilities). |
INPATIENT_FORMULARY_STATUS_CD | DOUBLE | N | Stores the inpatient formulary status code. |
OCS_FACILITY_FORMULARY_R_ID | DOUBLE | N | The unique primary key for this table. It is an internally generated sequence number. |
OUTPATIENT_FORMULARY_STATUS_CD | DOUBLE | N | Stores the outpatient formulary status code. |
RX_SYNONYM_VISIBILITY_IND | DOUBLE | N | Used to indicate prescription synonym visibility in order search. 0 - Not visible, 1 - visible. |
SYNONYM_ID | DOUBLE | N | Identifies the synonym. (zero means all synonyms). |
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 - OCS_FACILITY_FORMULARY_R
Child Column in OCS_FACILITY_FORMULARY_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |
OCS_HANDLING_PRECAUTIONS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Order Catalog Synonym Handling Precautions |
Definition: | Table used to store the hazardous information about a medication. |
Table Type: | REFERENCE |
Column Detail - OCS_HANDLING_PRECAUTIONS
Column Name | Type | Null? | Definition |
---|---|---|---|
HANDLING_PRECAUTIONS_LONG_BLOB | LONGBLOB | Y | Stores large binary data containing warnings/instructions for nurses regarding the medication they are preparing for the patient. |
OCS_HANDLING_PRECAUTIONS_ID | DOUBLE | N | Unique generated number that identifies a single row on the OCS_HAZARDOUS_INFO table. |
SYNONYM_ID | DOUBLE | N | Identifies the synonym. Foreign Key from ORDER_CATALOG_SYNONYM table. |
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 - OCS_HANDLING_PRECAUTIONS
Child Column in OCS_HANDLING_PRECAUTIONS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |