INSTITUTIONSCC_BRINCD_NLDPrompt Table: SCC_BRINCD_NLD
SAD_BR_EDU_SEC_NLDBO=Professional Education
ED=Education
VA=VAVO
EMPLIDPrompt Table: PEOPLE_SRCH
SAD_BR_STHBO_VW(SQL View) |
Index Back |
|---|---|
BRON student search record |
| SELECT DISTINCT INSTITUTION , SCC_BRINCD_NLD , SAD_BR_EDU_SEC_NLD , EMPLID , SAD_SL_SOFI_NBR FROM PS_SAD_BR_305_NLD DEL WHERE EMPLID > ' ' AND (SAD_SL_SOFI_NBR > ' ' OR NOT EXISTS ( SELECT DEL1.SAD_SL_SOFI_NBR FROM PS_SAD_BR_305_NLD DEL1 WHERE DEL1.SAD_SL_SOFI_NBR > ' ' AND DEL.EMPLID = DEL1.EMPLID)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SCC_BRINCD_NLD |
Character(4) | VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table: SCC_BRINCD_NLD |
| 3 | SAD_BR_EDU_SEC_NLD |
Character(2) | VARCHAR2(2) NOT NULL |
Educational Sector
BO=Professional Education ED=Education VA=VAVO |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 5 | SAD_SL_SOFI_NBR | Character(9) | VARCHAR2(9) NOT NULL | Social Fiscal Number |