/
Match KIM External Id Process
Match KIM External Id Process
- Mary Northup
Owned by Mary Northup
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)
, multiple selections available,
Related content
Match KIM to IAM people
Match KIM to IAM people
More like this
Load KIM Entities
Load KIM Entities
More like this
IAM Extract Process
IAM Extract Process
More like this
Match KIM for Update Process
Match KIM for Update Process
More like this