COMPANY_TBL_GPS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GPS_WFS_STATE	Character(2)	VARCHAR2(2) NOT NULL	German Public Sector States for Workforce Statistics (including 00 - Federal) 00=Federal 01=Schleswig Holstein 02=Hamburg 03=Niedersachsen 04=Bremen 05=Nordrhein Westfalen 06=Hessen 07=Rheinland Pfalz 08=Baden Wurttemberg 09=Bayern 10=Saarland 11=Berlin 12=Brandenburg 13=Mecklenburg Vorpommern 14=Sachsen 15=Sachsen Anhalt 16=Thuringen
4	GPS_WFS_AREA	Character(2)	VARCHAR2(2) NOT NULL	German Public Sector Area for Workforce Statistics. Beschaftigungsbereich 01=Federal Base Household 02=Federal Special Accounts 03=Federal Railway 05=German Post 06=Federal Agency for Employment 07=Federal Bank 11=State Base Household 12=State Spcl Accts w/o Hospital 13=State Hospitals 21=Municipality Base Household 22=Municipality Special Accounts 23=Municipality Hospitals 24=Special Base Household 25=Special Special Accounts 26=Special Hospitals 30=Federal Company Hlth Insurance 31=Federal Health Insurances 32=Federal Accident Insurances 33=Federal Pension Funds 37=Federal Independent Entities 40=State Cmpny Hlth Ins Private 41=State Health Insurances 42=State Accident Insurances 43=State Pension Funds 47=State Independent Entities 48=Municipality Independ Entities
5	GPS_WFS_NR	Number(7,0)	INTEGER NOT NULL	German Public Sector Company Report Number for Workforce Statistics.
6	GPS_CALL_ER_NBR	Number(8,0)	INTEGER NOT NULL	Employer Number