PREMPWKPAT

UPDATED BY
HR125 UK34.1 PA115 TM260 TM265 UK87.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WKE-COMPANY
Element: Company Hr
Numeric 4
UK34.1
WKE-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.
UK34.1
WKE-PATTERN-CODE
Element: Pattern Code
Alpha 3
UK34.1
WKE-PATT-EFF-FROM
Element: Patt Eff From
Numeric 8 (yyyymmdd)
UK34.1
WKE-WEEK-NBR
Element: Week Nbr
Numeric 2
UK34.1
WKE-EFF-DATE-TO
Element: Eff Date To
Numeric 8 (yyyymmdd)
UK34.1
WKE-SUN-DETL
Element: Sun Detl
Signed 4.2
UK34.1
WKE-MON-DETL
Element: Mon Detl
Signed 4.2
UK34.1
WKE-TUE-DETL
Element: Tue Detl
Signed 4.2
UK34.1
WKE-WED-DETL
Element: Wed Detl
Signed 4.2
UK34.1
WKE-THU-DETL
Element: Thu Detl
Signed 4.2
UK34.1
WKE-FRI-DETL
Element: Fri Detl
Signed 4.2
UK34.1
WKE-SAT-DETL
Element: Sat Detl
Signed 4.2
UK34.1


PREMPWKPAT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WKESET1 COMPANY
EMPLOYEE
PATT-EFF-FROM
HR125 PA115
UK34.1 TM260
TM265
WKESET3 PATTERN-CODE
WEEK-NBR
COMPANY
EMPLOYEE
PATT-EFF-FROM
KeyChange
UK87.1


PREMPWKPAT FILE RELATIONS


ONE TO ONE RELATIONS

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


File created: Wed Jun 08 20:51:11 2016

Home
Contact Us



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