| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SCCFP_CNTXT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Context ID - the unique key that identifies the file context
|
| 2 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
SCCFP_REC_VW
|
| 3 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
RECFIELD_VW
|
| 4 |
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
|
| 5 |
SCCFP_FLD_FORMAT |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Format Name
Prompt Table:
SCCFP_FRMT
|
| 6 |
SCCFP_DATE_DELIM |
Character(1) |
VARCHAR2(1) NOT NULL |
File Parser Date Seperater
|
| 7 |
SCCFP_DFLT_ACTION |
Character(4) |
VARCHAR2(4) NOT NULL |
File Parser Map Action
CALC=Calculated
CNTR=Unique Counter
DFLT=Default Value
I=Inherit from Parent
NONE=No Default
PI=Process Instance
SEQ=Sequence
|
| 8 |
BNDVALUE |
Long Character |
CLOB |
Bind Value
|
| 9 |
SCCFP_CNTR_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
Counter record - used in the file parser mapping feature.
Prompt Table:
SCCFP_RECDFN_VW
|
| 10 |
SCCFP_CNTR_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Counter field - used in the file parser mapping feature.
Prompt Table:
SCCFP_RECFLD_VW
|
| 11 |
SCCFP_DFLT_VIS |
Character(1) |
VARCHAR2(1) NOT NULL |
File Parser - Visible on Mapping page indicator
Y/N Table Edit
Default Value: Y
|
| 12 |
SCCFP_SORT_ORDER |
Number(6,0) |
INTEGER NOT NULL |
File Parser Sort Order field
|
| 13 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table:
PSPACKAGROOT_VW
|
| 14 |
QUALIFYPATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table:
PSPACKAGPATH_VW
|
| 15 |
APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table:
PSPACKAGCLAS_VW
|
| 16 |
SCCFP_DATE_DAY |
Character(2) |
VARCHAR2(2) NOT NULL |
File Parser Date Separator
Default Value: 01
|
| 17 |
SCCFP_DATE_MONTH |
Character(2) |
VARCHAR2(2) NOT NULL |
File Parser Date Separator
Default Value: 01
|