GPNL_HOLID_DEFN(SQL Table) |
Index Back |
|---|---|
Holiday Allowance DefinitionHoliday Allowance Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | GPNL_PIN_AC1_NUM | Number(8,0) | INTEGER NOT NULL |
This field will be used to store the pin number of accumulator 1. This accumulator is used for on-line and hard-copy payslips.
Prompt Table: %GP_EDIT_FLD2 |
| 5 | GPNL_PERCENT | Signed Number(8,3) | DECIMAL(6,3) NOT NULL | Percentage |
| 6 | GPNL_SEPARATED_PAY | Character(1) | VARCHAR2(1) NOT NULL |
Separate Pay Run
Y/N Table Edit Default Value: N |
| 7 | GPNL_INCL_TERMINTN | Character(1) | VARCHAR2(1) NOT NULL |
Payment Include in Termination
Y/N Table Edit Default Value: N |
| 8 | GPNL_CALC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Method
A=Real Accumulated Earnings B=Current Earnings Default Value: A |