GPIN_ECR_AET (SQL Table)	Index Back
AET Record for ECR File This is the run control record for generating the ECR File

GPIN_ECR_AET

(SQL Table)

AET Record for ECR File

This is the run control record for generating the ECR File

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
Prompt Table: GPIN_PSLPCAL_VW

5 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID
Prompt Table: GP_CAL_PRD

6 PRD_BGN_DT Date(10) DATE NOT NULL Period Begin Date

7 PRD_END_DT Date(10) DATE NOT NULL Pay Period End Date

8 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
Prompt Table: ESTAB_TBL

9 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.
Prompt Table: GPIN_ESTABCD_VW

10 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

11 GPIN_ECR_FILE_NAME Character(100) VARCHAR2(100) NOT NULL This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Refund of Advances.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GPIN_PSLPCAL_VW
5	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID Prompt Table: GP_CAL_PRD
6	PRD_BGN_DT	Date(10)	DATE NOT NULL	Period Begin Date
7	PRD_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date
8	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: ESTAB_TBL
9	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. Prompt Table: GPIN_ESTABCD_VW
10	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
11	GPIN_ECR_FILE_NAME	Character(100)	VARCHAR2(100) NOT NULL	This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Refund of Advances.