Match KIM External Id Process

Owned by Mary Northup
Last updated: May 15, 2015

There are currently 3 different external Id's that are stored for people on KIM.

 

Student Ids

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

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

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)