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.