Penn Computing

University of Pennsylvania
Penn Computing << go backback

CENSUS TERM Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

CENSUS TERM Table - Data Element Index

Aa_Census Using Affirmative Action (EE06) logic, this is the employee's census category for the given term. Under EE06 logic some faculty (like the President and Provost) are counted as Administrators, not as Faculty.

Values:

0   Inactive/Terminated Employee
1   A1 Primary Job (Exempt Administrative)
2   A1 Primary Job with Non-Standing Faculty secondary appointment
3   Standing Faculty member
4   Standing Faculty member with secondary administrative appointment
5   Non-Standing Faculty Primary Job
6   Non-Standing Faculty Primary Job with secondary administrative appointment
7   Primary A3 Job (Non-exempt administrative)
8   Primary A4 Job (Skilled crafts)
9   Primary A5 Job (Temporary worker)
Aa_Pri_Dpt For the given term, the department (using the Payroll department table) which holds the employee's primary appointment according to Affirmative Action Census logic. Under Affirmative Action logic some faculty (like the President and Provost) are counted as Administrators, not as Faculty.
Aa_Pri_Job The employee's primary job for the given term according to Affirmative Action census logic. The jobcode is a 6-digit character field and can be decoded using tables from the Payroll system. Under Affirmative Action logic some faculty (like the President and Provost) are counted as Administrators, not as Faculty.
Acad_Dept If the employee has an academic appointment for the term, this is the department that holds that appointment. In the case of employee's with multiple appointments, this may differ from the Primary Department. This field is generated as part of the Departmental Teaching Analysis process.
Acad_Job If the employee has an academic appointment for the term, this is that appointment. In the case of employee's with multiple appointments, this may differ from the Primary Job. This field is generated as part of the Departmental Teaching Analysis process.
Adm_Jobs_Count The number of administrative appointments the employee holds for the given term.
All_Jobs_Count The total number of appointments the employee holds for the given term.
Census_Name The employee's name, as it appeared that term in the Payroll system.
Fac_Jobs_Count The number of academic appointments the employee holds for the given term.
Ssn The employee's Social Security Number. Pending the use of a unique Penn ID, this is used as a key for joining information on people.
Term The term for which the census data were generated. This takes the form of a Student Records System Term with a four-character year (including the century) followed by an upper case A, B, or C.
Univ_Census

Using University logic, this is the employee's census category for the given term. Under University census logic any standing faculty member, even the President and Provost, are counted as Faculty, not as administrators.

Values:

0   Inactive/Terminated Employee
1   A1 Primary Job (Exempt Administrative)
2   A1 Primary Job with Non-Standing Faculty secondary appointment
3   Standing Faculty member
4   Standing Faculty member with secondary administrative appointment
5   Non-Standing Faculty Primary Job
6   Non-Standing Faculty Primary Job with secondary administrative appointment
7   Primary A3 Job (Non-exempt administrative)
8   Primary A4 Job (Skilled crafts)
9   Primary A5 Job (Temporary worker)
Univ_Pri_Dpt For the given term, the department (using the Payroll department table) which holds the employee's primary appointment according to University Census logic. Under University census logic any standing faculty member, even the President and Provost, are counted as Faculty, not as administrators.
Univ_Pri_Job

The employee's primary job for the given term according to University census logic. The jobcode is a 6-digit character field and can be decoded using tables from the Payroll system. Under University census logic any standing faculty member, even the President and Provost, are counted as Faculty, not as administrators.

 

CENSUS TERM Table . Tables and Data Elements . Student Data 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