SCC_NMD_TYP_PRT

(SQL Table)
 Index Back

Name Display Type - Name Parts

  • Parent record: SCC_NMD_TYP_RUL

    • # 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 PRT_ID Number(5,0) INTEGER NOT NULL PRT_ID
    6 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    7 PART_TYPE Character(1) VARCHAR2(1) NOT NULL Part Type
    N=Name Field
    S=Space
    U=User Defined

    Default Value: N

    8 NAME_DISPLAY_CODE Character(1) VARCHAR2(1) NOT NULL Name Display Code
    1=First
    2=Last
    3=Middle
    4=Title
    5=Second_Last
    6=Prefix
    7=Royal_Prefix
    8=Royal_Suffix
    9=AC_Name
    A=Prefix_Partner
    B=Last_Partner
    C=Preferred_First
    D=Initials
    E=Suffix
    9 USER_DEFINED Character(35) VARCHAR2(35) NOT NULL User Defined
    10 PART_DEPENDENCY Number(2,0) SMALLINT NOT NULL Part Dependency