SCCFP_CNVR_FLD

(SQL Table)
 Index Back

File Parser Conversion Fld

File Parser Conversion Fields

  • Parent record: SCCFP_CNVR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCCFP_CNVR_ID Number(15,0) DECIMAL(15) NOT NULL Conversion Profile ID - the unique key that identifies the file conversion profile
    2 SCCFP_CNVR_FIELD Character(30) VARCHAR2(30) NOT NULL Conversion Field Name
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN_VW

    4 SCCFP_DFLT_VALUE Character(30) VARCHAR2(30) NOT NULL File Parser field conversion default (PeopleSoft) value
    5 SCCFP_CNVR_ERR Character(1) VARCHAR2(1) NOT NULL File Parser Unmatched handling indicator
    D=Default Value
    E=Error - Halt Processing

    Default Value: E

    6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: PSMSGSETDEFN

    7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: PSMSGCATDEFN