SCCFP_FIELD_TYPEC=Character
D=Date
N=Number
S=Signed Decimal
T=Time
X=Date Time
SCCFP_FLD_FORMATSCCFP_FRMT(SQL Table) |
Index Back |
|---|---|
File Parser field formatConfigurable field format setup for file parser |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | SCCFP_FLD_FORMAT |
Character(30) | VARCHAR2(30) NOT NULL | Field Format Name |
| 3 | SCCFP_FRMT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | File Parser format description |