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_HOUSING_STATUSES

Object Details

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

View Type

A Business Intelligence System view

This entity contains information about the housing statuses of a person.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CALENDER_TYPE	VARCHAR2	(26)		Calendar type
SEQUENCE_NUMBER	NUMBER	(10)		Calendar sequence number
START_DATE	DATE			No longer used
END_DATE	DATE			No longer used
_LA:TEACH_PERIOD_RES_STATUS	CHAR	(75)		Meaning of the Teaching period residency status code.
TEACHING_PERIOD_ID	NUMBER	(15)	Yes	Teaching period residency status code.
PERSON_ID	NUMBER	(15)	Yes	Unique Person identifier.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	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 CALENDER_TYPE
,      SEQUENCE_NUMBER
,      START_DATE
,      END_DATE
,      _LA:TEACH_PERIOD_RES_STATUS
,      TEACHING_PERIOD_ID
,      PERSON_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_HOUSING_STATUSES;

Dependencies

[top of page]

APPS.IGSBV_HOUSING_STATUSES references the following:

APPS: IGS_PE_TEACH_PERIODS_ALL

APPS.IGSBV_HOUSING_STATUSES is not referenced by any database object