| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| EMPLOYID | Employee ID |
String | 16 | View | |
| DEPRTMNT | Department |
String | 8 | View | |
| JOBTITLE | Job Title |
String | 8 | View | |
| PAYROLCD | Payroll Code |
String | 8 | View | |
| UPRACTYP | UPR Account Type |
Integer | 2 | View | |
| aaAliasID | aaAliasID |
Long Integer | 4 | View | |
| aaAssignedPercent | aaAssignedPercent |
Long Integer | 4 | View |