Field Details
| Field name | Data type | Length | Mandatory | Comments |
|---|---|---|---|---|
| APPLICATION_ID | Int | 15 | Yes | |
| RESPONSIBILITY_ID | Int | 15 | Yes | |
| LAST_UPDATE_DATE | DateTime | No | yyyy-mm-dd hh:mi:ss:mmmm | |
| LAST_UPDATED_BY | Int | 15 | No | |
| CREATION_DATE | DateTime | No | yyyy-mm-dd hh:mi:ss:mmmm | |
| CREATED_BY | Int | 15 | No | |
| LAST_UPDATE_LOGIN | Int | 15 | No | |
| DATA_GROUP_APPLICATION_ID | Int | 15 | No | |
| DATA_GROUP_ID | Int | 15 | No | |
| MENU_ID | Int | 15 | Yes | |
| TERM_SECURITY_ENABLED_FLAG | String | 1 | No | |
| START_DATE | DateTime | Yes | yyyy-mm-dd hh:mi:ss:mmmm | |
| END_DATE | DateTime | No | yyyy-mm-dd hh:mi:ss:mmmm | |
| GROUP_APPLICATION_ID | Int | 15 | No | |
| REQUEST_GROUP_ID | Int | 15 | No | |
| VERSION | String | 1 | No | |
| WEB_HOST_NAME | String | 80 | No | |
| WEB_AGENT_NAME | String | 80 | No | |
| RESPONSIBILITY_KEY | String | 30 | No | |
| SECURITY_GROUP_ID | Decimal | No | scale=4
precision=29 |
|
| RESPONSIBILITY_NAME | String | 100 | Yes | |
| DESCRIPTION | String | 240 | No | |
| LANGUAGE | String | 4 | Yes | |
| APPLICATION_NAME | String | 240 | Yes | |
| IS_ACTIVE | String | 1 | Yes | This field will contain values Y/N.
|
Note: The combination of APPLICATION_ID and RESPONSIBILITY_ID must be unique.