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 NAME_FRMT_DVW1 NAME_FRMT_DVW2 NAME_FRMT_DVW3

    • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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 USE_NAME_GRP_FLG Character(1) VARCHAR2(1) NOT NULL Use Formal and Display Name Groups flag.

    Y/N Table Edit

    Default Value: N

    7 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    8 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path
    9 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