EMPLIDEMPL_RCDGPGB_TAX_BGN_YRPAY_ENTITYHIRE_DTPRD_END_DTGPGB_FPS1_SB_VW(SQL View) |
Index Back |
|---|---|
EPS Reconciliation TableEPS Reconciliation Table |
| SELECT EMPLID , EMPL_RCD , GPGB_TAX_BGN_YR , PAY_ENTITY , HIRE_DT , PRD_END_DT , GPGB_SMP , GPGB_SPPA , GPGB_SPPB , GPGB_SAP , GPGB_ASPPA , GPGB_ASPPB , GPGB_SHPPA , GPGB_SHPPB FROM PS_GPGB_FPS_SUBMIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | GPGB_TAX_BGN_YR |
Number(4,0) | SMALLINT NOT NULL | Tax Year Begins In This Calendar Year |
| 4 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 5 | HIRE_DT |
Date(10) | DATE | First Start Date |
| 6 | PRD_END_DT |
Date(10) | DATE | Pay Period End Date |
| 7 | GPGB_SMP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SMP |
| 8 | GPGB_SPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SPPA |
| 9 | GPGB_SPPB | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SPPB |
| 10 | GPGB_SAP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | End of Year Submissions - SAP |
| 11 | GPGB_ASPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | ASPPA YTD : Additional Stat Paternity Pay Adoption |
| 12 | GPGB_ASPPB | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | ASPPB YTD : Additional Stat Paternity Pay Birth |
| 13 | GPGB_SHPPA | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Shared Parental Adoption |
| 14 | GPGB_SHPPB | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | SHared Parental Birth |