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_ST_PRG_DTLS_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
HESA_ST_PROG_ID	NUMBER	(6)	Yes
COURSE_CD	VARCHAR2	(6)	Yes
SHORT_TITLE	VARCHAR2	(40)	Yes
VERSION_NUMBER	NUMBER	(3)	Yes
TEACHER_TRAIN_PROG_ID	VARCHAR2	(30)
TEACHER_TRAIN_PROG_DESC	VARCHAR2	(240)
ITT_PHASE	VARCHAR2	(30)
ITT_PHASE_DESC	VARCHAR2	(240)
BILINGUAL_ITT_MARKER	VARCHAR2	(30)
BILINGUAL_ITT_MARKER_DESC	VARCHAR2	(240)
TEACHING_QUAL_SOUGHT_SECTOR	VARCHAR2	(30)
TEACH_QUAL_SOUGHT_SECT_DESC	VARCHAR2	(240)
TEACHING_QUAL_SOUGHT_SUBJ1	VARCHAR2	(30)
TEACH_QUAL_SOUGHT_SUBJ1_DESC	VARCHAR2	(240)
TEACHING_QUAL_SOUGHT_SUBJ2	VARCHAR2	(30)
TEACH_QUAL_SOUGHT_SUBJ2_DESC	VARCHAR2	(240)
TEACHING_QUAL_SOUGHT_SUBJ3	VARCHAR2	(30)
TEACH_QUAL_SOUGHT_SUBJ3_DESC	VARCHAR2	(240)
LOCATION_OF_STUDY	VARCHAR2	(30)
LOCATION_OF_STUDY_DESC	VARCHAR2	(240)
OTHER_INST_PROV_TEACHING1	VARCHAR2	(30)
OTHER_INST_PROV_TEACHING1_DESC	VARCHAR2	(360)
OTHER_INST_PROV_TEACHING2	VARCHAR2	(30)
OTHER_INST_PROV_TEACHING2_DESC	VARCHAR2	(360)
PROP_TEACHING_IN_WELSH	NUMBER	(5)
PROP_NOT_TAUGHT	NUMBER	(5)
CREDIT_TRANSFER_SCHEME	VARCHAR2	(30)
CREDIT_TRANSFER_SCHEME_DESC	VARCHAR2	(240)
RETURN_TYPE	VARCHAR2	(3)
RETURN_TYPE_DESC	VARCHAR2	(80)		Return type Description
DEFAULT_AWARD	VARCHAR2	(30)		Default Award
PROGRAM_CALC	VARCHAR2	(1)
LEVEL_APPLICABLE_TO_FUNDING	VARCHAR2	(30)
LEVEL_APPL_TO_FUNDING_DESC	VARCHAR2	(240)
FRANCHISING_ACTIVITY	VARCHAR2	(30)
FRANCHISING_ACTIVITY_DESC	VARCHAR2	(240)
NHS_FUNDING_SOURCE	VARCHAR2	(30)
NHS_FUNDING_SOURCE_DESC	VARCHAR2	(240)
FE_PROGRAM_MARKER	VARCHAR2	(1)
FE_PROGRAM_MARKER_DESC	VARCHAR2	(240)
FEE_BAND	VARCHAR2	(30)
FEE_BAND_DESC	VARCHAR2	(240)
FUNDABILITY	VARCHAR2	(30)
FUNDABILITY_DESC	VARCHAR2	(240)
FTE_INTENSITY	NUMBER	(5)		FTE Intensity
TEACH_PERIOD_START_DT	DATE			Teaching period start date
TEACH_PERIOD_END_DT	DATE			Teaching period end date
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
IMPLIED_FUND_RATE	NUMBER			Implied rate of Council partial funding
GOV_INITIATIVES_CD	VARCHAR2	(30)		Government initiatives code
GOV_INITIATIVES_DESC	VARCHAR2	(240)		Government initiatives description
UNITS_FOR_QUAL	NUMBER			Number of units to achieve full qualification
DISADV_UPLIFT_ELIG_CD	VARCHAR2	(30)		Disadvantage uplift factor code
DISADV_UPLIFT_ELIG_DESC	VARCHAR2	(240)		Disadvantage uplift factor description
FRANCH_PARTNER_CD	VARCHAR2	(30)		Franchise Partner
FRANCH_PARTNER_DESC	VARCHAR2	(240)		Franchise Partner description
FRANCH_OUT_ARR_CD	VARCHAR2	(30)		Franchised out arrangements code
FRANCH_OUT_ARR_DESC	VARCHAR2	(240)		Franchised out arrangements description
EXCLUDE_FLAG	VARCHAR2	(1)		Flag to identify record for exclusion from HESA extract

Query Text

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


SELECT ROW_ID
,      HESA_ST_PROG_ID
,      COURSE_CD
,      SHORT_TITLE
,      VERSION_NUMBER
,      TEACHER_TRAIN_PROG_ID
,      TEACHER_TRAIN_PROG_DESC
,      ITT_PHASE
,      ITT_PHASE_DESC
,      BILINGUAL_ITT_MARKER
,      BILINGUAL_ITT_MARKER_DESC
,      TEACHING_QUAL_SOUGHT_SECTOR
,      TEACH_QUAL_SOUGHT_SECT_DESC
,      TEACHING_QUAL_SOUGHT_SUBJ1
,      TEACH_QUAL_SOUGHT_SUBJ1_DESC
,      TEACHING_QUAL_SOUGHT_SUBJ2
,      TEACH_QUAL_SOUGHT_SUBJ2_DESC
,      TEACHING_QUAL_SOUGHT_SUBJ3
,      TEACH_QUAL_SOUGHT_SUBJ3_DESC
,      LOCATION_OF_STUDY
,      LOCATION_OF_STUDY_DESC
,      OTHER_INST_PROV_TEACHING1
,      OTHER_INST_PROV_TEACHING1_DESC
,      OTHER_INST_PROV_TEACHING2
,      OTHER_INST_PROV_TEACHING2_DESC
,      PROP_TEACHING_IN_WELSH
,      PROP_NOT_TAUGHT
,      CREDIT_TRANSFER_SCHEME
,      CREDIT_TRANSFER_SCHEME_DESC
,      RETURN_TYPE
,      RETURN_TYPE_DESC
,      DEFAULT_AWARD
,      PROGRAM_CALC
,      LEVEL_APPLICABLE_TO_FUNDING
,      LEVEL_APPL_TO_FUNDING_DESC
,      FRANCHISING_ACTIVITY
,      FRANCHISING_ACTIVITY_DESC
,      NHS_FUNDING_SOURCE
,      NHS_FUNDING_SOURCE_DESC
,      FE_PROGRAM_MARKER
,      FE_PROGRAM_MARKER_DESC
,      FEE_BAND
,      FEE_BAND_DESC
,      FUNDABILITY
,      FUNDABILITY_DESC
,      FTE_INTENSITY
,      TEACH_PERIOD_START_DT
,      TEACH_PERIOD_END_DT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      IMPLIED_FUND_RATE
,      GOV_INITIATIVES_CD
,      GOV_INITIATIVES_DESC
,      UNITS_FOR_QUAL
,      DISADV_UPLIFT_ELIG_CD
,      DISADV_UPLIFT_ELIG_DESC
,      FRANCH_PARTNER_CD
,      FRANCH_PARTNER_DESC
,      FRANCH_OUT_ARR_CD
,      FRANCH_OUT_ARR_DESC
,      EXCLUDE_FLAG
FROM APPS.IGS_HE_ST_PRG_DTLS_V;

Dependencies

[top of page]

APPS.IGS_HE_ST_PRG_DTLS_V references the following:

APPS: IGS_HE_CODE_VALUES; IGS_HE_ST_PROG; IGS_LOOKUPS_VIEW; IGS_OR_INSTITUTION; IGS_PS_VER

APPS.IGS_HE_ST_PRG_DTLS_V is not referenced by any database object