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: IGS_AS_SUA_SES_ATTS_V

Product:	IGS - Student System (Obsolete)
Description:	This view defines the student's attendance for a placement session.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ATTS.ROWID ROW_ID
, ATTS.PERSON_ID PERSON_ID
, HZ.PARTY_NUMBER PERSON_NUMBER
, HZ.PARTY_NAME PERSON_NAME
, ATTS.COURSE_CD PROGRAM_CD
, ATTS.UOO_ID UOO_ID
, ATTS.SESSION_NAME SESSION_NAME
, SESSNS.SESSION_DESCRIPTION SESSION_DESCRIPTION
, SESSNS.SESSION_START_DATE_TIME START_DATE
, SESSNS.SESSION_END_DATE_TIME END_DATE
, DECODE( SESSNS.UNIT_SECTION_OCCURRENCE_ID
, NULL
, NULL
, IGS_AS_GEN_008.GET_OCCUR_DETAILS (ATTS.UOO_ID
, SESSNS.UNIT_SECTION_OCCURRENCE_ID)) OCCURENCE_DESC
, ATTS.ATTENDANCE_FLAG ATTENDANCE_FLAG
, ATTS.CREATED_BY CREATED_BY
, ATTS.CREATION_DATE CREATION_DATE
, ATTS.LAST_UPDATED_BY LAST_UPDATED_BY
, ATTS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ATTS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_SUA_SES_ATTS ATTS
, IGS_AS_USEC_SESSNS SESSNS
, HZ_PARTIES HZ
WHERE ATTS.SESSION_NAME = SESSNS.SESSION_NAME
AND ATTS.UOO_ID = SESSNS.UOO_ID
AND ATTS.PERSON_ID = HZ.PARTY_ID

Columns

Name
ROW_ID
PERSON_ID
PERSON_NUMBER
PERSON_NAME
PROGRAM_CD
UOO_ID
SESSION_NAME
SESSION_DESCRIPTION
START_DATE
END_DATE
OCCURENCE_DESC
ATTENDANCE_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN