| 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 Addres") |
| 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 |