NAME_PARSE_TBL

(SQL Table)
 Index Back

Name Parsing

Use NAME_PARSE_TBL to store all of the name types and name parts which are to be parsed into. The primary name on PERSONAL_DATA is parsed and the results are placed into the NAMES table via the entry/ies in NAME_PARSE_TBL.

  • Related Language Record: NAME_PARSE_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Prompt Table: NAME_TYPE_TBL

    2 NAME_PART Character(1) VARCHAR2(1) NOT NULL Part of Name
    F=First
    L=Last
    M=Middle
    T=Title
    U=Full

    Prompt Table: XL_NAME_PRT_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: NAME_PARSE_TBL.DESCR

    5 PARSE_BEGIN Character(4) VARCHAR2(4) NOT NULL Parse Begin Position
    AFTB=After First Blank and Comma
    AFTC=First Char After First Comma
    FLNM=Full Name
    POS1=First Character of Name
    6 PARSE_END Character(4) VARCHAR2(4) NOT NULL Parse End Position
    END=End of Name
    FLNM=Full Name
    FRST=First Blank Encountered
    NXTC=Next Comma Encountered
    SCND=Second Blank Encountered