PAEMPTRACK

Required Training

Contains information about tracks and courses that employees are required to take. TR13.1 (Required Training by Track & Course) and TR13.2 (Required Training by Employee - Track or Course) are the primary programs that update this file.
UPDATED BY
TR113 TR114 TR13.1 TR13.2 TR15.1 TR21.1
TR22.1 TR500 HR11.1 PA115 TR120 TR121
TR20.1 TR20.2 TR20.3 TR20.4 TR201 TR222
TR05.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ETR-COMPANY
Element: Company		Numeric 4
Contains the company number.
TR113 TR114
TR13.1 TR13.2
TR15.1
ETR-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.
TR113 TR114
TR13.1 TR13.2
TR15.1
ETR-TYPE
Element: Type		Alpha 2
Indicates whether the required training is a course or a track. CS = Course TR = Track
TR113 TR114
TR13.1 TR13.2
TR15.1
ETR-TRACK
Element: Track or Course Code		Alpha 10
Contains the track or course code.
TR113 TR114
TR13.1 TR13.2
TR15.1
ETR-START-DATE
Element: Effective Date		Numeric 8 (yyyymmdd)
Contains the date the track or course is assigned to the employee.
TR113 TR114
TR13.1 TR13.2
TR15.1
ETR-TRACK-STATUS
Element: Status		Alpha 1
Indicates whether the employee has completed the track. C = Complete I = Incomplete; Default value
F = Fully completed
N = Completed without skills prof
S = Partially completed with skill
P = Partially completed - no skill
TR113 TR114
TR13.1 TR13.2
TR15.1 TR21.1
TR22.1 TR500
ETR-EXP-CMPLT-DATE
Estimated
Completion Date		Numeric 8 (yyyymmdd)
Contains the estimated date for completing the course or track.
TR113 TR114
TR13.1 TR13.2
TR15.1
ETR-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
Contains the date the employee completed the course or track.
TR13.1 TR13.2
TR15.1 TR21.1
TR22.1 TR500


PAEMPTRACK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ETRSET1 COMPANY
EMPLOYEE
TYPE
TRACK
HR11.1 PA115
TR113 TR114
TR120 TR121
TR13.2 TR15.1
TR20.1 TR20.2
TR20.3 TR20.4
TR201 TR21.1
TR22.1 TR222
TR500
ETRSET3 TYPE
TRACK
COMPANY
EMPLOYEE
TR05.1 TR13.1
TR13.2 TR15.1
TR201


PAEMPTRACK FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
ETR-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
ETR-COMPANY->EMP-COMPANY
ETR-EMPLOYEE->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
ETR-COMPANY->PEM-COMPANY
ETR-EMPLOYEE->PEM-EMPLOYEE


PAEMPTRACK FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE
Valid When (ETR-TYPE ="CS" )
ETR-TRACK->CRS-COURSE
  CRS-EFFECTIVE-DATE
Track PATRACK
Valid When (ETR-TYPE ="TR" )
ETR-TRACK->TRA-TRACK
  TRA-EFFECTIVE-DATE

File created: Wed Jun 08 20:50:23 2016

Home
Contact Us



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