Search Results igs_pe_mil_services_u2

Overview

The IGS_PE_MIL_SERVICES_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS) module. It functions as the master repository for storing detailed military service history associated with a person, typically a student, applicant, or other constituent within the institution. Its primary role is to support the comprehensive tracking of an individual's military affiliation, which is critical for processes related to veteran benefits, admissions considerations, financial aid eligibility, and institutional reporting. As a multi-organization table denoted by the "_ALL" suffix, it is designed to store data partitioned by the ORG_ID column, enabling secure, shared service operations across multiple business units within a single EBS installation.

Key Information Stored

The table's structure is centered on linking a person to specific military service details. The primary identifier is the system-generated MILIT_SERVICE_ID. The core relationship is established via the PERSON_ID column, which foreign keys to HZ_PARTIES. Essential temporal data is captured in START_DATE and END_DATE columns. The nature of the service is defined through several foreign key references to code lookup tables: MILITARY_TYPE_CD (and MILITARY_TYPE_ID) for the branch or classification of service, SEPARATION_TYPE_ID for the discharge condition, and ASSISTANCE_STATUS_ID and ASSISTANCE_TYPE_ID for tracking veteran educational benefit status and type. Additional columns typically include attributes for rank, service number, and country of service, facilitating a complete military service profile.

Common Use Cases and Queries

This table is central to operations involving student veterans. Common use cases include determining eligibility for VA benefits, populating veteran status on admissions applications, and generating compliance reports for government agencies. A typical reporting query would join person and military service data to list active students using benefits.

• Sample Query: Identifying students currently using GI Bill benefits.
  SELECT hp.party_number, hp.person_first_name, hp.person_last_name, ims.start_date
FROM igs.igs_pe_mil_services_all ims,
hz_parties hp
WHERE ims.person_id = hp.party_id
AND ims.assistance_status_id = (SELECT code_id FROM igs_pe_code_classes WHERE code = 'ACTIVE')
AND ims.assistance_type_id = (SELECT code_id FROM igs_pe_code_classes WHERE code = 'GI_BILL')
AND SYSDATE BETWEEN ims.start_date AND NVL(ims.end_date, SYSDATE);
• Data is often maintained via the Person UI or dedicated veteran administration forms, which internally call the appropriate Person API (e.g., IGS_PE_PERSON_PKG).

Related Objects

The IGS_PE_MIL_SERVICES_ALL table maintains defined relationships with several other EBS objects, primarily for person and code reference data.

• HZ_PARTIES: The foundational table for all persons and organizations in EBS. Joined via IGS_PE_MIL_SERVICES_ALL.PERSON_ID = HZ_PARTIES.PARTY_ID to retrieve the individual's name and demographic information.
• IGS_PE_CODE_CLASSES: This lookup table is referenced multiple times to provide valid values for key service attributes.
  • IGS_PE_MIL_SERVICES_ALL.MILITARY_TYPE_ID = IGS_PE_CODE_CLASSES.CODE_ID
  • IGS_PE_MIL_SERVICES_ALL.SEPARATION_TYPE_ID = IGS_PE_CODE_CLASSES.CODE_ID
  • IGS_PE_MIL_SERVICES_ALL.ASSISTANCE_STATUS_ID = IGS_PE_CODE_CLASSES.CODE_ID
  • IGS_PE_MIL_SERVICES_ALL.ASSISTANCE_TYPE_ID = IGS_PE_CODE_CLASSES.CODE_ID
• The table's primary key (IGS_PE_MIL_SERVICES_PK on MILIT_SERVICE_ID) is referenced by other IGS entities, such as child tables or summary views, to provide extended military service information.