GP_PKG_IDCOMPANYEFFDTA=Active
I=Inactive
A=Real Accumulated Earnings
B=Current Earnings
GPNL_NRP_HOL_AD(SQL Table) |
Index Back |
|---|---|
Holiday Allowance DefinitionHoliday Allowance Definition |
| # | 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 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | 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. |
| 6 | GPNL_PERCENT | Signed Number(8,3) | DECIMAL(6,3) NOT NULL | Percentage |
| 7 | GPNL_SEPARATED_PAY | Character(1) | VARCHAR2(1) NOT NULL | Separate Pay Run |
| 8 | GPNL_INCL_TERMINTN | Character(1) | VARCHAR2(1) NOT NULL | Payment Include in Termination |
| 9 | GPNL_CALC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Method
A=Real Accumulated Earnings B=Current Earnings |