eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSBV_AS_UNIT_SEC_ATTENDANCES

Product:	IGS - Student System (Obsolete)
Description:	Unit section attendances
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, UAL.COURSE_CD
, UOO.UNIT_CD
, UV.TITLE
, UOO.UNIT_CLASS
, UC.DESCRIPTION
, UOO.LOCATION_CD
, LOC.DESCRIPTION
, UOO. CAL_TYPE
, UOO. CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, UAL.ATTENDANCE_HOURS
, '_LA:UAL.SUBMITTED:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, UAL.PERSON_ID
, UAL.UOO_ID
, UAL.CREATED_BY
, UAL.CREATION_DATE
, UAL.LAST_UPDATED_BY
, UAL.LAST_UPDATE_DATE
FROM IGS_AS_USEC_ATD_LINE UAL
, HZ_PARTIES HP
, IGS_PS_UNIT_VER_ALL UV
, IGS_AS_UNIT_CLASS_ALL UC
, IGS_AD_LOCATION LOC
, IGS_CA_INST_ALL CI
, IGS_PS_UNIT_OFR_OPT_ALL UOO
WHERE UAL.PERSON_ID = HP.PARTY_ID
AND UAL.UOO_ID = UOO.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.UNIT_CLASS = UC.UNIT_CLASS
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.CAL_TYPE = CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY

Columns

Name
PERSON_NAME
PERSON_NUMBER
PROGRAM_CODE
UNIT_CODE
UNIT_TITLE
UNIT_CLASS
UNIT_CLASS_DESCRIPTION
LOCATION_CODE
LOCATION_DESCRIPTION
CALENDAR_TYPE
CALENDAR_SEQUENCE_NUMBER
CALENDAR_DESCRIPTION
ATTENDANCE_HOURS
"_LA:SUBMITTED"
PERSON_ID
UNIT_SECTION_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE