PAEMPAPTST

Contains employee test information. This file is maintained primarily by PA49.1 (Employee Tests).
UPDATED BY
BN305 HAP3.1 HCRE.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
PA49.2 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PA54.1 PA549 PR110 PR113 PR120
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 HR00.1
HR01.1 PA249 PA81.1 PA81.2 PA248 PA48.1

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 HR511
HR54.1 HRS1.1
HRSC.1 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 PR13.9
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 HR511
HR54.1 HRS1.1
HRSC.1 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 PR13.9
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 HR511
HR54.1 HRS1.1
HRSC.1 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 PR13.9
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 HR511
HR54.1 HRS1.1
HRSC.1 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 PR13.9
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 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
PTSSET2 PARENT-OBJ-ID
OBJ-ID
KeyChange
PA248 PA249
PA349 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: Wed Jun 08 20:50:23 2016

Home
Contact Us



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