ACCEPT_FORMAT_FLEXING



Column Section Top of Page


Table-level Detail

Description: Accept Format Flexing
Definition: Flexing options for order entry formats.
Table Type: REFERENCE





Column Detail - ACCEPT_FORMAT_FLEXING


Column Name Type Null? Definition
ACCEPT_FLAG DOUBLE Y This field controls whether a field is required, optional, hidden, etc. 0 - Required, 1 - Optional, 2 - No Display, 3 - Display Only.
ACTION_TYPE_CD DOUBLE N The order action that this flexing is built for.
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
DEFAULT_PARENT_ENTITY_ID DOUBLE Y The identifier for the coded default values. This field will be empty (zero) for non-coded defaults.
DEFAULT_PARENT_ENTITY_NAME VARCHAR(32) Y 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 flexing.
FLEX_CD DOUBLE N Accept format flexing code. Identifies the flex value this record is for. Depending on the flex_type_flag, this could contain a location_cd, position_cd or an application_cd.
FLEX_PARENT_ENTITY_ID DOUBLE Y Identifies the flex value this record is for. Depending on the flex_type_flag, this could contain a location_cd, position_cd or an application_cd.
FLEX_PARENT_ENTITY_NAME VARCHAR(32) Y The table that contains the flex parameter as a key. Will currently always be CODE_VALUE.
FLEX_TYPE_FLAG DOUBLE N Identifies which type of flexing this record is for (e.g. application, position, etc.). 0 - Ordering Location, 1 - Patient Location, 2 - Application, 3 - Position, 4 - Encounter Type.
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.
OE_FIELD_ID DOUBLE N The order entry field that is to be flexed.
OE_FORMAT_ID DOUBLE N The Order entry format that is to be flexed.
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.


ALT_SEL_CAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alternate Orderable Selection Category
Definition: Used to store alternate search categories or items. (i.e. PowerOrders favorites and favorite folders)
Table Type: REFERENCE





Column Detail - ALT_SEL_CAT


Column Name Type Null? Definition
ADHOC_IND DOUBLE Y Indicates this category is for Ad hoc charting from the task list.
AHFS_IND DOUBLE Y Used to mark a category or item as a therapeutic class or category.
ALT_SEL_CATEGORY_ID DOUBLE N Primary key for this table.
CHILD_CAT_IND DOUBLE Y Indicates that this category has child categories.
FOLDER_FLAG DOUBLE Y Type of Folder related to the corresponding Alternate Selection Category; i.e., 1 - Normal Folder, 2 - IV Favorite Folder
IV_SET_SYNONYM_ID DOUBLE N This ID uniquely identifies the IV set used to place the order. This field is only valued for IV orders that start with an IV set.
LONG_DESCRIPTION VARCHAR(1000) Y Long description string for this category.
LONG_DESCRIPTION_KEY_CAP VARCHAR(1000) Y The Long Description column stored in all uppercase with spaces & special characters removed.
LONG_DESCRIPTION_KEY_CAP_A_NLS VARCHAR(4000) Y Stores the corresponding non-English character set values for the Long_Description_Key_CAP column. Used to sort correctly internationally.
LONG_DESCRIPTION_KEY_CAP_NLS VARCHAR(2002) Y An _NLS sort column for internationalization.Column is no longer used. Replaced by A_NLS column so the French Accent is handled properly. Obsolete.
OWNER_ID DOUBLE N Person ID of the user that created this category.
SECURITY_FLAG DOUBLE Y Used to mark a category or item as private or public writable. 1 - Private, 0 or 2 Public.
SHORT_DESCRIPTION VARCHAR(500) Y Display value to be seen in most apps for this category.
SOURCE_COMPONENT_FLAG DOUBLE N Stores the Source application/task to enable selective display of favorites. 0 - Favorite is not application specific, 1 - Favorite was created in Power Orders, 2 - Favorite was created in Easy Script, 3 - Favorite was created in Super Bill.
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 - ALT_SEL_CAT


Child Column in ALT_SEL_CAT(FK) Parent Table Name Parent Column Name
Parents: IV_SET_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID




Parent Column in ALT_SEL_CAT (PK) Child Table Name Child Column Name
Children: ALT_SEL_CATEGORY_ID ALT_SEL_LIST ALT_SEL_CATEGORY_ID
ALT_SEL_LIST CHILD_ALT_SEL_CAT_ID
BR_OF_PARENT_RELTN ALT_SEL_CATEGORY_ID
FILL_PRINT_ORD_HX THER_CLASS_ID
PHA_PROD_DISP_OBS_ST PARENT_THERAP_CLASS_ID
PHA_PROD_DISP_OBS_ST ROOT_THERAP_CLASS_ID
PHA_PROD_DISP_OBS_ST THERAP_CLASS_ID
SCH_APPT_ORD ALT_SEL_CATEGORY_ID


ALT_SEL_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alternate Selection List.
Definition: Alternate Selection List. Contains the parent-child associations between alternate selection categories and other categories, synonyms, home-health problems and reference tasks.
Table Type: REFERENCE





Column Detail - ALT_SEL_LIST


Column Name Type Null? Definition
ALT_SEL_CATEGORY_ID DOUBLE N The unique identifier for the parent alternate selection category.
CHILD_ALT_SEL_CAT_ID DOUBLE N The unique identifier for the child alternate selection category.
LIST_TYPE DOUBLE Y Indicates what type of child the record references. Valid values are: 1 - alternate selection category, 2 - synonym, 3 - home health problem, 4- reference task, 5 - IV favorites, 6 - plan, 7 - Regimen Synonym
ORDERED_AS_SYNONYM_ID DOUBLE Y The id of the order catalog synonym for the orderable for this ingredient when it's originally ordered.; The id of the order catalog synonym for the orderable for this ingredient when it's originally ordered.
ORDER_SENTENCE_ID DOUBLE N Favorite order sentence id.
PATHWAY_CATALOG_ID DOUBLE N The identifier for a Plan Child item. This field is valued if the list type is 6.
PW_CAT_SYNONYM_ID DOUBLE N The plan synonym that the entry is representing
REFERENCE_TASK_ID DOUBLE N The unique identifier for the reference task.
REGIMEN_CAT_SYNONYM_ID DOUBLE N Unique identifier for the REGIMEN_CAT_SYNONYM table. The identifier for a regimen synonym chld item. This field is valued if the list type is 7.
SEQUENCE DOUBLE N Specifies the sort order of all the children of a category.
SYNONYM_ID DOUBLE N The identifier for the synonym child. This field is valued if the list type is 2 or 3.
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 - ALT_SEL_LIST


Child Column in ALT_SEL_LIST(FK) Parent Table Name Parent Column Name
Parents: ALT_SEL_CATEGORY_ID ALT_SEL_CAT ALT_SEL_CATEGORY_ID
CHILD_ALT_SEL_CAT_ID ALT_SEL_CAT ALT_SEL_CATEGORY_ID
ORDERED_AS_SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
SYNONYM_ID ORDER_CATALOG_SYNONYM SYNONYM_ID
ORDER_SENTENCE_ID ORDER_SENTENCE ORDER_SENTENCE_ID
REFERENCE_TASK_ID ORDER_TASK REFERENCE_TASK_ID
PATHWAY_CATALOG_ID PATHWAY_CATALOG PATHWAY_CATALOG_ID
PW_CAT_SYNONYM_ID PW_CAT_SYNONYM PW_CAT_SYNONYM_ID
REGIMEN_CAT_SYNONYM_ID REGIMEN_CAT_SYNONYM REGIMEN_CAT_SYNONYM_ID


CATALOG_EVENT_SETS



Column Section Relationship Section Top of Page


Table-level Detail

Description: CATALOG EVENT SETS
Definition: Associates a order_catalog with event_set
Table Type: REFERENCE





Column Detail - CATALOG_EVENT_SETS


Column Name Type Null? Definition
CATALOG_CD DOUBLE N Foreign key table name order_catalog
EVENT_SET_NAME VARCHAR(100) N maps to event_set_name field on v500_event_set_cd
SEQUENCE DOUBLE N part of primary key
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 - CATALOG_EVENT_SETS


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


CLINICAL_VALIDATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Validation
Definition: This table groups Validation_Detail rows using a unique string.
Table Type: REFERENCE





Column Detail - CLINICAL_VALIDATION


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.
CLINICAL_VALIDATION_ID DOUBLE N Unique generated number that identifies a single row on the Clinical_Validation table.
MEASUREMENT_TYPE_CD DOUBLE N This is the measurement type code value for the grouping.
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.
VALIDATION_NAME VARCHAR(100) Y The Validation string identiifer for the Validation_Detail grouping.



Relationship Detail - CLINICAL_VALIDATION




Parent Column in CLINICAL_VALIDATION (PK) Child Table Name Child Column Name
Children: CLINICAL_VALIDATION_ID CLINICAL_VALIDATION_DETAIL CLINICAL_VALIDATION_ID
CLINICAL_VALIDATION_FAC_R CLINICAL_VALIDATION_ID