SCC_NSITMP_MC(SQL Table) |
Index Back |
|---|---|
NSI Mass change temp recordNSI temporary table for the NSN request mass change (NZL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 3 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 4 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | MIDDLE_NAME |
| 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 |