Results for “igs_ad_ss_appl_typ_u1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS.IGS_AD_SS_APPL_TYP is a transactional configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environment, owned by the IGS schema (Oracle Student System / iRecruitment and Admissions). It serves as the master reference for Self Service Admission Application Types, defining the distinct categories of admission applications that can be created and submitted through self-service channels. Each row represents one application type and drives downstream behavior including fee calculation, revenue and cash account derivation, enrollment deposit handling, and self-service availability.

The table resides in the APPS_TS_TX_DATA tablespace, with its unique and non-unique indexes held in APPS_TS_TX_IDX. From a Data Vault modeling perspective, the mined FK structure suggests a hub-leaning classification: ADMISSION_APPLICATION_TYPE acts as the stable business key, and the table anchors numerous dependent satellites and links rather than existing purely as a transactional fact.

Key Information Stored

The primary key, constraint IGS_AD_SS_APPL_TYP_PK, is defined on ADMISSION_APPLICATION_TYPE. A separate unique index, IGS_AD_SS_APPL_TYP_U1, also covers ADMISSION_APPLICATION_TYPE, reinforcing it as the definitive business-key candidate. The remaining columns fall into functional groupings:

• Identity and description: ADMISSION_APPLICATION_TYPE (the key), DESCRIPTION, and CLOSED_IND (whether the type is inactive and unavailable for new submissions).
• Categorization: ADMISSION_CAT and S_ADMISSION_PROCESS_TYPE tie the application type to an admission category and its system-level process behavior.
• Financial configuration: APPLICATION_FEE_AMOUNT, ENROLL_DEPOSIT_AMOUNT, ENROLL_DEPOSIT_LEVEL, GL_REV_ACCT_CCID, GL_CASH_ACCT_CCID, REV_ACCOUNT_CODE, and CASH_ACCOUNT_CODE govern fee and deposit amounts plus GL account derivation.
• Behavioral controls: CONFIGURABILITY_FUNC_NAME, SYSTEM_DEFAULT (flags the default application type), and USE_IN_APPL_SELF_SRVC (governs self-service visibility).
• Instructional text: CRT_REV_INSTR, SUBMIT_INSTR, and SUBMIT_ERR_INSTR hold user-facing guidance and error messages.
• WHO audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include populating application-type selection lists in self-service flows, validating fee and deposit configuration, and reporting on active versus closed types. A representative query to list active, self-service-enabled types with their fees:

SELECT admission_application_type,
       description,
       application_fee_amount,
       enroll_deposit_amount
FROM   igs.igs_ad_ss_appl_typ
WHERE  closed_ind = 'N'
AND    use_in_appl_self_srvc = 'Y';

Financial reconciliation queries join GL_REV_ACCT_CCID to the GL code combination table to trace revenue postings. Configuration audits compare SYSTEM_DEFAULT flags to ensure exactly one default type exists, while integration checks verify that admission applications reference valid, non-closed types.

Related Objects

IGS_AD_SS_APPL_TYP participates in a rich dependency network. It references IGS_AD_PRCS_CAT_ALL via ADMISSION_CAT. Numerous tables reference it through ADMISSION_APPLICATION_TYPE, including:

• IGS_AD_APPL_ALL (APPLICATION_TYPE) — the core admission application record.
• IGS_AD_SS_APPL_PGS and IGS_SS_ADM_APPL_STG — self-service application pages and staging.
• IGS_AD_SS_TEST_CONF and IGS_AD_SS_TERMS — test configuration and term linkage.
• IGS_AD_APTYP_PESTAT and IGS_AD_PESTAT_GROUP — personal status mapping.
• IGS_AD_DEPLVL_PRGTY and IGS_AD_DEPLVL_PRG — enrollment deposit level and program priority rules.
• IGS_UC_DEFAULTS — defaults used by the UCAS admissions integration.
• IGS_AD_SS_LOOKUPS — lookup values scoped by application type.

These relationships make IGS_AD_SS_APPL_TYP a central configuration hub whose modifications propagate across self-service admissions, financial aid, and external admissions integration processes.