SCC_FILE_NUMBERSCC_SUSPNNSI_VW(SQL View) |
Index Back |
|---|---|
NSI file number viewNSI File number prompt view for the extract parameters. (NZL) |
| SELECT DISTINCT a.SCC_FILE_NUMBER FROM PS_SCC_SUSPNSE_NSI a WHERE a.SCC_FILE_NUMBER NOT IN ( SELECT SCC_FILE_NUMBER FROM PS_SCC_INSTALL_NZL) AND SCC_STATUS_NSI = 'E' |
| # | 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) |