GROUP_PARAM
Column Section | Top of Page |
Table-level Detail
Description: | GROUP PARAM |
Definition: | OMF Grouping Tool parameters |
Table Type: | REFERENCE |
Column Detail - GROUP_PARAM
Column Name | Type | Null? | Definition |
---|---|---|---|
DELETE_VALUE | VARCHAR(255) | Y | Used to replace the delete bind variables in the OMF Grouping Tool. |
GROUPING_CD | DOUBLE | N | Group Type code_value |
PARAMETER | DOUBLE | N | Parameter # |
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_INS_VALUE | VARCHAR(255) | N | Parameter value for the 'omf_ins_omf_grouings' script. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
GROUP_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | GROUP TYPE |
Definition: | Group Types for the OMF Grouping Tool. |
Table Type: | REFERENCE |
Column Detail - GROUP_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
DELETE_SCRIPT | VARCHAR(255) | Y | Script to use to delete from this group type. |
DESCRIPTION | VARCHAR(255) | Y | Description of group type. |
GROUPING_CD | DOUBLE | N | Group type code value. |
MGMT_CD | DOUBLE | N | Determines the product group this group type belongs to. |
NUM_KEYS | DOUBLE | Y | Number of values used in key. |
STATUS_IND | DOUBLE | Y | Determines whether the Group Type is active. |
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_INSERT_SCRIPT | VARCHAR(255) | Y | Request number of script used to update or insert a group member. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - GROUP_TYPE
Parent Column in GROUP_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | GROUPING_CD | GROUP_TYPE_KEYS | GROUPING_CD |
GROUP_TYPE_KEYS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OMF Group type keys. |
Definition: | Contains: Group code value; script task numbers for ?selecting existing groups and getting list to chose from? |
Table Type: | REFERENCE |
Column Detail - GROUP_TYPE_KEYS
Column Name | Type | Null? | Definition |
---|---|---|---|
DESCRIPTION | VARCHAR(255) | Y | Description of group type key |
GROUPING_CD | DOUBLE | N | Group type code value. |
KEY_SELECT_LIST | VARCHAR(255) | Y | Task number for getting existing groupings (95300) when key_seq=1; and filter_meaning to get list of values if key_seq=2. |
KEY_SEQ | DOUBLE | N | Sequence for uniqueness. |
NUM_VALUE | DOUBLE | N | For key_seq = 1, the group's code value. Not used for key_seq = 2. |
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 - GROUP_TYPE_KEYS
Child Column in GROUP_TYPE_KEYS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | GROUPING_CD | GROUP_TYPE | GROUPING_CD |
OMF_APP_VIEWERS
Column Section | Top of Page |
Table-level Detail
Description: | OMF APP VIEWERS |
Definition: | List of (PowerVision style) viewers that a particular application can run. |
Table Type: | REFERENCE |
Column Detail - OMF_APP_VIEWERS
Column Name | Type | Null? | Definition |
---|---|---|---|
APPLICATION_NUMBER | DOUBLE | N | Application number from the APPLICATION table to which we are associating viewers. |
DEFAULT_IND | DOUBLE | Y | Determines whether this view type is the default viewer for this application. One and only one view type should have this set to 1 for a given application_number. |
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_TYPE | DOUBLE | N | Type of viewer that can be displayed. E.g a PowerVision grid/graph MDI, an advance data visualization tool, Risk Mgr viewer, IQHealth viewer, etc. |
OMF_AUDIT_CAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OMF Audit Category |
Definition: | Categories of logical parameters associated with audit events. |
Table Type: | REFERENCE |
Column Detail - OMF_AUDIT_CAT
Column Name | Type | Null? | Definition |
---|---|---|---|
AUDIT_CAT_CD | DOUBLE | N | That categories that are eligible to be audited. |
AUDIT_CAT_ID | DOUBLE | N | Unique, generated key for the OMF_AUDIT_CAT table. |
AUDIT_EVENT_NBR | DOUBLE | N | Foreign key to the AUDIT_EVENT table. This is the audit event/audit type pairing associated with this audit category. |
PARTICIPANT_ID_TYPE_TXT | VARCHAR(100) | N | The specific type of information that is audited. For example: person_id, Account Number |
PARTICIPANT_ROLE_TXT | VARCHAR(100) | N | The functional application role of Participant. The general category of the object being audited. For example, Patient, Provider. |
PARTICIPANT_TYPE_TXT | VARCHAR(100) | N | The general category of data that is to be audited. For example, Person, Organization |
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_AUDIT_CAT
Child Column in OMF_AUDIT_CAT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AUDIT_EVENT_NBR | AUDIT_EVENT | AUDIT_EVENT_NBR |
Parent Column in OMF_AUDIT_CAT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | AUDIT_CAT_ID | OMF_AUDIT_CAT_GRID_RELTN | AUDIT_CAT_ID |
OMF_AUDIT_CAT_IND_RELTN | AUDIT_CAT_ID |