GPNZ_ADV_TYPE(SQL Table) |
Index Back |
---|---|
Absence Advance Payment OptionThis defines options used in determining the periods to be calculated in advance for an absence event. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPNZ_ADVANCE_TYPE | Character(10) | VARCHAR2(10) NOT NULL | This code identifies options used in calculating advance payments for absence events. |
2 | GPNZ_ADV_DESCR | Character(50) | VARCHAR2(50) NOT NULL | This is a description of the Advance Type. |
3 | GPNZ_ADV_SHORTDESC | Character(10) | VARCHAR2(10) NOT NULL | This is a description of the Advance Type. |
4 | GPNZ_ADV_CAL_OPT | Character(2) | VARCHAR2(2) NOT NULL |
The option chosen here determines how the system will chhoose the Calendar Group in which an Advance should be paid.
10=Period Prior to Absence 20=Period Absence Begins 30=Payment Prior to Absence Begin 40=Payment After Absence Begin Default Value: 30 |
5 | GPNZ_CAL_ORIDE_SW | Character(1) | VARCHAR2(1) NOT NULL |
This option determines whether the operator is able to select the Calendar Group in which advance payments are to be calculated for an Absence Event.
Y/N Table Edit Default Value: N |