SCC_FILE_NUMBEREMPLIDSCC_SUSPNSISRCH(SQL View) |
Index Back |
|---|---|
NSI Suspense TableNSI Suspense Table (NZL) |
| SELECT A.SCC_FILE_NUMBER ,A.EMPLID ,B.XLATLONGNAME ,A.SCC_SURNAME ,A.SCC_FORENAME1 ,A.SCC_NSN FROM PS_SCC_SUSPNSE_NSI A , PSXLATITEM B WHERE B.FIELDNAME = 'SCC_STATUS_NSI' AND B.FIELDVALUE = A.SCC_STATUS_NSI AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PSXLATITEM B2 WHERE B2.FIELDNAME = B.FIELDNAME AND B2.FIELDVALUE = B.FIELDVALUE AND B2.EFFDT <= %CurrentDateIn) |
| # | 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_STATUSNSI_DESC | Character(30) | VARCHAR2(30) NOT NULL | National Student Index Status Description |
| 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) |