RY_EE_SEX_VW

(SQL View)
 Index Back

Gender Lookup View

This view is used for related display purpose.

SELECT %Substring(A.FIELDVALUE, 1,1) , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'SEX' AND %EffdtCheck(PSXLATITEM,A,%currentdatein) AND A.EFF_STATUS='A'

  • Related Language Record: RY_EE_SEX_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
    F=Female
    M=Male
    U=Unknown
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name