GENDER_ORNT_VW

(SQL View)
Index Back

Gender Orientation Details


SELECT REG_REGION , SEXUAL_ORIENTATION , EFFDT , EFF_STATUS , DESCR , DESCRLONG , LASTUPDOPRID , LASTUPDDTTM FROM PS_GENDER_ORNT_DTL

  • Related Language Record: GENDER_ORNT_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    2 SEXUAL_ORIENTATION Character(2) VARCHAR2(2) NOT NULL Sexual Orientation
    3 DATE_FROM Date(10) DATE Date From

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRLONG Long Character CLOB Long Description
    7 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.