PGM_RELEASE

(SQL Table)
 Index Back

Release Record

Stores the Release Data's , which are define/managed through Release Management page.

  • Related Language Record: PGM_RELEASE_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
    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

    Prompt Table: PGM_RELEASE_AC

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description
    10 RELEASE_USER1 Character(15) VARCHAR2(15) NOT NULL Release User1 - Additional Field
    11 RELEASE_USER2 Character(15) VARCHAR2(15) NOT NULL Release User2 - Additional Field
    12 RELEASE_USER3 Character(15) VARCHAR2(15) NOT NULL Release User3 - Additional Field
    13 RELEASE_USER4 Character(15) VARCHAR2(15) NOT NULL Release User4 - Additional Field
    14 RELEASE_USER5 Character(15) VARCHAR2(15) NOT NULL Release User5 - Additional Field
    15 RELEASE_USER6 Character(15) VARCHAR2(15) NOT NULL Release User6 - Additional Field
    16 PC_USER_CURRENCY Character(3) VARCHAR2(3) NOT NULL User Currency

    Prompt Table: CURRENCY_CD_TBL

    17 RELEASE_USERAMT1 Number(27,3) DECIMAL(26,3) NOT NULL Release User Amount1 - Additional Field
    18 RELEASE_USERAMT2 Number(27,3) DECIMAL(26,3) NOT NULL Release User Amount2 - Additional Field
    19 RELEASE_USER_DT1 Date(10) DATE Release User date1 - Additional Field
    20 RELEASE_USER_DT2 Date(10) DATE Release User date2 - Additional Field
    21 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    22 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    23 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    24 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.