SCCFP_MAP_FLD(SQL Table) |
Index Back |
---|---|
File Parser Mapping FieldFile Parser 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 | SCCFP_SGMNT_NBR | Number(9,0) | DECIMAL(9) NOT NULL | File Parser - File Segment number |
3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: SCCFP_CNTXT_REC |
4 | SCCFP_ROW_NBR | Number(3,0) | SMALLINT NOT NULL |
File Parser Row Number
Default Value: 1 |
5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
6 | SCCFP_SORT_ORDER | Number(6,0) | INTEGER NOT NULL | File Parser Sort Order field |
7 | SCCFP_FIELD_DESCR | Character(30) | VARCHAR2(30) NOT NULL |
File Parser field description
Prompt Table: SCCFP_FILE_FLD |
8 | SCCFP_MAP_ACTION | Character(4) | VARCHAR2(4) NOT NULL |
File Parser Map Action
CALC=Calculated CNTR=Unique Counter DFLT=Default Value DRCT=Direct from File I=Inherit from Parent NONE=None PI=Process Instance SEQ=Sequence Default Value: DRCT |
9 | 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 |
10 | BNDVALUE | Long Character | CLOB | Bind Value |
11 | SCCFP_CNTR_REC | Character(15) | VARCHAR2(15) NOT NULL |
Counter record - used in the file parser mapping feature.
Prompt Table: SCCFP_RECDFN_VW |
12 | SCCFP_CNTR_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Counter field - used in the file parser mapping feature.
Prompt Table: SCCFP_RECFLD_VW |
13 | SCCFP_FLD_FORMAT | Character(30) | VARCHAR2(30) NOT NULL |
Field Format Name
Prompt Table: SCCFP_FRMT |
14 | SCCFP_DATE_DELIM | Character(1) | VARCHAR2(1) NOT NULL | File Parser Date Seperater |
15 | SCCFP_DEC_POS | Number(3,0) | SMALLINT NOT NULL | File Parser Decimal Position |
16 | SCCFP_TRIM | Character(1) | VARCHAR2(1) NOT NULL |
File Parser Trim Field
Y/N Table Edit |
17 | SCCFP_CNVR_FIELD | Character(30) | VARCHAR2(30) NOT NULL |
Conversion Field Name
Prompt Table: SCCFP_CNVR_FLD |
18 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PSPACKAGROOT_VW |
19 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW |
20 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PSPACKAGCLAS_VW |
21 | SCCFP_SKIP_IF_BLNK | Character(1) | VARCHAR2(1) NOT NULL |
File Parser "skip if blank" flag. This flag drives the processing of the file parser by bypassing records when indicated fields are blanks. For example, if the phone number is blank a phone record insert can be avoided.
Y/N Table Edit Default Value: N |
22 | SCCFP_DATE_DAY | Character(2) | VARCHAR2(2) NOT NULL |
File Parser Date Separator
Default Value: 01 |
23 | SCCFP_SUB_PARSE | Character(1) | VARCHAR2(1) NOT NULL |
File Parser Sub Parse Field
Y/N Table Edit Default Value: N |
24 | SCCFP_SUB_DELIMITR | Character(1) | VARCHAR2(1) NOT NULL | File Parser Sub Field Delimiter - User Defined. |
25 | SCCFP_SUB_OCCUR | Number(2,0) | SMALLINT NOT NULL | File Parser Sub Field Occurance Position |
26 | SCCFP_DATE_MONTH | Character(2) | VARCHAR2(2) NOT NULL | File Parser Date Separator |