PACOMMENTS – Personnel Comments

System
Personnel (PA)
Prefix
PAC
Primary key
COMPANY, EMP-APP, CMT-TYPE, EMPLOYEE, JOB-CODE, ACTION-CODE, LN-NBR, SEQ-NBR, DATE
Fields
11
Updated by
101 programs
Referenced by
45 programs

PACOMMENTS is the Personnel Comments table in Lawson Personnel (prefix PAC). It is indexed by COMPANY, EMP-APP, CMT-TYPE, EMPLOYEE, JOB-CODE, ACTION-CODE, LN-NBR, SEQ-NBR, DATE (PACSET1); alternate indexes: PACSET2. It is related 1:1 to APPLICANT, PRSYSTEM, EMDEPEND, PAEMERGCNT, APPJOBHIST, EMPLOYEE, INTERVIEW, JOBCODE and 3 more. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR00.1 and 93 more and referenced by HR211, HR213, PA208, PA212, PA213, PA214, PA215, PA216 and 37 more. The table has 11 fields, 2 indexes and 12 documented relations.

About PACOMMENTS

The Personnel Comments file contains comments for employees or applicants.

Fields (11)

Column = COBOL field name without the PAC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PAC-COMPANY PK
COMPANY		Numeric 4Contains the company number which represents an established company.HR90.1, HR90.2, PA09.1, PA100, PA46.1, PA56.1, PR530, ZE526
#PAC-EMP-APP PK
EMP_APP		Numeric 1Indicates 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 +41 more
#PAC-CMT-TYPE PK
CMT_TYPE		Alpha 2Contains 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 PK
EMPLOYEE		Numeric 9Contains 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 +41 more
#PAC-JOB-CODE PK
JOB_CODE		Alpha 9Contains 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 PK
ACTION_CODE		Alpha 10Contains 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 PK
LN_NBR		Numeric 4Contains the comment type number. Valid values are: number.
  • IV Interview sequence number.
  • JH Applicant job history sequence
  • 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 +42 more
#PAC-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains 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 +41 more
#PAC-CMT-TEXT
CMT_TEXT		Alpha 60 (Lower Case)Comment text.HR90.1, HR90.2, PA09.1, PA100, PA46.1, PA56.1, PR530, ZE526
#PAC-DATE PK
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 +6 more
#PAC-PRINT-CODE
PRINT_CODE		Alpha 1The 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

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PACSET1
  1. COMPANY
  2. EMP-APP
  3. CMT-TYPE
  4. EMPLOYEE
  5. JOB-CODE
  6. ACTION-CODE
  7. LN-NBR
  8. SEQ-NBR
  9. DATE
PrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR00.1 +22 more (list truncated in source)
PACSET2
  1. COMPANY
  2. EMP-APP
  3. CMT-TYPE
  4. ACTION-CODE
  5. DATE
  6. EMPLOYEE
  7. JOB-CODE
  8. LN-NBR
  9. SEQ-NBR
KeyChangeBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APPLICANTPRSYSTEMEMDEPENDPAEMERGCNTAPPJOBHISTEMPLOYEEINTERVIEWJOBCODEPAEMPLOYEEREFERENCREVIEWPACOMMENTS

One to one (12) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen PAC-EMP-APP = 1
PAC-COMPANY→APL-COMPANY
PAC-EMPLOYEE→APL-APPLICANT
CompanyPRSYSTEMRequired
PAC-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DependentsEMDEPENDRequiredWhen PAC-CMT-TYPE = "DP"
PAC-COMPANY→EMD-COMPANY
PAC-EMPLOYEE→EMD-EMPLOYEE
PAC-LN-NBR→EMD-SEQ-NBR
Emerg ContactPAEMERGCNTRequiredWhen PAC-CMT-TYPE = "EC"
PAC-COMPANY→PAE-COMPANY
PAC-EMPLOYEE→PAE-EMPLOYEE
PAC-LN-NBR→PAE-SEQ-NBR
Emp Job HistAPPJOBHISTRequiredWhen (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
EmployeeEMPLOYEERequiredWhen PAC-EMP-APP = Zeroes
PAC-COMPANY→EMP-COMPANY
PAC-EMPLOYEE→EMP-EMPLOYEE
InterviewINTERVIEWRequiredWhen 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 CodeJOBCODERequiredWhen PAC-JOB-CODE != Spaces
PAC-COMPANY→JBC-COMPANY
PAC-JOB-CODE→JBC-JOB-CODE
Job HistoryAPPJOBHISTRequiredWhen (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 EmployeePAEMPLOYEERequiredWhen PAC-EMP-APP = Zeroes
PAC-COMPANY→PEM-COMPANY
PAC-EMPLOYEE→PEM-EMPLOYEE
ReferenceREFERENCRequiredWhen PAC-CMT-TYPE = "RF"
PAC-COMPANY→REF-COMPANY
PAC-EMPLOYEE→REF-APPLICANT
PAC-LN-NBR→REF-SEQ-NBR
ReviewREVIEWRequiredWhen PAC-CMT-TYPE = "RV"
PAC-COMPANY→REV-COMPANY
PAC-EMPLOYEE→REV-EMPLOYEE
PAC-LN-NBR→REV-SEQ-NBR

Programs

Updated by (101)

Referenced by (45)