QLabor ODS

Technical Name: 0RC_DS07

Use

The QLabor ODS is used to stage the data prior to loading into the QLabor InfoCube primarily to allow for overwrite functionality to filter out multiple data loads.

InfoSources

0RC_CI_7 Qlabor

Key Fields

Key Field

Description

0RC_RT_FDY

Retail Fiscal Date

0RC_RT_QHR

Quarter Hour Indicator

0RC_RT_FQH

Retail Fiscal Quarter Hour

0RC_RT_FYR

Retail Fiscal Year

0RC_RT_FMO

Retail Fiscal Month

0RC_RT_FWK

Retail Fiscal Week

0RC_RT_FDIW

Retail Fiscal Day in Week

0RC_STORE

Store

0RC_DEPART

Department

0RC_JOB

Job

0CALDAY

Calendar day

Data Fields

Transactional data comes from the InfoSource with an indicator as to whether the data is intermediate or final. Most of the Key Figures will use a Routine in the Update Rules that evaluates the 0RC_RT_IFI field in the Communication Structure and determines if the corresponding Key Figure should be populated or not.

This routine will be applied to all of the Key Figures except Coverage.

Data Field

Description

0RC_FWKLD

Forecasted Workload

0RC_FLOW_WL

Flowed Workload

0RC_FWKLI

Intermediate Forecasted Workload

0RC_SCHBRKI

Intermediate Scheduled Breaks

0RC_SCHFTI

Intermediate Scheduled Shifts

0RC_FILL_WL

Filler Workload

0RC_STAT_WL

Static Workload

0RC_SCHSFT

Scheduled Shifts

0RC_SCHBRK

Scheduled Breaks

0RC_COVER

Actual Coverage

0RC_FILLIWL

Intermediate Filler Workload

0RC_FLOWIWL

Intermediate Flowed Workload

0RC_STATIWL

Intermediate Static WL

0UNIT

Unit of measure

Delta Update

This ODS object is designed for a delta update with a flat file DataSource.