PA PIMS Report - Staff Or Staff Snapshot

1

District Code

The unique, nine-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education (PDE).

Numeric(9)

hrmstate.state2 (first 9 characters)

2

Staff ID

A unique identifier for each staff member.

Use the seven-digit Professional Personnel ID (PPID) for all certified and non-certified staff. 

Do not use leading zeros or spaces.

Numeric(7)

pa_pims_mnt.ppid

3

Social Security Number

The nine-digit number of identification assigned to the individual by the Social Security Administration.

Omit dashes.

Numeric(9)

pa_pims_mnt.ssn

4

Not Used

Not Applicable

Not Applicable

Not Applicable

5

Not Used

Not Applicable

Not Applicable

Not Applicable

6

Not Used

Not Applicable

Not Applicable

Not Applicable

7

Not Used

Not Applicable

Not Applicable

Not Applicable

8

Job Description

The level of access that should be granted in the Pennsylvania Value-Added Assessment System (PVAAS) Roster Verification System for this school year.

Valid values:

• LWS - LEA-wide and Student Access

• LNS - LEA-wide and No Student Access

• SWS - School and Student Access

• SNS - School and No Student Access

• NPA - No PVAAS Access

Char(3)

pa_pims_mnt.pvaas_role

9

Not Used

Not Applicable

Not Applicable

Not Applicable

10

Not Used

Not Applicable

Not Applicable

Not Applicable

11

Not Used

Not Applicable

Not Applicable

Not Applicable

12

Not Used

Not Applicable

Not Applicable

Not Applicable

13

Not Used

Not Applicable

Not Applicable

Not Applicable

14

Location Code

The PDE-defined, four-digit school code identifying the staff member's primary school of employment.

Numeric(4)

pa_pims_mnt.location

15

Not Used

Not Applicable

Not Applicable

Not Applicable

16

Not Used

Not Applicable

Not Applicable

Not Applicable

17

Staff Employment Type Code

Indicates whether an individual is employed for a standard number of hours (as determined by civil or organizational policies) in a week, month, or another period.

Valid Values:

• F for full time

• P for part-time

Char(1)

pa_pims_mnt.part_time

18

Not Used

Not Applicable

Not Applicable

Not Applicable

19

Not Used

Not Applicable

Not Applicable

Not Applicable

20

Gender

The employee's gender.

Char(1)

pa_pims_mnt.sex

21

Race or Ethnicity Code

The general racial or ethnic category that reflects the individual's recognition of their community or with which they most identify.

Char(2)

pa_pims_mnt.race

22

Not Used

Not Applicable

Not Applicable

Not Applicable

23

Home Phone

The telephone number, including the area code and extension, if applicable.

Char(14)

Optional – not supplied

24

Not Used

Not Applicable

Not Applicable

Not Applicable

25

Address 1

The street number, street name, or post office box number of the home address.

Char(40)

employee.addr1

26

Address 2

Additional street address information.

Char(40)

employee.addr2

27

City

The name of the city.

Char(30)

employee.city

28

State

The two-character abbreviation for the state, if within the United States, or outlying area in which an address is located.

Char(2)

employee.state_id

29

Full Zip Code

The five- or nine-digit zip code portion of the home address.

Char(10)

employee.zip

30

Not Used

Not Applicable

Not Applicable

Not Applicable

31

Not Used

Not Applicable

Not Applicable

Not Applicable

32

Not Used

Not Applicable

Not Applicable

Not Applicable

33

Not Used

Not Applicable

Not Applicable

Not Applicable

34

Not Used

Not Applicable

Not Applicable

Not Applicable

35

Current Service Date

The month, day, and year an individual was hired for a position.

This must be the date the employee was first hired for the current position, even if that is a prior year.

The format is YYYY-MM-DD

Char(10)

pa_pims_mnt.hire_date

36

Exit Date

The month, day, and year an individual ended a period of self-employment or employment with an organization or institution.

This field is required for exited staff only.

The format is YYYY-MM-DD

Char(10)

pa_pims_mnt.term_date

37

Not Used

Not Applicable

Not Applicable

Not Applicable

38

Not Used

Not Applicable

Not Applicable

Not Applicable

39

Years Experience

The total years an individual has worked in one or more educational institutions.

Enter whole numbers only, not fractions or decimals.

You should report an individual in their first year as 1.

Numeric(2)

pa_pims_mnt.tot_exp

40

Birth Date

The employee's birth date.

The format is YYYY-MM-DD

Char(10)

pa_pims_mnt.birth_date

41

Active/Inactive Indicator

Valid Values:

• A – active

• T – terminated

• M – military leave

• S – sabbatical leave

• U – suspension

• O – other

• H – charter school

• W – workers’ compensation

Char(1)

pa_pims_mnt.active_inact

42

Not Used

Not Applicable

Not Applicable

Not Applicable

43

Years Experience In District

The total number of consecutive years an individual has worked for the Local Education Agency (LEA).

Numeric(2)

pa_pims_mnt.dist_exp

44

Job Class Code Long

The category that most reflects the nature and degree of an individual’s participation in the workforce.

Valid values (after 8/31/2023):

• CP - College Professor

• NTPE - Non-teaching Professional Employee

• PE - Teaching Professional Employee

• SC - Subcontracted Employee

• SP - Substitute other than Professional or Temporary Professional

• SPE - Substitute

• TPE - Temporary Professional Employee

Char(4)

pa_pims_mnt.empl_basis

45

Not Used

Not Applicable

Not Applicable

Not Applicable

46

Not Used

Not Applicable

Not Applicable

Not Applicable

47

Not Used

Not Applicable

Not Applicable

Not Applicable

48

Not Used

Not Applicable

Not Applicable

Not Applicable

49

Not Used

Not Applicable

Not Applicable

Not Applicable

50

Snapshot Date

Indicates the reporting period date for the staff record.

Required for the Staff Snapshot.

The format is YYYY-MM-DD

Char(10)

Snapshot date entered

51

Not Used

Not Applicable

Not Applicable

Not Applicable

52

Annual Salary

The gross salary or wage (in whole dollars only) an individual is paid before deductions (excluding differentials).

Numeric(10)

pa_pims_mnt.salary

53

Not Used

Not Applicable

Not Applicable

Not Applicable

54

Termination Code

The primary reason for the termination of the employment relationship.

Valid values:

• 01 – resigned / terminated, remained in education

• 02 – resigned / terminated, left education

• 03 – furloughed / laid off

• 06 – retired

• 07 – death / illness

• 08 – other

• 14 – disciplinary action

• 15 – Retired PPID (use only if directed by PDE for PPIDs reported incorrectly in prior years that cannot be corrected)

Char(2)

pa_pims_mnt.term_code

55

Not Used

Not Applicable

Not Applicable

Not Applicable

56

Not Used

Not Applicable

Not Applicable

Not Applicable

57

Alternate Staff Id

A unique number or alphanumeric code assigned by the LEA to identify a staff member.

Numeric(9)

pa_pims_mnt.empl_no

58

Not Used

Not Applicable

Not Applicable

Not Applicable

59

Not Used

Not Applicable

Not Applicable

Not Applicable

60

Not Used

Not Applicable

Not Applicable

Not Applicable

61

Not Used

Not Applicable

Not Applicable

Not Applicable

62

Not Used

Not Applicable

Not Applicable

Not Applicable

63

Local Contract

Indicates whether the staff member has a current contract or is working without one because the contract is currently in negotiations.

Char(1)

pa_pims_mnt.local_contract

64

Not Used

Not Applicable

Not Applicable

Not Applicable

65

First Name Long

A legal name given to an individual at birth, baptism, during another naming ceremony, or through legal change.

Char(60)

pa_pims_mnt.fname

66

Last Name Long

The legal name borne in common by family members, also known as a surname.

Char(60)

pa_pims_mnt.lname

67

Name Suffix

An appendage, if any, used to denote an individual’s generation in his family.

For example: Jr., Sr., III

Char(10)

pa_pims_mnt.fname

68

Not Used

Not Applicable

Not Applicable

Not Applicable

68

Not Used

Not Applicable

Not Applicable

Not Applicable

69

Not Used

Not Applicable

Not Applicable

Not Applicable

70

Not Used

Not Applicable

Not Applicable

Not Applicable

71

Highest Degree Institution Code

The extent of formal instruction an individual has received, such as the highest grade in school completed, its equivalent, or the highest degree received.

Valid values:

• 1044 high school diploma

• 2409 high school equivalency (e.g., GED)

• 0819 vocational certificate – no college degree

• 1049 some college but no degree

• 1050 Associate's degree (two years or more)

• 1051 Bachelor's (Baccalaureate) degree (e.g., B.A., A.B., B.S.)

• 1054 Master's degree (e.g., M.A., M.S., M. Eng., M.Ed., M.S.W., M.B.A., M.L.S.)

• 1055 Specialist's degree (e.g., Ed.S.)

• 1057 Doctoral (Doctor's) degree (e.g., Ph.D., Ed.D.)

• 9998 less than HS graduate

Char(4)

pa_pims_mnt.degree

72

Not Used

Not Applicable

Not Applicable

Not Applicable

73

Not Used

Not Applicable

Not Applicable

Not Applicable

74

Not Used

Not Applicable

Not Applicable

Not Applicable

75

Not Used

Not Applicable

Not Applicable

Not Applicable

76

E-mail Address

The numbers, letters, and symbols used to identify an e-mail user within the network to which the individual or organization belongs.

Char(80)

pa_pims_mnt.email_addr

77

Middle Name

A secondary name given to an individual at birth, baptism, or during another naming ceremony.

Char(60)

pa_pims_mnt.mname

78

Not Used

Not Applicable

Not Applicable

Not Applicable

79

Not Used

Not Applicable

Not Applicable

Not Applicable

80

Not Used

Not Applicable

Not Applicable

Not Applicable

81

Not Used

Not Applicable

Not Applicable

Not Applicable

82

Not Used

Not Applicable

Not Applicable

Not Applicable

83

Not Used

Not Applicable

Not Applicable

Not Applicable

84

Not Used

Not Applicable

Not Applicable

Not Applicable

85

Not Used

Not Applicable

Not Applicable

Not Applicable

86

Not Used

Not Applicable

Not Applicable

Not Applicable

87

Not Used

Not Applicable

Not Applicable

Not Applicable

88

Not Used

Not Applicable

Not Applicable

Not Applicable

89

Not Used

Not Applicable

Not Applicable

Not Applicable

90

Not Used

Not Applicable

Not Applicable

Not Applicable

91

Not Used

Not Applicable

Not Applicable

Not Applicable

92

Not Used

Not Applicable

Not Applicable

Not Applicable

93

Not Used

Not Applicable

Not Applicable

Not Applicable

94

Not Used

Not Applicable

Not Applicable

Not Applicable

95

Not Used

Not Applicable

Not Applicable

Not Applicable

96

Not Used

Not Applicable

Not Applicable

Not Applicable

97

Not Used

Not Applicable

Not Applicable

Not Applicable

98

Not Used

Not Applicable

Not Applicable

Not Applicable

99

Not Used

Not Applicable

Not Applicable

Not Applicable

100

Not Used

Not Applicable

Not Applicable

Not Applicable

101

Not Used

Not Applicable

Not Applicable

Not Applicable

102

Not Used

Not Applicable

Not Applicable

Not Applicable

103

Not Used

Not Applicable

Not Applicable

Not Applicable

104

Not Used

Not Applicable

Not Applicable

Not Applicable

105

Not Used

Not Applicable

Not Applicable

Not Applicable

106

Not Used

Not Applicable

Not Applicable

Not Applicable

107

Not Used

Not Applicable

Not Applicable

Not Applicable

108

Not Used

Not Applicable

Not Applicable

Not Applicable

109

Not Used

Not Applicable

Not Applicable

Not Applicable

110

Not Used

Not Applicable

Not Applicable

Not Applicable

111

Not Used

Not Applicable

Not Applicable

Not Applicable

112

Not Used

Not Applicable

Not Applicable

Not Applicable

113

Not Used

Not Applicable

Not Applicable

Not Applicable

114

Not Used

Not Applicable

Not Applicable

Not Applicable

115

Not Used

Not Applicable

Not Applicable

Not Applicable

116

Gender Identity

The employee's gender identity.

Char(1)

person.gender_identity or gender_identity_tbl.state_code if either are equal to X