EMPLIDPrompt Table: PEOPLE_SRCH
N=New
P=In Progress
S=Sent
Default Value: N
SAD_SL_STU_ATCH(SQL Table) |
Index Back |
|---|---|
Selection & Placement Students |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | SAD_SL_SOFI_NBR | Character(9) | VARCHAR2(9) NOT NULL | Social Fiscal Number |
| 3 | SAD_SL_O_NBR | Character(9) | VARCHAR2(9) NOT NULL | Onumber |
| 4 | SAD_SL_STDLNK_NBR | Character(9) | VARCHAR2(9) NOT NULL | Studielink Number |
| 5 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 6 | SAD_SL_RNK_NBR_NLD | Number(19,0) | DECIMAL(19) NOT NULL | Ranking Number |
| 7 | SAD_SL_STUD_LD_STA | Character(1) | VARCHAR2(1) NOT NULL |
Studielink Program Load Status
N=New P=In Progress S=Sent Default Value: N |