EMPLIDCAL_RUN_IDPYMT_DTGPMX_SS_XML_VW(SQL View) |
Index Back |
|---|---|
Search Record SS XML PayslipSearch Record Self Service XML Payslip |
| SELECT A.EMPLID , A.CAL_RUN_ID , B.PYMT_DT , A.GPMX_XML_PAYSLIP FROM PS_GPMX_DIG_TBL A , PS_GP_CALENDAR B WHERE A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | PYMT_DT |
Date(10) | DATE | Payment Date |
| 4 | GPMX_XML_PAYSLIP | Long Character(32700) | CLOB | XML Payslip |