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