PACOMMENTS FILE
Personnel Comments
The Personnel Comments file contains comments for employees or applicants.
REFERENCED BY
HR211 HR213 PA208 PA212 PA214 PA215
PA216 PA218 PA219 PA220 PA221 PA222
PA224 PA225 PA231 PA232 PA233 PA234
PA235 PA236 PA238 PA239 PA240 PA241
PA242 PA290 PA311 PA350 PA532 PA66.1
PA66.2 PA66.4 PR134 PR135 PR160 PA213
PA340
UPDATED BY
HR13.1 HR513 HR54.1 HR700 HR90.1 HR90.2
HRS1.1 HRSC.1 PA02.1 PA09.1 PA100 PA102
PA115 PA120 PA130 PA135 PA19.1 PA33.1
PA41.1 PA42.1 PA43.1 PA43.2 PA46.1 PA502
PA52.1 PA52.3 PA52.4 PA52.5 PA52.2 PA533
PA54.1 PA56.1 PR300 HR00.1 HR01.1 HR06.1
HR11.1 PA12.1 PA14.1 PA15.1 PA15.2 PA16.1
PA18.1 PA20.1 PA21.1 PA22.1 PA24.1 PA25.1
PA26.1 PA32.1 PA34.1 PA35.1 PA36.1 PA372
PA38.1 PA39.1 PA40.1 PA512 PA590 PA90.1
PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAC-COMPANY Numeric 4 HR90.1 HR90.2
Company Contains the company number which PA09.1 PA46.1
represents an established company. PA56.1
PAC-EMP-APP Numeric 1 HR54.1 HR700
Type Indicates whether the person is an HR90.1 HR90.2
external or internal applicant. HRS1.1 HRSC.1
PA09.1 PA100
An external applicant is a person PA102 PA46.1
applying from outside the company; an PA52.1 PA52.3
internal applicant is an employee PA52.4 PA52.5
applying from inside the company. PA54.1 PA56.1
PAC-CMT-TYPE Alpha 2 HR90.1 HR90.2
Comment Type Contains the comment type. PA09.1 PA46.1
BN = Benefit PA56.1
CE = Certification
CK = Payment
CP = Company Property
DP = Dependent
EC = Emergency Contact
ED = Education
GE = General
IV = Interview
JD = Job Description
JH = Job History
JR = Job Requisition
MD = Medical
MI = Military
OS = OSHA
PA = Personnel Action
RL = Relocation
RF = Reference
RV = Review
SK = Skill
TR = Time Record
TV = Travel
WR = Work Restriction
PAC-EMPLOYEE Numeric 9 HR54.1 HR700
Employee Contains the employee or applicant HR90.1 HR90.2
number for comments. This value is zero HRS1.1 HRSC.1
for job descriptions and personnel PA09.1 PA100
action comments. PA102 PA46.1
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PA56.1
PAC-JOB-CODE Alpha 9 HR90.1 PA09.1
Job Code Contains the job code for job PA46.1 PA56.1
description comments. This value is
blank for employee, applicant, and
personnel action comments.
PAC-ACTION-CODE Alpha 10 HR90.1 PA09.1
Action Code Contains the action code for personnel PA46.1 PA56.1
action comments. This value is blank for
employee, applicant, and job description
comments.
PAC-LN-NBR Numeric 4 HR54.1 HR700
Line Number Contains the comment type number. Valid HR90.1 HR90.2
values are: HRS1.1 HRSC.1
PA09.1 PA100
IV = Interview sequence number. PA102 PA46.1
JH = Applicant job history sequence PA52.1 PA52.3
number. PA52.4 PA52.5
DP = Dependent number. PA54.1 PA56.1
RV = Performance review sequence number.
PA = Personnel action number.
All others = Zero.
PAC-SEQ-NBR Numeric 4 HR54.1 HR700
Sequence Number Contains a sequence number that keeps HR90.1 HR90.2
records unique. It is automatically HRS1.1 HRSC.1
assigned. PA09.1 PA100
PA102 PA46.1
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1 PA56.1
PAC-CMT-TEXT Alpha 60 (Lower Case) HR90.1 HR90.2
Comment Text Comment text. PA09.1 PA46.1
PA56.1
PAC-DATE Numeric 8 (yyyymmdd) HR90.1 HR90.2
Date Contains the date the comment was PA09.1 PA46.1
entered. PA56.1
PAC-PRINT-CODE Alpha 1 HR90.1 HR90.2
Print Code The Print Code indicates whether the PA46.1 PA56.1
comment will print on reports.
Y = Yes
N = No
PACOMMENTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PACSET1 COMPANY HR00.1 HR01.1
EMP-APP HR06.1 HR11.1
CMT-TYPE HR13.1 HR211
EMPLOYEE HR213 HR513
JOB-CODE HR54.1 HR700
ACTION-CODE HR90.1 HR90.2
LN-NBR HRS1.1 HRSC.1
SEQ-NBR PA02.1 PA09.1
PA100 PA102
PA115 PA12.1
PA120 PA130
PA135 PA14.1
PA15.1 PA15.2
PA16.1 PA18.1
PA19.1 PA20.1
...
PACSET2 COMPANY KeyChange PA100 PA213
EMP-APP PA340 PA52.1
CMT-TYPE PA52.3 PA52.4
ACTION-CODE PA52.5 PA56.1
DATE PA66.4
EMPLOYEE
JOB-CODE
LN-NBR
SEQ-NBR
PACOMMENTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When PAC-EMP-APP = 1
PAC-COMPANY -> APL-COMPANY
PAC-EMPLOYEE -> APL-APPLICANT
Company PRSYSTEM Required
PAC-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Dependents EMDEPEND Required
When PAC-CMT-TYPE = "DP"
PAC-COMPANY -> EMD-COMPANY
PAC-EMPLOYEE -> EMD-EMPLOYEE
PAC-LN-NBR -> EMD-SEQ-NBR
Emerg Contact PAEMERGCNT Required
When PAC-CMT-TYPE = "EC"
PAC-COMPANY -> PAE-COMPANY
PAC-EMPLOYEE -> PAE-EMPLOYEE
PAC-LN-NBR -> PAE-SEQ-NBR
Emp Job Hist APPJOBHIST Required
When (PAC-EMP-APP = Zeroes )
And (PAC-CMT-TYPE = "JH" )
PAC-COMPANY -> AJH-COMPANY
Zeroes -> AJH-APPLICANT
PAC-EMPLOYEE -> AJH-EMPLOYEE
PAC-LN-NBR -> AJH-SEQ-NBR
Employee EMPLOYEE Required
When PAC-EMP-APP = Zeroes
PAC-COMPANY -> EMP-COMPANY
PAC-EMPLOYEE -> EMP-EMPLOYEE
Interview INTERVIEW Required
When PAC-CMT-TYPE = "IV"
PAC-COMPANY -> ITV-COMPANY
PAC-EMP-APP -> ITV-EMP-APP
PAC-EMPLOYEE -> ITV-APPLICANT
PAC-LN-NBR -> ITV-SEQ-NBR
Job Code JOBCODE Required
When PAC-JOB-CODE != Spaces
PAC-COMPANY -> JBC-COMPANY
PAC-JOB-CODE -> JBC-JOB-CODE
Job History APPJOBHIST Required
When (PAC-EMP-APP = 1 )
And (PAC-CMT-TYPE = "JH" )
PAC-COMPANY -> AJH-COMPANY
PAC-EMPLOYEE -> AJH-APPLICANT
Zeroes -> AJH-EMPLOYEE
PAC-LN-NBR -> AJH-SEQ-NBR
Pa Employee PAEMPLOYEE Required
When PAC-EMP-APP = Zeroes
PAC-COMPANY -> PEM-COMPANY
PAC-EMPLOYEE -> PEM-EMPLOYEE
Reference REFERENC Required
When PAC-CMT-TYPE = "RF"
PAC-COMPANY -> REF-COMPANY
PAC-EMPLOYEE -> REF-APPLICANT
PAC-LN-NBR -> REF-SEQ-NBR
Review REVIEW Required
When PAC-CMT-TYPE = "RV"
PAC-COMPANY -> REV-COMPANY
PAC-EMPLOYEE -> REV-EMPLOYEE
PAC-LN-NBR -> REV-SEQ-NBR
|