PACOMMENTS

Personnel Comments

The Personnel Comments file contains comments for employees or applicants.

REFERENCED BY
HR211 HR213 PA208 PA212 PA214 PA215
PA216 PA219 PA220 PA221 PA222 PA224
PA225 PA231 PA232 PA233 PA234 PA235
PA236 PA238 PA239 PA240 PA241 PA242
PA31.1 PA311 PA350 PA45.1 PA532 PA66.1
PA66.2 PA66.4 PR134 PR135 PR160 PR180
PR32.2 PR35.1 PR35.2 PR36.3 PR80.2 ZH500
PA213 PA340 PR282


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR11.4 HR13.1 HR28.1
HR511 HR513 HR54.1 HR90.1 HR90.2 HRS1.1
HRSC.1 LT101 LT111 ZH510 PA02.1 PA09.1
PA100 PA102 PA115 PA120 PA13.1 PA13.2
PA130 PA135 PA19.1 PA218 PA33.1 PA41.1
PA42.1 PA42.3 PA43.1 PA43.2 PA46.1 PA502
PA513 PA52.1 PA52.2 PA52.3 PA52.4 PA52.5
PA533 PA535 PA54.1 PA56.1 ZE526 PR110
PR113 PR12.6 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 PR30.2 PR300 PR512 PR530
HR00.1 HR01.1 HR06.1 HR506 PA12.1 PA14.1
PA15.1 PA15.2 PA16.1 PA18.1 PA20.1 PA21.1
PA22.1 PA24.1 PA25.1 PA26.1 PA290 PA32.1
PA34.1 PA35.1 PA36.1 PA372 PA38.1 PA39.1
PA40.1 PA490 PA512 PA590 PA90.1 TR21.1
HR15.1 HR515 LT11.5 LT13.5 PA113

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
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 HR11.4
HR28.1 HR511
HR54.1 HR90.1
HR90.2 HRS1.1
HRSC.1 LT101
LT111 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 PR512
PR530 ZE526
ZH510
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
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 HR11.4
HR28.1 HR511
HR54.1 HR90.1
HR90.2 HRS1.1
HRSC.1 LT101
LT111 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 PR512
PR530 ZE526
ZH510
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
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
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. OS = OSHA report number. All others = Zero.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.4
HR28.1 HR511
HR54.1 HR90.1
HR90.2 HRS1.1
HRSC.1 LT101
LT111 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
PR512 PR530
ZE526 ZH510
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 HR11.4
HR28.1 HR511
HR54.1 HR90.1
HR90.2 HRS1.1
HRSC.1 LT101
LT111 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 PR512
PR530 ZE526
ZH510
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
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
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


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
DATE
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR00.1
HR01.1 HR06.1
HR11.1 HR11.2
HR11.4 HR13.1
HR211 HR213
HR28.1 HR506
HR511 HR513
HR54.1 HR90.1
HR90.2 HRS1.1
HRSC.1 LT101
LT111 ZH510
PA02.1 PA09.1
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 HR11.4
HR15.1 HR28.1
HR511 HR515
HR54.1 HRS1.1
HRSC.1 LT101
LT11.5 LT111
LT13.5 ZH500
ZH510 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2


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 02:24:53 2016

Home
Contact Us



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