GPIN_ECR_DATA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Default Value: GPIN_ECR_SRCH.CAL_RUN_ID Prompt Table: GPIN_PSLPCAL_VW
2	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.
3	GPIN_EE_PF_UAN	Number(12,0)	DECIMAL(12) NOT NULL	Universal Account Number
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Default Value: JOB.ESTABID Prompt Table: ESTAB_TBL
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	YEARCD	Character(4)	VARCHAR2(4) NOT NULL	Calendar Year
9	MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
10	GPIN_EPF_WAGES	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Provident Fund Wages.
11	GPIN_EPS_WAGES	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Provident Fund Pension Wages.
12	GPIN_EPF_EE_REM	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Provident Fund Employee Contribution Remitted.
13	GPIN_EPS_REM	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the PF Pension Contribution Remmited.
14	GPIN_EPF_ER_REM	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Provident Fund Employer Contribution Remitted.
15	GPIN_EPF_WAGES_ARR	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Provident Fund Wages Arrears.
16	GPIN_EPF_EE_ARR	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Provident Fund Employee Contribution Arrears.
17	GPIN_EPF_ER_ARR	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Provident Fund Employer Contribution Arrears.
18	GPIN_NCP_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Employee NCP Days.
19	GPIN_EPS_ARR	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the PF Pension Contribution Arrears.
20	GPIN_ECR_REFUND	Number(19,6)	DECIMAL(18,6) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Refund of Advances.
21	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
22	DTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
23	GPIN_ECR_GEN_MODE	Character(1)	VARCHAR2(1) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the ECR File Generation Mode. F=Generate and Finalize ECR File G=Generate ECR File L=Load ECR Data
24	GROSS_SALARY	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Sal Package - Gross Salary
25	GPIN_EDLI_WAGE	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the EDLI Wages.
26	GPIN_EDLI_WAGE_ARR	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the EDLI Wages.
27	GPIN_EPS_WAGE_ARR	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Arrear EPS Wages.