Results for “authorized_date”

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

Overview

IGSBV_AD_ADM_PS_APPL_INST is a view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It exposes admission application program detail data — that is, the record of an applicant's candidacy for a specific academic program, course, or admission offering. The view consolidates person identification, program selection, assessment metrics, decision processing, and offer/response lifecycle attributes into a single queryable structure, making it suitable for institutional reporting, applicant tracking dashboards, and integration extracts.

Because it is a view rather than a base table, it provides a denormalized, read-only projection that shields consumers from the underlying normalized admissions schema while presenting business-meaningful labels and lookups. In the context of the user search term offer_response_date, the relevant column is OFFER_RESPONSE_DT, which records the date on which an applicant responded to an offer of admission.

Underlying Base Objects

The view text references the base table alias APD, which corresponds to the admission application instance table (IGS_AD_APPL_INST), joined to person-related sources to obtain the party number and formatted person name. It also references PSV.TITLE, indicating a join to a program or program-version source that supplies the program title, and lookup-based decoding for flags such as FINAID_APPLY_DATE and CNDTNL_OFFER_MUST_BE_STSFD_IND.

The ETRM metadata for this object documents no explicit referenced base objects, and the view is marked VALID. The joins are implied by column aliases: APD.* columns derive from the admission application instance table, P.PARTY_NUMBER from the party/registry layer, and PP.PERSON_NAME from a person-name source. The flexfield reference '_DF:IGS:IGS_AD_APPL_INST_FLEX:APD' signals that descriptive flexfield context is attached to the APD record, while '_LA:' tokens denote lookup-value translations applied to coded flags.

Key Columns

• PERSON_ID / PARTY_NUMBER / PERSON_NAME — applicant identity and display name.
• ADMISSION_APPL_NUMBER / SEQUENCE_NUMBER — application and program-choice identifiers.
• COURSE_CD / NOMINATED_COURSE_CD / CRV_VERSION_NUMBER / TITLE — target program and version context.
• PREDICTED_GPA / ACADEMIC_INDEX / ASS_RANK / SECONDARY_ASS_RANK — assessment and ranking metrics.
• DECISION_DATE / DECISION_MAKE_ID / DECISION_REASON_ID / ADM_OUTCOME_STATUS — decision processing data.
• OFFER_DT — date the offer of admission was issued.
• OFFER_RESPONSE_DT — the date the applicant responded to the offer; central to offer-response tracking and the searched term.
• ACTUAL_RESPONSE_DT / ADM_OFFER_RESP_STATUS / ADM_OFFER_DFRMNT_STATUS — realized response date, response status, and deferment handling.
• PRPSD_COMMENCEMENT_DT / DEFERRED_ADM_CAL_TYPE — proposed commencement and deferral calendar context.
• ADM_CNDTNL_OFFER_STATUS / CNDTNL_OFFER_SATISFIED_DT — conditional offer state and satisfaction date.
• ADM_CAL_TYPE / ADM_CI_SEQUENCE_NUMBER — admission calendar and cycle identifiers.
• FINAID_APPLY_DATE / ENTRY_STATUS / ENTRY_LEVEL — financial-aid application date and entry classification.

Common Use Cases and Queries

Typical scenarios include monitoring turnaround between offer issuance and applicant response, measuring offer acceptance rates by program, and extracting applicant cohorts for downstream integration. A representative query filtering on the offer-response date follows:

• Offer-response interval: SELECT admission_appl_number, person_name, offer_dt, offer_response_dt, adm_offer_resp_status FROM igsbv_ad_adm_ps_appl_inst WHERE offer_response_dt BETWEEN :start_date AND :end_date ORDER BY offer_response_dt.
• Pending responses: filter WHERE offer_dt IS NOT NULL AND offer_response_dt IS NULL to identify applicants who have not yet responded to an outstanding offer.
• Program summary: aggregate COUNT(*) and acceptance counts grouped by nominated_course_cd, title, and adm_cal_type.
• Decision analysis: select decision_date, adm_outcome_status, adm_cndtNL_offer_status for outcome and conditional-offer reporting.

Because the view is read-only, all such queries should be issued with standard APPS security and reporting responsibilities; no DML is performed against the view itself.