SCC_NMD_TYP_NMT

(SQL Table)
Index Back

  • Parent record: SCC_NMD_TYP_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 NAME_DISPLAY_TYPE Character(30) VARCHAR2(30) NOT NULL Name Display Type
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 NMT_ID Number(5,0) INTEGER NOT NULL NMT_ID
    4 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Prompt Table: NAME_TYPE_TBL

    5 NAME_TYPE_RANK Number(3,0) SMALLINT NOT NULL Name Type Rank
    6 DEFAULT_NAME_FIELD Character(1) VARCHAR2(1) NOT NULL Default Name Field
    1=Use Name Display
    2=Use Formal Name
    3=Use Name