PREMPWKPAT FILE
REFERENCED BY
TM260 TM265 UK87.1
UPDATED BY
HR125 UK34.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WKE-COMPANY Numeric 4 UK34.1
Element: Company Hr
WKE-EMPLOYEE Numeric 9 UK34.1
Element: Employee 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.
WKE-PATTERN-CODE Alpha 3 UK34.1
Element: Pattern Code
WKE-PATT-EFF-FROM Numeric 8 (yyyymmdd) UK34.1
Element: Patt Eff From
WKE-WEEK-NBR Numeric 2 UK34.1
Element: Week Nbr
WKE-EFF-DATE-TO Numeric 8 (yyyymmdd) UK34.1
Element: Eff Date To
WKE-SUN-DETL Signed 4.2 UK34.1
Element: Sun Detl
WKE-MON-DETL Signed 4.2 UK34.1
Element: Mon Detl
WKE-TUE-DETL Signed 4.2 UK34.1
Element: Tue Detl
WKE-WED-DETL Signed 4.2 UK34.1
Element: Wed Detl
WKE-THU-DETL Signed 4.2 UK34.1
Element: Thu Detl
WKE-FRI-DETL Signed 4.2 UK34.1
Element: Fri Detl
WKE-SAT-DETL Signed 4.2 UK34.1
Element: Sat Detl
PREMPWKPAT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WKESET1 COMPANY HR125 PA115
EMPLOYEE UK34.1 TM260
PATT-EFF-FROM TM265
WKESET3 PATTERN-CODE KeyChange UK87.1
WEEK-NBR
COMPANY
EMPLOYEE
PATT-EFF-FROM
PREMPWKPAT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
WKE-COMPANY -> EMP-COMPANY
WKE-EMPLOYEE -> EMP-EMPLOYEE
Prwkpat PRWKPAT Required
WKE-PATTERN-CODE -> WKP-PATTERN-CODE
Prwkpatdtl PRWKPATDTL Required
WKE-PATTERN-CODE -> WKD-PATTERN-CODE
WKE-WEEK-NBR -> WKD-WEEK-NBR
|
