Lawson Insight Technical Documentation |
|
PAEMPAPTST
PAEMPAPTST FILE
Contains employee test information. This file is maintained primarily by
PA49.1 (Employee Tests).
REFERENCED BY
PA249 PA81.1 PA81.2 PA248 PA48.1
UPDATED BY
BN305 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR511 HR54.1 HRS1.1 HRSC.1
PA02.1 PA100 PA102 PA115 PA120 PA13.1
PA13.2 PA149 PA349 PA49.1 PA49.3 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PA54.1
PA549 PR110 PR113 PR120 PR13.1 PR13.5
PR13.6 PR13.8 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTS-COMPANY Numeric 4 PA149 PA49.1
Element: Company Hr PA49.3 PA549
PTS-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 HRS1.1 HRSC.1
internal applicant is an employee PA02.1 PA100
applying from inside the company. PA102 PA115
0 = Employee PA13.1 PA13.2
1 = Applicant PA149 PA49.1
PA49.3 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA549 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PTS-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee Contains the employee number. Each HEP4.1 HPOS.1
person employed by the company is HPQC.1 HPRS.1
assigned a unique number. The system HR11.1 HR11.2
uses the employee number to correlate HR511 HR54.1
all of the information related to that HRS1.1 HRSC.1
person. PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA149 PA49.1
PA49.3 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PA549 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PTS-TEST Alpha 10 PA149 PA49.1
Element: Test Contains the test. PA49.3 PA549
PTS-SEQ-NBR Numeric 4 PA149 PA49.1
Element: Seq Nbr An automatically assigned sequence PA49.3 PA549
number.
PTS-SCHED-DATE Numeric 8 (yyyymmdd) PA149 PA49.1
Element: Sched Date Contains the date on which the test is PA49.3 PA549
scheduled.
PTS-STATUS Numeric 1 PA149 PA49.1
Element: Status Contains the status for the test. PA49.3 PA549
1 = Scheduled
2 = In Process
3 = Refused
4 = Withdrawn
5 = Completed
PTS-EFFECT-DATE Numeric 8 (yyyymmdd) PA149 PA49.1
Element: Effect Date Contains the date on which the status PA49.3 PA549
is effective.
PTS-RESULT1 Alpha 10 PA149 PA49.1
Element: Result1 Contains the test result. PA49.3 PA549
PTS-RESULT-DESC Alpha 40 (Lower Case) PA149 PA49.1
Element: Result Desc Contains the result description. PA49.3 PA549
PTS-NEXT-DATE Numeric 8 (yyyymmdd) PA149 PA49.1
Element: Next Date Contains the date of the next follow up PA49.3 PA549
test.
PTS-REASON Alpha 10 PA149 PA49.1
Element: Reason Contains the reason for the test. PA49.3 PA549
PTS-NOTIFY-DATE Numeric 8 (yyyymmdd) PA149 PA49.1
Element: Notify Date Contains the date on which the employee PA49.3 PA549
is notified.
PTS-NOTIFY-TYPE Alpha 10 PA149 PA49.1
Element: Notify Type Contains the method by which the PA49.3 PA549
employee is notified of the test.
PTS-ESTABLISHMENT Alpha 10 PA149 PA49.1
Element: Establishment If the test is the result of an PA49.3 PA549
incident, this field contains the
establishment where the incident
occurred.
PTS-INCIDENT-NBR Numeric 4 PA149 PA49.1
Element: Incident Nbr If the test is a result of an incident, PA49.3 PA549
this field contains the incident number.
PTS-REFUSE-REASON Alpha 10 PA149 PA49.1
Element: Refuse Reason Contains the reason the employee PA49.3 PA549
refused to take the test.
PTS-RENEW-DATE Numeric 8 (yyyymmdd) PA149 PA49.1
Element: Renew Date Contains the date for the renewal test. PA49.3 PA549
PTS-RENEW-TEST Alpha 10 PA149 PA49.1
Element: Renew Test Contains the renewal test. PA49.3 PA549
PTS-FOLLOW-DATE Numeric 8 (yyyymmdd) PA149 PA49.1
Element: Follow Date Contains the date for the follow up PA49.3 PA549
test.
PTS-FOLLOW-TEST Alpha 10 PA149 PA49.1
Element: Follow Test Contains the follow up test. PA49.3 PA549
PTS-COMMENT Alpha 40 (Lower Case) PA149 PA49.1
Element: Comment Contains comments about the follow up PA49.3 PA549
test.
PTS-OBJ-ID Numeric 12 BN305 HAP3.1
Element: Obj Id This is the object identifier. It is HEP4.1 HPOS.1
used to relate commitments or posted HPQC.1 HPRS.1
transactions back to the originating HR11.1 HR11.2
subsystems. Each subsystem record that HR511 HR54.1
is updated as a commitment or posted HRS1.1 HRSC.1
transaction is assigned an object PA02.1 PA100
identifier. The object identifier is PA102 PA115
maintained in the subsystem files and in PA13.1 PA13.2
the Activity Commitments Detail and PA149 PA49.1
Activity Transaction files. The object PA49.3 PA502
identifier is a unique key used to drill PA513 PA52.1
back from Activity Management to the PA52.3 PA52.4
subsystems. PA52.5 PA54.1
PA549 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PTS-PARENT-OBJ-ID Numeric 12 BN305 HAP3.1
Element: Obj Id This is the object identifier. It is HEP4.1 HPOS.1
used to relate commitments or posted HPQC.1 HPRS.1
transactions back to the originating HR11.1 HR11.2
subsystems. Each subsystem record that HR511 HR54.1
is updated as a commitment or posted HRS1.1 HRSC.1
transaction is assigned an object PA02.1 PA100
identifier. The object identifier is PA102 PA115
maintained in the subsystem files and in PA13.1 PA13.2
the Activity Commitments Detail and PA149 PA49.1
Activity Transaction files. The object PA49.3 PA502
identifier is a unique key used to drill PA513 PA52.1
back from Activity Management to the PA52.3 PA52.4
subsystems. PA52.5 PA54.1
PA549 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PTS-DATE-STAMP Numeric 8 (yyyymmdd) PA149 PA49.1
Element: Date Stamp This field contains the server date PA49.3 PA549
(month, date, and year) of the last
change to this record.
PTS-TIME-STAMP Numeric 6 (hhmmss) PA149 PA49.1
Element: Time Stamp Contains the server time (hour, minute, PA49.3 PA549
and second) when the record was last
changed.
PTS-USER-ID Alpha 10 (Lower Case) PA149 PA49.1
Element: User PA49.3 PA549
PTS-WF-EMP-TST-SEQ Derived
Element: Wf Emp Tst Seq
PAEMPAPTST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTSSET1 COMPANY BN305 HAP3.1
EMP-APP HEP4.1 HPOS.1
EMPLOYEE HPQC.1 HPRS.1
TEST HR00.1 HR01.1
SEQ-NBR HR11.1 HR11.2
HR511 HR54.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA120 PA13.1
PA13.2 PA149
PA249 PA349
PA49.1 PA49.3
PA502 PA513
PA52.1 PA52.3
...
PTSSET2 PARENT-OBJ-ID KeyChange PA149 PA248
OBJ-ID PA249 PA349
PA49.1 PA49.3
PA549
PTSSET3 COMPANY KeyChange, Subset PA149
NEXT-DATE Where (NEXT-DATE != Zeroes )
TEST
EMP-APP
EMPLOYEE
SEQ-NBR
PTSSET4 COMPANY KeyChange PA149 PA248
TEST PA349 PA48.1
EMP-APP PA49.1 PA49.3
EMPLOYEE PA549 PA81.2
SEQ-NBR*
PTSSET5 COMPANY KeyChange PA149 PA249
EMP-APP PA49.1 PA49.2
EMPLOYEE PA49.3 PA549
TEST PA81.1
SCHED-DATE*
SEQ-NBR
PTSSET6 COMPANY KeyChange, Subset PA149
SCHED-DATE Where STATUS < 3
TEST
EMP-APP
EMPLOYEE
SEQ-NBR
PAEMPAPTST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When (PTS-EMP-APP = 1 )
PTS-COMPANY -> APL-COMPANY
PTS-EMPLOYEE -> APL-APPLICANT
Company PRSYSTEM Required
PTS-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When (PTS-EMP-APP = Zeroes )
PTS-COMPANY -> EMP-COMPANY
PTS-EMPLOYEE -> EMP-EMPLOYEE
Establishment OSHESTAB Required
When (PTS-ESTABLISHMENT != Spaces )
PTS-COMPANY -> OTB-COMPANY
PTS-ESTABLISHMENT -> OTB-ESTABLISHMENT
Follow Test PATSTSETUP Required
When (PTS-FOLLOW-TEST != Spaces )
PTS-COMPANY -> PAP-COMPANY
PTS-FOLLOW-TEST -> PAP-TEST
Incident OSHA Required
When (PTS-INCIDENT-NBR != Zeroes )
PTS-COMPANY -> OSH-COMPANY
PTS-EMPLOYEE -> OSH-EMPLOYEE
PTS-ESTABLISHMENT -> OSH-ESTABLISHMENT
PTS-INCIDENT-NBR -> OSH-SEQ-NBR
Notify Type PCODES Required
When (PTS-NOTIFY-TYPE != Spaces )
"TN" -> PCO-TYPE
PTS-NOTIFY-TYPE -> PCO-CODE
Paemployee PAEMPLOYEE Required
When (PTS-EMP-APP = Zeroes )
PTS-COMPANY -> PEM-COMPANY
PTS-EMPLOYEE -> PEM-EMPLOYEE
Reason PCODES Required
When (PTS-REASON != Spaces )
"TA" -> PCO-TYPE
PTS-REASON -> PCO-CODE
Refusal PCODES Required
When (PTS-REFUSE-REASON != Spaces )
"TF" -> PCO-TYPE
PTS-REFUSE-REASON -> PCO-CODE
Renew Test PATSTSETUP Required
When (PTS-RENEW-TEST != Spaces )
PTS-COMPANY -> PAP-COMPANY
PTS-RENEW-TEST -> PAP-TEST
Results PATSTRESLT Required
When (PTS-RESULT1 != Spaces )
PTS-COMPANY -> PTR-COMPANY
PTS-TEST -> PTR-TEST
PTS-RESULT1 -> PTR-CODE
Test PATSTSETUP Required
PTS-COMPANY -> PAP-COMPANY
PTS-TEST -> PAP-TEST
|