PREMPWKPAT

REFERENCED BY
TM260 TM265

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


PREMPWKPAT FILE INDEX

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


PREMPWKPAT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
WKE-COMPANY->EMP-COMPANY (EMPSET1)
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: Thu Jun 09 02:30:34 2016

Home
Contact Us



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