EMPLIDSSR_ECK_ID_TYP_NLDINS=Instructor
STD=Student
SSR_ECK_STM_NLD(SQL Table) |
Index Back |
|---|---|
ECK recordRecord to store ECK iD and Stampseudonym |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SSR_ECK_ID_TYP_NLD |
Character(3) | VARCHAR2(3) NOT NULL |
Id type for ECK processing
INS=Instructor STD=Student |
| 3 | SSR_ECK_STMPDN_NLD | Character(250) | VARCHAR2(250) NOT NULL | stampseudonym for ECK processing |
| 4 | SSR_ECK_STM_IV_NLD | Character(70) | VARCHAR2(70) NOT NULL | stampseudonym IV for encryption |
| 5 | SSR_ECK_ID_NLD | Character(250) | VARCHAR2(250) NOT NULL | ECK ID |
| 6 | SSR_ECK_ID_IV_NLD | Character(70) | VARCHAR2(70) NOT NULL | ECK ID IV for encrytion |
| 7 | SSR_ECK_INST_GUUID | Character(50) | VARCHAR2(50) NOT NULL | GUUID |