FA_PAY_PROGRAMEFFDTFA_TYPECHR=Christmas
CNY=Chinese New Year
DEP=Deepavali
HAR=Hari Raya
N=Value Not Applicable
D=Days
M=Months
GPSG_NRP_FA1_VW(SQL View) |
Index Back |
|---|---|
Festive Advance Pay ProgramView to be used for Non Rules packager for FA pay program. |
| SELECT FA_PAY_PROGRAM ,EFFDT ,FA_TYPE ,FA_CALC_RULE ,PLAN_TYPE ,DEDCD ,ERNCD ,PROBATION_PERIOD ,FA_PERIOD_TYPE ,PIN_ERN_NUM + 50000000 ,PIN_DED_NUM + 50000000 FROM PS_FA_PAY_PROGRAM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FA_PAY_PROGRAM |
Character(3) | VARCHAR2(3) NOT NULL | Festive Advance Pay Program that the Employee is enrolled in. |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | FA_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
This field will define the Festive Advance Holiday Type.
CHR=Christmas CNY=Chinese New Year DEP=Deepavali HAR=Hari Raya N=Value Not Applicable |
| 4 | FA_CALC_RULE | Character(3) | VARCHAR2(3) NOT NULL | Festive Advance Calculation Rule ID |
| 5 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 6 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL | Deduction Code |
| 7 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 8 | PROBATION_PERIOD | Number(3,0) | SMALLINT NOT NULL | Probation Period |
| 9 | FA_PERIOD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Thid field indicates the type of interval for the Probation Period.
D=Days M=Months |
| 10 | PIN_ERN_NUM | Number(8,0) | INTEGER NOT NULL | Pin Number Earning |
| 11 | PIN_DED_NUM | Number(8,0) | INTEGER NOT NULL | Pin Number |