Search Results igs_pe_mil_services_u1

Overview

The IGS_PE_MIL_SERVICES_ALL table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, residing in the IGS (iGrants) schema. Its primary function is to store detailed historical records of an individual's military service. This table supports critical functionality in modules related to human resources, student systems, and benefits administration where veteran status or military history is a factor, such as for eligibility tracking, reporting, or compliance purposes. As a multi-org enabled table (indicated by the '_ALL' suffix), it can store data partitioned by operating unit, making it integral to deployments with multiple business entities.

Key Information Stored

The table's structure captures the essential timeline and categorization of military service. The primary identifier is the MILIT_SERVICE_ID. The PERSON_ID column links the record to a specific individual in the person registry. The START_DATE and END_DATE define the period of service. Notably, several columns are documented as obsolete, including SEPARATION_TYPE_ID, MILITARY_TYPE_ID, ASSISTANCE_TYPE_ID, and ASSISTANCE_STATUS_ID. This indicates a likely migration to a flexfield or lookup-based model in these EBS versions. The table includes standard Oracle columns for auditing (CREATED_BY, LAST_UPDATE_DATE, etc.) and a set of attribute columns (ATTRIBUTE_CATEGORY, ATTRIBUTE1-7) intended for Descriptive Flexfield (DFF) customization to capture additional, implementation-specific details about the military service record.

Common Use Cases and Queries

This table is central to reporting and processes involving veteran or military-affiliated persons. Common use cases include generating compliance reports for government agencies, determining eligibility for veteran-specific benefits or programs, and populating personal data summaries. A typical query to retrieve a person's military service history, joining to a person's core record, would be:

• SELECT ms.PERSON_ID, ms.START_DATE, ms.END_DATE FROM IGS.IGS_PE_MIL_SERVICES_ALL ms WHERE ms.PERSON_ID = :person_id ORDER BY ms.START_DATE;

Given the obsolescence of type code columns like SEPARATION_TYPE_ID, implementations likely utilize Descriptive Flexfields. Therefore, queries often involve the ATTRIBUTE columns or joins to flexfield value tables. Data integrity is enforced by unique constraints, particularly IGS_PE_MIL_SERVICES_U2, which prevents duplicate service type entries for a person within the same date range.

Related Objects

The table maintains relationships with other core EBS objects primarily through foreign keys. The PERSON_ID column is a foreign key referencing a person record, typically in a table like PER_ALL_PEOPLE_F or IGS_PE_PERSON. The obsolete ID columns (SEPARATION_TYPE_ID, etc.) were historically foreign keys to lookup tables, which may still exist but are no longer the primary reference. The table's two unique indexes define its key relationships: IGS_PE_MIL_SERVICES_U1 on MILIT_SERVICE_ID for the primary key, and IGS_PE_MIL_SERVICES_U2, a composite unique constraint on (PERSON_ID, MILITARY_TYPE_CD, START_DATE). This table is also a likely dependency for various views, reports, and APIs within the IGS and HRMS modules that expose or manipulate military service data.