INSTITUTIONSCC_BRINCD_NLDPrompt Table: SCC_BRINCD_NLD
SAD_BR_EDU_SEC_NLDBO=Professional Education
ED=Education
VA=VAVO
EMPLIDPrompt Table: PEOPLE_SRCH
SAD_BR_STD_SCRH(SQL View) |
Index Back |
|---|---|
BRON student search record |
| SELECT DISTINCT INSTITUTION , SCC_BRINCD_NLD , SAD_BR_EDU_SEC_NLD , EMPLID , NATIONAL_ID FROM PS_SAD_BR_DEL_NLD DEL WHERE EMPLID > ' ' AND (NATIONAL_ID > ' ' OR NOT EXISTS ( SELECT DEL1.NATIONAL_ID FROM PS_SAD_BR_DEL_NLD DEL1 WHERE DEL1.NATIONAL_ID > ' ' 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 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |