Field Details

Field name Data type Length Mandatory Comments
APPLICATION_ID Int 17 Yes
PROFILE_OPTION_ID Int 17 Yes
PROFILE_OPTION_NAME String 80 Yes
LAST_UPDATE_DATE DateTime No yyyy-mm-dd hh:mi:ss:mmmm
LAST_UPDATED_BY Int 15 Yes
CREATION_DATE DateTime No yyyy-mm-dd hh:mi:ss:mmmm
CREATED_BY BigInt 15 No
LAST_UPDATE_LOGIN BigInt 15 No
WRITE_ALLOWED_FLAG String 1 No
READ_ALLOWED_FLAG String 1 No
USER_CHANGEABLE_FLAG String 1 No
USER_VISIBLE_FLAG String 1 No
SITE_ENABLED_FLAG String 1 No
SITE_UPDATE_ALLOWED_FLAG String 1 No
APP_ENABLED_FLAG String 1 No
APP_UPDATE_ALLOWED_FLAG String 1 No
RESP_ENABLED_FLAG String 1 No
RESP_UPDATE_ALLOWED_FLAG String 1 No
USER_ENABLED_FLAG String 1 No
USER_UPDATE_ALLOWED_FLAG String 1 No
START_DATE_ACTIVE DateTime No yyyy-mm-dd hh:mi:ss:mmmm
SQL_VALIDATION String 2000 No
END_DATE_ACTIVE DateTime No yyyy-mm-dd hh:mi:ss:mmmm
HIERARCHY_TYPE String 8 No
SERVER_ENABLED_FLAG String 1 No
ORG_ENABLED_FLAG String 1 No
SERVER_UPDATE_ALLOWED_FLAG String 1 No
ORG_UPDATE_ALLOWED_FLAG String 1 No
USER_PROFILE_OPTION_NAME String 240 Yes
DESCRIPTION String 240 Yes
LANGUAGE String 4
Note: The combination of APPLICATION_ID and PROFILE_OPTION_ID must be unique.