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.IGSBV_AS_UNIT_SEC_ATTENDANCES

Object Details

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

View Type

A Business Intelligence System view

Unit section attendances

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_NAME	VARCHAR2	(360)	Yes	Student name
PERSON_NUMBER	VARCHAR2	(30)	Yes	Student number
PROGRAM_CODE	VARCHAR2	(6)	Yes	Program code
UNIT_CODE	VARCHAR2	(10)	Yes	Unit Code
UNIT_TITLE	VARCHAR2	(90)	Yes	Unit title
UNIT_CLASS	VARCHAR2	(10)	Yes	Section
UNIT_CLASS_DESCRIPTION	VARCHAR2	(60)	Yes	Section description
LOCATION_CODE	VARCHAR2	(10)	Yes	Location code
LOCATION_DESCRIPTION	VARCHAR2	(60)	Yes	Location description
CALENDAR_TYPE	VARCHAR2	(10)	Yes	Teaching calendar type
CALENDAR_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Teaching calendar sequence number
CALENDAR_DESCRIPTION	VARCHAR2	(30)		Teaching calendar description
ATTENDANCE_HOURS	NUMBER	(7)	Yes	Attendance hours given to student for a particular unit section
_LA:SUBMITTED	CHAR	(50)		Attendance have been Submitted 'Y'/'N'
PERSON_ID	NUMBER	(15)	Yes	Student Id
UNIT_SECTION_ID	NUMBER	(7)	Yes	ID of the Unit Section whose Attendance entered
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

Query Text

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


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

Dependencies

[top of page]

APPS.IGSBV_AS_UNIT_SEC_ATTENDANCES references the following:

APPS: HZ_PARTIES; IGS_AD_LOCATION; IGS_AS_UNIT_CLASS_ALL; IGS_AS_USEC_ATD_LINE; IGS_CA_INST_ALL; IGS_PS_UNIT_OFR_OPT_ALL; IGS_PS_UNIT_VER_ALL

APPS.IGSBV_AS_UNIT_SEC_ATTENDANCES is not referenced by any database object