NAME_FORMAT_TBL

(SQL Table)
 Index Back

Name Format Types

Types of Name Formats

  • Related Language Record: NAME_FORMAT_LNG

  • Parent Record Of NAME_FORMAT_DTL NAME_FORMAT_WRK

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

    Default Value: NAME_DFT_SEC

    6 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    7 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path
    8 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit

    Default Value: N