SCCFP_MAP_DFN

(SQL Table)
 Index Back

File Parser Mapping Definition

File Parser Mapping Definition - the parent to the file layout and mapping tables.

  • Related Language Record: SCCFP_MPDFN_LNG

  • Parent Record Of SCCFP_FILE_SGT 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_MAP_NAME Character(30) VARCHAR2(30) NOT NULL File Mapping name - the user key to a File Mapping
    3 SCCFP_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the file context

    Prompt Table: SCCFP_CNTXT_DFN

    4 SCCFP_FILE_TYPE Character(1) VARCHAR2(1) NOT NULL File Type - CSV, Flat File, XML etc
    D=Delimited
    F=Flat

    Default Value: F

    5 SCCFP_SGMNTD Character(1) VARCHAR2(1) NOT NULL File Parser - Segmented Indicator

    Y/N Table Edit

    Default Value: N

    6 SCCFP_CNVR_ID Number(15,0) DECIMAL(15) NOT NULL Conversion Profile ID - the unique key that identifies the file conversion profile

    Default Value: SCCFP_CNTXT_DFN.SCCFP_CNVR_ID

    Prompt Table: SCCFP_CNVR

    7 SCCFP_DELIMITER Character(1) VARCHAR2(1) NOT NULL File Parser Field Delimiter (e.g. Comma, Tab, etc)
    C=Comma
    P=Pipe
    T=Tab
    X=Semicolon

    Default Value: C

    8 SCCFP_FIELD_QUAL Character(1) VARCHAR2(1) NOT NULL File Parser Field Qualifier

    Default Value: "

    9 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    10 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    11 SCCFP_HEADER Character(1) VARCHAR2(1) NOT NULL File Parser automap from header indicator
    12 SCCFP_HEADER_ROW Number(3,0) SMALLINT NOT NULL File Parser Header Row Number
    13 SCCFP_MAP_STATUS Character(1) VARCHAR2(1) NOT NULL File Parser Map Status
    A=Active
    I=Inactive
    P=Pending

    Default Value: P