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

Object Details

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

View Type

A Business Intelligence System view

This entity describes a student's satisfaction of a special requirement within a nominated student program attempt. For example, first-aid certificate.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_IDENTIFIER	NUMBER	(15)	Yes	Describes the ID code that uniquely identifies a person.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the person number for a person id
PERSON_NAME	VARCHAR2	(360)	Yes	Full Name of the Person.
PROGRAM_CODE	VARCHAR2	(6)	Yes	Code used to identify the program in that the student is enrolled.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title of the program code
SPECIAL_REQUIREMENT_CODE	VARCHAR2	(10)	Yes	Code of a special requirement. Special requirements are institution- defined and might include for example, First Aid.
SPECIAL_REQUIREMENT_DESC	VARCHAR2	(60)	Yes	Description of the special requirement
COMPLETED_DATE	DATE		Yes	Date on that the special requirements were completed.
EXPIRY_DATE	DATE			Date on that the special requirement expires. For example, a first aid certificate might only be valid for 12 months.
REFERENCE	VARCHAR2	(10)		Generic reference number of the special requirement. For example, the first aid certificate number.
COMMENTS	VARCHAR2	(2000)		Provides any comments about a student's satisfaction of a special requirement within a nominated program attempt.
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_IDENTIFIER
,      PERSON_NUMBER
,      PERSON_NAME
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      SPECIAL_REQUIREMENT_CODE
,      SPECIAL_REQUIREMENT_DESC
,      COMPLETED_DATE
,      EXPIRY_DATE
,      REFERENCE
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_STD_PRG_SPL_REQUIREMENTS;

Dependencies

[top of page]

APPS.IGSFV_STD_PRG_SPL_REQUIREMENTS references the following:

APPS: HZ_PARTIES; IGS_EN_STDNT_PS_ATT_ALL; IGS_GE_SPL_REQ; IGS_PS_STDNT_SPL_REQ; IGS_PS_VER_ALL

APPS.IGSFV_STD_PRG_SPL_REQUIREMENTS is not referenced by any database object