GPIN_F16BIP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPIN_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	This field is used to store the Tax Year.
3	GPIN_F16RPT_KEY	Number(20,0)	DECIMAL(20) NOT NULL	Report Key
4	RAWXML	Long Character	CLOB	Raw XML
5	URL_ID	Character(30)	VARCHAR2(30) NOT NULL	URL Identifier (see PSURLDEFN).
6	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
7	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
8	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
9	GPIN_REPORT_ID	Character(8)	VARCHAR2(8) NOT NULL	Report Identifier
10	BGN_DT	Date(10)	DATE	Begin Date
11	END_DT	Date(10)	DATE	end date
12	TO_DATE	Date(10)	DATE	Latest Date to be sent to PYR
13	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
14	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
15	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
16	GPIN_FLD_NAME	Character(15)	VARCHAR2(15) NOT NULL	Payee Report Field Name
17	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
18	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
19	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
20	GPIN_FINANCIAL_YR	Character(15)	VARCHAR2(15) NOT NULL	Financial Year
21	GP_GENRPT_SORT_OPT	Character(2)	VARCHAR2(2) NOT NULL	Sort option for generic reports 10=Employee ID, Employee Rcd Nbr 20=Name, Employee Rcd Nbr
22	CREATION_DT	Date(10)	DATE	Creation Date
23	GPIN_ASSMNT_YR	Character(15)	VARCHAR2(15) NOT NULL	Assessment Year
24	GPIN_IT_TAN_NBR	Character(30)	VARCHAR2(30) NOT NULL	This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Tax Deduction Account Number.
25	GPIN_IT_PAN_NBR	Character(30)	VARCHAR2(30) NOT NULL	This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Permanent Account Number.
26	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number