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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGS_AS_SUA_SES_ATTS_V

Object Details

Object Name:	IGS_AS_SUA_SES_ATTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AS_SUA_SES_ATTS_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

This view defines the student's attendance for a placement session.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID of the Table IGS_AS_SUA_SES_ATTS
PERSON_ID	NUMBER	(15)	Yes	Person ID of the student for whom the attendance is being captured.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number of the student for whom the attendance is being captured.
PERSON_NAME	VARCHAR2	(360)	Yes	Name of the student for whom the attendance is being captured.
PROGRAM_CD	VARCHAR2	(6)	Yes	Program code of the student, for what the attendance is to be captured.
UOO_ID	NUMBER	(7)	Yes	Unit section ID of the student, for what the attendance is to be captured.
SESSION_NAME	VARCHAR2	(90)	Yes	Session for what the attendance is captured.
SESSION_DESCRIPTION	VARCHAR2	(240)		Description of the placement session.
START_DATE	DATE		Yes	Start date time of the session. This has got both date and time components.
END_DATE	DATE			End date time of the session. This has got both date and time components.
OCCURENCE_DESC	VARCHAR2	(4000)		Description of the unit section occurrence, if used for the session.
ATTENDANCE_FLAG	VARCHAR2	(1)	Yes	Indicates whether the student has attended the session. The value is Y, N or NA.
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column.
CREATION_DATE	DATE		Yes	Standard Who Column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.IGS_AS_SUA_SES_ATTS_V;

Dependencies

[top of page]

APPS.IGS_AS_SUA_SES_ATTS_V references the following:

APPS: HZ_PARTIES; IGS_AS_GEN_008 - show dependent code; IGS_AS_SUA_SES_ATTS; IGS_AS_USEC_SESSNS

APPS.IGS_AS_SUA_SES_ATTS_V is not referenced by any database object