GPS_POSTPLNROWL

(SQL Table)
 Index Back

Post Plan Row

Post Plan Row

  • Related Language Record for GPS_POSTPLN_ROW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_02

    2 YEAR Character(4) VARCHAR2(4) NOT NULL Character field to represent a year
    3 GPS_POST_PLN_TYPE Character(1) VARCHAR2(1) NOT NULL Post Plan TYpe
    0=Base Plan
    1=1. Amendment Plan
    2=2. Amendment Plan
    3=3. Amendment Plan
    4=4. Amendment Plan
    4 GPS_ROWID Character(45) VARCHAR2(45) NOT NULL RowID, a condensed version of the key fields of a budgeting system
    5 GPS_GRADE Character(8) VARCHAR2(8) NOT NULL Salary Grade.

    Prompt Table: %EDITTABLE5

    6 GPS_RANK Character(15) VARCHAR2(15) NOT NULL Rank for GPS

    Prompt Table: %EDITTABLE11

    7 GPS_POST_TYPE Character(3) VARCHAR2(3) NOT NULL Post Type
    AND=Other (Civil Service)
    ANE=Other (Employee)
    ANG=Public Sector Employee
    ANW=Civil Servant on Recall
    AZU=Apprentice
    BEA=Civil Servant
    ERE=Replacement Post (Employee)
    ERS=Replacement Post (Civil Serv.)
    LEB=Empty Post (Civil Service)
    LEE=Empty Post (Employee)
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 GPS_DESCR1 Character(50) VARCHAR2(50) NOT NULL Description 1
    10 GPS_DESCR2 Character(50) VARCHAR2(50) NOT NULL Description 2