PI_EXTIO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PI_RUN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payroll Interface Run Type E=Export I=Import
2	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID
3	PI_RUN_OPT	Character(1)	VARCHAR2(1) NOT NULL	PI Run Option N=New P=Reprocess R=Restart
4	PI_RUN_NUM	Number(4,0)	SMALLINT NOT NULL	Payroll Interface Run Number
5	FILE_HANDLE	Character(2)	VARCHAR2(2) NOT NULL	File Handle
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	FILE_SEQ_NO	Number(9,0)	DECIMAL(9) NOT NULL	Sequencing field used when reading from or writing to the external file used for Payroll Interface.
8	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
9	CHARSET	Character(40)	VARCHAR2(40) NOT NULL	Character Set
10	RECDATA_SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Used for allowing the 'break-up' of the external file record for intermediate storage in the PI_EXTIO table.
11	REC_DATA_PARTIAL	Character(252)	VARCHAR2(252) NOT NULL	Hold Record Data for external file processing.
12	PI_RECORD_LEN	Number(4,0)	SMALLINT NOT NULL	PI Record Length