Results for “igs_ad_ss_appl_typ_pk”

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

Overview

IGS_AD_SS_APPL_TYP is a configuration table within the Oracle E-Business Suite Student System (IGS) product family, historically associated with the Student Admission and Recruitment modules. The table holds Admission Application Type details, functioning as a reference and control entity that defines the categories of admission applications an institution recognizes—for example, undergraduate, postgraduate, transfer, or non-degree applications—together with the processing, fee, and accounting attributes attached to each type.

The ETRM metadata classifies this object as IGS – Student System (Obsolete). It is documented as "Not implemented in this database," meaning the physical table is not deployed in the referenced 12.1.1 environment. Its documented physical schema nonetheless defines an owner of IGS with 23 columns and a primary key, IGS_AD_SS_APPL_TYP_PK, built on ADMISSION_APPLICATION_TYPE.

From a Data Vault modeling standpoint, the heuristic classification provided is hub-leaning. This suggests the table is best modeled as a hub that anchors the business concept "Admission Application Type," with its descriptive and financial attributes potentially separated into an associated satellite. The extensive set of foreign keys emitted by dependent tables reinforces its role as a central reference point for the admission subtype.

Key Information Stored

Although the table exposes 23 columns, the most functionally significant are the following.

• ADMISSION_APPLICATION_TYPE — The primary key column and the unique business-key candidate, enforced through unique index IGS_AD_SS_APPL_TYP_U1. It is the identifier referenced throughout the admission data model.
• DESCRIPTION — The human-readable name of the application type.
• ADMISSION_CAT — Foreign key to IGS_AD_PRCS_CAT_ALL, linking the application type to an admission category used in processing rules and workflows.
• S_ADMISSION_PROCESS_TYPE — System-level admission process type controlling how applications of this type are handled.
• CONFIGURABILITY_FUNC_NAME — Name of the function used to drive configurability logic for this type.
• APPLICATION_FEE_AMOUNT — The fee charged when an applicant submits an application of this type.
• GL_REV_ACCT_CCID and GL_CASH_ACCT_CCID — General Ledger account code combinations for revenue and cash postings.
• REV_ACCOUNT_CODE and CASH_ACCOUNT_CODE — Accounting code values associated with revenue and cash handling.
• ENROLL_DEPOSIT_AMOUNT and ENROLL_DEPOSIT_LEVEL — Deposit amount and the level at which an enrollment deposit is required.
• USE_IN_APPL_SELF_SRVC — Flag indicating whether the type is available in applicant self-service.
• CLOSED_IND and SYSTEM_DEFAULT — Status and default-selection indicators.
• CRT_REV_INSTR, SUBMIT_INSTR, SUBMIT_ERR_INSTR — Instruction and error text presented to applicants.
• Standard audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on validating application types, presenting selection lists in self-service admission forms, and driving fee and deposit calculations. A common retrieval pattern selects active, self-service-visible types for a given category:

• List active application types: SELECT admission_application_type, description, application_fee_amount FROM igs_ad_ss_appl_typ WHERE closed_ind = 'N';
• Filter by category: join to IGS_AD_PRCS_CAT_ALL on ADMISSION_CAT to restrict results to a processing category.
• Self-service eligibility: filter on USE_IN_APPL_SELF_SRVC = 'Y' to populate applicant-facing LOVs.
• Fee and deposit reporting: aggregate APPLICATION_FEE_AMOUNT and ENROLL_DEPOSIT_AMOUNT by type for financial reconciliation.
• Accounting validation: examine GL_REV_ACCT_CCID and GL_CASH_ACCT_CCID to confirm correct GL mappings before go-live.

Because the table is documented as obsolete and not implemented, these queries are primarily applicable to legacy 11i-era IGS implementations and historical migrations.

Related Objects

The reference relationships define this table as a dependency hub. The most significant related objects are:

• IGS_AD_APPL_ALL — references via APPLICATION_TYPE; the principal applicant record table.
• IGS_AD_PRCS_CAT_ALL — referenced by this table through ADMISSION_CAT for processing categories.
• IGS_AD_APTYP_PESTAT — references on ADMISSION_APPLICATION_TYPE, mapping types to person statuses.
• IGS_AD_PESTAT_GROUP — references on ADMISSION_APPLICATION_TYPE, grouping statuses by type.
• IGS_AD_SS_TERMS and IGS_AD_SS_LOOKUPS — reference on ADMISSION_APPLICATION_TYPE for term and lookup configuration.
• IGS_AD_SS_TEST_CONF — references on ADMISSION_APPLICATION_TYPE for test configuration.
• IGS_AD_DEPLVL_PRGTY and IGS_AD_DEPLVL_PRG — reference on ADMISSION_APPLICATION_TYPE for deposit level programs.
• IGS_SS_ADM_APPL_STG and IGS_UC_DEFAULTS — staging and default tables referencing the application type.
• IGS_AD_SS_APPL_PGS — references on ADMISSION_APPLICATION_TYPE, linking application types to page configurations.