The Batch tables are referenced/used by:
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| ROL__ID | int | Y | Auto-Generated Primary Key |
| ROL__CODE | varchar(50) | Y | Unique Role Code (Short Name) |
| ROL__NAME | varchar(50) | Y | Alternative Role Name |
| ROL__BLOCKED | bit | Flag that indicates if Role is blocked for usage | |
| ROL__DESCRIPTION | varchar(1000) | Long Description |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| USR__ID | int | Y | Auto-Generated Primary Key |
| USR__CODE | varchar(50) | Y | Username user for login purposes |
| USR__FIRSTNAME | varchar(50) | User's First Name | |
| USR__LASTNAME | varchar(50) | User's Last Name | |
| USR__BLOCKED | bit | Flag to indicate user is blocked for use | |
| USR__PIN | varchar(50) | Y | User Password |
| USR__DESCRIPTION | varchar(1000) | Additional Long Description for user | |
| USR__ROL_ID | int | Y | Foreign Key to qx_Role Table (User's primary Role) |
| USR__PWD_DATE | datetime | Date Password was last reset | |
| USR__SCN_ID | int | Foreign key to qx_Scanner | |
| USR__LDAP_ALIAS | varchar(100) | LDAP (Active Directory) User mapping | |
| USR__LNG_ID | int | Foreign key to qx_Language (The Users selected Language) | |
| USR__EMAIL | varchar(200) | User Email Address | |
| USR__MOBILE | varchar(20) | User Mobile Number |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| URO__ID | int | Y | Auto-Generated Primary Key |
| URO__USR_ID | int | Y | Foreign Key to qx_User Table (Linked User) |
| URO__ROL_ID | int | Y | Foreign Key to qx_Role Table (Linked Role) |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| RLF__ID | int | Y | Auto-Generated Primary Key |
| RLF__ROL_ID | int | Y | Foreign Key to qx_Role Table (Linked Role) |
| RLF__FNC_ID | int | Y | Foreign Key to qx_Function (Linked Mobile Device Function) |
| RLF__WRITE_ACCESS | int | Role has Write access (if applicable) | |
| RLF__ACTION_ACCESS | int | Role has Action (execute) access (if applicable) |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| FNC__ID | int | Y | Auto-Generated Primary Key |
| FNC__CODE | varchar(50) | Y | Function Code (Short) |
| FNC__NAME | varchar(50) | Function Name (Alternative Name) | |
| FNC__BLOCKED | bit | Flag to indicate if the function is globally blocked | |
| FNC__DESCRIPTION | varchar(1000) | Long Description of Function |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| RDD__ID | int | Y | Auto-Generated Primary Key |
| RDD__ROL_ID | int | Y | Foreign Key to qx_Role Table (Linked Role) |
| RDD__DDF_ID | int | Y | Foreign Key to qx_DocumentDefinition Table (Linked View) |
| RDD__ENABLED | bit | Flag to set if access is enabled |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| RDA__ID | int | Y | Auto-Generated Primary Key |
| RDA__RDD_ID | int | Y | Foreign Key to qx_RoleDocumentDefinitionAccess (Linked View Access) |
| RDA__DVC_ID | int | Y | Foreign key to qx_DocumentDefinitionViewColumn (Linked View Column) |
| RDA__VISIBLE | bit | Flag that indicates visibility of column |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| RAA__ID | int | Y | Auto-Generated Primary Key |
| RAA__RDD_ID | int | Y | Foreign key to qx_RoleDocumentDefinitionAccess (Linked View Access) |
| RAA__DDA_ID | int | Y | Foreign key to qx_DocumentDefinitionAction (Linked View Action) |
| RAA__VISIBLE | bit | Flag that indicates visibility of Action button |