Results for “citizenship_cd”
25 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGS.IGS_ST_CITIZENSHP_CD table is a reference (lookup) entity within the Oracle E-Business Suite Student System (IGS) product family. It stores the set of user-defined citizenship codes that an institution recognizes when recording a person's citizenship status. Rather than hard-coding a fixed enumeration of nationalities or residency categories, the Student System exposes this table so that implementers can tailor citizenship values to institutional, regulatory, or statutory reporting requirements. Each row represents one permissible citizenship code together with its associated description, an optional mapping to the government-defined citizenship code, and an active/closed indicator.
From a Data Vault modeling perspective, the mined relationship structure suggests this object behaves as a satellite-leaning reference entity. It carries descriptive attributes (description, notes, closed indicator) around a business key and points outward to a government citizenship code table, which is characteristic of a descriptive reference satellite rather than a pure hub or a transactional link. In the Oracle EBS 12.1.1 and 12.2.2 schemas the table is owned by the IGS schema and is reported as VALID.
Key Information Stored
The documented schema contains 10 columns. The most significant are summarized below.
- CITIZENSHIP_CD — The primary business identifier for the record. It is also the single column forming the surrogate primary key constraint
IGS_ST_CITIZENSHP_CD_PKand the unique indexIGS_ST_CITIZENSHP_CD_U1, making it both the primary key and the principal business-key candidate. - GOVT_CITIZENSHIP_CD — A foreign key column referencing
IGS_PE_GOVCITIZEN_CD. It links the institution-defined citizenship code to the corresponding government-coded citizenship value, which is essential for statutory or government reporting extracts. - DESCRIPTION — The user-facing name or label displayed for the citizenship code in forms, lists of values, and reports.
- CLOSED_IND — An active/closed flag that determines whether the code remains selectable. Closed codes are retained for historical records but suppressed from new data entry.
- NOTES — Free-form text for administrative remarks, usage guidance, or institutional policy notes attached to the code.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard Oracle EBS audit columns recording who created and last modified the row, when, and from which login session.
Because CITIZENSHIP_CD is the only column in the unique index and the primary key, it is unambiguously the business key; there is no compound business-key candidate documented.
Common Use Cases and Queries
This table is typically accessed to populate lists of values in student admission and person registration forms, to resolve a stored citizenship code into a readable description for reporting, and to map institutional codes to government codes for regulatory extracts. A common query to retrieve only currently active citizenship codes is:
SELECT citizenship_cd, description FROM igs_st_citizenshp_cd WHERE closed_ind = 'N' ORDER BY description;- Joining to the government reference for crosswalk reporting:
SELECT c.citizenship_cd, c.description, g.govt_citizenship_cd FROM igs_st_citizenshp_cd c, igs_pe_govcitizen_cd g WHERE c.govt_citizenship_cd = g.govt_citizenship_cd; - Joining to person statistics to count persons per citizenship:
SELECT s.citizenship_cd, c.description, COUNT(*) FROM igs_pe_statistics s, igs_st_citizenshp_cd c WHERE s.citizenship_cd = c.citizenship_cd GROUP BY s.citizenship_cd, c.description; - Data validation checks to find orphaned codes in downstream tables.
Related Objects
- IGS_PE_GOVCITIZEN_CD — Referenced by
IGS_ST_CITIZENSHP_CD.GOVT_CITIZENSHIP_CD; supplies the government-standard citizenship values. - IGS_PE_STATISTICS — References this table via
IGS_PE_STATISTICS.CITIZENSHIP_CD; stores per-person statistical citizenship data. - IGS_ST_CITIZENSHP_CD_PK — The primary key constraint over
CITIZENSHIP_CD. - IGS_ST_CITIZENSHP_CD_U1 — The unique index over
CITIZENSHIP_CDenforcing business-key uniqueness.
Together these relationships establish IGS_ST_CITIZENSHP_CD as the central institutional citizenship reference that bridges government coding and person-level statistical records within the Student System.
-
This entity describes the available user defined citizenship codes.
-
This entity describes the statistical information collected about a person. eg. Aboriginal & Torres Strait Islander Indicator.
-
This table contains changes made to data impacting on a previous government submission after the submission has been sent. These changes need to be reported.
-
This entity describes a students liability details as captured at the census date for each government submission of the Student Liability File.
-
This entity describes a students enrollment details as captured at the census date for each submission of the Student Enrollment File to the government.
-
Table: IGS_ST_CITIZENSHP_CD 12.2.2
This entity describes the available user defined citizenship codes.
Not implemented in this database·Explore IGS module →
-
TABLE: IGS.IGS_PE_STATISTICS 12.1.1
-
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'.