Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

The process for loading a KIM entity that has principal information is this:

INSERT INTO KRIM_ENTITY_T ("ENTITY_ID", "OBJ_ID", "VER_NBR", "ACTV_IND", "LAST_UPDT_DT")
VALUES ($EntityId, SYS_GUID(), 1, $ActvEntityInd, CURRENT_DATE);
INSERT INTO KRIM_PRNCPL_T ("PRNCPL_ID", "OBJ_ID", "VER_NBR", "PRNCPL_NM", "ENTITY_ID", "PRNCPL_PSWD", "ACTV_IND", "LAST_UPDT_DT")
VALUES ($PrincipalId, SYS_GUID(), 1, $PrincipalName, $EntityId, NULL, $ActvPrincipalInd, CURRENT_DATE);
INSERT INTO KRIM_ENTITY_NM_T ("ENTITY_NM_ID", "OBJ_ID", "VER_NBR", "ENTITY_ID", "NM_TYP_CD", "FIRST_NM", "MIDDLE_NM", "LAST_NM", "SUFFIX_NM", "PREFIX_NM", 
"DFLT_IND", "ACTV_IND", "LAST_UPDT_DT", "NOTE_MSG", "NM_CHNG_DT", "TITLE_NM")
VALUES (KRIM_ENTITY_NM_ID_S.NEXTVAL, SYS_GUID(), 1, $EntityId, 'PRFR', $FirstName, $MiddleName, $LastName, NULL, NULL, 'Y', 'Y', CURRENT_DATE, NULL, NULL, NULL);
INSERT INTO KRIM_ENTITY_ENT_TYP_T ("ENT_TYP_CD", "ENTITY_ID", "OBJ_ID", "VER_NBR", "ACTV_IND", "LAST_UPDT_DT")
VALUES ('PERSON', $EntityId, SYS_GUID(), 1, 'Y', CURRENT_DATE);

The process for loading a KIM entity that has no principal information is this:

INSERT INTO KRIM_ENTITY_T ("ENTITY_ID", "OBJ_ID", "VER_NBR", "ACTV_IND", "LAST_UPDT_DT")
VALUES ($EntityId, SYS_GUID(), 1, $ActvEntityInd, CURRENT_DATE);
INSERT INTO KRIM_ENTITY_NM_T ("ENTITY_NM_ID", "OBJ_ID", "VER_NBR", "ENTITY_ID", "NM_TYP_CD", "FIRST_NM", "MIDDLE_NM", "LAST_NM", "SUFFIX_NM", "PREFIX_NM", 
"DFLT_IND", "ACTV_IND", "LAST_UPDT_DT", "NOTE_MSG", "NM_CHNG_DT", "TITLE_NM")
VALUES (KRIM_ENTITY_NM_ID_S.NEXTVAL, SYS_GUID(), 1, $EntityId, 'PRFR', $FirstName, $MiddleName, $LastName, NULL, NULL, 'Y', 'Y', CURRENT_DATE, NULL, NULL, NULL);
INSERT INTO KRIM_ENTITY_ENT_TYP_T ("ENT_TYP_CD", "ENTITY_ID", "OBJ_ID", "VER_NBR", "ACTV_IND", "LAST_UPDT_DT")
VALUES ('PERSON', $EntityId, SYS_GUID(), 1, 'Y', CURRENT_DATE);

The process for loading an additional principal for an existing entity is this:

INSERT INTO KRIM_PRNCPL_T ("PRNCPL_ID", "OBJ_ID", "VER_NBR", "PRNCPL_NM", "ENTITY_ID", "PRNCPL_PSWD", "ACTV_IND", "LAST_UPDT_DT")
VALUES ($PrincipalId, SYS_GUID(), 1, $PrincipalName, $EntityId, NULL, $ActvPrincipalInd, CURRENT_DATE);
  • No labels