EMPLIDPrompt Table: PERSONAL_DATA
EFFDTDefault Value: %date
EFFSEQ0=Main
1=Merged
2=Alternate
3=Alternate Merge
SCC_NSI_ADLDATA(SQL Table) |
Index Back |
|---|---|
NSI Update/Insert Process RecNSI Additional Data for Update/Insert 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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 4 | SCC_FILE_NUMBER | Number(4,0) | SMALLINT NOT NULL | File Number for NSI (NZL) |
| 5 | SCC_NSI_CREATED_DT | Character(8) | VARCHAR2(8) NOT NULL | NSI Created Date (NZL) |
| 6 | SCC_NSI_CREATED_ID | Character(200) | VARCHAR2(200) NOT NULL | NSI Created by User ID (NZL) |
| 7 | SCC_RANKING | Character(3) | VARCHAR2(3) NOT NULL | NSI Level of match ranking (NZL) |
| 8 | SCC_PREF_NAME_IND | Character(1) | VARCHAR2(1) NOT NULL | NSI Preferred Name Indicator |
| 9 | SCC_MATCH_IND_NSI | Character(1) | VARCHAR2(1) NOT NULL |
Match Indicator for NSI (NZL)
0=Main 1=Merged 2=Alternate 3=Alternate Merge |
| 10 | SCC_PROVIDER_CODE | Number(4,0) | SMALLINT NOT NULL | NSI Created By Provider Code |