FA_PAY_PROGRAM (SQL Table)	Index Back
Festive Advance Pay Program Festive Advance Pay Program table, stores the Calculation Rules information.

FA_PAY_PROGRAM

(SQL Table)

Festive Advance Pay Program

Festive Advance Pay Program table, stores the Calculation Rules information.

Parent record: FA_PAY_HDR

# 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.
Prompt Table: FA_PAY_HDR

2 EFFDT Date(10) DATE NOT NULL Effective Date
Prompt Table: FA_PAY_HDR

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
Default Value: CHR

4 FA_CALC_RULE Character(3) VARCHAR2(3) NOT NULL Festive Advance Calculation Rule ID
Prompt Table: FA_CALC_RL_TBL

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.
Default Value: 00

6 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
Prompt Table: DEDUCTION_TBL

7 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
Prompt Table: EARNINGS_TBL

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
Default Value: M

10 PIN_ERN_NUM Number(8,0) INTEGER NOT NULL Pin Number Earning
Prompt Table: FA_GP_ERN_SRCH

11 PIN_DED_NUM Number(8,0) INTEGER NOT NULL Pin Number
Prompt Table: FA_GP_DED_SRCH

#	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. Prompt Table: FA_PAY_HDR
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Prompt Table: FA_PAY_HDR
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 Default Value: CHR
4	FA_CALC_RULE	Character(3)	VARCHAR2(3) NOT NULL	Festive Advance Calculation Rule ID Prompt Table: FA_CALC_RL_TBL
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. Default Value: 00
6	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code Prompt Table: DEDUCTION_TBL
7	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: EARNINGS_TBL
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 Default Value: M
10	PIN_ERN_NUM	Number(8,0)	INTEGER NOT NULL	Pin Number Earning Prompt Table: FA_GP_ERN_SRCH
11	PIN_DED_NUM	Number(8,0)	INTEGER NOT NULL	Pin Number Prompt Table: FA_GP_DED_SRCH