Table Detail Report

OMF_EXPRESS_DICTIONARY



Column Section Top of Page


Table-level Detail

Description: OMF EXPRESS DICTIONARY
Definition: Holds the list of all values which can be checked in calc engine rules.
Table Type: REFERENCE





Column Detail - OMF_EXPRESS_DICTIONARY


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.
ARRAY_STR VARCHAR(255) Y String used to qualify arrays for rules.
CCL_STRING VARCHAR(255) Y The CCL code that is used in the formulas created by the OMF rule building applications.
DETAIL_IND DOUBLE Y Indicates whether the data is at the detail level (=1) - such as verifying tech, detail procedure, performing tech - or at the order level or higher (=0) - such as admitting physician, encntr_type, order_date, and patient.
DISPLAY_ORDER DOUBLE Y Order to display qualifications in the (IC) Rule builder.
EXPRESS_CD DOUBLE Y The code value that indicates whether the expression is used for rule qualification, calculation, or both.
EXPRESS_NUM DOUBLE N Unique identification number for the expression.
EXPRESS_SEQ DOUBLE N Sequence number used to order 'ccl_string's if they are greater than 255. Also provides uniqueness when this happens.
FILTER_MEANING VARCHAR(50) Y Name of filter from the omf_filter_meaning table. Is used to get the list of values for the TAT tool.
GROUP_NUM DOUBLE Y Groups express ids by purpose.
MODE_CD DOUBLE Y The code_value for the rule mode (only used in Infection Control. Examples: susceptibilities, antibiotics, and general lab results). Code set 14199.
MULTIPLE_IND DOUBLE Y Can multiple values be selected for this condition?
OMF_GROUPING_CD DOUBLE Y No longer used.
PL_SQL_FUNCTION VARCHAR(255) Y PL/SQL function to be applied to the CCL string outside of the normal select statement. Is a temporary work around until we can apply PL/SQL functions around CCL functions.
PRODUCT_CD DOUBLE N The code_value which identifies the product (e.g. Infection Control or Service Management). Code set 14135.
PROSE VARCHAR(255) Y Free text long description of the expression.
REQUIRED_IND DOUBLE Y Is this condition required? For example, in any IC susceptibility rule an antibiotic must be listed while source, isolate, and result do not.
REQ_GROUP_NUM DOUBLE Y The express_id of a group of this id. In the (IC) rule builder this will allow the user to only use a group OR the individual members but not both.
SHOW_ALL_IND DOUBLE Y OBSOLETE - Get from Filter meaning now. Used inTAT tool. 0 = Search prompt. Partial list appears; 1 = No search prompt. Entire list appear
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.
XREF_SCRIPT_NBR DOUBLE Y OBSOLETE - Get from Filter meaning now. Script request number which will produce the list of values to be displayed.


OMF_FILTER_MEANING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Info about column 'types' such as physician id (whether ordering, discharge, etc
Definition: Info about column 'types' such as physician id (whether ordering, discharge, etc), tech id, date, etc.
Table Type: REFERENCE





Column Detail - OMF_FILTER_MEANING


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.
CORE_IND DOUBLE N Indicates this row was created by Cerner.
DESCRIPTION VARCHAR(255) Y Filter meaning description.
DISPLAY_FUNCTION VARCHAR(100) Y Function needed to display a stored code value or id.
FILTER_MEANING VARCHAR(50) N Name of the filter meaning.
FILTER_PE_NAME VARCHAR(40) Y Parent entity name of this meaning. E.g. 'Code_value', 'Person', etc. This will be stamped on tables (such as omf_pv_security_filter and omf_pvi_filter) which will generically store these values. This is done so merges of these tables will be successful.
FILTER_SCRIPT DOUBLE Y Script to get list of possible items.
INACTIVE_PROMPT_IND DOUBLE Y Tells PowerVision whether the filtering dialog should display a prompt asking the user if they want to see inactive rows.
OWNER_GROUP_CD DOUBLE N The owner group of the filter meaning, used to categorize items across a solution group or functional area (ex Operational vs Financial).
SHOW_ALL_IND DOUBLE Y Whether all values will be displayed at once or if a start value should be prompted for.
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.
VAL1 VARCHAR(255) Y Passed in string value 1 to filter scripts. Typically will be the filter program name.
VAL2 VARCHAR(255) Y Passed in string value 2 to filter scripts. Typically a parameter such as code set or cdf_meaning.
VAL3 VARCHAR(255) Y Passed in string value 3 to filter scripts. Typically a parameter such as code set or cdf_meaning.
VAL4 VARCHAR(255) Y Passed in string value 4 to filter scripts. Typically a parameter such as code set or cdf_meaning.
VAL5 VARCHAR(255) Y Passed in string value 5 to filter scripts. Typically a parameter such as code set or cdf_meaning.



Relationship Detail - OMF_FILTER_MEANING




Parent Column in OMF_FILTER_MEANING (PK) Child Table Name Child Column Name
Children: FILTER_MEANING DA_ELEMENT FILTER_MEANING
OMF_AUTH_ATTR FILTER_MEANING
OMF_CFGRN_ITEM FILTER_MEANING


OMF_FORMULA



Column Section Top of Page


Table-level Detail

Description: OMF FORMULA
Definition: Holds user and client defined formulas created using PowerVision apps.
Table Type: REFERENCE





Column Detail - OMF_FORMULA


Column Name Type Null? Definition
GRID_CD DOUBLE N Subject area with which this formula is used. Different teams could uses different code_sets than 14265.
INDICATOR_CD DOUBLE N Formula Indicator ID.
NAME VARCHAR(50) Y The name of the formula.
OWNED_BY_FLAG DOUBLE Y Who owns this formula - e.g. the entire client site or a specific user.
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.
USER_ID DOUBLE N User's person_id who created the formula.


OMF_FUNCTION



Column Section Top of Page


Table-level Detail

Description: OMF FUNCTION
Definition: Names of pl/sql functions used by OMF.
Table Type: REFERENCE





Column Detail - OMF_FUNCTION


Column Name Type Null? Definition
FUNCTION_NAME VARCHAR(40) N Name of PL/SQL function.
RETURN_DTYPE VARCHAR(10) N Function return type - e.g. i4, vc, f8.
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.


OMF_GRID



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF Grids.
Definition: Grids related to a view and grouped by product. Also, tells whether a total line should be displayed.
Table Type: REFERENCE





Column Detail - OMF_GRID


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.
CLIENT_SA_DESC VARCHAR(255) Y Client defined description of a subject area in PowerVision. Not yet used.
DISPLAY VARCHAR(40) Y Subject area display name. This is optional. If not entered the code_value.display for the grid_cd will be used.
GRID_CD DOUBLE N Grid code value.
GRID_GROUP_CD DOUBLE N The grid's group - for PowerVision/Admin Tool display. Other codesets can be used besides 14265 depending on the team defining the value.
GRID_GROUP_DISPLAY VARCHAR(100) Y Grid group display name. This is optional. If not entered, the code_value.display for the GRID_CD column will be used.
OWNER VARCHAR(40) Y Cerner team owner. Not used yet.
PVDB_IND DOUBLE Y Used to indicate that this grid was built using the data import process.
PVDB_NAME VARCHAR(20) Y Indicates the name that the Oracle view and CCL DBIMPORT program will be called. Only applicable when grid is created using the data import process.
SA_DESC VARCHAR(255) Y Subject area description.
TOTAL_IND DOUBLE Y No longer used. Indicates whether a total line should appear on the grid.
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.
VIEW_CD DOUBLE N cdf_meaning='VIEW', display = . Other codesets can be used besides 14265 depending on the team defining the value.



Relationship Detail - OMF_GRID




Parent Column in OMF_GRID (PK) Child Table Name Child Column Name
Children: GRID_CD OMF_AUDIT_CAT_GRID_RELTN GRID_CD
OMF_GRID_COLUMN GRID_CD