Table Detail Report

OMF_AUTH_PRSNL_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF Authorization Personnel Group
Definition: The authentication value(s) which have been implemented for a specific PRSNL_GROUP.
Table Type: REFERENCE





Column Detail - OMF_AUTH_PRSNL_GROUP


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ATTR_PARENT_ENTITY_ID DOUBLE N The foreign key from the table that is being checked for authentication values.
ATTR_PARENT_ENTITY_NAME VARCHAR(32) Y The name of the table whose values are being authenticated.
ATTR_VALUE_TXT VARCHAR(255) Y The string value that is implemented for authentication. This is used when the authenticated value is not one stored in a Millennium table.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
OMF_AUTH_LOGON_ATTR_RELTN_ID DOUBLE N The internal surrogate value which identifies the logon type and attribute type value(s) associated with this record.
OMF_AUTH_PRSNL_GROUP_ID DOUBLE N Unique, generated number that identifies a single row on the OMF_AUTH_PRSNL_GROUP table.
PRSNL_GROUP_ID DOUBLE N The internal surrogate value which identifies the group that is using these particular security validations.
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_AUTH_PRSNL_GROUP


Child Column in OMF_AUTH_PRSNL_GROUP(FK) Parent Table Name Parent Column Name
Parents: OMF_AUTH_LOGON_ATTR_RELTN_ID OMF_AUTH_LOGON_ATTR_RELTN OMF_AUTH_LOGON_ATTR_RELTN_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


OMF_CALC_INDICATOR



Column Section Top of Page


Table-level Detail

Description: List of indicators needed by PowerVision to calculate a given indicator.
Definition: List of indicators needed by PowerVision to calculate a given indicator. This ensures that a formula indicator will be able to be calculated regardless of whether the user chooses the indicators it is dependent on to be viewed.
Table Type: REFERENCE





Column Detail - OMF_CALC_INDICATOR


Column Name Type Null? Definition
CALC_INDICATOR_CD DOUBLE N Indicator which is needed by another indicator to be calculated. (cdf_meaning = 'INDICATOR'). Other codesets can be used besides 14265 depending on the team defining the value.
INDICATOR_CD DOUBLE N Indicator which needs other indicators to calculate it. (cdf_meaning = 'INDICATOR'). Other codesets can be used besides 14265 depending on the team defining the value.
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_CFGRN_DOMN



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF Configuration Domain
Definition: The domains associated with items used to drive dynamic configuration/preference settings.
Table Type: REFERENCE





Column Detail - OMF_CFGRN_DOMN


Column Name Type Null? Definition
CFGRN_DOMN_ID DOUBLE N The system assigned unique value for the domain.
DOMN_DESC_TXT VARCHAR(255) N The description of the domain that will be displayed in the application.
DOMN_NAME_TXT VARCHAR(255) N The unique description of the domain.
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_CFGRN_DOMN




Parent Column in OMF_CFGRN_DOMN (PK) Child Table Name Child Column Name
Children: CFGRN_DOMN_ID OMF_CFGRN_SECT CFGRN_DOMN_ID


OMF_CFGRN_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF Configuration Item
Definition: Items used to drive dynamic configuration/preference settings.
Table Type: REFERENCE





Column Detail - OMF_CFGRN_ITEM


Column Name Type Null? Definition
CFGRN_ITEM_ID DOUBLE N The system assigned unique value for the item.
CFGRN_SECT_ID DOUBLE N The system assigned value of the item's parent section_id.
DFLT_OPT_VALUE_TXT VARCHAR(255) Y The item's default unique value setting.
EPILOG_MSG_TXT VARCHAR(255) Y Provides a message to the end user after a change has been made.
FILTER_MEANING VARCHAR(50) Y The filter meaning associated with the configuration item.
ITEM_DESC_TXT VARCHAR(255) N The description of the item that will be displayed in the application.
ITEM_NAME_TXT VARCHAR(255) N The unique description of the item.
OPT_TYPE_FLAG DOUBLE N The type of option associated with the configuration item.
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_CFGRN_ITEM


Child Column in OMF_CFGRN_ITEM(FK) Parent Table Name Parent Column Name
Parents: CFGRN_SECT_ID OMF_CFGRN_SECT CFGRN_SECT_ID
FILTER_MEANING OMF_FILTER_MEANING FILTER_MEANING




Parent Column in OMF_CFGRN_ITEM (PK) Child Table Name Child Column Name
Children: CFGRN_ITEM_ID OMF_CFGRN_ITEM_ACTN CFGRN_ITEM_ID
OMF_CFGRN_ITEM_SETNG CFGRN_ITEM_ID


OMF_CFGRN_ITEM_ACTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF Configuration Item Action
Definition: Action(s) associated with a configuration item.
Table Type: REFERENCE





Column Detail - OMF_CFGRN_ITEM_ACTN


Column Name Type Null? Definition
ACTN_FLAG DOUBLE N The action type for this item/sequence pairing.
CFGRN_ITEM_ACTN_ID DOUBLE N The unique identifier of the item associated with this configuration action.
CFGRN_ITEM_ID DOUBLE N The unique identifier for the Configuration Item.
SEQ_NBR DOUBLE N Sequences multiple actions for an item.
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.
VAL1 VARCHAR(255) Y Almost always a script to be executed by an action. May also be a value passed in to action script.
VAL2 VARCHAR(255) Y Passed in string value to action script.
VAL3 VARCHAR(255) Y Passed in string value to action script.
VAL4 VARCHAR(255) Y Passed in string value to action script.
VAL5 VARCHAR(255) Y Passed in string value to action script.



Relationship Detail - OMF_CFGRN_ITEM_ACTN


Child Column in OMF_CFGRN_ITEM_ACTN(FK) Parent Table Name Parent Column Name
Parents: CFGRN_ITEM_ID OMF_CFGRN_ITEM CFGRN_ITEM_ID