Field info
| Field name | Data type | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROLENAME | String | 30 | Yes | |
| VERSION | Bigint | 4 | No | |
| ROLETYPE | String | 1 | No | This field can contain Q/U
|
| DESCR | String | 30 | No | |
| QRYNAME | String | 30 | No | |
| ROLESTATUS | String | 1 | No | The field can contain A/I
|
| RECNAME | String | 15 | No | |
| FIELDNAME | String | 18 | No | |
| PC_EVENT_TYPE | String | 14 | No | |
| QRYNAME_SEC | String | 30 | No | |
| PC_FUNCTION_NAME | String | 30 | No | |
| ROLE_PCODE_RULE_ON | String | 1 | No | |
| ROLE_QUERY_RULE_ON | String | 1 | No | |
| LDAP_RULE_ON | String | 1 | No | |
| ALLOWNOTIFY | String | 1 | No | |
| ALLOWLOOKUP | String | 1 | No | |
| LASTUPDDTTM | DateTime | 8 | No | mm/dd/yyyy hh:mi:ss:mmmm |
| LASTUPDOPRID | String | 30 | No | |
| DESCRLONG | String | 16 | No |
Note: The ROLENAME field must be unique.