PCODES FILE
Human Resource Code
Contains the values defined for HR codes and for user fields that have valid
values.
REFERENCED BY
BN145 BN231 BN232 BN238 BN240 BN245
BN246 BN331 BN335 BN70.1 HC02.3 HCEM.1
HCLO.1 HCOP.1 HCOP.2 HCRV.1 HCUF.1 HCUL.1
HCUN.1 HPCO.1 HR00.1 HR07.1 HR11.1 HR13.1
HR15.1 HR155 HR170 HR200 HR204 HR211
HR213 HR30.1 HR507 HR511 HR513 HR515
HR54.1 HR55.2 HR55.3 HR70.1 HR700 HR704
HRS1.1 HRSC.1 HS00.1 HS11.1 HS12.1 HS13.1
HS14.1 PA02.1 PA08.1 PA08.2 PA08.3 PA100
PA102 PA111 PA115 PA120 PA13.1 PA13.2
PA149 PA15.1 PA15.2 PA16.1 PA17.1 PA172
PA20.1 PA202 PA208 PA21.1 PA211 PA212
PA214 PA215 PA216 PA217 PA218 PA22.1
PA220 PA221 PA222 PA224 PA225 PA231
PA234 PA235 PA236 PA238 PA24.1 PA241
PA242 PA248 PA249 PA25.1 PA259 PA26.1
PA262 PA263 PA272 PA290 PA300 PA305
PA31.1 PA310 PA311 PA315 PA32.1 PA320
PA325 PA330 PA335 PA34.1 PA345 PA35.1
PA350 PA355 PA36.1 PA360 PA370 PA372
PA38.1 PA391 PA40.1 PA41.1 PA42.1 PA43.1
PA43.2 PA44.1 PA45.1 PA48.1 PA49.1 PA49.2
PA49.3 PA490 PA502 PA513 PA52.1 PA52.2
PA52.3 PA52.4 PA52.5 PA520 PA53.1 PA531
PA532 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 PA66.4 PA70.1 PA71.1
PA72.1 PA73.1 PA90.1 PA90.2 PA90.3 PA91.1
PA93.4 TR00.1 TR01.1 TR02.1 TR03.1 TR04.1
TR05.1 TR10.1 TR11.1 TR12.1 TR200 TR201
TR202 TR204 TR205 TR21.1 TR210 TR22.1
TR26.1 TR500 PR03.1 PR120 PR13.1 PR131
PR134 PR136 PR139 PR212 PR214 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR37.1
PR530 TA175 TA260 TA265 UK60.1 UK70.1
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.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCO-TYPE Alpha 2 HR04.2 HR04.3
Type Contains the code types with which HR04.7 HR04.8
valid values are used. Values of 1-99 HR04.9 HR80.1
are numbers assigned to user fields that HR80.2 HR80.3
have valid values associated with them. HR80.4 HR80.5
AC = Accommodation HR80.6 HR80.7
AR = Applicant Rating HR80.8 HR80.9
AS = Association HR81.1 HR81.2
BD = Budget Reason HR81.3 HR81.4
BN = Benefit HR81.5 HR81.6
BP = Body Part HR81.7 HR81.8
BU = Bargaining Unit HR81.9 HR82.1
CC = Course Category HR82.2 HR82.3
CE = Certification HR82.4 HR82.5
CM = Communication Method HR82.6 HR82.8
CO = Requisition Cost HR82.9 HR83.1
CP = Company Property HR83.2 HR83.3
CQ = Change Request HR83.4 HR83.5
CR = Change Reason HR83.6 HR83.7
CS = CEU Source HR83.8 HR83.9
CT = Courst Type HR84.1 HR84.2
DI = Disability HR84.3 HR84.4
DP = Dependent HR84.5 HR84.6
DR = Data Requested HR84.7 HR84.8
EC = Environmental Conditions HR84.9 HR85.1
ED = Education Degree HR85.2 HR85.3
EI = Education Institution HR85.4 HR85.5
EM = Emergency Medical HR85.6 HR85.7
EO = Equipment Operated HR85.8 HR86.1
ER = Extension Reason HR86.2 HR86.3
ES = Education Subject ...
ET = Estabishment
FA = Follow Up Category
FC = Facility
FO = Follow Up Outcome
FS = Follow Up Status
FT = Follow Up Type
GA = Griev Disc Action Step Cat
GC = Griev Disc Category
GO = Griev Disc Outcome
GP = Griev Disc Action Step Type
GS = Griev Disc Status
GT = Griev Disc Action Step Outcome
HS = Hire Source
HO = Hospital
IC = Incident Category
IE = Incident Severity
IL = Illness
IN = Incident
IO = Incident Outcome
IR = Interview Rating
IS = Incident Status
I2 = Incident User 2
I3 = Incident User 3
LO = Location
MC = Cost Category
MG = Mail Group
MR = Mental Requirements
MT = Cost Type
OC = Incident Cost Category
OT = Incident Cost Type
PC = Primary Care Physician
PF = Proficiency Level
PH = Physical Requirements
PL = Parking Lot
PO = Position Reason
PR = Performance Rating
PY = Physician
RA = Personnel Action Reason
RC = Reason for Cancellation
RE = Religion
RL = Relocation
RQ = Requisition Status
RS = Reason
RT = Review Type
SC = Internal Security
SK = Skill
SR = Supervisor Received
SS = Skill Source
SU = Supervisor
S1 = Supervisor User Field 1
S2 = Supervisor User Field 2
S3 = Supervisor User Field 3
S4 = Supervisor User Field 4
S5 = Supervisor User Field 5
TA = Test Reason
TE = Test Override Reason
TF = Test Refusal Reason
TL = Test Letter
TN = Test Notify Type
TO = Test Location
TR = Travel
TS = Test Source
TT = Test Type
T2 = Test User 2
T3 = Test User 3
UL = User-defined Level
UN = Union
WR = Work Restriction
WS = Work Schedule
01 = User Field
99 = User Field
PCO-CODE Alpha 10 HR04.2 HR04.3
Code Contains the valid values for each code HR04.7 HR04.8
type. 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.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-DESCRIPTION Alpha 30 (Lower Case) HR04.2 HR04.3
Description Contains the HR Code or user field HR04.7 HR04.8
description. 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.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-ACTIVE-FLAG Alpha 1 HR04.2 HR04.3
Status Indicates if the code is active or HR04.7 HR04.8
inactive. HR04.9 HR80.1
A = Active HR80.2 HR80.3
I = Inactive 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.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-EDUC-LEVEL Numeric 3 HR04.2 HR04.3
Educational Level Contains the level associated with ED HR04.7 HR04.8
(Education) type codes. 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.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-COUNT Numeric 1 HR04.2 HR04.3
Count 1 = Excluded HR04.7 HR04.8
2 = Active 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.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 BN145 BN231
CODE BN232 BN238
BN240 BN245
BN246 BN331
BN335 BN70.1
HC02.3 HCEM.1
HCLO.1 HCOP.1
HCOP.2 HCRV.1
HCUF.1 HCUL.1
HCUN.1 HPCO.1
HR00.1 HR04.2
HR04.3 HR04.4
HR04.5 HR04.6
HR04.7 HR04.8
HR04.9 HR07.1
...
PCODES FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pcodesdtl PCODESDTL Required
PCO-TYPE -> PDD-TYPE
PCO-CODE -> PDD-CODE
PCODES FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
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
|