Lawson Insight Technical Documentation |
|
PACOMMENTS
PACOMMENTS FILE
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 PR30.1
PR32.2 PR35.1 PR35.2 PR36.3 PA213 PA340
UPDATED BY
BN305 HAP3.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 PR300
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 PA113
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAC-COMPANY Numeric 4 HR90.1 HR90.2
Element: Company Hr Contains the company number which PA09.1 PA100
represents an established company. PA46.1 PA56.1
PR530
PAC-EMP-APP Numeric 1 BN305 HAP3.1
Element: Emp App Indicates whether the person is an HEP4.1 HPOS.1
external or internal applicant. HPQC.1 HPRS.1
HR11.1 HR11.2
An external applicant is a person HR511 HR54.1
applying from outside the company; an HR90.1 HR90.2
internal applicant is an employee HRS1.1 HRSC.1
applying from inside the company. 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 PR530
PAC-CMT-TYPE Alpha 2 HR90.1 HR90.2
Element: Cmt Type Contains the comment type. PA09.1 PA100
BN = Benefit PA46.1 PA56.1
CE = Certification PR530
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
PAC-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee or applicant HEP4.1 HPOS.1
number for comments. This value is zero HPQC.1 HPRS.1
for job descriptions and personnel HR11.1 HR11.2
action comments. 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 PR530
PAC-JOB-CODE Alpha 9 HR90.1 PA09.1
Element: Job Code Contains the job code for job PA100 PA46.1
description comments. This value is PR530
blank for employee, applicant, and
personnel action comments.
PAC-ACTION-CODE Alpha 10 HR90.1 PA09.1
Element: Action Code Contains the action code for personnel PA100 PA46.1
action comments. This value is blank for PA54.1 PA56.1
employee, applicant, and job description PR530
comments.
PAC-LN-NBR Numeric 4 BN305 HAP3.1
Element: Ln Nbr Contains the comment type number. Valid HEP4.1 HPOS.1
values are: HPQC.1 HPRS.1
HR11.1 HR11.2
IV = Interview sequence number. HR511 HR54.1
JH = Applicant job history sequence HR90.1 HR90.2
number. HRS1.1 HRSC.1
DP = Dependent number. PA02.1 PA09.1
RV = Performance review sequence number. PA100 PA102
PA = Personnel action number. PA115 PA13.1
All others = Zero. 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
PR530
PAC-SEQ-NBR Numeric 4 BN305 HAP3.1
Element: Seq Nbr Contains a sequence number that keeps HEP4.1 HPOS.1
records unique. It is automatically HPQC.1 HPRS.1
assigned. 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 PR530
PAC-CMT-TEXT Alpha 60 (Lower Case) HR90.1 HR90.2
Element: Cmt Text Comment text. PA09.1 PA100
PA46.1 PA56.1
PR530
PAC-DATE Numeric 8 (yyyymmdd) HR90.1 HR90.2
Element: Date Contains the date the comment was PA09.1 PA100
entered. PA46.1 PA52.1
PA52.2 PA52.3
PA52.4 PA52.5
PA54.1 PA56.1
PR530
PAC-PRINT-CODE Alpha 1 HR90.1 HR90.2
Element: Print Code The Print Code indicates whether the PA100 PA46.1
comment will print on reports. PA56.1 PR530
Y = Yes
N = No
PACOMMENTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PACSET1 COMPANY BN305 HAP3.1
EMP-APP HEP4.1 HPOS.1
CMT-TYPE HPQC.1 HPRS.1
EMPLOYEE HR00.1 HR01.1
JOB-CODE HR06.1 HR11.1
ACTION-CODE HR11.2 HR13.1
LN-NBR HR211 HR213
SEQ-NBR HR506 HR511
HR513 HR54.1
HR90.1 HR90.2
HRS1.1 HRSC.1
PA02.1 PA09.1
PA100 PA102
PA115 PA12.1
PA120 PA13.1
...
PACSET2 COMPANY KeyChange BN305 HAP3.1
EMP-APP HEP4.1 HPOS.1
CMT-TYPE HPQC.1 HPRS.1
ACTION-CODE HR11.1 HR11.2
DATE HR15.1 HR511
EMPLOYEE HR515 HR54.1
JOB-CODE HRS1.1 HRSC.1
LN-NBR PA02.1 PA100
SEQ-NBR PA102 PA113
PA115 PA13.1
PA13.2 PA213
PA340 PA502
PA513 PA52.1
PA52.2 PA52.3
PA52.4 PA52.5
...
PACOMMENTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|