[Home] [Help]
View: IGSBV_FACULTY_PLACEMENT
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Base view to get the details of storing faculties for a placement |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT FACS.SPLACEMENT_ID
, FACS.FACULTY_ID
, PE.PARTY_NUMBER
, SPLAC.PERSON_ID
, SPLAC.COURSE_CD
, SPLAC.UOO_ID
, FACS.CREATED_BY
, FACS.CREATION_DATE
, FACS.LAST_UPDATED_BY
, FACS.LAST_UPDATE_DATE
FROM IGS_EN_SPLACE_FACS FACS
, HZ_PARTIES PE
, IGS_EN_SPLACEMENTS SPLAC
WHERE FACS.FACULTY_ID = PE.PARTY_ID
AND FACS.SPLACEMENT_ID = SPLAC.SPLACEMENT_ID WITH READ ONLY
Columns
| Name |
| STUDENT_PLACEMENT_IDENTIFIER |
| FACULTY_IDENTIFIER |
| FACULTY_NUMBER |
| PERSON_IDENTIFIER |
| PROGRAM_CODE |
| UNIT_SECTION_IDENTIFIER |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |