FPR ROLES Table
View exposing role reference data used in Faculty Professional Record reporting and administration.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
16 |
FIRST_NAME |
First name associated with the person. |
VARCHAR2 |
30 |
KRB_NAME |
Krb name associated with the record. |
VARCHAR2 |
8 |
LAST_NAME |
Last name associated with the person. |
VARCHAR2 |
40 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
QUALIFIER_KRB_NAME |
Qualifier krb name associated with the record. |
VARCHAR2 |
15 |
QUALIFIER_MIT_ID |
Business identifier for the qualifier mit. |
VARCHAR2 |
9 |
ROLES_FUNCTION_CATEGORY_CODE |
Code identifying roles function category. |
VARCHAR2 |
4 |
ROLES_FUNCTION_ID |
Business identifier for the roles function. |
NUMBER |
|
ROLES_FUNCTION_NAME |
Roles function name associated with the record. |
VARCHAR2 |
50 |
ROLES_QUALIFIER_NAME |
Roles qualifier name associated with the record. |
VARCHAR2 |
50 |
ROLES_QUALIFIER_TYPE |
Roles qualifier type associated with the record. |
VARCHAR2 |
4 |
TITLE |
Title associated with the record. |
VARCHAR2 |
50 |
UNIT_NAME |
Unit name associated with the record. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |