View: IGS_PR_STDNT_PR_AWD_V | Oracle EBS ETRM Search

View: IGS_PR_STDNT_PR_AWD_V 12.1.1

IGS - Student System·11 columns

This view stores the awards associated with the positive outcome of the rule for a student's program attempt.

APPS.IGS_PR_STDNT_PR_AWD_V·↳ IGS_PR_STDNT_PR_AWD·↳ IGS_PS_AWD·Explore IGS module →

View: IGS_PR_OU_AWD_V 12.1.1

IGS - Student System·11 columns

This view stores the awards associated with the rule for positive outcomes.

APPS.IGS_PR_OU_AWD_V·↳ IGS_PR_OU_AWD·↳ IGS_PS_AWD·Explore IGS module →

Table: IGS_GR_SPECIAL_AWARD_ALL 12.1.1 satellite-leaning

owner IGS·IGS - Student System·12 columns

This entity describes special awards that may be awarded to a graduand.

IGS.IGS_GR_SPECIAL_AWARD_ALL·Explore IGS module →

Table: IGS_PS_AWD_HNR_BASE 12.1.1 link

owner IGS·IGS - Student System·12 columns

Defines the basis on what the honors level of the student is to be derived. The definition will include the unit level and the weightage that is to be given to a particular unit level mark to arrive at the honors level of a student in a giv

IGS.IGS_PS_AWD_HNR_BASE·Explore IGS module →

View: IGS_HE_UT_LVL_AWARD_V 12.1.1

IGS - Student System·12 columns

Holds the Awards associated to a Tariff Level for a Calculation Type

APPS.IGS_HE_UT_LVL_AWARD_V·↳ IGS_HE_UT_LVL_AWARD·↳ IGS_PS_AWD·Explore IGS module →

View: IGS_GR_SPECIAL_AWARD 12.1.1

IGS - Student System·13 columns

APPS.IGS_GR_SPECIAL_AWARD·↳ IGS_GR_SPECIAL_AWARD_ALL·Explore IGS module →

Table: IGS_HE_UT_PRT_AWARD 12.1.1 link

owner IGS·IGS - Student System·8 columns

Holds the parent child Award relationships for a Calculation Type

IGS.IGS_HE_UT_PRT_AWARD·Explore IGS module →

Table: IGS_GR_AWD_CRM_US_GP 12.1.1 hub-leaning

owner IGS·IGS - Student System·15 columns

This entity describes the groups of unit sets which are being processed during the nominated graduation ceremony.

IGS.IGS_GR_AWD_CRM_US_GP·Explore IGS module →

View: IGS_PS_AWD_HNR_BASE_V 12.1.1

IGS - Student System·15 columns

Defines the configuration for calculating the marks at unt level.

APPS.IGS_PS_AWD_HNR_BASE_V·↳ IGS_LOOKUP_VALUES·↳ IGS_PS_AWD_HNR_BASE·↳ IGS_PS_UNIT_LEVEL_ALL·Explore IGS module →

View: IGS_EN_SPAA_V 12.1.1

IGS - Student System·16 columns

View for student program attempt award.

APPS.IGS_EN_SPAA_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_EN_SPA_AWD_AIM_V·Explore IGS module →

View: IGS_PS_AWD_V 12.1.1

IGS - Student System·16 columns

Stores the award setup

APPS.IGS_PS_AWD_V·↳ IGS_AS_GRD_SCHEMA·↳ IGS_GR_TESTAMUR_TYPE·↳ IGS_PS_AWD·Explore IGS module →

Table: IGS_PR_STDNT_PR_AWD 12.1.1 link

owner IGS·IGS - Student System·9 columns

Stores the awards associated with the positive outcome of the rule for a student's program attempt

IGS.IGS_PR_STDNT_PR_AWD·Explore IGS module →

Table: IGS_EN_SPA_AWD_AIM 12.1.1 satellite-leaning

owner IGS·IGS - Student System·17 columns

This table stores the information about maintenance of a student's targeted awards for each student program attempt, including start/end dates and completion flag.

IGS.IGS_EN_SPA_AWD_AIM·Explore IGS module →

Table: IGS_PS_AWD_OWN 12.1.1 satellite-leaning

owner IGS·IGS - Student System·11 columns

This entity describes the owner organizational unit of a program award.

IGS.IGS_PS_AWD_OWN·Explore IGS module →

View: IGS_HE_UT_PRT_AWARD_V 12.1.1

IGS - Student System·11 columns

Holds the parent child Award relationships for a Calculation Type

APPS.IGS_HE_UT_PRT_AWARD_V·↳ IGS_HE_UT_PRT_AWARD·↳ IGS_PS_AWD·Explore IGS module →

View: IGS_EN_SPA_AWD_AIM_V 12.1.1

IGS - Student System·18 columns

This view stores the information about maintenance of a student's targeted awards for each student program attempt, including start/end dates and completion flag.

APPS.IGS_EN_SPA_AWD_AIM_V·↳ IGS_EN_SPA_AWD_AIM·↳ IGS_PS_AWD·Explore IGS module →

Table: IGS_HE_UT_PRS_DTLS 12.1.1 link

owner IGS·IGS - Student System·10 columns

Holds Tariff Calculation details for a Person

IGS.IGS_HE_UT_PRS_DTLS·Explore IGS module →

Table: IGS_HE_UT_EXCL_QALS 12.1.1 link

owner IGS·IGS - Student System·9 columns

Holds the details of the Qualifications to be excluded from a particular Tariff Calculation

IGS.IGS_HE_UT_EXCL_QALS·Explore IGS module →

Table: IGS_PR_OU_AWD 12.1.1 link

owner IGS·IGS - Student System·9 columns

Stores the awards associated with the rule for positive outcomes.

IGS.IGS_PR_OU_AWD·Explore IGS module →

View: IGS_HE_UT_EXCL_QALS_V 12.1.1

IGS - Student System·12 columns

Stores the UCAS Tariff Qualifications to be Excluded from the Calculation Type

APPS.IGS_HE_UT_EXCL_QALS_V·↳ IGS_HE_UT_EXCL_QALS·↳ IGS_PS_AWD·↳ IGS_PS_FLD_OF_STUDY·Explore IGS module →

Table: IGS_PS_AWARD 12.1.1 satellite-leaning

owner IGS·IGS - Student System·11 columns

This entity describes the awards which completion of the program will attain for the student. The allowance has been made for zero to many awards per program.

IGS.IGS_PS_AWARD·Explore IGS module →

Table: IGS_HE_UT_LVL_AWARD 12.1.1 satellite-leaning

owner IGS·IGS - Student System·10 columns

Contains OSS Awards mapped to Tariff Levels

IGS.IGS_HE_UT_LVL_AWARD·Explore IGS module →

View: IGS_HE_UT_PRS_DTLS_V 12.1.1

IGS - Student System·12 columns

Holds the Exam level Tariff details for Persons and the Tariff Calculation Types for which the Tariff Calculation process had been run

APPS.IGS_HE_UT_PRS_DTLS_V·↳ IGS_HE_UT_PRS_DTLS·↳ IGS_PS_AWD·Explore IGS module →

Table: IGS_GR_AWD_CEREMONY_ALL 12.1.1 satellite-leaning

owner IGS·IGS - Student System·15 columns

This entity describes the awards which are being processed during the nominated graduation ceremony.

IGS.IGS_GR_AWD_CEREMONY_ALL·Explore IGS module →

View: IGS_GR_CRMN_ROUND_V 12.1.1

IGS - Student System·14 columns

APPS.IGS_GR_CRMN_ROUND_V·↳ IGS_GR_AWD_CEREMONY·↳ IGS_GR_AWD_CRM_US_GP·↳ IGS_GR_CRMN·Explore IGS module →

Table: IGS_PS_AWD 12.1.1 hub-leaning

owner IGS·IGS - Student System·13 columns

This entity describes an award offered by the university.

IGS.IGS_PS_AWD·Explore IGS module →

View: IGS_GR_GRADUAND_V 12.1.1

IGS - Student System·24 columns

APPS.IGS_GR_GRADUAND_V·↳ HZ_PARTIES·↳ IGS_GR_AWD_CRMN·↳ IGS_GR_GRADUAND·Explore IGS module →

Table: IGS_EN_SPAA_HIST 12.1.1 link

owner IGS·IGS - Student System·16 columns

Stores student program attempt award history

IGS.IGS_EN_SPAA_HIST·Explore IGS module →

View: IGS_GR_AWD_CEREMONY 12.1.1

IGS - Student System·16 columns

APPS.IGS_GR_AWD_CEREMONY·↳ IGS_GR_AWD_CEREMONY_ALL·Explore IGS module →

Table: IGS_EN_LGY_SPAA_INT 12.1.1 standalone

owner IGS·IGS - Student System·24 columns

Contains the Student Award Aim information to be imported into the IGS_EN_SPA_AWD_AIM table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table.

IGS.IGS_EN_LGY_SPAA_INT·Explore IGS module →

View: IGS_PR_STD_PRG_AWD_AIM_V 12.1.1

IGS - Student System·25 columns

This view stores the information about maintenance of a student's targeted awards for each student program attempt, including start/end dates and completion flag.

APPS.IGS_PR_STD_PRG_AWD_AIM_V·↳ HZ_PARTIES·↳ IGS_AS_SU_SETATMPT·↳ IGS_EN_SPA_AWD_AIM_V·Explore IGS module →

Table: IGS_GR_AWD_CRM_UT_ST 12.1.1 link

owner IGS·IGS - Student System·15 columns

This entity describes the unit sets which make up the unit set groups which are being processed during the nominated graduation ceremony.

IGS.IGS_GR_AWD_CRM_UT_ST·Explore IGS module →

View: IGS_GR_AWD_CRM_US_GP_V 12.1.1

IGS - Student System·15 columns

IGS_GR_AWD_CRM_US_GP_V is used to include group_title which is either the override_title or a derived value.

APPS.IGS_GR_AWD_CRM_US_GP_V·↳ IGS_GR_AWD_CRM_US_GP·↳ IGS_GR_GEN_001·Explore IGS module →

Table: IGS_AS_STU_TRN_CMTS 12.1.1 link

owner IGS·IGS - Student System·17 columns

Table to be populated with transcript comments for the student.