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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PACSET1COMPANY, EMP-APP, CMT-TYPE, EMPLOYEE, JOB-CODE, ACTION-CODE, LN-NBR, SEQ-NBR, DATEPrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR00.1 +22 more (list truncated in source)
PACSET2COMPANY, EMP-APP, CMT-TYPE, ACTION-CODE, DATE, EMPLOYEE, JOB-CODE, LN-NBR, SEQ-NBRKeyChangeBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)

Relations

One to one (12) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen PAC-EMP-APP = 1PAC-COMPANY → APL-COMPANY, PAC-EMPLOYEE → APL-APPLICANT
CompanyPRSYSTEMRequiredPAC-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 = ZeroesPAC-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 != SpacesPAC-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 = ZeroesPAC-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)