PRWKPAT

REFERENCED BY
UK34.1 TM260 TM265


UPDATED BY
UK87.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WKP-PATTERN-CODE
Element: Pattern Code		Alpha 3
UK87.1
WKP-PATTERN-DESC
Element: Pattern Desc		Alpha 20
UK87.1
WKP-WEEKS-IN-PATT
Element: Weeks In Patt		Numeric 3
UK87.1


PRWKPAT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WKPSET1 PATTERN-CODE
UK34.1 UK87.1
TM260 TM265


PRWKPAT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Prempwkpat PREMPWKPAT Delete Cascades
WKP-PATTERN-CODE->WKE-PATTERN-CODE
  WKE-WEEK-NBR
  WKE-COMPANY
  WKE-EMPLOYEE
  WKE-PATT-EFF-FROM
Prwkpatdtl PRWKPATDTL Delete Cascades
WKP-PATTERN-CODE->WKD-PATTERN-CODE
  WKD-WEEK-NBR

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

Home
Contact Us



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