PCODES

Human Resource Code

Contains the values defined for HR codes and for user fields that have valid values.

REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN106
BN145 BN150 BN16.2 BN16.3 BN16.4 BN216
BN230 BN231 BN232 BN234 BN238 BN240
BN242 BN245 BN246 BN305 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN320 BN331 BN335
BN47.1 BN53.1 BN531 BN532 BN54.2 BN547
BN554 BN70.1 BN71.1 BN72.1 BS03.1 BS03.2
BS03.3 BS32.1 XB520 HC02.5 HCDL.1 HCEM.1
HCHP.1 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR00.1 HR07.1 HR11.1 HR11.2 HR13.1
HR13.2 HR13.3 HR13.4 HR15.1 HR155 HR156
HR170 HR20.1 HR200 HR206 HR211 HR213
HR217 HR22.1 HR220 HR222 HR30.1 HR507
HR51.2 HR51.3 HR51.6 HR51.8 HR511 HR513
HR515 HR54.1 HR55.2 HR55.3 HR70.1 HRS1.1
HRSC.1 HS703 PR521 EXI2.1 EXI4.1 LP01.1
LP100 LP101 LP130 LP140 LP145 LP188
LP197 LP201 LP231 LP240 LP251 LP260
LP262 LP264 LP51.1 HS00.1 HS11.1 HS11.2
HS12.1 HS12.2 HS13.1 HS13.2 HS14.1 HS50.1
HS50.2 HS50.3 HS50.4 HS51.1 HS51.2 HS52.1
HS52.2 HS701 HS702 HS704 PA02.1 PA07.1
PA08.1 PA08.2 PA08.3 PA100 PA102 PA103
PA113 PA115 PA120 PA13.1 PA13.2 PA149
PA15.1 PA15.2 PA16.1 PA17.1 PA172 PA18.1
PA202 PA208 PA210 PA211 PA212 PA214
PA215 PA216 PA217 PA218 PA220 PA221
PA222 PA223 PA224 PA225 PA227 PA231
PA234 PA235 PA236 PA238 PA241 PA242
PA248 PA249 PA25.1 PA259 PA26.1 PA262
PA263 PA272 PA290 PA292 PA294 PA296
PA31.1 PA310 PA311 PA315 PA32.1 PA320
PA325 PA330 PA335 PA345 PA350 PA355
PA360 PA370 PA372 PA390 PA391 PA40.1
PA41.1 PA42.1 PA42.3 PA43.1 PA43.2 PA44.1
PA45.1 PA48.1 PA49.1 PA49.2 PA49.3 PA490
PA495 PA496 PA502 PA513 PA52.1 PA52.2
PA52.3 PA52.4 PA52.5 PA526 PA53.1 PA531
PA534 PA535 PA54.1 PA549 PA570 PA59.1
PA59.2 PA590 PA62.1 PA63.1 PA64.1 PA64.2
PA65.1 PA65.2 PA66.2 PA66.3 PA70.1 PA71.1
PA72.1 PA73.1 PA90.1 PA90.2 PA90.3 PA91.1
PA92.2 PA93.2 PA93.4 PA94.1 TR00.1 TR01.1
TR02.1 TR03.1 TR04.1 TR05.1 TR10.1 TR11.1
TR12.1 TR120 TR121 TR20.1 TR20.2 TR20.3
TR20.4 TR200 TR201 TR202 TR204 TR205
TR210 TR22.1 TR500 PR03.1 PR110 PR113
PR120 PR128 PR13.1 PR13.5 PR13.6 PR13.7
PR13.8 PR13.9 PR130 PR131 PR132 PR134
PR135 PR136 PR137 PR139 PR189 PR212
PR214 PR252 PR29.1 PR297 PR30.1 PR313
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 PR36.1 PR37.1 PR45.1 PR529 PR530
PR560 PR582 PR80.1 PR80.4 PR82.1 PR84.1
PR89.1 UK102 UK560 TA147 TA175 TA260
TA265


UPDATED BY
HR04.2 HR04.3 HR04.7 HR04.8 HR04.9 HR04.4
HR04.5 HR04.6 HR80.1 HR80.2 HR80.3 HR80.4
HR80.5 HR80.6 HR80.7 HR80.8 HR80.9 HR81.1
HR81.2 HR81.3 HR81.4 HR81.5 HR81.6 HR81.7
HR81.8 HR81.9 HR82.1 HR82.2 HR82.3 HR82.4
HR82.5 HR82.6 HR82.7 HR82.8 HR82.9 HR83.1
HR83.2 HR83.3 HR83.4 HR83.5 HR83.6 HR83.7
HR83.8 HR83.9 HR84.1 HR84.2 HR84.3 HR84.4
HR84.5 HR84.6 HR84.7 HR84.8 HR84.9 HR85.1
HR85.2 HR85.3 HR85.4 HR85.5 HR85.6 HR85.7
HR85.8 HR86.1 HR86.2 HR86.3 HR86.4 HR86.5
HR86.6 HR86.7 HR86.8 HR86.9 HR87.1 HR87.2
HR87.3 HR87.4 HR87.5 HR87.6 HR87.7 HR87.8
HR87.9 HR88.1 HR88.2 HR88.3 HR88.4 HR88.5
HR88.6 HR88.7 HR89.1 HR89.2 HR89.3 HR89.4
HR89.5 HR89.6 HR89.7 HR89.8 HR89.9 HR91.7
HR92.1 HR92.2 HCRV.1 HHCN.1 HPCO.1 HR204
PA111 PA20.1 PA207 PA21.1 PA22.1 PA24.1
PA27.1 PA34.1 PA35.1 PA36.1 PA38.1 PA520
PA532 PA96.1 TR21.1 TR26.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCO-TYPE
Element: Type
Alpha 2
Contains the code types with which valid values are used. Values of 1-99 are numbers assigned to user fields that have valid values associated with them.
...
HR04.2 HR04.3
HR04.7 HR04.8
HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
PCO-CODE
Element: Code
Alpha 10
Contains the valid values for each code type.
...
HR04.2 HR04.3
HR04.7 HR04.8
HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
PCO-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
Contains the HR Code or user field description.
...
HR04.2 HR04.3
HR04.7 HR04.8
HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
PCO-ACTIVE-FLAG
Element: Active Flag
Alpha 1
Indicates if the code is active or inactive.
A = Active
I = Inactive
...
HR04.2 HR04.3
HR04.7 HR04.8
HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
PCO-EDUC-LEVEL
Element: Educ Level
Numeric 3
Contains the level associated with ED (Education) type codes.
...
HR04.2 HR04.3
HR04.7 HR04.8
HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
PCO-COUNT
Element: Count
Numeric 1

1 = Excluded
2 = Active
...
HR04.2 HR04.3
HR04.7 HR04.8
HR04.9 HR80.1
HR80.2 HR80.3
HR80.4 HR80.5
HR80.6 HR80.7
HR80.8 HR80.9
HR81.1 HR81.2
HR81.3 HR81.4
HR81.5 HR81.6
HR81.7 HR81.8
HR81.9 HR82.1
HR82.2 HR82.3
HR82.4 HR82.5
HR82.6 HR82.7
HR82.8 HR82.9
HR83.1 HR83.2
HR83.3 HR83.4
HR83.5 HR83.6
HR83.7 HR83.8
HR83.9 HR84.1
HR84.2 HR84.3
HR84.4 HR84.5
HR84.6 HR84.7
HR84.8 HR84.9
HR85.1 HR85.2
HR85.3 HR85.4
HR85.5 HR85.6
HR85.7 HR85.8
HR86.1 HR86.2
PCO-WEB-AVAILABLE
Element: Web Available
Alpha 1
Indicates if employee can view/update the skill/cert/education code on the Web.
1 = Not Available
2 = Display Only
3 = Update
...
HR04.2 HR04.3
HR04.7 HR04.8
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
PCO-WEB-AVAIL-SUPV
Element: Web Avail Supv
Alpha 1
Indicates if supervisor can view/update the skill/cert/ education code on the Web.
1 = Not Available
2 = Display Only
3 = Update
...
HR04.2 HR04.3
HR04.7 HR04.8
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
PCO-WORKFLOW-FLAG
Element: Workflow Flag
Alpha 1
This field determines whether you are using a Process Flow application for approving entries.
N = No
Y = Yes
...
HR04.2 HR04.3
HR04.7 HR04.8
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
PCO-HIPAA-REL-CODE
Element: Hipaa Rel Code
Numeric 2

01 = Spouse
03 = Parent
04 = Grandparent
05 = Grandchild
06 = Uncle or Aunt
07 = Nephew or Niece
08 = Cousin
09 = Adopted Child
10 = Foster Child
11 = Son- or Daughter-in-law
12 = Brither- or Sister-in-law
13 = Mother- or Father-in-law
14 = Brother or Sister
15 = Ward
17 = Stepchild
18 = Self
19 = Child
23 = Sponsored Dep
24 = Dependent of a Minor Dep
25 = Ex-Spouse
26 = Guardian
31 = Court Appt Guardian
32 = Mother
33 = Father
38 = Collateral Dependent
48 = Stepfather
49 = Stepmother
53 = Life Partner
...
HR04.2 HR04.3
HR04.7 HR04.8
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
PCO-HIPAA-REASON
Element: Hipaa Reason
Alpha 2

01 = Divorce
02 = Birth
03 = Death
04 = Retirement
05 = Adoption
06 = Strike
07 = Term Benefits
08 = Term Employment
09 = COBRA
10 = COBRA Premium
11 = Survive Spouse
14 = Vol Withdrawal
16 = Quit
17 = Fired
18 = Suspended
21 = Disability
22 = Plan Change
26 = Decline Cov
27 = Pre-Enrollment
28 = Init Enrollment
29 = Benefit Selection
31 = Legal Separation
32 = Marriage
37 = LOA w/Benefits
38 = LOA w/o Ben
39 = Layoff w/Ben
40 = Layoff w/o Ben
41 = Re-enrollment
AI = No reason given
43 = Change of Location
...
HR04.2 HR04.3
HR04.7 HR04.8
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3
PCO-RECRUIT-AVAIL
Element: Recruit Avail
Alpha 1

1 = Not available for use
2 = Available for use
PCO-PAY-WORK-FLAG
Element: Pay Work Flag
Numeric 1
This determines whether the day is eligible for pay or not and is assigned to a Day Type Code that is associated with the HRWRKDTL record.
1 = NN (Not Paid/Not Worked)
2 = PW (Paid/Worked)
3 = PN (Paid/Not Worked)
4 = NW (Not Paid/Worked
...
HR04.2 HR04.3
HR04.7 HR04.8
HR80.1 HR80.2
HR80.3 HR80.4
HR80.5 HR80.6
HR80.7 HR80.8
HR80.9 HR81.1
HR81.2 HR81.3
HR81.4 HR81.5
HR81.6 HR81.7
HR81.8 HR81.9
HR82.1 HR82.2
HR82.3 HR82.4
HR82.5 HR82.6
HR82.7 HR82.8
HR82.9 HR83.1
HR83.2 HR83.3
HR83.4 HR83.5
HR83.6 HR83.7
HR83.8 HR83.9
HR84.1 HR84.2
HR84.3 HR84.4
HR84.5 HR84.6
HR84.7 HR84.8
HR84.9 HR85.1
HR85.2 HR85.3
HR85.4 HR85.5
HR85.6 HR85.7
HR85.8 HR86.1
HR86.2 HR86.3


PCODES FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCOSET1 TYPE
CODE
...
BN100 BN101
BN102 BN103
BN105 BN106
BN145 BN150
BN16.2 BN16.3
BN16.4 BN216
BN230 BN231
BN232 BN234
BN238 BN240
BN242 BN245
BN246 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN335
PCOSET2 CODE
TYPE
HPCO.1 HR204
PA20.1 PA207
PA21.1 PA22.1
PA24.1 PA27.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 PA96.1
TR21.1 TR26.1


PCODES FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Pcodesdtl PCODESDTL Not Required
PCO-TYPE->PDD-TYPE
PCO-CODE->PDD-CODE
Pcodestype PCODESTYPE Not Required
PCO-TYPE->PCS-TYPE


PCODES FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Bargain Emps PATHFIND
Valid When PCO-TYPE ="BU"
22->PTF-FLD-NBR
PCO-CODE->PTF-FLD-VALUE
  PTF-COMPANY
  PTF-EMPLOYEE
  PTF-POS-LEVEL
Comp Profic PACOMPPROF Delete Cascades
Valid When (PCO-TYPE ="AB" )
Or(PCO-TYPE ="KN" )
Or(PCO-TYPE ="OA" )
Or(PCO-TYPE ="SK" )
PCO-CODE->PCM-CODE
PCO-TYPE->PCM-TYPE
  PCM-COMPANY
  PCM-PROCESS-LEVEL
  PCM-SEQ
  PCM-PROFIC-LEVEL
Course Compet PAATTRIB Delete Cascades
Valid When (PCO-TYPE ="AB" )
Or(PCO-TYPE ="KN" )
Or(PCO-TYPE ="OA" )
Or(PCO-TYPE ="SK" )
PCO-TYPE->TRB-TYPE
PCO-CODE->TRB-CODE
  TRB-COURSE
Course Skills PAATTRIB Delete Cascades
Valid When (PCO-TYPE ="SK" )
PCO-TYPE->TRB-TYPE
PCO-CODE->TRB-CODE
  TRB-COURSE
Location Emps PATHFIND
Valid When PCO-TYPE ="LO"
17->PTF-FLD-NBR
PCO-CODE->PTF-FLD-VALUE
  PTF-COMPANY
  PTF-EMPLOYEE
  PTF-POS-LEVEL
Proficiency PACOMPPROF Delete Cascades
Valid When (PCO-TYPE ="PF" )
PCO-CODE->PCM-PROFIC-LEVEL
  PCM-COMPANY
  PCM-PROCESS-LEVEL
  PCM-TYPE
  PCM-CODE
Track Cert PATRACK
Valid When PCO-TYPE ="CE"
PCO-CODE->TRA-CERT-ACHIEVED
  TRA-TRACK
  TRA-EFFECTIVE-DATE
Union Emps PATHFIND
Valid When PCO-TYPE ="UN"
21->PTF-FLD-NBR
PCO-CODE->PTF-FLD-VALUE
  PTF-COMPANY
  PTF-EMPLOYEE
  PTF-POS-LEVEL
User Lev Emps PATHFIND
Valid When PCO-TYPE ="UL"
16->PTF-FLD-NBR
PCO-CODE->PTF-FLD-VALUE
  PTF-COMPANY
  PTF-EMPLOYEE
  PTF-POS-LEVEL


File created: Wed Jun 08 20:49:15 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.