Set of views containing context-sensitive package user data information.
When the Reporting Meta Layer is synchronized, a view is created for every set of context-sensitive package user data fields defined in the system. The name of each view is defined in the User Data window in the Meta Layer View field. It defaults to a prefix MPKG_UD_ and a suffix that defaults to the first 20 alphanumeric characters of the corresponding context value.
For example, if there are two sets of context-sensitive package user data defined in PPM, with a Workflow context field and context values FIN dev -> prod and MFG dev -> prod, then two corresponding Meta Layer views would exist: MPKG_UD_FIN_DEV_PROD and MPKG_UD_MFG_DEV_PROD.
If no context-sensitive package user data has been defined in the User Data window, then no views of this type will exist in the Meta Layer. Global package user data fields are incorporated directly into the package view MPKG_PACKAGES and therefore do not require a separate unique view.
If context-sensitive package user data has been defined, only new packages with this user data and existing packages that have been edited will appear in the views.
Continuing the example, there are two package user data fields defined for the FIN dev -> prod workflow context, with tokens named VERSION_CTL_PROJECT and VERSION_CTL_ENV.
In the corresponding view MPKG_UD_FIN_DEV_PROD, two columns named the same as the token names would be present:
Name Null? Type ------------------------------- -------- ---- PACKAGE_NUMBER NOT NULL VARCHAR2(30) PACKAGE_TYPE NOT NULL VARCHAR2(80) CONTEXT_FIELD VARCHAR2(80) CONTEXT_VALUE VARCHAR2(200) CONTEXT_CODE VARCHAR2(200) VERSION_CTL_PROJECT VARCHAR2(200) VERSION_CTL_ENV VARCHAR2(200) CREATION_DATE NOT NULL DATE CREATED_BY_USERNAME NOT NULL VARCHAR2(30) LAST_UPDATE_DATE NOT NULL DATE PACKAGE_ID NOT NULL NUMBER
A report is needed that shows the number of open packages that are being processed through the FIN dev -> prod workflow, broken down by VERSION_CTL_PROJECT and priority:
SELECT f.version_ctl_project PROJECT, p.priority PRIORITY, COUNT(*) NUM_OPEN_PKGS FROM mpkg_ud_fin_dev_prod f, mpkg_packages p WHERE p.close_date IS NULL AND p.cancel_date IS NULL AND p.submission_date IS NOT NULL AND p.package_id = f.package_id GROUP BY f.version_ctl_project, p.priority ORDER BY 1, 2;
PROJECT PRIORITY NUM_OPEN_PKGS --------------------------------- --------------- ------------- Rel 3.0 High 2 Normal 12 Low 32
Rel 2.1.2 Critical 1 High 1 Normal 8 Low 3
Rel 2.1 Low 23 ...