GP_PKG_UPG_VW

(SQL View)
 Index Back

Prompt View for Pkg Includes

This is the prompt view for the field GP_PKG_UPG_ACTION. It shows the upgrade actions a user can use on the Packaging Criteria1 and Packaging Criteria2 pages. A view was needed to exclude a value of 'I' from being shown to the user. 'I' implies Info only - the element does not get upgraded but exists in the package to verify that it exists on the target database. When Include option of Focus Elements Only is chosen, all the member elements are inserted with upgrade action of I-Info.

SELECT %Substring(FIELDVALUE, 1, 1) , EFFDT , EFF_STATUS , XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME='GP_PKG_UPG_ACTION' AND FIELDVALUE IN ('D','U')

  • Related Language Record: GP_PKG_UPG_LW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PKG_UPG_ACTION Character(1) VARCHAR2(1) NOT NULL Field used for element packaging
    D=Delete
    I=Informational Only
    U=Upgrade
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name