COMPANYPrompt Table: COMPANY_TBL
GPS_RPT_TYPECAR=Child Allowance
WFS=Workforce Statistic
YEARMONTHOFYEARGPS_RPT_FILE_NOA=XML & ASCII
E=Error
I=Interface
X=XML
N=N
Y=Y
GPS_CAR_RPT_VW2(SQL View) |
Index Back |
|---|---|
GPS Child Allowance Report VW2German Public Sector Child Allowance Report List View 2 |
| SELECT COMPANY ,GPS_RPT_TYPE , YEAR , MONTHOFYEAR , GPS_RPT_FILE_NO , GB_GROUP_ID , GPS_RPT_STATUS , GPS_RPT_ERR_FLG FROM PS_GPS_RPT_MGMT WHERE GPS_RPT_TYPE = 'CAR' |
| # | 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 | MONTHOFYEAR |
Number(2,0) | SMALLINT NOT NULL | Month of Year |
| 5 | GPS_RPT_FILE_NO |
Number(2,0) | SMALLINT NOT NULL | German Pbulic Sector Report File Number |
| 6 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 7 | 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 |
| 8 | GPS_RPT_ERR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
GPS Report Error flag
N=N Y=Y |