HRPERSNL - Employee Personnel (PE) Database

HRPERSNL field information

Order Field Name Type Length Dec Description

1

P_ABORIG

C

1

0

Aboriginal? (Y/N)

2

P_ABOTYPE

C

1

0

Aboriginal Code

3

P_ACCUMCUR

L

1

0

Accumulate Current Figures Next Payroll

4

P_ACTIVE

C

1

0

Employee Status Code(A/T/L/D/N)

5

P_AFMEDVET

C

1

0

Armed Forces Medal Veteran (Y/N)

6

P_ALLOCBY

C

1

0

Allocate Method Code (P/H)

7

P_ANNUAL

N

18

5

Annual Pay

8

P_ANYCHANG

T

8

0

Last Change to Any Data-Item

9

P_AUTOHOL

C

4

0

Earning Code for Holiday Pay

10

P_AUTOILL

C

4

0

Earning Code for Illness Pay

11

P_AUTOPAY

L

1

0

Automatic Timesheet Indicator

12

P_AUTOPER

C

4

0

Earning Code for Personal Pay

13

P_AUTOREG

C

4

0

Earning Code for Regular Pay

14

P_AUTOVAC

C

4

0

Earning Code for Vacation Pay

15

P_AWCINUSE

L

1

0

In Use by OE/LE (T/F

16

P_BEN_EXP

T

8

0

Latest Benefit Expiration Date

17

P_BIRTH

T

8

0

Birth Date

18

P_BONUS

C

2

0

Bonus

19

P_BONUSAMT

N

13

2

Bonus Amount

20

P_BUSEXT

C

4

0

Business Phone Extension

21

P_BUSPHONE

C

13

0

Business Phone

22

P_CAMPVET

C

1

0

Campaign Veteran (Y/N)

23

P_CELLULAR

C

13

0

Cellular Phone

24

P_CFICATIP

N

9

2

Tips Component of Current FICA Wage

25

P_CHADATE

T

8

0

Last Change Date

26

P_CITIZEN

C

12

0

Citizenship

27

P_CMA

C

3

0

Census Metro Area Code

28

P_COBRA

C

1

0

COBRA Code (Y/N/P/E/S)

29

P_COMPANY

C

3

0

Company Code

30

P_COMPARAT

N

6

2

Comparatio

31

P_CONSDATE

T

8

0

Consent Date

32

P_CONSENT

C

1

0

Consent Received (Y/N)

33

P_CONSTYPE

C

1

0

Type of Consent

34

P_CURRENCY

C

3

0

Currency Type (USD/CAD)

35

P_CURTIPS

N

9

2

Reported Tips for Current Period

36

P_DEPINSUR

N

2

0

Number of Insured Dependents

37

P_DEPNDTS

N

2

0

Number of Dependents

38

P_DISAVET

C

1

0

Disabled Veteran (Y/N)

39

P_discharg

T

8

0

Active Duty Discharge Date

40

P_DISTYPE

C

1

0

Disability Code

41

P_EEEC

C

2

0

EE Employment Category Code

42

P_EEOCLASS

C

6

0

EEO Classification Code

43

P_EEOG

C

2

0

EE Occupational Group Code

44

P_EEORPT

C

1

0

EEO Reporting (Y/N)

45

P_EERPT

C

1

0

EE Reporting (Y/N)

46

P_EFFDATE

T

8

0

Change Effective Date for Job Data

47

P_EIC

L

1

0

EIC Eligibility (T/F)

48

P_EICMSTAT

C

1

0

EIC Marital Status Code (N/M/S/O)

49

P_EMPEMAIL

C

64

0

E-Mail Address

50 P_EMPFAX

C

13

0

Employee Fax
51

P_EMPLOY

C

3

0

Employee Type Code (RFT, RPT, etc.)

52

P_EMPNO

C

9

0

Employee ID

53

P_EMPPROV

C

2

0

Province of Employment

54

P_EMPTYPE

C

1

0

Employee Job Type (Payroll)

55

P_EXEMPT

C

1

0

Exempt (Y/N)

56

P_EXTCDATE

T

8

0

Benefits Extended Coverage Date

57

P_FCITY

C

20

0

Forwarding Address City

58

P_FCOUNTRY

C

12

0

Forwarding Address Country

59

P_FCOUNTY

C

15

0

Forwarding Address County

60

P_FNAME

C

15

0

First Name

61

P_FOLLOWUP

T

8

0

Consent Follow Up Date

62

P_FSTATE

C

3

0

Forwarding Address State Code

63

P_FSTREET1

C

28

0

Forwarding Address Street 1

64

P_FSTREET2

C

28

0

Forwarding Address Street 2

65

P_FUNCTION

C

2

0

EEO-4 Job Category Function

66

P_FZIP

C

10

0

Forwarding Address ZIP Code

67

P_GRSTEP

N

2

0

Employee's Step Rate

68

P_GUID

C

36

0

Unique Employee ID

69

P_HANDICAP

C

1

0

Disability (Y/N)

70

P_HCITY

C

20

0

Home Address City

71

P_HCOUNTRY

C

12

0

Home Address Country

72

P_HCOUNTY

C

15

0

Home Address County

73

P_HIREMAN

C

1

0

Hiring Manager (Y/N)

74

P_HPHONE

C

13

0

Home Phone

75

P_HSTATE

C

3

0

Home Address State/Province Code

76

P_HSTREET1

C

28

0

Home Address Street 1

77

P_HSTREET2

C

28

0

Home Address Street 2

78

P_HZIP

C

10

0

Home Address ZIP Code

79

P_I9RENEW

T

8

0

I-9 Reverification Date

80

P_I9VERIF

C

1

0

I-9 Verification Status (Y/N/P)

81

P_ILLACCR

N

11

5

Amount of Illness Leave Accrued

82

P_ILLCARRY

N

11

5

Amount of Illness Carryover At Year-End

83

P_ILLCLOSE

N

11

5

Amount of Illness Carryover At Mid-Year

84

P_ILLIND

C

1

0

Method of Illness Accrual Code (A/H

85

P_ILLRATE

N

11

5

Illness Leave Accrual Rate

86

P_ILLTAKEN

N

11

5

Amount of Illness Leave Taken

87

P_INDUSTRY

C

2

0

Industrial Sector Code

88

P_JMISC1

C

10

0

User-Defined 1 (Current Pay)

89

P_JMISC2

C

15

0

User-Defined 2 (Current Pay)

90

P_JMISC3

N

10

2

User-Defined 3 (Current Pay)

91

P_JMISC4

N

10

2

User-Defined 4 (Current Pay)

92

P_JOBCLASS

C

6

0

Job Classification Code

93

P_JOBCODE

C

8

0

Job Code

94

P_JOBDATE

T

8

0

Job Start Date

95

P_JOBGROUP

C

6

0

EEO Job Group Code

96

P_JOBGRPPE

C

6

0

EE Job Group Code

97

P_JOBSERV

N

3

0

Job Service in Months

98

P_JOBTITLE

C

25

0

Job Title

99

P_JSDATE

T

8

0

Job Service Date

100

P_LABORIND

C

15

0

Direct/Indirect Labor Indicator

101

P_LANGUAGE

C

3

0

Language Code

102

P_LASTCHK

T

8

0

Check Date for Last Payment Issued

103

P_LASTHIRE

T

8

0

Last Hire Date

104

P_LEAVERET

T

8

0

No Longer Used

105

P_LEVEL1

C

12

0

Division Code

106

P_LEVEL2

C

12

0

Department Code

107

P_LEVEL3

C

12

0

Location Code

108

P_LEVEL4

C

12

0

Not Defined

109

P_LEVEL5

C

12

0

Not Defined

110

P_LNAME

C

25

0

Last Name

111

P_LNORMU

N

10

4

Last Hours/Units Per Pay Period

112

P_LOCATION

C

12

0

Worksite Location Code

113

P_LPAYDATE

T

8

0

Last Pay Effective Date

114

P_LPAYFREQ

C

1

0

Last Pay Frequency

115

P_LSALARY

N

16

5

Last Pay Period Salary

116

P_LSTPAYDT

T

8

0

Last Pay Period Ending Date

117

P_LUNITR

N

11

5

Last Unit Pay Rate

118

P_MAILSTOP

C

6

0

Mail Stop

119

P_MARRIED

C

1

0

Marital Status Code (M/S/W/D/O/P)

120

P_MI

C

15

0

Middle Name

121

P_MILITARY

C

10

0

Military Experience

122

P_MINORITY

C

1

0

Visible Minority (Y/N)

123

P_MINTYPE

C

1

0

Visible Minority Code

124

P_MISC1

C

6

0

User-Defined 1 (HR Status)

125

P_MISC2

C

10

0

User-Defined 2 (HR Status)

126

P_MISC3

C

15

0

User-Defined 3 (HR Status)

127

P_MISC4

N

10

2

User-Defined 4 (HR Status)

128

P_NEXTPAY

T

8

0

Next Pay Review Due Date

129

P_NEXTPERF

T

8

0

Next Performance Review Due Date

130

P_NICKNAME

C

14

0

Nickname

131

P_NOC

C

4

0

N.O.C.

132

P_NORMUNIT

N

11

5

Hours/Units Per Pay Period

133

P_NOTES

C

150

0

Termination Notes

134

P_ORIGHIRE

T

8

0

Original Hire Date

135

P_OTHERID

N

10

0

Other ID

136

P_OTHERVET

C

1

0

Other Protected Veteran (Y/N)

137

P_OVERTIME

C

1

0

Overtime Eligible Y/N

138

P_PAGER

C

13

0

Pager Number

139

P_PAYDATE

T

8

0

Pay Effective Date

140

P_PAYFREQ

C

1

0

Pay Frequency Code (W/B/S/M)

141

P_PAYGROUP

C

3

0

Employee Pay Group Code

142

P_PAYSTAT

C

1

0

Employee Payroll Status Code (A/I/T)

143

P_PENSION

L

1

0

Pension Plan Indicator (T/F)

144

P_PERACCR

N

11

5

Amount of Personal Time Accrued

145

P_PERCARRY

N

11

5

Amount of Personal Carryover At Year End

146

P_PERCLOSE

N

11

5

Amount of Personal Carryover At Mid Year

147

P_PERFDATE

T

8

0

Performance Review Date

148

P_PERIND

C

1

0

Method of Personal Accrual Code (A/

149

P_PERRATE

N

11

5

Personal Time Accrual Rate

150

P_PERTAKEN

N

11

5

Amount of Personal Time Taken

151

P_QFICATIP

N

10

2

QTD Tips Amount of FSOC Wages

152

P_QTDUNTAX

N

9

2

Uncollected Tax on Tips QTD

153

P_QTIPALLO

N

10

2

QTD Allocated Tips

154

P_QTIPSREP

N

10

2

QTD Reported Tips

155

P_QUESCOM

C

150

0

Questionnaire Comment

156

P_QUESDATE

T

8

0

Questionnaire Completion Date

157

P_QUESTION

C

1

0

Questionnaire Completed? (Y/N)

158

P_RACE

C

1

0

Ethnic Origin Code

159

P_RATING

C

5

0

Performance Review Rating Code

160

P_REASON

C

8

0

Change Reason Code

161

P_RECALC

C

1

0

Recalculate Trial Payroll Flag

162

P_RECRUTR

C

6

0

Recruiter Who Hired This Employee

163

P_REHIRE

C

1

0

Rehire Employee (Y/N)

164

P_SALARY

N

16

5

Pay Period Salary

165

P_SALGRADE

C

6

0

Salary Grade Code

166

P_SALHOUR

C

1

0

Salaried/Hourly Code (S/H)

167

P_SALUT

C

6

0

Salutation (Dr./Ms./Mrs./Mr.)

168

P_SEASONAL

C

1

0

Seasonal Worker (Y/N)

169

P_SENDATE

T

8

0

Adjusted Seniority Date

170

P_SEX

C

1

0

Gender Code (M/F)

171

P_SHIFT

C

2

0

Shift Code

172

P_SHIFTPRE

N

9

4

Shift Premium

173

P_SMOKER

C

1

0

Smoker (Y/N)

174

P_SOURCE

C

25

0

Source of Hire

175

P_SSN

C

11

0

Social Security Number

176

P_SSNSIN

C

2

0

SSN or SIN (US/CN)

177

P_STATUTE

L

1

0

Statutory Indicator (T/F)

178

P_SUP2CO

C

3

0

Supervisor Company (formerly "Secondary Supervisor Company ")

179

P_SUP2MAIL

C

64

0

Supervisor E-Mail Address (formerly "Secondary Supervisor E-Mail Address")

180

P_SUP2NO

C

9

0

Supervisor ID Number (formerly "Secondary Supervisor ID Number")

181

P_SUP2VIS

C

25

0

Supervisor Name (formerly "Secondary Supervisor Name ")

182

P_SUPEMAIL

C

64

0

Manager E-Mail Address (formerly "Supervisor E-Mail Address")

183

P_SUPERCO

C

3

0

Manager Company (formerly "Supervisor Company ")

184

P_SUPERNO

C

9

0

Manager ID Number (formerly "Supervisor ID Number")

185

P_SUPERVIS

C

25

0

Manager Name (formerly "Supervisor Name ")

186

P_SYNCBPS

C

1

0

Sync this Employee to BPS

187

P_TERMDATE

T

8

0

Termination Date

188

P_TERMREAS

C

8

0

Termination Reason Code

189

P_TERMTYPE

C

1

0

Termination Type (V/I/U)

190

P_TSTAMP

C

16

0

Time Sheet Time and Date Stamp

191

P_UNIONCD

C

6

0

Union Affiliation Code

192

P_UNIONDT

T

8

0

Union Affiliation Date

193

P_UNITPAY

C

6

0

Units of Pay Code

194

P_UNITRATE

N

11

5

Unit Pay Rate

195

P_VACACCR

N

11

5

Amount of Vacation Accrued

196

P_VACCARRY

N

11

5

Amount of Vacation Carryover At Year End

197

P_VACCLOSE

N

11

5

Amount of Vacation Carryover At Mid Year

198

P_VACDATE

T

8

0

Vacation: Service Date

199

P_VACIND

C

1

0

Method of Vacation Accrual

200

P_VACRATE

N

11

5

Vacation Accrual Rate

201

P_VACTAKEN

N

11

5

Amount of Vacation Taken

202

P_VIETNAM

C

1

0

Vietnam Era Veteran (Y/N)

203

P_VISAEXP

T

8

0

Visa Expiration Date

204

P_VISATYPE

C

9

0

Visa Type

205

P_WORKCODE

C

4

0

Time Sheet Work Code

206

P_WORKCOMP

C

6

0

Workers Compensation Code

207

P_WORKRATE

N

9

5

Workers Compensation Rate

208

P_YFICATIP

N

10

2

YTD Tips Amount of FSOC Wages

209

P_YTDUNTAX

N

9

2

Uncollected Tax on Tips YTD

210

P_YTIPALLO

N

10

2

YTD Allocated Tips

211

P_YTIPSREP

N

10

2

YTD Reported Tips

212

_ACTIVE

C

25

0

Employee Status Description

213

_AFMEDVET

C

3

0

Armed Forces Service Medal Veteran (Yes/No)
214

_AN1000

C

25

0

Annual Pay Rounded To Thousand

215

_ANNUAL

C

25

0

Employee's Annual Pay

216

_CAMPVET

C

3

0

Campaign Veteran (Yes/No)
217

_COBRA

C

25

0

COBRA Description (Yes/No/Pending/etc)

218

_DISAVET

C

3

0

Disabled Veteran Description (Yes/No)

219

_EEOCLASS

C

25

0

EEO Classification Description

220

_EMPLOY

C

25

0

Employee Type Description

221

_EXEMPT

C

25

0

Exempt Description

222

_FSTATE

C

25

0

Forwarding Address State Description

223

_HSTATE

C

25

0

State Description

224

_I9VERIF

C

25

0

I-9 Verification Status Description

225

_JOBCODE

C

25

0

Job Code Description

226

_JOBGROUP

C

25

0

EEO Job Group Description

227

_LEVEL1

C

25

0

Division

228

_LEVEL2

C

25

0

Department

229

_LEVEL3

C

25

0

Location

230

_LEVEL4

C

25

0

Not Defined Description

231

_LEVEL5

C

25

0

Not Defined Description

232

_LOCATION

C

25

0

Work Location Description

233

_MARRIED

C

25

0

Marital Status Description

234

_NAME1

C

55

0

Name: Last, First Middle

235

_NAME2

C

55

0

Name: First Middle Last

236

_PAYFREQ

C

25

0

Pay Frequency Description

237

_RACE

C

25

0

Ethnic Origin Description

238

_RATING

C

25

0

Performance Review Rating Description

239

_REASON

C

25

0

Pay Change Reason Description

240

_REHIRE

C

3

0

Rehire Employee Description (Yes/No)

241

_SALGRADE

C

25

0

Salary Grade Description

242

_SALHOUR

C

25

0

Salary/Hourly Description

243

_SEASONAL

C

3

0

Seasonal Worker Description

244

_SEX

C

25

0

Gender Description (Male/Female)

245

_SHIFT

C

25

0

Shift Description

246

_SMOKER

C

25

0

Smoker Description (Yes/No)

247

_TERMREAS

C

25

0

Termination Reason Description

248

_TERMTYPE

C

25

0

Termination Type Description

249

_UNIONCD

C

25

0

Union Affiliation Description

250

_UNITPAY

C

25

0

Units of Pay Description

251

_VIETNAM

C

3

0

Vietnam Veteran Description (Yes/No)

252

_ZFILTER

C

25

0

Filter Function