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 = |
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 |