Results for “person_id_long”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_SV_UPD_DPND_BLK_V is a PL/SQL view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to supply the row-level data required to construct the XML block that describes updated dependent information for a student. In the context of the IGS Student System, this view forms part of the seeding infrastructure used by the SEVIS (Student and Exchange Visitor Information System) processing and reporting flows, where dependent records that have undergone an update action must be extracted and formatted for transmission or reporting.
Because the view filters on the dependent action type, it presents a purpose-built result set rather than a full copy of the underlying dependent data. This makes it suitable for batch-driven integrations, concurrent program data sources, and XML generation routines that require only those dependent records flagged as updated.
Underlying Base Objects
The view is defined over a single documented base object, IGS_SV_DEPDNT_INFO, aliased as DPDT in the view text. The ETRM metadata records no additional referenced base objects. All columns exposed by the view are projected directly from IGS_SV_DEPDNT_INFO, with the exception of three columns that are populated as literal NULL values or aliases.
The defining predicate is WHERE DPDT.DEPDNT_ACTION_TYPE = 'U', restricting output to dependent records whose action type indicates an update. There is no join logic in the view, so each row in the view corresponds to exactly one qualifying row in IGS_SV_DEPDNT_INFO. The view therefore acts as a filtered projection, not an aggregation or a join-derived structure.
Key Columns
- BATCH_ID — Identifier of the batch to which the dependent update record belongs, used to group output for processing runs.
- PERSON_ID — The person identifier of the student or primary record associated with the dependent.
- PRINT_FORM — Flag or indicator controlling whether the dependent record is included in printed form output.
- DEPDNT_ID — The unique identifier for the dependent record itself.
- PERSON_NUMBER — Exposed as a literal NULL in the view text; the person number is not sourced from the base table.
- DEPDNT_SEVIS_ID — The SEVIS identifier assigned to the dependent, central to SEVIS reporting.
- LAST_NAME, FIRST_NAME, MIDDLE_NAME, SUFFIX — Name components of the dependent.
- BIRTH_DATE, GENDER, BIRTH_CNTRY_CODE — Demographic attributes of the dependent.
- CITIZENSHIP_CNTRY_CODE — Exposed as an alias over the base column CITIZEN_CNTRYY_CODE.
- VISA_TYPE, RELATIONSHIP, REMARKS — Visa classification, relationship to the student, and free-text remarks.
- PERSON_ID_LONG — Listed in the view columns and returned as a literal NULL, matching the user's search term; no long person identifier is populated by this view.
Common Use Cases and Queries
The primary use case is extraction of updated dependent data for XML block generation within the IGS SEVIS interface. A typical query retrieves all updated dependents for a given batch:
SELECT batch_id, person_id, depdnt_id, last_name, first_name, relationship FROM igs_sv_upd_dpnd_blk_v WHERE batch_id = :p_batch_id;SELECT person_id, depdnt_sevis_id, birth_date, gender FROM igs_sv_upd_dpnd_blk_v WHERE person_id = :p_person_id;SELECT * FROM igs_sv_upd_dpnd_blk_v ORDER BY batch_id, depdnt_id;
Note that queries referencing PERSON_ID_LONG or PERSON_NUMBER will return NULL, since both columns are deliberately exposed as placeholders. Any downstream logic requiring the long person identifier must obtain it from another source.
-
View: IGS_SV_UPD_DPND_BLK_V 12.1.1
View for obtaining information for the XML block describing the updated dependent information for the student.
APPS.IGS_SV_UPD_DPND_BLK_V·↳ IGS_SV_DEPDNT_INFO·Explore IGS module →
-
View: IGS_SV_PRGM_DUM_V 12.1.1
View for fetching Program information for student.
APPS.IGS_SV_PRGM_DUM_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_OPT_EMPL_DUM_V 12.1.1
View for fetching OPT employment details for students.
APPS.IGS_SV_OPT_EMPL_DUM_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_ACT_DPND_BLK_V 12.1.1
View for obtaining information for the XML block describing the activation of dependent for the student.
APPS.IGS_SV_ACT_DPND_BLK_V·↳ IGS_SV_DEPDNT_INFO·Explore IGS module →
-
View: IGS_SV_EV_VALDTE_DUM_V 12.1.1
View for fetching information for validate element of XML
APPS.IGS_SV_EV_VALDTE_DUM_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_OFF_EMPL_DUM_V 12.1.1
View for fetching off campus employment informations for students
APPS.IGS_SV_OFF_EMPL_DUM_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_CNCL_DPND_BLK_V 12.1.1
View for fetching the details about dependents that are getting terminated
APPS.IGS_SV_CNCL_DPND_BLK_V·↳ IGS_SV_DEPDNT_INFO·Explore IGS module →
-
View: IGS_SV_CPT_EMPL_DUM_V 12.1.1
View for fetching CPT employment records
APPS.IGS_SV_CPT_EMPL_DUM_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View for update financial information for Exchange Visitor in the XML file being sent to SEVIS.
APPS.IGS_SV_EV_UPD_FIN_BLK_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_FINANCE_INFO·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_EV_SOA_DUM_V 12.1.1
View for fetching site of activities for Exchange Visitor students
APPS.IGS_SV_EV_SOA_DUM_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_DPND_BLK_V 12.1.1
View for obtaining information for the XML block describing the creation of the student dependent main information.
APPS.IGS_SV_DPND_BLK_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_DEPDNT_INFO·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_EDT_PERS_BLK_V 12.1.1
View for obtaining information for the XML block describing the student personal information changes.
APPS.IGS_SV_EDT_PERS_BLK_V·↳ IGS_SV_BIO_INFO·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_EV_DPND_BLK_V 12.1.1
View for the creation of the Exchange Visitor dependent block in the XML file sent to SEVIS
APPS.IGS_SV_EV_DPND_BLK_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_DEPDNT_INFO·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_ADD_DPND_BLK_V 12.1.1
View for obtaining information for the XML block describing the addition of a new dependent for the student.
APPS.IGS_SV_ADD_DPND_BLK_V·↳ IGS_SV_DEPDNT_INFO·↳ IGS_SV_PERSONS·Explore IGS module →
-
View used for obtaining the Exchange Visitor create dependent block information.
APPS.IGS_SV_EV_CRT_DEP_BLK_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_DEPDNT_INFO·Explore IGS module →
-
Add dependent block for the Exchange Visitor
APPS.IGS_SV_EV_ADD_DPD_BLK_V·↳ IGS_SV_DEPDNT_INFO·Explore IGS module →
-
Edit dependent block for the Exchange Visitor
APPS.IGS_SV_EV_EDT_DPD_BLK_V·↳ IGS_SV_DEPDNT_INFO·Explore IGS module →
-
View: IGS_SV_EDT_FINC_BLK_V 12.1.1
View for obtaining information for the XML block describing the financial updates made by the student.
APPS.IGS_SV_EDT_FINC_BLK_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_FINANCE_INFO·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_EV_STATUS_BLK_V 12.1.1
View for fetching status information for Exchange Visitor students
APPS.IGS_SV_EV_STATUS_BLK_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_STATUS_DUM_V 12.1.1
View for fetching status information for student.
APPS.IGS_SV_STATUS_DUM_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_TRM_DPND_BLK_V 12.1.1
View for obtaining information for the XML block describing the termination of a dependent for the student.
APPS.IGS_SV_TRM_DPND_BLK_V·↳ IGS_SV_DEPDNT_INFO·Explore IGS module →
-
View: IGS_SV_UPD_STDT_BLK_V 12.1.1
View for obtaining information for the XML block describing the updated student information.
APPS.IGS_SV_UPD_STDT_BLK_V·↳ IGS_SV_BATCHES·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_EV_UPD_BLK_V 12.1.1
View for use on XML batch for add dummy block
APPS.IGS_SV_EV_UPD_BLK_V·↳ IGS_SV_BATCHES·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_DSCPL_ACT_BLK_V 12.1.1
View for obtaining information for the XML block describing the disciplinary actions taken on the student.
APPS.IGS_SV_DSCPL_ACT_BLK_V·↳ IGS_SV_CONVICTIONS·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_EV_PROG_DUM_V 12.1.1
View for fetching program information for Exchange Visitor students
APPS.IGS_SV_EV_PROG_DUM_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_DROP_BLW_BLK_V 12.1.1
View to be used for the drop below full course XML block
APPS.IGS_SV_DROP_BLW_BLK_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·↳ IGS_SV_PRGMS_INFO·Explore IGS module →
-
View: IGS_SV_EV_EDT_EV_BLK_V 12.1.1
Edit Exchange Visitor Block View.
APPS.IGS_SV_EV_EDT_EV_BLK_V·↳ IGS_SV_BIO_INFO·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_EV_CRT_EV_BLK_V 12.1.1
Create Exchange Visitor Block View.
APPS.IGS_SV_EV_CRT_EV_BLK_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_CRT_STDT_BLK_V 12.1.1
View for obtaining information for the XML block describing the creation of the student information.
APPS.IGS_SV_CRT_STDT_BLK_V·↳ IGS_SV_BTCH_SUMMARY·↳ IGS_SV_PERSONS·Explore IGS module →
-
View: IGS_SV_STDNT_REG_BLK_V 12.1.1
View for obtaining information for the XML block describing the students registration information.
APPS.IGS_SV_STDNT_REG_BLK_V·↳ IGS_SV_BATCHES·↳ IGS_SV_BIO_INFO·↳ IGS_SV_BTCH_SUMMARY·Explore IGS module →
-
View: IGS_SV_PRGM_DUM_V 12.2.2
View for fetching Program information for student.
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_OPT_EMPL_DUM_V 12.2.2
View for fetching OPT employment details for students.
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_TRM_DPND_BLK_V 12.2.2
View for obtaining information for the XML block describing the termination of a dependent for the student.
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_EV_VALDTE_DUM_V 12.2.2
View for fetching information for validate element of XML
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_EV_PROG_DUM_V 12.2.2
View for fetching program information for Exchange Visitor students
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_CNCL_DPND_BLK_V 12.2.2
View for fetching the details about dependents that are getting terminated
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_CPT_EMPL_DUM_V 12.2.2
View for fetching CPT employment records
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_ADD_DPND_BLK_V 12.2.2
View for obtaining information for the XML block describing the addition of a new dependent for the student.
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_EV_UPD_BLK_V 12.2.2
View for use on XML batch for add dummy block
Not implemented in this database·Explore IGS module →
-
Edit dependent block for the Exchange Visitor
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_DSCPL_ACT_BLK_V 12.2.2
View for obtaining information for the XML block describing the disciplinary actions taken on the student.
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_UPD_STDT_BLK_V 12.2.2
View for obtaining information for the XML block describing the updated student information.
Not implemented in this database·Explore IGS module →
-
Add dependent block for the Exchange Visitor
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_OFF_EMPL_DUM_V 12.2.2
View for fetching off campus employment informations for students
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_ACT_DPND_BLK_V 12.2.2
View for obtaining information for the XML block describing the activation of dependent for the student.
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_EV_STATUS_BLK_V 12.2.2
View for fetching status information for Exchange Visitor students
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_EDT_FINC_BLK_V 12.2.2
View for obtaining information for the XML block describing the financial updates made by the student.
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_EV_SOA_DUM_V 12.2.2
View for fetching site of activities for Exchange Visitor students
Not implemented in this database·Explore IGS module →
-
View: IGS_SV_EV_DPND_BLK_V 12.2.2
View for the creation of the Exchange Visitor dependent block in the XML file sent to SEVIS
Not implemented in this database·Explore IGS module →