Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT USTR.ROWID ROW_ID
, USTR.UNIT_SECTION_TEACH_RESP_ID
, USTR.UOO_ID UOO_ID
, USTR.INSTRUCTOR_ID INSTRUCTOR_ID
, PE.PERSON_LAST_NAME || '
, '|| PE.PERSON_FIRST_NAME||' '||PE.PERSON_MIDDLE_NAME SURNAME
, USTR.CONFIRMED_FLAG CONFIRMED_FLAG
, USTR.PERCENTAGE_ALLOCATION PERCENTAGE_ALLOCATION
, USTR.INSTRUCTIONAL_LOAD INSTRUCTIONAL_LOAD
, USTR.INSTRUCTIONAL_LOAD_LAB
, USTR.INSTRUCTIONAL_LOAD_LECTURE
, USTR.LEAD_INSTRUCTOR_FLAG LEAD_INSTRUCTOR_FLAG
, USTR.CREATED_BY CREATED_BY
, USTR.CREATION_DATE CREATION_DATE
, USTR.LAST_UPDATED_BY LAST_UPDATED_BY
, USTR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USTR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PE.PARTY_NUMBER
FROM IGS_PS_USEC_TCH_RESP USTR
, HZ_PARTIES PE
WHERE USTR.INSTRUCTOR_ID = PE.PARTY_ID