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