Results for “entry_date”

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

Overview

IGS_SS_ADM_APPL_ALL is a core transactional table within the Oracle E-Business Suite Student System (IGS) product family, owned by the IGS schema. It stores all details of admission applications received online through self-service channels, functioning as the central repository for prospective-student application data in institutions running Oracle Student System on EBS 12.1.1 or 12.2.2. Each row represents a single admission application tied to a person, an admissions calendar instance, and an application source.

Under the documented relationship metadata, the table is heuristically classified as standalone for Data Vault modeling purposes. This classification is a modeling suggestion rather than a structural constraint: the only documented foreign key, SCH_APL_TO_ID, references IGS_AD_SCHL_APLY_TO, so no strong hub-and-link topology is evidenced. A Data Vault practitioner would typically model this table as a satellite attached to a PERSON hub, with admissions calendar context carried as referenced links or descriptive attributes.

Key Information Stored

The documented schema contains 58 columns. The surrogate primary key is SS_ADM_APPL_ID, enforced by unique index IGS_SS_ADM_APPL_ALL_PK. No separate business-key unique index is documented, so SS_ADM_APPL_ID is both the technical and the primary integration key.

• SS_ADM_APPL_ID — surrogate primary key uniquely identifying each online admission application.
• ORG_ID — operating unit / organization context, supporting multi-org access control.
• PERSON_ID / API_PERSON_ID — the applicant's person record; API_PERSON_ID links to the person created or matched during web application processing.
• APPL_STATUS / STATUS — application status indicators tracking lifecycle progress from submission through decision.
• APPL_SUBMIT_DATE — date the online application was submitted.
• ACAD_CAL_TYPE, ACAD_CAL_SEQ_NUMBER, ADM_CAL_TYPE, ADM_CAL_SEQ_NUMBER — academic and admissions calendar context identifying the target admission cycle.
• ADMISSION_CAT, S_ADM_PROCESS_TYPE, SOURCE_TYPE_ID, APP_SOURCE_ID — admission category, process type, and the source through which the application was received.
• SCH_APL_TO_ID — foreign key to IGS_AD_SCHL_APLY_TO, indicating the school or admit-to unit the applicant applied to.
• RESID_STAT_ID, VISA_TYPE, VISA_NUMBER, VISA_EXPIRY_DT, PASSPORT_NUMBER1 — residency, visa, and passport data captured for admissions eligibility and compliance.
• COMMON_APP — flag indicating whether the application originated from a common application service.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical reporting scenarios include admissions funnel analysis, application volume by calendar and source, and applicant-level extraction for downstream processing. A representative query joining the applicant to the person record:

• SELECT a.ss_adm_appl_id, a.person_id, a.appl_status, a.appl_submit_date, a.adm_cal_type, a.adm_cal_seq_number FROM igs.igs_ss_adm_appl_all a WHERE a.org_id = :org_id AND a.appl_submit_date BETWEEN :from_date AND :to_date;
• Counts by admit-to school: join to IGS_AD_SCHL_APLY_TO on SCH_APL_TO_ID to aggregate applications per school.
• Status pipeline reporting: group by APPL_STATUS and ADMISSION_CAT to monitor conversion rates across admission cycles.

Related Objects

• IGS_AD_SCHL_APLY_TO — referenced via SCH_APL_TO_ID; defines the school/admit-to unit for each application.
• IGS_SS_ADM_APPL_ALL_PK — the primary key unique index on SS_ADM_APPL_ID, guaranteeing application uniqueness.
• Person and applicant tables — joined through PERSON_ID / API_PERSON_ID to resolve applicant demographics.
• Calendar reference tables — ACAD_CAL_TYPE and ADM_CAL_TYPE resolve against academic and admissions calendar definitions.
• Admissions decision and status history tables — keyed by SS_ADM_APPL_ID to track processing outcomes.