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_STORED_PLACEMENTS

Object Details

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

View Type

A Business Intelligence System view

Full view for getting details of the storing placement information of a student unit attempt.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
STUDENT_PLACEMENT_IDENTIFIER	NUMBER		Yes	PK
PERSON_IDENTIFIER	NUMBER	(15)	Yes	Identifier of the person for the student placement
PROGRAM_CODE	VARCHAR2	(6)	Yes	The code of the student's program attempt
UNIT_SECTION_IDENTIFIER	NUMBER	(7)	Yes	Identifier of the student unit attempt
START_DATE	DATE		Yes	Start date of the placement
END_DATE	DATE		Yes	End date of the placement
INSTITUTION_CODE	VARCHAR2	(30)	Yes	Institution code
TITLE	VARCHAR2	(90)	Yes	Title of the placement
DESCRIPTION	VARCHAR2	(150)		Description of the placement
CATEGORY_CODE	VARCHAR2	(30)		Placement category code
PLACEMENT_TYPE_CODE	VARCHAR2	(30)		Placement type code
SPECIALTY_CODE	VARCHAR2	(30)		Placement specialty code
COMPENSATION_FLAG	VARCHAR2	(1)	Yes	Whether the student is compensated or not for the placement
ATTENDANCE_TYPE	VARCHAR2	(2)		Attendance type of the placement
LOCATION	VARCHAR2	(240)		Location of the placement
NOTES	VARCHAR2	(2000)		Notes
PERSON_NUMBER	VARCHAR2	(30)	Yes	Unique Person Number for a Person given Person ID.
UNIT_CODE	VARCHAR2	(10)	Yes	Unit Code
UNIT_VERSION_NUMBER	NUMBER	(3)	Yes	Unit version number
UNIT_CLASS	VARCHAR2	(10)	Yes	Unit class
LOCATION_CODE	VARCHAR2	(10)	Yes	Unit location code
INSTITUTION_NAME	VARCHAR2	(360)	Yes	Institution name
ATTEND_TYPE_DESCRIPTION	VARCHAR2	(60)		Description of attendance type of the placement
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 STUDENT_PLACEMENT_IDENTIFIER
,      PERSON_IDENTIFIER
,      PROGRAM_CODE
,      UNIT_SECTION_IDENTIFIER
,      START_DATE
,      END_DATE
,      INSTITUTION_CODE
,      TITLE
,      DESCRIPTION
,      CATEGORY_CODE
,      PLACEMENT_TYPE_CODE
,      SPECIALTY_CODE
,      COMPENSATION_FLAG
,      ATTENDANCE_TYPE
,      LOCATION
,      NOTES
,      PERSON_NUMBER
,      UNIT_CODE
,      UNIT_VERSION_NUMBER
,      UNIT_CLASS
,      LOCATION_CODE
,      INSTITUTION_NAME
,      ATTEND_TYPE_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_STORED_PLACEMENTS;

Dependencies

[top of page]

APPS.IGSFV_STORED_PLACEMENTS references the following:

APPS: HZ_PARTIES; IGS_EN_ATD_TYPE_ALL; IGS_EN_SPLACEMENTS; IGS_PE_HZ_PARTIES; IGS_PS_UNIT_OFR_OPT_ALL

APPS.IGSFV_STORED_PLACEMENTS is not referenced by any database object