GPNL_NRP_HOL_VW(SQL View) |
Index Back |
|---|---|
Holiday Allow Defn (Export VW)Holiday Allow Defn (Export VW) |
| SELECT COMPANY , EFFDT , EFF_STATUS , GPNL_PIN_AC1_NUM + 50000000 , GPNL_PERCENT , GPNL_SEPARATED_PAY , GPNL_INCL_TERMINTN , GPNL_CALC_METHOD FROM PS_GPNL_HOLID_DEFN |
| # | 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 |