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.