View: IGS_PS_FACLTY_DEGRS_V

View Text

SELECT FD.ROWID ROW_ID
, FD.FACLTY_DEGRD_ID FACLTY_DEGRD_ID
, FD.DEGREE_CD DEGREE_CD
, PD.DESCRIPTION DESCRIPTION
, FD.PERSON_ID PERSON_ID
, FD.PROGRAM PROGRAM
, FD.INSTITUTION_CD INSTITUTION_CD
, INS.NAME INSTITUTION_NAME
, FD.DEGREE_DATE DEGREE_DATE
, FD.CREATED_BY CREATED_BY
, FD.CREATION_DATE CREATION_DATE
, FD.LAST_UPDATED_BY LAST_UPDATED_BY
, FD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_FACLTY_DEGRS FD
, IGS_OR_INSTITUTION INS
, IGS_PS_DEGREES PD
WHERE FD.INSTITUTION_CD = INS.INSTITUTION_CD
AND FD.DEGREE_CD = PD.DEGREE_CD

Columns