 COMMIT
 /
 
-
-INSERT INTO KR_KIM_ENTITY_NAME_T(ENTITY_NAME_ID, OBJ_ID, ENTITY_ID, ENT_TYP_CD, NAME_TYP_CD, FIRST_NM, MIDDLE_NM, LAST_NM, DFLT_IND, ACTV_IND) 
-    VALUES('en1', 'en1', 'e1', 'PERSON', 'PREFERRED', 'One', '', 'User', 'Y', 'Y')
-/
-INSERT INTO KR_KIM_ENTITY_NAME_T(ENTITY_NAME_ID, OBJ_ID, ENTITY_ID, ENT_TYP_CD, NAME_TYP_CD, FIRST_NM, MIDDLE_NM, LAST_NM, DFLT_IND, ACTV_IND) 
-    VALUES('en2', 'en2', 'e2', 'PERSON', 'PREFERRED', 'Two', '', 'User', 'Y', 'Y')
-/
-INSERT INTO KR_KIM_ENTITY_NAME_T(ENTITY_NAME_ID, OBJ_ID, ENTITY_ID, ENT_TYP_CD, NAME_TYP_CD, FIRST_NM, MIDDLE_NM, LAST_NM, DFLT_IND, ACTV_IND) 
-    VALUES('en3', 'en3', 'e3', 'PERSON', 'PREFERRED', 'Three', '', 'User', 'Y', 'Y')
-/
-INSERT INTO KR_KIM_ENTITY_NAME_T(ENTITY_NAME_ID, OBJ_ID, ENTITY_ID, ENT_TYP_CD, NAME_TYP_CD, FIRST_NM, MIDDLE_NM, LAST_NM, DFLT_IND, ACTV_IND) 
-    VALUES('en4', 'en4', 'e4', 'PERSON', 'PREFERRED', 'Four', '', 'User', 'Y', 'Y')
-/
-COMMIT
-/
-
+INSERT INTO KR_KIM_ENT_NAME_TYPE_T(ENT_NAME_TYP_CD, OBJ_ID, ENT_NAME_TYP_NM, DISPLAY_SORT_CD, DFLT_IND, ACTV_IND, LAST_UPDT_DT) 
+    VALUES('PREFERRED', 'etn1', 'Preferred Name', 01, 'N', 'Y', sysdate)
+/
+COMMIT
+/
+
+INSERT INTO KR_KIM_ENTITY_NAME_T(ENTITY_NAME_ID, OBJ_ID, ENTITY_ID, NAME_TYP_CD, FIRST_NM, MIDDLE_NM, LAST_NM, SUFFIX_NM, TITLE_NM, DFLT_IND, ACTV_IND, LAST_UPDT_DT) 
+    VALUES('en1', 'en1', 'e1', 'PREFERRED', 'One', '', 'User', '', '', 'Y', 'Y', sysdate)
+/
+INSERT INTO KR_KIM_ENTITY_NAME_T(ENTITY_NAME_ID, OBJ_ID, ENTITY_ID, NAME_TYP_CD, FIRST_NM, MIDDLE_NM, LAST_NM, SUFFIX_NM, TITLE_NM, DFLT_IND, ACTV_IND, LAST_UPDT_DT) 
+    VALUES('en2', 'en2', 'e2', 'PREFERRED', 'Two', '', 'User', '', '', 'Y', 'Y', sysdate)
+/
+INSERT INTO KR_KIM_ENTITY_NAME_T(ENTITY_NAME_ID, OBJ_ID, ENTITY_ID, NAME_TYP_CD, FIRST_NM, MIDDLE_NM, LAST_NM, SUFFIX_NM, TITLE_NM, DFLT_IND, ACTV_IND, LAST_UPDT_DT) 
+    VALUES('en3', 'en3', 'e3', 'PREFERRED', 'Three', '', 'User', '', '', 'Y', 'Y', sysdate)
+/
+INSERT INTO KR_KIM_ENTITY_NAME_T(ENTITY_NAME_ID, OBJ_ID, ENTITY_ID, NAME_TYP_CD, FIRST_NM, MIDDLE_NM, LAST_NM, SUFFIX_NM, TITLE_NM, DFLT_IND, ACTV_IND, LAST_UPDT_DT) 
+    VALUES('en4', 'en4', 'e4', 'PREFERRED', 'Four', '', 'User', '', '', 'Y', 'Y', sysdate)
+/
+INSERT INTO KR_KIM_ENTITY_NAME_T(ENTITY_NAME_ID, OBJ_ID, ENTITY_ID, NAME_TYP_CD, FIRST_NM, MIDDLE_NM, LAST_NM, SUFFIX_NM, TITLE_NM, DFLT_IND, ACTV_IND, LAST_UPDT_DT) 
+    VALUES('en5', 'en5', 'e5', 'PREFERRED', 'Five', '', 'User', '', '', 'Y', 'N', sysdate)
+/
+INSERT INTO KR_KIM_ENTITY_NAME_T(ENTITY_NAME_ID, OBJ_ID, ENTITY_ID, NAME_TYP_CD, FIRST_NM, MIDDLE_NM, LAST_NM, SUFFIX_NM, TITLE_NM, DFLT_IND, ACTV_IND, LAST_UPDT_DT) 
+    VALUES('en6', 'en6', 'e6',  'PREFERRED', 'Six', '', 'User', '', '', 'Y', 'N', sysdate)
+/
+COMMIT
+/
+
+INSERT INTO KR_KIM_EXT_ID_TYPE_T(EXT_ID_TYP_CD, OBJ_ID, EXT_ID_TYP_NM, DISPLAY_SORT_CD, ENCR_REQ_IND, ACTV_IND, LAST_UPDT_DT) 
+    VALUES('EMPLOYEE', 'extid1', 'Employee ID', 01, 'N', 'Y', sysdate)
+/
+COMMIT
+/
 
 INSERT INTO KR_KIM_ENTITY_EXT_ID_T(ENTITY_EXT_ID_ID, OBJ_ID, ENTITY_ID, EXT_ID_TYP_CD, EXT_ID, ACTV_IND) 
     VALUES('eeid1', 'eeid1', 'e1', 'EMPLOYEE', 'EXTID1', 'Y')

    VALUES('p3', 'p3', 'user3', 'e3', 'Y')
/
INSERT INTO KR_KIM_PRINCIPAL_T(PRNCPL_ID, OBJ_ID, PRNCPL_NM, ENTITY_ID, ACTV_IND) 
    VALUES('p4', 'p4', 'user4', 'e4', 'Y')
/
COMMIT
/



INSERT INTO KR_KIM_GROUP_T(GRP_ID, OBJ_ID, GRP_NM, NMSPC_CD, GRP_DESC, TYP_ID, ACTV_IND) 
    VALUES('g1', 'g1', 'topgroup', 'TEST', 'Top-level group', NULL, 'Y')
/
INSERT INTO KR_KIM_GROUP_T(GRP_ID, OBJ_ID, GRP_NM, NMSPC_CD, GRP_DESC, TYP_ID, ACTV_IND) 
    VALUES('g2', 'g2', 'middlegroup', 'TEST', 'middle-level group', NULL, 'Y')
/
INSERT INTO KR_KIM_GROUP_T(GRP_ID, OBJ_ID, GRP_NM, NMSPC_CD, GRP_DESC, TYP_ID, ACTV_IND) 
    VALUES('g3', 'g3', 'bottomgroup', 'TEST', 'Bottom-level group', NULL, 'Y')
/
INSERT INTO KR_KIM_GROUP_T(GRP_ID, OBJ_ID, GRP_NM, NMSPC_CD, GRP_DESC, TYP_ID, ACTV_IND) 
    VALUES('g4', 'g4', 'bottominactivegroup', 'TEST', 'Bottom-level group (inactive', NULL, 'N')
/
COMMIT
/



INSERT INTO KR_KIM_ROLE_T(ROLE_ID, OBJ_ID, ROLE_NM, NMSPC_CD, ROLE_DESC, TYP_ID, ACTV_IND) 
    VALUES('r1', 'r1', 'poweruserrole', 'TEST', 'high level role that implies other roles', 'roleType1', 'Y')
/
INSERT INTO KR_KIM_ROLE_T(ROLE_ID, OBJ_ID, ROLE_NM, NMSPC_CD, ROLE_DESC, TYP_ID, ACTV_IND) 
    VALUES('r2', 'r2', 'generalrole', 'TEST', 'role granted to large number of users', 'roleType2', 'Y')
/

INSERT INTO KR_KIM_ROLE_REL_T(ROLE_REL_ID, OBJ_ID, ROLE_ID, CONTAINED_ROLE_ID) 
