GPS_POSTTYP_DEF

(SQL Table)
 Index Back

Post Type Definition and Mappi

Post Type definition and Mapping Table

  • Parent Record Of GPS_POSTTYP_TBL

    • # 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: SETID_TBL

    2 GPS_BDG_SYSTEM Character(1) VARCHAR2(1) NOT NULL Budgeting System
    D=Doppik
    K=Kameralistik
    O=Other
    3 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)