SCCFP_MAP_REC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCCFP_MAP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Mapping ID - the unique key that identifies the file mapping
2	SCCFP_SGMNT_NBR	Number(9,0)	DECIMAL(9) NOT NULL	File Parser - File Segment number
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: SCCFP_CNTXT_REC
4	SCCFP_ROW_NBR	Number(3,0)	SMALLINT NOT NULL	File Parser Row Number Default Value: 1
5	SCCFP_PARENT_REC	Character(15)	VARCHAR2(15) NOT NULL	File Parser Parent Record Prompt Table: SCCFP_CNTXT_REC
6	SCCFP_PARENT_ROW	Number(3,0)	SMALLINT NOT NULL	File Parser Row Number
7	SCCFP_SORT_ORDER	Number(6,0)	INTEGER NOT NULL	File Parser Sort Order field
8	SCCFP_TREE_LEVEL	Number(3,0)	SMALLINT NOT NULL	File Parser Tree level field
9	SCCFP_FORCE_INSERT	Character(1)	VARCHAR2(1) NOT NULL	File Parser "Force Insert" flag. When this flag is set the file parser will always insert a row even if not file fields are mapped to the record. Y/N Table Edit Default Value: N