| 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. |
