Table Detail Report

OMF_GRID_COLUMN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Columns to display on a PowerVision grid.
Definition: Columns to display on a PowerVision grid
Table Type: REFERENCE





Column Detail - OMF_GRID_COLUMN


Column Name Type Null? Definition
GRID_CD DOUBLE N Code value for an indicator. The cdf_meaning is 'GRID'. Other codesets can be used besides 14265 depending on the team defining the value.
GRID_COLUMN_CD DOUBLE N Code value for an indicator or vo_type_cd. The cdf_meaning is 'INDICATOR'. Other codesets can be used besides 14265 depending on the team defining the value.
GRID_COLUMN_HDG VARCHAR(50) Y Column heading to display in grid.
GRID_COLUMN_SEQ DOUBLE N The order in which columns appear in the grid.
GRID_VO_IND DOUBLE Y Is the grid_column_cd a view option?
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 - OMF_GRID_COLUMN


Child Column in OMF_GRID_COLUMN(FK) Parent Table Name Parent Column Name
Parents: GRID_CD OMF_GRID GRID_CD


OMF_GROUPINGS



Column Section Top of Page


Table-level Detail

Description: OMF GROUPINGS
Definition: OMF groupings such as physicians, procedures, shifts, and locations.
Table Type: REFERENCE





Column Detail - OMF_GROUPINGS


Column Name Type Null? Definition
GROUPING_CD DOUBLE N Code value of the group type (e.g. UM PHYSICIANS, SMR LOCATIONS)
GROUPING_STATUS_CD DOUBLE N Status of 'ACTIVE' or 'INACTIVE'.
KEY1 VARCHAR(200) N Key 1 value. Typically the code_value, person_id, nomenclature_id that is being grouped.
KEY2 VARCHAR(200) Y Key 2 value. Typically the code value of the group that the item is in.
KEY3 VARCHAR(200) Y Key 3 value. Not used.
KEY4 VARCHAR(200) Y Key 4 value. Not used.
NUM1 DOUBLE Y Num 1 value - e.g. the age in years, day, etc. that is being grouped.
NUM2 DOUBLE Y Num 2 value - e.g. the age in years, day, etc. that is being grouped..
NUM3 DOUBLE Y Num 3 value. Not used.
NUM4 DOUBLE Y Num 4 value. Not used.
OMF_GROUPING_ID DOUBLE N Unique id of group/item combination.
STRING1 VARCHAR(200) Y String value 1.
STRING2 VARCHAR(200) Y String value 2.
STRING3 VARCHAR(200) Y String value 3.
STRING4 VARCHAR(200) Y String value 4.
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.
VALID_FROM_DT_TM DATETIME Y Start of when this grouping member is valid from.
VALID_UNTIL_DT_TM DATETIME Y End of when this grouping member is valid from.


OMF_INDICATOR



Column Section Top of Page


Table-level Detail

Description: OMF INDICATOR
Definition: Contains PowerVision indicators definitions.
Table Type: REFERENCE





Column Detail - OMF_INDICATOR


Column Name Type Null? Definition
ALIGN_FLAG DOUBLE Y Indicates view column alignment for PowerVision views.
COLUMN_STR VARCHAR(255) Y Column's name with a table abbreviation attached. Will be used in a CCL select statement.
DATA_TYPE_FLAG DOUBLE Y Indicator"s data type.
FACT_IND DOUBLE Y Is this indicator a fact or not? Can it be Summed, Averaged,etc.
FILTER_DESCRIPTION VARCHAR(100) Y Display value of the indicator in PowerVision if this indicator is filterable and not related to a template item..
FILTER_IND DOUBLE Y Indicates whether the indicator is filterable in PowerVision.
FILTER_MEANING VARCHAR(50) Y Generic meaning of an indicator if its filterable. E.g. NURSE UNIT, DETAIL PROCEDURE, PHYSICIAN, PATIENT, etc.
FORMAT VARCHAR(50) Y Format to display the indicator in PowerVision.
GENERIC_OPERAND VARCHAR(20) Y Operand (e.g. +, -, *, /) to use for generic indicators such as turnaround time indicators.
GROUP_BY_IND DOUBLE Y Indicates whether this indicator can be group-ed by (e.g. an patient id could but a patient name shouldn't since patients can share names).
GROUP_BY_STR VARCHAR(255) Y Value to use in group by if the column_str is not usable (e.g. if the column_str is a function).
GROUP_IND DOUBLE Y Is this indicator a group of indicators? Not used.
HELP_DESCRIPTION_STR VARCHAR(255) Y Help descriptions for bubble help in PowerVision.
INDICATOR_CD DOUBLE N Indicator's code value. cdf_meaning=INDICATOR, display=. Other codesets can be used besides 14265 depending on the team defining the value.
INDICATOR_TYPE_CD DOUBLE N Tells the type of indicator this is (e.g. RAW, GENERIC, etc.) cdf_meaning = .
KEY_INDICATOR_CD DOUBLE N Indicator code value of the indicator that this column is associated with. Would only be filled out when, e.g., the indicator is the physician name, then this column would be the indicator code value of the physician id. Used for PowerVision.
SELECT_LIST_NAME VARCHAR(12) Y No longer used. Column alias name to use in CCL selects. For example, 'select = from table1'
SG_TYPE VARCHAR(50) Y Study Group type such as PATIENT, PHYSICIAN,etc. Also used to allow drill path connections.
SORT_FLAG DOUBLE Y Sorting method - 0 by description/indicator; 1 = by id/key_indicator
STR_SEQ DOUBLE N Order to put together strings if an indicator's column_str value is greater than 255 characters.
TOTALS_CD DOUBLE N Total method to display in PowerVision (e.g. COUNT, SUM, FORMULA TOT, etc.)
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_IN_OUT_DAYS



Column Section Top of Page


Table-level Detail

Description: Store active days for rules which use in by/out by calculations.
Definition: Store active days for rules which use in by/out by calculations
Table Type: REFERENCE





Column Detail - OMF_IN_OUT_DAYS


Column Name Type Null? Definition
DAY_OF_WEEK DOUBLE N Day of week the rule is active for. 0=Sunday;...6=Saturday
EVENT_NUM DOUBLE N Event number such as 'ORDER', 'COMPLETE', 'DRAWN', etc.
RULE_ID DOUBLE N Rule id these days belong to.


OMF_LEVEL_OPERAND



Column Section Top of Page


Table-level Detail

Description: OMF LEVEL OPERAND
Definition: Holds operands between lines of rules.
Table Type: REFERENCE





Column Detail - OMF_LEVEL_OPERAND


Column Name Type Null? Definition
MODE_CD DOUBLE N The code_value for the rule mode (only used in Infection Control. Examples: susceptibilities, antibiotics, and general lab results). Code set 14199.
MODE_SEQ1 DOUBLE N One line of the rule for a mode.
MODE_SEQ2 DOUBLE N Second line of the rule for a mode.
OPERAND VARCHAR(20) Y Operand to put between rule lines.
RULE_ID DOUBLE N Rule identifier from the omf_rules table.