Table Detail Report
OMF_PVI_VO
Column Section | Top of Page |
Table-level Detail
Description: | OMF PVI VO |
Definition: | View options chosen in PowerVision saved views and templates. |
Table Type: | REFERENCE |
Column Detail - OMF_PVI_VO
Column Name | Type | Null? | Definition |
---|---|---|---|
INDICATOR_CD | DOUBLE | N | PowerVision indicator that was chosen. Other codesets can be used besides 14265 depending on the team defining the value. |
OMF_PV_ITEM_ID | DOUBLE | N | Parent PowerVision Saved View or Template. |
SEQ1 | DOUBLE | N | Used for TAT indicator to define starting event. |
SEQ2 | DOUBLE | N | Used for TAT indicator to define ending event. |
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_PV_BATCH
Column Section | Top of Page |
Table-level Detail
Description: | OMF PV BATCH |
Definition: | Top level information of PowerVision scheduled views result sets. |
Table Type: | REFERENCE |
Column Detail - OMF_PV_BATCH
Column Name | Type | Null? | Definition |
---|---|---|---|
BATCH_ID | DOUBLE | N | Unique key. |
DELETE_ON_DT_TM | DATETIME | Y | Date when the result set should be deleted. |
ERROR_IND | DOUBLE | Y | Indicates whether an error occurred while retrieving result set. |
ERROR_MSG1 | VARCHAR(255) | Y | Text of error message. |
ERROR_MSG2 | VARCHAR(255) | Y | Text of error message. |
ERROR_MSG3 | VARCHAR(255) | Y | Text of error message. |
FINISH_DT_TM | DATETIME | Y | Date/time when the result set finished running. |
HASH_KEY | DOUBLE | Y | Hash value which represents the facts, dimensions and filtering done in this saved view. |
NUMBER_COLS | DOUBLE | Y | Number of facts and dimensions in this result set. |
NUMBER_ROWS | DOUBLE | Y | Number of rows retuned in this result set. |
OMF_PV_ITEM_ID | DOUBLE | N | Saved view id which this result set is for. |
START_DT_TM | DATETIME | Y | Date/time when the result set was started being retrieved. |
TOTAL_IND | DOUBLE | Y | Not currently used. |
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. |
USER_ID | DOUBLE | N | Users person_id which owns the saved view being run. |
OMF_PV_COL_SEC
Column Section | Top of Page |
Table-level Detail
Description: | Lists which facts and dimensions a user is not allow to access in a subject area |
Definition: | Lists which facts and dimensions a user is not allow to access in a subject area. |
Table Type: | REFERENCE |
Column Detail - OMF_PV_COL_SEC
Column Name | Type | Null? | Definition |
---|---|---|---|
GRID_CD | DOUBLE | N | Subject area. The code set will vary depending on the PowerVison domain. |
INDICATOR_CD | DOUBLE | N | View option which is being denied access to. The code set will vary depending on the PowerVison 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. |
USER_ID | DOUBLE | N | Users person_id. |
OMF_PV_ITEMS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OMF PV ITEMS |
Definition: | PowerVision items such as Saved Views, Fitlers, and Templates. |
Table Type: | REFERENCE |
Column Detail - OMF_PV_ITEMS
Column Name | Type | Null? | Definition |
---|---|---|---|
FILTER_PROMPT_IND | DOUBLE | N | Determines if we prompt for filterings when running. |
FOLDER_ID | DOUBLE | Y | PowerVision folder that this item is stored in. |
GRID_CD | DOUBLE | N | Subject area this item belongs to. Other codesets can be used besides 14265 depending on the team defining the value. |
ITEM_TYPE_FLAG | DOUBLE | N | PowerVision item type such as Saved View, Template and Filter. |
OMF_PV_ITEM_ID | DOUBLE | N | Unique identifier of the PV item. |
PROGRAM_GROUP_NBR | DOUBLE | Y | If the item is a Discern Explorer (CCL) program, this field contains the program group associated with the CCL program. This should match the object group shown in CCLProt. |
PROGRAM_NAME_TXT | VARCHAR(30) | Y | If the item is a Discern Explorer (CCL) program, this field contains the name of the Discern Explorer program associated with the item. |
PROP_PROMPT_IND | DOUBLE | N | Determines whether we prompt for properties when running the Saved View. |
PRSNL_GROUP_ID | DOUBLE | N | If the item is associated with a 'User Group' rather than a user, this field contains the internal surrogate value which identifies the group. |
PV_ITEM_NAME | VARCHAR(255) | N | Name of PowerVision item. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
USER_ID | DOUBLE | N | Person who owns this PowerVision item. |
VIEW_CD | DOUBLE | N | View which this item belongs to. Other codesets can be used besides 14265 depending on the team defining the value. |
VIEW_TYPE | DOUBLE | N | Type of viewer which this was saved for. List of possible viewers is stored in omf_pv_viewers. |
Relationship Detail - OMF_PV_ITEMS
Child Column in OMF_PV_ITEMS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRSNL_GROUP_ID | PRSNL_GROUP | PRSNL_GROUP_ID |
OMF_PV_SCHED
Column Section | Top of Page |
Table-level Detail
Description: | OMF PV SCHED |
Definition: | Schedule information for PowerVision views. |
Table Type: | REFERENCE |
Column Detail - OMF_PV_SCHED
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
APPLICATION_NUMBER | DOUBLE | Y | Application this schedule is for - e.g. 950001 for PowerVision. |
DAY_OF_MONTH | DOUBLE | Y | Day of month. Either 1->31 for day of month; or 0 = first; 1 = second; 2 = third; 3 = fourth; 4 = last e.g. Sunday of the month. |
DAY_OF_WEEK | VARCHAR(8) | Y | String holding the days of week to run. 1=Sun through 7=Sat. 145 would indicator tor run this every Sunday, Wednesday, and Thursday. |
DEL_AFTER_DAYS | DOUBLE | Y | How many days after creating the result set should this data be kept. |
END_RUN_DT_NBR | DOUBLE | Y | Julian date when run finished. |
END_RUN_DT_TM | DATETIME | Y | Date when run finished. |
EVERY | DOUBLE | Y | How often is this to be run - e.g. every 2 days, 1 week, 3 months. |
LAST_RUN_DT_NBR | DOUBLE | Y | Julian date when this was last run. |
LAST_RUN_DT_TM | DATETIME | Y | Date when this was last run. |
LAST_RUN_MIN_NBR | DOUBLE | Y | Minute of day when this was last run. |
NEXT_RUN_DT_NBR | DOUBLE | Y | Julian date when this should be next run. |
NEXT_RUN_DT_TM | DATETIME | Y | Date when this should be next run. |
NEXT_RUN_MIN_NBR | DOUBLE | Y | Minute between 1 and 1440 when this should be next run. |
OMF_PV_ITEM_ID | DOUBLE | N | Saved view. |
RECURRENCE_FLAG | DOUBLE | Y | Daily, weekly, monthly indicator. |
TIME_OF_DAY | VARCHAR(10) | Y | String in HHMM format when this should be run. |
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. |
USER_ID | DOUBLE | N | Users person_id whose saved view is being run. |