Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Base view for getting details of the storing placement information of a student unit attempt. |
Implementation/DBA Data: | Not implemented in this database |
SELECT SPLAC.SPLACEMENT_ID
, SPLAC.PERSON_ID
, SPLAC.COURSE_CD
, SPLAC.UOO_ID
, SPLAC.START_DATE
, SPLAC.END_DATE
, SPLAC.INSTITUTION_CODE
, SPLAC.TITLE
, SPLAC.DESCRIPTION
, SPLAC.CATEGORY_CODE
, SPLAC.PLACEMENT_TYPE_CODE
, SPLAC.SPECIALTY_CODE
, SPLAC.COMPENSATION_FLAG
, SPLAC.ATTENDANCE_TYPE
, SPLAC.LOCATION
, SPLAC.NOTES
, PE.PARTY_NUMBER
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.UNIT_CLASS
, UOO.LOCATION_CD
, INST.PARTY_NAME
, SPLAC.CREATED_BY
, SPLAC.CREATION_DATE
, SPLAC.LAST_UPDATED_BY
, SPLAC.LAST_UPDATE_DATE
FROM IGS_EN_SPLACEMENTS SPLAC
, HZ_PARTIES PE
, HZ_PARTIES INST
, IGS_PE_HZ_PARTIES IHP
, IGS_PS_UNIT_OFR_OPT_ALL UOO
WHERE SPLAC.PERSON_ID = PE.PARTY_ID
AND SPLAC.UOO_ID = UOO.UOO_ID
AND INST.PARTY_ID = IHP.PARTY_ID
AND SPLAC.INSTITUTION_CODE = IHP.OSS_ORG_UNIT_CD WITH READ ONLY