[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
IGS.IGS_HE_ST_PROG_ALL does not reference any database object
IGS.IGS_HE_ST_PROG_ALL is referenced by following:
|
|
|