GPS_RPT_PER_YVW

(SQL View)
Index Back

GPS WFS Person YEAR VIEW

GPS WFS Person VIEW GROUP BY YEAR

SELECT DISTINCT YEAR ,COMPANY ,EMPLID ,EMPL_RCD ,GPS_RPT_TYPE FROM PS_GPS_RPT_PERSON p1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 YEAR Character(4) VARCHAR2(4) NOT NULL Character field to represent a year
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 GPS_RPT_TYPE Character(3) VARCHAR2(3) NOT NULL GPS Report Type
CAR=Child Allowance
WFS=Workforce Statistic