| Data element |
Definition |
ADMIN_OPTION
Indexed - no
Format - varchar2(3)
May be null? yes |
Indicates whether the user can grant the role to other users.
|
GRANTED_ROLE
Indexed - yes
Format - varchar2(30)
May be null? yes |
The Data Warehouse database role that has been granted to the user.
Values:
Refer to the DWADMIN.DW_ROLES_DESC table. |
GRANTEE
Indexed - yes
Format - varchar2(30)
May be null? yes |
The Oracle database login ID of the user to whom the role has been granted. |
HOME_CENTER
Indexed - yes
Format - char(2)
May be null? yes |
A 2-digit number used to identify the school or center that owns the employee's record and is responsible for its maintenance. The code set is from the University's General Ledger, and has been in use since July 1, 1996.
Example: 40 (School of Medicine)
Values:
Refer to the DWADMIN.ORG_CODES table, for values where
Home_Center = Center_Code. |
PENN_ID
Indexed - yes
Format - char(8)
May be null? yes |
The 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse. |
