EMPLIDEMPL_RCDPRD_BGN_DTDefault Value: 1
GPGB_RTI_ERNPRD(SQL Table) |
Index Back |
|---|---|
Employee earning periodUsed in FPS RTI for storing earning period numbers for a pay period |
| # | 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 Rcd Nbr |
| 3 | PRD_BGN_DT |
Date(10) | DATE | Period Begin Date |
| 4 | GPGB_EARN_PRD | Number(3,0) | SMALLINT NOT NULL |
Used to store earning period
Default Value: 1 |