OIM 11g R2 – LKU Table Schema

Column Name Data Type NULL
LKU_KEY NUMBER(19, 0) No
LKU_LOOKUP_KEY NUMBER(19, 0) Yes
LKU_TYPE VARCHAR2(1) Yes
LKU_GROUP VARCHAR2(255) Yes
LKU_REQUIRED VARCHAR2(1) Yes
LKU_TYPE_STRING_KEY VARCHAR2(255) No
LKU_FIELD VARCHAR2(50) Yes
LKU_DATA_LEVEL NUMBER(1, 0) Yes
LKU_CREATE DATE Yes
LKU_CREATEBY NUMBER(19, 0) Yes
LKU_UPDATE DATE Yes
LKU_UPDATEBY NUMBER(19, 0) Yes
LKU_NOTE CLOB Yes
LKU_ROWVER RAW(8) Yes

Leave a Reply

Your email address will not be published. Required fields are marked *