PAYROLL ROLES DETAIL Table
Authorizations for payroll data access in the Roles Database.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
VARCHAR2 |
8 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PAYROLL_ROLES_FUNCTION_KEY |
XXX |
NUMBER |
22 |
PAYROLL_ROLES_QUALIFIER_KEY |
XXX |
NUMBER |
22 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
ROLE_ASSIGNMENT_TYPE |
'Direct' means that the authorization was directly assigned. 'Inherited' means that the authorization was assigned at a higher level in the hierarchy. For example, if an authorization is assigned for D_SCHOOL_SCI, then you will see one record where the qualifier maps to 'D_SCHOOL_SCI' and the roles_assignment_type='Direct' and several other records mapping to departments within the school of science (e.g., for 'D_BIOLOGY') with roles_assignment_type='Inherited'. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |