...
Certain academic information comes to students via the attending institution. This information includes enrollment, STDNT_ENRL fieldrecord, and term activation, STDNT_CAR_TERM fieldrecord. This information is created for students by a particular institution, so the keys to these tables include the EMPLID and the INSTITUTION field. There are some tables where the key structure does not include the INSTITUTION field, but INSTITUTION appears in the table anyway. An example of this is the academic program, ACAD_PROG. This academic information exists only because of the students’ relationship with a particular institution.
On the other hand financial side of the students’ involvement with an institution, the field, INSTITUTION, is not used. Instead, the field BUSINESS_UNIT is used. Charges for tuition and fees are stored in the item table, ITEM_SF. Here the keys include EMPLID and BUSINESS_UNIT.
...
| Panel |
|---|
INSTITUTION = ‘BAR01’ (Baruch), then the BUSINESS_UNIT = ‘BAR01’ and the SETID = ‘BAR01’ |
Example of Joining different records with similar keys with different Names below:
| Academic | key(s) | Financial | Key(s) |
|---|---|---|---|
ACAD_PROG | EMPLID, INSTITUTION | FACILITY_TBL | SETID |
| STDNT_ENRL | EMPLID, INSTITUTION | ITEM_SF | BUSINESS_UNIT |
| STDNT_CAR_TERM | EMPLID, INSTITUTION |