GPIN_PF_ENROLL (SQL Table)	Index Back
Provident Fund Enrollment Captures the Payee Registration Details into the PF Enrollment. This table will store the establishment for PF purposes, the payee registration number, and the contribution

GPIN_PF_ENROLL

(SQL Table)

Provident Fund Enrollment

Captures the Payee Registration Details into the PF Enrollment. This table will store the establishment for PF purposes, the payee registration number, and the contribution

Parent Record Of GPIN_PF_BENEF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: PERSON.ORIG_HIRE_DT

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
Default Value: JOB.ESTABID
Prompt Table: ESTAB_TBL

5 GPIN_REG_NBR Character(22) VARCHAR2(22) NOT NULL This Field is created for Establishment ID for Global Payroll Country Estension India. This field is used to store the Registration number.

6 GPIN_REG_IND Character(1) VARCHAR2(1) NOT NULL This Field is created for Establishment ID for Global Payroll Country Estension India. This field is used as a Registration Indicator to check if the Registration is done.
Y/N Table Edit
Default Value: N

7 VOLUNTARY_PCT Number(7,3) DECIMAL(6,3) NOT NULL Voluntary Contrib Pct

8 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.

9 GPIN_PF_CAPPING Character(1) VARCHAR2(1) NOT NULL Indicates if capping has been applied to PF contributions. The field can have 'Y' or 'N' value.
Y/N Table Edit
Default Value: N

10 GPIN_LEAVE_RSN Character(1) VARCHAR2(1) NOT NULL This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Provident Fund Employee Reason of Leaving. C - Cessation S - Superannuation R - Retirement D - Death in Service P - Permanent Disablement
C=Cessation
D=Death in Service
P=Permanent Disablement
R=Retirement
S=Superannuation

11 GPIN_PF_NBR Character(30) VARCHAR2(30) NOT NULL This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Provident Fund Registration No.

12 GPIN_ECR_RELTNSHIP Character(1) VARCHAR2(1) NOT NULL ECR Relationship
F=Father
S=Husband

13 GPIN_ECR_LAST_NAME Character(30) VARCHAR2(30) NOT NULL ECR Last Name

14 GPIN_EE_PF_UAN Number(12,0) DECIMAL(12) NOT NULL Universal Account Number

15 GPIN_EPS_GOV_SHARE Character(1) VARCHAR2(1) NOT NULL Contribute to Govt. EPS share?
Y/N Table Edit
Default Value: N

16 GPIN_DISABLE_EPS Character(1) VARCHAR2(1) NOT NULL Disable EPS (Employer)?
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: PERSON.ORIG_HIRE_DT
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Default Value: JOB.ESTABID Prompt Table: ESTAB_TBL
5	GPIN_REG_NBR	Character(22)	VARCHAR2(22) NOT NULL	This Field is created for Establishment ID for Global Payroll Country Estension India. This field is used to store the Registration number.
6	GPIN_REG_IND	Character(1)	VARCHAR2(1) NOT NULL	This Field is created for Establishment ID for Global Payroll Country Estension India. This field is used as a Registration Indicator to check if the Registration is done. Y/N Table Edit Default Value: N
7	VOLUNTARY_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Voluntary Contrib Pct
8	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
9	GPIN_PF_CAPPING	Character(1)	VARCHAR2(1) NOT NULL	Indicates if capping has been applied to PF contributions. The field can have 'Y' or 'N' value. Y/N Table Edit Default Value: N
10	GPIN_LEAVE_RSN	Character(1)	VARCHAR2(1) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Provident Fund Employee Reason of Leaving. C - Cessation S - Superannuation R - Retirement D - Death in Service P - Permanent Disablement C=Cessation D=Death in Service P=Permanent Disablement R=Retirement S=Superannuation
11	GPIN_PF_NBR	Character(30)	VARCHAR2(30) NOT NULL	This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Provident Fund Registration No.
12	GPIN_ECR_RELTNSHIP	Character(1)	VARCHAR2(1) NOT NULL	ECR Relationship F=Father S=Husband
13	GPIN_ECR_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	ECR Last Name
14	GPIN_EE_PF_UAN	Number(12,0)	DECIMAL(12) NOT NULL	Universal Account Number
15	GPIN_EPS_GOV_SHARE	Character(1)	VARCHAR2(1) NOT NULL	Contribute to Govt. EPS share? Y/N Table Edit Default Value: N
16	GPIN_DISABLE_EPS	Character(1)	VARCHAR2(1) NOT NULL	Disable EPS (Employer)? Y/N Table Edit Default Value: N