Results for “prgm_action_type”

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

Overview

The IGS.IGS_SV_PRGMS_INFO table is a core operational table within the Oracle E-Business Suite IGS – Student System product. It stores program-related information that the Student and Exchange Visitor Information System (SEVIS) requires for foreign students and exchange visitors. In practice, the table captures the academic program attributes—majors, study levels, program dates, English proficiency indicators, and authorization or termination details—that must be reported to SEVIS for regulatory compliance. It is owned by the IGS schema, carries a VALID status, and is documented with 33 physical columns in ETRM 12.1.1.

From a Data Vault modeling perspective, the mined classification is satellite-leaning. This reflects the table’s role as a descriptive, attribute-bearing structure keyed by a composite business key rather than a pure hub or link. The primary key constraint, IGS_SV_PRGMS_INFO_PK, is composed of BATCH_ID, PERSON_ID, and PRGM_ACTION_TYPE, which together identify a specific program action submitted for a given person within a batch. The unique index IGS_SV_PRGMS_INFO_U1 mirrors this composite key, serving as the documented business-key candidate.

Key Information Stored

Among the 33 documented columns, the most significant are those that define identity, SEVIS action, and program context:

• BATCH_ID, PERSON_ID, PRGM_ACTION_TYPE — the composite primary key and business-key candidates, identifying the person and the specific program action within a submission batch.
• PRINT_FORM, FORM_STATUS_ID — controls whether a SEVIS form is printed and tracks its current status.
• POSITION_CODE, SUBJECT_FIELD_CODE — classification of the individual’s academic or exchange position.
• EDUCATION_LEVEL, EDUC_LVL_REMARKS — the study level reported to SEVIS, with supporting remarks.
• PRIMARY_MAJOR, SECONDARY_MAJOR, MINOR — the declared academic majors and minor fields.
• LENGTH_OF_STUDY, PRGM_START_DATE, PRGM_END_DATE — program duration and reporting dates.
• ENGLISH_REQD, ENGLISH_REQD_MET, NOT_REQD_REASON — English proficiency requirement status and justification when not applicable.
• AUTHORIZATION_REASON, TERMINATION_REASON, END_PRGM_REASON — reasons associated with program authorization and termination events.
• SEVIS_AUTH_ID — the foreign key tying the record to a SEVIS authorization.
• AUDIT columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) — standard who/when tracking for the row.

Common Use Cases and Queries

This table is most heavily used in SEVIS reporting, compliance reconciliation, and batch submission tracking. Typical scenarios include retrieving all program actions for a person, identifying pending forms, and reconciling submission batches.

A representative query to list program actions for a person:

SELECT PERSON_ID, PRGM_ACTION_TYPE, PRIMARY_MAJOR,
       PRGM_START_DATE, PRGM_END_DATE, FORM_STATUS_ID
FROM   IGS.IGS_SV_PRGMS_INFO
WHERE  PERSON_ID = :person_id
ORDER BY PRGM_START_DATE;

To find records awaiting form generation, filter on FORM_STATUS_ID and PRINT_FORM. To audit English requirement handling, aggregate by ENGLISH_REQD and ENGLISH_REQD_MET. Reporting extracts commonly join this table to IGS_SV_PERSONS on BATCH_ID and PERSON_ID to combine demographic and program context.

Related Objects

The documented foreign-key relationships and key structure identify the following significant related objects:

• IGS_SV_PERSONS — referenced via BATCH_ID and PERSON_ID; provides the person and batch context for each program record.
• IGS_EN_SVS_AUTH — referenced via SEVIS_AUTH_ID; supplies the SEVIS authorization details.

These relationships confirm the table’s position as a satellite entity depending on person-level and authorization-level parent data, making IGS_SV_PERSONS and IGS_EN_SVS_AUTH the primary integration points for SEVIS reporting and compliance joins.