SCC_NMD_TYP_RUL

(SQL Table)
 Index Back

  • Parent record: SCC_NMD_TYP_NMT

    • # 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 RUL_ID Number(5,0) INTEGER NOT NULL RUL_ID
    5 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types

    Prompt Table: NAME_FORMAT_TBL

    6 RULE_OPTION Character(1) VARCHAR2(1) NOT NULL Name Field
    1=Use Name Display
    2=Use Formal Name
    3=Use Name
    4=Use Name Parts
    7 LAST_NAME_PREF_NLD Character(1) VARCHAR2(1) NOT NULL The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
    1=Own Name
    2=Name Partner
    3=Name Partner + Own Name
    4=Own Name + Name Partner

    Default Value: 1

    8 IGNORE_RULES Character(1) VARCHAR2(1) NOT NULL Ignore Rules
    N=No
    Y=Yes