PGM_RELESE_SRCH

(SQL View)
 Index Back

Release View

Release Prompt View - Fetches all Active,Pending Releases from PGM_RELEASE table.

SELECT BUSINESS_UNIT ,RELEASE ,RELEASE_MANAGER ,RELEASE_STATUS_IND ,RELEASE_DATE_ORIG ,RELEASE_DATE ,RELEASE_TYP ,DESCR FROM PS_PGM_RELEASE WHERE RELEASE_STATUS_IND IN ('A','P')

  • Related Language Record: PGM_REL_ALL_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

    2 RELEASE Character(15) VARCHAR2(15) NOT NULL Release - Carries Release Information driven by the BUSINESS_UNIT

    Prompt Table: PGM_RELEASE_ALL

    3 RELEASE_MANAGER Character(11) VARCHAR2(11) NOT NULL Release Manager - New Owner Id , who manages/tracks the whole Release Management System

    Prompt Table: PERSONAL_DATA

    4 RELEASE_STATUS_IND Character(1) VARCHAR2(1) NOT NULL Release Status having a Active , Inactive Status
    A=Active
    I=Inactive
    P=Pending

    Default Value: A

    5 RELEASE_DATE_ORIG Date(10) DATE NOT NULL Original Release Date of a particular Release created under a Business unit
    6 RELEASE_DATE Date(10) DATE NOT NULL Release Date
    7 RELEASE_TYP Character(10) VARCHAR2(10) NOT NULL Release Type driven by the SETID
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description