Penn Computing

University of Pennsylvania
Penn Computing << go backback
USER_ACCESS_LIST Table   Tables and Data Elements   Infrastructure Home    Data Warehouse Home

USER_ACCESS_LIST Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
ACCESS_BEGIN_ORG

Indexed - yes
Format - char(4)
May be null? yes
The ORG code at the start of the range of organizations to which the user has access, for the application.
Values:
Refer to the DWADMIN.ORG_CODES table for values.
ACCESS_CENTER

Indexed - yes
Format - char(2)
May be null? yes

The School or Center to which the user has access, for the application. The appearance of a value in the Access_Center column indicates that the user has access to all ORGs within that School or Center.

Values:
Refer to the DWADMIN.ORG_CODES table, for values where 
Home_Center = Center_Code.
ACCESS_END_ORG

Indexed - yes
Format - char(4)
May be null? yes
The ORG code at the end of the range of organizations to which the user has access, for the application.
Values:
Refer to the DWADMIN.ORG_CODES table for values.
APPLICATION

Indexed - yes
Format - varchar2(50)
May be null? yes
The name of the application to which the user has access, for the Access ORGs or Center.
APPLICATION_USER_ID

Indexed - yes
Format - varchar2(50)
May be null? no
The unique identifier for the user, within the Application.
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.
HOME_ORG

Indexed - yes
Format - char(4)
May be null? yes
The 4-digit number that represents the organization that owns the employee's record and is responsible for its maintenance. An organization is a subdivision of the University created for management purposes. An Organization belongs to only one School or Responsibility Center, and its organization code is unique. (The code set is from the University's General Ledger, and has been in use since July 1, 1996.)

Examples: 0104 (CHEMISTRY); 0001 (GEN UNIVERSITY)

Values:
Refer to the DWADMIN.ORG_CODES table for values.
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.

USER_ACCESS_LIST Table   Tables and Data Elements   Infrastructure Home    Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania