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]

TABLE: IGS.IGS_HE_ST_PROG_ALL

Object Details

Object Name:	IGS_HE_ST_PROG_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_HE_ST_PROG_ALL
Subobject Name:
Status:	VALID

IGS_HE_ST_PROG_ALL stores the Program Version HESA details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_HE_ST_PROG_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HESA_ST_PROG_ID
IGS_HE_ST_PROG_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	COURSE_CD VERSION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
HESA_ST_PROG_ID	NUMBER	(6)	Yes	Sequence generated identifier for each record
ORG_ID	NUMBER	(15)		Org Identifier
COURSE_CD	VARCHAR2	(6)	Yes	Program Code
VERSION_NUMBER	NUMBER	(3)	Yes	Program Version Number
TEACHER_TRAIN_PROG_ID	VARCHAR2	(30)		Teacher training program Identifier
ITT_PHASE	VARCHAR2	(30)		ITT phase
BILINGUAL_ITT_MARKER	VARCHAR2	(30)		Bilingual ITT marker
TEACHING_QUAL_SOUGHT_SECTOR	VARCHAR2	(30)		Teaching qualification sought sector
TEACHING_QUAL_SOUGHT_SUBJ1	VARCHAR2	(30)		Teaching qualification sought for subject
TEACHING_QUAL_SOUGHT_SUBJ2	VARCHAR2	(30)		Teaching qualification sought for subject
TEACHING_QUAL_SOUGHT_SUBJ3	VARCHAR2	(30)		Teaching qualification sought for subject
LOCATION_OF_STUDY	VARCHAR2	(30)		Location of study
OTHER_INST_PROV_TEACHING1	VARCHAR2	(30)		Other institution teaching this unit
OTHER_INST_PROV_TEACHING2	VARCHAR2	(30)		Other institution teaching this unit
PROP_TEACHING_IN_WELSH	NUMBER	(5)		Proportion taught in Welsh
PROP_NOT_TAUGHT	NUMBER	(5)		Proportion of unit not Taught at this institution
CREDIT_TRANSFER_SCHEME	VARCHAR2	(30)		Credit Transfer Scheme
RETURN_TYPE	VARCHAR2	(3)		Return type of the submission
DEFAULT_AWARD	VARCHAR2	(30)		Award Code
PROGRAM_CALC	VARCHAR2	(1)		Indicator of whether calculation should be at Program level or at Unit level
LEVEL_APPLICABLE_TO_FUNDING	VARCHAR2	(30)		Level of Funding
FRANCHISING_ACTIVITY	VARCHAR2	(30)		Franchising Activity
NHS_FUNDING_SOURCE	VARCHAR2	(30)		Funding Source code
FE_PROGRAM_MARKER	VARCHAR2	(1)		Fresh Entrant Program Marker, code which identifies if this program is an FE program or not
FEE_BAND	VARCHAR2	(30)		Fee Band
FUNDABILITY	VARCHAR2	(30)		Fundability Code
FTE_INTENSITY	NUMBER	(5)		Full Time Equivalent Intensity
TEACH_PERIOD_START_DT	DATE			Teaching Period start date
TEACH_PERIOD_END_DT	DATE			Teaching Period end date
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
IMPLIED_FUND_RATE	NUMBER			Implied rate of Council partial funding
GOV_INITIATIVES_CD	VARCHAR2	(30)		Government initiatives code
UNITS_FOR_QUAL	NUMBER			Number of units to achieve full qualification
DISADV_UPLIFT_ELIG_CD	VARCHAR2	(30)		Disadvantage uplift factor code
FRANCH_PARTNER_CD	VARCHAR2	(30)		Franchise Partner code
FRANCH_OUT_ARR_CD	VARCHAR2	(30)		Franchised out arrangements code
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 HESA_ST_PROG_ID
,      ORG_ID
,      COURSE_CD
,      VERSION_NUMBER
,      TEACHER_TRAIN_PROG_ID
,      ITT_PHASE
,      BILINGUAL_ITT_MARKER
,      TEACHING_QUAL_SOUGHT_SECTOR
,      TEACHING_QUAL_SOUGHT_SUBJ1
,      TEACHING_QUAL_SOUGHT_SUBJ2
,      TEACHING_QUAL_SOUGHT_SUBJ3
,      LOCATION_OF_STUDY
,      OTHER_INST_PROV_TEACHING1
,      OTHER_INST_PROV_TEACHING2
,      PROP_TEACHING_IN_WELSH
,      PROP_NOT_TAUGHT
,      CREDIT_TRANSFER_SCHEME
,      RETURN_TYPE
,      DEFAULT_AWARD
,      PROGRAM_CALC
,      LEVEL_APPLICABLE_TO_FUNDING
,      FRANCHISING_ACTIVITY
,      NHS_FUNDING_SOURCE
,      FE_PROGRAM_MARKER
,      FEE_BAND
,      FUNDABILITY
,      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
,      UNITS_FOR_QUAL
,      DISADV_UPLIFT_ELIG_CD
,      FRANCH_PARTNER_CD
,      FRANCH_OUT_ARR_CD
,      EXCLUDE_FLAG
FROM IGS.IGS_HE_ST_PROG_ALL;

Dependencies

[top of page]

IGS.IGS_HE_ST_PROG_ALL does not reference any database object

IGS.IGS_HE_ST_PROG_ALL is referenced by following:

APPS: IGS_HE_ST_PROG_ALL