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 HR11.1 HR11.2 HR13.1 HR511 HR513
HR54.1 HR90.1 HR90.2 HRS1.1 HRSC.1 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 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR300 PR530 HR00.1 HR01.1 HR06.1
HR211 HR213 HR506 PA12.1 PA14.1 PA15.1
PA15.2 PA16.1 PA18.1 PA20.1 PA208 PA21.1
PA212 PA214 PA215 PA216 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 PA34.1
PA35.1 PA350 PA36.1 PA372 PA38.1 PA39.1
PA40.1 PA45.1 PA490 PA512 PA532 PA590
PA66.1 PA66.2 PA66.4 PA90.1 TR21.1 PR134
PR135 PR160 PR180 PR30.1 PR32.2 PR35.1
PR35.2 PR36.3 PR80.2 HR15.1 HR515 PA113
PA213 PA340

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
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 HR511
HR54.1 HR90.1
HR90.2 HRS1.1
HRSC.1 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 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR530
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
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 HR511
HR54.1 HR90.1
HR90.2 HRS1.1
HRSC.1 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 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR530
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
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
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 HR511
HR54.1 HR90.1
HR90.2 HRS1.1
HRSC.1 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
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR530
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 HR511
HR54.1 HR90.1
HR90.2 HRS1.1
HRSC.1 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 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR530
PAC-CMT-TEXT
Element: Cmt Text
Alpha 60 (Lower Case)
Comment text.
HR90.1 HR90.2
PA09.1 PA100
PA46.1 PA56.1
PR530
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
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


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 HR506
HR511 HR513
HR54.1 HR90.1
HR90.2 HRS1.1
HRSC.1 PA02.1
PA09.1 PA100
PA102 PA115
PA12.1 PA120
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
HR511 HR515
HR54.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA113 PA115
PA13.1 PA13.2
PA213 PA340
PA502 PA513
PA52.1 PA52.2
PA52.3 PA52.4


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: Wed Jun 08 20:50:23 2016

Home
Contact Us



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