PI_DEFFL_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PI_FILE_ID	Character(6)	VARCHAR2(6) NOT NULL	Payroll Interface File ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	PI_SYSTEM_ID	Character(4)	VARCHAR2(4) NOT NULL	Payroll Interface System ID Prompt Table: PI_SYSTEM_TBL
7	PI_PROCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Process Type B=Export/Import E=Export I=Import Default Value: E
8	PI_FILE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payroll Interface File Type C=Comma Separated (CSV) L=Logical O=Other Delimited P=Physical T=Tab Delimited
9	PI_RECORD_LEN	Number(4,0)	SMALLINT NOT NULL	PI Record Length
10	EXT_FLDID_IND	Character(1)	VARCHAR2(1) NOT NULL	External Field ID Indicator Y/N Table Edit Default Value: N
11	CONVERT_CASE	Character(1)	VARCHAR2(1) NOT NULL	Convert Case Y/N Table Edit
12	MAX_FLDS_PER_REC	Number(3,0)	SMALLINT NOT NULL	Max Fields Per Output Rec
13	INCL_HEADER_IND	Character(1)	VARCHAR2(1) NOT NULL	Include Header Y/N Table Edit
14	DATA_DELIMITER	Character(1)	VARCHAR2(1) NOT NULL	Data Delimiter Default Value: PI_SYSTEM_TBL.DATA_DELIMITER