Table Detail Report

OMF_MODE_OPERAND



Column Section Top of Page


Table-level Detail

Description: Holds operands between a rules modes.
Definition: Holds operands between a rules modes such as for Infection Control - 'Demographics' AND ('Micro' OR 'Lab' OR 'Susceptibiliities')
Table Type: REFERENCE





Column Detail - OMF_MODE_OPERAND


Column Name Type Null? Definition
MODE1_CD DOUBLE N Mode_cd of first mode.
MODE2_CD DOUBLE N Mode code of second mode.
OPERAND VARCHAR(20) Y Operand to use between mode rule parts such as 'AND' or 'OR'.
RULE_ID DOUBLE N Unique rule_id from the omf_rules table.
VIS_MODE_CD1 VARCHAR(255) Y No longer used.
VIS_MODE_CD2 VARCHAR(255) Y No longer used.


OMF_OPERAND



Column Section Top of Page


Table-level Detail

Description: OMF OPERAND
Definition: Holds operands between items in one line of a rule.
Table Type: REFERENCE





Column Detail - OMF_OPERAND


Column Name Type Null? Definition
CONDITION_LEVEL DOUBLE Y No longer used.
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_LEVEL DOUBLE Y No longer used.
MODE_SEQ DOUBLE N Determines what order to display lines on the rule builder grid. Also used with omf_mode_operand table to determine what operand goes between mode sequences.
OPERAND VARCHAR(20) Y '=' or '!=' - Determines whether we are excluding or including the value being tested.
OPERAND_SEQ DOUBLE N Used when a string field on this table exceeds 255 characters.
RULE_ID DOUBLE N Unique rule_id from the omf_rules table.
VALUE1 VARCHAR(100) Y Database value of a qualifiers (on left side of operand).
VALUE2 VARCHAR(100) Y Database value of a qualifiers (on right side of operand). Can be more than one of these per 'VALUE1'.
VALUE2_SEQ DOUBLE N Used if more than one 'VALUE2' per 'VALUE1'.
VALUE_SEQ DOUBLE N Sequence of qualifiers per mode sequence.
VIS_VALUE1 VARCHAR(255) Y On screen value of VALUE1.
VIS_VALUE2 VARCHAR(255) Y On screen value of VALUE2.


OMF_PVB_COL_INFO



Column Section Top of Page


Table-level Detail

Description: OMF PVB COL INFO
Definition: Column information about scheduled results sets from PowerVision.
Table Type: ACTIVITY





Column Detail - OMF_PVB_COL_INFO


Column Name Type Null? Definition
ALIGN_FLAG DOUBLE Y Not currently used.
BATCH_ID DOUBLE N ID of the result set this column info comes from.
CI_SEQ DOUBLE N Sequence used to provide uniqueness.
DATA_COL DOUBLE Y Position in list of visible facts and dimensions for this result_set.
DATA_TYPE_FLAG DOUBLE Y Data type of this column.
DISPLAY_IND DOUBLE Y Indicates whether this column is visible.
FACT_IND DOUBLE Y Indicates whether this is a fact or dimension.
FORMAT VARCHAR(255) Y Formatting to apply to this column.
FORM_MAP_NAME VARCHAR(255) Y String to refer to in formulas.
HELP_DESC_STR VARCHAR(255) Y Help description for this column.
NAME VARCHAR(255) Y Name of column.
PVFORMULA1 VARCHAR(255) Y Formula string.
PVFORMULA2 VARCHAR(255) Y Formula string2.
PVFORMULA3 VARCHAR(255) Y Formula string3.
PVFORMULA4 VARCHAR(255) Y Formula string4.
TOTALS_STR VARCHAR(40) Y Not currently used.
VO_GROUP_ID DOUBLE N Template folder which holds this column.
VO_ID DOUBLE N Indicator_cd for the column.


OMF_PVB_DATA



Column Section Top of Page


Table-level Detail

Description: OMF PVB DATA
Definition: Result set data for PowerVision scheduled views.
Table Type: ACTIVITY





Column Detail - OMF_PVB_DATA


Column Name Type Null? Definition
BATCH_ID DOUBLE N Id of the result set which this data is for.
DATA_VALUE DOUBLE Y Numeric value for a FACT column.
DISP1 VARCHAR(255) Y Data to display.
DISP2 VARCHAR(255) Y Data to display.
DISP3 VARCHAR(255) Y Data to display.
DISP4 VARCHAR(255) Y Data to display.
D_COL DOUBLE N The column portion of a row-column intersection (address).
D_ROW DOUBLE N The row portion of a row-column intersection (address).
UNIQ VARCHAR(255) Y Value which provides uniqueness to the column's data - e.g. person_id as opposed to person_name.
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.


OMF_PVB_SELECT



Column Section Top of Page


Table-level Detail

Description: Select statement used to generate the result set for a scheduled PowerVision vie
Definition: Select statement used to generate the result set for a scheduled PowerVision view.
Table Type: ACTIVITY





Column Detail - OMF_PVB_SELECT


Column Name Type Null? Definition
BATCH_ID DOUBLE N Result set this select statement is for.
SELECT_STMT VARCHAR(255) Y CCL select statement.
SEL_SEQ DOUBLE N Ordering sequence.