SCC_SUSPNSE_NSI(SQL Table) |
Index Back |
|---|---|
NSI Suspense TableNSI Suspense Table (NZL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SCC_FILE_NUMBER |
Number(4,0) | SMALLINT NOT NULL | File Number for NSI (NZL) |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | SCC_STATUS_NSI | Character(1) | VARCHAR2(1) NOT NULL |
Status of NSI Suspense records (NZL)
E=Extracted P=Posted R=Ready for Extraction S=Select a Match X=Ready to Post Y=Error Z=Error Corrected |
| 4 | SCC_SURNAME | Character(32) | VARCHAR2(32) NOT NULL | Surname for NSI (NZL) |
| 5 | SCC_FORENAME1 | Character(32) | VARCHAR2(32) NOT NULL | Forename 1 for NSI (NZL) |
| 6 | SCC_NSN | Number(10,0) | DECIMAL(10) NOT NULL | National Student Number (NZL) |
| 7 | SCC_FORENAME2 | Character(32) | VARCHAR2(32) NOT NULL | Forename 2-3 for NSI (NZL) |
| 8 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 9 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 10 | SCC_NM_DOB_VERFCTN | Character(1) | VARCHAR2(1) NOT NULL |
Name/DOB Verification for NSI (NZL)
B=Birth Certificate M=BDM O=Other Primary ID P=Passport U=Unverified |
| 11 | SCC_RESIDENTL_STAT | Character(1) | VARCHAR2(1) NOT NULL |
NSI Residential Status
A=Australian Citizen C=Citizen O=Overseas P=Permanent Resident U=Unknown |
| 12 | SCC_RES_ST_VERFCTN | Character(1) | VARCHAR2(1) NOT NULL |
Residential Stat Verification for NSI (NZL)
B=Birth Certificate M=BDM O=Other Primary ID P=Passport U=Unverified |
| 13 | SCC_OVERRIDE_CODE | Character(10) | VARCHAR2(10) NOT NULL | NSI Override Code (NZL) |
| 14 | SCC_MC_INSERTD_NSI | Character(1) | VARCHAR2(1) NOT NULL |
Inserted by Mass Change for NSI (NZL)
Y/N Table Edit |