| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Field used for element packaging
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 4 |
BGN_DT |
Date(10) |
DATE |
Begin Date
|
| 5 |
PIN_TAKE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Absence Take
|
| 6 |
END_DT |
Date(10) |
DATE |
end date
|
| 7 |
GPNZ_ADVANCE_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
This code identifies options used in calculating advance payments for absence events.
|
| 8 |
GPNZ_ADV_BGN_DT |
Date(10) |
DATE |
The Begin Date used when calculating an Advance for an Absence. This is normally the same as the Begin Date of the Absence that was paid in advance, but may be different if the Absence dates were changed after the advance was paid.
|
| 9 |
GPNZ_ADV_END_DT |
Date(10) |
DATE |
The End Date used when calculating an Advance for an Absence. This is normally the same as the End Date of the Absence that was paid in advance, but may be different if the Absence dates were changed after the advance was paid.
|
| 10 |
GPNZ_ADV_CAL_RUNID |
Character(18) |
VARCHAR2(18) NOT NULL |
This is the Calendar Group ID in which Advance Payments are to be included for an Absence Event.
|
| 11 |
GPNZ_ADV_PYMTDT |
Date(10) |
DATE |
This is the date on which the Advance Payment is to be made. It is used to override the normal Payment Date for the Calendars/Periods that are to be paid in advance.
|
| 12 |
GPNZ_ADV_PRD |
Character(10) |
VARCHAR2(10) NOT NULL |
This identifies the Calendar Period to which the Advance Payment is to be attributed.
|
| 13 |
GPNZ_RET_CAL_RUNID |
Character(18) |
VARCHAR2(18) NOT NULL |
This is the Calendar Group ID in which payments are to be made on return from an absence that is paid in advance.
|
| 14 |
GPNZ_RET_PYMTDT |
Date(10) |
DATE |
This is the date on which the 'On Return' Payments are to be made for an Absence that is paid in advance. It is used to override the normal Payment Date for the Calendars/Periods that are to be paid on return.
|
| 15 |
GPNZ_RET_PRD |
Character(10) |
VARCHAR2(10) NOT NULL |
This identifies the Calendar Period to which 'On Return' Payments are to be attributed for an Absence paid in advance.
|
| 16 |
GPNZ_START_SEG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether a Segmentation Trigger is required at the end of an Absence Event or not. A trigger is required if only the absence part of the last period is to be calculated in advance.
|
| 17 |
GPNZ_END_SEG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies whether a Segmentation Trigger is required at the start of an Absence Event or not. A trigger is required if only the absence part of the first period is to be calculated in advance.
|
| 18 |
PYE_RUN_NUM |
Number(8,0) |
INTEGER NOT NULL |
Number to link to Payee Run Table
|