Results for “interface_military_id”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGS_AD_MILITARY_INT view is a public synonym-backed database object owned by the APPS schema within the Oracle E-Business Suite IGS – Student System product family. It is registered as a VALID view in both ETRM 12.1.1 and 12.2.2, and it exposes the military service and military assistance data that the institution collects and stages prior to loading it into the base admissions tables. The view functions as an integration and reporting surface over the interface (staging) table IGS_AD_MILITARY_INT_ALL, adding only the ROW_ID pseudo-column derived from the underlying ROWID and otherwise projecting every column of the base table unchanged.
Because it is a thin projection rather than a transformation view, IGS_AD_MILITARY_INT is principally consumed by concurrent programs, inbound interface routines, and ad-hoc reporting queries that need to inspect staged military records, their match status, and any error conditions before the data is validated and promoted into the operational admissions schema. The SEPARATION_TYPE_CD column, which is the term the user searched for, is one of the key descriptive attributes carried through this interface, denoting the nature of the student's separation or discharge from military service.
Underlying Base Objects
The documented view text defines a single-object SELECT over IGS_AD_MILITARY_INT_ALL, aliased as TAB. No joins, unions, or aggregations are present; each row returned corresponds one-to-one with a row in the interface-all table. The _ALL suffix indicates that the base table is partitioned by operating unit, which is why ORG_ID is carried explicitly in the SELECT list and the ROW_ID is exposed for downstream procedural updates and deletes.
The ETRM metadata documents no additional referenced base objects for this view beyond that interface table, and no database links, synonyms, or function calls appear in the view text. This confirms that the view itself is a pure, lightweight wrapper intended to give report and interface developers a stable, read-accessible name in the APPS schema while the physical storage, indexes, and operating-unit partitioning remain in the underlying interface table.
Key Columns
The columns exposed by the view fall into four logical groups:
- Identity and organizational keys:
ROW_ID,ORG_ID,INTERFACE_MILITARY_ID, andINTERFACE_ID. These uniquely identify each staged military record and its owning operating unit, and link the record back to its parent interface run. - Military service attributes:
MILITARY_TYPE_CD,SEPARATION_TYPE_CD,START_DATE, andEND_DATE.SEPARATION_TYPE_CDcaptures the reason or category of the service member's separation, while the date columns bound the period of service. - Assistance attributes:
ASSISTANCE_TYPE_CDandASSISTANCE_STATUS_CDdescribe the type of military tuition or financial assistance claimed and its processing status. - Interface control and audit columns:
MATCH_IND,STATUS,ERROR_CODE, andDUP_MILIT_SERVICE_IDsupport duplicate detection, error diagnosis, and reconciliation; the standard WHO columns (CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) plus the concurrent-program columns (REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE) and the twentyATTRIBUTEflex columns complete the DFF-enabled record.
Common Use Cases and Queries
Typical usage centers on verifying what has been staged, locating records separated by a specific reason, and identifying rows that failed validation. The following query retrieves staged military records for a given operating unit grouped by their separation reason:
SELECT separation_type_cd,
COUNT(*) staged_count
FROM igs_ad_military_int
WHERE org_id = :p_org_id
AND status = 'N'
GROUP BY separation_type_cd
ORDER BY separation_type_cd;
To inspect records that failed the interface validation, filtering on the error indicator is appropriate:
SELECT row_id, interface_military_id, military_type_cd,
separation_type_cd, error_code
FROM igs_ad_military_int
WHERE status = 'E'
AND org_id = :p_org_id;
Reports and reconciliations can correlate the staging records back to their interface run via REQUEST_ID or INTERFACE_ID, and duplicate candidates can be surfaced using DUP_MILIT_SERVICE_ID together with the MATCH_IND flag. Because the view is a direct projection over IGS_AD_MILITARY_INT_ALL, all predicates on ORG_ID and other indexed columns are pushed to the base table, so reporting performance is equivalent to querying the underlying interface table directly.
-
View: IGS_AD_MILITARY_INT 12.1.1
APPS.IGS_AD_MILITARY_INT·↳ IGS_AD_MILITARY_INT_ALL·Explore IGS module →
-
Holds information about military service details
-
PACKAGE: APPS.IGS_AD_IMP_007 12.1.1
-
View: IGS_AD_MILITARY_INT 12.2.2
Not implemented in this database·Explore IGS module →
-
Holds information about military service details
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.