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_HE_POOUS

Object Details

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Program Offering Option Unit Set HESA Details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
HESA_POOUS_ID	NUMBER	(6)	Yes	Sequence generated record identifier
COURSE_CD	VARCHAR2	(6)	Yes	Course code
CRV_VERSION_NUMBER	NUMBER	(3)	Yes	Course version number
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type
LOCATION_CD	VARCHAR2	(10)	Yes	Location code
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	Attendance mode
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	Attendance type
UNIT_SET_CD	VARCHAR2	(10)	Yes	Unit set code
US_VERSION_NUMBER	NUMBER	(3)	Yes	Unit set version number
LOCATION_OF_STUDY	VARCHAR2	(30)		Location of Study
MODE_OF_STUDY	VARCHAR2	(30)		Mode of Study
UFI_PLACE	VARCHAR2	(30)
FRANCHISING_ACTIVITY	VARCHAR2	(30)		Franchising activity code
TYPE_OF_YEAR	VARCHAR2	(30)		Type of year
LENG_CURRENT_YEAR	NUMBER	(2)		Length of current year
GRADING_SCHEMA_CD	VARCHAR2	(10)		Grading Schema Code
GS_VERSION_NUMBER	NUMBER	(3)		Grading schema version number
CREDIT_VALUE_YOP1	NUMBER	(3)		Credit value of Year of program 1
LEVEL_CREDIT1	VARCHAR2	(30)		Level Credit 1
CREDIT_VALUE_YOP2	NUMBER	(3)		Credit value of Year of program 2
LEVEL_CREDIT2	VARCHAR2	(30)		Level Credit 2
FTE_INTENSITY	NUMBER	(5)		FTE Intensity
FTE_CALC_TYPE	VARCHAR2	(1)		FTE calculation type.Can take values I and U
TEACH_PERIOD_START_DT	DATE			Teaching period start date
TEACH_PERIOD_END_DT	DATE			Teaching period end date
OTHER_INSTIT_TEACH1	VARCHAR2	(30)		Other institution 1 teaching this program
OTHER_INSTIT_TEACH2	VARCHAR2	(30)		Other institution 2 teaching this program
PROP_NOT_TAUGHT	NUMBER	(5)		Proportion not taught
FUNDABILITY_CD	VARCHAR2	(30)		Fundability code
FEE_BAND	VARCHAR2	(30)		Fee band code
FUNDING_SOURCE	VARCHAR2	(10)		Institution defined Funding Source
LEVEL_APPLICABLE_TO_FUNDING	VARCHAR2	(30)		Level applicable to funding
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
CREDIT_VALUE_YOP3	NUMBER			Credit value of year of programme 3
LEVEL_CREDIT3	VARCHAR2	(30)		Level Credit 3
CREDIT_VALUE_YOP4	NUMBER			Credit value of year of programme 4
LEVEL_CREDIT4	VARCHAR2	(30)		Level Credit 4

Query Text

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


SELECT ROW_ID
,      HESA_POOUS_ID
,      COURSE_CD
,      CRV_VERSION_NUMBER
,      CAL_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      LOCATION_OF_STUDY
,      MODE_OF_STUDY
,      UFI_PLACE
,      FRANCHISING_ACTIVITY
,      TYPE_OF_YEAR
,      LENG_CURRENT_YEAR
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      CREDIT_VALUE_YOP1
,      LEVEL_CREDIT1
,      CREDIT_VALUE_YOP2
,      LEVEL_CREDIT2
,      FTE_INTENSITY
,      FTE_CALC_TYPE
,      TEACH_PERIOD_START_DT
,      TEACH_PERIOD_END_DT
,      OTHER_INSTIT_TEACH1
,      OTHER_INSTIT_TEACH2
,      PROP_NOT_TAUGHT
,      FUNDABILITY_CD
,      FEE_BAND
,      FUNDING_SOURCE
,      LEVEL_APPLICABLE_TO_FUNDING
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREDIT_VALUE_YOP3
,      LEVEL_CREDIT3
,      CREDIT_VALUE_YOP4
,      LEVEL_CREDIT4
FROM APPS.IGS_HE_POOUS;

Dependencies

[top of page]

APPS.IGS_HE_POOUS references the following:

APPS: IGS_HE_POOUS_ALL

APPS.IGS_HE_POOUS is referenced by following:

APPS: IGS_EN_HESA_PKG - show dependent code; IGS_HE_EXTRACT2_PKG - show dependent code; IGS_HE_EXTRACT_FIELDS_PKG - show dependent code; IGS_HE_EXTRACT_FIELDS_PKG - show dependent code; IGS_HE_EXTRACT_PKG - show dependent code; IGS_HE_IDENTIFY_TARGET_POP - show dependent code; IGS_HE_POOUS_DTLS_V; IGS_HE_PS_PKG - show dependent code