| # |
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_SGMNT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
File Parser - Segment Name
|
| 4 |
SCCFP_SGT_IDVAL |
Character(50) |
VARCHAR2(50) NOT NULL |
File Parser Segment ID value
|
| 5 |
SCCFP_FIELD_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
File Parser Field Number
|
| 6 |
SCCFP_START_POS |
Number(9,0) |
DECIMAL(9) NOT NULL |
File Parser - Flat file field starting position
|
| 7 |
SCCFP_LENGTH |
Number(9,0) |
DECIMAL(9) NOT NULL |
File Parser - Flat file field length
|