SCC_NSI_INTFC(SQL Table) |
Index Back |
|---|---|
NSI Intermediate fileNSI Intermediate file for the Request NSN App Engine (NZL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SCC_SURNAME | Character(32) | VARCHAR2(32) NOT NULL | Surname for NSI (NZL) |
| 3 | SCC_FORENAME1 | Character(32) | VARCHAR2(32) NOT NULL | Forename 1 for NSI (NZL) |
| 4 | SCC_FORENAME2 | Character(32) | VARCHAR2(32) NOT NULL | Forename 2-3 for NSI (NZL) |
| 5 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 6 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 7 | 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 |
| 8 | SCC_RESIDENTL_STAT | Character(1) | VARCHAR2(1) NOT NULL |
NSI Residential Status
A=Australian Citizen C=Citizen O=Overseas P=Permanent Resident U=Unknown |
| 9 | 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 |