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 |