HCR_NM_TYP_I

(SQL View)
 Index Back

Name Type Table Interface VW

Used to store Types of Names that a person can have and the order that they are displayed

SELECT A.NAME_TYPE ,A.ORDER_BY_SEQ ,A.NAME_TYPE_DESCR ,A.NAME_TYPE_SHORT ,A.DATA_TYPE_CD FROM PS_NAME_TYPE_TBL A

  • Related Language Record: HCR_NM_TYP_LN_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
    2 ORDER_BY_SEQ Number(2,0) SMALLINT NOT NULL Order by Sequence
    3 NAME_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Name Type
    4 NAME_TYPE_SHORT Character(15) VARCHAR2(15) NOT NULL Name Type Short
    5 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N