[Home] [Help] [Dependency Information]
Object Name: | IGS_HE_ST_PROG |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_HE_ST_PROG |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Stores HESA Program details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
HESA_ST_PROG_ID | NUMBER | (6) | Yes | |
COURSE_CD | VARCHAR2 | (6) | Yes | |
VERSION_NUMBER | NUMBER | (3) | Yes | |
TEACHER_TRAIN_PROG_ID | VARCHAR2 | (30) | ||
ITT_PHASE | VARCHAR2 | (30) | ||
BILINGUAL_ITT_MARKER | VARCHAR2 | (30) | ||
TEACHING_QUAL_SOUGHT_SECTOR | VARCHAR2 | (30) | ||
TEACHING_QUAL_SOUGHT_SUBJ1 | VARCHAR2 | (30) | ||
TEACHING_QUAL_SOUGHT_SUBJ2 | VARCHAR2 | (30) | ||
TEACHING_QUAL_SOUGHT_SUBJ3 | VARCHAR2 | (30) | ||
LOCATION_OF_STUDY | VARCHAR2 | (30) | ||
OTHER_INST_PROV_TEACHING1 | VARCHAR2 | (30) | ||
OTHER_INST_PROV_TEACHING2 | VARCHAR2 | (30) | ||
PROP_TEACHING_IN_WELSH | NUMBER | (5) | ||
PROP_NOT_TAUGHT | NUMBER | (5) | ||
CREDIT_TRANSFER_SCHEME | VARCHAR2 | (30) | ||
RETURN_TYPE | VARCHAR2 | (3) | ||
DEFAULT_AWARD | VARCHAR2 | (30) | ||
PROGRAM_CALC | VARCHAR2 | (1) | ||
LEVEL_APPLICABLE_TO_FUNDING | VARCHAR2 | (30) | ||
FRANCHISING_ACTIVITY | VARCHAR2 | (30) | ||
NHS_FUNDING_SOURCE | VARCHAR2 | (30) | ||
FE_PROGRAM_MARKER | VARCHAR2 | (1) | ||
FEE_BAND | VARCHAR2 | (30) | ||
FUNDABILITY | VARCHAR2 | (30) | ||
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 | 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 | |
UNITS_FOR_QUAL | NUMBER | Number of units to achieve full qualification | ||
DISADV_UPLIFT_ELIG_CD | VARCHAR2 | (30) | Disadvantage uplift factor | |
FRANCH_PARTNER_CD | VARCHAR2 | (30) | Franchise Partner | |
FRANCH_OUT_ARR_CD | VARCHAR2 | (30) | Franchised out arrangements | |
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 ROW_ID
, HESA_ST_PROG_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 APPS.IGS_HE_ST_PROG;
|
|
|