PI_DEFN_RECORD

#	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# Default Value: 10
4	PI_RECORD_ID	Character(4)	VARCHAR2(4) NOT NULL	Payroll Interface Record ID
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	PI_RECORD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Record Type B=Not Processed by Interface D=Data H=Header P=Process Result T=Trailer Default Value: D
7	REC_OCCUR_IND	Character(1)	VARCHAR2(1) NOT NULL	Occurrence Indicator M=Multi Recs to Multi Defn Recs N=Multi Recs to Single Defn Rec S=Single Rec to Single Defn Rec Default Value: S
8	PRIMARY_PS_REC	Character(15)	VARCHAR2(15) NOT NULL	Primary Peoplesoft Record Prompt Table: PI_PS_REC_VW
9	PI_INSTANCE_ID	Character(6)	VARCHAR2(6) NOT NULL	Instance ID Prompt Table: PI_INSTANCE_TBL
10	PI_PROCESS_ID	Character(6)	VARCHAR2(6) NOT NULL	PI Process ID Prompt Table: PI_PROCESS_VW
11	REC_TERM_VAL	Character(6)	VARCHAR2(6) NOT NULL	Record Terminated Value
12	REC_TERM_LEN	Number(2,0)	SMALLINT NOT NULL	Record Terminated Length
13	PI_BASE_REC_SEQ	Number(3,0)	SMALLINT NOT NULL	PI Base Data Record Sequence Prompt Table: PI_DEFN_REC_VW
14	DESCRLONG	Long Character	CLOB	Long Description