|
|
HRWRKDTL FILE
Contains the detail for a work schedule
REFERENCED BY
HR221
UPDATED BY
HR21.1 HR00.1 HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WSD-COMPANY Numeric 4 HR21.1
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
WSD-WORK-SCHED Alpha 10 HR21.1
Element: Code
WSD-EFFECT-DATE Numeric 8 (yyyymmdd) HR21.1
Element: Date
WSD-WORK-PERIOD Numeric 2 HR21.1
Element: Work Period
WSD-DESCRIPTION Alpha 30 (Lower Case) HR21.1
Element: Description This field displays the description.
WSD-WORK-DAYS Signed 6.4 HR21.1
Element: Ws Days
WSD-NON-WORK-DAYS Signed 6.4 HR21.1
Element: Ws Days
WSD-OTHER-DAYS Signed 6.4 HR21.1
Element: Ws Days
WSD-PRD-TOT-DAYS Derived
Element: Prd Tot Days
WSD-DATE-STAMP Numeric 8 (yyyymmdd) HR21.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
WSD-TIME-STAMP Numeric 6 (hhmmss) HR21.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
WSD-USER-ID Alpha 10 (Lower Case) HR21.1
Element: User Contains the user ID of the person who
last changed this record.
HRWRKDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WSDSET1 COMPANY HR00.1 HR01.1
WORK-SCHED PBIP.1 PR197
EFFECT-DATE
WORK-PERIOD
WSDSET2 COMPANY HR21.1 HR221
WORK-SCHED
EFFECT-DATE*
WORK-PERIOD
HRWRKDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
WSD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Work Sch HRWRKSCHD Required
WSD-COMPANY -> WSC-COMPANY
WSD-WORK-SCHED -> WSC-WORK-SCHED
WSD-EFFECT-DATE -> WSC-EFFECT-DATE
|
