SCC_BIOG_CONFVW(SQL View) |
Index Back |
|---|---|
Biographic Flds - Config VwBiographic fields - configuration record view- Fluid. Holds Bio fields as rqd for display in SS. |
| SELECT SCC_BIO_FIELD_ID , SCC_BIOG_REGIONID , SCC_BIO_FLD_SEQ , SCC_MSGSET_BIO , SCC_MSGNBR_BIO , SCC_BIO_DISPL_ONLY , SCC_BIO_BLNK_WRN FROM PS_SCC_BIOG_CONF WHERE scc_bio_field_id IN ('GI','GJ') AND (scc_bio_field_id <> 'GJ' AND EXISTS( SELECT scc_bio_field_id FROM PS_SCC_BIOG_CONF WHERE scc_bio_field_id = 'GI') OR scc_bio_field_id = 'GJ' AND NOT EXISTS( SELECT scc_bio_field_id FROM PS_SCC_BIOG_CONF WHERE scc_bio_field_id = 'GI')) UNION SELECT SCC_BIO_FIELD_ID , SCC_BIOG_REGIONID , SCC_BIO_FLD_SEQ , SCC_MSGSET_BIO , SCC_MSGNBR_BIO , SCC_BIO_DISPL_ONLY , SCC_BIO_BLNK_WRN FROM PS_SCC_BIOG_CONF WHERE scc_bio_field_id IN ('PP','PQ') AND (scc_bio_field_id <> 'PQ' AND EXISTS( SELECT scc_bio_field_id FROM PS_SCC_BIOG_CONF WHERE scc_bio_field_id = 'PP') OR scc_bio_field_id = 'PQ' AND NOT EXISTS( SELECT scc_bio_field_id FROM PS_SCC_BIOG_CONF WHERE scc_bio_field_id = 'PP')) UNION SELECT SCC_BIO_FIELD_ID , SCC_BIOG_REGIONID , SCC_BIO_FLD_SEQ , SCC_MSGSET_BIO , SCC_MSGNBR_BIO , SCC_BIO_DISPL_ONLY , SCC_BIO_BLNK_WRN FROM PS_SCC_BIOG_CONF WHERE scc_bio_field_id IN ('SO','SP') AND (scc_bio_field_id <> 'SP' AND EXISTS( SELECT scc_bio_field_id FROM PS_SCC_BIOG_CONF WHERE scc_bio_field_id = 'SO') OR scc_bio_field_id = 'SP' AND NOT EXISTS( SELECT scc_bio_field_id FROM PS_SCC_BIOG_CONF WHERE scc_bio_field_id = 'SO')) UNION SELECT SCC_BIO_FIELD_ID , SCC_BIOG_REGIONID , SCC_BIO_FLD_SEQ , SCC_MSGSET_BIO , SCC_MSGNBR_BIO , SCC_BIO_DISPL_ONLY , SCC_BIO_BLNK_WRN FROM PS_SCC_BIOG_CONF WHERE scc_bio_field_id NOT IN ('GJ','GI','PQ','PP','SP','SO') |
| # | 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 |
| 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 |