PI_DEFN_FIELD

#	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	PI_RECORD_SEQ	Number(3,0)	SMALLINT NOT NULL	Payroll Interface Record Seq#
4	PI_FIELD_SEQ	Number(3,0)	SMALLINT NOT NULL	Payroll Interface Field Seq# Default Value: 10
5	PI_FIELD_ID	Character(6)	VARCHAR2(6) NOT NULL	Payroll Interface Field ID Prompt Table: PI_FIELD_TBL
6	PI_KEY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Payroll Interface Key Field C=Target Company E=Effective Date N=Not a Key Field O=Occurrence Defining Key Field R=Record Level Key Field Default Value: N
7	PI_GROUP_ID	Character(3)	VARCHAR2(3) NOT NULL	Payroll Interface Group ID Prompt Table: PI_GROUP_TBL
8	REVERSE_SIGN	Character(1)	VARCHAR2(1) NOT NULL	Field Reverse Sign Y/N Table Edit Default Value: N
9	CONVERT_CASE	Character(1)	VARCHAR2(1) NOT NULL	Convert Case Y/N Table Edit Default Value: N
10	REDEFINE_IND	Character(1)	VARCHAR2(1) NOT NULL	Redefine Previous Field Y/N Table Edit Default Value: N
11	PI_SYSTEM_ID	Character(4)	VARCHAR2(4) NOT NULL	Payroll Interface System ID Default Value: PI_DEFN_FILE.PI_SYSTEM_ID