GPES_FILE_DEFN (SQL Table)	Index Back
Load flat file setup Input flat file general setup. GPES_FILE_CD: File code. RECNAME: Table name to store the data read from the flat file. One row several fields (master table). RECNAME_FILE: Table name to store the data read from the flat file. One row one field. Optional (secondary table). FIELDNAME0: Key field name used to delete previously loaded data. Before starting to load data for the a new value, the data is deleted for such a new value from both the master and secondary tables. GPES_REC_TYP_I: In case the file has different record layouts, beginning position of the record type field. GPES_REC_TYP_L: In case the file has different record layouts, length of the record type field.

GPES_FILE_DEFN

(SQL Table)

Load flat file setup

Input flat file general setup. GPES_FILE_CD: File code. RECNAME: Table name to store the data read from the flat file. One row several fields (master table). RECNAME_FILE: Table name to store the data read from the flat file. One row one field. Optional (secondary table). FIELDNAME0: Key field name used to delete previously loaded data. Before starting to load data for the a new value, the data is deleted for such a new value from both the master and secondary tables. GPES_REC_TYP_I: In case the file has different record layouts, beginning position of the record type field. GPES_REC_TYP_L: In case the file has different record layouts, length of the record type field.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPES_FILE_CD Character(8) VARCHAR2(8) NOT NULL File code

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN

3 RECNAME_FILE Character(15) VARCHAR2(15) NOT NULL Model File Layout
Prompt Table: PSRECDEFN

4 FIELDNAME0 Character(18) VARCHAR2(18) NOT NULL Name of Field
Prompt Table: PSRECFIELDALL

5 GPES_REC_TYP_I Number(3,0) SMALLINT NOT NULL Record type field beginning position

6 GPES_REC_TYP_L Number(3,0) SMALLINT NOT NULL Record type field length

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPES_FILE_CD	Character(8)	VARCHAR2(8) NOT NULL	File code
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
3	RECNAME_FILE	Character(15)	VARCHAR2(15) NOT NULL	Model File Layout Prompt Table: PSRECDEFN
4	FIELDNAME0	Character(18)	VARCHAR2(18) NOT NULL	Name of Field Prompt Table: PSRECFIELDALL
5	GPES_REC_TYP_I	Number(3,0)	SMALLINT NOT NULL	Record type field beginning position
6	GPES_REC_TYP_L	Number(3,0)	SMALLINT NOT NULL	Record type field length