GPDE_TX_XMLC_VW(SQL View) |
Index Back |
|---|---|
Germany XML Tax ResultsGlobal Payroll Germany XML Results table for the Tax Statement ELSTER process |
| SELECT GPDE_ELSTER_TKT ,GPDE_AL_ELSTER_TYP ,LAST_UPDATE_DTTM ,RUNCONTROLID ,OPRID ,PAY_ENTITY ,GP_PAYGROUP ,SETID ,DEPTID ,LOCATION ,GPDE_XML_STATUS ,GPDE_AL_DT_POSTED ,GPDE_RC_YR_CLOSE ,PROCESS_INSTANCE ,GPDE_RC_MONTH_YEAR ,GPDE_AL_CPAY_ENDDT ,GPDE_RC_PAY_YEAR , GPDE_AL_DETAIL FROM PS_GPDE_TX_XMLRSLT WHERE GPDE_XML_STATUS = '40' AND GPDE_RC_YR_CLOSE = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPDE_ELSTER_TKT |
Character(20) | VARCHAR2(20) NOT NULL | Ticket number returned from ELSTER messaging process representing a particular group of tax statement data sent to ELSTER. |
| 2 | GPDE_AL_ELSTER_TYP | Character(4) | VARCHAR2(4) NOT NULL |
Various eGovernment processes
LSTA=Tax Registration LSTB=Tax Statement NONE=None STAT=Payroll Statistics Default Value: NONE |
| 3 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 4 | RUNCONTROLID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 7 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 8 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 10 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 11 | GPDE_XML_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Global Payroll Germany - Return Status of XML File
00=Awaiting Ticket 01=Initial File Sent 05=Checking Status 20=Data Error 40=File Successful 99=Duplicate Ticket -- Outdated |
| 12 | GPDE_AL_DT_POSTED | Date(10) | DATE | Begin Date |
| 13 | GPDE_RC_YR_CLOSE | Character(1) | VARCHAR2(1) NOT NULL |
Tax Year Close
Y/N Table Edit Default Value: N |
| 14 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 15 | GPDE_RC_MONTH_YEAR | Character(1) | VARCHAR2(1) NOT NULL |
Month Year Quarter Salary Structure Report
M=For Month Q=For Quarter S=Salary Structure Report Y=For Year |
| 16 | GPDE_AL_CPAY_ENDDT | Date(10) | DATE | Current Pay End Date |
| 17 | GPDE_RC_PAY_YEAR | Number(4,0) | SMALLINT NOT NULL | For Year |
| 18 | GPDE_AL_DETAIL | Character(1) | VARCHAR2(1) NOT NULL |
Detailed Output Selection
Y/N Table Edit |