SCC_BIOG_CONF

(SQL Table)
Index Back

Biographic Flds - Config

Biographic fields - configuration record - Fluid

  • Parent Record Of SCC_BIOG_EXCL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_BIO_FIELD_ID Character(2) VARCHAR2(2) NOT NULL Field Name
    BG=Birth Gender
    GE=Gender
    GI=Gender Identity
    GJ=Other Identity
    MA=Marital Status
    MS=Military Status
    PP=Pronouns
    PQ=Other Pronouns
    RP=Religious Preference
    SO=Sexual Orientation
    SP=Other Orientation
    XA=Biographical Attribute 1
    XB=Biographical Attribute 2
    XC=Biographical Attribute 3
    XD=Biographical Attribute 4
    XE=Biographical Attribute 5
    XF=Biographical Attribute 6
    XG=Biographical Attribute 7
    XH=Biographical Attribute 8
    XI=Biographical Attribute 9
    2 SCC_BIOG_REGIONID Number(2,0) SMALLINT NOT NULL Biographic Region
    3 SCC_BIO_FLD_SEQ Number(2,0) SMALLINT NOT NULL Sequence
    4 SCC_MSGSET_BIO Number(5,0) INTEGER NOT NULL Message Set
    5 SCC_MSGNBR_BIO Number(5,0) INTEGER NOT NULL Message Number

    Prompt Table: SCC_MSGCAT_DYN

    6 SCC_BIO_DISPL_ONLY Character(1) VARCHAR2(1) NOT NULL Display Only

    Y/N Table Edit

    7 SCC_BIO_BLNK_WRN Character(1) VARCHAR2(1) NOT NULL Blank Warning

    Y/N Table Edit