Results for “admission_process_category”
15 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGS_AD_SS_PRC_CAT_V view is a reporting and integration object within the Oracle E-Business Suite IGS – Student System product family. It is owned by the APPS schema and is delivered with a status of VALID in both Oracle EBS 12.1.1 and 12.2.2. The view presents admission process categories in a denormalized, presentation-ready form, combining a coded identifier with its human-readable lookup meaning so that downstream reports, self-service pages, and integration interfaces do not need to perform their own joins against the lookup tables. The distinctive naming convention — the SS segment typically denoting a self-service or summary-oriented construct — indicates that this view is intended primarily for read-only consumption rather than for transactional maintenance. Users searching for the term "admission_process_category" are typically attempting to resolve how the composite admission process category label is derived, and this view is the documented source for that value. Because it exposes a concatenated display string alongside the raw code, it is well suited for list-of-values (LOV) definitions, concurrent program parameters, and BI Publisher data templates within the Student System module.
Underlying Base Objects
The view is defined over three documented base objects in the APPS schema:
- IGS_AD_PRCS_CAT — the admission process category table, aliased
APC, which supplies the primaryADMISSION_CATcode and theS_ADMISSION_PROCESS_TYPEdiscriminator. - IGS_AD_CAT — the admission category table, aliased
AC, which is joined onADMISSION_CATand filtered so that only records whereNVL(CLOSED_IND, 'N') = 'N'are returned. This means categories flagged as closed are excluded from the view. - IGS_LOOKUPS_VIEW — the standard Oracle lookups view, aliased
ILV, which resolves theS_ADMISSION_PROCESS_TYPEcode against theADMISSION_PROCESS_TYPElookup type to produce the meaningful description.
Although the ETRM metadata records no formal referenced base objects, the view text documents this three-table join explicitly. The join between the process category and category tables is an inner join on ADMISSION_CAT, and the lookup join is an equality between ILV.LOOKUP_CODE and APC.S_ADMISSION_PROCESS_TYPE restricted to the correct lookup type.
Key Columns
- ADMISSION_PROCESS_CATEGORY — the composite display value, formed as
APC.ADMISSION_CAT || '/' || ILV.MEANING. This is the column most directly associated with the "admission_process_category" search term. - ADMISSION_CAT — the raw admission category code from the base table, retained so that consumers can join or filter programmatically without parsing the concatenated string.
- S_ADMISSION_PROCESS_TYPE — the admission process type code used as the lookup discriminator, useful for grouping or filtering categories by process type.
Common Use Cases and Queries
Typical scenarios include populating an LOV for an admission category parameter, driving self-service selection lists, and feeding extract programs. A representative query returning all active admission process categories follows:
SELECT admission_process_category, admission_cat, s_admission_process_type FROM apps.igs_ad_ss_prc_cat_v ORDER BY admission_process_category;
To restrict results to a single process type, add a predicate on s_admission_process_type:
SELECT admission_process_category FROM apps.igs_ad_ss_prc_cat_v WHERE s_admission_process_type = :p_process_type;
Because closed categories are already filtered out by the view definition, consumers do not need to re-apply the CLOSED_IND condition. All queries should be issued against the APPS schema with the appropriate MO or responsibility context, and results should be treated as read-only.
-
View: IGS_AD_SS_PRC_CAT_V 12.1.1
APPS.IGS_AD_SS_PRC_CAT_V·↳ IGS_AD_CAT·↳ IGS_AD_PRCS_CAT·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
View: IGS_AD_SS_APPL_TYP_V 12.1.1
APPS.IGS_AD_SS_APPL_TYP_V·↳ FND_FORM_FUNCTIONS_VL·↳ IGS_AD_CAT·↳ IGS_AD_PRCS_CAT·Explore IGS module →
-
Admission Interview Letters
APPS.IGS_AD_INTERVIEW_LETTERS_V·↳ HZ_PARTIES·↳ IGS_AD_APPL_ADMAPPL_V·↳ IGS_AD_APPL_ALL·Explore IGS module →
-
The validations for the individual letters are placed at the SQLl query level that we attach to master document
APPS.IGS_AD_OUTCOME_LETTERS_V·↳ HZ_PARTIES·↳ IGS_AD_APPL_ADMAPPL_V·↳ IGS_AD_APPL_ALL·Explore IGS module →
-
View: IGS_AD_SS_PRC_CAT_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_AD_SS_APPL_TYP_V 12.2.2
Not implemented in this database·Explore IGS module →
-
Admission Interview Letters
Not implemented in this database·Explore IGS module →
-
The validations for the individual letters are placed at the SQLl query level that we attach to master document
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.