Table Detail Report

OC_MULTI_PHARMACY_REVIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Catalog Multi Pharmacy Review
Definition: Table used to store the multiple pharmacy review required indicator of Order Catalog.
Table Type: REFERENCE





Column Detail - OC_MULTI_PHARMACY_REVIEW


Column Name Type Null? Definition
CATALOG_CD DOUBLE N Identifies the orderable item. Foreign Key from ORDER_CATALOG table.
MULTIPLE_PHARMACY_REVIEW_IND DOUBLE N Stores the multiple pharmacy review indicator. 0 indicates that catalog is not eligible for Multiple pharmacy review, 1 indicates that catalog is eligible for Multiple pharmacy review.
OC_MULTI_PHARMACY_REVIEW_ID DOUBLE N Unique generated number that identifies a single row on the OC_MULTI_PHARMACY_REVIEW 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 - OC_MULTI_PHARMACY_REVIEW


Child Column in OC_MULTI_PHARMACY_REVIEW(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD


OE_FIELD_MEANING



Column Section Relationship Section Top of Page


Table-level Detail

Description: OE Field Meaning
Definition: OE Field Meaning
Table Type: REFERENCE





Column Detail - OE_FIELD_MEANING


Column Name Type Null? Definition
DESCRIPTION VARCHAR(200) Y textual description
OE_FIELD_MEANING VARCHAR(25) N OE Field Meaning
OE_FIELD_MEANING_ID DOUBLE N OE Field Meaning Identifier. The value for this column does not come from an Oracle sequence. It is loaded via a CSV.
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 - OE_FIELD_MEANING




Parent Column in OE_FIELD_MEANING (PK) Child Table Name Child Column Name
Children: OE_FIELD_MEANING_ID ORDER_DETAIL_HISTORY OE_FIELD_MEANING_ID
ORDER_PROPOSAL_DETAIL OE_FIELD_MEANING_ID
PM_PSO_LINK OE_FIELD_MEANING_ID
RX_MED_ORD_DETAIL OE_FIELD_MEANING_ID
SCH_DETAIL OE_FIELD_MEANING_ID
SCH_PEND_EVENT_DETAIL OE_FIELD_MEANING_ID
SCH_PEND_ORDER_DETAIL OE_FIELD_MEANING_ID
SCH_REF_DETAIL OE_FIELD_MEANING_ID


OE_FORMAT_FIELDS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Order Entry Format Fields
Definition: Table stores all the fields that will be placed on an order entry format.
Table Type: REFERENCE





Column Detail - OE_FORMAT_FIELDS


Column Name Type Null? Definition
ACCEPT_FLAG DOUBLE Y Flag describes whether the field is accepted or not and how. 0 - Required, 1 - Optional, 2 - No Display, 3 - Display Only
ACTION_TYPE_CD DOUBLE N The type of action to associate this field to the format with.
CARRY_FWD_PLAN_IND DOUBLE N Indicates whether to bring forward the value of this field from one order to the next for PowerPlans. The "field" is the front end format field which in relation to this table is the entire row of this table. A good example would be a Dose field. 1 - Carry Forward, 0- Do not Carry Forward
CLIN_LINE_IND DOUBLE Y An indicator on whether to show this field on the clinical display line.
CLIN_LINE_LABEL VARCHAR(25) Y The label to be shown with the field value on the clinical line.
CLIN_SUFFIX_IND DOUBLE Y An indicator on whether to show the clinical line label as a suffix to the field value.
CORE_IND DOUBLE Y A core field will require the eco server to re-explode orders
DEFAULT_PARENT_ENTITY_ID DOUBLE N The identifier for the default value, if the default value is coded. This field will be empty (zero) for non-coded defaults.
DEFAULT_PARENT_ENTITY_NAME VARCHAR(32) Y The name of the table that the coded default value is from. This field will be empty for non-coded defaults.
DEFAULT_VALUE VARCHAR(100) Y The default value to be used for this field.
DEF_PREV_ORDER_IND DOUBLE Y An indicator on whether to bring forward the value of this field from one order to the next.
DEPT_LINE_IND DOUBLE Y An indicator on whether to show this field on the department display line.
DEPT_LINE_LABEL VARCHAR(25) Y The label to show with the field value on the department display line.
DEPT_SUFFIX_IND DOUBLE Y An indicator on whether to show the department line label as a suffix to the field value.
DISP_DEPT_YES_NO_FLAG DOUBLE Y A flag on whether to show all positive and negative responses to a YES/NO field on the dept displayline. 0 - Display Yes/No, 1 - Display Yes, 2 - Display No
DISP_YES_NO_FLAG DOUBLE Y A flag on whether to show the positive/negative responses to a YES/NO field on the clinical displayline. 0 - Display Yes/No, 1 - Display Yes, 2 - Display No.
EPILOG_METHOD DOUBLE Y For future use.
FIELD_SEQ DOUBLE Y A sequence number identifying the order of all the fields that have been grouped together using thegroup sequence.
FILTER_PARAMS VARCHAR(255) Y Filter parameters order detail list boxes.
GROUP_SEQ DOUBLE Y A sequence number used to identify the ordering of fields on the format.
INPUT_MASK VARCHAR(50) Y For future use
LABEL_TEXT VARCHAR(200) Y The label that should be displayed for this field.
LOCK_ON_MODIFY_FLAG DOUBLE N Indicates if a detail is to be locked for a modify action. A 0 indicates that the detail is not locked and the accept_flag will be honored. 0 - Not locked, 1 - Locked.
MAX_NBR_OCCUR DOUBLE Y The maximum number of times this field can appear on the format.
OE_FIELD_ID DOUBLE N The id of the field.
OE_FORMAT_ID DOUBLE N The id of the format.
PROLOG_METHOD DOUBLE Y For future use.
REQUIRE_COSIGN_IND DOUBLE Y An indicator on whether this field, if changed, should cause the cosign logic to be checked.
REQUIRE_REVIEW_IND DOUBLE Y Requires a nurse to review an order placed. Keeps an order in a Pending Review status.
REQUIRE_VERIFY_IND DOUBLE Y Requires Pharmacist to verify an order. In On Hold status until it is verified.
STATUS_LINE VARCHAR(200) Y A display line of information about the 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.
VALUE_REQUIRED_IND DOUBLE Y An indicator on whether the field has to have a value entered.



Relationship Detail - OE_FORMAT_FIELDS


Child Column in OE_FORMAT_FIELDS(FK) Parent Table Name Parent Column Name
Parents: ACTION_TYPE_CD ORDER_ENTRY_FORMAT ACTION_TYPE_CD
OE_FORMAT_ID ORDER_ENTRY_FORMAT OE_FORMAT_ID


ORDER_CATALOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: ORDER CATALOG
Definition: Stores the orderables for a site
Table Type: REFERENCE





Column Detail - ORDER_CATALOG


Column Name Type Null? Definition
ABN_REVIEW_IND DOUBLE Y Indicator for PathNet
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.
ACTIVITY_SUBTYPE_CD DOUBLE N Stores the code value for the activity sub-type that is used to filter order catalog items within activity type
ACTIVITY_TYPE_CD DOUBLE N Stores the code value for the activity type that is used to filter order catalog items within catalog type
AUTO_CANCEL_IND DOUBLE Y If auto_cancel_ind is 1, it can be automatically cancelled when a patient is discharged.
BILL_ONLY_IND DOUBLE Y Indicator on whether this is a bill only orderable.
CATALOG_CD DOUBLE N Used to store the internal code for the order catalog item
CATALOG_TYPE_CD DOUBLE N Used to store the internal code for the catalog type. Used as a filtering mechanism for rows on theorder catalog table
CKI VARCHAR(255) Y For Meds Processing
COMMENT_TEMPLATE_FLAG DOUBLE Y Flag to indicate that a comment template exists for the orderable.
COMPLETE_UPON_ORDER_IND DOUBLE Y Indicator on whether to complete this orderable automatically when it is ordered.
CONCEPT_CKI VARCHAR(255) Y Concept CKI is the functional Concept Identifier; it is the codified means within Millennium to identify key medical concepts to support information processing, clinical decision support, executable knowledge and knowledge presentation.
CONSENT_FORM_FORMAT_CD DOUBLE N The code value identifying the CONSENT FORM FORMAT
CONSENT_FORM_IND DOUBLE Y Indicator on whether to print a consent form for this orderable.
CONSENT_FORM_ROUTING_CD DOUBLE N The consent form routing id to use for this orderable. It comes from dcp_output_route_id in dcp_output_route table.
CONT_ORDER_METHOD_FLAG DOUBLE Y Flag to define what type of continuing order this orderable should be.
CS_INDEX_CD DOUBLE N The type of indexing to use for this orderable if it is a careset
DCP_CLIN_CAT_CD DOUBLE N The clinical category for this orderable.
DC_DISPLAY_DAYS DOUBLE Y How long to display after it has been discontinued
DC_INTERACTION_DAYS DOUBLE Y How many days it will have an interaction after it has been discontinued
DEPT_DISPLAY_NAME VARCHAR(100) Y Used to store the preferred display name used by departmental applications using the order catalog table
DEPT_DUP_CHECK_IND DOUBLE Y Used to indicate if departmental dup checking information has been specified for the order catalog item in the dept_dup_check table
DESCRIPTION VARCHAR(100) Y The description of the Orderable
DISABLE_ORDER_COMMENT_IND DOUBLE Y Used to disable order comment.
DISCERN_AUTO_VERIFY_FLAG DOUBLE N Flag representing current order catalog's auto verification settings for Discern Alerts. '0' = No Setting '1' = "No" - No auto verification performed. '2' = "No w/Clinical Checking" - If alerts exist, auto verification is not performed. '3' = "Yes w/Reason" - Only auto verify if a reason was provided with the alert(s).'4' = "Yes" - Auto verify regardless of alerts.
DOSING_ACT_INGRED_CODE DOUBLE Y User selected active ingredient code from the MLTM_NDC_ACT_INGRED_LIST table.
DOSING_ALL_INGRED_IND DOUBLE N Indicate strength dose is calculated based on all ingredients. If this field is set to 1, the dosing_act_ingred_code field will be cleared.
DUP_CHECKING_IND DOUBLE Y Indicator on whether or not to do duplicate checking.
EVENT_CD DOUBLE N Code for the type of event related to the order catalog.
FORM_ID DOUBLE N Holds the ID of the form to be displayed for this orderable.
FORM_LEVEL DOUBLE Y A preference will be used to control what level of forms to display for a posit. Arbitrary "importance" level.
IC_AUTO_VERIFY_FLAG DOUBLE N Flag representing current order catalog's auto verification settings for Interaction Checking. '0' = No Setting '1' = "No" - No auto verification performed. '2' = "No w/Clinical Checking" - If alerts exist, auto verification is not performed. '3' = "Yes w/Reason" - Only auto verify if a reason was provided with the alert(s).'4' = "Yes" - Auto verify regardless of alerts.
INST_RESTRICTION_IND DOUBLE Y Future Function
MODIFIABLE_FLAG DOUBLE Y Used for multi-ingredient orderables to indicate whether ingredients can be added to or subtracted from the order.
OE_FORMAT_ID DOUBLE N Used to store the internal identifier for the order entry format to be used by order entry applications
OP_DC_DISPLAY_DAYS DOUBLE N DC Display Days to be used when the catalog is ordered in an outpatient setting (i.e. Orig_Ord_As_Flag of 1 or 2). A -1 value indicates that the value is NOT SET and that DC_Display_Days will be used instead.
OP_DC_INTERACTION_DAYS DOUBLE N DC Interaction Days to be used when the catalog is ordered in an outpatient setting (i.e. Orig_Ord_As_Flag of 1 or 2). A -1 value indicates that the value is NOT SET and that DC_Interaction_Days will be used instead.
ORDERABLE_TYPE_FLAG DOUBLE Y Used to store the flag that indicates what type of orderable procedure the item has been assigned
ORDER_REVIEW_IND DOUBLE Y Indicator on whether to do review for this orderable
ORD_COM_TEMPLATE_LONG_TEXT_ID DOUBLE N Used to pont to the long text record to show the order comment template.
PREP_INFO_FLAG DOUBLE Y Flag on whether the orderable has a prep associated with it.
PRIMARY_MNEMONIC VARCHAR(100) N Used to store the abbreviated description for the synonym flagged as the primary synonym on the order_catalog_synonym table
PRINT_REQ_IND DOUBLE Y Indicator on whether this orderable should generate a requisition.
PROMPT_IND DOUBLE Y Used to indicate that one or more of the rows on the profile_task_r table have been flagged as having prompts
QUICK_CHART_IND DOUBLE Y Indicator on whether to do quick charting for this orderable.
REF_TEXT_MASK DOUBLE Y Value to define what online reference manual information has been built.
REQUISITION_FORMAT_CD DOUBLE N The requisition format to be used for this orderable.
REQUISITION_ROUTING_CD DOUBLE N The requisition routing is to use for this orderable. It comes from dcp_output_route_id in dcp_output_route table.
RESOURCE_ROUTE_CD DOUBLE N Future
RESOURCE_ROUTE_LVL DOUBLE Y Used to indicate at which level routing information exists. Valid values are 1- Routing information is appended to the order catalog, 2- Routing information is appended to the task/assays associated ith the order catalog on profile_task_r. 3- Routing information is appended to the rows on profile_task_r. 4- Routing information is appended to the route_code_resource_list table
REVIEW_HIERARCHY_ID DOUBLE N Future
SCHEDULE_IND DOUBLE Y Indicator on whether to this orderable is available for scheduling
SOURCE_VOCAB_IDENT VARCHAR(50) Y The common name identifier for this order catalog.
SOURCE_VOCAB_MEAN VARCHAR(12) Y The meaning of the source vocabulary for the common name.
STOP_DURATION DOUBLE Y NEW
STOP_DURATION_UNIT_CD DOUBLE N NEW
STOP_TYPE_CD DOUBLE N new code
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.
VETTING_APPROVAL_FLAG DOUBLE N This field indicates whether an order is a vetting order or not and whether or not it requires approval. This field will only apply to radiology procedures. 0 - not a vetting order 1 - vetting order, does not require approval 2 - vetting order, requires approval



Relationship Detail - ORDER_CATALOG


Child Column in ORDER_CATALOG(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD CODE_VALUE CODE_VALUE
FORM_ID DCP_FORMS_REF DCP_FORM_INSTANCE_ID
CONSENT_FORM_ROUTING_CD DCP_OUTPUT_ROUTE DCP_OUTPUT_ROUTE_ID
REQUISITION_ROUTING_CD DCP_OUTPUT_ROUTE DCP_OUTPUT_ROUTE_ID
OE_FORMAT_ID ORDER_ENTRY_FORMAT_PARENT OE_FORMAT_ID
REVIEW_HIERARCHY_ID RES_REVIEW_HIERARCHY REVIEW_HIERARCHY_ID




Parent Column in ORDER_CATALOG (PK) Child Table Name Child Column Name
Children: CATALOG_CD ALERT_AUDIT_ALLERGY_DOM CATALOG_CD
ALERT_AUDIT_DRUG_DOM CAUSING_CATALOG_CD
ALERT_AUDIT_DRUG_DOM SUBJECT_CATALOG_CD
ALERT_AUDIT_DUP_DOM CAUSING_CATALOG_CD
ALERT_AUDIT_DUP_DOM SUBJECT_CATALOG_CD
ALERT_AUDIT_FOOD_DOM CATALOG_CD
AOAV_MED_RESULT CATALOG_CD
AP_DIAG_AUTO_CODE CATALOG_CD
AP_FT_TERM_PROC CATALOG_CD
AP_PREFIX ORDER_CATALOG_CD
AP_PREFIX_AUTO_TASK CATALOG_CD
AP_SYNOPTIC_RPT_SECTION_R CATALOG_CD
AUTHORIZATION_ITEM ORDER_CATALOG_CD
AUTHORIZATION_ITEM_HIST ORDER_CATALOG_CD
BB_GROUP_COMPONENT CATALOG_CD
BILL_ONLY_PROC_RELTN CATALOG_CD
CASE_REPORT CATALOG_CD
CATALOG_EVENT_SETS CATALOG_CD
CATALOG_TAT CATALOG_CD
CHART_GRP_EVNT_SET ORDER_CATALOG_CD
CS_COMPONENT CATALOG_CD
CV_ORDER_CATEGORY_R CATALOG_CD
CV_PROC CATALOG_CD
CYTO_REPORT_CONTROL CATALOG_CD
CYTO_STANDARD_RPT CATALOG_CD
DIFFERENTIAL_REF CATALOG_CD
DUP_CHECKING CATALOG_CD
ENCNTR_PROCEDURE CATALOG_CD
FORM_ASSOCIATION CATALOG_CD
GS_MED_CLAIM CATALOG_CD
HLA_AB_SCREEN_HISTORY_MAP CATALOG_CD
HLA_AB_SPEC_MAP CATALOG_CD
INTERP_TASK_ASSAY ORDER_CAT_CD
MAMMO_FOLLOW_UP CATALOG_CD
MED_ADMIN_INGREDIENT_META INGREDIENT_REF_ID
MIC_ABN_ORG_RESPONSE_CODE CATALOG_CD
MIC_ABN_SUS_RESULT CATALOG_CD
MIC_ACT_ANG_SUM_RPT CATALOG_CD
MIC_ANG_AUTOMATED CATALOG_CD
MIC_ANG_TIMES CATALOG_CD
MIC_GROUP_RESPONSE CATALOG_CD
MIC_MEDIA_ACTIVITY CATALOG_CD
MIC_MEDIA_DEFAULT CATALOG_CD
MIC_MEDS_ACTIVITY CATALOG_CD
MIC_ORDER_LAB CATALOG_CD
MIC_PATHOGEN CATALOG_CD
MIC_REF_ANG CATALOG_CD
MIC_REPORT_CORRELATION CATALOG_CD
MIC_RPT_PARAMS CATALOG_CD
MIC_STAIN_CORRELATION CATALOG_CD
MIC_TASK_LOG CATALOG_CD
MIC_VALID_SUS_PANEL CATALOG_CD
MIC_WORKCARD_CORRELATION CATALOG_CD
OC_MULTI_PHARMACY_REVIEW CATALOG_CD
ORC_RESOURCE_LIST CATALOG_CD
ORDER_CATALOG_REVIEW CATALOG_CD
ORDER_CATALOG_SYNONYM CATALOG_CD
ORDER_CATALOG_TEXT CATALOG_CD
ORDER_DIAG_CONFIG CATALOG_CD
ORDER_PROPOSAL CATALOG_CD
ORDER_PROPOSAL_INGREDIENT CATALOG_CD
ORDER_RADIOLOGY CATALOG_CD
ORDER_RESULTS_HOLD_CONFIG CATALOG_CD
ORDER_RX_SCRATCHPAD CATALOG_CD
ORDER_TASK_XREF CATALOG_CD
ORDER_TRACKING_WORKLIST CATALOG_CD
ORM_ORD_HIST_SNAPSHOT_COMP CATALOG_CD
PL_SEG_CAT_CD_XREF CATALOG_CD
PREFERENCE_CARD CATALOG_CD
PREFIX_REPORT_R CATALOG_CD
PREFIX_RPT_FONT_INFO CATALOG_CD
PROD_ORD_PROD_IDX_R CATALOG_CD
RAD_ENCNTR_PATH_R CATALOG_CD
RAD_FOLLOW_UP_RECALL CATALOG_CD
RAD_PROCEDURE_ASSOC CATALOG_CD
RAD_PROCEDURE_TIMES CATALOG_CD
RAD_PROC_FIELD_RELTN CATALOG_CD
RAD_PROTOCOL_CONFIG PROCEDURE_CD
RAD_RELEVANT_PRIOR_RELTN CATALOG_CD
RAD_RELEVANT_PRIOR_RELTN PRIOR_CATALOG_CD
RAD_TEMPLATE_GROUP CATALOG_CD
REV_Q_FILT_CRIT_ORD_PROC CATALOG_CD
RX_THERAP_SBSTTN_FROM FROM_CATALOG_CD
RX_THERAP_SBSTTN_TO TO_CATALOG_CD
SCH_BOOKING_ORD CATALOG_CD
SERVICE_DIRECTORY CATALOG_CD
SN_PICKLIST_PREF_CARD_R CATALOG_CD
SN_PROC_CPT_R PROCEDURE_CD
SURGICAL_PROCEDURE CATALOG_CD
SURG_PROC_DETAIL CATALOG_CD
TECHNIQUE_DEFAULTS CATALOG_CD
TRANS_EXAM_EXCLUSIONS CATALOG_CD


ORDER_CATALOG_REVIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: ORDER CATALOG REVIEW
Definition: Controls routing of nurse review, doctor cosign and pharmacy verify.
Table Type: REFERENCE





Column Detail - ORDER_CATALOG_REVIEW


Column Name Type Null? Definition
ACTION_TYPE_CD DOUBLE N Order Action Type: Order, Modify, Cancel, Discontinue
CATALOG_CD DOUBLE N Unique identifier for orderable items.
COSIGN_REQUIRED_IND DOUBLE Y On hold until doctor cosigns it.
DOCTOR_COSIGN_FLAG DOUBLE Y 0 - No Cosign Needed 1 - Ordering Physician Provider_id 2 - Attending Physician Provider_id 3 - Order detail Provider_id
NURSE_REVIEW_FLAG DOUBLE Y 0 - No verify needed 1 - Location_cd = ordering location 2 - Location _cd = patient location 3 - Order detail defines provider_id 4 - Order detail defines location_cd
REVIEW_REQUIRED_IND DOUBLE Y On Hold until a nurse reviews it
RX_VERIFY_FLAG DOUBLE Y 0 - No verify needed. 2 - Required in On Hold status.
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 - ORDER_CATALOG_REVIEW


Child Column in ORDER_CATALOG_REVIEW(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD