Field Details

Field name Data type Length Mandatory Comments
APPLICATION_ID Int 17 Yes
PROFILE_OPTION_ID Int 17 Yes
LEVEL_ID Int 17 Yes
LEVEL_VALUE Int 17 Yes
LAST_UPDATE_DATE DateTime No
LAST_UPDATED_BY BigInt 15 No
CREATION_DATE DateTime 15 No yyyy-mm-dd hh:mi:ss:mmmm
CREATED_BY bigint 15 No
LAST_UPDATE_LOGIN bigint 15 No
PROFILE_OPTION_VALUE String 240 Yes
LEVEL_VALUE_APPLICATION_ID bigint 15 Yes
Note: The combination of APPLICATION_ID, PROFILE_OPTION_ID, LEVEL_ID, LEVEL_VALUE and LEVEL_VALUE_APPLICATION_ID must be unique.