GP_PKG_IDFA_PAY_PROGRAMEFFDTFA_TYPECHR=Christmas
CNY=Chinese New Year
DEP=Deepavali
HAR=Hari Raya
N=Value Not Applicable
D=Days
M=Months
GPSG_NRP_FA1_AD(SQL Table) |
Index Back |
|---|---|
Festive Advance Pay ProgramFestive Advance Pay Program table, stores the Calculation Rules information. |
| # | 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 | FA_PAY_PROGRAM |
Character(3) | VARCHAR2(3) NOT NULL | Festive Advance Pay Program that the Employee is enrolled in. |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | 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 |
| 5 | FA_CALC_RULE | Character(3) | VARCHAR2(3) NOT NULL | Festive Advance Calculation Rule ID |
| 6 | 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. |
| 7 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL | Deduction Code |
| 8 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 9 | PROBATION_PERIOD | Number(3,0) | SMALLINT NOT NULL | Probation Period |
| 10 | FA_PERIOD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Thid field indicates the type of interval for the Probation Period.
D=Days M=Months |
| 11 | PIN_ERN_NUM | Number(8,0) | INTEGER NOT NULL | Pin Number Earning |
| 12 | PIN_DED_NUM | Number(8,0) | INTEGER NOT NULL | Pin Number |