SCC_PERS_BIOG

(SQL Table)
 Index Back

Gender ID Record

  • Parent Record Of SCC_CAF_PERSBIO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 SCC_BIRTH_GENDER Character(1) VARCHAR2(1) NOT NULL Birth Gender
    F=Female
    M=Male
    N=Not Applicable
    P=Prefer not to say
    U=Unknown
    X=Intersex
    4 SCC_GENDER_ID Character(2) VARCHAR2(2) NOT NULL Gender Identity
    OT=Other
    PN=Prefer not to say
    UN=Unknown
    5 SCC_GENDER_ID_OTH Character(120) VARCHAR2(120) NOT NULL Other Gender Identity
    6 SCC_SEXUAL_ORT Character(2) VARCHAR2(2) NOT NULL Sexual Orientation
    OT=Other
    PN=Prefer not to say
    UN=Unknown
    7 SCC_SEXUAL_ORT_OTH Character(120) VARCHAR2(120) NOT NULL Other Sexual Orientation
    8 SCC_PRONOUNS Character(2) VARCHAR2(2) NOT NULL Preferred Pronouns
    OT=Other
    PN=Prefer not to say
    UN=Unknown
    9 SCC_PRONOUNS_OTH Character(120) VARCHAR2(120) NOT NULL Other Preferred Pronouns
    10 SCC_BIO_ATTRB_1 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 1
    UN=Unknown
    11 SCC_BIO_ATTRB_2 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 2
    UN=Unknown
    12 SCC_BIO_ATTRB_3 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 3
    UN=Unknown
    13 SCC_BIO_ATTRB_4 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 4
    UN=Unknown
    14 SCC_BIO_ATTRB_5 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 5
    UN=Unknown
    15 SCC_BIO_ATTRB_6 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 6
    UN=Unknown
    16 SCC_BIO_ATTRB_7 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 7
    UN=Unknown
    17 SCC_BIO_ATTRB_8 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 8
    UN=Unknown
    18 SCC_BIO_ATTRB_9 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 9
    UN=Unknown
    19 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.
    20 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.