PACOMMENTS

Personnel Comments

The Personnel Comments file contains comments for employees or applicants.
UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR00.1 HR01.1 HR06.1 HR11.1 HR11.2
HR13.1 HR15.1 HR211 HR213 HR28.1 HR506
HR511 HR513 HR515 HR54.1 HR90.1 HR90.2
HRS1.1 HRSC.1 LT101 LT11.5 ZH500 ZH510
PA02.1 PA09.1 PA100 PA102 PA113 PA115
PA12.1 PA120 PA13.1 PA13.2 PA130 PA135
PA14.1 PA15.1 PA15.2 PA16.1 PA18.1 PA19.1
PA20.1 PA208 PA21.1 PA212 PA213 PA214
PA215 PA216 PA218 PA219 PA22.1 PA220
PA221 PA222 PA224 PA225 PA231 PA232
PA233 PA234 PA235 PA236 PA238 PA239
PA24.1 PA240 PA241 PA242 PA25.1 PA26.1
PA290 PA31.1 PA311 PA32.1 PA33.1 PA34.1
PA340 PA35.1 PA350 PA36.1 PA372 PA38.1
PA39.1 PA40.1 PA41.1 PA42.1 PA42.3 PA43.1
PA43.2 PA45.1 PA46.1 PA490 PA502 PA512
PA513 PA52.1 PA52.2 PA52.3 PA52.4 PA52.5
PA532 PA533 PA535 PA54.1 PA56.1 PA590
PA66.1 PA66.2 PA66.4 PA90.1 TR21.1 ZE526
ZE531 PR110 PR113 PR12.6 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR134 PR135
PR160 PR180 PR30.1 PR30.2 PR300 PR32.2
PR35.1 PR35.2 PR36.3 PR530 PR80.2 ZP530

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAC-COMPANY
Element: Company Hr		Numeric 4
Contains the company number which represents an established company.
HR90.1 HR90.2
PA09.1 PA100
PA46.1 PA56.1
PR530 ZE526
ZE531 ZP530
PAC-EMP-APP
Element: Emp App		Numeric 1
Indicates whether the person is an external or internal applicant. An external applicant is a person applying from outside the company; an internal applicant is an employee applying from inside the company.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HR90.1 HR90.2
HRS1.1 HRSC.1
LT101 PA02.1
PA09.1 PA100
PA102 PA115
PA13.1 PA13.2
PA46.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA56.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR530
ZE526 ZE531
ZH510 ZP530
PAC-CMT-TYPE
Element: Cmt Type		Alpha 2
Contains the comment type.
BN = Benefit
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
HR90.1 HR90.2
PA09.1 PA100
PA46.1 PA56.1
PR530 ZE526
ZE531 ZP530
PAC-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee or applicant number for comments. This value is zero for job descriptions and personnel action comments.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HR90.1 HR90.2
HRS1.1 HRSC.1
LT101 PA02.1
PA09.1 PA100
PA102 PA115
PA13.1 PA13.2
PA46.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA56.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR530
ZE526 ZE531
ZH510 ZP530
PAC-JOB-CODE
Element: Job Code		Alpha 9
Contains the job code for job description comments. This value is blank for employee, applicant, and personnel action comments.
HR90.1 PA09.1
PA100 PA46.1
PR530 ZE526
ZE531 ZP530
PAC-ACTION-CODE
Element: Action Code		Alpha 10
Contains the action code for personnel action comments. This value is blank for employee, applicant, and job description comments.
HR90.1 PA09.1
PA100 PA46.1
PA54.1 PA56.1
PR530 ZE526
ZE531 ZP530
PAC-LN-NBR
Element: Ln Nbr		Numeric 4
Contains the comment type number. Valid values are: IV = Interview sequence number. JH = Applicant job history sequence number. DP = Dependent number. RV = Performance review sequence number. PA = Personnel action number. All others = Zero.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HR90.1 HR90.2
HRS1.1 HRSC.1
LT101 PA02.1
PA09.1 PA100
PA102 PA115
PA13.1 PA13.2
PA46.1 PA502
PA513 PA52.1
PA52.2 PA52.3
PA52.4 PA52.5
PA54.1 PA56.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR530 ZE526
ZE531 ZH510
ZP530
PAC-SEQ-NBR
Element: Seq Nbr		Numeric 4
Contains a sequence number that keeps records unique. It is automatically assigned.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HR90.1 HR90.2
HRS1.1 HRSC.1
LT101 PA02.1
PA09.1 PA100
PA102 PA115
PA13.1 PA13.2
PA46.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA56.1 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR30.2 PR530
ZE526 ZE531
ZH510 ZP530
PAC-CMT-TEXT
Element: Cmt Text		Alpha 60 (Lower Case)
Comment text.
HR90.1 HR90.2
PA09.1 PA100
PA46.1 PA56.1
PR530 ZE526
ZE531 ZP530
PAC-DATE
Element: Date		Numeric 8 (yyyymmdd)
Contains the date the comment was entered.
HR90.1 HR90.2
PA09.1 PA100
PA46.1 PA52.1
PA52.2 PA52.3
PA52.4 PA52.5
PA54.1 PA56.1
PR530 ZE526
ZE531 ZP530
PAC-PRINT-CODE
Element: Print Code		Alpha 1
The Print Code indicates whether the comment will print on reports.
Y = Yes
N = No
HR90.1 HR90.2
PA100 PA46.1
PA56.1 PR530
ZE526 ZE531
ZP530


PACOMMENTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PACSET1 COMPANY
EMP-APP
CMT-TYPE
EMPLOYEE
JOB-CODE
ACTION-CODE
LN-NBR
SEQ-NBR
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR00.1
HR01.1 HR06.1
HR11.1 HR11.2
HR13.1 HR211
HR213 HR28.1
HR506 HR511
HR513 HR54.1
HR90.1 HR90.2
HRS1.1 HRSC.1
LT101 ZH510
PA02.1 PA09.1
PA100 PA102
PACSET2 COMPANY
EMP-APP
CMT-TYPE
ACTION-CODE
DATE
EMPLOYEE
JOB-CODE
LN-NBR
SEQ-NBR
KeyChange
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR15.1
HR28.1 HR511
HR515 HR54.1
HRS1.1 HRSC.1
LT101 LT11.5
ZH500 ZH510
PA02.1 PA100
PA102 PA113
PA115 PA13.1
PA13.2 PA213
PA340 PA502


PACOMMENTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:22:09 2016

Home
Contact Us



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