| # |
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 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 4 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 5 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Default Value: JOB.ESTABID
Prompt Table:
ESTAB_TBL
|
| 6 |
BGN_DT |
Date(10) |
DATE |
Begin Date
|
| 7 |
END_DT |
Date(10) |
DATE |
end date
|
| 8 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 9 |
GPIN_REG_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
This Field is created for Establishment ID for Global Payroll Country Estension India. This field is used to store the Registration number.
|
| 10 |
YEARCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Calendar Year
|
| 11 |
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
|
| 12 |
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.
|
| 13 |
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.
|
| 14 |
GPIN_EPF_EE_DUE |
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.
|
| 15 |
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.
|
| 16 |
GPIN_EPS_DUE |
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.
|
| 17 |
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.
|
| 18 |
GPIN_EPF_ER_DUE |
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.
|
| 19 |
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.
|
| 20 |
GPIN_ECR_LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Father's / Husband's Name
|
| 21 |
GPIN_ECR_RELTNSHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
Relationship
F=Father
S=Husband
|
| 22 |
EMPLID_NEW |
Character(11) |
VARCHAR2(11) NOT NULL |
ID
|
| 23 |
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.
|
| 24 |
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.
|
| 25 |
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.
|
| 26 |
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.
|
| 27 |
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.
|
| 28 |
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.
|
| 29 |
GPIN_EPF_JOIN_DT |
Date(10) |
DATE |
This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Provident Fund Registration Date.
|
| 30 |
GPIN_EPF_EXIT_DT |
Date(10) |
DATE |
This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Provident Fund Exit Date.
|
| 31 |
GPIN_EPS_JOIN_DT |
Date(10) |
DATE |
This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Pension Join Date.
|
| 32 |
GPIN_EPS_EXIT_DT |
Date(10) |
DATE |
This Field is created for Provident Fund for Global Payroll Country Extension India. This field stores the Pension Exit Date.
|
| 33 |
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
|
| 34 |
AUDIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The OPRID of the user who made the changes audited on an audit record.
|
| 35 |
DTTM_MODIFIED |
DateTime(26) |
TIMESTAMP |
Datetime modified
|
| 36 |
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
|