S_AB_STU_CITIZENSHIP_C
This is a child table of Students table that stores student's citizenship status.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 22.7.1 | Number(10,0) | Primary Key |
STUDENTSDCID | 22.7.1 | Number(10,0) | DCID of the Students table. |
| CITIZENSHIPSTATUS | 22.7.1 | VARCHAR2(1 CHAR) | The citizenship status |
| COUNTRYOFCITIZENSHIP | 22.7.1 | VARCHAR2(100 CHAR) | The country of citizenship |
| CREATEDBYORGCODE | 22.7.1 | VARCHAR2(6 CHAR) | The organization code which created the record |
| EFFECTIVEDATE | 22.7.1 | DATE | The date the citizenship status is in effect |
| EXPIRYDATE | 22.7.1 | DATE | The date the document expires |
| GUARDIANCITIZENSHIPSTATUS | 22.7.1 | VARCHAR2(1 CHAR) | The citizenship status of the Guardian |
| GUARDIANREFID | 22.7.1 | NUMBER(11,0) | The unique identifier for the parent guardian record on student citizenship status |
| ISPREFERRED | 22.7.1 | NUMBER(1,0) | The flag to identify primary record |
| ORGCODE | 22.7.1 | NUMBER(11) | The organization code used in caller info of PASI submission |
| REFID | 22.7.1 | NUMBER(11,0) | The unique identifier for the citizenship status record |
| WhoCreated | 22.7.1 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
| WhenCreated | 22.7.1 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 22.7.1 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
| WhenModified | 22.7.1 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |