There are currently 3 different external Id's that are stored for people on KIM.
Student Ids
| Code Block |
|---|
INSERT INTO KRIM_ENTITY_EXT_ID_T ("ENTITY_EXT_ID_ID", "OBJ_ID", "VER_NBR", "ENTITY_ID", "EXT_ID_TYP_CD", "EXT_ID", "LAST_UPDT_DT")
VALUES (KRIM_ENTITY_EXT_ID_ID_S.NEXTVAL, SYS_GUID(), 1, $EntityId, 'STUDENT', $StudentId, CURRENT_DATE) |
PIDMs
| Code Block |
|---|
INSERT INTO KRIM_ENTITY_EXT_ID_T ("ENTITY_EXT_ID_ID", "OBJ_ID", "VER_NBR", "ENTITY_ID", "EXT_ID_TYP_CD", "EXT_ID", "LAST_UPDT_DT")
VALUES (KRIM_ENTITY_EXT_ID_ID_S.NEXTVAL, SYS_GUID(), 1, $EntityId, 'PIDM', $Pidm, CURRENT_DATE) |
and IAMIDs
| Code Block |
|---|
INSERT INTO KRIM_ENTITY_EXT_ID_T ("ENTITY_EXT_ID_ID", "OBJ_ID", "VER_NBR", "ENTITY_ID", "EXT_ID_TYP_CD", "EXT_ID", "LAST_UPDT_DT")
VALUES (KRIM_ENTITY_EXT_ID_ID_S.NEXTVAL, SYS_GUID(), 1, $EntityId, 'IAMID', $IAMID, CURRENT_DATE) |