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.