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.