RECIPIENT_IDGPAU_MEMBER_IDPAY_ENTITYEMPLIDEMPL_RCDDATETIME_STAMPEFFDTDefault Value: %date
GPAU_SUPER_ACTIONGPAU_SUPR_ACTN_DTLGPAU_PIN_DED_NUMGPAU_SUPEC_ACT(SQL Table) |
Index Back |
|---|---|
GPAU - SuperEC Activity tbleA rows is created in this table each time there is a change to a EE or his/her spouse relating to SuperEC. The process that creates the SuperEC message XML file will use this table instead of scanning the HRMS tables to look for changes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECIPIENT_ID |
Character(8) | VARCHAR2(8) NOT NULL | Payment recipient ID |
| 2 | GPAU_MEMBER_ID |
Character(18) | VARCHAR2(18) NOT NULL | The Membership Group ID is required for the file generated by GPAU_RCPFILE. |
| 3 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 6 | DATETIME_STAMP |
DateTime(26) | TIMESTAMP | DateTime Stamp |
| 7 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 8 | GPAU_SUPER_ACTION |
Character(2) | VARCHAR2(2) NOT NULL | Super EC Action. |
| 9 | GPAU_SUPR_ACTN_DTL |
Character(3) | VARCHAR2(3) NOT NULL | SuperEC Action Details. |
| 10 | GPAU_PIN_DED_NUM |
Number(8,0) | INTEGER NOT NULL | GPAUS - Stores the deduction Pin Number for employees with SuperEC deductions. |