GPIN_NRP_F12_VW (SQL View)	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_NRP_F12_VW

(SQL View)

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

SELECT A.EMPLID ,A.PIN_NUM+50000000 ,A.GPIN_TAX_YEAR ,A.ENTRY_TYPE_ELEM ,A.AMOUNT ,A.GPIN_F12BA_AMTPD ,A.GPIN_F12BA_TAXPERQ FROM PS_GPIN_YE_F12BA A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 GPIN_TAX_YEAR Number(4,0) SMALLINT NOT NULL This field is used to store the Tax Year.

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	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: %GP_EDIT_FLD7
3	GPIN_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	This field is used to store the Tax Year.
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.