LOCATION_GPS

(SQL Table)
Index Back

Location Table GPS

Location Table German Public Sector attributes. One to one child of LOCATION_TBL.

  • Parent record: LOCATION_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: SET_VLD_HR_03

    2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 GPS_WFS_MUNICIPLTY Character(8) VARCHAR2(8) NOT NULL Municipality (EF 14) for German Public Sector Workforce Statistics.

    Prompt Table: GPS_MUNICIP_TBL