GPNL_HOLID_VW(SQL View) |
Index Back |
|---|---|
13th Month DefinitionGPNL Holiday Definition |
| SELECT A.COMPANY , B.COMP_FREQUENCY , A.EFFDT , A.EFF_STATUS , A.GPNL_PIN_AC1_NUM , A.GPNL_PERCENT , A.GPNL_SEPARATED_PAY , A.GPNL_INCL_TERMINTN , A.GPNL_CALC_METHOD , B.GPNL_START_PERIOD , B.GPNL_PERIOD_TO_PAY FROM PS_GPNL_HOLID_DEFN A , PS_GPNL_HOLID_DTL B WHERE A.COMPANY = B.COMPANY AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_GPNL_HOLID_DTL B_ED WHERE B.COMPANY = B_ED.COMPANY AND B.COMP_FREQUENCY = B_ED.COMP_FREQUENCY AND B_ED.EFFDT <= A.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | COMP_FREQUENCY |
Character(5) | VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly Prompt Table: FREQUENCY_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 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.
Prompt Table: GP_ACM_VW |
| 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
Y/N Table Edit Default Value: N |
| 8 | GPNL_INCL_TERMINTN | Character(1) | VARCHAR2(1) NOT NULL |
Payment Include in Termination
Y/N Table Edit Default Value: N |
| 9 | GPNL_CALC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Method
A=Real Accumulated Earnings B=Current Earnings Default Value: A |
| 10 | GPNL_START_PERIOD | Number(3,0) | SMALLINT NOT NULL | Start Period for Accumulator |
| 11 | GPNL_PERIOD_TO_PAY | Number(3,0) | SMALLINT NOT NULL | Period to Pay |