[Home] [Help]
View: IGSFV_FACULTY_PLACEMENT
Product: | IGS - Student System (Obsolete) |
Description: | Full 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 |