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_PROGRAM_UK_STATISTICS

Object Details

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

View Type

A Business Intelligence System view

Full View for UK Statistics Program Details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
HESA_STATS_PROGRAM_ID	NUMBER	(6)	Yes	Sequence number uniquely identifying the HESA statistics Program records
PROGRAM_CODE	VARCHAR2	(6)	Yes	Unique identifier for a Program of Study
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Program of study Title
PROGRAM_SHORT_TITLE	VARCHAR2	(40)	Yes	Program of study Short Name
PROGRAM_ABBREVIATION	VARCHAR2	(20)	Yes	Program of study Abbreviation
PROGRAM_VERSION_NUMBER	NUMBER	(3)	Yes	Version Number of Program of Study
FE_PROGRAM_MARKER	VARCHAR2	(1)		FE program Marker, Indicates whether program of study is an FE program and how fee is quoted
FE_PROGRAM_MARKER_DESC	VARCHAR2	(240)		Fe Program Marker Code description
HESA_RETURN_TYPE	VARCHAR2	(3)		Type of HESA reduce return produced for students enrolled on this Program of Study
_LA:HESA_RETURN_TYPE_DESC	CHAR	(60)		Return type description
LOCATION_OF_STUDY	VARCHAR2	(30)		Location of study, Program value of HESA LOCSDY
LOCATION_OF_STUDY_DESC	VARCHAR2	(240)		Location of study description
CREDIT_TRANSFER_SCHEME	VARCHAR2	(30)		Credit Transfer Scheme, Program value of HESA CRDTSCM
CREDIT_TRANSFER_SCHEME_DESC	VARCHAR2	(240)		Credit transfer scheme description
LEVEL_APP_TO_FUNDING_COUNCIL	VARCHAR2	(30)		Level Applicable to funding council, Program value of HESA FUNDLEV
LEVEL_APP_FUNDING_COUNCIL_DESC	VARCHAR2	(240)		Level Applicable to funding council description
FUNDABILITY_CODE	VARCHAR2	(30)		Fundability, Program value of HESA FUNDCODE
FUNDABILITY_DESC	VARCHAR2	(240)		Fundability description
FEE_BAND	VARCHAR2	(30)		Fee Band, Program value of HESA FEEBAND
FEE_BAND_DESC	VARCHAR2	(240)		Fee Band Description
SOURCE_OF_DEPT_HEALTH_FUNDING	VARCHAR2	(30)		Source of Department of Health funding, Program value of HESA DHFUND
SOURCE_DEPT_HEALTH_FUND_DESC	VARCHAR2	(240)		Source of Department of Health funding description
FRANCHISING_ACTIVITY	VARCHAR2	(30)		Collaboration or Franchising activity, Program value of HESA FRANACT
FRANCHISING_ACTIVITY_DESC	VARCHAR2	(240)		Collaboration or Franchising activity description
OTHER_INST_PROV_TEACHING1	VARCHAR2	(30)		Other Institution providing teaching 1, Program value of HESA TINST1
OTHER_INST_PROV_TEACHING1_DESC	VARCHAR2	(360)		Other Institution providing teaching 1 Name
OTHER_INST_PROV_TEACHING2	VARCHAR2	(30)		Other Institution providing teaching 2, Program value of HESA TINST2
OTHER_INST_PROV_TEACHING2_DESC	VARCHAR2	(360)		Other Institution providing teaching 2 name
PROP_NOT_TAUGHT_BY_THIS_INST	NUMBER	(5)		Proportion not taught by this institution, Program value of HESA PCOLAB
PROP_TAUGHT_IN_WELSH	NUMBER	(5)		Proportion taught in Welsh, Program value of HESA PROWELSH
USE_PROGRAM_LEVEL_FOR_CALC	VARCHAR2	(1)		When set HESA year of program details are used to derive Cost Center, Subject code and proportions
FTE_INTENSITY	NUMBER	(5)		Standard Program Full Time Equivalent
TEACHING_PERIOD_START_DATE	DATE			Program value of FULL TIME EQUIVALENT default teaching calendar start date
TEACHING_PERIOD_END_DATE	DATE			Program value of FULL TIME EQUIVALENT default teaching calendar end date
TEACHER_TRAINING_PROGRAM_ID	VARCHAR2	(30)		Teacher training course identifier, Program value of HESA TTCID
TEACHER_TRAINING_PROGRAM_DESC	VARCHAR2	(240)		Teacher training course identifier description
ITT_PHASE_SCOPE	VARCHAR2	(30)		Initial Teacher Training Phase or Scope, Program value of HESA ITTPHSC Field
ITT_PHASE_SCOPE_DESC	VARCHAR2	(240)		Initial Teacher Training Phase or Scope description
BILINGUAL_ITT_MARKER	VARCHAR2	(30)		Bilingual Initial Teacher Training marker, Program value of HESA BITTM Field
BILINGUAL_ITT_MARKER_DESC	VARCHAR2	(240)		Bilingual Initial Teacher Training marker description
TEACH_QUAL_SOUGHT_SECTOR	VARCHAR2	(30)		Teaching qualification sought sector, Program value of HESA TQSSEC Field
TEACH_QUAL_SOUGHT_SECTOR_DESC	VARCHAR2	(240)		Teaching qualification sought sector description
TEACH_QUAL_SOUGHT_SUBJ1	VARCHAR2	(30)		Teaching qualification sought subject 1, Program value of HESA TQSSUB1 Field
TEACH_QUAL_SOUGHT_SUBJ1_DESC	VARCHAR2	(240)		Teaching qualification sought subject 1 description
TEACH_QUAL_SOUGHT_SUBJ2	VARCHAR2	(30)		Teaching qualification sought subject 2, Program value of HESA TQSSUB2 Field
TEACH_QUAL_SOUGHT_SUBJ2_DESC	VARCHAR2	(240)		Teaching qualification sought subject 2 description
TEACH_QUAL_SOUGHT_SUBJ3	VARCHAR2	(30)		Teaching qualification sought subject 3, Program value of HESA TQSSUB3 Field
TEACH_QUAL_SOUGHT_SUBJ3_DESC	VARCHAR2	(240)		Teaching qualification sought subject sector 3 description
IMPLIED_FUNDING_RATE	NUMBER			Implied Funding Rate.Returned as HESA IMPRATE
GOVERNMENT_INITIATIVES_CODE	VARCHAR2	(30)		Government Initiatives Code.Returned as HESA GOVINIT
GOVERNMENT_INITIATIVES_DESC	VARCHAR2	(240)		Government Initiatives Code Description
UNITS_TO_ACHIEVE_QUALIFICATION	NUMBER			Units To Achieved Qualification.Returned as HESA NOUNTACH
DISADVANTAGE_UPLIFT_ELIG_CODE	VARCHAR2	(30)		Disadvantage Uplift Eligibility Code.Returned as HESA ELISISUP
DISADVANTAGE_UPLIFT_ELIG_DESC	VARCHAR2	(240)		Disadvantage Uplift Eligibility Description
FRANCHISE_PARTNER_CODE	VARCHAR2	(30)		Franchise Partner Code.Returned as HESA FRANPART
FRANCHISE_PARTNER_DESC	VARCHAR2	(240)		Franchise Partner Code Description
FRANCHISED_OUT_ARRANGMNTS_CODE	VARCHAR2	(30)		Franchised Out Arrangements.Returned as HESA FROUTARR
FRANCHISED_OUT_ARRANGMNTS_DESC	VARCHAR2	(240)		Franchised Out Arrangements Description
EXCLUDE_FLAG	VARCHAR2	(1)		Flag to identify record for exclusion from HESA extract
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column indicates who created this record
CREATION_DATE	DATE		Yes	Standard WHO column indicates when this record was created
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column indicates who updated this record last
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column indicates when this record was last updated

Query Text

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


SELECT HESA_STATS_PROGRAM_ID
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      PROGRAM_SHORT_TITLE
,      PROGRAM_ABBREVIATION
,      PROGRAM_VERSION_NUMBER
,      FE_PROGRAM_MARKER
,      FE_PROGRAM_MARKER_DESC
,      HESA_RETURN_TYPE
,      _LA:HESA_RETURN_TYPE_DESC
,      LOCATION_OF_STUDY
,      LOCATION_OF_STUDY_DESC
,      CREDIT_TRANSFER_SCHEME
,      CREDIT_TRANSFER_SCHEME_DESC
,      LEVEL_APP_TO_FUNDING_COUNCIL
,      LEVEL_APP_FUNDING_COUNCIL_DESC
,      FUNDABILITY_CODE
,      FUNDABILITY_DESC
,      FEE_BAND
,      FEE_BAND_DESC
,      SOURCE_OF_DEPT_HEALTH_FUNDING
,      SOURCE_DEPT_HEALTH_FUND_DESC
,      FRANCHISING_ACTIVITY
,      FRANCHISING_ACTIVITY_DESC
,      OTHER_INST_PROV_TEACHING1
,      OTHER_INST_PROV_TEACHING1_DESC
,      OTHER_INST_PROV_TEACHING2
,      OTHER_INST_PROV_TEACHING2_DESC
,      PROP_NOT_TAUGHT_BY_THIS_INST
,      PROP_TAUGHT_IN_WELSH
,      USE_PROGRAM_LEVEL_FOR_CALC
,      FTE_INTENSITY
,      TEACHING_PERIOD_START_DATE
,      TEACHING_PERIOD_END_DATE
,      TEACHER_TRAINING_PROGRAM_ID
,      TEACHER_TRAINING_PROGRAM_DESC
,      ITT_PHASE_SCOPE
,      ITT_PHASE_SCOPE_DESC
,      BILINGUAL_ITT_MARKER
,      BILINGUAL_ITT_MARKER_DESC
,      TEACH_QUAL_SOUGHT_SECTOR
,      TEACH_QUAL_SOUGHT_SECTOR_DESC
,      TEACH_QUAL_SOUGHT_SUBJ1
,      TEACH_QUAL_SOUGHT_SUBJ1_DESC
,      TEACH_QUAL_SOUGHT_SUBJ2
,      TEACH_QUAL_SOUGHT_SUBJ2_DESC
,      TEACH_QUAL_SOUGHT_SUBJ3
,      TEACH_QUAL_SOUGHT_SUBJ3_DESC
,      IMPLIED_FUNDING_RATE
,      GOVERNMENT_INITIATIVES_CODE
,      GOVERNMENT_INITIATIVES_DESC
,      UNITS_TO_ACHIEVE_QUALIFICATION
,      DISADVANTAGE_UPLIFT_ELIG_CODE
,      DISADVANTAGE_UPLIFT_ELIG_DESC
,      FRANCHISE_PARTNER_CODE
,      FRANCHISE_PARTNER_DESC
,      FRANCHISED_OUT_ARRANGMNTS_CODE
,      FRANCHISED_OUT_ARRANGMNTS_DESC
,      EXCLUDE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_PROGRAM_UK_STATISTICS;

Dependencies

[top of page]

APPS.IGSFV_PROGRAM_UK_STATISTICS references the following:

APPS: HZ_PARTIES; IGS_HE_CODE_VALUES; IGS_HE_ST_PROG_ALL; IGS_PE_HZ_PARTIES; IGS_PS_VER_ALL

APPS.IGSFV_PROGRAM_UK_STATISTICS is not referenced by any database object