Table: IGS_PS_FLD_OF_STUDY_ALL | Oracle EBS ETRM Search

Table: IGS_PS_FLD_OF_STUDY_ALL 12.1.1 hub-leaning

owner IGS·IGS - Student System·11 columns

This entity describes the university set of fields of study. This is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values.

IGS.IGS_PS_FLD_OF_STUDY_ALL·Explore IGS module →

SYNONYM: APPS.IGS_PS_FLD_OF_STUDY_ALL 12.1.1

TABLE: IGS.IGS_PS_FLD_OF_STUDY_ALL 12.1.1

owner IGS

Table: IGS_PS_FLD_OF_STUDY_ALL 12.2.2

IGS - Student System (Obsolete)

This entity describes the university set of fields of study. This is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values.

Not implemented in this database·Explore IGS module →

APPS.IGS_PS_FLD_OF_STUDY_PKG dependencies on IGS_PS_FLD_OF_STUDY_ALL 12.1.1

APPS.IGS_AD_IMP_003 dependencies on IGS_PS_FLD_OF_STUDY_ALL 12.1.1

View: IGSBV_FIELDS_OF_STUDY 12.1.1

IGS - Student System·8 columns

This is the base view which describes university set of fields of study.

APPS.IGSBV_FIELDS_OF_STUDY·↳ IGS_PS_FLD_OF_STUDY_ALL·Explore IGS module →

APPS.IGS_PS_FLD_OF_STUDY_PKG SQL Statements 12.1.1

View: IGSFV_FIELDS_OF_STUDY 12.1.1

IGS - Student System·9 columns

This is the full view which describes university set of fields of study.

APPS.IGSFV_FIELDS_OF_STUDY·↳ IGS_PS_FLD_OF_STUDY_ALL·↳ IGS_RE_GV_FLD_OF_SDY·Explore IGS module →

View: IGS_HE_ST_PROG_CC_V 12.1.1

IGS - Student System·14 columns

Hesa Cost center details defined at Program Level

APPS.IGS_HE_ST_PROG_CC_V·↳ IGS_HE_CODE_VALUES·↳ IGS_HE_ST_PROG_CC·↳ IGS_PS_FLD_OF_STUDY_ALL·Explore IGS module →

View: IGSFV_AD_ACAD_INTEREST 12.1.1

IGS - Student System·13 columns

APPS.IGSFV_AD_ACAD_INTEREST·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_AD_ACAD_INTEREST·Explore IGS module →

View: IGS_PS_FLD_OF_STUDY 12.1.1

IGS - Student System·13 columns

APPS.IGS_PS_FLD_OF_STUDY·↳ IGS_LOOKUP_VALUES·↳ IGS_PS_FLD_OF_STUDY_ALL·Explore IGS module →

View: IGSFV_UNIT_FIELD_OF_STUDIES 12.1.1

IGS - Student System·10 columns

This is the full view, which describes the Field of Study with details unit code, version number, unit title, field of study and field of study description

APPS.IGSFV_UNIT_FIELD_OF_STUDIES·↳ IGS_PS_FLD_OF_STUDY_ALL·↳ IGS_PS_UNIT_FLD_STDY·↳ IGS_PS_UNIT_VER_ALL·Explore IGS module →

View: IGSFV_UNIT_STAT_COST_CENTRES 12.1.1

IGS - Student System·15 columns

Full View for UK Statistics Unit Cost Center Details

APPS.IGSFV_UNIT_STAT_COST_CENTRES·↳ IGS_HE_CODE_VALUES·↳ IGS_HE_ST_UV_CC_ALL·↳ IGS_PS_FLD_OF_STUDY_ALL·Explore IGS module →

View: IGS_HE_ST_SPA_CC_V 12.1.1

IGS - Student System·14 columns

Hesa Cost center details defined at Student Program Attempt Level

APPS.IGS_HE_ST_SPA_CC_V·↳ IGS_HE_CODE_VALUES·↳ IGS_HE_ST_SPA_CC·↳ IGS_PS_FLD_OF_STUDY_ALL·Explore IGS module →

View: IGS_HE_EN_SUSA_CC_V 12.1.1

IGS - Student System·16 columns

Hesa Cost center details defined at Student Unit Set Attempt Level

APPS.IGS_HE_EN_SUSA_CC_V·↳ IGS_HE_CODE_VALUES·↳ IGS_HE_EN_SUSA_CC·↳ IGS_PS_FLD_OF_STUDY_ALL·Explore IGS module →

PACKAGE: APPS.IGS_PS_FLD_OF_STUDY_PKG 12.1.1

used by 9

View: IGSFV_ST_PROG_ATT_COST_CENTRES 12.1.1

IGS - Student System·19 columns

Full business view to allow queries on Student Program Attempt Cost Center HESA details.

APPS.IGSFV_ST_PROG_ATT_COST_CENTRES·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_EN_STDNT_PS_ATT_ALL·Explore IGS module →

View: IGSFV_PRG_UK_STAT_COST_CENTRES 12.1.1

IGS - Student System·15 columns

Full View for UK Statistics Program Cost Center Details

APPS.IGSFV_PRG_UK_STAT_COST_CENTRES·↳ IGS_HE_CODE_VALUES·↳ IGS_HE_ST_PROG_CC·↳ IGS_PS_FLD_OF_STUDY_ALL·Explore IGS module →

View: IGSBV_UC_QUAL_DETAILS 12.1.1

IGS - Student System·26 columns

Base View for the qualifications awarded to an applicant

APPS.IGSBV_UC_QUAL_DETAILS·↳ HZ_PARTIES·↳ IGS_AS_GRD_SCH_GRADE·↳ IGS_PS_AWD·Explore IGS module →

PACKAGE BODY: APPS.IGS_PS_FLD_OF_STUDY_PKG 12.1.1

used by 9

VIEW: APPS.IGSFV_FIELDS_OF_STUDY 12.1.1

View: IGSFV_ST_UNIT_SET_ATT_COST_CNT 12.1.1

IGS - Student System·24 columns

Full business view to allow queries on Student Unit Set Attempt Cost Center HESA Details.

APPS.IGSFV_ST_UNIT_SET_ATT_COST_CNT·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_AS_SU_SETATMPT·Explore IGS module →

PACKAGE BODY: APPS.IGS_PS_FLD_OF_STUDY_PKG 12.1.1

Table: IGS_HE_EN_SUSA_CC 12.2.2

IGS - Student System (Obsolete)

Holds HESA Cost Center details defined at StudentUnit Set Attempt level

Not implemented in this database·Explore IGS module →

View: IGSFV_PRG_OFR_OPT_COST_CENTRES 12.1.1

IGS - Student System·29 columns

Full View for Program Offering Option Unit Set HESA Details - Cost Center Details

APPS.IGSFV_PRG_OFR_OPT_COST_CENTRES·↳ IGS_AD_LOCATION_ALL·↳ IGS_CA_TYPE·↳ IGS_EN_ATD_MODE_ALL·Explore IGS module →

Table: IGS_PS_UNIT_FLD_STDY 12.2.2

IGS - Student System (Obsolete)

To capture the relation between Units & Fields of Study

Not implemented in this database·Explore IGS module →

Table: IGS_PS_FACLTY_DISP 12.2.2

IGS - Student System (Obsolete)

Entity to capture the faculty's discipline details

Not implemented in this database·Explore IGS module →

View: IGS_UC_QUAL_DETS_V 12.1.1

IGS - Student System·25 columns

The qualification details view will display the qualifications awarded to an applicant

APPS.IGS_UC_QUAL_DETS_V·↳ HZ_PARTIES·↳ IGS_AS_GRD_SCH_GRADE·↳ IGS_LOOKUP_VALUES·Explore IGS module →

View: IGS_PR_ACAD_QUAL_CREDIT_V 12.1.1

IGS - Student System·17 columns

This view contains the details of credit granted through advanced standing based on the UK Qualifications structure. The credit is shown only as an aggregated summary figure.

APPS.IGS_PR_ACAD_QUAL_CREDIT_V·↳ HZ_PARTIES·↳ IGS_AV_STND_UNIT_LVL_ALL·↳ IGS_EN_STDNT_PS_ATT_ALL·Explore IGS module →

Table: IGS_RE_GV_FLD_OF_SDY 12.2.2

IGS - Student System (Obsolete)

This entity describes the Government set of fields of study.

Not implemented in this database·Explore IGS module →

View: IGSFV_UC_QUAL_DETAILS 12.1.1

IGS - Student System·31 columns

Full View for the qualifications awarded to an applicant

APPS.IGSFV_UC_QUAL_DETAILS·↳ HZ_PARTIES·↳ IGS_AS_GRD_SCH_GRADE·↳ IGS_PE_HZ_PARTIES·Explore IGS module →

Table: IGS_PS_US_FLD_STUDY 12.2.2

IGS - Student System (Obsolete)

This entity describes the field of study details for unit set.