SCCFP_MAPFLD_VW

(SQL View)
 Index Back

File Parser Mapped fields view

File Parser mapped fields view - joins file definition fields to results record fields

SELECT A.SCCFP_MAP_ID ,A.SCCFP_SGMNT_NBR ,A.RECNAME ,A.SCCFP_ROW_NBR ,A.FIELDNAME ,A.SCCFP_FIELD_DESCR ,A.SCCFP_MAP_ACTION ,A.SCCFP_FIELD_TYPE ,A.BNDVALUE ,A.SCCFP_CNTR_REC ,A.SCCFP_CNTR_FLD ,A.SCCFP_FLD_FORMAT ,A.SCCFP_SUB_PARSE ,A.SCCFP_SUB_DELIMITR ,A.SCCFP_SUB_OCCUR ,A.SCCFP_DATE_DELIM ,A.SCCFP_DATE_DAY ,A.SCCFP_DATE_MONTH ,A.SCCFP_DEC_POS ,A.SCCFP_TRIM ,A.SCCFP_CNVR_FIELD ,B.SCCFP_START_POS ,B.SCCFP_LENGTH ,B.SCCFP_FIELD_NBR ,B.SCCFP_SORT_ORDER ,A.PACKAGEROOT ,A.QUALIFYPATH ,A.APPCLASSID ,A.SCCFP_SKIP_IF_BLNK FROM PS_SCCFP_MAP_FLD A , PS_SCCFP_FILE_FLD B WHERE A.SCCFP_MAP_ID = B.SCCFP_MAP_ID AND A.SCCFP_SGMNT_NBR = B.SCCFP_SGMNT_NBR AND A.SCCFP_FIELD_DESCR = B.SCCFP_FIELD_DESCR

# 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_FIELD_DESCR Character(30) VARCHAR2(30) NOT NULL File Parser field description

Prompt Table: SCCFP_FILE_FLD

7 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

8 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

9 BNDVALUE Long Character CLOB Bind Value
10 SCCFP_CNTR_REC Character(15) VARCHAR2(15) NOT NULL Counter record - used in the file parser mapping feature.
11 SCCFP_CNTR_FLD Character(18) VARCHAR2(18) NOT NULL Counter field - used in the file parser mapping feature.
12 SCCFP_FLD_FORMAT Character(30) VARCHAR2(30) NOT NULL Field Format Name

Prompt Table: SCCFP_FRMT

13 SCCFP_SUB_PARSE Character(1) VARCHAR2(1) NOT NULL File Parser Sub Parse Field
14 SCCFP_SUB_DELIMITR Character(1) VARCHAR2(1) NOT NULL File Parser Sub Field Delimiter - User Defined.
15 SCCFP_SUB_OCCUR Number(2,0) SMALLINT NOT NULL File Parser Sub Field Occurance Position
16 SCCFP_DATE_DELIM Character(1) VARCHAR2(1) NOT NULL File Parser Date Seperater
17 SCCFP_DATE_DAY Character(2) VARCHAR2(2) NOT NULL File Parser Date Separator
18 SCCFP_DATE_MONTH Character(2) VARCHAR2(2) NOT NULL File Parser Date Separator
19 SCCFP_DEC_POS Number(3,0) SMALLINT NOT NULL File Parser Decimal Position
20 SCCFP_TRIM Character(1) VARCHAR2(1) NOT NULL File Parser Trim Field

Y/N Table Edit

21 SCCFP_CNVR_FIELD Character(30) VARCHAR2(30) NOT NULL Conversion Field Name

Prompt Table: SCCFP_CNVR_FLD

22 SCCFP_START_POS Number(9,0) DECIMAL(9) NOT NULL File Parser - Flat file field starting position
23 SCCFP_LENGTH Number(9,0) DECIMAL(9) NOT NULL File Parser - Flat file field length
24 SCCFP_FIELD_NBR Number(9,0) DECIMAL(9) NOT NULL File Parser Field Number
25 SCCFP_SORT_ORDER Number(6,0) INTEGER NOT NULL File Parser Sort Order field
26 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

Prompt Table: PSPACKAGROOT_VW

27 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

Prompt Table: PSPACKAGPATH_VW

28 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

Prompt Table: PSPACKAGCLAS_VW

29 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.