Contains employee test information. This file is maintained primarily by PA49.1 (Employee Tests).
REFERENCED BY
ZH500 | PA249 | PA81.1 | PA81.2 | PA248 | PA48.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
PTS-COMPANY Element: Company Hr | Numeric 4 |
|
||||
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 |
|||||
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. |
|||||
PTS-TEST Element: Test | Alpha 10 Contains the test. |
|
||||
PTS-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||
PTS-SCHED-DATE Element: Sched Date | Numeric 8 (yyyymmdd) Contains the date on which the test is scheduled. |
|
||||
PTS-STATUS Element: Status | Numeric 1 Contains the status for the test. 1 = Scheduled 2 = In Process 3 = Refused 4 = Withdrawn 5 = Completed |
|
||||
PTS-EFFECT-DATE Element: Effect Date | Numeric 8 (yyyymmdd) Contains the date on which the status is effective. |
|
||||
PTS-RESULT1 Element: Result1 | Alpha 10 Contains the test result. |
|
||||
PTS-RESULT-DESC Element: Result Desc | Alpha 40 (Lower Case) Contains the result description. |
|
||||
PTS-NEXT-DATE Element: Next Date | Numeric 8 (yyyymmdd) Contains the date of the next follow up test. |
|
||||
PTS-REASON Element: Reason | Alpha 10 Contains the reason for the test. |
|
||||
PTS-NOTIFY-DATE Element: Notify Date | Numeric 8 (yyyymmdd) Contains the date on which the employee is notified. |
|
||||
PTS-NOTIFY-TYPE Element: Notify Type | Alpha 10 Contains the method by which the employee is notified of the test. |
|
||||
PTS-ESTABLISHMENT Element: Establishment | Alpha 10 If the test is the result of an incident, this field contains the establishment where the incident occurred. |
|
||||
PTS-INCIDENT-NBR Element: Incident Nbr | Numeric 4 If the test is a result of an incident, this field contains the incident number. |
|
||||
PTS-REFUSE-REASON Element: Refuse Reason | Alpha 10 Contains the reason the employee refused to take the test. |
|
||||
PTS-RENEW-DATE Element: Renew Date | Numeric 8 (yyyymmdd) Contains the date for the renewal test. |
|
||||
PTS-RENEW-TEST Element: Renew Test | Alpha 10 Contains the renewal test. |
|
||||
PTS-FOLLOW-DATE Element: Follow Date | Numeric 8 (yyyymmdd) Contains the date for the follow up test. |
|
||||
PTS-FOLLOW-TEST Element: Follow Test | Alpha 10 Contains the follow up test. |
|
||||
PTS-COMMENT Element: Comment | Alpha 40 (Lower Case) Contains comments about the follow up test. |
|
||||
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. |
|||||
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. |
|||||
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. |
|
||||
PTS-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||
PTS-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||||
PTS-WF-EMP-TST-SEQ Element: Wf Emp Tst Seq | Derived |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PTSSET1 |
COMPANY EMP-APP EMPLOYEE TEST SEQ-NBR |
|
|||||||||||||||
PTSSET2 |
PARENT-OBJ-ID OBJ-ID |
|
| ||||||||||||||
PTSSET3 |
COMPANY NEXT-DATE TEST EMP-APP EMPLOYEE SEQ-NBR |
|
| ||||||||||||||
PTSSET4 |
COMPANY TEST EMP-APP EMPLOYEE SEQ-NBR* |
|
| ||||||||||||||
PTSSET5 |
COMPANY EMP-APP EMPLOYEE TEST SCHED-DATE* SEQ-NBR |
|
| ||||||||||||||
PTSSET6 |
COMPANY SCHED-DATE TEST EMP-APP EMPLOYEE SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Applicant | APPLICANT |
Required
| ||||||||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||
Establishment | OSHESTAB |
Required
| ||||||||||||||||||
Follow Test | PATSTSETUP |
Required
| ||||||||||||||||||
Incident | OSHA |
Required
| ||||||||||||||||||
Notify Type | PCODES |
Required
| ||||||||||||||||||
Paemployee | PAEMPLOYEE |
Required
| ||||||||||||||||||
Reason | PCODES |
Required
| ||||||||||||||||||
Refusal | PCODES |
Required
| ||||||||||||||||||
Renew Test | PATSTSETUP |
Required
| ||||||||||||||||||
Results | PATSTRESLT |
Required
| ||||||||||||||||||
Test | PATSTSETUP |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.