PAEMPAPTST

Contains employee test information. This file is maintained primarily by PA49.1 (Employee Tests).

REFERENCED BY
PA48.1


UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR00.1 HR01.1 HR11.1 HR11.2 HR28.1
HR511 HR54.1 HRS1.1 HRSC.1 LT101 ZH500
ZH510 PA02.1 PA100 PA102 PA115 PA120
PA13.1 PA13.2 PA149 PA248 PA249 PA349
PA49.1 PA49.2 PA49.3 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PA54.1 PA549 PA81.1
PA81.2 PR110 PR113 PR12.6 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR30.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTS-COMPANY
Element: Company Hr
Numeric 4
PA149 PA49.1
PA49.3 PA549
PTS-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.
0 = Employee
1 = Applicant
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PTS-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PTS-TEST
Element: Test
Alpha 10
Contains the test.
PA149 PA49.1
PA49.3 PA549
PTS-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
PA149 PA49.1
PA49.3 PA549
PTS-SCHED-DATE
Element: Sched Date
Numeric 8 (yyyymmdd)
Contains the date on which the test is scheduled.
PA149 PA49.1
PA49.3 PA549
PTS-STATUS
Element: Status
Numeric 1
Contains the status for the test.
1 = Scheduled
2 = In Process
3 = Refused
4 = Withdrawn
5 = Completed
PA149 PA49.1
PA49.3 PA549
PTS-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the date on which the status is effective.
PA149 PA49.1
PA49.3 PA549
PTS-RESULT1
Element: Result1
Alpha 10
Contains the test result.
PA149 PA49.1
PA49.3 PA549
PTS-RESULT-DESC
Element: Result Desc
Alpha 40 (Lower Case)
Contains the result description.
PA149 PA49.1
PA49.3 PA549
PTS-NEXT-DATE
Element: Next Date
Numeric 8 (yyyymmdd)
Contains the date of the next follow up test.
PA149 PA49.1
PA49.3 PA549
PTS-REASON
Element: Reason
Alpha 10
Contains the reason for the test.
PA149 PA49.1
PA49.3 PA549
PTS-NOTIFY-DATE
Element: Notify Date
Numeric 8 (yyyymmdd)
Contains the date on which the employee is notified.
PA149 PA49.1
PA49.3 PA549
PTS-NOTIFY-TYPE
Element: Notify Type
Alpha 10
Contains the method by which the employee is notified of the test.
PA149 PA49.1
PA49.3 PA549
PTS-ESTABLISHMENT
Element: Establishment
Alpha 10
If the test is the result of an incident, this field contains the establishment where the incident occurred.
PA149 PA49.1
PA49.3 PA549
PTS-INCIDENT-NBR
Element: Incident Nbr
Numeric 4
If the test is a result of an incident, this field contains the incident number.
PA149 PA49.1
PA49.3 PA549
PTS-REFUSE-REASON
Element: Refuse Reason
Alpha 10
Contains the reason the employee refused to take the test.
PA149 PA49.1
PA49.3 PA549
PTS-RENEW-DATE
Element: Renew Date
Numeric 8 (yyyymmdd)
Contains the date for the renewal test.
PA149 PA49.1
PA49.3 PA549
PTS-RENEW-TEST
Element: Renew Test
Alpha 10
Contains the renewal test.
PA149 PA49.1
PA49.3 PA549
PTS-FOLLOW-DATE
Element: Follow Date
Numeric 8 (yyyymmdd)
Contains the date for the follow up test.
PA149 PA49.1
PA49.3 PA549
PTS-FOLLOW-TEST
Element: Follow Test
Alpha 10
Contains the follow up test.
PA149 PA49.1
PA49.3 PA549
PTS-COMMENT
Element: Comment
Alpha 40 (Lower Case)
Contains comments about the follow up test.
PA149 PA49.1
PA49.3 PA549
PTS-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PTS-PARENT-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 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
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
PTS-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
PA149 PA49.1
PA49.3 PA549
PTS-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA149 PA49.1
PA49.3 PA549
PTS-USER-ID
Element: User
Alpha 10 (Lower Case)
PA149 PA49.1
PA49.3 PA549
PTS-WF-EMP-TST-SEQ
Element: Wf Emp Tst Seq
Derived


PAEMPAPTST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTSSET1 COMPANY
EMP-APP
EMPLOYEE
TEST
SEQ-NBR
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR00.1
HR01.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 ZH500
ZH510 PA02.1
PA100 PA102
PA115 PA120
PA13.1 PA13.2
PA149 PA249
PA349 PA49.1
PTSSET2 PARENT-OBJ-ID
OBJ-ID
KeyChange
PA149 PA248
PA249 PA349
PA49.1 PA49.3
PA549
PTSSET3 COMPANY
NEXT-DATE
TEST
EMP-APP
EMPLOYEE
SEQ-NBR
KeyChange, Subset
Where(NEXT-DATE !=Zeroes)
PA149
PTSSET4 COMPANY
TEST
EMP-APP
EMPLOYEE
SEQ-NBR*
KeyChange
PA149 PA248
PA349 PA48.1
PA49.1 PA49.3
PA549 PA81.2
PTSSET5 COMPANY
EMP-APP
EMPLOYEE
TEST
SCHED-DATE*
SEQ-NBR
KeyChange
PA149 PA249
PA49.1 PA49.2
PA49.3 PA549
PA81.1
PTSSET6 COMPANY
SCHED-DATE
TEST
EMP-APP
EMPLOYEE
SEQ-NBR
KeyChange, Subset
WhereSTATUS <3
PA149


PAEMPAPTST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:22:11 2016

Home
Contact Us



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