SCCFP_MAP_IDFIELDNAMEC=Character
D=Date
N=Number
S=Signed Decimal
T=Time
X=Date Time
Default Value: C
Prompt Table: SCCFP_FRMT
Y/N Table Edit
SCCFP_PS_MAPFLD(SQL Table) |
Index Back |
|---|---|
File Parser Pop Select Map FldFile Parser Pop Select Mapping Field Table |
| # | 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 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | SCCFP_FIELD_DESCR | Character(30) | VARCHAR2(30) NOT NULL | File Parser field description |
| 4 | SCCFP_START_POS | Number(9,0) | DECIMAL(9) NOT NULL | File Parser - Flat file field starting position |
| 5 | SCCFP_LENGTH | Number(9,0) | DECIMAL(9) NOT NULL | File Parser - Flat file field length |
| 6 | SCCFP_FIELD_NBR | Number(9,0) | DECIMAL(9) NOT NULL | File Parser Field Number |
| 7 | 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 |
| 8 | SCCFP_FLD_FORMAT | Character(30) | VARCHAR2(30) NOT NULL |
Field Format Name
Prompt Table: SCCFP_FRMT |
| 9 | SCCFP_DATE_DELIM | Character(1) | VARCHAR2(1) NOT NULL | File Parser Date Seperater |
| 10 | SCCFP_DEC_POS | Number(3,0) | SMALLINT NOT NULL | File Parser Decimal Position |
| 11 | SCCFP_TRIM | Character(1) | VARCHAR2(1) NOT NULL |
File Parser Trim Field
Y/N Table Edit |