GPIN_YE_F12BA (SQL Table)	Index Back
Form 12BA - India This record is used to setup the any amount paid by the employee and the taxable perquisite value for the Form 12BA

GPIN_YE_F12BA

(SQL Table)

Form 12BA - India

This record is used to setup the any amount paid by the employee and the taxable perquisite value for the Form 12BA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID
Prompt Table: GPIN_YE_F12_HDR

3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: %GP_EDIT_FLD7

4 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element
Prompt Table: GP_ENT_GRPIN_VW

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

6 GPIN_F12BA_AMTPD Signed Number(20,3) DECIMAL(18,3) NOT NULL This field is used to hold the amount paid by the employee for the fiscal year.

7 GPIN_F12BA_TAXPERQ Signed Number(20,3) DECIMAL(18,3) NOT NULL This field holds the taxable perquisite value for the Form 12BA.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID Prompt Table: GPIN_YE_F12_HDR
3	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: %GP_EDIT_FLD7
4	ENTRY_TYPE_ELEM	Character(3)	VARCHAR2(3) NOT NULL	entry type element Prompt Table: GP_ENT_GRPIN_VW
5	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
6	GPIN_F12BA_AMTPD	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	This field is used to hold the amount paid by the employee for the fiscal year.
7	GPIN_F12BA_TAXPERQ	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	This field holds the taxable perquisite value for the Form 12BA.