EMPLIDEMPL_RCDCAL_RUN_IDPrompt Table: GPGB_CALRUN_VW
N=No
Y=Yes
Default Value: N
GPGB_RTI_FPSADJ(SQL Table) |
Index Back |
|---|---|
RTI FPS AdjustmentRTI FPS Adjustment |
| # | 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 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPGB_CALRUN_VW |
| 4 | LEAVE_DT | Date(10) | DATE | Leave Date |
| 5 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 6 | GPGB_RTI_YTD_ADJ | Character(1) | VARCHAR2(1) NOT NULL |
This field is to check if any terminated employees has any YTD adjustment made in last payroll finalizedi ndicator.It has to be input by user manually.
N=No Y=Yes Default Value: N |