SCCFP_MAP_FLD

(SQL Table)
Index Back

File Parser Mapping Field

File Parser Mapping Field Table

  • Parent record: SCCFP_MAP_REC
  • # 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