Skip to main content
Skip table of contents


This is a child table of Students table that stores student's citizenship status.

Column Name


Data Type


ID22.7.1Number(10,0)Primary Key




DCID of the Students table.
CITIZENSHIPSTATUS22.7.1VARCHAR2(1 CHAR)The citizenship status
COUNTRYOFCITIZENSHIP22.7.1VARCHAR2(100 CHAR)The country of citizenship
CREATEDBYORGCODE22.7.1VARCHAR2(6 CHAR)The organization code which created the record
EFFECTIVEDATE22.7.1DATEThe date the citizenship status is in effect
EXPIRYDATE22.7.1DATEThe date the document expires

The citizenship status of the Guardian

GUARDIANREFID22.7.1NUMBER(11,0)The unique identifier for the parent guardian record on student citizenship status
ISPREFERRED22.7.1NUMBER(1,0)The flag to identify primary record
ORGCODE22.7.1NUMBER(11)The organization code used in caller info of PASI submission
REFID22.7.1NUMBER(11,0)The unique identifier for the citizenship status record
WhoCreated22.7.1Varchar2(100)The name of the person who created the record. Defaults to the user.
WhenCreated22.7.1Timestamp(6)The date and time the record was created. Defaults to system date.
WhoModified22.7.1Varchar2(100)The name of the person who modified the record. Defaults to the user.
WhenModified22.7.1Timestamp(6)The date and time the record was modified. Defaults to system date.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.