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