SCC_UPDATES_NSI(SQL Table) |
Index Back |
|---|---|
NSI Updates TableNSI Updates 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 | SEQUENCE_NBR_5 |
Number(5,0) | INTEGER NOT NULL | 5 character sequence nbr |
| 4 | SCC_REC_TYPE_NSI | Character(1) | VARCHAR2(1) NOT NULL |
NSI Returned record type (NZL)
E=E M=M S=S |
| 5 | SCC_NSN | Number(10,0) | DECIMAL(10) NOT NULL | National Student Number (NZL) |
| 6 | SCC_SURNAME | Character(32) | VARCHAR2(32) NOT NULL | Surname for NSI (NZL) |
| 7 | SCC_FORENAME1 | Character(32) | VARCHAR2(32) NOT NULL | Forename 1 for NSI (NZL) |
| 8 | SCC_FORENAME2 | Character(32) | VARCHAR2(32) NOT NULL | Forename 2-3 for NSI (NZL) |
| 9 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 10 | SCC_PREF_NAME_IND | Character(1) | VARCHAR2(1) NOT NULL | NSI Preferred Name Indicator |
| 11 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 12 | 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 |
| 13 | SCC_NM_DOB_VERF_BY | Character(4) | VARCHAR2(4) NOT NULL | Name/DOB Verified By for NSI (NZL) |
| 14 | SCC_RESIDENTL_STAT | Character(1) | VARCHAR2(1) NOT NULL |
NSI Residential Status
A=Australian Citizen C=Citizen O=Overseas P=Permanent Resident U=Unknown |
| 15 | 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 |
| 16 | SCC_RES_ST_VERF_BY | Character(4) | VARCHAR2(4) NOT NULL | Residential Status Verified By for NSI |
| 17 | SSR_NZQA_PAID | Character(1) | VARCHAR2(1) NOT NULL |
NZQA Paid
N=No U=Not Applicable or Not Known Y=Yes |
| 18 | DT_OF_DEATH | Date(10) | DATE | Date of Death |
| 19 | SCC_STDNT_STAT_NSI | Character(1) | VARCHAR2(1) NOT NULL |
NSI Record Status (NZL)
A=Active I=Inactive P=Partial |
| 20 | SCC_NSI_CREATED_DT | Character(8) | VARCHAR2(8) NOT NULL | NSI Created Date (NZL) |
| 21 | SCC_NSI_CREATED_ID | Character(200) | VARCHAR2(200) NOT NULL | NSI Created by User ID (NZL) |
| 22 | SCC_PROVIDER_CODE | Number(4,0) | SMALLINT NOT NULL | NSI Created By Provider Code |
| 23 | SCC_OVERRIDE_CODE | Character(10) | VARCHAR2(10) NOT NULL | NSI Override Code (NZL) |
| 24 | SCC_RANKING | Character(3) | VARCHAR2(3) NOT NULL | NSI Level of match ranking (NZL) |
| 25 | SCC_MATCH_IND_NSI | Character(1) | VARCHAR2(1) NOT NULL |
Match Indicator for NSI (NZL)
0=Main 1=Merged 2=Alternate 3=Alternate Merge |
| 26 | SCC_MATCH_INDIC | Character(1) | VARCHAR2(1) NOT NULL | Match selection indicator for NSI (NZL) |
| 27 | SCC_NSI_ERROR_CODE | Number(3,0) | SMALLINT NOT NULL | NSI Error Code (NZL) |
| 28 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 29 | SCC_ERR_CORRECTED | Character(1) | VARCHAR2(1) NOT NULL | Error Corrected code for NSI (NZL) |