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