13 External System Intra-day Integration

This chapter describes the measure files AIP receives from an external system for Intra-day.

Measure Data Overview

The tables in this section list the measure files AIP receives from an external system for Intra-day. The measures are categorized by:

• Intra-day Measure Files Used by Daily Batch Only

• Intra-day Measures Used by Intra-day Batch Only

• Intra-day Measures Used by Both Daily and Intra-day Batches

Intra-day Measure Files Used by Daily Batch Only

Table 13-1 lists the Intra-day measures used by daily batch only.

Table 13-1 Intra-day Measure Files Used by Daily Batch Only

File Name	Description	Source
idrplnflgl1i.txt	Intra-day Release Replan Indicator by Store/SKU/day	External
idrplnflgl2i.txt	Intra-day Release Replan Indicator by Store/SKU/Week-pattern	External
idrplnflgl3i.txt	Intra-day Release Replan Indicator by Store/Department/Day	External / AIP-Oracle
idrplnflgl4i.txt	Intra-day Release Replan Indicator by Store/Department/Week-pattern	External / AIP-Oracle
idrwal1i.txt	Intra-day Release Wave Assignment by Store/SKU/day	External
idrwal2i.txt	Intra-day Release Wave Assignment by Store/SKU/Week-pattern	External
idrwal3i.txt	Intra-day Release Wave Assignment by Store/Department/Day	External / AIP-Oracle
idrwal4i.txt	Intra-day Release Wave Assignment by Store/Department/Week-pattern	External / AIP-Oracle

Intra-day Measures Used by Intra-day Batch Only

Table 13-2 lists the Intra-day measures used by Intra-day batch only.

Table 13-2 Intra-day Measure Files Used by Intra-day Batch Only

File Name	Description	Source
idsnpshttiml1i.txt	Intra-day Release Wave Inventory Snapshot Time Exception	External
idsnpshttiml2i.txt	Intra-day Release Wave Inventory Snapshot Time Default	External / AIP-Oracle

Intra-day Measures Used by Both Daily and Intra-day Batches

Table 13-3 lists the Intra-day measures used by both daily and Intra-day batches.

Table 13-3 Intra-day Measure Files Used by Both Daily and Intra-day Batches

File Name	Description	Source
ipddpl1i.txt	Delivery-day demand percent by Location/SKU/Day	External
ipddpl2i.txt	Delivery-day demand percent by Location/SKU/Week-pattern	External
ipddpl3i.txt	Delivery-day demand percent by Location/Department/Day	External / AIP-Oracle
ipddpl4i.txt	Delivery-day demand percent by Location/Department/Week-pattern	External / AIP-Oracle
ipddpl5i.txt	Delivery-day demand percent by Location/Day	External / AIP-Oracle
ipddpl6i.txt	Delivery-day demand percent by Location/Week-pattern	External / AIP-Oracle
iphrslsprofi.txt	Hourly sales profile	External
iponshelfl1i.txt	On-shelf Time by Store/SKU/Day	External
iponshelfl2i.txt	On-shelf Time by Store/Department/Day	External
iponshelfl3i.txt	On-shelf Time by Store/Department/Week-pattern	External

Details for Intra-day Measures Used by Daily Batch Only

This section provides details for Intra-day measures used by the daily batch only.

idrplnflgl1i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Intra-day Release Replan Indicator by Store/SKU/day	Indicates whether or not to include the store order in an Intra-day re-plan just prior to its Intra-day release.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	idrplnflgl1i
Source Object Name	idrplnflgl1i.txt	Target Object Database	data/rplnflgl1
Required/Optional	Optional	Target Object Load Intersection	day_dstk_sku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DAY	Day	1	9
DSTK	Destination Stocking Point	10	20
SKU	SKU	30	20
Value	Intra-day Release Replan Indicator by Store/SKU/day	50	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY	Day	String	"D20060401"
DSTK	Destination Stocking Point	String	"S303 "
SKU	SKU	String	"118525 "
Value	Intra-day Release Replan Indicator by Store/SKU/day	Integer	"1 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of idrplnflgl1i.txt extract file format:

D20060401S303 118525 1

idrplnflgl2i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Intra-day Release Replan Indicator by Store/SKU/Week-pattern	Indicates whether or not to include the store order in an Intra-day re-plan just prior to its Intra-day release.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	idrplnflgl2i
Source Object Name	idrplnflgl2i.txt	Target Object Database	data/rplnflgl2
Required/Optional	Optional	Target Object Load Intersection	dow_dstk_sku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DOW	Day of Week	1	8
DSTK	Destination Stocking Point	9	20
SKU	SKU	29	20
Value	Intra-day Release Replan Indicator by Store/SKU/Week-pattern	49	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DOW	Day of Week	String	"THR "
DSTK	Destination Stocking Point	String	"S303 "
SKU	SKU	String	"118525 "
Value	Intra-day Release Replan Indicator by Store/SKU/Week-pattern	Integer	"1 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of idrplnflgl2i.txt extract file format:

THR S303 118525 1

idrplnflgl3i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Intra-day Release Replan Indicator by Store/Department/Day	Indicates whether or not to include the store order in an Intra-day re-plan just prior to its Intra-day release.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	idrplnflgl3i
Source Object Name	idrplnflgl3i.txt	Target Object Database	data/rplnflgl3
Required/Optional	Optional	Target Object Load Intersection	day_dstk_dept

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DAY	Day	1	9
DSTK	Destination Stocking Point	10	20
DEPT	Department	30	20
Value	Intra-day Release Replan Indicator by Store/Department/Day	50	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY	Day	String	"D20060401"
DSTK	Destination Stocking Point	String	"S303 "
DEPT	Department	String	"44 "
Value	Intra-day Release Replan Indicator by Store/Department/Day	Integer	"1 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of idrplnflgl3i.txt extract file format:

D20060401S303 44 1

idrplnflgl4i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Intra-day Release Replan Indicator by Store/Department/Week-pattern	Indicates whether or not to include the store order in an Intra-day re-plan just prior to its Intra-day release.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	idrplnflgl4i
Source Object Name	idrplnflgl4i.txt	Target Object Database	data/rplnflgl4
Required/Optional	Optional	Target Object Load Intersection	dow_dstk_dept

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DOW	Day of Week	1	8
DSTK	Destination Stocking Point	9	20
DEPT	Department	29	20
Value	Intra-day Release Replan Indicator by Store/Department/Week-pattern	49	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DOW	Day of Week	String	"THR "
DSTK	Destination Stocking Point	String	"S303 "
DEPT	Department	String	"44 "
Value	Intra-day Release Replan Indicator by Store/Department/Week-pattern	Integer	"1 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of idrplnflgl4i.txt extract file format:

THR S303 44 1

idrwal1i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Intra-day Release Wave Assignment by Store/SKU/day	Indicates which hour the store purchase order or transfer is released for execution.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	idrwal1i
Source Object Name	idrwal1i.txt	Target Object Database	data/rwal1
Required/Optional	Optional	Target Object Load Intersection	day_dstk_sku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DAY	Day	1	9
DSTK	Destination Stocking Point	10	20
SKU	SKU	30	20
Value	Intra-day Release Wave Assignment by Store/SKU/day	50	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY	Day	String	"D20060401"
DSTK	Destination Stocking Point	String	"S303 "
SKU	SKU	String	"118525 "
Value	Intra-day Release Wave Assignment by Store/SKU/day	Integer	"7 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of idrwal1i.txt extract file format:

D20060401S303 118525 7

idrwal2i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Intra-day Release Wave Assignment by Store/SKU/Week-pattern	Indicates which hour the store purchase order or transfer is released for execution.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	idrwal2i
Source Object Name	idrwal2i.txt	Target Object Database	data/rwal2
Required/Optional	Optional	Target Object Load Intersection	dow_dstk_sku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DOW	Day of Week	1	8
DSTK	Destination Stocking Point	9	20
SKU	SKU	29	20
Value	Intra-day Release Wave Assignment by Store/SKU/Week-pattern	49	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DOW	Day of Week	String	"THR "
DSTK	Destination Stocking Point	String	"S303 "
SKU	SKU	String	"118525 "
Value	Intra-day Release Wave Assignment by Store/SKU/Week-pattern	Integer	"7 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of idrwal2i.txt extract file format:

THR S303 118525 7

idrwal3i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Intra-day Release Wave Assignment by Store/Department/Day	Indicates which hour the store purchase order or transfer is released for execution.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	idrwal3i
Source Object Name	idrwal3i.txt	Target Object Database	data/rwal3
Required/Optional	Optional	Target Object Load Intersection	day_dstk_dept

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DAY	Day	1	9
DSTK	Destination Stocking Point	10	20
DEPT	Department	30	20
Value	Intra-day Release Wave Assignment by Store/Department/Day	50	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY	Day	String	"D20060401"
DSTK	Destination Stocking Point	String	"S303 "
DEPT	Department	String	"44 "
Value	Intra-day Release Wave Assignment by Store/Department/Day	Integer	"7 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of idrwal3i.txt extract file format:

D20060401S303 44 7

idrwal4i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Intra-day Release Wave Assignment by Store/Department/Week-pattern	Indicates which hour the store purchase order or transfer is released for execution.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	idrwal4i
Source Object Name	idrwal4i.txt	Target Object Database	data/rwal4
Required/Optional	Optional	Target Object Load Intersection	dow_dstk_dept

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DOW	Day of Week	1	8
DSTK	Destination Stocking Point	9	20
DEPT	Department	29	20
Value	Intra-day Release Wave Assignment by Store/Department/Week-pattern	49	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DOW	Day of Week	String	"THR "
DSTK	Destination Stocking Point	String	S303
DEPT	Department	String	"44 "
Value	Intra-day Release Wave Assignment by Store/Department/Week-pattern	Integer	"7 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of idrwal4i.txt extract file format:

THR S303 44 7

Details for Intra-day Measures Used by Intra-day Batch Only

This section provides details for Intra-day measures used by Intra-day batch only.

idsnpshttiml1i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Intra-day Release Wave Inventory Snapshot Time Exception	The approximate time the inventory snapshot is captured for the release wave. This is used to revise sales forecasts during Intra-day replanning.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	idsnpshttiml1i
Source Object Name	idsnpshttiml1i.txt	Target Object Database	data/idsnpshttiml1i
Required/Optional	Optional	Target Object Load Intersection	day_seq

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DAY	Day	1	9
SEQ	Sequence Number	10	20
Value	Intra-day Release Wave Inventory Snapshot Time Exception	30	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY	Day	String	"D20060401"
SEQ	Sequence Number	String	"0007 "
Value	Intra-day Release Wave Inventory Snapshot Time Exception	Integer	"1230 " NaVal = -1

Formatting Conditions

None

Example of idsnpshttiml1i.txt extract file format:

D200604010007 1230

idsnpshttiml2i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Intra-day Release Wave Inventory Snapshot Time Default	The approximate time the inventory snapshot is captured for the release wave. This is used to revise sales forecasts during Intra-day replanning.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	idsnpshttiml2i
Source Object Name	idsnpshttiml2i.txt	Target Object Database	data/idsnpshttiml2i
Required/Optional	Optional	Target Object Load Intersection	dow_seq

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DOW	Day of Week	1	8
SEQ	Sequence Number	9	20
Value	Intra-day Release Wave Inventory Snapshot Time Default	29	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DOW	Day of Week	String	"THR "
SEQ	Sequence Number	String	"0007 "
Value	Intra-day Release Wave Inventory Snapshot Time Default	Integer	"1230 " NaVal = -1

Formatting Conditions

None

Example of idsnpshttiml2i.txt extract file format:

THR 0007 1230

Details for Intra-day Measures Used by Both Daily and Intra-day Batches

This section provides details for Intra-day measures used by both daily and Intra-day batches.

ipddpl1i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Delivery-day demand percent by Location/SKU/Day	Indicates what portion of a day's forecast demand can be met by a delivery on that day. Warehouses are restricted to 0% or 100%.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	ipddpl1i
Source Object Name	ipddpl1i.txt	Target Object Database	data/ddpl1
Required/Optional	Optional	Target Object Load Intersection	day_dstk_sku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DAY	Day	1	9
DSTK	Destination Stocking Point	10	20
SKU	SKU	30	20
Value	Delivery-day demand percent by Location/SKU/Day	50	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY	Day	String	"D20060401"
DSTK	Destination Stocking Point	String	"S303 "
SKU	SKU	String	"118525 "
Value	Delivery-day demand percent by Location/SKU/Day	Real	".75 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of ipddpl1i.txt extract file format:

D20060401S303 118525 .75

ipddpl2i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Delivery-day demand percent by Location/SKU/Week-pattern	Indicates what portion of a day's forecast demand can be met by a delivery on that day. Warehouses are restricted to 0% or 100%.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	ipddpl2i
Source Object Name	ipddpl2i.txt	Target Object Database	data/ddpl2
Required/Optional	Optional	Target Object Load Intersection	dow_dstk_sku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DOW	Day of Week	1	8
DSTK	Destination Stocking Point	9	20
SKU	SKU	29	20
Value	Delivery-day demand percent by Location/SKU/Week-pattern	49	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DOW	Day of Week	String	"THR "
DSTK	Destination Stocking Point	String	"S303 "
SKU	SKU	String	"118525 "
Value	Delivery-day demand percent by Location/SKU/Week-pattern	Real	".75 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of ipddpl2i.txt extract file format:

THR S303 118525 .75

ipddpl3i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Delivery-day demand percent by Location/Department/Day	Indicates what portion of a day's forecast demand can be met by a delivery on that day. Warehouses are restricted to 0% or 100%.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	ipddpl3i
Source Object Name	ipddpl3i.txt	Target Object Database	data/ddpl3
Required/Optional	Optional	Target Object Load Intersection	v

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DAY	Day	1	9
DSTK	Destination Stocking Point	10	20
DEPT	Department	30	20
Value	Delivery-day demand percent by Location/Department/Day	50	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY	Day	String	"D20060401"
DSTK	Destination Stocking Point	String	"S303 "
DEPT	Department	String	"44 "
Value	Delivery-day demand percent by Location/Department/Day	Real	".75 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of ipddpl3i.txt extract file format:

D20060401S303 44 .75

ipddpl4i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Delivery-day demand percent by Location/Department/Week-pattern	Indicates what portion of a day's forecast demand can be met by a delivery on that day. Warehouses are restricted to 0% or 100%.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	ipddpl4i
Source Object Name	ipddpl4i.txt	Target Object Database	data/ddpl4
Required/Optional	Optional	Target Object Load Intersection	dow_dstk_dept

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DOW	Day of Week	1	8
DSTK	Destination Stocking Point	9	20
DEPT	Department	29	20
Value	Delivery-day demand percent by Location/Department/Week-pattern	49	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DOW	Day of Week	String	"THR "
DSTK	Destination Stocking Point	String	"S303 "
DEPT	Department	String	"44 "
Value	Delivery-day demand percent by Location/Department/ Week-pattern	Real	".75 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of ipddpl4i.txt extract file format:

THR S303 44 .75

ipddpl5i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Delivery-day demand percent by Location/Day	Indicates what portion of a day's forecast demand can be met by a delivery on that day. Warehouses are restricted to 0% or 100%.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	ipddpl5i
Source Object Name	ipddpl5i.txt	Target Object Database	data/ddpl5
Required/Optional	Optional	Target Object Load Intersection	day_dstk

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DOW	Day of Week	1	8
DSTK	Destination Stocking Point	9	20
DEPT	Department	29	20
Value	Intra-day Release Wave Assignment by Store/Department/Week-pattern	49	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DOW	Day of Week	String	"THR "
DSTK	Destination Stocking Point	String	"S303 "
DEPT	Department	String	"44 "
Value	Intra-day Release Wave Assignment by Store/Department/Week-pattern	Integer	"7 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of ipddpl5i.txt extract file format:

THR S303 44 7

ipddpl6i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Delivery-day demand percent by Location/Week-pattern	Indicates what portion of a day's forecast demand can be met by a delivery on that day. Warehouses are restricted to 0% or 100%.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	ipddpl6i
Source Object Name	ipddpl6i.txt	Target Object Database	data/ddpl6
Required/Optional	Optional	Target Object Load Intersection	dow_dstk

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DOW	Day of Week	1	8
DSTK	Destination Stocking Point	9	20
Value	Delivery-day demand percent by Location/Week-pattern	29	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DOW	Day of Week	String	"THR "
DSTK	Destination Stocking Point	String	"S303 "
Value	Delivery-day demand percent by Location/Week-pattern	Real	".75 "NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of ipddpl6i.txt extract file format:

THR S303 .75

iphrslsprofi.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	Hourly sales profile	Indicates the cumulative percentage of the day's sales that have been completed, by hour.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	iphrslsprofi
Source Object Name	iphrslsprofi.txt	Target Object Database	data/slsprof
Required/Optional	Optional	Target Object Load Intersection	dow_dstk_seq_scls

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DOW	Day of Week	1	8
DSTK	Destination Stocking Point	9	20
SEQ	Sequence Number	29	20
SCLS	Subclass	49	20
Value	Hourly sales profile	69	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DOW	Day of Week	String	"THR "
DSTK	Destination Stocking Point	String	"S303 "
SEQ	Sequence Number	String	"0007 "
SCLS	Subclass	String	"44_604_1466 "
Value	Hourly sales profile	Real	".75 " NaVal = 1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of iphrslsprofi.txt extract file format:

THR S303 0007 44_604_1466 .75

iponshelfl1i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	On-shelf Time by Store/SKU/Day	Indicates the time that a delivery is placed on the store shelf to fulfill consumer demand. Time is specified down to the nearest minute from 0001 to 2400.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	iponshelfl1i
Source Object Name	iponshelfl1i.txt	Target Object Database	data/onshelfl1
Required/Optional	Optional	Target Object Load Intersection	day_dstk_sku

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DAY	Day	1	9
DSTK	Destination Stocking Point	10	20
SKU	SKU	30	20
Value	On-shelf Time by Store/SKU/Day	50	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY	Day	String	"D20060401"
DSTK	Destination Stocking Point	String	"S303 "
SKU	SKU	String	"118525 "
Value	On-shelf Time by Store/SKU/Day	Integer	"1230 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of iponshelfl1i.txt extract file format:

D20060401S303 118525 1230

iponshelfl2i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	On-shelf Time by Store/Department/Day	Indicates the time that a delivery is placed on the store shelf to fulfill consumer demand. Time is specified down to the nearest minute from 0001 to 2400.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	iponshelfl2i
Source Object Name	iponshelfl2i.txt	Target Object Database	data/onshelfl2
Required/Optional	Optional	Target Object Load Intersection	day_dstk_dept

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DAY	Day	1	9
DSTK	Destination Stocking Point	10	20
DEPT	Department	30	20
Value	On-shelf Time by Store/Department/Day	50	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DAY	Day	String	"D20060401"
DSTK	Destination Stocking Point	String	"S303 "
DEPT	Department	String	"44 "
Value	On-shelf Time by Store/Department/Day	Integer	"1230 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of iponshelfl2i.txt extract file format:

D20060401S303 44 1230

iponshelfl3i.txt

Data Element Details

Data Type	Data Element Name	Data Description
Measure	On-shelf Time by Store/Department/Week-pattern	Indicates the time that a delivery is placed on the store shelf to fulfill consumer demand. Time is specified down to the nearest minute from 0001 to 2400.

Extracting Program Details

Program Type	Program Name	Schema File	Program Frequency
not applicable	not applicable	not applicable	Daily

Data Source and Target Details

Data Source Details		Target Data Details
Data Origin System	External Systems	Target Object Type	RPAS Measure
Source Object Type	Fixed-length Text File	Target Object Name	iponshelfl3i
Source Object Name	iponshelfl3i.txt	Target Object Database	data/onshelfl3
Required/Optional	Optional	Target Object Load Intersection	dow_dstk_dept

Field Level Mapping - Source

Source Fields	Source Field Description	Field Start Position	Field Width
DOW	Day of Week	1	8
DSTK	Destination Stocking Point	9	20
DEPT	Department	29	20
Value	On-shelf Time by Store/Department/Week-pattern	49	8

Field Level Mapping - Target

Target Data Field Name	Target Field Description	Target Field Data Type	Condition/Format
DOW	Day of Week	String	"THR "
DSTK	Destination Stocking Point	String	"S303 "
DEPT	Department	String	"44 "
Value	On-shelf Time by Store/Department/Week-pattern	Integer	"1230 " NaVal = -1

Formatting Conditions

Value	Prefix (Case Sensitive)
Supplier	V
Warehouses	W
Stores	S

Example of iponshelfl3i.txt extract file format:

THR S303 44 1230