View: IGS_FI_SUB_CA_INS_V | Oracle EBS ETRM Search

View: IGS_FI_SUB_CA_INS_V 12.1.1

This is for selecting the distinct records for person Id,Subaccount Id,Fee Calendar Type and Fee Calendar Instance.

APPS.IGS_FI_SUB_CA_INS_V·↳ IGS_CA_INST·↳ IGS_FI_INV_INT·Explore IGS module →

View: IGS_DA_EXPL_PRG_CAT_V 12.1.1

View is used to determine the program catalogs allowed to be displayed for the Explore Program Catalog LOV based on configuration of profiles setup and the user allowed to choose Explore Program options.

APPS.IGS_DA_EXPL_PRG_CAT_V·↳ FND_LOOKUP_VALUES·↳ IGS_AS_SU_SETATMPT·↳ IGS_CA_INST_ALL·Explore IGS module →

View: BEN_PER_CM_PCU_LOV_V 12.1.1

BEN - Advanced Benefits·11 columns

APPS.BEN_PER_CM_PCU_LOV_V·↳ BEN_ACTN_TYP·↳ BEN_CM_TYP_USG_F·↳ BEN_ENRT_PERD·Explore BEN module →

Table: IGS_PE_SN_SERVICE 12.1.1 link

owner IGS·IGS - Student System·12 columns

Holds details of a person's special need service information

IGS.IGS_PE_SN_SERVICE·Explore IGS module →

View: IGS_GR_GRD_PERD_ABBRVTN_V 12.1.1

IGS - Student System·5 columns

IGS_GR_GRD_PERD_ABBRVTN_V is used to manipulate graduation period abbreviation.

APPS.IGS_GR_GRD_PERD_ABBRVTN_V·↳ IGS_CA_INST·↳ IGS_CA_STAT·↳ IGS_CA_TYPE·Explore IGS module →

View: IGS_PE_SN_SERVICE_V 12.1.1

IGS - Student System·13 columns

Holds details of a person's special need contact information

APPS.IGS_PE_SN_SERVICE_V·↳ IGS_LOOKUP_VALUES·↳ IGS_PE_SN_SERVICE·Explore IGS module →

View: BEN_PER_CM_USG_D 12.2.2

BEN - Advanced Benefits·13 columns

APPS.BEN_PER_CM_USG_D·↳ BEN_ACTN_TYP·↳ BEN_CM_TYP_USG_F·↳ BEN_ENRT_PERD·Explore BEN module →

View: IGF_GR_REPORT_PELL_V 12.1.1

IGF - Financial Aid·15 columns

Holds Reporting Pell Identifiers for a Award Year

APPS.IGF_GR_REPORT_PELL_V·↳ IGF_GR_REPORT_PELL·↳ IGS_CA_INST·Explore IGF module →

View: IGS_PR_SCA_US_V 12.1.1

IGS - Student System·16 columns

APPS.IGS_PR_SCA_US_V·↳ IGS_AS_SU_SETATMPT·↳ IGS_EN_GEN_008·↳ IGS_EN_STDNT_PS_ATT·Explore IGS module →

View: IGS_OR_UNIT_HIST_V 12.1.1

IGS - Student System·17 columns

APPS.IGS_OR_UNIT_HIST_V·↳ HZ_PARTIES·↳ IGS_AU_GEN_003·↳ IGS_GE_DATE·Explore IGS module →

View: IGS_PR_RUL_OUTAPPL_V 12.1.1

IGS - Student System·3 columns

This view contains description about the prg calendar. It is the combination of cal type, alternate code, start dt,end dt, cal type,abbreviation etc.

APPS.IGS_PR_RUL_OUTAPPL_V·↳ IGS_CA_INST·↳ IGS_CA_STAT·↳ IGS_CA_TYPE·Explore IGS module →

Table: IGS_PR_CS_SCHDL 12.1.1 hub-leaning

owner IGS·IGS - Student System·10 columns

Maintains the schedule of Class Standing

IGS.IGS_PR_CS_SCHDL·Explore IGS module →

Table: IGS_FI_FEE_AS_RT_HT_ALL 12.1.1 link

owner IGS·IGS - Student System·19 columns

This entity describes special contract based fee assessment rates

IGS.IGS_FI_FEE_AS_RT_HT_ALL·Explore IGS module →

View: IGS_GR_GRD_PERD_V 12.1.1

IGS - Student System·4 columns

IGS_GR_GRD_PERD_V is used to maintain graduation period.

APPS.IGS_GR_GRD_PERD_V·↳ IGS_CA_INST·↳ IGS_CA_STAT·↳ IGS_CA_TYPE·Explore IGS module →

Table: IGS_PE_SN_SRVCE_INT 12.1.1 standalone

owner IGS·IGS - Student System·20 columns

contains the person special needs/service records to be imported to IGS_PE_SN_SERVICE.

IGS.IGS_PE_SN_SRVCE_INT·Explore IGS module →

View: IGS_PS_UNIT_OFFER_PAT_V 12.1.1

IGS - Student System·20 columns

APPS.IGS_PS_UNIT_OFFER_PAT_V·↳ IGS_CA_INST·↳ IGS_PS_UNIT_OFR_PAT·↳ IGS_PS_UNIT_VER·Explore IGS module →

View: IGS_FI_F_CAT_CA_INST_AS_V 12.1.1

IGS - Student System·11 columns

This view represents the columns of the fee_cat_cal_instance table as well as including columns representing the start and end dates from the cal_instance table. It returns only those records which have a system status of 'ACTIVE'. It is

APPS.IGS_FI_F_CAT_CA_INST_AS_V·↳ IGS_CA_INST·↳ IGS_FI_FEE_STR_STAT·↳ IGS_FI_F_CAT_CA_INST·Explore IGS module →

Table: IGS_CA_INST_ALL 12.1.1 hub

owner IGS·IGS - Student System·21 columns

Describes an instance of a calendar type

IGS.IGS_CA_INST_ALL·Explore IGS module →

View: IGS_CA_INST_PR_PERD_V 12.1.1

IGS - Student System·12 columns

APPS.IGS_CA_INST_PR_PERD_V·↳ IGS_CA_INST·↳ IGS_CA_INST_REL·↳ IGS_CA_STAT·Explore IGS module →

View: IGS_PE_PERSON_ADDR_GOVT_PERM_V 12.1.1

IGS - Student System·13 columns

IGS_PE_PERSON_ADDR_GOVT_PERM_V describes the permanent address

APPS.IGS_PE_PERSON_ADDR_GOVT_PERM_V·↳ IGS_PE_PERSON_ADDR·Explore IGS module →

View: BEN_PER_CM_USG_D 12.1.1

BEN - Advanced Benefits·13 columns

APPS.BEN_PER_CM_USG_D·↳ BEN_ACTN_TYP·↳ BEN_CM_TYP_USG_F·↳ BEN_ENRT_PERD·Explore BEN module →

View: IGS_PR_CS_SCHDL_V 12.1.1

IGS - Student System·13 columns

Shows the Class Standing schedule

APPS.IGS_PR_CS_SCHDL_V·↳ IGS_LOOKUPS_VIEW·↳ IGS_PR_CS_SCHDL·↳ IGS_PS_TYPE·Explore IGS module →

Table: IGS_FI_GV_DSP_HEC_CN 12.1.1 link

owner IGS·IGS - Student System·9 columns

This table describes the mappings of government discipline groups to contribution bands.

IGS.IGS_FI_GV_DSP_HEC_CN·Explore IGS module →

View: IGF_AP_APPL_SETUP_V 12.1.1

IGF - Financial Aid·9 columns

APPS.IGF_AP_APPL_SETUP_V·↳ IGF_AP_APPL_SETUP·↳ IGS_CA_INST·Explore IGF 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 →

Table: IGS_EN_SEVIS_AUTH 12.1.1 standalone

owner IGS·IGS - Student System·14 columns

Obsolete

IGS.IGS_EN_SEVIS_AUTH·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_RE_SCHOLARSHIP_ALL 12.1.1 link

owner IGS·IGS - Student System·15 columns

This entity describes the details of scholarships

IGS.IGS_RE_SCHOLARSHIP_ALL·Explore IGS module →

View: IGS_AD_ADM_UT_STA_GD_V 12.1.1

IGS - Student System·15 columns

Describes the grading schema code grades applicable to an administrative unit status. This caters for versions of the grading schema code. At any point in time, there should be only one grading schema code grade applicable.

APPS.IGS_AD_ADM_UT_STA_GD_V·↳ IGS_AD_ADM_UT_STA_GD·↳ IGS_AS_GRD_SCHEMA·↳ IGS_AS_GRD_SCH_GRADE·Explore IGS module →

View: IGS_PS_FAC_CAL_INST_V 12.1.1

IGS - Student System·15 columns

APPS.IGS_PS_FAC_CAL_INST_V·↳ IGS_CA_INST·↳ IGS_PE_PERSON_BASE_V·↳ IGS_PS_UNIT_OFR_OPT_ALL·Explore IGS module →

View: IGS_CO_INTERACTION_HISTORY_V 12.1.1

IGS - Student System·26 columns

Interaction History

APPS.IGS_CO_INTERACTION_HISTORY_V·↳ IBC_CITEMS_V·↳ IGS_CA_INST·↳ IGS_CO_INTERAC_HIST·Explore IGS module →

View: IGS_EN_EFFECTIVE_TERMS_V 12.1.1

IGS - Student System·8 columns

View fetches the current term, one previous term and one next term for the academic calendar.

APPS.IGS_EN_EFFECTIVE_TERMS_V·↳ IGS_CA_INST·↳ IGS_CA_TYPE·↳ IGS_EN_SPA_TERMS_API·Explore IGS module →