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