EMPLIDPrompt Table: PERSONAL_DATA
SCC_NSI_ADLCHG(SQL Table) |
Index Back |
|---|---|
Change notification NSINSI Additional Data for Change Notification Process (NZL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | SCC_MODIFIED_DATE | Character(8) | VARCHAR2(8) NOT NULL | Modified Date for NSI (NZL) |
| 3 | SCC_MASTER_NSN | Number(10,0) | DECIMAL(10) NOT NULL | Master NSN for NSI (NZL) |
| 4 | SCC_PROVIDER_CODE | Number(4,0) | SMALLINT NOT NULL | NSI Created By Provider Code |
| 5 | SCC_CHGD_FIELD_IND | Number(5,0) | INTEGER NOT NULL | Changed Field Indicator for NSI (NZL) |
| 6 | SCC_PREF_NAME_IND | Character(1) | VARCHAR2(1) NOT NULL | NSI Preferred Name Indicator |