SCCFP_FILE_FLD

#	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	SCCFP_FIELD_DESCR	Character(30)	VARCHAR2(30) NOT NULL	File Parser field description
4	SCCFP_SORT_ORDER	Number(6,0)	INTEGER NOT NULL	File Parser Sort Order field
5	SCCFP_START_POS	Number(9,0)	DECIMAL(9) NOT NULL	File Parser - Flat file field starting position
6	SCCFP_LENGTH	Number(9,0)	DECIMAL(9) NOT NULL	File Parser - Flat file field length
7	SCCFP_FIELD_NBR	Number(9,0)	DECIMAL(9) NOT NULL	File Parser Field Number
8	SCCFP_FIELD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	File Parser field type C=Character D=Date N=Number S=Signed Decimal T=Time X=Date Time Default Value: C
9	SCCFP_FLD_FORMAT	Character(30)	VARCHAR2(30) NOT NULL	Field Format Name Prompt Table: SCCFP_FRMT
10	SCCFP_DATE_DELIM	Character(1)	VARCHAR2(1) NOT NULL	File Parser Date Seperater
11	SCCFP_DEC_POS	Number(3,0)	SMALLINT NOT NULL	File Parser Decimal Position
12	SCCFP_TRIM	Character(1)	VARCHAR2(1) NOT NULL	File Parser Trim Field Y/N Table Edit
13	SCCFP_DATE_DAY	Character(2)	VARCHAR2(2) NOT NULL	File Parser Date Separator Default Value: 01
14	SCCFP_DATE_MONTH	Character(2)	VARCHAR2(2) NOT NULL	File Parser Date Separator Default Value: 01