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: 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 →

Table: IGS_OR_UNIT_LOC 12.1.1 satellite-leaning

owner IGS·IGS - Student System·8 columns

This entity describes the intersection between organizational unit and location.

IGS.IGS_OR_UNIT_LOC·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 →

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 →

View: IGS_OR_UNIT_ACCT_CD_V 12.1.1

IGS - Student System·11 columns

revenue account string information for an organisation unit

APPS.IGS_OR_UNIT_ACCT_CD_V·↳ IGS_OR_UNIT_ACCT_CD·Explore IGS module →

View: IGS_OR_UNIT_ACCT_CD 12.1.1

IGS - Student System·11 columns

APPS.IGS_OR_UNIT_ACCT_CD·↳ IGS_OR_UNIT_ACCT_CD_ALL·Explore IGS 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 →

Table: IGS_OR_UNIT_ACCTS_ALL 12.1.1 standalone

owner IGS·IGS - Student System·12 columns

This table captures the entities and their respective orders in the account hierarchy defined in the table

IGS.IGS_OR_UNIT_ACCTS_ALL·Explore IGS module →

Table: IGS_OR_UNIT_ACCT_CD_ALL 12.1.1 satellite-leaning

owner IGS·IGS - Student System·10 columns

This table contains revenue account string information for an organization unit

IGS.IGS_OR_UNIT_ACCT_CD_ALL·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 →

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 →

Table: IGS_EN_SPI_RCONDS 12.1.1 link

owner IGS·IGS - Student System·13 columns

Student Program Intermission Return Conditions

IGS.IGS_EN_SPI_RCONDS·Explore IGS module →

View: IGS_OR_UNIT_ACCTS 12.1.1

IGS - Student System·13 columns

APPS.IGS_OR_UNIT_ACCTS·↳ IGS_OR_UNIT_ACCTS_ALL·Explore IGS module →

View: IGS_PE_PRG_ATP_V 12.1.1

IGS - Student System·13 columns

APPS.IGS_PE_PRG_ATP_V·↳ IGS_EN_STDNT_PS_ATT·↳ IGS_PS_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 →

View: IGS_EN_UNIT_SET_ACTIVE_V 12.1.1

IGS - Student System·11 columns

IGS_EN_UNIT_SET_ACTIVE_V describes the active unit sets that are available for a given specific period.

APPS.IGS_EN_UNIT_SET_ACTIVE_V·↳ IGS_EN_UNIT_SET·↳ IGS_EN_UNIT_SET_STAT·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: 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 →

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 →

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: 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 →

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_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 →

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 →

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_PS_USEC_X_GRP_V 12.1.1

IGS - Student System·16 columns

APPS.IGS_PS_USEC_X_GRP_V·↳ IGS_CA_INST·↳ IGS_PS_USEC_X_GRP·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_OR_UNIT_ACCTS_V 12.1.1