GPS_RPT_MGMT_VW

(SQL View)
 Index Back

GPS Report management view

GPS Report management view served for Workforce Statistics and Child Allowance

SELECT DISTINCT COMPANY ,GPS_RPT_TYPE , YEAR , CASE WHEN GPS_RPT_TYPE = 'CAR' THEN ' ' ELSE GB_GROUP_ID END AS GB_GROUP_ID , CASE WHEN GPS_RPT_TYPE = 'CAR' THEN ' ' ELSE GPS_RPT_STATUS END AS GPS_RPT_STATUS , CASE WHEN GPS_RPT_TYPE = 'CAR' THEN ' ' ELSE GPS_RPT_ERR_FLG END AS GPS_RPT_ERR_FLG FROM PS_GPS_RPT_MGMT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 GPS_RPT_TYPE Character(3) VARCHAR2(3) NOT NULL GPS Report Type
CAR=Child Allowance
WFS=Workforce Statistic
3 YEAR Character(4) VARCHAR2(4) NOT NULL Character field to represent a year
4 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
5 GPS_RPT_STATUS Character(1) VARCHAR2(1) NOT NULL GPS Workforce Statistic mapping execlude flag Indicate whether the data with matching Exclude will be exclude for all of the mappings
A=XML & ASCII
E=Error
I=Interface
X=XML
6 GPS_RPT_ERR_FLG Character(1) VARCHAR2(1) NOT NULL GPS Report Error flag
N=N
Y=Y