Google Git
Sign in
apache / hawq / refs/heads/master / . / tools / tpcds / tools / tpcds.wam
blob: 3fae3c9944254330df47517021770dfe8e57d422 [file] [log] [blame]
# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements. See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership. The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License. You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied. See the License for the
# specific language governing permissions and limitations
# under the License.
/BEGIN_TABLE AMCHEAD
NAME A30
VERS A8
USER A30
/BEGIN_DATA AMCHEAD
PowerDesigner/WAM
6.1.3
/END_TABLE AMCHEAD
/BEGIN_TABLE AMCMODL
@ N5
OID N10
MODL N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
OPTS TXT
EXOP TXT
DBMS A256
FILE A256
HEAD TXT
FOOT TXT
POID N10
PNAM A80
PCOD A80
USER A80
VERS A8
CDAT N12
MDAT N12
EDAT N12
PART N1
ACCS N5
CUST TXT
/BEGIN_DATA AMCMODL
3
1
1
TPCDS
TPCDS
ANSI Level 2
ansi2.def
0
TPCDS
TPCDS
940354999
1163537651
0
0
0
/END_TABLE AMCMODL
/BEGIN_TABLE AMCDOMN
@ N5
OID N10
DOMN N10
NAME A80
CODE A80
DESC TXT
NOTE TXT
LABL A254
DTTP A30
MLEN N8
PREC N2
IDNT N1
WDEF N1
MAND N1
UNIT A8
FRMT A20
LVAL A20
HVAL A20
DVAL A30
UPPR N1
LOWR N1
NMDF N1
VALS TXT
CRUL TXT
GRUL TXT
SOID N10
ATYP N10
PROF N10
ROPR N1
/BEGIN_DATA AMCDOMN
/END_TABLE AMCDOMN
/BEGIN_TABLE AMCTABL
@ N5
OID N10
TABL N10
MODL N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
NBRC N24,0
SOID N10
TOBJ N5
COBJ A80
OPTS TXT
PKOP TXT
CRUL TXT
SRUL TXT
PKCN A30
CKCN A30
HEAD TXT
FOOT TXT
NGEN N1
OWNR N10
ATYP N10
TSTD N8
ROPR N1
/BEGIN_DATA AMCTABL
3
15
15
1
Customer_Address
CA
One row for each unique customer location\
\
Describes physical location of the customer\
\
Data generator enforces constraint that customers with same household demographic will have the same address (since at this point we define household as customers with the same address) This was originally enforced by having each row in\\
this table contain a reference to a household demographic entry. This created several strange linkages in other tables that contained both addresses and household demographics.
Remove reference to household demographics. Data generator will enforce constraint that customers with the same household demographics will have the same address.\
\
Possible candidate for refresh function: find and remove stale entries.
150000
0
0
ADDRESS
0
0
0
0
0
3
28
28
1
Customer
C
100000
0
0
CUSTOMER
0
0
0
0
0
3
39
39
1
Customer_Demographics
CD
One row for each unique combination of customer demographics.\
\
The values in this table represent "RAW" answers provided by a customer in response to demographic questions.
Purchase band is not defined.\
To be consistent with the income band referenced from household demographics this would be a separate dimension. Do we really want to move to the snowflake model?
10000
0
0
DEMOGRAPHICS
PK_C_DEMOGRAPHICS
0
0
0
0
0
3
49
49
1
Store
S
500
0
0
STORE
0
0
0
0
0
3
50
50
1
Inventory
INV
15000000
0
0
INVENTORY
0
0
0
0
0
3
270
270
1
Item
I
1. In column descriptions, remove all references to Product and Product_ID, since these columns have been deleted. Also delete PRODUCT_NAME column completely.\
\
2. Research problem: explore functions that map from item upwards to higher levels of hierarchy, and maintain proper inclusion (i.e. if Item 1,2 and 3 are in Class A, and Item 4,5, and 6 are in Class B, we should never map Item 2 to any\\
other class but A. A possible approach is:\
\
item ID mod 1000 = subclass_ID, then subclass_ID mod 200 = class_ID, etc. This maintains inclusion, but has the perhaps undesirable property that every subclass has the same number of items, every class has the same number of subclasses,\\
etc. In other words, the "tree" describing the hierarchy is perfectly balanced at all levels.\
\
A way to "unbalance" the tree at the top level would be to only use the "mod" approach up to and including selecting the Class of a generated item. After that, use statically generated mappings of Category->subcategory->class that contain\\
skew. I.e. some categories have more subcategories than others, some subcats. have more classes than others. \
\
In any case, decide how many distinct values there are for each hierarchy_ID column. In the above approach, doing mod 10 gives 10 distinct values for a given level. Need to specify this at all levels of the hierarchy.\
\
3. Assign textual strings to hierarchy description columns (category, subcategory, class, subclass, brand, item). One idea is to use statically generated mappings *and* names (see above) for category->subcategory->class based on common\\
retail departments. For the lower levels of the hierarchy, one could do the following:\
\
Class nnn gets the name concat(category_name, subcategory_name, "classnnn")\
Subclass xxx gets the name "SBCLxxxx"\
Brandyyy gets concat("SBCLxxxx", BRANDyyyyyy") where Brand yyyy is in Subclass xxx. \
Item zzz gets name concat ("SBCLxxx", "BRANDyyyyy", "ITEMzzzz") where Item zzz has been determined (using the function defined in "research problem", above) to be in Brand yyyy and Subclass xxxx).\
\
4.) The hierarchy item->brand->manufacturer is somewhat separate. Need to define a function to map brand_id to manufacturer_ID, and decide on a manufacturer name. As above, one could simply say that manufacturer xxx is named\\
"MANUFACTURERxxx".\
\
5.) There are a number of attribute columns that don't apply to every conceivable item. For example, Flavor would only apply to food items, etc. One approach would be to mandate during generation that the population (or lack thereof) of\\
the attribute column would depend on category membership of the item. For example, if an item is in the Clothing category, we would populate the (size and unit) columns. If an item is in the Food category, we might populate the (size,\\
flavor, container) columns. If a column is not to be populated (because of "category mismatch), we would populate it with a value that means "not applicable". Need to specify column domains for each of: formulation, flavor, size,\\
container, units.\
\
6.) Need to decide how many product managers there are.
10000
0
0
ITEM
0
0
0
0
0
3
308
308
1
Date_Dim
D
Table of dates.\
Values in almost all fields in this table can be derived. It is used to simplify queries.
Things to do:\
- we may want to add the following columns\
Previous Day, Week, Month, Quarter, Year\
Next Day, Week, Month, Quarter, Year\
\
- as we are developing queries we may add additional unspecified columns\
\
- it is not clear if we want to design the table so that it needs update periodically. We need to decide if we really need this, if such maintenance pays of by writing simpler SQL
2500
0
0
DATE
DATE_PK
0
0
0
0
0
3
353
353
1
Catalog_Returns
CR
10000
0
0
CATALOG_RETURNS
0
0
0
0
0
3
974
974
1
Promotion
P
One row for each promotion that has/is being run during the lifespan of the data set
15000
0
0
PROMOTION
PK_PROMOTION
0
0
0
0
0
3
990
990
1
Catalog_Page
CP
5000
0
0
CATALOG_PAGE
PK_CATALOG_PAGE
0
0
0
0
0
3
1005
1005
1
Web_Page
WP
1000
0
0
WEB_PAGE
PK_WEB_PAGE
0
0
0
0
0
3
1022
1022
1
Warehouse
W
10
0
0
WAREHOUSE
PK_WAREHOUSE
0
0
0
0
0
3
1031
1031
1
Ship_Mode
SM
200
0
0
SHIP_MODE
0
0
0
0
0
3
1045
1045
1
Call_Center
CC
10
0
0
CALL_CENTER
PK_CALL_CENTER
0
0
0
0
0
3
1076
1076
1
Web_Site
WEB
10
0
0
WEB_SITE
PK_WEB_SITE
0
0
0
0
0
3
1118
1118
1
Time_Dim
T
It seems like the last 20 byte fields (shift,sub-shift and meal time) should be in a separate small dimension tables, and the TIME table itself should contain only a code here. But the additional space is only 0.5 MB anyway.\
Maybe we should get rid of those.
86400
0
0
TIME
PK_TIME
0
0
0
0
0
3
1127
1127
1
Reason
R
150
0
0
REASON
PK_REASON
0
0
0
0
0
3
1192
1192
1
Store_Returns
SR
10000
0
0
STORE_RETURNS
PK_STORE_RETURNS
0
0
0
0
0
3
1260
1260
1
Web_Returns
WR
2000000
0
0
WEB_RETURNS
PK_WEB_RETURNS
0
0
0
0
0
3
1351
1351
1
Web_Sales
WS
200000000
0
0
WEB_SALES
PK_WEB_SALES
0
0
0
0
0
3
1468
1468
1
Catalog_Sales
CS
200000000
0
0
CATALOG_SALES
PK_CATALOG_SALES
0
0
0
0
0
3
1550
1550
1
Store_Sales
SS
200000000
0
0
STORE_SALES
PK_STORE_SALES
0
0
0
0
0
3
15340
15340
1
Income_Band
IB
One row for each income range
Are ranges mutually exclusive? Can they overlap?
20
0
0
IB
0
0
0
0
0
3
29069
29069
1
Household_demographics
HD
HD
0
0
0
HD
PK_H_DEMOGRAPHICS
0
0
0
0
0
3
38739
38739
1
Dbgen_Version
DBGEN_VERSION
Version of dbgen used to load database
0
0
0
DBGEN_VERSION
DV_VERSION
0
0
0
0
0
/END_TABLE AMCTABL
/BEGIN_TABLE AMCCOLN
@ N5
OID N10
COLN N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
TABL N10
DOMN N10
DTTP A30
MLEN N8
PREC N2
IDNT N1
WDEF N1
UNIT A8
FRMT A20
LVAL A20
HVAL A20
DVAL A30
UPPR N1
LOWR N1
NMDF N1
VALS TXT
CRUL TXT
GRUL TXT
PRIM N1
FORN N1
MAND N1
DISP N1
SOID N10
TOBJ N5
COBJ A80
CKCN A30
NUMR N8
PROF N10
REDU N8
NULV N5
AVLN N8
ATYP N10
ROPR N1
/BEGIN_DATA AMCCOLN
3
23887
23887
ca_address_sk
CA_ADDRESS_SK
15
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
CA_ADDRESS_SK
1
0
-100
0
0
0
0
3
19
19
ca_address_id
CA_ADDRESS_ID
Identifier that is the unique id of the address table. \
\
There is one row here for anything that needs an address (customer, retail store, call center, web site, warehouse, and fact tables that show customer address at the time of the sale). Dimension table references represent current\\
addresses for call center, web site, warehouse or customer.\
\
There needs to be a well-known identifier for an UNKNOWN address.
15
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
A_ADDR_ID
2
0
0
0
0
0
0
3
20
20
ca_street_number
CA_STREET_NUMBER
15
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
A_NUMBER
3
0
0
0
0
0
0
3
21
21
ca_street_name
CA_STREET_NAME
15
0
VARCHAR(60)
60
0
0
0
0
0
0
0
0
0
1
0
0
A_STREET_NAME
4
0
0
0
0
0
0
3
22
22
ca_street_type
CA_STREET_TYPE
15
0
CHAR(15)
15
0
0
0
0
0
0
0
0
0
1
0
0
A_STREET_TYPE
5
0
0
0
0
0
0
3
2800
2800
ca_suite_number
CA_SUITE_NUMBER
15
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
A_SUITE
6
0
-100
0
0
0
0
3
23
23
ca_city
CA_CITY
15
0
VARCHAR(60)
60
0
0
0
0
0
0
0
0
0
1
0
0
A_CITY
7
0
0
0
0
0
0
3
24
24
ca_county
CA_COUNTY
15
0
VARCHAR(30)
30
0
0
0
0
0
0
0
0
0
1
0
0
A_COUNTY
8
0
0
0
0
0
0
3
25
25
ca_state
CA_STATE
15
0
CHAR(2)
2
0
0
0
0
0
0
0
0
0
1
0
0
A_STATE
9
0
0
0
0
0
0
3
1107
1107
ca_zip
CA_ZIP
15
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
A_ZIP
10
0
-100
0
0
0
0
3
5961
5961
ca_country
CA_COUNTRY
15
0
VARCHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
A_COUNTRY
11
0
-100
0
0
0
0
3
1106
1106
ca_gmt_offset
CA_GMT_OFFSET
With Latitude and Logitude should be able to calculate distance between entities
15
0
DECIMAL(5,2)
5
2
0
0
0
0
0
0
0
0
1
0
0
A_LATITUDE
12
0
-100
0
0
0
0
3
5973
5973
ca_location_type
CA_LOCATION_TYPE
Type of residence or location\
\
rent/own single family house, rent multi-family house, own multi-family house, rent/own apartment, rent/own condo, rent/own commercial, retail store, call center, web site, warehouse, Unknown
15
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
A_LOCATION_TYPE
13
0
-100
0
0
0
0
3
22670
22670
c_customer_sk
C_CUSTOMER_SK
28
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
C_CUSTOMER_SK
1
0
-100
0
0
0
0
3
29
29
c_customer_id
C_CUSTOMER_ID
Sales and returns point to the customer table by this id. They also point to the address and demo information in effect at the time of the sale or return. The customer row has within it information that may change over time, but we are\\
only interested in knowing the current state (like the name today - we don't need to save somone's maiden name). Changing data (addresses, demographics) are broken out into separate tables so that their history can be maintained). \
\
When a customer column changes occur, the row is updated. For address and demographics, the pointers to the Demographics or Address tables are updated (and address rows added). This way, we seldom add customer records, *and* keep\\
historical information for sales/returns, and can easily discern the current state of a customer. Probably should offer users a view called "current customer" which is a prejoin of these three tables.\
\
It is possible for a row to be in the customer table without any sales for the customer. \
\
There needs to be a well-known identifier for an UNKNOWN customer.
28
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
C_CUST_KEY
2
0
0
0
0
0
0
3
23922
23922
c_current_cdemo_sk
C_CURRENT_CDEMO_SK
28
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CD_DEMO_SK
3
0
-100
0
0
0
0
3
30073
30073
c_current_hdemo_sk
C_CURRENT_HDEMO_SK
28
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
C_CURRENT_HDEMO_SK
4
0
-100
0
0
0
0
3
23888
23888
c_current_addr_sk
C_CURRENT_ADDR_SK
28
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CA_ADDRESS_SK
5
0
-100
0
0
0
0
3
11683
11683
c_first_shipto_date_sk
C_FIRST_SHIPTO_DATE_SK
The date of the first shipment to the customer.
28
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
C_FIRST_SHIPTO_DATE
6
0
-100
0
0
0
0
3
11684
11684
c_first_sales_date_sk
C_FIRST_SALES_DATE_SK
The date of first purchase order by the customer.
28
0
INTEGER
0
0
0
0
0
0
0
0
0
1
0
1
0
0
6
7
0
0
0
0
0
1
3
26693
26693
c_salutation
C_SALUTATION
28
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
C_SALUTATION
8
0
-100
0
0
0
0
3
33
33
c_first_name
C_FIRST_NAME
Customer's first name
28
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
C_FIRST_NAME
9
0
0
0
0
0
0
3
32
32
c_last_name
C_LAST_NAME
Customer's last name.
28
0
CHAR(30)
30
0
0
0
0
0
0
0
0
0
1
0
0
C_LAST_NAME
10
0
0
0
0
0
0
3
30
30
c_preferred_cust_flag
C_PREFERRED_CUST_FLAG
This field flags "preferred customers", a marketing program.\
\
Y for preferred customers, N for otherwise.
28
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
C_CUST_ID
11
0
0
0
0
0
0
3
5956
5956
c_birth_day
C_BIRTH_DAY
Numeric number for day of birth. For example, if someone's birth day is July 4, 1975, the number is 4.\
\
We are not pointing to the date table for this information. Otherwise, we would need a life-time's worth of date rows in the table. There is no space issue doing this, it just seems a little silly keeping 120 years worth of days in date. \\
On the other hand, it might be nice for display purposes to have all the ways of expressing the date that is found in the date table.
28
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
C_BIRTH_DAY
12
0
-100
0
0
0
0
3
5957
5957
c_birth_month
C_BIRTH_MONTH
Numeric number for month of birth. For example, if someone's birth day is July 4, 1975, the number is7.
28
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
C_BIRTH_MONTH
13
0
-100
0
0
0
0
3
5958
5958
c_birth_year
C_BIRTH_YEAR
Numeric four digit number for year of birth. For example, if someone's birth day is July 4, 1975, the number is 1975.
28
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
C_BIRTH_YEAR
14
0
-100
0
0
0
0
3
5960
5960
c_birth_country
C_BIRTH_COUNTRY
Country of birth, if known
Will require a list of candidate countries -- no other list exists, since the data set is assumed to be US-centric.
28
0
VARCHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
C_BIRTH_COUNTRY
15
0
-100
0
0
0
0
3
8744
8744
c_login
C_LOGIN
Login to the web site; Random alphanumerics
28
0
CHAR(13)
13
0
0
0
0
0
0
0
0
0
1
0
0
C_LOGIN
16
0
-100
0
0
0
0
3
8752
8752
c_email_address
C_EMAIL
Customer's email address. Stored here since historical email is of no interest
28
0
CHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
C_EMAIL
17
0
-100
0
0
0
0
3
8751
8751
c_last_review_date
C_LAST_REVIEW_DATE
Date of last update for preferred status, purchasing preference, demographic info etc.; Currently a stand-alone date. Should this be a FK to the date table?
28
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
C_LAST_REVIEW
18
0
-100
0
0
0
0
3
23921
23921
cd_demo_sk
CD_DEMO_SK
39
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
CD_DEMO_SK
1
0
-100
0
0
0
0
3
15349
15349
cd_gender
CD_GENDER
39
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
CD_GENDER
2
0
-100
0
0
0
0
3
15350
15350
cd_marital_status
CD_MARITAL_STATUS
39
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
CD_MARITAL_STATUS
3
0
-100
0
0
0
0
3
15351
15351
cd_education_status
CD_EDUCATION_STATUS
39
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
CD_EDUCATION_STATUS
4
0
-100
0
0
0
0
3
15352
15352
cd_purchase_estimate
CD_PURCHASE_ESTIMATE
Lower bound of estimated purchase amount per year
39
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
CD_PURCHASE_BAND
5
0
-100
0
0
0
0
3
15353
15353
cd_credit_rating
CD_CREDIT_RATING
39
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
CD_CREDIT_RATING
6
0
-100
0
0
0
0
3
5969
5969
cd_dep_count
CD_DEP_COUNT
Positive number represents the number of dependents supported by the customer according to the following::\
\
\
0-5 number is count; 6 means more than 5; -1 unknown
39
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
DE_DEP_COUNT
7
0
-100
0
0
0
0
3
5970
5970
cd_dep_employed_count
CD_DEP_EMPLOYED_COUNT
Positive number represents the number of employed dependents supported by the customer according to the following::\
\
\
0-5 number is count; 6 means more than 5; -1 unknown5; -1 unknown
39
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
DE_DEP_EMPLOYED_COUNT
8
0
-100
0
0
0
0
3
5971
5971
cd_dep_college_count
CD_DEP_COLLEGE_COUNT
Positive number represents the number of dependents in college supported by the customer according to the following::\
\
\
0-5 number is count; 6 means more than 5; -1 unknown
39
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
DE_DEP_COLLEGE_COUNT
9
0
-100
0
0
0
0
3
22739
22739
s_store_sk
S_STORE_SK
49
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
S_STORE_SK
1
0
-100
0
0
0
0
3
57
57
s_store_id
S_STORE_ID
Unique identifier for a physical retail store.\
Store has several hierarchies:\
\
store ---> company\
store ---> market ----> market manager
49
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
S_ID
2
0
0
0
0
0
0
3
24901
24901
s_rec_start_date
S_REC_START_DATE_ID
49
0
date
0
0
0
0
0
0
0
0
0
0
1
0
0
S_REC_START_DATE_ID
3
0
-100
0
0
0
0
3
24902
24902
s_rec_end_date
S_REC_END_DATE_ID
49
0
date
0
0
0
0
0
0
0
0
0
0
1
0
0
S_REC_END_DATE_ID
4
0
-100
0
0
0
0
3
22844
22844
s_closed_date_sk
S_CLOSED_DATE_SK
49
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_DATE_SK
5
0
-100
0
0
0
0
3
1037
1037
s_store_name
S_STORE_NAME
Name of the store. Example:\
Fred Meyer Walker Road\
QFC #185\
Stop and Shop Hollywood\
Gayfers Edgewater Mall\
\
Dependent on store, but is also a unique value\
\
Typically the store name is related to the mall that the store is in. For example, Macy Mall Center, etc.\
\
One proposal: the stoe name is the concatenation of company name and the location, e.g., Broadway Downtown\
\
Should range from 8-30 characters in length
49
0
VARCHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
S_NAME
6
0
-100
0
0
0
0
3
60
60
s_number_employees
S_EMPLOYEES
Number of employees in the store\
1 to 1200 (to allow for seasonal swings), and should somewhat correlate to the sqare footage: \
\
600 sq ft --> 6 emplyees\
250000 sq ft --> 1200 employees\
\
Dependent on store.
49
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
S_EMPLOYEES
7
0
0
0
0
0
0
3
63
63
s_floor_space
S_FLOOR_SPACE
Floor space in square meters\
Dependent on store\
Should be coorlated with store type and larger for jumbo or anything that sounds big, and small for mini or mart or anything that sounds small.
49
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
S_FLOOR_SPACE
8
0
0
0
0
0
0
3
66
66
s_hours
S_HOURS
Classification for the hours that this store is open:\
standard, extended, 24-hr\
\
Dependent on store.\
\
Vary by location and state laws. For example, downtown stores may close at 5:30PM \
Big Kmart closes at 10 pm,\
Super Kmart is 24 hours\
Sometimes stores don't open on Sunday due to Blue laws.
49
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
S_HOURS
9
0
0
0
0
0
0
3
1042
1042
s_manager
S_MANAGER
Unique id for the store manager.\
Dependent on store manager.
49
0
VARCHAR(40)
40
0
0
0
0
0
0
0
0
0
1
0
0
S_MGR
10
0
-100
0
0
0
0
3
69
69
s_market_id
S_MARKET_ID
Unique id for the market. In the following hierarchy\
\
store ---> market ----> market_manager\
\
Markets tend to be geographically based around cities.
49
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
S_MARKET_ID
11
0
0
0
0
0
0
3
70
70
s_geography_class
S_GEOGRAPHY_CLASS
For industrialized nations, this would be one of three classes:\
URBAN\
SUBURBAN\
RURAL\
\
Dependent on market.
This is the description of the sales region this store belongs to.
49
0
VARCHAR(100)
100
0
0
0
0
0
0
0
0
0
1
0
0
S_MARKET_CLASS
12
0
0
0
0
0
0
3
71
71
s_market_desc
S_MARKET_DESC
Desciption of the market. Examples:\
Seattle North West\
Seattle South West\
Portland North\
Portland North East\
Portland South East\
Portland North West\
Portland South West\
Beaverton\
\
Tied to market id but is unique amoung other markets.
49
0
VARCHAR(100)
100
0
0
0
0
0
0
0
0
0
1
0
0
S_MARKET_DESCR
13
0
0
0
0
0
0
3
73
73
s_market_manager
S_MARKET_MANAGER
The identifier for the manager of the market.\
store ---> market ----> market_ manager_id\
\
A market manager manages several markets. Those should be in a geographically close set of markets (ideally).
49
0
VARCHAR(40)
40
0
0
0
0
0
0
0
0
0
1
0
0
S_MARKET_MGR_FNAME
14
0
0
0
0
0
0
3
17968
17968
s_division_id
S_DIVISION_ID
Unique identifier for the corporate division that includes the company/store. Part of the hierarchy:\
\
store ---> company --> division --> THE CORPORATION\
\
Examples:\
State Street Store --> Marshall Fields --> Department Stores --> Target Corp
Is the placement of division in the hierarchy correct, or should it be between store and company?\
\
Current hierarchy: \
store ---> company --> division --> THE CORPORATION\
\
Examples:\
State Street Store --> Marshall Fields --> Department Stores --> Target Corp
49
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
S_DIVISION_ID
15
0
-100
0
0
0
0
3
17969
17969
s_division_name
S_DIVISION_NAME
Name of the division, dependent on division_id (1-1)
49
0
VARCHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
S_DIVISION_NAME
16
0
-100
0
0
0
0
3
74
74
s_company_id
S_COMPANY
Unique identifier for the company that owns the store. Part of the hierarchy:\
\
store ---> company --> division --> THE CORPORATION\
\
Examples:\
Fred Meyer Walker Road - company is Keogers.
49
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
S_COMPANY
17
0
0
0
0
0
0
3
1043
1043
s_company_name
S_COMPANY_NAME
Name of the company, dependent on company -id (1-1)
49
0
VARCHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
S_COMPANY_NAME
18
0
-100
0
0
0
0
3
18890
18890
s_street_number
S_STREET_NUMBER
49
0
VARCHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
S_STREET_NUMBER
19
0
-100
0
0
0
0
3
18892
18892
s_street_name
S_STREET_NAME
49
0
VARCHAR(60)
60
0
0
0
0
0
0
0
0
0
1
0
0
S_STREET_NAME
20
0
-100
0
0
0
0
3
18893
18893
s_street_type
S_STREET_TYPE
49
0
CHAR(15)
15
0
0
0
0
0
0
0
0
0
1
0
0
S_STREET_TYPE
21
0
-100
0
0
0
0
3
18891
18891
s_suite_number
S_SUITE_NUMBER
49
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
S_SUITE_NUM
22
0
-100
0
0
0
0
3
18894
18894
s_city
S_CITY
49
0
VARCHAR(60)
60
0
0
0
0
0
0
0
0
0
1
0
0
S_CITY
23
0
-100
0
0
0
0
3
18895
18895
s_county
S_COUNTY
49
0
VARCHAR(30)
30
0
0
0
0
0
0
0
0
0
1
0
0
S_COUNTY
24
0
-100
0
0
0
0
3
18896
18896
s_state
S_STATE
49
0
CHAR(2)
2
0
0
0
0
0
0
0
0
0
1
0
0
S_STATE
25
0
-100
0
0
0
0
3
18899
18899
s_zip
S_ZIP
49
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
S_ZIP
26
0
-100
0
0
0
0
3
18911
18911
s_country
S_COUNTRY
49
0
VARCHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
S_COUNTRY
27
0
-100
0
0
0
0
3
18897
18897
s_gmt_offset
S_GMT_OFFSET
49
0
DECIMAL(5,2)
5
2
0
0
0
0
0
0
0
0
1
0
0
S_LATITUDE
28
0
-100
0
0
0
0
3
41752
41752
s_tax_precentage
S_TAX_PRECENTAGE
49
0
DECIMAL(5,2)
5
2
0
0
0
0
0
0
0
0
1
0
0
S_TAX_PRECENTAGE
29
0
-100
0
0
0
0
3
22820
22820
inv_date_sk
INV_DATE_SK
50
0
INTEGER
0
0
0
0
0
0
0
1
1
1
1
0
0
D_DATE_SK
1
0
-100
0
0
0
0
3
22952
22952
inv_item_sk
INV_ITEM_SK
50
0
INTEGER
0
0
0
0
0
0
0
1
1
1
1
0
0
I_ITEM_SK
2
0
-100
0
0
0
0
3
24918
24918
inv_warehouse_sk
INV_WAREHOUSE_SK
50
0
INTEGER
0
0
0
0
0
0
0
1
1
1
1
0
0
W_WAREHOUSE_SK
3
0
-100
0
0
0
0
3
55
55
inv_quantity_on_hand
INV_QUANTITY_ON_HAND
inventory level on hand this day for this warehouse for this item\
\
Is there a row here if the item is not stocked by the warehouse? If it is stocked, still need a rowwith a zero Qty on hand.
50
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
INV_QUANTITY
4
0
0
0
0
0
0
3
22949
22949
I_ITEM_SK
I_ITEM_SK
270
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
I_ITEM_SK
1
0
-100
0
0
0
0
3
271
271
I_ITEM_ID
I_ITEM_ID
A unique key internally generated. An ITEM is the lowest level of the item hierarchy. An item would be a distinct saleable item identified in practice by a unique SKU number. Each ITEM_ID has a one-to-one relationship with the ITEM_DESC\\
column.\
\
Primary key column.
How many item_ids are there? Reasonable range for a large enterprise 1-1.5M.\
\
Will it scale with different database sizes? Yes/No, how fast?\
\
Note that this question applies to all other tables in the hierarchy.
270
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
I_ITEM_ID
2
0
0
0
0
0
0
3
22950
22950
I_REC_START_DATE
I_REC_START_DATE_ID
270
0
date
0
0
0
0
0
0
0
0
0
0
1
0
0
I_REC_START_DATE_ID
3
0
-100
0
0
0
0
3
22951
22951
I_REC_END_DATE
I_REC_END_DATE_ID
270
0
date
0
0
0
0
0
0
0
0
0
0
1
0
0
I_REC_END_DATE_ID
4
0
-100
0
0
0
0
3
3668
3668
I_ITEM_DESC
I_ITEM_DESC
Textual item description, unique to Item_ID
270
0
VARCHAR(200)
200
0
0
0
0
0
0
0
0
0
1
0
0
I_ITEM_DESC
5
0
-100
0
0
0
0
3
275
275
I_CURRENT_PRICE
I_CURRENT_PRICE
Current price of the product, slowly changing over time. \
\
Would be nice to make price facts in sales tables close to this number for a given item.
270
0
DECIMAL(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
I_CURR_LPRICE
6
0
0
0
0
0
0
3
42480
42480
I_WHOLESALE_COST
I_WHOLESALE_COST
270
0
DECIMAL(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
I_WHOLESALE_COST
7
0
-100
0
0
0
0
3
277
277
I_BRAND_ID
I_BRAND_ID
Unique id for brands, dependent on item_id and is part of the category hierarchy.\
\
10 items/brand\
\
item ---> brand --->subclass--->class--->subcategory ---> category
270
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
I_BRAND_ID
8
0
0
0
0
0
0
3
278
278
I_BRAND
I_BRAND
Brand discription:\
\
Dawn\
Tide\
Store Brand\
Jolly Green Giant\
Swanson's TV dinners\
\
Dependent on brand-id, but is a unique brand name over all brands.
270
0
CHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
I_BRAND
9
0
0
0
0
0
0
3
281
281
I_CLASS_ID
I_CLASS_ID
generated id for class\
4 subclasses/class\
\
item --->brand --->subclass--->class--->subcategory ---> category
270
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
I_CLASS_ID
10
0
0
0
0
0
0
3
282
282
I_CLASS
I_CLASS
class description (1-1 with class_ id). A unique class description over all classes.
270
0
CHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
I_CLASS
11
0
0
0
0
0
0
3
285
285
I_CATEGORY_ID
I_CATEGORY_ID
generated id for catagory\
4 classes/subcategory\
\
\
\
item ---> brand --->subclass--->class--->subcategory ---> category
270
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
I_CATEGORY_ID
12
0
0
0
0
0
0
3
286
286
I_CATEGORY
I_CATEGORY
A unique category description (over all categories).\
4 subcategories/category\
\
There are about 200 categories in a typical store, maybe 600 in the enterprise\
categories include\
drug, dairy, fresh fruits, household, outdoor furniture,....
270
0
CHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
I_CATEGORY
13
0
0
0
0
0
0
3
287
287
I_MANUFACT_ID
I_MANUFACT_ID
60 brands/manufacturer\
Manufacturer identifier\
\
manufacture is related to item and brand. If an item is in a brand, the manufacture that makes that brand makes also all items in that brand.\
\
\
item ---> brand --->manufacturer
270
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
I_MANUFACT_ID
14
0
0
0
0
0
0
3
288
288
I_MANUFACT
I_MANUFACT
Manufacturer, 1-1 with manufacturer id (unique for all manufactures).\
\
BF Goodrich\
Dixie Beer
270
0
CHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
I_MANUFACT
15
0
0
0
0
0
0
3
289
289
I_SIZE
I_SIZE
1-1 with item_id, can be "null"\
\
example:\
\
ladies 2,4,6,8,10,12,14,16,18,1x,2x,3x\
misses XS,S,M.L,XL, XXL\
girls \
boys\
mens \
\
(shoe sizes) \
1,2,3,4,5,6,7,8,9,10,11,12,13 AAA,AA,A,B,C,D,E\
ladies\
mens\
kids
270
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
I_SIZE
16
0
0
0
0
0
0
3
290
290
I_FORMULATION
I_FORMULATION
1-1 with item\
\
special formulas (depending on the item category, perhaps)\
low fat\
x% fat\
new formula\
low salt\
perfume free\
lead free\
fat free\
non-arrisole\
anti-itch\
anti-snooze\
..
270
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
I_FORMULATION
17
0
0
0
0
0
0
3
291
291
I_COLOR
I_COLOR
1-1 with item\
can be "null" \
\
\
cherry flavor\
lemon flavor\
country fresh
270
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
I_FLAVOR
18
0
0
0
0
0
0
3
292
292
I_UNITS
I_UNITS
1-1 with item\
\
measuring units for items\
oz,lbs,kg,g,\
m,cm,inches, feet, yards, meters\
cc, liters, ml, pints, quarts, qal, 5 gal, 10 gal....\
\
can be "null"
270
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
I_UNITS
19
0
0
0
0
0
0
3
293
293
I_CONTAINER
I_CONTAINER
1-1 with item\
examples:\
\
plastic jar\
plastic bottle no deposit\
plastic bottle deposit\
plastic carton\
glass jar\
glass bottle no deposit\
glass bottle deposit\
tin can\
cardboard box\
cardboard carton\
plastic wrap
270
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
I_CONTAINER
20
0
0
0
0
0
0
3
294
294
I_MANAGER_ID
I_MANAGER_ID
This field is the identifier for the product manager that manages the brand to which this item belong.. (like an employee number for the manager).\
\
One to many, manger to brand. That is, one manager manages one or more multiple brands. \
\
Each item belongs to exactly one brand, and potentially several brands map to one manager.\
\
item ---> brand --->manager_id
Need to decide how many managers there are, and how many brands each manages.
270
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
I_MANAGER_ID
21
0
0
0
0
0
0
3
17963
17963
I_PRODUCT_NAME
I_PRODUCT_NAME
Product name, dependent on product_id column (but is a unique name over all products). Example::\
\
Dawn Dishwashing Liquid 12oz Size
270
0
CHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
I_PRODUCT_NAME
22
0
0
0
0
0
0
3
22819
22819
d_date_sk
D_DATE_SK
308
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
D_DATE_SK
1
0
-100
0
0
0
0
3
309
309
d_date_id
D_DATE_ID
Generated field. \
\
RESERVE ZERO, as zero has special meaning for date_ids found in end_date fields to mean "current"\
\
The meaning of the date depends on the context. For example, when the sales table date field ss_sold_date_id points this row, it refers to the date sold relative to the store where it was sold. When the catalog sales table\\
cs_sold_date_id points to this row, it is the date at the call center when the item was sold, and cs_cust_date_id is the date at the customer location when it was sold. Some dimension tables use this id when identifying a date, such as\\
the season table.\
\
Our calendar is "date grane based calendar" not for example fiscal year calendar. This implies that we have two hierarchies:\
date --> week\
date ---> month ---> quarter ---> year
308
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
D_DATE_ID
2
0
-100
0
0
0
0
3
310
310
d_date
D_DATE
date expressed as a date datatype; see also date_id description
308
0
DATE
0
0
0
0
0
0
0
0
0
0
1
0
0
D_SQL_DATE
3
0
-100
0
0
0
0
3
311
311
d_month_seq
D_MONTH_SEQ
Id unique for this month.\
date ---> month ---> quarter ---> year
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_MONTH
4
0
-100
0
0
0
0
3
312
312
d_week_seq
D_WEEK_SEQ
Number unique for this week\
date --> week
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_WEEK
5
0
-100
0
0
0
0
3
313
313
d_quarter_seq
D_QUARTER_SEQ
Number unique for this quarter\
\
date ---> month ---> quarter ---> year
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_QUARTER
6
0
-100
0
0
0
0
3
314
314
d_year
D_YEAR
Number unique for this year (1999, 2000)\
\
date ---> month ---> quarter ---> year
Domain should be defined.
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_YEAR
7
0
-100
0
0
0
0
3
315
315
d_dow
D_DOW
Day of the Week 1 through 7.\
\
We always assume that Sunday is 1 (we are modeling US only operation).\
\
dependent on week
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_DOW
8
0
-100
0
0
0
0
3
15354
15354
d_moy
D_MOY
Month of the Year 1 through 12.\
\
January is 1.
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_MOY
9
0
-100
0
0
0
0
3
316
316
d_dom
D_DOM
Day of the Month 1 through 31\
dependent on month
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_DOM
10
0
-100
0
0
0
0
3
318
318
d_qoy
D_QOY
Quarter number in the year 1,2,3, or 4\
dependent on quarter. \
There is a quarter starting on January 1st. It is quarter 1.
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_QOY
11
0
-100
0
0
0
0
3
15355
15355
d_fy_year
D_FY_YEAR
Fiscal Year.\
The domain should be derived from the domain of the D_YEAR.
The domain has a dependency on the D_YEAR and it should be resolved.
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_FY_YEAR
12
0
-100
0
0
0
0
3
15356
15356
d_fy_quarter_seq
D_FY_QUARTER_SEQ
Quarter in Fiscal Year.\
Domain (1,2,3,4)
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_FY_QUARTER_SEQ
13
0
-100
0
0
0
0
3
15357
15357
d_fy_week_seq
D_FY_WEEK_SEQ
Week of a fiscal year. Integer 1-53.
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_FY_WEEK_SEQ
14
0
-100
0
0
0
0
3
317
317
d_day_name
D_DAY_NAME
Name of day (SUN, MON, TUE, WED, THU, FRI, SAT)\
dependent on date.
308
0
CHAR(9)
9
0
0
0
0
0
0
0
0
0
1
0
0
D_DAY_NAME
15
0
-100
0
0
0
0
3
319
319
d_quarter_name
D_QUARTER_NAME
Name of the quarter (unique) Q199, Q299, �Q405\
dependent on quarter
'#Qyy' where # is in (1,2,3,4), and yy is derived from D_YEAR.\
This is a calendar quarter. This is NOT a FY quarter.
308
0
CHAR(6)
6
0
0
0
0
0
0
0
0
0
1
0
0
D_QUARTER_NAME
16
0
-100
0
0
0
0
3
320
320
d_holiday
D_HOLIDAY
Flag to indicate if this day is a holiday\
dependent on date.\
'T' and 'F'.
What are the holiday days?
308
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
D_HOLIDAY
17
0
-100
0
0
0
0
3
321
321
d_weekend
D_WEEKEND
Flag to indicate if this is a Saturday or a Sunday, or in the case of a holiday that is MON or FRIDAY.\
\
dependent on date.
Should we consider the "long weekend days" or only the Saturdays and Sundays here. At this moment we count only the Sat and Sun.
308
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
D_WEEKEND
18
0
-100
0
0
0
0
3
322
322
d_following_holiday
D_FOLLOWING_HOLIDAY
Flag the day (or days) after a holiday. There might be more than one "day" after a holiday for certain long weekends (e.g., Thanksgiving), for example.\
\
dependent on date.
308
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
D_FOLLOWING_HOLIDAY
19
0
-100
0
0
0
0
3
323
323
d_first_dom
D_FIRST_DOM
date_id of the first day of the calendar month.\
dependent on date.
Is this only a "calendar month"?\
Why is this an integer?
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_FIRST_DOM
20
0
-100
0
0
0
0
3
324
324
d_last_dom
D_LAST_DOM
date_id of the last day of the calendar month.\
dependent on date.
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_LAST_DOM
21
0
-100
0
0
0
0
3
325
325
d_same_day_ly
D_SAME_DAY_LY
same day last year\
Points to date_id fhat was the date exactly one year ago (for comparison purposes at least).\
dependent on date.
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_SAME_DAY_LY
22
0
-100
0
0
0
0
3
326
326
d_same_day_lq
D_SAME_DAY_LQ
Same day last quarter\
Points to date_id that was the date exactly one quarter ago (for comparison purposes at least).\
dependent on date.
308
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
D_SAME_DAY_LQ
23
0
-100
0
0
0
0
3
327
327
d_current_day
D_CURRENT_DAY
Enumeration:\
'H' -history\
'P' previous\
'C' last complete\
'T' to-date (current)\
'F' future
308
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
D_CURRENT_DAY
24
0
-100
0
0
0
0
3
328
328
d_current_week
D_CURRENT_WEEK
Week Enumeration:\
'H' history\
'P' previous\
'C' last complete\
'T' to-date (current)\
'F' future
308
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
D_CURRENT_WEEK
25
0
-100
0
0
0
0
3
329
329
d_current_month
D_CURRENT_MONTH
Month Enumeration:\
'H' history\
'P' previous\
'C' last complete\
'T' to-date (current)\
'F' future
308
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
D_CURRENT_MONTH
26
0
-100
0
0
0
0
3
330
330
d_current_quarter
D_CURRENT_QUARTER
Quarter Enumeration:\
'H' history\
'P' previous\
'C' last complete\
'T' to-date (current)\
'F' future
308
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
D_CURRENT_QUARTER
27
0
-100
0
0
0
0
3
331
331
d_current_year
D_CURRENT_YEAR
Year Enumeration:\
'H' history\
'P' previous\
'C' last complete\
'T' to-date (current)\
'F' future
308
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
D_CURRENT_YEAR
28
0
-100
0
0
0
0
3
22898
22898
cr_returned_date_sk
CR_RETURNED_DATE_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_D_DATE_SK
1
0
-100
0
0
0
0
3
22747
22747
cr_returned_time_sk
CR_RETURNED_TIME_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
T_TIME_SK
2
0
-100
0
0
0
0
3
22955
22955
cr_item_sk
CR_ITEM_SK
353
0
INTEGER
0
0
0
0
0
0
0
1
1
1
1
0
0
I_ITEM_SK
3
0
-100
0
0
0
0
3
22679
22679
cr_refunded_customer_sk
CR_REFUNDED_CUSTOMER_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
C_C_CUSTOMER_SK
4
0
-100
0
0
0
0
3
23928
23928
cr_refunded_cdemo_sk
CR_REFUNDED_CDEMO_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CD_CD_DEMO_SK
5
0
-100
0
0
0
0
3
37388
37388
cr_refunded_hdemo_sk
CR_REFUNDED_HDEMO_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CR_REFUNDED_HDEMO_SK
6
0
-100
0
0
0
0
3
37399
37399
cr_refunded_addr_sk
CR_REFUNDED_ADDR_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CR_REFUNDED_ADDR_SK
7
0
-100
0
0
0
0
3
22673
22673
cr_returning_customer_sk
CR_RETURNING_CUSTOMER_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
C_CUSTOMER_SK
8
0
-100
0
0
0
0
3
23925
23925
cr_returning_cdemo_sk
CR_RETURNING_CDEMO_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CD_DEMO_SK
9
0
-100
0
0
0
0
3
31742
31742
cr_returning_hdemo_sk
CR_RETURNING_HDEMO_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CR_RETURNING_HDEMO_SK
10
0
-100
0
0
0
0
3
23894
23894
cr_returning_addr_sk
CR_RETURNING_ADDR_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CA_CA_ADDRESS_SK
11
0
-100
0
0
0
0
3
24947
24947
cr_call_center_sk
CR_CALL_CENTER_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CC_CALL_CENTER_SK
12
0
-100
0
0
0
0
3
25885
25885
cr_catalog_page_sk
CR_CATALOG_PAGE_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CP_CATALOG_PAGE_SK
13
0
-100
0
0
0
0
3
24934
24934
cr_ship_mode_sk
CR_SHIP_MODE_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SM_SHIP_MODE_SK
14
0
-100
0
0
0
0
3
24921
24921
cr_warehouse_sk
CR_WAREHOUSE_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
W_WAREHOUSE_SK
15
0
-100
0
0
0
0
3
24908
24908
cr_reason_sk
CR_REASON_SK
353
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
R_REASON_SK
16
0
-100
0
0
0
0
3
1191
1191
cr_order_number
CR_ORDER_NUMBER
353
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
CR_ORDER
17
0
-100
0
0
0
0
3
354
354
cr_return_quantity
CR_RETURN_QUANTITY
353
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
R_QTY_RETURNED
18
0
0
0
0
0
0
3
355
355
cr_return_amount
CR_RETURN_AMOUNT
353
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
R_RETURNED_AMT
19
0
0
0
0
0
0
3
362
362
cr_return_tax
CR_RETURN_TAX
353
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
R_EXT_TAX
20
0
0
0
0
0
0
3
3655
3655
cr_return_amt_inc_tax
CR_RETURN_AMT_INC_TAX
353
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CR_RETURN_AMT_INC_TAX
21
0
-100
0
0
0
0
3
357
357
cr_fee
CR_FEE
353
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
R_RETURN_FEE
22
0
0
0
0
0
0
3
358
358
cr_return_ship_cost
CR_RETURN_SHIP_COST
353
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
R_SHIP_COST
23
0
0
0
0
0
0
3
359
359
cr_refunded_cash
CR_CASH
353
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
R_REFUND_AMT
24
0
0
0
0
0
0
3
360
360
cr_reversed_charge
CR_REVERSED_CHARGE
353
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
R_CC_AMT
25
0
0
0
0
0
0
3
361
361
cr_store_credit
CR_STORE_CREDIT
353
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
R_SCREDIT_AMT
26
0
0
0
0
0
0
3
3656
3656
cr_net_loss
CR_NET_LOSS
353
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CR_NET_LOSS
27
0
-100
0
0
0
0
3
23871
23871
p_promo_sk
P_PROMO_SK
974
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
P_PROMO_SK
1
0
-100
0
0
0
0
3
975
975
p_promo_id
P_PROMO_ID
This table is a placeholder currently. More work has to be done for promotions.
974
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
P_ID
2
0
-100
0
0
0
0
3
22826
22826
p_start_date_sk
P_START_DATE_SK
974
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_DATE_SK
3
0
-100
0
0
0
0
3
22829
22829
p_end_date_sk
P_END_DATE_SK
974
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_D_DATE_SK
4
0
-100
0
0
0
0
3
41754
41754
p_item_sk
P_ITEM_SK
974
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
P_ITEM_SK
5
0
-100
0
0
0
0
3
7689
7689
p_cost
P_COST
Cost to mount this promotion. Q: shold this be projected with actuals to follow or should both be included?
974
0
DECIMAL(15,2)
15
2
0
0
0
0
0
0
0
0
1
0
0
P_COST
6
0
-100
0
0
0
0
3
7690
7690
p_response_target
P_RESPONSE_TARGET
Equivalent to basket count; how many responses do we want/expect from this promotion. Q: Do we need to segregate by type?
974
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
P_RESPONSE_TARGET
7
0
-100
0
0
0
0
3
976
976
p_promo_name
P_PROMO_NAME
974
0
CHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
P_NAME
8
0
-100
0
0
0
0
3
7677
7677
p_channel_dmail
P_CHANNEL_DMAIL
flag; set to Y if direct mail used in this promtion, N otherwise
974
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
P_CHANNEL_DMAIL
9
0
-100
0
0
0
0
3
7678
7678
p_channel_email
P_CHANNEL_EMAIL
flag; set to Y if email used in this promtion, N otherwise
974
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
P_CHANNEL_EMAIL
10
0
-100
0
0
0
0
3
7679
7679
p_channel_catalog
P_CHANNEL_CATALOG
flag; set to Y if a catalog is used in this promtion, N otherwise
974
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
P_CHANNEL_CATALOG
11
0
-100
0
0
0
0
3
7681
7681
p_channel_tv
P_CHANNEL_TV
flag; set to Y if TV is used in this promtion, N otherwise
974
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
P_CHANNEL_TV
12
0
-100
0
0
0
0
3
7680
7680
p_channel_radio
P_CHANNEL_RADIO
flag; set to Y if radio is used in this promtion, N otherwise
974
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
P_CHANNEL_RADIO
13
0
-100
0
0
0
0
3
7682
7682
p_channel_press
P_CHANNEL_PRESS
flag; set to Y if print media (newspapers/magazines) used in this promtion, N otherwise
974
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
P_CHANNEL_PRESS
14
0
-100
0
0
0
0
3
7683
7683
p_channel_event
P_CHANNEL_EVENT
flag; set to Y if direct mail used in this promtion, N otherwise
974
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
P_CHANNEL_EVENT
15
0
-100
0
0
0
0
3
7684
7684
p_channel_demo
P_CHANNEL_DEMO
flag; set to Y if direct mail used in this promtion, N otherwise
974
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
P_CHANNEL_DEMO
16
0
-100
0
0
0
0
3
7726
7726
p_channel_details
P_CHANNEL_DETAILS
details of the channel set used. Might include name of paper, name of channel or program, etc.
974
0
VARCHAR(100)
100
0
0
0
0
0
0
0
0
0
1
0
0
P_CHANNEL_DETAILS
17
0
-100
0
0
0
0
3
9845
9845
p_purpose
P_PURPOSE
Goal of the promotion (customer retention, product introduction, etc.)
974
0
CHAR(15)
15
0
0
0
0
0
0
0
0
0
1
0
0
P_PURPOSE
18
0
-100
0
0
0
0
3
9846
9846
p_discount_active
P_DISCOUNT_ACTIVE
Set to Y if the promotion includes a price reduction (i.e, sale_price < list_price); N otherwise
974
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
P_DISCOUNT_ACTIVE
19
0
-100
0
0
0
0
3
24953
24953
cp_catalog_page_sk
CP_CATALOG_PAGE_SK
990
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
CP_CATALOG_PAGE_SK
1
0
-100
0
0
0
0
3
991
991
cp_catalog_page_id
CP_CATALOG_PAGE_ID
990
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
CP_ID
2
0
-100
0
0
0
0
3
22832
22832
cp_start_date_sk
CP_START_DATE_SK
990
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_DATE_SK
3
0
-100
0
0
0
0
3
22835
22835
cp_end_date_sk
CP_END_DATE_SK
990
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_D_DATE_SK
4
0
-100
0
0
0
0
3
992
992
cp_department
CP_DEPARTMENT
990
0
VARCHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
CP_DEPARTMENT
5
0
-100
0
0
0
0
3
993
993
cp_catalog_number
CP_CATALOG_NUMBER
990
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
CP_CATALOG
6
0
-100
0
0
0
0
3
21028
21028
cp_catalog_page_number
CP_CATALOG_PAGE_NUMBER
990
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
CP_CATALOG_PAGE_NBR
7
0
-100
0
0
0
0
3
994
994
cp_description
CP_DESCRIPTION
990
0
VARCHAR(100)
100
0
0
0
0
0
0
0
0
0
1
0
0
CP_DESCRIPTION
8
0
-100
0
0
0
0
3
995
995
cp_type
CP_TYPE
990
0
VARCHAR(100)
100
0
0
0
0
0
0
0
0
0
1
0
0
CP_TYPE
9
0
-100
0
0
0
0
3
27658
27658
wp_web_page_sk
WP_WEB_PAGE_SK
1005
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
WP_WEB_PAGE_SK
1
0
-100
0
0
0
0
3
1006
1006
wp_web_page_id
WP_WEB_PAGE_ID
Primary key; unique integer for each collection of content
1005
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
WP_ID
2
0
-100
0
0
0
0
3
27659
27659
wp_rec_start_date
WP_REC_START_DATE_ID
1005
0
date
0
0
0
0
0
0
0
0
0
0
1
0
0
WP_REC_START_DATE_ID
3
0
-100
0
0
0
0
3
27660
27660
wp_rec_end_date
WP_REC_END_DATE_ID
1005
0
date
0
0
0
0
0
0
0
0
0
0
1
0
0
WP_REC_END_DATE_ID
4
0
-100
0
0
0
0
3
22841
22841
wp_creation_date_sk
WP_CREATION_DATE_SK
1005
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_D_DATE_SK
5
0
-100
0
0
0
0
3
22838
22838
wp_access_date_sk
WP_ACCESS_DATE_SK
1005
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_DATE_SK
6
0
-100
0
0
0
0
3
16401
16401
wp_autogen_flag
WP_AUTOGEN_FLAG
Y if page was built by server (and hence can expire)
1005
0
CHAR(1)
1
0
0
0
0
0
0
0
0
0
1
0
0
WP_AUTOGEN_FLAG
7
0
-100
0
0
0
0
3
35468
35468
wp_customer_sk
WP_CUSTOMER_SK
1005
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
WP_CUSTOMER_SK
8
0
-100
0
0
0
0
3
1007
1007
wp_url
WP_URL
URL for this page
1005
0
VARCHAR(100)
100
0
0
0
0
0
0
0
0
0
1
0
0
WP_URL
9
0
-100
0
0
0
0
3
1009
1009
wp_type
WP_TYPE
One of "welcome", "order", "info", etc. Want to separate pages that have a specific purpose (customer-targeted welcome, market basket/sale) from those that don't
1005
0
CHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
WP_TYPE
10
0
-100
0
0
0
0
3
8753
8753
wp_char_count
WP_CHAR_COUNT
1005
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
WP_CHAR_COUNT
11
0
-100
0
0
0
0
3
8754
8754
wp_link_count
WP_LINK_COUNT
1005
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
WP_LINK_COUNT
12
0
-100
0
0
0
0
3
8755
8755
wp_image_count
WP_IMAGE_COUNT
1005
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
WP_IMAGE_COUNT
13
0
-100
0
0
0
0
3
8756
8756
wp_max_ad_count
WP_MAX_AD_COUNT
1005
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
WP_MAX_AD_COUNT
14
0
-100
0
0
0
0
3
24917
24917
w_warehouse_sk
W_WAREHOUSE_SK
1022
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
W_WAREHOUSE_SK
1
0
-100
0
0
0
0
3
1023
1023
w_warehouse_id
W_WAREHOUSE_ID
1022
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
W_ID
2
0
-100
0
0
0
0
3
1024
1024
w_warehouse_name
W_WAREHOUSE_NAME
1022
0
VARCHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
W_DESC
3
0
-100
0
0
0
0
3
1025
1025
w_warehouse_sq_ft
W_SWAREHOUSE_SQ_FT
1022
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
W_SQ_FT
4
0
-100
0
0
0
0
3
18900
18900
w_street_number
W_STREET_NUMBER
1022
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
W_STREET_NUM
5
0
-100
0
0
0
0
3
18902
18902
w_street_name
W_STREET_NAME
1022
0
VARCHAR(60)
60
0
0
0
0
0
0
0
0
0
1
0
0
W_STREET_NAME
6
0
-100
0
0
0
0
3
18903
18903
w_street_type
W_STREET_TYPE
1022
0
CHAR(15)
15
0
0
0
0
0
0
0
0
0
1
0
0
W_STREET_TYPE
7
0
-100
0
0
0
0
3
18901
18901
w_suite_number
W_SUITE_NUMBER
1022
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
W_SUITE_NUM
8
0
-100
0
0
0
0
3
18904
18904
w_city
W_CITY
1022
0
VARCHAR(60)
60
0
0
0
0
0
0
0
0
0
1
0
0
W_CITY
9
0
-100
0
0
0
0
3
18905
18905
w_county
W_COUNTY
1022
0
VARCHAR(30)
30
0
0
0
0
0
0
0
0
0
1
0
0
W_COUNTY
10
0
-100
0
0
0
0
3
18906
18906
w_state
W_STATE
1022
0
CHAR(2)
2
0
0
0
0
0
0
0
0
0
1
0
0
W_STATE
11
0
-100
0
0
0
0
3
18910
18910
w_zip
W_ZIP
1022
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
W_ZIP
12
0
-100
0
0
0
0
3
18907
18907
w_country
W_COUNTRY
1022
0
VARCHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
W_COUNTRY
13
0
-100
0
0
0
0
3
33591
33591
w_gmt_offset
W_GMT_OFFSET
1022
0
DECIMAL(5,2)
5
2
0
0
0
0
0
0
0
0
1
0
0
W_GMT_OFFSET
14
0
-100
0
0
0
0
3
24933
24933
sm_ship_mode_sk
SM_SHIP_MODE_SK
1031
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
SM_SHIP_MODE_SK
1
0
-100
0
0
0
0
3
1032
1032
sm_ship_mode_id
SM_SHIP_MODE_ID
1031
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
SM_ID
2
0
-100
0
0
0
0
3
1033
1033
sm_type
SM_TYPE
1031
0
CHAR(30)
30
0
0
0
0
0
0
0
0
0
1
0
0
SM_TYPE
3
0
-100
0
0
0
0
3
1034
1034
sm_code
SM_CODE
1031
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
SH_CODE
4
0
-100
0
0
0
0
3
1036
1036
sm_carrier
SM_CARRIER
1031
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
SM_CARRIER
5
0
-100
0
0
0
0
3
1035
1035
sm_contract
SM_CONTRACT
1031
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
SM_CONTRACT
6
0
-100
0
0
0
0
3
24946
24946
cc_call_center_sk
CC_CALL_CENTER_SK
1045
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
CC_CALL_CENTER_SK
1
0
-100
0
0
0
0
3
1046
1046
cc_call_center_id
CC_CALL_CENTER_ID
1045
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
CC_ID
2
0
-100
0
0
0
0
3
24954
24954
cc_rec_start_date
CC_REC_START_DATE_ID
1045
0
date
0
0
0
0
0
0
0
0
0
0
1
0
0
CC_REC_START_DATE_ID
3
0
-100
0
0
0
0
3
24955
24955
cc_rec_end_date
CC_REC_END_DATE_ID
1045
0
date
0
0
0
0
0
0
0
0
0
0
1
0
0
CC_REC_END_DATE_ID
4
0
-100
0
0
0
0
3
22847
22847
cc_closed_date_sk
CC_CLOSED_DATE_SK
1045
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_DATE_SK
5
0
-100
0
0
0
0
3
22850
22850
cc_open_date_sk
CC_OPEN_DATE_SK
1045
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_D_DATE_SK
6
0
-100
0
0
0
0
3
1047
1047
cc_name
CC_NAME
1045
0
VARCHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
CC_NAME
7
0
-100
0
0
0
0
3
1048
1048
cc_class
CC_CLASS
1045
0
VARCHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
CC_CLASS
8
0
-100
0
0
0
0
3
1050
1050
cc_employees
CC_EMPLOYEES
1045
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
CC_EMPLOYEES
9
0
-100
0
0
0
0
3
1053
1053
cc_sq_ft
CC_SQ_FT
1045
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
CC_SQ_FT
10
0
-100
0
0
0
0
3
1054
1054
cc_hours
CC_HOURS
1045
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
CC_HOURS
11
0
-100
0
0
0
0
3
1055
1055
cc_manager
CC_MANAGER
1045
0
VARCHAR(40)
40
0
0
0
0
0
0
0
0
0
1
0
0
CC_MGR
12
0
-100
0
0
0
0
3
1056
1056
cc_mkt_id
CC_MKT
1045
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
CC_MKT
13
0
-100
0
0
0
0
3
1057
1057
cc_mkt_class
CC_MKT_CLASS
1045
0
CHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
CC_MKT_CLASS
14
0
-100
0
0
0
0
3
1058
1058
cc_mkt_desc
CC_MKT_DESC
1045
0
VARCHAR(100)
100
0
0
0
0
0
0
0
0
0
1
0
0
CC_MKT_DESC
15
0
-100
0
0
0
0
3
1059
1059
cc_market_manager
CC_MARKET_MANAGER
1045
0
VARCHAR(40)
40
0
0
0
0
0
0
0
0
0
1
0
0
CC_MKT_MGR
16
0
-100
0
0
0
0
3
21841
21841
cc_division
CC_DIVISION
1045
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
CC_DIVISION
17
0
-100
0
0
0
0
3
21842
21842
cc_division_name
CC_DIVISION_NAME
1045
0
VARCHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
CC_DIVISION_NAME
18
0
-100
0
0
0
0
3
1060
1060
cc_company
CC_COMPANY
1045
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
CC_COMPANY
19
0
-100
0
0
0
0
3
1061
1061
cc_company_name
CC_COMPANY_NAME
1045
0
CHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
CC_COMPANY_NAME
20
0
-100
0
0
0
0
3
21845
21845
cc_street_number
CC_STREET_NUMBER
1045
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
CC_SUITE_NUM
21
0
-100
0
0
0
0
3
21847
21847
cc_street_name
CC_STREET_NAME
1045
0
VARCHAR(60)
60
0
0
0
0
0
0
0
0
0
1
0
0
CC_STREET_NAME
22
0
-100
0
0
0
0
3
21848
21848
cc_street_type
CC_STREET_TYPE
1045
0
CHAR(15)
15
0
0
0
0
0
0
0
0
0
1
0
0
CC_STREET_TYPE
23
0
-100
0
0
0
0
3
21846
21846
cc_suite_number
CC_SUITE_NUMBER
1045
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
CC_STREET_NUM
24
0
-100
0
0
0
0
3
21849
21849
cc_city
CC_CITY
1045
0
VARCHAR(60)
60
0
0
0
0
0
0
0
0
0
1
0
0
CC_CITY
25
0
-100
0
0
0
0
3
21850
21850
cc_county
CC_COUNTY
1045
0
VARCHAR(30)
30
0
0
0
0
0
0
0
0
0
1
0
0
CC_COUNTY
26
0
-100
0
0
0
0
3
21851
21851
cc_state
CC_STATE
1045
0
CHAR(2)
2
0
0
0
0
0
0
0
0
0
1
0
0
CC_STATE
27
0
-100
0
0
0
0
3
21843
21843
cc_zip
CC_ZIP
1045
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
CC_ZIP
28
0
-100
0
0
0
0
3
21852
21852
cc_country
CC_COUNTRY
1045
0
VARCHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
CC_COUNTRY
29
0
-100
0
0
0
0
3
33592
33592
cc_gmt_offset
CC_GMT_OFFSET
1045
0
DECIMAL(5,2)
5
2
0
0
0
0
0
0
0
0
1
0
0
CC_GMT_OFFSET
30
0
-100
0
0
0
0
3
42481
42481
cc_tax_percentage
CC_TAX_PERCENTAGE
1045
0
DECIMAL(5,2)
5
2
0
0
0
0
0
0
0
0
1
0
0
CC_TAX_PERCENTAGE
31
0
-100
0
0
0
0
3
27651
27651
web_site_sk
WEB_SITE_SK
1076
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
WEB_SITE_SK
1
0
-100
0
0
0
0
3
1077
1077
web_site_id
WEB_SITE_ID
1076
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
WS_ID
2
0
-100
0
0
0
0
3
27649
27649
web_rec_start_date
WEB_REC_START_DATE_ID
1076
0
date
0
0
0
0
0
0
0
0
0
0
1
0
0
WEB_REC_START_DATE_ID
3
0
-100
0
0
0
0
3
27650
27650
web_rec_end_date
WEB_REC_END_DATE_ID
1076
0
date
0
0
0
0
0
0
0
0
0
0
1
0
0
WEB_REC_END_DATE_ID
4
0
-100
0
0
0
0
3
1078
1078
web_name
WEB_NAME
1076
0
VARCHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
WS_NAME
5
0
-100
0
0
0
0
3
22853
22853
web_open_date_sk
WEB_OPEN_DATE_SK
1076
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_DATE_SK
6
0
-100
0
0
0
0
3
22856
22856
web_close_date_sk
WEB_CLOSE_DATE_SK
1076
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_D_DATE_SK
7
0
-100
0
0
0
0
3
1079
1079
web_class
WEB_CLASS
1076
0
VARCHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
WS_CLASS
8
0
-100
0
0
0
0
3
1083
1083
web_manager
WEB_MANAGER
1076
0
VARCHAR(40)
40
0
0
0
0
0
0
0
0
0
1
0
0
WS_MGR
9
0
-100
0
0
0
0
3
1084
1084
web_mkt_id
WEB_MKT
1076
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
WS_MKT
10
0
-100
0
0
0
0
3
1085
1085
web_mkt_class
WEB_MKT_CLASS
1076
0
VARCHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
WS_MKT_CLASS
11
0
-100
0
0
0
0
3
1086
1086
web_mkt_desc
WEB_MKT_DESC
1076
0
VARCHAR(100)
100
0
0
0
0
0
0
0
0
0
1
0
0
WS_MKT_DESC
12
0
-100
0
0
0
0
3
1087
1087
web_market_manager
WEB_MARKET_MANAGER
1076
0
VARCHAR(40)
40
0
0
0
0
0
0
0
0
0
1
0
0
MS_MKT_MGR
13
0
-100
0
0
0
0
3
1088
1088
web_company_id
WEB_COMPANY
1076
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
WS_COMPANY
14
0
-100
0
0
0
0
3
1089
1089
web_company_name
WEB_COMPANY_NAME
1076
0
CHAR(50)
50
0
0
0
0
0
0
0
0
0
1
0
0
WS_COMPANY_NAME
15
0
-100
0
0
0
0
3
18924
18924
web_street_number
WEB_STREET_NUMBER
1076
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
WEB_STREET_NUM
16
0
-100
0
0
0
0
3
18926
18926
web_street_name
WEB_STREET_NAME
1076
0
VARCHAR(60)
60
0
0
0
0
0
0
0
0
0
1
0
0
WEB_STREET_NAME
17
0
-100
0
0
0
0
3
18927
18927
web_street_type
WEB_STREET_TYPE
1076
0
CHAR(15)
15
0
0
0
0
0
0
0
0
0
1
0
0
WEB_STREET_TYPE
18
0
-100
0
0
0
0
3
40635
40635
web_suite_number
WEB_SUITE_NUMBER
1076
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
WEB_SUITE_NUMBER
19
0
-100
0
0
0
0
3
18928
18928
web_city
WEB_CITY
1076
0
VARCHAR(60)
60
0
0
0
0
0
0
0
0
0
1
0
0
WEB_CITY
20
0
-100
0
0
0
0
3
18929
18929
web_county
WEB_COUNTY
1076
0
VARCHAR(30)
30
0
0
0
0
0
0
0
0
0
1
0
0
WEB_COUNTY
21
0
-100
0
0
0
0
3
18930
18930
web_state
WEB_STATE
1076
0
CHAR(2)
2
0
0
0
0
0
0
0
0
0
1
0
0
WEB_STATE
22
0
-100
0
0
0
0
3
18934
18934
web_zip
WEB_ZIP
1076
0
CHAR(10)
10
0
0
0
0
0
0
0
0
0
1
0
0
WEB_ZIP
23
0
-100
0
0
0
0
3
18931
18931
web_country
WEB_COUNTRY
1076
0
VARCHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
WEB_COUNTRY
24
0
-100
0
0
0
0
3
33593
33593
web_gmt_offset
WEB_GMT_OFFSET
1076
0
DECIMAL(5,2)
5
2
0
0
0
0
0
0
0
0
1
0
0
WEB_GMT_OFFSET
25
0
-100
0
0
0
0
3
41751
41751
web_tax_percentage
WEB_TAX_PERCENTAGE
1076
0
DECIMAL(5,2)
5
2
0
0
0
0
0
0
0
0
1
0
0
WEB_TAX_PERCENTAGE
26
0
-100
0
0
0
0
3
22746
22746
t_time_sk
T_TIME_SK
1118
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
T_TIME_SK
1
0
-100
0
0
0
0
3
1119
1119
t_time_id
T_TIME_ID
0 to 1439 \
\
minutes in a day\
time ( minute) ---> hour --> sub_shift --> shift \
time (minute) ---> hour --> meal_time\
time (minute) ---> hour -->am_pm
1118
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
T_ID
2
0
-100
0
0
0
0
3
21029
21029
t_time
T_TIME
1118
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
T_TIME
3
0
-100
0
0
0
0
3
1120
1120
t_hour
T_HOUR
0 to 23\
hour in the day\
\
time ( minute) ---> hour --> sub_shift --> shift \
time (minute) ---> hour --> meal_time\
time (minute) ---> hour -->am_pm
1118
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
T_HOUR
4
0
-100
0
0
0
0
3
1121
1121
t_minute
T_MINUTE
\
minute in the hour (0-59)\
dependent on time
1118
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
T_MINUTE
5
0
-100
0
0
0
0
3
7675
7675
t_second
T_SECOND
1118
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
T_SECOND
6
0
-100
0
0
0
0
3
1122
1122
t_am_pm
T_AM_PM
AM or PM\
\
time (minute) ---> hour -->am_pm
1118
0
CHAR(2)
2
0
0
0
0
0
0
0
0
0
1
0
0
T_AM_PM
7
0
-100
0
0
0
0
3
1123
1123
t_shift
T_SHIFT
morning, afternoon, evening, night\
time ( minute) ---> hour --> sub_shift --> shift
1118
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
T_SHIFT
8
0
-100
0
0
0
0
3
1124
1124
t_sub_shift
T_SUB_SHIFT
early, mid, late\
time ( minute) ---> hour --> sub_shift --> shift
1118
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
T_SUB_SHIFT
9
0
-100
0
0
0
0
3
1125
1125
t_meal_time
T_MEAL
Breakfast time, lunch time, dinner time, none\
\
time (minute) ---> hour --> meal_time
1118
0
CHAR(20)
20
0
0
0
0
0
0
0
0
0
1
0
0
T_MEAL
10
0
-100
0
0
0
0
3
24907
24907
r_reason_sk
R_REASON_SK
1127
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
R_REASON_SK
1
0
-100
0
0
0
0
3
1128
1128
r_reason_id
R_REASON_ID
generated key, 0 to (approximately) 30
1127
0
CHAR(16)
16
0
0
0
0
0
0
0
0
1
1
0
0
R_ID
2
0
-100
0
0
0
0
3
1129
1129
r_reason_desc
R_REASON_DESC
reason for return:\
wrong color\
wrong item\
wrong size\
wrong style\
damaged\
changed mind
1127
0
CHAR(100)
100
0
0
0
0
0
0
0
0
0
1
0
0
R_DESC
3
0
-100
0
0
0
0
3
22937
22937
sr_returned_date_sk
SR_RETURNED_DATE_SK
1192
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D3_D_DATE_SK
1
0
-100
0
0
0
0
3
22753
22753
sr_return_time_sk
SR_RETURN_TIME_SK
1192
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
T_TIME_SK
2
0
-100
0
0
0
0
3
22958
22958
sr_item_sk
SR_ITEM_SK
1192
0
INTEGER
0
0
0
0
0
0
0
1
1
1
1
0
0
I_ITEM_SK
3
0
-100
0
0
0
0
3
22685
22685
sr_customer_sk
SR_CUSTOMER_SK
1192
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
C_CUSTOMER_SK
4
0
-100
0
0
0
0
3
23931
23931
sr_cdemo_sk
SR_CDEMO_SK
1192
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SR_DEMO_SK
5
0
-100
0
0
0
0
3
31056
31056
sr_hdemo_sk
SR_HDEMO_SK
1192
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SR_HDEMO_SK
6
0
-100
0
0
0
0
3
23897
23897
sr_addr_sk
SR_ADDR_SK
1192
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SR_ADDR_SK
7
0
-100
0
0
0
0
3
22740
22740
sr_store_sk
SR_STORE_SK
1192
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
S_STORE_SK
8
0
-100
0
0
0
0
3
24911
24911
sr_reason_sk
SR_REASON_SK
1192
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SR_REASON_SK
9
0
-100
0
0
0
0
3
1259
1259
sr_ticket_number
SR_TICKET_NUMBER
1192
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
SR_TICKET
10
0
-100
0
0
0
0
3
1210
1210
sr_return_quantity
SR_RETURNED_QUANTITY
1192
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
SR_QUANTITY
11
0
0
0
0
0
0
3
1211
1211
sr_return_amt
SR_RETURN_AMT
1192
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SR_AMOUNT
12
0
0
0
0
0
0
3
1217
1217
sr_return_tax
SR_RETURN_TAX
1192
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SR_EXP_TAX
13
0
0
0
0
0
0
3
3647
3647
sr_return_amt_inc_tax
SR_RETURN_AMT_INC_TAX
1192
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SR_RETURN_AMT_INC_TAX
14
0
-100
0
0
0
0
3
1212
1212
sr_fee
SR_FEE
1192
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SR_FEE
15
0
0
0
0
0
0
3
3648
3648
sr_return_ship_cost
SR_RETURN_SHIP_COST
1192
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SR_RETURN_SHIP_COST
16
0
-100
0
0
0
0
3
1214
1214
sr_refunded_cash
SR_REFUNDED_CASH
1192
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SR_CASH
17
0
0
0
0
0
0
3
1215
1215
sr_reversed_charge
SR_REVERSED_CHARGE
1192
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SR_CREDIT_CARD
18
0
0
0
0
0
0
3
1216
1216
sr_store_credit
SR_STORE_CREDIT
1192
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SR_STORE_CREDIT
19
0
0
0
0
0
0
3
3649
3649
sr_net_loss
SR_NET_LOSS
1192
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SR_NET_LOSS
20
0
-100
0
0
0
0
3
22874
22874
wr_returned_date_sk
WR_RETURNED_DATE_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_D_DATE_SK
1
0
-100
0
0
0
0
3
22798
22798
wr_returned_time_sk
WR_RETURNED_TIME_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
T3_T_TIME_SK
2
0
-100
0
0
0
0
3
22961
22961
wr_item_sk
WR_ITEM_SK
1260
0
INTEGER
0
0
0
0
0
0
0
1
1
1
1
0
0
I_ITEM_SK
3
0
-100
0
0
0
0
3
22697
22697
wr_refunded_customer_sk
WR_REFUNDED_CUSTOMER_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
C_C_CUSTOMER_SK
4
0
-100
0
0
0
0
3
34351
34351
wr_refunded_cdemo_sk
WR_REFUNDED_CDEMO_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
WR_REFUNDED_CUSTOMER_D__SK
5
0
-100
0
0
0
0
3
23937
23937
wr_refunded_hdemo_sk
WR_REFUNDED_HDEMO_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CD_CD_DEMO_SK
6
0
-100
0
0
0
0
3
23900
23900
wr_refunded_addr_sk
WR_REFUNDED_ADDR_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CA_ADDRESS_SK
7
0
-100
0
0
0
0
3
22691
22691
wr_returning_customer_sk
WR_RETURNING_CUSTOMER_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
C_CUSTOMER_SK
8
0
-100
0
0
0
0
3
34352
34352
wr_returning_cdemo_sk
WR_RETURNING_CDEMO_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
WR_RETURNING_CUSTOMER_D_SK
9
0
-100
0
0
0
0
3
23934
23934
wr_returning_hdemo_sk
WR_RETURNING_HDEMO_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CD_DEMO_SK
10
0
-100
0
0
0
0
3
23903
23903
wr_returning_addr_sk
WR_RETURNING_ADDR_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CA_CA_ADDRESS_SK
11
0
-100
0
0
0
0
3
28441
28441
wr_web_page_sk
WR_WEB_PAGE_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
WP_WEB_PAGE_SK
12
0
-100
0
0
0
0
3
24914
24914
wr_reason_sk
WR_REASON_SK
1260
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
R_REASON_SK
13
0
-100
0
0
0
0
3
1277
1277
wr_order_number
WR_ORDER_NUMBER
1260
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
CR_ORDER
14
0
-100
0
0
0
0
3
1278
1278
wr_return_quantity
WR_RETURN_QUANTITY
1260
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
CR_QUANTITY
15
0
0
0
0
0
0
3
1279
1279
wr_return_amt
WR_RETURN_AMT
1260
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CR_AMOUNT
16
0
0
0
0
0
0
3
1285
1285
wr_return_tax
WR_RETURN_TAX
1260
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CR_EXP_TAX
17
0
0
0
0
0
0
3
3666
3666
wr_return_amt_inc_tax
WR_RETURN_AMT_INC_TAX
1260
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WR_RETURN_AMT_INC_TAX
18
0
-100
0
0
0
0
3
1280
1280
wr_fee
WR_FEE
1260
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CR_FEE
19
0
0
0
0
0
0
3
1281
1281
wr_return_ship_cost
WR_RETURN_SHIP_COST
1260
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CR_SHIP_COST
20
0
0
0
0
0
0
3
1282
1282
wr_refunded_cash
WR_REFUNDED_CASH
1260
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CR_CAST
21
0
0
0
0
0
0
3
1283
1283
wr_reversed_charge
WR_REVERSED_CHARGE
1260
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CR_CREDIT_CARD
22
0
0
0
0
0
0
3
1284
1284
wr_account_credit
WR_ACCOUNT_CREDIT
1260
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CR_STORE_CREDIT
23
0
0
0
0
0
0
3
3667
3667
wr_net_loss
WR_NET_LOSS
1260
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WR_NET_LOSS
24
0
-100
0
0
0
0
3
22913
22913
ws_sold_date_sk
WS_SOLD_DATE_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D3_D_DATE_SK
1
0
-100
0
0
0
0
3
22777
22777
ws_sold_time_sk
WS_SOLD_TIME_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
T2_T_TIME_SK
2
0
-100
0
0
0
0
3
22880
22880
ws_ship_date_sk
WS_SHIP_DATE_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_DATE_SK
3
0
-100
0
0
0
0
3
22964
22964
ws_item_sk
WS_ITEM_SK
1351
0
INTEGER
0
0
0
0
0
0
0
1
1
1
1
0
0
I_ITEM_SK
4
0
-100
0
0
0
0
3
22703
22703
ws_bill_customer_sk
WS_BILL_CUSTOMER_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
C_CUSTOMER_SK
5
0
-100
0
0
0
0
3
34349
34349
ws_bill_cdemo_sk
WS_BILL_CDEMO_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
WS_BILL_CUSTOMER_D_SK
6
0
-100
0
0
0
0
3
23940
23940
ws_bill_hdemo_sk
WS_BILL_HDEMO_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CD_DEMO_SK
7
0
-100
0
0
0
0
3
23906
23906
ws_bill_addr_sk
WS_BILL_ADDR_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CA_ADDRESS_SK
8
0
-100
0
0
0
0
3
22709
22709
ws_ship_customer_sk
WS_SHIP_CUSTOMER_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
C_C_CUSTOMER_SK
9
0
-100
0
0
0
0
3
34350
34350
ws_ship_cdemo_sk
WS_SHIP_CDEMO_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
WS_SHIP_CUSTOMER_D_SK
10
0
-100
0
0
0
0
3
23943
23943
ws_ship_hdemo_sk
WS_SHIP_HDEMO_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CD_CD_DEMO_SK
11
0
-100
0
0
0
0
3
23909
23909
ws_ship_addr_sk
WS_SHIP_ADDR_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CA_CA_ADDRESS_SK
12
0
-100
0
0
0
0
3
27655
27655
ws_web_page_sk
WS_WEB_PAGE_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
WS_WEB_SITE_SK
13
0
-100
0
0
0
0
3
38094
38094
ws_web_site_sk
WS_WEB_SITE_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
WS_WEB_SITE_SK
14
0
-100
0
0
0
0
3
24940
24940
ws_ship_mode_sk
WS_SHIP_MODE_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SM_SHIP_MODE_SK
15
0
-100
0
0
0
0
3
24927
24927
ws_warehouse_sk
WS_WAREHOUSE_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
W_WAREHOUSE_SK
16
0
-100
0
0
0
0
3
23878
23878
ws_promo_sk
WS_PROMO_SK
1351
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
P_PROMO_SK
17
0
-100
0
0
0
0
3
1368
1368
ws_order_number
WS_ORDER_NUMBER
1351
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
WS_ORDER
18
0
-100
0
0
0
0
3
1369
1369
ws_quantity
WS_QUANTITY
1351
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
WS_QUANTITY
19
0
0
0
0
0
0
3
1370
1370
ws_wholesale_cost
WS_WHOLESALE_COST
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_WHOLESALE
20
0
0
0
0
0
0
3
1371
1371
ws_list_price
WS_LIST_PRICE
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_SALES_PRICE
21
0
0
0
0
0
0
3
1372
1372
ws_sales_price
WS_SALES_PRICE
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_ACTUAL_PRICE
22
0
0
0
0
0
0
3
1373
1373
ws_ext_discount_amt
WS_EXP_DISCOUNT_AMT
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_EXP_DISCOUNT
23
0
0
0
0
0
0
3
1374
1374
ws_ext_sales_price
WS_EXP_SALES_PRICE
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_EXP_SALES_PRICE
24
0
0
0
0
0
0
3
1375
1375
ws_ext_wholesale_cost
WS_EXP_WHOLESALE_COST
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_EXP_WHOLESALE
25
0
0
0
0
0
0
3
1376
1376
ws_ext_list_price
WS_EXP_LIST_PRICE
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_EXPR_PRICE
26
0
0
0
0
0
0
3
1378
1378
ws_ext_tax
WS_EXP_TAX
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_EXP_TAX
27
0
-100
0
0
0
0
3
1379
1379
ws_coupon_amt
WS_COUPON_AMT
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_COUPON_AMT
28
0
-100
0
0
0
0
3
1380
1380
ws_ext_ship_cost
WS_EXP_SHIP_COST
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_SHIP_COST
29
0
-100
0
0
0
0
3
1381
1381
ws_net_paid
WS_NET_PAID
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_NET_PAID
30
0
-100
0
0
0
0
3
3640
3640
ws_net_paid_inc_tax
WS_NET_PAID_INC_TAX
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_NET_PAID_INC_TAX
31
0
-100
0
0
0
0
3
3641
3641
ws_net_paid_inc_ship
WS_NET_PAID_INC_SHIP
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_NET_PAID_INC_SHIP
32
0
-100
0
0
0
0
3
3642
3642
ws_net_paid_inc_ship_tax
WS_NET_PAID_INC_SHIP_TAX
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_NET_PAID_INC_SHIP_TAX
33
0
-100
0
0
0
0
3
1382
1382
ws_net_profit
WS_NET_PROFIT
1351
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
WS_NET_PROFIT
34
0
-100
0
0
0
0
3
22892
22892
cs_sold_date_sk
CS_SOLD_DATE_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D_D_DATE_SK
1
0
-100
0
0
0
0
3
22762
22762
cs_sold_time_sk
CS_SOLD_TIME_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
T_TIME_SK
2
0
-100
0
0
0
0
3
22904
22904
cs_ship_date_sk
CS_SHIP_DATE_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
D2_D_DATE_SK
3
0
-100
0
0
0
0
3
22721
22721
cs_bill_customer_sk
CS_BILL_CUSTOMER_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
C_C_CUSTOMER_SK
4
0
-100
0
0
0
0
3
23949
23949
cs_bill_cdemo_sk
CS_BILL_CDEMO_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CD_CD_DEMO_SK
5
0
-100
0
0
0
0
3
36127
36127
cs_bill_hdemo_sk
CS_BILL_HDEMO_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CS_BILL_HDEMO_SK
6
0
-100
0
0
0
0
3
23915
23915
cs_bill_addr_sk
CS_BILL_ADDR_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CA_CA_ADDRESS_SK
7
0
-100
0
0
0
0
3
22715
22715
cs_ship_customer_sk
CS_SHIP_CUST_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
C_CUSTOMER_SK
8
0
-100
0
0
0
0
3
23946
23946
cs_ship_cdemo_sk
CS_SHIP_CDEMO_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CD_DEMO_SK
9
0
-100
0
0
0
0
3
36128
36128
cs_ship_hdemo_sk
CS_SHIP_HDEMO_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CS_SHIP_HDEMO_SK
10
0
-100
0
0
0
0
3
23912
23912
cs_ship_addr_sk
CS_SHIP_ADDR_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CA_ADDRESS_SK
11
0
-100
0
0
0
0
3
24950
24950
cs_call_center_sk
CS_CALL_CENTER_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CS_CALL_CENTER_SK
12
0
-100
0
0
0
0
3
25888
25888
cs_catalog_page_sk
CS_CATALOG_PAGE_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CS_CATALOG_PAGE_SK
13
0
-100
0
0
0
0
3
24943
24943
cs_ship_mode_sk
CS_SHIP_MODE_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CS_SHIP_MODE_SK
14
0
-100
0
0
0
0
3
24930
24930
cs_warehouse_sk
CS_WAREHOUSE_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
CS_WAREHOUSE_SK
15
0
-100
0
0
0
0
3
22976
22976
cs_item_sk
CS_ITEM_SK
1468
0
INTEGER
0
0
0
0
0
0
0
1
1
1
1
0
0
I_ITEM_SK
16
0
-100
0
0
0
0
3
23875
23875
cs_promo_sk
CS_PROMO_SK
1468
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
P_PROMO_SK
17
0
-100
0
0
0
0
3
1483
1483
cs_order_number
CS_ORDER_NUMBER
1468
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
CS_ORDER
18
0
-100
0
0
0
0
3
1484
1484
cs_quantity
CS_QUANTITY
1468
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
CS_QUANTITY
19
0
0
0
0
0
0
3
1485
1485
cs_wholesale_cost
CS_WHOLESALE_COST
What we paid for it (per-item) not additive
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_WHOLESALE
20
0
0
0
0
0
0
3
1486
1486
cs_list_price
CS_LIST_PRICE
current list price, i.e. price before sales, promotions ; not additive
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_SALES_PRICE
21
0
0
0
0
0
0
3
1487
1487
cs_sales_price
CS_SALES_PRICE
What we actually sold it for (not additive)
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_ACTUAL_PRICE
22
0
0
0
0
0
0
3
1488
1488
cs_ext_discount_amt
CS_EXP_DISCOUNT_AMT
Qty * (list_price -sales_price)
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_EXP_DISCOUNT
23
0
0
0
0
0
0
3
1489
1489
cs_ext_sales_price
CS_EXP_SALES_PRICE
Qty * sales_price
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_EXP_SALES_PRICE
24
0
0
0
0
0
0
3
1490
1490
cs_ext_wholesale_cost
CS_EXP_WHOLESALE_COST
Qty*wholesale_cost (additive)
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_EXP_WHOLESALE
25
0
0
0
0
0
0
3
1491
1491
cs_ext_list_price
CS_EXP_LIST_PRICE
Qty * list _price
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_EXPR_PRICE
26
0
0
0
0
0
0
3
1492
1492
cs_ext_tax
CS_EXP_TAX
Total tax paid on Qty
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_EXP_TAX
27
0
-100
0
0
0
0
3
1493
1493
cs_coupon_amt
CS_COUPON_AMT
Coupon amount related to this item on this ticket
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_COUPON_AMT
28
0
-100
0
0
0
0
3
1494
1494
cs_ext_ship_cost
CS_EXP_SHIP_COST
shipping charges applied to this item-qty
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_SHIP_COST
29
0
-100
0
0
0
0
3
1495
1495
cs_net_paid
CS_NET_PAID
exp_sales_price - coupon_amt
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_NET_PAID
30
0
-100
0
0
0
0
3
3624
3624
cs_net_paid_inc_tax
CS_NET_PAID_INC_TAX
exp_sales_price - coupon_amt + exp_tax
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_NET_PAID_INC_TAX
31
0
-100
0
0
0
0
3
3625
3625
cs_net_paid_inc_ship
CS_NET_PAID_INC_SHIP
exp_sales_price - coupon_amt+ exp_ship_cost
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_NET_PAID_INC_SHIP
32
0
-100
0
0
0
0
3
3626
3626
cs_net_paid_inc_ship_tax
CS_NET_PAID_INC_SHIP_TAX
exp_sales_price - coupon_amt+ exp_ship_cost + exp_tax
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_NET_PAID_INC_SHIP_TAX
33
0
-100
0
0
0
0
3
1496
1496
cs_net_profit
CS_NET_PROFIT
sales_amount - coupon_amt - exp_wholesale_cost
1468
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
CS_NET_PROFIT
34
0
-100
0
0
0
0
3
22895
22895
ss_sold_date_sk
SS_SOLD_DATE_SK
1550
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SS_SOLD_DATE_SK
1
0
-100
0
0
0
0
3
22765
22765
ss_sold_time_sk
SS_SOLD_TIME_SK
1550
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SS_SOLD_TIME_SK
2
0
-100
0
0
0
0
3
22973
22973
ss_item_sk
SS_ITEM_SK
1550
0
INTEGER
0
0
0
0
0
0
0
1
1
1
1
0
0
SS_SOLD_ITEM_SK
3
0
-100
0
0
0
0
3
22727
22727
ss_customer_sk
SS_CUSTOMER_SK
1550
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SS_SOLD_CUSTOMER_SK
4
0
-100
0
0
0
0
3
23952
23952
ss_cdemo_sk
SS_CDEMO_SK
1550
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SS_SOLD_DEMO_SK
5
0
-100
0
0
0
0
3
30077
30077
ss_hdemo_sk
SS_HDEMO_SK
1550
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SS_SOLD_HDEMO_SK
6
0
-100
0
0
0
0
3
23918
23918
ss_addr_sk
SS_ADDR_SK
1550
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SS_SOLD_ADDR_SK
7
0
-100
0
0
0
0
3
22743
22743
ss_store_sk
SS_STORE_SK
1550
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
S_STORE_SK
8
0
-100
0
0
0
0
3
23872
23872
ss_promo_sk
SS_PROMO_SK
1550
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
SS_SOLD_PROMO_SK
9
0
-100
0
0
0
0
3
1611
1611
ss_ticket_number
SS_TICKET_NUMBER
This is a number that is assigned at the time of the sale at the store. The register ticket combined with the store, date (store date), and time make up a unique key of this table. It breaks the tie if two unknown customers have a sales\\
recorded at the same second in the same store.\
\
Ticket numbers are unique within the same store for the same day (at the store). For data generation, it can be even more unique than that, but it needs to be atleast that unique.\
\
This is a degenerate dimension, as all the other information at the time of sale ends up in other dimensions.
1550
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
SS_TICKET
10
0
-100
0
0
0
0
3
1565
1565
ss_quantity
SS_QUANTITY
This is the quantity of this item sold on this register ticket.\
\
For data generation care must be taken to choose quantity so that the other numbers say in range as all the columns named " *_exp*" are a multiple of this column. Note that ss_net_paid, ss_net_paid_inc_tax, and ss_net_profit are computed\\
from columns that are multiples of this column.
1550
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
SS_QUANTITY
11
0
0
0
0
0
0
3
1566
1566
ss_wholesale_cost
SS_WHOLESALE_COST
This is what the store paid for this item sold. \
\
This field is NOT ADDITIVE, but can be averaged (max or min) over time or products of the same type.
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_WHOLESALE
12
0
0
0
0
0
0
3
1567
1567
ss_list_price
SS_LIST_PRICE
This is the list price of the product at this time.\
\
This field is NOT ADDITIVE, but can be averaged (max or min) over time or products of the same type.\
\
For data generation, the list price should be greater than or equal to the actual price (ss_actual_price)
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_SALES_PRICE
13
0
0
0
0
0
0
3
1568
1568
ss_sales_price
SS_SALES_PRICE
This is the actual price that was used at the time of the sale. This would be different from the list price if it was sold on sale. \
\
This field is NOT ADDITIVE, but can be averaged (max or min) over time or products of the same type.\
\
For data generation, the sales price should be less than or equal to the list price (ss_list_price). Usually the sales price should be the same as the list price.
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_ACTUAL_PRICE
14
0
0
0
0
0
0
3
1569
1569
ss_ext_discount_amt
SS_EXP_DISCOUNT_AMT
= ss_quantity * (ss_list_price - ss_actual_price)\
\
This is the amount that the actual price is discounted for the sale. It is expanded for the quantity sold. This cannot be greater than the ss_exp_actual_price and should probably be not often greater than 75 percent of it. \
\
It should usually be 0.
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_EXP_DISCOUNT
15
0
0
0
0
0
0
3
1570
1570
ss_ext_sales_price
SS_EXP_SALES_PRICE
=ss_quantity * ss_sales_price
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_EXP_SALES_PRICE
16
0
0
0
0
0
0
3
1571
1571
ss_ext_wholesale_cost
SS_EXP_WHOLESALE_COST
= ss_quantity * ss_wholesale_cost\
\
This represents what it cost to purchase the item sold expanded by quantity.\
\
This should usually be less than the price paid. It should always be less than the expanded list price (or if not, that would make a pretty obvious query).
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_EXP_WHOLESALE
17
0
0
0
0
0
0
3
1572
1572
ss_ext_list_price
SS_EXP_LIST_PRICE
= ss_quantity * ss_list_price
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_EXP_PRICE
18
0
0
0
0
0
0
3
1573
1573
ss_ext_tax
SS_EXP_TAX
This is the total tax paid for this item on the ticket. \
\
In real life this might be based on the the %tax for this item (if taxable) times what was paid for the item times the quantity.
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_EXP_TAX
19
0
-100
0
0
0
0
3
1574
1574
ss_coupon_amt
SS_COUPON_AMT
This is the total amount of coupons applied to this item on the ticket.\
\
This field willl usually be zero. It should be a small percentage of the list price of one item.
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_COUPON_AMT
20
0
-100
0
0
0
0
3
1576
1576
ss_net_paid
SS_NET_PAID
\
This is the actual expanded amount paid for item( but not including the tax)\
\
\
= ss_exp_sales_price - ss_coupon_amount
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_NET_PAID
21
0
-100
0
0
0
0
3
3623
3623
ss_net_paid_inc_tax
SS_NET_PAID_INC_TAX
This is the actual expanded amount paid for item including the tax.\
\
\
= ss_exp_sales_price - ss_coupon_amount + ss_exp_tax
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_NET_PAID_INC_TAX
22
0
-100
0
0
0
0
3
1577
1577
ss_net_profit
SS_NET_PROFIT
= ss_exp_sales_price - ss_exp_coupon_amount - ss_exp_wholesale_cost\
\
(should also equal ss_net_paid - ss_exp_tax - ss_exp_wholesale_cost)\
\
This should average some reasonable percent of the cost. It should be allowed to go negative. It should be skewed to allow for more or less profitable months, stores, customer types, demographics, promotions... if possible.
1550
0
decimal(7,2)
7
2
0
0
0
0
0
0
0
0
1
0
0
SS_NET_PROFIT
23
0
-100
0
0
0
0
3
15341
15341
ib_income_band_sk
IB_INCOME_BAND_SK
15340
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
IB_INCOME_BAND_ID
1
0
-100
0
0
0
0
3
15342
15342
ib_lower_bound
IB_LOWER_BOUND
15340
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
IB_LOWER_BOUND
2
0
-100
0
0
0
0
3
15343
15343
ib_upper_bound
IB_UPPER_BOUND
15340
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
IB_UPPER_BOUND
3
0
-100
0
0
0
0
3
29070
29070
hd_demo_sk
HD_DEMO_SK
29069
0
INTEGER
0
0
0
0
0
0
0
1
0
1
1
0
0
HD_DEMO_SK
1
0
-100
0
0
0
0
3
30065
30065
hd_income_band_sk
HD_INCOME_BAND_SK
29069
0
INTEGER
0
0
0
0
0
0
0
0
1
0
1
0
0
IB_INCOME_BAND_ID
2
0
-100
0
0
0
0
3
29073
29073
hd_buy_potential
HD_BUY_POTENTIAL
29069
0
CHAR(15)
15
0
0
0
0
0
0
0
0
0
1
0
0
HD_BUY_POTENTIAL
3
0
-100
0
0
0
0
3
29074
29074
hd_dep_count
HD_DEP_COUNT
29069
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
HD_DEP_COUNT
4
0
-100
0
0
0
0
3
29075
29075
hd_vehicle_count
HD_VEHICLE_COUNT
29069
0
INTEGER
0
0
0
0
0
0
0
0
0
0
1
0
0
HD_VEHICLE_COUNT
5
0
-100
0
0
0
0
3
38740
38740
dv_version
DV_VERSION
38739
0
VARCHAR(16)
16
0
0
0
0
0
0
0
0
0
1
0
0
DV_VERSION
1
0
-100
0
0
0
0
3
38741
38741
dv_create_date
DV_CREATE_DATE
38739
0
DATE
0
0
0
0
0
0
0
0
0
0
1
0
0
DV_CREATE_DATE
2
0
-100
0
0
0
0
3
38742
38742
dv_create_time
DV_CREATE_TIME
38739
0
TIME
0
0
0
0
0
0
0
0
0
0
1
0
0
DV_CREATE_TIME
3
0
-100
0
0
0
0
3
38743
38743
dv_cmdline_args
DV_CMDLINE_ARGS
38739
0
VARCHAR(200)
200
0
0
0
0
0
0
0
0
0
1
0
0
DV_CMDLINE_ARGS
4
0
-100
0
0
0
0
/END_TABLE AMCCOLN
/BEGIN_TABLE AMCAKEY
@ N5
OID N10
AKEY N10
NAME A80
CODE A80
TABL N10
LABL A254
DESC TXT
NOTE TXT
OPTS TXT
AKCN A30
NUMR N8
ROPR N1
/BEGIN_DATA AMCAKEY
/END_TABLE AMCAKEY
/BEGIN_TABLE AMCCKEY
@ N5
OID N10
CKEY N10
AKEY N10
COLN N10
NUMR N8
/BEGIN_DATA AMCCKEY
/END_TABLE AMCCKEY
/BEGIN_TABLE AMCREFR
@ N5
OID N10
REFR N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
TABL1 N10
TABL2 N10
KOBJ N10
URUL N1
DRUL N1
MAND N1
CPRT N1
SOID N10
TOBJ N5
COBJ A80
FKCN A30
CMIN A10
CMAX A10
NGEN N1
CMMT N1
ROPR N1
/BEGIN_DATA AMCREFR
3
76
76
Ref_76
REF_76
39
28
39
1
1
0
1
0
0
REF_76
0
n
0
0
0
3
80
80
Ref_80
REF_80
15
28
15
1
1
0
1
0
0
REF_80
0
n
0
0
0
3
296
296
Ref_296
REF_296
270
50
270
1
1
1
1
0
0
REF_296
0
n
0
0
0
3
333
333
Ref_333
REF_333
308
50
308
1
1
0
1
0
0
REF_333
0
n
0
0
0
3
368
368
Ref_368
REF_368
308
353
308
1
1
0
1
0
0
REF_368
0
n
0
0
0
3
372
372
Ref_372
REF_372
39
353
39
1
1
0
1
0
0
REF_372
0
n
0
0
0
3
376
376
Ref_376
REF_376
28
353
28
1
1
0
1
0
0
REF_376
0
n
0
0
0
3
982
982
Ref_982
REF_982
308
974
308
1
1
0
1
0
0
REF_982
0
n
0
0
0
3
986
986
Ref_986
REF_986
308
974
308
1
1
0
1
0
0
REF_986
0
n
0
0
0
3
997
997
Ref_997
REF_997
308
990
308
1
1
0
1
0
0
REF_997
0
n
0
0
0
3
1001
1001
Ref_1001
REF_1001
308
990
308
1
1
0
1
0
0
REF_1001
0
n
0
0
0
3
1014
1014
Ref_1014
REF_1014
308
1005
308
1
1
0
1
0
0
REF_1014
0
n
0
0
0
3
1018
1018
Ref_1018
REF_1018
308
1005
308
1
1
0
1
0
0
REF_1018
0
n
0
0
0
3
1038
1038
Ref_1038
REF_1038
308
49
308
1
1
0
1
0
0
REF_1038
0
n
0
0
0
3
1064
1064
Ref_1064
REF_1064
308
1045
308
1
1
0
1
0
0
REF_1064
0
n
0
0
0
3
1068
1068
Ref_1068
REF_1068
308
1045
308
1
1
0
1
0
0
REF_1068
0
n
0
0
0
3
1143
1143
Ref_1143
REF_1143
1022
50
1022
1
1
1
1
0
0
REF_1143
0
n
0
0
0
3
1147
1147
Ref_1147
REF_1147
28
353
28
1
1
0
1
0
0
REF_1147
0
n
0
0
0
3
1151
1151
Ref_1151
REF_1151
39
353
39
1
1
0
1
0
0
REF_1151
0
n
0
0
0
3
1155
1155
Ref_1155
REF_1155
15
353
15
1
1
0
1
0
0
REF_1155
0
n
0
0
0
3
1159
1159
Ref_1159
REF_1159
1118
353
1118
1
1
0
1
0
0
REF_1159
0
n
0
0
0
3
1167
1167
Ref_1167
REF_1167
270
353
270
1
1
1
1
0
0
REF_1167
0
n
0
0
0
3
1171
1171
Ref_1171
REF_1171
1045
353
1045
1
1
0
1
0
0
REF_1171
0
n
0
0
0
3
1175
1175
Ref_1175
REF_1175
990
353
990
1
1
0
1
0
0
REF_1175
0
n
0
0
0
3
1179
1179
Ref_1179
REF_1179
1031
353
1031
1
1
0
1
0
0
REF_1179
0
n
0
0
0
3
1183
1183
Ref_1183
REF_1183
1022
353
1022
1
1
0
1
0
0
REF_1183
0
n
0
0
0
3
1187
1187
Ref_1187
REF_1187
1127
353
1127
1
1
0
1
0
0
REF_1187
0
n
0
0
0
3
1227
1227
Ref_1227
REF_1227
1118
1192
1118
1
1
0
1
0
0
REF_1227
0
n
0
0
0
3
1231
1231
Ref_1231
REF_1231
270
1192
270
1
1
1
1
0
0
REF_1231
0
n
0
0
0
3
1235
1235
Ref_1235
REF_1235
28
1192
28
1
1
0
1
0
0
REF_1235
0
n
0
0
0
3
1239
1239
Ref_1239
REF_1239
39
1192
39
1
1
0
1
0
0
REF_1239
0
n
0
0
0
3
1243
1243
Ref_1243
REF_1243
15
1192
15
1
1
0
1
0
0
REF_1243
0
n
0
0
0
3
1247
1247
Ref_1247
REF_1247
49
1192
49
1
1
0
1
0
0
REF_1247
0
n
0
0
0
3
1255
1255
Ref_1255
REF_1255
1127
1192
1127
1
1
0
1
0
0
REF_1255
0
n
0
0
0
3
1291
1291
Ref_1291
REF_1291
308
1260
308
1
1
0
1
0
0
REF_1291
0
n
0
0
0
3
1295
1295
Ref_1295
REF_1295
308
1260
308
1
1
0
1
0
0
REF_1295
0
n
0
0
0
3
1299
1299
Ref_1299
REF_1299
1118
1260
1118
1
1
0
1
0
0
REF_1299
0
n
0
0
0
3
1303
1303
Ref_1303
REF_1303
270
1260
270
1
1
1
1
0
0
REF_1303
0
n
0
0
0
3
1307
1307
Ref_1307
REF_1307
28
1260
28
1
1
0
1
0
0
REF_1307
0
n
0
0
0
3
1311
1311
Ref_1311
REF_1311
39
1260
39
1
1
0
1
0
0
REF_1311
0
n
0
0
0
3
1315
1315
Ref_1315
REF_1315
15
1260
15
1
1
0
1
0
0
REF_1315
0
n
0
0
0
3
1319
1319
Ref_1319
REF_1319
28
1260
28
1
1
0
1
0
0
REF_1319
0
n
0
0
0
3
1323
1323
Ref_1323
REF_1323
39
1260
39
1
1
0
1
0
0
REF_1323
0
n
0
0
0
3
1327
1327
Ref_1327
REF_1327
15
1260
15
1
1
0
1
0
0
REF_1327
0
n
0
0
0
3
1331
1331
Ref_1331
REF_1331
1076
1260
1076
1
1
0
1
0
0
REF_1331
0
n
0
0
0
3
1335
1335
Ref_1335
REF_1335
1005
1260
1005
1
1
0
1
0
0
REF_1335
0
n
0
0
0
3
1339
1339
Ref_1339
REF_1339
1031
1260
1031
1
1
0
1
0
0
REF_1339
0
n
0
0
0
3
1343
1343
Ref_1343
REF_1343
1127
1260
1127
1
1
0
1
0
0
REF_1343
0
n
0
0
0
3
1347
1347
Ref_1347
REF_1347
1022
1260
1022
1
1
0
1
0
0
REF_1347
0
n
0
0
0
3
1383
1383
Ref_1383
REF_1383
308
1351
308
1
1
0
1
0
0
REF_1383
0
n
0
0
0
3
1395
1395
Ref_1395
REF_1395
270
1351
270
1
1
1
1
0
0
REF_1395
0
n
0
0
0
3
1399
1399
Ref_1399
REF_1399
28
1351
28
1
1
0
1
0
0
REF_1399
0
n
0
0
0
3
1403
1403
Ref_1403
REF_1403
39
1351
39
1
1
0
1
0
0
REF_1403
0
n
0
0
0
3
1407
1407
Ref_1407
REF_1407
15
1351
15
1
1
0
1
0
0
REF_1407
0
n
0
0
0
3
1411
1411
Ref_1411
REF_1411
28
1351
28
1
1
0
1
0
0
REF_1411
0
n
0
0
0
3
1415
1415
Ref_1415
REF_1415
39
1351
39
1
1
0
1
0
0
REF_1415
0
n
0
0
0
3
1419
1419
Ref_1419
REF_1419
15
1351
15
1
1
0
1
0
0
REF_1419
0
n
0
0
0
3
1423
1423
Ref_1423
REF_1423
1076
1351
1076
1
1
0
1
0
0
REF_1423
0
n
0
0
0
3
1431
1431
Ref_1431
REF_1431
1031
1351
1031
1
1
0
1
0
0
REF_1431
0
n
0
0
0
3
1435
1435
Ref_1435
REF_1435
1022
1351
1022
1
1
0
1
0
0
REF_1435
0
n
0
0
0
3
1502
1502
Ref_1502
REF_1502
308
1468
308
1
1
0
1
0
0
REF_1502
0
n
0
0
0
3
1506
1506
Ref_1506
REF_1506
1118
1468
1118
1
1
0
1
0
0
REF_1506
0
n
0
0
0
3
1510
1510
Ref_1510
REF_1510
28
1468
28
1
1
0
1
0
0
REF_1510
0
n
0
0
0
3
1514
1514
Ref_1514
REF_1514
39
1468
39
1
1
0
1
0
0
REF_1514
0
n
0
0
0
3
1518
1518
Ref_1518
REF_1518
15
1468
15
1
1
0
1
0
0
REF_1518
0
n
0
0
0
3
1522
1522
Ref_1522
REF_1522
28
1468
28
1
1
0
1
0
0
REF_1522
0
n
0
0
0
3
1526
1526
Ref_1526
REF_1526
39
1468
39
1
1
0
1
0
0
REF_1526
0
n
0
0
0
3
1530
1530
Ref_1530
REF_1530
15
1468
15
1
1
0
1
0
0
REF_1530
0
n
0
0
0
3
1534
1534
Ref_1534
REF_1534
1045
1468
1045
1
1
0
1
0
0
REF_1534
0
n
0
0
0
3
1538
1538
Ref_1538
REF_1538
990
1468
990
1
1
0
1
0
0
REF_1538
0
n
0
0
0
3
1542
1542
Ref_1542
REF_1542
1031
1468
1031
1
1
0
1
0
0
REF_1542
0
n
0
0
0
3
1546
1546
Ref_1546
REF_1546
1022
1468
1022
1
1
0
1
0
0
REF_1546
0
n
0
0
0
3
1579
1579
Ref_1579
REF_1579
308
1550
308
1
1
0
1
0
0
REF_1579
0
n
0
0
0
3
1583
1583
Ref_1583
REF_1583
1118
1550
1118
1
1
0
1
0
0
REF_1583
0
n
0
0
0
3
1587
1587
Ref_1587
REF_1587
270
1550
270
1
1
0
1
0
0
REF_1587
0
n
0
0
0
3
1591
1591
Ref_1591
REF_1591
28
1550
28
1
1
0
1
0
0
REF_1591
0
n
0
0
0
3
1595
1595
Ref_1595
REF_1595
39
1550
39
1
1
0
1
0
0
REF_1595
0
n
0
0
0
3
1599
1599
Ref_1599
REF_1599
15
1550
15
1
1
0
1
0
0
REF_1599
0
n
0
0
0
3
1603
1603
Ref_1603
REF_1603
49
1550
49
1
1
0
1
0
0
REF_1603
0
n
0
0
0
3
1607
1607
Ref_1607
REF_1607
974
1550
974
1
1
0
1
0
0
REF_1607
0
n
0
0
0
3
2801
2801
Ref_2801
REF_2801
308
353
308
1
1
0
1
0
0
REF_2801
0
n
0
0
0
3
4479
4479
Ref_4479
REF_4479
270
1468
270
1
1
1
1
0
0
REF_4479
0
n
0
0
0
3
4483
4483
Ref_4483
REF_4483
308
1468
308
1
1
0
1
0
0
REF_4483
0
n
0
0
0
3
4503
4503
Ref_4503
REF_4503
308
1351
308
1
1
0
1
0
0
REF_4503
0
n
0
0
0
3
4511
4511
Ref_4511
REF_4511
1118
1351
1118
1
1
0
1
0
0
REF_4511
0
n
0
0
0
3
4555
4555
Ref_4555
REF_4555
308
1260
308
1
1
0
1
0
0
REF_4555
0
n
0
0
0
3
4567
4567
Ref_4567
REF_4567
1118
1260
1118
1
1
0
1
0
0
REF_4567
0
n
0
0
0
3
4575
4575
Ref_4575
REF_4575
308
1192
308
1
1
0
1
0
0
REF_4575
0
n
0
0
0
3
7692
7692
Ref_7692
REF_7692
974
1468
974
1
1
0
1
0
0
REF_7692
0
n
0
0
0
3
7696
7696
Ref_7696
REF_7696
974
1351
974
1
1
0
1
0
0
REF_7696
0
n
0
0
0
3
9847
9847
Ref_9847
REF_9847
974
990
974
1
1
0
1
0
0
REF_9847
0
n
0
0
0
3
30064
30064
Ref_30064
REF_30064
15340
29069
15340
1
1
0
1
0
0
REF_30064
0
n
0
0
0
3
31053
31053
Ref_31053
REF_31053
1192
29069
1192
1
1
0
1
0
0
REF_31053
0
n
0
0
0
3
31054
31054
Ref_31054
REF_31054
1192
29069
1192
1
1
0
1
0
0
REF_31054
0
n
0
0
0
3
31055
31055
Ref_31055
REF_31055
29069
1192
29069
1
1
0
1
0
0
REF_31055
0
n
0
0
0
3
34359
34359
Ref_34359
REF_34359
29069
1260
29069
1
1
0
1
0
0
REF_34359
0
n
0
0
0
3
36581
36581
Ref_36581
REF_36581
1076
1005
1076
1
1
0
1
0
0
REF_36581
0
n
0
0
0
3
36585
36585
Ref_36585
REF_36585
1076
1005
1076
1
1
0
1
0
0
REF_36585
0
n
0
0
0
3
37384
37384
Ref_31742
REF_31742
29069
353
29069
1
1
0
1
0
0
REF_31742
0
n
0
0
0
3
37395
37395
Ref_31744
REF_31744
15
353
15
1
1
0
1
0
0
REF_31744
0
n
0
0
0
3
38118
38118
Ref_38118
REF_38118
29069
1351
29069
1
1
0
1
0
0
REF_38118
0
n
0
0
0
3
38126
38126
Ref_38126
REF_38126
29069
1351
29069
1
1
0
1
0
0
REF_38126
0
n
0
0
0
3
38134
38134
Ref_38134
REF_38134
1005
1351
1005
1
1
0
1
0
0
REF_38134
0
n
0
0
0
3
38144
38144
Ref_38144
REF_38144
29069
1468
29069
1
1
0
1
0
0
REF_38144
0
n
0
0
0
3
38148
38148
Ref_38148
REF_38148
29069
1468
29069
1
1
0
1
0
0
REF_38148
0
n
0
0
0
3
39554
39554
Ref_996
REF_996
15340
29069
15340
1
1
0
1
0
0
REF_996
0
n
0
0
0
3
39614
39614
Ref_995
REF_995
29069
1260
29069
1
1
0
1
0
0
REF_995
0
n
0
0
0
3
40036
40036
Ref_40036
REF_40036
29069
353
29069
1
1
0
1
0
0
REF_40036
0
n
0
0
0
3
40044
40044
Ref_40044
REF_40044
29069
1192
29069
1
1
0
1
0
0
REF_40044
0
n
0
0
0
3
41193
41193
Ref_41193
REF_41193
29069
1550
29069
1
1
0
1
0
0
REF_41193
0
n
0
0
0
3
41455
41455
Ref_41455
REF_41455
29069
28
29069
1
1
0
1
0
0
REF_41455
0
n
0
0
0
3
41463
41463
Ref_41463
REF_41463
308
28
308
1
1
0
1
0
0
REF_41463
0
n
0
0
0
3
41475
41475
Ref_41475
REF_41475
308
28
308
1
1
0
1
0
0
REF_41475
0
n
0
0
0
3
41491
41491
Ref_41491
REF_41491
308
1076
308
1
1
0
1
0
0
REF_41491
0
n
0
0
0
3
41495
41495
Ref_41495
REF_41495
308
1076
308
1
1
0
1
0
0
REF_41495
0
n
0
0
0
3
41753
41753
Ref_41753
REF_41753
270
974
270
1
1
0
1
0
0
REF_41753
0
n
0
0
0
3
43200
43200
Ref_43200
REF_43200
974
270
974
1
1
0
1
0
0
REF_43200
0
n
0
0
0
/END_TABLE AMCREFR
/BEGIN_TABLE AMCCCOL
@ N5
OID N10
CCOL N10
COLN1 N10
COLN2 N10
/BEGIN_DATA AMCCCOL
1
22674
22674
22670
22673
1
22680
22680
22670
22679
1
22686
22686
22670
22685
1
22692
22692
22670
22691
1
22698
22698
22670
22697
1
22704
22704
22670
22703
1
22710
22710
22670
22709
1
22741
22741
22739
22740
1
22748
22748
22746
22747
1
22778
22778
22746
22777
1
22799
22799
22746
22798
1
22827
22827
22819
22826
1
22830
22830
22819
22829
1
22842
22842
22819
22841
1
22848
22848
22819
22847
1
22851
22851
22819
22850
1
22875
22875
22819
22874
1
22881
22881
22819
22880
1
22893
22893
22819
22892
1
22899
22899
22819
22898
1
22914
22914
22819
22913
1
22938
22938
22819
22937
1
22953
22953
22949
22952
1
22956
22956
22949
22955
1
22959
22959
22949
22958
1
22962
22962
22949
22961
1
22965
22965
22949
22964
1
23879
23879
23871
23878
1
23889
23889
23887
23888
1
23895
23895
23887
23894
1
23898
23898
23887
23897
1
23901
23901
23887
23900
1
23904
23904
23887
23903
1
23907
23907
23887
23906
1
23910
23910
23887
23909
1
23923
23923
23921
23922
1
23926
23926
23921
23925
1
23929
23929
23921
23928
1
23932
23932
23921
23931
1
24909
24909
24907
24908
1
24912
24912
24907
24911
1
24915
24915
24907
24914
1
24922
24922
24917
24921
1
24928
24928
24917
24927
1
24935
24935
24933
24934
1
24941
24941
24933
24940
1
24948
24948
24946
24947
1
25886
25886
24953
25885
1
28442
28442
27658
28441
1
37224
37224
22819
22838
1
37370
37370
22819
22832
1
37372
37372
22819
22835
1
37374
37374
22746
22753
1
37380
37380
24917
24918
1
37382
37382
22819
22820
1
37402
37402
23887
37399
1
38084
38084
23921
34352
1
38088
38088
23921
34351
1
38099
38099
27651
38094
1
38103
38103
23921
34349
1
38107
38107
23921
34350
1
38142
38142
27658
27655
1
38589
38589
22819
22844
1
41473
41473
22819
11684
1
41481
41481
22819
11683
1
41501
41501
22819
22856
1
41505
41505
22819
22853
1
41755
41755
22949
41754
/END_TABLE AMCCCOL
/BEGIN_TABLE AMCCREF
@ N5
OID N10
CREF N10
REFR N10
CCOL N10
NUMR N8
/BEGIN_DATA AMCCREF
/END_TABLE AMCCREF
/BEGIN_TABLE AMCINDX
@ N5
OID N10
INDX N10
NAME A80
CODE A80
TABL N10
LABL A254
DESC TXT
NOTE TXT
PRIM N1
FORN N1
ISAK N1
KOBJ N10
UNIQ N1
CLUS N1
OPTS TXT
COBJ A80
NUMR N8
TYPE A40
ROPR N1
/BEGIN_DATA AMCINDX
/END_TABLE AMCINDX
/BEGIN_TABLE AMCCIDX
@ N5
OID N10
CIDX N10
INDX N10
COLN N10
ASCD N1
NUMR N8
/BEGIN_DATA AMCCIDX
/END_TABLE AMCCIDX
/BEGIN_TABLE AMCTRGRI
@ N5
OID N10
GUID N10
NAME A30
LABL A254
TEXT TXT
/BEGIN_DATA AMCTRGRI
/END_TABLE AMCTRGRI
/BEGIN_TABLE AMCTRGRT
@ N5
OID N10
GUID N10
NAME A30
TEMP A30
TEXT TXT
TNAM A30
/BEGIN_DATA AMCTRGRT
/END_TABLE AMCTRGRT
/BEGIN_TABLE AMCTRGR
@ N5
TEMP A30
TEXT TXT
NAME A30
TABL N10
ALWS N1
ORDR N5
/BEGIN_DATA AMCTRGR
/END_TABLE AMCTRGR
/BEGIN_TABLE AMCPROC
@ N5
OID N10
PROC N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
TEXT TXT
FUNC N1
/BEGIN_DATA AMCPROC
/END_TABLE AMCPROC
/BEGIN_TABLE AMCVIEW
@ N5
OID N10
VIEW N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
CUST N1
LOBJ TXT
QURY TXT
UPDT N1
GENE N1
CHCK N1
OWNR N10
ROPR N1
/BEGIN_DATA AMCVIEW
/END_TABLE AMCVIEW
/BEGIN_TABLE AMCRULE
@ N5
OID N10
RULE N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
TYPE N5
FLAG N5
CEXP TXT
SEXP TXT
LOBJ TXT
SOID N10
COBJ A80
/BEGIN_DATA AMCRULE
/END_TABLE AMCRULE
/BEGIN_TABLE AMCTSPC
@ N5
OID N10
TSPC N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
OPTS TXT
/BEGIN_DATA AMCTSPC
/END_TABLE AMCTSPC
/BEGIN_TABLE AMCSTOR
@ N5
OID N10
STOR N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
OPTS TXT
/BEGIN_DATA AMCSTOR
/END_TABLE AMCSTOR
/BEGIN_TABLE AMCLTBL
@ N5
OID N10
LTBL N10
LABL A254
DESC TXT
NOTE TXT
OPTS TXT
HEAD TXT
FOOT TXT
GENE N1
TABL N10
OWNR N10
/BEGIN_DATA AMCLTBL
/END_TABLE AMCLTBL
/BEGIN_TABLE AMCLCOL
@ N5
OID N10
LCOL N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
LTBL N10
COLN N10
DTTP A30
MLEN N8
PREC N2
MAND N1
UNIQ N1
DISP N1
IQIX N4
OPTFP TXT
OPTLF TXT
OPTLD TXT
OPTHG TXT
OPTHNG TXT
NUMR N8
/BEGIN_DATA AMCLCOL
/END_TABLE AMCLCOL
/BEGIN_TABLE AMCJREL
@ N5
OID N10
JREL N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
LTBL1 N10
LTBL2 N10
MANY N1
/BEGIN_DATA AMCJREL
/END_TABLE AMCJREL
/BEGIN_TABLE AMCJIDX
@ N5
OID N10
JIDX N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
OPTS TXT
HEAD TXT
FOOT TXT
LTBL N10
LOBJ TXT
OWNR N10
/BEGIN_DATA AMCJIDX
/END_TABLE AMCJIDX
/BEGIN_TABLE AMCJCCL
@ N5
OID N10
JCCL N10
LCOL1 N10
LCOL2 N10
/BEGIN_DATA AMCJCCL
/END_TABLE AMCJCCL
/BEGIN_TABLE AMCJCRL
@ N5
OID N10
JCRL N10
JREL N10
JCCL N10
NUMR N8
/BEGIN_DATA AMCJCRL
/END_TABLE AMCJCRL
/BEGIN_TABLE AMCJNIX
@ N5
OID N10
JNIX N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
OPTS TXT
HEAD TXT
FOOT TXT
LOBJ TXT
OWNR N10
/BEGIN_DATA AMCJNIX
/END_TABLE AMCJNIX
/BEGIN_TABLE AMCFACT
@ N5
OID N10
FACT N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
TABL N10
AGGR TXT
/BEGIN_DATA AMCFACT
1
6776
6776
Catalog Returns (CR_)
CATALOG_RETURNS
353
1
6788
6788
Store Returns (SR_)
STORE_RETURNS
1192
1
6789
6789
Store Sales (SS_)
STORE_SALES
1550
1
6792
6792
Web Cross Sales (XS_)
WEB_CROSS_SALES
0
1
6794
6794
Web Returns (WR_)
WEB_RETURNS
1260
1
6795
6795
Web Sales (WS_)
WEB_SALES
1351
1
6982
6982
Inventory (INV_)2
INVENTORY2
50
1
7691
7691
Catalog Sales (CS_)
CATALOG_SALES
1468
1
7701
7701
Response History (RH)
RESPONSE_HISTORY
0
1
8874
8874
Web Session (WS_)
WEB_SESSION
0
1
8933
8933
Web Events (WE)
WEB_EVENTS
0
1
10689
10689
Product Promotion History (PPH)
PRODUCT_PROMO_HISTORY
0
/END_TABLE AMCFACT
/BEGIN_TABLE AMCDIM
@ N5
OID N10
DIM N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
TABL N10
/BEGIN_DATA AMCDIM
1
6773
6773
Address (A_)
ADDRESS
15
1
6774
6774
Call Center (CC_)
CALL_CENTER
1045
1
6775
6775
Catalog Page (CP_)
CATALOG_PAGE
990
1
6777
6777
Cross Sold Type (XT_)
CROSS_SOLD_TYPE
0
1
6778
6778
Customer (C_)
CUSTOMER
28
1
6779
6779
Date (D_)
DATE
308
1
6780
6780
Demographics (DE_)
DEMOGRAPHICS
39
1
6781
6781
Inventory (INV_)
INVENTORY
0
1
6782
6782
Item (I_)
ITEM
270
1
6783
6783
Promotion (P_)
PROMOTION
974
1
6784
6784
Reason (R_)
REASON
1127
1
6785
6785
Season (SEASON_)
SEASON
0
1
6786
6786
Ship Mode (SM_)
SHIP_MODE
1031
1
6787
6787
Store (S_)
STORE
49
1
6790
6790
Time (T_)
TIME
1118
1
6791
6791
Warehouse (W_)
WAREHOUSE
1022
1
6793
6793
Web Page (WP_)
WEB_PAGE
1005
1
6796
6796
Web Site (WEB_)
WEB_SITE
1076
1
8806
8806
Date (D_)2
DATE2
0
1
8839
8839
Web Ad (WA_)
WEB_AD
0
1
8867
8867
Ad Usage (AU)
AD_USAGE
0
1
10688
10688
Promotional Product Group (PPG)
PROMO_PRODUCT_GROUP
0
1
13262
13262
Web Content
WEB_CONTENT
0
1
14292
14292
Demographics (DE_)2
DEMOGRAPHICS2
0
1
15318
15318
Address (A_)2
ADDRESS2
0
1
15344
15344
Income Band (IB_)
IB
15340
1
30059
30059
HOUSEHOLD_DEMOGRAPHICS
HD
29069
1
34373
34373
HOUSEHOLD_DEMOGRAPHICS2
HD2
0
1
38744
38744
Dbgen_Version
DBGEN_VERSION
38739
1
39643
39643
Household_demographics22
HD22
0
/END_TABLE AMCDIM
/BEGIN_TABLE AMCHFCT
@ N5
OID N10
HFCT N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
/BEGIN_DATA AMCHFCT
/END_TABLE AMCHFCT
/BEGIN_TABLE AMCHDIM
@ N5
OID N10
HDIM N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
/BEGIN_DATA AMCHDIM
/END_TABLE AMCHDIM
/BEGIN_TABLE AMCMETR
@ N5
OID N10
METR N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
TTYP N10
COLN N10
FRML TXT
AGGR TXT
/BEGIN_DATA AMCMETR
/END_TABLE AMCMETR
/BEGIN_TABLE AMCATTR
@ N5
OID N10
ATTR N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
TTYP N10
COLN N10
/BEGIN_DATA AMCATTR
/END_TABLE AMCATTR
/BEGIN_TABLE AMCNODE
@ N5
OID N10
NODE N10
PNODE N10
TYPE N10
NUMR N8
GENE N1
/BEGIN_DATA AMCNODE
/END_TABLE AMCNODE
/BEGIN_TABLE AMCDTBS
@ N5
OID N10
DTBS N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
DEFF A256
DTSC A80
SRVN A30
LOGN A128
PASS A256
/BEGIN_DATA AMCDTBS
/END_TABLE AMCDTBS
/BEGIN_TABLE AMCETBL
@ N5
OID N10
ETBL N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
DTBS N10
/BEGIN_DATA AMCETBL
/END_TABLE AMCETBL
/BEGIN_TABLE AMCECOL
@ N5
OID N10
ECOL N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
ETBL N10
DTTP A30
MLEN N8
PREC N2
DISP N1
NUMR N8
/BEGIN_DATA AMCECOL
/END_TABLE AMCECOL
/BEGIN_TABLE AMCTSRC
@ N5
OID N10
TSRC N10
TABL N10
DTBS N10
SCRPT TXT
INVLD N1
LOBJ TXT
/BEGIN_DATA AMCTSRC
/END_TABLE AMCTSRC
/BEGIN_TABLE AMCCSRC
@ N5
OID N10
CSRC N10
COLN N10
TSRC N10
ALIAS A80
EXPR TXT
INVLD N1
LOBJ TXT
/BEGIN_DATA AMCCSRC
/END_TABLE AMCCSRC
/BEGIN_TABLE AMCSUBM
@ N5
OID N10
SUBM N10
MODL N10
NAME A80
CODE A80
LABL A254
DESC TXT
NOTE TXT
POID N10
PNAM A80
PCOD A80
USER A80
VERS A8
CDAT N12
MDAT N12
ACCS N5
SMID N10
NUMR N8
/BEGIN_DATA AMCSUBM
3
86
86
1
Inventory
INVENTORY
0
TPCDS
TPCDS
953065079
954986780
0
0
1
3
87
87
1
Web Sales
WEB_SALES
0
TPCDS
TPCDS
953065206
954986780
0
0
2
3
88
88
1
Web Returns
WEB_RETURNS
0
TPCDS
TPCDS
953065883
954986780
0
0
3
3
90
90
1
Store Returns
STORE_RETURNS
0
TPCDS
TPCDS
953066621
954986780
0
0
4
3
91
91
1
Catalog Returns
CATALOG_RETURNS
0
TPCDS
TPCDS
953066972
954986780
0
0
5
3
95
95
1
Catalog Sales
CATALOG_SALES
0
TPCDS
TPCDS
953067688
954986780
0
0
6
3
114
114
1
Store Sales
STORE_SALES
0
TPCDS
TPCDS
954985429
954986780
0
0
7
/END_TABLE AMCSUBM
/BEGIN_TABLE AMCSUBO
@ N5
OID N10
SUBO N10
MODL N10
SUBM N10
NUMR N8
/BEGIN_DATA AMCSUBO
3
50
50
1
86
1
3
270
270
1
86
2
3
308
308
1
86
3
3
1022
1022
1
86
4
3
296
296
1
86
5
3
333
333
1
86
6
3
1143
1143
1
86
7
3
15
15
1
87
8
3
28
28
1
87
9
3
39
39
1
87
10
3
270
270
1
87
11
3
308
308
1
87
12
3
974
974
1
87
13
3
1005
1005
1
87
14
3
1022
1022
1
87
15
3
1031
1031
1
87
16
3
1076
1076
1
87
17
3
1118
1118
1
87
18
3
1351
1351
1
87
19
3
1395
1395
1
87
20
3
1399
1399
1
87
21
3
1403
1403
1
87
22
3
1411
1411
1
87
23
3
1415
1415
1
87
24
3
1423
1423
1
87
25
3
1431
1431
1
87
26
3
1435
1435
1
87
27
3
4511
4511
1
87
28
3
1383
1383
1
87
29
3
4503
4503
1
87
30
3
1419
1419
1
87
31
3
1407
1407
1
87
32
3
7696
7696
1
87
33
3
15
15
1
88
34
3
28
28
1
88
35
3
39
39
1
88
36
3
270
270
1
88
37
3
308
308
1
88
38
3
1005
1005
1
88
39
3
1022
1022
1
88
40
3
1031
1031
1
88
41
3
1076
1076
1
88
42
3
1118
1118
1
88
43
3
1127
1127
1
88
44
3
1260
1260
1
88
45
3
1331
1331
1
88
46
3
1335
1335
1
88
47
3
1299
1299
1
88
48
3
4567
4567
1
88
49
3
1327
1327
1
88
50
3
1315
1315
1
88
51
3
1307
1307
1
88
52
3
1319
1319
1
88
53
3
1303
1303
1
88
54
3
1323
1323
1
88
55
3
1311
1311
1
88
56
3
1295
1295
1
88
57
3
1291
1291
1
88
58
3
4555
4555
1
88
59
3
1339
1339
1
88
60
3
1347
1347
1
88
61
3
1343
1343
1
88
62
3
15
15
1
90
63
3
28
28
1
90
64
3
39
39
1
90
65
3
49
49
1
90
66
3
270
270
1
90
67
3
308
308
1
90
68
3
1118
1118
1
90
69
3
1127
1127
1
90
70
3
1192
1192
1
90
71
3
1227
1227
1
90
72
3
1243
1243
1
90
73
3
1235
1235
1
90
74
3
1231
1231
1
90
75
3
1247
1247
1
90
76
3
1239
1239
1
90
77
3
4575
4575
1
90
78
3
1255
1255
1
90
79
3
29069
29069
1
90
80
3
31055
31055
1
90
81
3
15340
15340
1
90
82
3
30064
30064
1
90
83
3
15
15
1
91
84
3
28
28
1
91
85
3
39
39
1
91
86
3
270
270
1
91
87
3
308
308
1
91
88
3
353
353
1
91
89
3
990
990
1
91
90
3
1022
1022
1
91
91
3
1031
1031
1
91
92
3
1045
1045
1
91
93
3
1118
1118
1
91
94
3
1127
1127
1
91
95
3
1155
1155
1
91
96
3
1147
1147
1
91
97
3
376
376
1
91
98
3
1167
1167
1
91
99
3
372
372
1
91
100
3
1151
1151
1
91
101
3
368
368
1
91
102
3
2801
2801
1
91
103
3
1171
1171
1
91
104
3
1179
1179
1
91
105
3
1183
1183
1
91
106
3
1175
1175
1
91
107
3
1187
1187
1
91
108
3
1159
1159
1
91
109
3
29069
29069
1
91
110
3
15
15
1
95
111
3
28
28
1
95
112
3
39
39
1
95
113
3
270
270
1
95
114
3
308
308
1
95
115
3
974
974
1
95
116
3
990
990
1
95
117
3
1022
1022
1
95
118
3
1031
1031
1
95
119
3
1045
1045
1
95
120
3
1118
1118
1
95
121
3
1468
1468
1
95
122
3
1506
1506
1
95
123
3
1510
1510
1
95
124
3
1514
1514
1
95
125
3
1522
1522
1
95
126
3
1526
1526
1
95
127
3
1534
1534
1
95
128
3
1538
1538
1
95
129
3
1542
1542
1
95
130
3
1546
1546
1
95
131
3
4479
4479
1
95
132
3
4483
4483
1
95
133
3
1502
1502
1
95
134
3
1530
1530
1
95
135
3
1518
1518
1
95
136
3
7692
7692
1
95
137
3
29069
29069
1
95
138
3
15
15
1
114
139
3
28
28
1
114
140
3
39
39
1
114
141
3
49
49
1
114
142
3
270
270
1
114
143
3
308
308
1
114
144
3
974
974
1
114
145
3
1118
1118
1
114
146
3
1550
1550
1
114
147
3
15340
15340
1
114
148
3
1599
1599
1
114
149
3
1579
1579
1
114
150
3
1607
1607
1
114
151
3
1603
1603
1
114
152
3
1595
1595
1
114
153
3
1591
1591
1
114
154
3
1587
1587
1
114
155
3
1583
1583
1
114
156
3
1038
1038
1
114
157
3
986
986
1
114
158
3
982
982
1
114
159
3
80
80
1
114
160
3
76
76
1
114
161
3
29069
29069
1
114
162
3
30064
30064
1
114
163
/END_TABLE AMCSUBO
/BEGIN_TABLE AMCRPRT
@ N5
OID N10
RPRT N10
FLGS N8
NAME A64
DESC A254
TMLT BIN
/BEGIN_DATA AMCRPRT
3
10
10
0
Reduced report
Graphs, columns and annotations
d0cf11e0a1b11ae1000000000000000000000000000000003e000300feff0900060000000000000000000000010000000100000000000000001000000200000002000000feffffff0000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff\
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff\
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff\
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff\
fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffdffffff0400000023000000050000000600000007000000080000000a000000090000000c0000000b0000000e0000000d0000000f0000001000000011000000120000001300000014000000150000001700000016000000\
19000000180000001a0000001b0000001c0000001d0000001e000000200000001f00000021000000220000002400000025000000feffffff2600000027000000280000002a000000290000002b0000002c0000002d0000002e0000002f000000310000003000000032000000330000003400000036000000\
3500000037000000feffffff38000000feffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff\
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff\
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff52006f006f007400200045006e00740072007900000000000000000000000000000000000000000000000000000000000000000000000000\
000000000000000016000500ffffffffffffffff2600000000000000000000000000000000000000000000000000000000000000902938324369bf0103000000c038000000000000310000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000004000101ffffffffffffffff030000000000000000000000000000000000000000000000b09533324369bf01b09533324369bf010000000000000000000000005200500054005f004900540045004d00000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000012000200ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000006d000000000000005200500054005f00500041005200410031000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000140002010200000004000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000020000000a0100000000000001000000feffffff03000000040000000500000006000000\
feffffff08000000090000000a0000000b000000feffffff0d000000feffffff0f000000feffffff11000000120000001300000014000000fefffffffeffffff17000000feffffff19000000feffffff1b0000001c0000001d0000001e000000fefffffffefffffffeffffff22000000feffffff24000000\
250000002600000027000000fefffffffeffffff2a000000feffffff2c000000feffffff2e0000002f0000003000000031000000feffffff33000000340000003500000036000000fefffffffefffffffeffffff3a000000feffffff3c0000003d0000003e0000003f000000fefffffffefffffffeffffff\
43000000feffffff45000000feffffff4700000048000000feffffff4a0000004b0000004c0000004d000000feffffff4f000000500000005100000052000000feffffff54000000550000005600000057000000fefffffffeffffff5a000000feffffff5c0000005d0000005e0000005f000000feffffff\
61000000620000006300000064000000fefffffffeffffff67000000feffffff690000006a0000006b0000006c000000feffffff6e0000006f0000007000000071000000fefffffffeffffff74000000feffffff76000000770000007800000079000000feffffff7b0000007c0000007d0000007e000000\
fefffffffeffffff080049544d53495a450002000000f400090049544d464c414753000400000013000000080049544d54595045000200000002000b0049544d434c53534e4d45000f0000005f5250545f544142434e544e5453000b0049544d4d4f444c4e4d4500090000005f5250545f47454e00000000\
00000000000000000000000000006b00090050415253544154450004000000200000000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000c000a005041524c494e444e54000200000000000a0050415252494e44\
4e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f524500020000000a000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f5244520002000000\
4b000e005041525350545854424f524452000200000001000a005041524e42544142530002000000000010fc7a67bf01d024c867ed68bf0120f9b5037b67bf0120f9b5037b67bf010b0600000000000000080000000000002000000040000000090050415253544154450004000000000000000800504152\
414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152465200500054005f00500041005200410032000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000200ffffffffffffffffffffffff\
000000000000000000000000000000000000000000000000000000000000000000000000070000000a01000000000000320000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400010101000000\
07000000060000000000000000000000000000000000000000000000b09533324369bf01b09533324369bf010000000000000000000000005200500054005f004900540045004d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
12000201ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000000000000c0000006b000000000000003300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
000000000000000004000101ffffffffffffffff140000000000000000000000000000000000000000000000b09533324369bf01501c35324369bf010000000000000000000000004e544847485400020000000a000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000\
000a0050415246494e444e54000200000000000c0050415253504245464f5245000200000000000b0050415253504146544552000200000000000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e0050415253\
50545854424f524452000200000001000a005041524e4254414253000200000000006f00660065007300730069006f006e0061006c0020004c00560050002000530065007400750070002800300030003000330029002e00080049544d53495a4500020000005800090049544d464c414753000400000013\
000000080049544d54595045000200000008000b0049544d434c53534e4d45000d0000005f5250545f5047425245414b000b0049544d4d4f444c4e4d4500090000005f5250545f47454e00006900630065002000320030003000300020005000080049544d53495a450002000000d400090049544d464c41\
4753000400000013000000080049544d5459504500020000000a000b0049544d434c53534e4d4500060000004752415048000b0049544d4d4f444c4e4d4500090000004d50445f43312e30006067bf0138610000000000000062000000000000200000006800000031000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000101ffffffffffffffff0e0000000000000000000000000000000000000000000000b09533324369bf01b09533324369bf010000000000000000000000003100000000000000\
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000101ffffffffffffffff0b0000000000000000000000000000000000000000000000b09533324369bf01b09533324369bf01000000000000000000000000\
5200500054005f004900540045004d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000000000000e000000\
64000000000000005200500054005f005000410052004100310000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000140002010a0000000c000000ffffffff0000000000000000000000000000000000000000000000000000000000000000\
00000000100000000a01000000000000090050415253544154450004000000200001000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000c000a005041524c494e444e54000200000000000a0050415252494e44\
4e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f524500020000000a000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f5244520002000000\
4b000e005041525350545854424f524452000200000001000a005041524e4254414253000200000000000000fefffffffefffffffeffffffb7020000feffffffb9020000ba020000bb020000bc020000fefffffffeffffff12000201ffffffff0600475241464c0002000000000006004752415a4d000200\
0000640008004752415a4d545900020000000000540000006b000000ce0200005200500054005f00080049544d53495a4500020000005800090049544d464c414753000400000013000000080049544d54595045000200000008000b0049544d434c53534e4d45000d0000005f5250545f5047425245414b\
000b0049544d4d4f444c4e4d4500090000005f5250545f47454e00005600000069000000ffffffff5200500054005f005200500054005f0043005500530054004f004d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000201ffffffff\
0d000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000feffffff00000000000000005200500054005f004700520041005000480049004300000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
18000200ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000150000002c000000000000003200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000400010109000000110000000f0000000000000000000000000000000000000000000000b09533324369bf01b09533324369bf010000000000000000000000005200500054005f004900540045004d000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000012000201ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000160000006b000000000000005200500054005f004900540045004d00000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000000000001800000069000000000000005200500054005f00500041005200410031000000000000000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000140002001000000012000000ffffffff0000000000000000000000000000000000000000000000000000000000000000000000001a0000000a010000000000005200500054005f005400490054004c004500000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000014000201ffffffff13000000ffffffff0000000000000000000000000000000000000000000000000000000000000000000000001f00000022000000000000005200500054005f0043004f004e005400\
4e0054005300540042004c000000000000000000000000000000000000000000000000000000000000000000000000001e000200ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000200000000600000000000000080049544d53495a\
450002000000bc00090049544d464c414753000400000077000000080049544d54595045000200000003000b0049544d434c53534e4d45000b0000005f5250545f5449544c45000b0049544d4d4f444c4e4d4500090000005f5250545f47454e0059bf012a0200002b0200002c0200005200500054005f00\
090050415253544154450004000000200001000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000e000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a005041524649\
4e444e54000200000000000c0050415253504245464f524500020000000c000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f5244\
52000200000001000a005041524e42544142530002000000000000007202000073020000feffffff75020000760200007702000078020000fefffffffeffffff7b020000feffffff14000201ffffffff09005449544c544558540013000000476c6f62616c206d6f64656c20677261706800000000000000\
00000000630000000501000000000000090000005441424c0200010002006b027f10020301004e4db8001300902a9802445f43312e3000000000000000000000000000000000000000000000000000000a004c53544e4243080049544d53495a450002000000d400090049544d464c414753000400000013\
000000080049544d5459504500020000000a000b0049544d434c53534e4d4500060000004752415048000b0049544d4d4f444c4e4d4500090000004d50445f43312e300054000200000000000000000000000000000000000900504152535441090050415253544154450004000000200001000800504152\
414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000c000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f5245\
00020000000a000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e42544142530002000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005200500054005f0032000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0400010108000000230000001d0000000000000000000000000000000000000000000000b09533324369bf01501c35324369bf010000000000000000000000003100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
000000000000000004000101ffffffffffffffff170000000000000000000000000000000000000000000000b09533324369bf01501c35324369bf010000000000000000000000005200500054005f004900540045004d000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000012000201ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000000000002100000064000000000000005200500054005f005000410052004100310000000000000000000000000000000000000000000000\
000000000000000000000000000000000000000000000000140002011600000018000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000230000000a010000000000005200500054005f0043005500530054004f004d00000000000000000000000000\
000000000000000000000000000000000000000000000000000000000000000016000201ffffffff19000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000feffffff00000000000000005200500054005f0047005200410050004800490043000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000018000200ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000280000002c0000000000000032000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000100150000001c0000001b0000000000000000000000000000000000000000000000501c35324369bf01501c35324369bf010000000000000000000000005200500054005f00\
4900540045004d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000290000006b00000000000000\
0600475241464c0002000000000006004752415a4d0002000000640008004752415a4d545900020000000000005041524e425441425300020000000000000000080049544d53495a4500020000005800090049544d464c414753000400000013000000080049544d54595045000200000008000b0049544d\
434c53534e4d45000d0000005f5250545f5047425245414b000b0049544d4d4f444c4e4d4500090000005f5250545f47454e0000000000000000000000000000080049544d53495a080049544d53495a4500020000003c01090049544d464c414753000400000077000000080049544d5459504500020000\
0011000b0049544d434c53534e4d4500090000005355424d4f44454c000b0049544d4d4f444c4e4d4500090000004d50445f43312e300000000000000000000000000000000000000900504152535441090050415253544154450004000000200001000800504152414c474e000200000000000b00504152\
464e544e414d450006000000417269616c000b00504152464e544847485400020000000c000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f524500020000000a000b0050415253504146\
544552000200000003000b005041525350424554574e000200000000000a00505200500054005f004900540045004d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff0000000000000000\
000000000000000000000000000000000000000000000000000000002b00000067000000000000005200500054005f005000410052004100310000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000140002011a0000001f000000ffffffff\
0000000000000000000000000000000000000000000000000000000000000000000000002d0000000a010000000000005200500054005f00500041005200410032000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000201ffffffff\
ffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000320000000a010000000000005200500054005f0043005500530054004f004d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
160002001e00000020000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000feffffff00000000000000004152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f52445200020000000100\
0a005041524e425441425300020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000900504152535441090050415253544154450004000000200001000800504152414c474e000200000000000b00504152464e544e414d4500\
06000000417269616c000b00504152464e544847485400020000000e000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f524500020000000c000b00504152535041465445520002000000\
03000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e42544142530002000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000009005041525354410a005355424d444c545854001d0000004772617068206f66207375626d6f64656c20255355424d4f44454c25000b00504152464e544847485200500054005f005200500054005f005300550042004d0044004c0000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000016000201ffffffff21000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000370000002d000000000000005200500054005f0043004f004e005400\
4e0054005300540042004c000000000000000000000000000000000000000000000000000000000000000000000000001e000200ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000000000003800000006000000000000005200500054005f00\
4900540045004d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000390000006900000000000000\
5200500054005f005000410052004100310000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000140002002200000024000000ffffffff0000000000000000000000000000000000000000000000000000000000000000000000003b000000\
0a010000000000000200010002006b02bf0ec2040100ffffb8001300902a9802890000008a000000feffffff8c0000008d0000008e0000008f000000fefffffffeffffff92000000080049544d53495a450002000000bc00090049544d464c414753000400000077000000080049544d5459504500020000\
0003000b0049544d434c53534e4d45000b0000005f5250545f5449544c45000b0049544d4d4f444c4e4d4500090000005f5250545f47454e00000000ae000000af000000b0000000fefffffffeffffff090050415253544154450004000000700001000800504152414c474e000200000000000b00504152\
464e544e414d450006000000417269616c000b00504152464e544847485400020000000e000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f524500020000000c000b0050415253504146\
544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e425441425300020000000000fffff6000000f7000000f8000000\
f9000000fefffffffb000000fc000000fd000000fe000000fefffffffeffffff5400020000000a005200500054005f005400490054004c0045000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000201ffffffff25000000ffffffff\
000000000000000000000000000000000000000000000000000000000000000000000000400000001a000000000000005200500054005f0043004f004e0054004e0054005300540042004c000000000000000000000000000000000000000000000000000000000000000000000000001e000200ffffffff\
ffffffffffffffff00000000000000000000000000000000000000000000000000000000000000000000000041000000060000000000000034000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
04000101050000005e000000520000000000000000000000000000000000000000000000501c35324369bf01902938324369bf010000000000000000000000003100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
000000000000000004000101ffffffffffffffff420000000000000000000000000000000000000000000000501c35324369bf01f0a236324369bf0100000000000000000000000009005449544c54455854000b00000057414d20477261706873000000fffffffffeffffff00000000fffffffffeffffff\
00000000ffffffff140002013f000000020001000200ffff00000000fffffffffeffffff00000000ffffffff000000000000000000000000000000008600000005010000feffffff5200500054005f00080049544d53495a4500020000006800090049544d464c414753000400000013000000080049544d\
54595045000200000008000b0049544d434c53534e4d45000d0000005f5250545f5047425245414b000b0049544d4d4f444c4e4d4500090000005f5250545f47454e00008b00000014010000ffffffff5200500054005f00080049544d53495a4500020000007c01090049544d464c414753000400000033\
000000080049544d5459504500020000000f000b0049544d434c53534e4d45000e0000005441424c434f4c4d4e4c495354000b0049544d4d4f444c4e4d4500090000004d50445f43312e300090000000170000000000000033000000feffffff0a004c53544e42434f4c530002000000070008004c535443\
4f4c53001c0000000100000002000000030000000600000007000000080000001a00000008004c5354464c4753001c0000000500000004000000040000000500000005000000050000000400000008004c535457445448000e000000b0ffd5ff2800ecff0a000a0031000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000101ffffffffffffffff290000000000000000000000000000000000000000000000501c35324369bf01501c35324369bf010000000000000000000000005200500054005f00\
4900540045004d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000420000006b00000000000000\
320000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400010128000000310000002c0000000000000000000000000000000000000000000000501c35324369bf01501c35324369bf0100000000\
00000000000000005200500054005f004900540045004d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000\
00000000440000006c000000000000005200500054005f004c00490053005400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000120002012b0000002e000000ffffffff000000000000000000000000000000000000000000000000\
0000000000000000000000004600000092000000000000005200500054005f00500041005200410031000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000201ffffffffffffffffffffffff00000000000000000000000000000000\
0000000000000000000000000000000000000000490000000a010000000000005200500054005f005000410052004100320000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000140002002d0000002f000000ffffffff0000000000000000\
000000000000000000000000000000000000000000000000000000004e0000000a010000000000005200500054005f00500041005200410033000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000201ffffffff30000000ffffffff\
000000000000000000000000000000000000000000000000000000000000000000000000530000000a01000000000000280008004c5354534f5254000200000000000000760200007702000078020000feffffff00000000000000000000000000000000a402000012000201ffffffff0900504152535441\
54450004000000200001000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000c000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e5400020000\
0000000c0050415253504245464f524500020000000a000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f52445200020000000100\
0a005041524e425441425300020000000000000001000000988c00000000000000000000000000000000000000000000000000009500000005010000000000005200500054005f00090050415253544154450004000000201000000800504152414c474e000200000002000b00504152464e544e414d4500\
06000000417269616c000b00504152464e544847485400020000000a000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f5245000200000000000b00504152535041465445520002000000\
00000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e425441425300020000000000000800504152414c474e000200000002000b00504152\
464e544e414d450001000000000b00504152464e544847485400020000000a00090050415253544154450004000000001000000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000a000a005041524c494e444e54\
000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f5245000200000000000b0050415253504146544552000200000000000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b\
005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e425441425300020000000000000800504152414c474e000200000000000b00504152464e544e414d450001000000000b00504152464e544847485200500054005f005200500054005f00\
43005500530054004f004d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000200ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000580000001b00000000000000\
3300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000101ffffffffffffffff3d0000000000000000000000000000000000000000000000501c35324369bf01f0a236324369bf0100000000\
00000000000000003100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000101ffffffffffffffff340000000000000000000000000000000000000000000000501c35324369bf01501c3532\
4369bf010000000000000000000000005200500054005f004900540045004d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff000000000000000000000000000000000000000000000000\
000000000000000000000000590000006d000000000000000900435553545449544c000c000000436f6c756d6e204c697374004e54000200000000000a0050415246494e444e54000200000000000c005041525350424546080049544d53495a4500020000002c01090049544d464c414753000400000013\
000000080049544d5459504500020000000e000b0049544d434c53534e4d45000f0000005441424c434f4c4d4e414e4e4f54000b0049544d4d4f444c4e4d4500090000004d50445f43312e30005041524e425441425300020000000000000000090050415253544154450004000000200001000800504152\
414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000c000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f5245\
00020000000a000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e42544142530002000000\
0000000800504152414c474e000200000000000b00504152464e544e414d450001000000000b00504152464e544847485200500054005f005200500054005f005000410052004100310000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
140002013300000035000000ffffffff0000000000000000000000000000000000000000000000000000000000000000000000005b0000000a010000000000005200500054005f00500041005200410032000000000000000000000000000000000000000000000000000000000000000000000000000000\
000000000000000014000201ffffffff36000000ffffffff0000000000000000000000000000000000000000000000000000000000000000000000006000000014010000000000005200500054005f0043005500530054004f004d0000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000016000200ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000650000001a0000000000000032000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000004000100320000003c000000390000000000000000000000000000000000000000000000501c35324369bf01f0a236324369bf01000000000000000000000000090050415253544154450004000000000000000800504152414c474e00020000\
0000000b00504152464e544e414d45001000000054696d6573204e657720526f6d616e000b00504152464e544847485400020000000a000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f\
5245000200000003000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e4254414253000200\
00000000000200000000000b00504152464e544e414d45001000000054696d6573204e657720526f6d616e000b0050410900435553545449544c000b000000416e6e6f746174696f6e00000200000000000a0050415252494e444e54000200000000000a0050415246494e444e540002080049544d53495a\
4500020000002c01090049544d464c414753000400000013000000080049544d5459504500020000000e000b0049544d434c53534e4d45000f0000005441424c434f4c4d4e4445534352000b0049544d4d4f444c4e4d4500090000004d50445f43312e300054424f524452000200000001000a005041524e\
5200500054005f004900540045004d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000000000000000000066000000\
6d000000000000005200500054005f00500041005200410031000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000201380000003a000000ffffffff0000000000000000000000000000000000000000000000000000000000000000\
00000000680000000a010000000000005200500054005f00500041005200410032000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000201ffffffff3b000000ffffffff000000000000000000000000000000000000000000000000\
0000000000000000000000006d00000014010000000000005200500054005f0043005500530054004f004d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000200ffffffffffffffffffffffff00000000000000000000000000000000\
0000000000000000000000000000000000000000720000001b00000000000000090050415253544154450004000000200001000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000c000a005041524c494e444e54\
000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f524500020000000a000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b\
005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e425441425300020000000000000000000000000000000000000001000000fc100000c700000080210000d07e0000d87fc502100000000100000014000201ffffffff0900504152535441\
54450004000000000000000800504152414c474e000200000000000b00504152464e544e414d45001000000054696d6573204e657720526f6d616e000b00504152464e544847485400020000000a000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a00504152\
46494e444e54000200000000000c0050415253504245464f5245000200000003000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f\
524452000200000001000a005041524e425441425300020000000000000200000000000b00504152464e544e414d45001000000054696d6573204e657720526f6d616e000b0050410900435553545449544c000c0000004465736372697074696f6e000200000000000a0050415252494e444e5400020000\
0000000a0050415246494e444e540002080049544d53495a4500020000004801090049544d464c414753000400000017000000080049544d5459504500020000000d000b0049544d434c53534e4d45000a0000005441424c434f4c4d4e000b0049544d4d4f444c4e4d4500090000004d50445f43312e3000\
525350545854424f524452000200000001000a005041524e090050415253544154450004000000200001000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000c000a005041524c494e444e54000200000000000a\
0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f524500020000000a000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00505200500054005f004900540045004d000000000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000000000007300000068000000000000005200500054005f005000410052004100\
31000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000201370000003f000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000750000000a010000000000005200500054005f00\
500041005200410032000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000201ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000000000007a0000000a01000000000000\
5200500054005f0043005500530054004f004d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000160002003e00000040000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000feffffff\
00000000000000004152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e425441425300020000000000000800504152414c474e000200000000000b00504152464e544e414d450001000000000b0050\
4152464e544847485400020000000c00090050415253544154450004000000200001000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000e000a005041524c494e444e54000200000000000a0050415252494e44\
4e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f524500020000000c000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f5244520002000000\
4b000e005041525350545854424f524452000200000001000a005041524e425441425300020000000000000800504152414c474e000200000000000b00504152464e544e414d450001000000000b00504152464e544847485400020000000a000b004752505449544c5458540007000000254954454d2500\
494e444e54000200000000000a0050415246494e444e54000200000000000c005200500054005f005200500054005f004700520050005400490054004c004500000000000000000000000000000000000000000000000000000000000000000000000000000000001a000201ffffffff41000000ffffffff\
0000000000000000000000000000000000000000000000000000000000000000000000007f00000018000000000000005200500054005f0043004f004e0054004e0054005300540042004c000000000000000000000000000000000000000000000000000000000000000000000000001e000200ffffffff\
ffffffffffffffff00000000000000000000000000000000000000000000000000000000000000000000000080000000060000000000000034000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
040001012a0000004c000000440000000000000000000000000000000000000000000000f0a236324369bf01f0a236324369bf010000000000000000000000005200500054005f004900540045004d0000000000000000000000000000000000000000000000000000000000000000000000000000000000\
000000000000000012000201ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000810000006800000000000000feffffff82000000feffffff84000000850000008600000087000000feffffff890000008a0000008b0000008c000000\
fefffffffeffffff8f000000feffffff91000000920000009300000094000000feffffff96000000970000009800000099000000fefffffffeffffff9c000000feffffff9e0000009f000000a0000000a1000000feffffffa3000000a4000000a5000000a6000000fefffffffefffffffeffffffaa000000\
feffffffac000000feffffffae000000af000000b0000000b1000000feffffffb3000000b4000000b5000000b6000000feffffffb8000000b9000000ba000000bb000000fefffffffeffffffbe000000feffffffc0000000c1000000c2000000c3000000fefffffffefffffffeffffffc7000000feffffff\
c9000000ca000000cb000000cc000000feffffffce000000cf000000d0000000d1000000feffffffd3000000d4000000d5000000d6000000feffffffd8000000d9000000da000000db000000feffffffdd000000de000000df000000e0000000e1000000fefffffffeffffffffffffffffffffffffffffff\
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0200020001006b023f0a420901004c41\
b8001300902a9802000000080049544d5459504500020000000d000b0049544d434c53534e4d4500080000005441424c080049544d53495a4500020000002c01090049544d464c414753000400000013000000080049544d5459504500020000000e000b0049544d434c53534e4d45000a0000005441424c\
4445534352000b0049544d4d4f444c4e4d4500090000004d50445f43312e300001000000000b00504152464e544847485400020000000c00090050415253544154450004000000200001000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b0050415246\
4e544847485400020000000c000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f524500020000000a000b0050415253504146544552000200000003000b005041525350424554574e0002\
00000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e425441425300020000000000000800504152414c474e000200000000000b00504152464e544e414d450001000000000b0050\
4152464e544847485200500054005f005200500054005f005000410052004100310000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000140002014300000045000000ffffffff000000000000000000000000000000000000000000000000\
000000000000000000000000830000000a010000000000005200500054005f00500041005200410032000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000201ffffffff46000000ffffffff00000000000000000000000000000000\
00000000000000000000000000000000000000008800000014010000000000005200500054005f0043005500530054004f004d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000200ffffffffffffffffffffffff0000000000000000\
000000000000000000000000000000000000000000000000000000008d0000001b000000000000003500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000101ffffffffffffffff49000000\
0000000000000000000000000000000000000000f0a236324369bf01f0a236324369bf01000000000000000000000000090050415253544154450004000000000000000800504152414c474e000200000000000b00504152464e544e414d45001000000054696d6573204e657720526f6d616e000b005041\
52464e544847485400020000000a000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f5245000200000003000b0050415253504146544552000200000003000b005041525350424554574e\
000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e4254414253000200000000006465642041747472696275746520254954454d2500000000000000000000000000000000\
01000100000000000900435553545449544c000c0000004465736372697074696f6e000000000000000000000000000000000000000000000000000000000000080049544d53495a080049544d53495a4500020000002c01090049544d464c414753000400000013000000080049544d5459504500020000\
000e000b0049544d434c53534e4d45000a0000005441424c414e4e4f54000b0049544d4d4f444c4e4d4500090000004d50445f43312e3000000000000000000000000000000000005200500054005f005200500054005f004900540045004d00000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000000000008e00000068000000000000005200500054005f00500041005200410031000000000000000000000000000000\
000000000000000000000000000000000000000000000000000000000000000014000201480000004a000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000900000000a010000000000005200500054005f0050004100520041003200000000000000\
0000000000000000000000000000000000000000000000000000000000000000000000000000000014000201ffffffff4b000000ffffffff0000000000000000000000000000000000000000000000000000000000000000000000009500000014010000000000005200500054005f004300550053005400\
4f004d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000200ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000000000009a0000001a000000000000000900504152535441\
54450004000000200001000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000c000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e5400020000\
0000000c0050415253504245464f524500020000000a000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f52445200020000000100\
0a005041524e42544142530002000000000054000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c005041525350424546090050415253544154450004000000000000000800504152414c474e000200000000000b00504152464e544e414d4500\
1000000054696d6573204e657720526f6d616e000b00504152464e544847485400020000000a000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f5245000200000003000b005041525350\
4146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e425441425300020000000000520041003100000000000000\
000000000000000000000000e3000000050100002c0100005200500054005f000900435553545449544c000b000000416e6e6f746174696f6e00000036010000feffffff38010000390100000000000000000000000000001400020064000000080049544d53495a4500020000004801090049544d464c41\
4753000400000057000000080049544d5459504500020000000d000b0049544d434c53534e4d4500050000005441424c000b0049544d4d4f444c4e4d4500090000004d50445f43312e300000000000000000000000000000000000000000000014000201ffffffff09005041525354415445000400000020\
0001000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000c000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c00504152\
53504245464f524500020000000a000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00505200500054005f004900540045004d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
12000201470000004e000000ffffffff0000000000000000000000000000000000000000000000000000000000000000000000009b00000063000000000000005200500054005f00500041005200410031000000000000000000000000000000000000000000000000000000000000000000000000000000\
000000000000000014000201ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000000000009d0000000a010000000000005200500054005f0050004100520041003200000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000140002004d00000050000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000a20000000a010000000000005200500054005f0043005500530054004f004d000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000016000200ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000feffffff00000000000000004152424f52444552000200000000000b005041525350424f5244520002000000\
4b000e005041525350545854424f524452000200000001000a005041524e425441425300020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000900435553545449090050415253544154450004000000200001000800504152\
414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000e000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f5245\
00020000000c000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e42544142530002000000\
000054000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245460b004752505449544c5458540007000000254954454d250000000003000b005041525350424554574e000200000000000a00504152424f523800000054005f00\
5200500054005f004700520050005400490054004c004500000000000000000000000000000000000000000000000000000000000000000000000000000000001a0002014f00000051000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000a7000000\
18000000000000005200500054005f0043004f004e0054004e0054005300540042004c000000000000000000000000000000000000000000000000000000000000000000000000001e000200ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000\
00000000a80000000c000000000000003200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000101270000005a000000540000000000000000000000000000000000000000000000f0a23632\
4369bf01902938324369bf010000000000000000000000005200500054005f004900540045004d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff00000000000000000000000000000000\
0000000000000000000000000000000000000000a9000000670000000000000005000400050002000300010001000002b8001300902a980241525350545854424f524452000200000001000a005041524e425441425300020000000000000000080049544d53495a4500020000007c01090049544d464c41\
4753000400000073000000080049544d5459504500020000000f000b0049544d434c53534e4d4500090000005441424c4c495354000b0049544d4d4f444c4e4d4500090000004d50445f43312e3000001000000054696d6573204e657720526f6d616e000b0050410a004c53544e42434f4c530002000000\
050008004c5354434f4c530014000000010000000200000003000000040000001600000008004c5354464c47530014000000070000000600000004000000040000000400000008004c535457445448000a0000009cffceff32001400320008004c5354534f525400020000000000000a0900504152535441\
54450004000000200001000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000c000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e5400020000\
0000000c0050415253504245464f524500020000000a000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00505200500054005f004c0049005300540000000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000120002015300000056000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000ab0000007e000000000000005200500054005f0050004100520041003100000000000000000000000000000000000000000000000000000000000000\
0000000000000000000000000000000014000201ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000ad0000000a010000000000005200500054005f005000410052004100320000000000000000000000000000000000000000000000\
000000000000000000000000000000000000000000000000140002005500000057000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000b20000000a010000000000005200500054005f00500041005200410033000000000000000000000000000000\
000000000000000000000000000000000000000000000000000000000000000014000201ffffffff58000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000b70000000a010000000000004152424f52444552000200000000000b005041525350424f\
52445200020000004b000e005041525350545854424f524452000200000001000a005041524e4254414253000200000000000000160100001701000018010000fefffffffefffffffeffffff1c010000feffffff1e0100001f0100002001000021010000feffffff09005041525354415445000400000020\
1000000800504152414c474e000200000002000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000a000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c00504152\
53504245464f5245000200000000000b0050415253504146544552000200000000000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e4254\
41425300020000000000ffff66010000670100006801000069010000feffffff6b0100006c0100006d0100006e010000feffffff700100007101000072010000090050415253544154450004000000001000000800504152414c474e000200000000000b00504152464e544e414d45000600000041726961\
6c000b00504152464e544847485400020000000a000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f5245000200000000000b0050415253504146544552000200000000000b0050415253\
50424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e42544142530002000000000054000200000000000a0050415252494e444e54000200000000000a005041\
5246494e444e54000200000000000c0050415253504245460900435553545449544c000b0000005461626c65204c697374000003000b005041525350424554574e000200000000000a00504152424f524445520002000000080049544d53495a450002000000bc00090049544d464c414753000400000077\
000000080049544d54595045000200000003000b0049544d434c53534e4d45000b0000005f5250545f5449544c45000b0049544d4d4f444c4e4d4500090000005f5250545f47454e000000000000000000000000000000000900504152535441090050415253544154450004000000700001000800504152\
414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152465200500054005f0043005500530054004f004d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016000200ffffffffffffffffffffffff\
000000000000000000000000000000000000000000000000000000000000000000000000bc0000001a000000000000005200500054005f004900540045004d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffff\
ffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000bd00000069000000000000005200500054005f005000410052004100310000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000\
14000200590000005b000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000bf0000000a010000000000005200500054005f005400490054004c0045000000000000000000000000000000000000000000000000000000000000000000000000000000\
000000000000000014000201ffffffff5c000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000c400000021000000000000004e544847485400020000000e000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000\
000a0050415246494e444e54000200000000000c0050415253504245464f524500020000000c000b0050415253504146544552000200000003000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e0050415253\
50545854424f524452000200000001000a005041524e42544142530002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000090043555354544909005449544c5445585400120000005461626c6520496e666f726d6174696f6e\
000000000000000000000000000000000000000000000000080049544d53495a0200020001004801090049544d464c414753000400000037000000080049544d5459504500020000000d000b0049544d434c53534e4d45000a0000005441424c0a00494e464f564552534e00040000008c1300000a00494e\
464f5249454e54000200000001000c00494e464f5041505253495a000200000001000900494e464f4c414e47000200000009040800504152414c474e000200000000000b00504152464e544e414d450001000000000b00504152464e544847485200500054005f005200500054005f0043004f004e005400\
4e0054005300540042004c000000000000000000000000000000000000000000000000000000000000000000000000001e000200ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000c500000006000000000000005200500054005f00\
49004e0046004f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000012000201ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000c60000004b00000000000000\
5200500054005f005000410052004100310000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000140002015d00000060000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000c8000000\
1c010000000000005200500054005f00500041005200410032000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014000201ffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000\
00000000cd000000200100000000000009005041525354415445000400000000c800000800504152414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000a000a005041524c494e444e54000200000000000a0050415252494e44\
4e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f5245000200000000000b0050415253504146544552000200000000000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f5244520002000000\
4b000e005041525350545854424f524452000200000001000a005041524e42544142530002000000010008005041525441425300040000001040000000504152464e544e414d450001000000000b00504152464e544847485400020000000e0009005041525354415445000400000000c200000800504152\
414c474e000200000000000b00504152464e544e414d450006000000417269616c000b00504152464e544847485400020000000a000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f5245\
000200000000000b0050415253504146544552000200000000000b005041525350424554574e000200000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e42544142530002000000\
020008005041525441425300080000003a200000104000000000000000000000000000000000000000000000000000000200020001000000090050415253544154450004000000200f00000800504152414c474e000200000002000b00504152464e544e414d450006000000417269616c000b0050415246\
4e544847485400020000000e000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f524500020000000c000b0050415253504146544552000200000003000b005041525350424554574e0002\
00000000000a00504152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e42544142530002000000000054000200000000000a0050415252494e444e54000200000000000a0050415246494e444e5400\
0200000000000c005041525350424546090050415253544154450004000000000000000800504152414c474e000200000002000b00504152464e544e414d450006000000417269616c000b00504152465200500054005f005000410052004100330000000000000000000000000000000000000000000000\
000000000000000000000000000000000000000000000000140002005f00000062000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000d20000000a010000000000005200500054005f00500041005200410034000000000000000000000000000000\
000000000000000000000000000000000000000000000000000000000000000014000200ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000d70000000a010000000000005200500054005f00540045004d0050004c00410054004500\
000000000000000000000000000000000000000000000000000000000000000000000000000000001a0002016100000063000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000dc0000006d010000000000005200500054005f0043004f004e005400\
4e0054005300540042004c000000000000000000000000000000000000000000000000000000000000000000000000001e000200ffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000e20000000a000000000000004e54484748540002\
0000000a000a005041524c494e444e54000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c0050415253504245464f5245000200000000000b0050415253504146544552000200000000000b005041525350424554574e000200000000000a0050\
4152424f52444552000200000000000b005041525350424f52445200020000004b000e005041525350545854424f524452000200000001000a005041524e42544142530002000000000054000200000000000a0050415252494e444e54000200000000000a0050415246494e444e54000200000000000c00\
5041525350424546080049544d53495a4500020000004404080049544d5459504500020000000100090049544d464c4147530004000000170000000b0049544d434c53534e4d45000e0000005f5250545f54454d504c415445000b0049544d4d4f444c4e4d4500090000005f5250545f47454e000b00544d\
504c54464c41475300040000000d0000000a00544d504c54484541440014000000254d4f44554c452509254d4f444c4e414d4525000a00544d504c54464f4f540027000000506f77657244657369676e6572092544415445250925504147454e414d452520255041474525000a00544d504c545449544c00\
13000000526564756365642057414d205265706f7274000900494e464f4e414d45000f00000052656475636564207265706f7274000900494e464f415554480001000000000900494e464f564552530001000000000a00494e464f444553435200200000004772617068732c20636f6c756d6e7320616e64\
20616e6e6f746174696f6e7300ffffff0000000054005f005200500054005f000400010002000300040054004c0045000000ffffea000000feffffffec000000ed000000ee000000ef000000feffffff14000201ffffffff1a000201ffffffff7e000000ffffffff00000000000000000000000000000000\
0000000000000000000000000000000000000000270100001e000000010000005200500054005f0043004f004e0054004e0054005300540042004c000000000001000000fc100000c700000080210000d07e0000d87fc50210000000010000001e000200ffffffffffffffffffffffffb082000010750000\
d80000000100000030140000000000000000000000000000000000002801000012000000000000003300000054005f0043005500530054004f004d00000000000000000000000000000000000000000000000000040000000000000000000000a8170000e827000004000101ffffffffffffffff80000000\
000000000000000000000000000000000000000070fe77845259bf0170fe77845259bf01be0000001a000000687700000800010002000300
/END_TABLE AMCRPRT
/BEGIN_TABLE AMCSLCT
RPRT N10
MODL N10
LOBJ TXT
/BEGIN_DATA AMCSLCT
/END_TABLE AMCSLCT
/BEGIN_TABLE AMCCNST
@ N5
CNST N10
MODL N10
NAME A30
TYPE A20
VALE A254
RSRV N1
/BEGIN_DATA AMCCNST
/END_TABLE AMCCNST
/BEGIN_TABLE AMCEXAT
@ N5
EXAT N10
MODL N10
NAME A30
TYPE A20
LABL A254
VALE A254
TOBJ N5
RSRV N1
/BEGIN_DATA AMCEXAT
/END_TABLE AMCEXAT
/BEGIN_TABLE AMCEXAV
@ N5
EXAV N10
MODL N10
EXAT N10
VALE A254
OBJT N10
/BEGIN_DATA AMCEXAV
/END_TABLE AMCEXAV
/BEGIN_TABLE PBEDTS
@ N5
EDTN N10
NAME A30
EDIT A254
TYPE N5
CNTR N8
SEQN N5
FLAG N12
RSVD A32
/BEGIN_DATA PBEDTS
/END_TABLE PBEDTS
/BEGIN_TABLE PBFRMT
@ N5
FMTN N10
NAME A30
FRMT A254
TYPE N5
CNTR N8
GENE N8
/BEGIN_DATA PBFRMT
/END_TABLE PBFRMT
/BEGIN_TABLE PBVALD
@ N5
VLDN N10
NAME A30
VALD A254
TYPE N5
CNTR N8
VMSG A254
GENE N8
/BEGIN_DATA PBVALD
/END_TABLE PBVALD
/BEGIN_TABLE AMCFONT
FONT N5
FNAM A32
FSIZ N5
FSTY N5
/BEGIN_DATA AMCFONT
1
Arial
8
0
2
Arial
8
1
3
MS Sans Serif
8
0
4
Arial
8
8
5
Arial
6
0
/END_TABLE AMCFONT
/BEGIN_TABLE AMCPENS
PENS N5
PSTY N5
PCLR N8
PWID N5
/BEGIN_DATA AMCPENS
1
1
0
0
2
1
255
0
3
1
16744703
0
4
1
160
0
5
1
8388672
0
6
1
65280
0
7
1
4194368
0
8
1
16744448
0
9
1
16776960
0
10
1
8388863
0
11
1
16777088
0
12
1
8388736
0
13
1
8388608
0
14
1
8421568
0
15
1
16711808
0
16
1
65535
0
17
1
16744576
0
18
1
65344
0
19
1
65408
0
20
1
16711680
0
21
2
255
0
/END_TABLE AMCPENS
/BEGIN_TABLE AMCBRSH
BRSH N5
BSTY N5
BCLR N8
BHAT N5
/BEGIN_DATA AMCBRSH
1
0
16777215
0
2
0
32896
0
3
0
10197915
0
4
0
10069901
0
5
0
255
0
6
0
0
0
7
0
16744703
0
8
0
160
0
9
0
8388672
0
10
0
65280
0
11
0
4194368
0
12
0
16744448
0
13
0
16776960
0
14
0
8388863
0
15
0
16777088
0
16
0
8388736
0
17
0
8388608
0
18
0
16314027
0
19
0
8421568
0
20
0
16711808
0
21
0
65535
0
22
0
16744576
0
23
0
65344
0
24
0
65408
0
25
0
16744512
0
26
0
16711680
0
27
0
12632256
0
28
0
8454016
0
29
0
33023
0
/END_TABLE AMCBRSH
/BEGIN_TABLE AMCPROP
PROP N5
MODL N10
SUBM N10
SECT A50
NPRO A30
VPRO A80
/BEGIN_DATA AMCPROP
0
1
0
WarehouseArchitect
Shadow
no
1
1
0
WarehouseArchitect
AutoAdjust
yes
2
1
0
WarehouseArchitect
LineStyle
2
3
1
0
WarehouseArchitect
PrnScale
100
4
1
0
WarehouseArchitect
Orientation
1
5
1
0
WarehouseArchitect
LengthName
80
6
1
0
WarehouseArchitect
UpprCaseName
no
7
1
0
WarehouseArchitect
LowrCaseName
no
8
1
0
WarehouseArchitect
AllowAllName
yes
9
1
0
WarehouseArchitect
AllowChrName
<Null>
10
1
0
WarehouseArchitect
InvldChrName
"+-*/\.,!:;"
11
1
0
WarehouseArchitect
NoAccentName
no
12
1
0
WarehouseArchitect
LengthCode
80
13
1
0
WarehouseArchitect
UpprCaseCode
yes
14
1
0
WarehouseArchitect
LowrCaseCode
no
15
1
0
WarehouseArchitect
AllowAllCode
no
16
1
0
WarehouseArchitect
AllowChrCode
'a'-'z', 'A'-'Z', '0'-'9', "_"
17
1
0
WarehouseArchitect
InvldChrCode
<Null>
18
1
0
WarehouseArchitect
NoAccentCode
yes
19
1
0
WarehouseArchitect
NoSplitting
yes
20
1
0
WarehouseArchitect
Truncation
no
21
1
0
WarehouseArchitect
Wrapping
no
22
1
0
WarehouseArchitect
WrapLength
80
23
1
0
WarehouseArchitect
WrapChar
"!""#$%&'()*+,-./:;<=>?@[\]^_`{|}~"
24
1
0
WarehouseArchitect
PdmShowName
no
25
1
0
WarehouseArchitect
PdmShowPrim
yes
26
1
0
WarehouseArchitect
PdmShowColn
no
27
1
0
WarehouseArchitect
PdmShowDttp
no
28
1
0
WarehouseArchitect
PdmShowDomains
no
29
1
0
WarehouseArchitect
PdmShowKeys
no
30
1
0
WarehouseArchitect
PdmShowKeyLevel
no
31
1
0
WarehouseArchitect
PdmShowAkey
no
32
1
0
WarehouseArchitect
PdmShowIdxLevel
no
33
1
0
WarehouseArchitect
PdmShowNull
no
34
1
0
WarehouseArchitect
PdmShowIndx
no
35
1
0
WarehouseArchitect
PdmShowOwnr
no
36
1
0
WarehouseArchitect
PdmShowNameRefr
no
37
1
0
WarehouseArchitect
PdmShowJoinRefr
no
38
1
0
WarehouseArchitect
PdmShowConsRefr
no
39
1
0
WarehouseArchitect
PdmShowCnstRefr
no
40
1
0
WarehouseArchitect
PdmShowIdclRefr
no
41
1
0
WarehouseArchitect
PdmShowCardRefr
no
42
1
0
WarehouseArchitect
PdmShowColnView
no
43
1
0
WarehouseArchitect
PdmShowDttpView
no
44
1
0
WarehouseArchitect
PdmShowExprView
no
45
1
0
WarehouseArchitect
PdmShowTablView
yes
46
1
0
WarehouseArchitect
PdmShowOwnrView
no
47
1
0
WarehouseArchitect
PdmRltnMode
yes
48
1
0
WarehouseArchitect
PdmAutoMigrFkey
yes
49
1
0
WarehouseArchitect
PdmAutoMigrDmn
yes
50
1
0
WarehouseArchitect
PdmAutoMigrChk
yes
51
1
0
WarehouseArchitect
PdmAutoMigrRul
yes
52
1
0
WarehouseArchitect
PdmAutoMigrExa
no
53
1
0
WarehouseArchitect
PdmNonAutoMigrDef
1
54
1
0
WarehouseArchitect
PdmRefrUnique
yes
55
1
0
WarehouseArchitect
PdmColnDmnNoDiv
no
56
1
0
WarehouseArchitect
PdmColnDmnDivInd
1
57
1
0
WarehouseArchitect
PdmDefDttp
58
1
0
WarehouseArchitect
PdmDefMlen
0
59
1
0
WarehouseArchitect
PdmDefPrec
0
60
1
0
WarehouseArchitect
PdmRebuildIndxPK
yes
61
1
0
WarehouseArchitect
PdmRebuildIndxFK
yes
62
1
0
WarehouseArchitect
PdmRebuildIndxAK
yes
63
1
0
WarehouseArchitect
PdmRebuildIndxSK
yes
64
1
0
WarehouseArchitect
PdmRebuildIndxPreserve
no
65
1
0
WarehouseArchitect
PKIndexName
%TABLE%_PK
66
1
0
WarehouseArchitect
FKIndexName
%REFR%_FK
67
1
0
WarehouseArchitect
AKIndexName
%AKEY%_AK
68
1
0
WarehouseArchitect
SKIndexName
%SKEY%_SK
69
1
0
WarehouseArchitect
IndexThreshold
70
1
0
WarehouseArchitect
DwShowSSrv
no
71
1
0
WarehouseArchitect
DwShowLCol
yes
72
1
0
WarehouseArchitect
DwShowLColDttp
yes
73
1
0
WarehouseArchitect
DwShowIQIndx
yes
74
1
0
WarehouseArchitect
DwShowLTblOwnr
yes
75
1
0
WarehouseArchitect
DwShowNameJref
no
76
1
0
WarehouseArchitect
DwShowJoinJref
yes
77
1
0
WarehouseArchitect
DwShowCardJref
no
78
1
0
WarehouseArchitect
Language
1033
79
1
0
WarehouseArchitect
Multidimensional tree
0,1,-1,-1,-1,-1,258,112,680,581
80
1
0
WarehouseArchitect
DBOAltIndex
yes
81
1
0
WarehouseArchitect
DBOAltrIndx
no
82
1
0
WarehouseArchitect
DBOFornIndx
no
83
1
0
WarehouseArchitect
DBOPrimIndx
no
84
1
0
WarehouseArchitect
DBOOthrIndx
no
85
1
0
WarehouseArchitect
DBOConsIOpt
no
86
1
0
WarehouseArchitect
DBOTypeTrgr
0
87
1
0
WarehouseArchitect
DBOAltTrgr
yes
88
1
0
WarehouseArchitect
DBOCreaTrgr
yes
89
1
0
WarehouseArchitect
DBODeltTrgr
yes
90
1
0
WarehouseArchitect
DBODropTrgr
no
91
1
0
WarehouseArchitect
DBOInstTrgr
yes
92
1
0
WarehouseArchitect
DBOUpdtTrgr
yes
93
1
0
WarehouseArchitect
DBOChkC1
yes
94
1
0
WarehouseArchitect
DBOChkC2
yes
95
1
0
WarehouseArchitect
DBOChkC3
yes
96
1
0
WarehouseArchitect
DBOChkC4
yes
97
1
0
WarehouseArchitect
DBOChkC5
yes
98
1
0
WarehouseArchitect
DBOChkC6
yes
99
1
0
WarehouseArchitect
DBOChkC7
yes
100
1
0
WarehouseArchitect
DBOChkC8
yes
101
1
0
WarehouseArchitect
DBOChkC9
yes
102
1
0
WarehouseArchitect
DBOChkC10
yes
103
1
0
WarehouseArchitect
DBOChkC11
yes
104
1
0
WarehouseArchitect
DBOStdMsg
yes
105
1
0
WarehouseArchitect
DBOMsgTab
106
1
0
WarehouseArchitect
DBOMsgNo
107
1
0
WarehouseArchitect
DBOMsgTxt
108
1
0
WarehouseArchitect
DBOAltView
yes
109
1
0
WarehouseArchitect
DBOCreaView
no
110
1
0
WarehouseArchitect
DBODropView
no
111
1
0
WarehouseArchitect
DBOClosDtbs
no
112
1
0
WarehouseArchitect
DBOOpenDtbs
no
113
1
0
WarehouseArchitect
DBOConsAkey
no
114
1
0
WarehouseArchitect
DBOConsChck
yes
115
1
0
WarehouseArchitect
DBOConsTChk
no
116
1
0
WarehouseArchitect
DBOConsCChk
no
117
1
0
WarehouseArchitect
DBOConsDChk
no
118
1
0
WarehouseArchitect
DBOConsDeft
no
119
1
0
WarehouseArchitect
DBOConsFkey
no
120
1
0
WarehouseArchitect
DBOConsIDcl
no
121
1
0
WarehouseArchitect
DBOConsPkey
yes
122
1
0
WarehouseArchitect
DBOConsIDUR
yes
123
1
0
WarehouseArchitect
DBOConsIDUC
no
124
1
0
WarehouseArchitect
DBOConsIDUN
no
125
1
0
WarehouseArchitect
DBOConsIDUD
no
126
1
0
WarehouseArchitect
DBOConsIDDR
yes
127
1
0
WarehouseArchitect
DBOConsIDDC
no
128
1
0
WarehouseArchitect
DBOConsIDDN
no
129
1
0
WarehouseArchitect
DBOConsIDDD
no
130
1
0
WarehouseArchitect
DBOCreaDtbs
no
131
1
0
WarehouseArchitect
DBOCreaProc
yes
132
1
0
WarehouseArchitect
DBODropProc
no
133
1
0
WarehouseArchitect
DBODropDtbs
no
134
1
0
WarehouseArchitect
DBOConsDOpt
no
135
1
0
WarehouseArchitect
DBOConsDBSc
no
136
1
0
WarehouseArchitect
DBOConsDESc
no
137
1
0
WarehouseArchitect
DBODropIndx
no
138
1
0
WarehouseArchitect
DBODropTabl
no
139
1
0
WarehouseArchitect
DBOCreaTabl
yes
140
1
0
WarehouseArchitect
DBOConsTBSc
no
141
1
0
WarehouseArchitect
DBOConsTESc
no
142
1
0
WarehouseArchitect
DBOConsTOpt
no
143
1
0
WarehouseArchitect
DBODrpTmpTbl
yes
144
1
0
WarehouseArchitect
DBOAltTable
yes
145
1
0
WarehouseArchitect
DBOUseTrgUR
no
146
1
0
WarehouseArchitect
DBOUseTrgDR
no
147
1
0
WarehouseArchitect
DBOUseTrgDC
no
148
1
0
WarehouseArchitect
DBOLowrCase
yes
149
1
0
WarehouseArchitect
DBOUpprCase
no
150
1
0
WarehouseArchitect
DBONoAccent
no
151
1
0
WarehouseArchitect
DBOAnsiChar
no
152
1
0
WarehouseArchitect
DBOAddTitle
no
153
1
0
WarehouseArchitect
DBOUseNames
yes
154
1
0
WarehouseArchitect
DBOSqlODBC
no
155
1
0
WarehouseArchitect
DBOChkModl
no
156
1
0
WarehouseArchitect
OLAPFile
157
1
0
WarehouseArchitect
OLAPDbms
158
1
0
WarehouseArchitect
OLAPUseNames
yes
159
1
0
WarehouseArchitect
DBOCreaLTbl
yes
160
1
0
WarehouseArchitect
DBOConsIBSc
yes
161
1
0
WarehouseArchitect
DBOConsIESc
yes
162
1
0
WarehouseArchitect
DBODropLTbl
no
163
1
0
WarehouseArchitect
DBOCreaLCol
yes
164
1
0
WarehouseArchitect
DBODropLCol
no
165
1
0
WarehouseArchitect
DBOCreaJIdx
no
166
1
0
WarehouseArchitect
DBOConsJBSc
no
167
1
0
WarehouseArchitect
DBOConsJESc
no
168
1
0
WarehouseArchitect
DBODropJIdx
no
169
1
0
WarehouseArchitect
DBOCreaIspc
no
170
1
0
WarehouseArchitect
DBODropIspc
no
171
1
0
WarehouseArchitect
DBOUseTrgUC
no
172
1
0
WarehouseArchitect
DBOUseTrgUN
no
173
1
0
WarehouseArchitect
DBOUseTrgUD
no
174
1
0
WarehouseArchitect
DBOUseTrgDN
no
175
1
0
WarehouseArchitect
DBOUseTrgDD
no
176
1
0
WarehouseArchitect
DBOTablComm
no
177
1
0
WarehouseArchitect
DBOViewComm
no
178
1
0
WarehouseArchitect
DBOConsUddt
no
179
1
0
WarehouseArchitect
DBOColnComm
no
180
1
0
WarehouseArchitect
DBOCreaTspc
no
181
1
0
WarehouseArchitect
DBOCreaStor
no
182
1
0
WarehouseArchitect
DBODropTspc
no
183
1
0
WarehouseArchitect
DBODropStor
no
184
1
0
WarehouseArchitect
DBOCreaUddt
no
185
1
0
WarehouseArchitect
DBODropUddt
no
186
1
0
WarehouseArchitect
DBOCreTmpTbl
no
187
1
0
WarehouseArchitect
DBOAltProc
no
188
1
0
WarehouseArchitect
DBOAutoArch
no
189
1
0
WarehouseArchitect
OLAPDef
190
1
0
WarehouseArchitect
OLAPPath
191
1
0
WarehouseArchitect
OLAPData
192
1
0
WarehouseArchitect
OLAPScri
193
1
0
WarehouseArchitect
OLAPExpressScript
yes
194
1
0
WarehouseArchitect
OLAPExpressProgram
yes
195
1
0
WarehouseArchitect
OLAPGeneHeader
yes
196
1
0
WarehouseArchitect
EXTRDef
197
1
0
WarehouseArchitect
DBOUseQualifier
no
198
1
0
WarehouseArchitect
External Sources
0,1,-1,-1,-1,-1,353,246,934,689
199
1
0
WarehouseArchitect
DBOUseUddt
no
200
1
86
WarehouseArchitect
PrnScale
100
201
1
86
WarehouseArchitect
Orientation
1
202
1
86
WarehouseArchitect
NoSplitting
yes
203
1
86
WarehouseArchitect
Truncation
no
204
1
86
WarehouseArchitect
Wrapping
no
205
1
86
WarehouseArchitect
WrapLength
80
206
1
86
WarehouseArchitect
WrapChar
"!""#$%&'()*+,-./:;<=>?@[\]^_`{|}~"
207
1
86
WarehouseArchitect
PdmShowName
yes
208
1
86
WarehouseArchitect
PdmShowPrim
yes
209
1
86
WarehouseArchitect
PdmShowColn
yes
210
1
86
WarehouseArchitect
PdmShowDttp
no
211
1
86
WarehouseArchitect
PdmShowDomains
no
212
1
86
WarehouseArchitect
PdmShowKeys
no
213
1
86
WarehouseArchitect
PdmShowKeyLevel
no
214
1
86
WarehouseArchitect
PdmShowAkey
no
215
1
86
WarehouseArchitect
PdmShowIdxLevel
no
216
1
86
WarehouseArchitect
PdmShowNull
no
217
1
86
WarehouseArchitect
PdmShowIndx
no
218
1
86
WarehouseArchitect
PdmShowOwnr
no
219
1
86
WarehouseArchitect
PdmShowNameRefr
no
220
1
86
WarehouseArchitect
PdmShowJoinRefr
yes
221
1
86
WarehouseArchitect
PdmShowConsRefr
no
222
1
86
WarehouseArchitect
PdmShowCnstRefr
no
223
1
86
WarehouseArchitect
PdmShowIdclRefr
no
224
1
86
WarehouseArchitect
PdmShowCardRefr
no
225
1
86
WarehouseArchitect
PdmShowColnView
no
226
1
86
WarehouseArchitect
PdmShowDttpView
no
227
1
86
WarehouseArchitect
PdmShowExprView
no
228
1
86
WarehouseArchitect
PdmShowTablView
yes
229
1
86
WarehouseArchitect
PdmShowOwnrView
no
230
1
86
WarehouseArchitect
PdmRltnMode
yes
231
1
86
WarehouseArchitect
DwShowSSrv
yes
232
1
86
WarehouseArchitect
DwShowLCol
yes
233
1
86
WarehouseArchitect
DwShowLColDttp
yes
234
1
86
WarehouseArchitect
DwShowIQIndx
yes
235
1
86
WarehouseArchitect
DwShowLTblOwnr
yes
236
1
86
WarehouseArchitect
DwShowNameJref
no
237
1
86
WarehouseArchitect
DwShowJoinJref
yes
238
1
86
WarehouseArchitect
DwShowCardJref
no
239
1
87
WarehouseArchitect
PrnScale
61
240
1
87
WarehouseArchitect
Orientation
1
241
1
87
WarehouseArchitect
NoSplitting
yes
242
1
87
WarehouseArchitect
Truncation
no
243
1
87
WarehouseArchitect
Wrapping
no
244
1
87
WarehouseArchitect
WrapLength
80
245
1
87
WarehouseArchitect
WrapChar
"!""#$%&'()*+,-./:;<=>?@[\]^_`{|}~"
246
1
87
WarehouseArchitect
PdmShowName
yes
247
1
87
WarehouseArchitect
PdmShowPrim
yes
248
1
87
WarehouseArchitect
PdmShowColn
yes
249
1
87
WarehouseArchitect
PdmShowDttp
no
250
1
87
WarehouseArchitect
PdmShowDomains
no
251
1
87
WarehouseArchitect
PdmShowKeys
no
252
1
87
WarehouseArchitect
PdmShowKeyLevel
no
253
1
87
WarehouseArchitect
PdmShowAkey
no
254
1
87
WarehouseArchitect
PdmShowIdxLevel
no
255
1
87
WarehouseArchitect
PdmShowNull
no
256
1
87
WarehouseArchitect
PdmShowIndx
no
257
1
87
WarehouseArchitect
PdmShowOwnr
no
258
1
87
WarehouseArchitect
PdmShowNameRefr
no
259
1
87
WarehouseArchitect
PdmShowJoinRefr
yes
260
1
87
WarehouseArchitect
PdmShowConsRefr
no
261
1
87
WarehouseArchitect
PdmShowCnstRefr
no
262
1
87
WarehouseArchitect
PdmShowIdclRefr
no
263
1
87
WarehouseArchitect
PdmShowCardRefr
no
264
1
87
WarehouseArchitect
PdmShowColnView
no
265
1
87
WarehouseArchitect
PdmShowDttpView
no
266
1
87
WarehouseArchitect
PdmShowExprView
no
267
1
87
WarehouseArchitect
PdmShowTablView
yes
268
1
87
WarehouseArchitect
PdmShowOwnrView
no
269
1
87
WarehouseArchitect
PdmRltnMode
yes
270
1
87
WarehouseArchitect
DwShowSSrv
yes
271
1
87
WarehouseArchitect
DwShowLCol
yes
272
1
87
WarehouseArchitect
DwShowLColDttp
yes
273
1
87
WarehouseArchitect
DwShowIQIndx
yes
274
1
87
WarehouseArchitect
DwShowLTblOwnr
yes
275
1
87
WarehouseArchitect
DwShowNameJref
no
276
1
87
WarehouseArchitect
DwShowJoinJref
yes
277
1
87
WarehouseArchitect
DwShowCardJref
no
278
1
88
WarehouseArchitect
PrnScale
65
279
1
88
WarehouseArchitect
Orientation
1
280
1
88
WarehouseArchitect
NoSplitting
yes
281
1
88
WarehouseArchitect
Truncation
no
282
1
88
WarehouseArchitect
Wrapping
no
283
1
88
WarehouseArchitect
WrapLength
80
284
1
88
WarehouseArchitect
WrapChar
"!""#$%&'()*+,-./:;<=>?@[\]^_`{|}~"
285
1
88
WarehouseArchitect
PdmShowName
yes
286
1
88
WarehouseArchitect
PdmShowPrim
yes
287
1
88
WarehouseArchitect
PdmShowColn
yes
288
1
88
WarehouseArchitect
PdmShowDttp
no
289
1
88
WarehouseArchitect
PdmShowDomains
no
290
1
88
WarehouseArchitect
PdmShowKeys
no
291
1
88
WarehouseArchitect
PdmShowKeyLevel
no
292
1
88
WarehouseArchitect
PdmShowAkey
no
293
1
88
WarehouseArchitect
PdmShowIdxLevel
no
294
1
88
WarehouseArchitect
PdmShowNull
no
295
1
88
WarehouseArchitect
PdmShowIndx
no
296
1
88
WarehouseArchitect
PdmShowOwnr
no
297
1
88
WarehouseArchitect
PdmShowNameRefr
no
298
1
88
WarehouseArchitect
PdmShowJoinRefr
yes
299
1
88
WarehouseArchitect
PdmShowConsRefr
no
300
1
88
WarehouseArchitect
PdmShowCnstRefr
no
301
1
88
WarehouseArchitect
PdmShowIdclRefr
no
302
1
88
WarehouseArchitect
PdmShowCardRefr
no
303
1
88
WarehouseArchitect
PdmShowColnView
no
304
1
88
WarehouseArchitect
PdmShowDttpView
no
305
1
88
WarehouseArchitect
PdmShowExprView
no
306
1
88
WarehouseArchitect
PdmShowTablView
yes
307
1
88
WarehouseArchitect
PdmShowOwnrView
no
308
1
88
WarehouseArchitect
PdmRltnMode
yes
309
1
88
WarehouseArchitect
DwShowSSrv
yes
310
1
88
WarehouseArchitect
DwShowLCol
yes
311
1
88
WarehouseArchitect
DwShowLColDttp
yes
312
1
88
WarehouseArchitect
DwShowIQIndx
yes
313
1
88
WarehouseArchitect
DwShowLTblOwnr
yes
314
1
88
WarehouseArchitect
DwShowNameJref
no
315
1
88
WarehouseArchitect
DwShowJoinJref
yes
316
1
88
WarehouseArchitect
DwShowCardJref
no
317
1
90
WarehouseArchitect
PrnScale
83
318
1
90
WarehouseArchitect
Orientation
1
319
1
90
WarehouseArchitect
NoSplitting
yes
320
1
90
WarehouseArchitect
Truncation
no
321
1
90
WarehouseArchitect
Wrapping
no
322
1
90
WarehouseArchitect
WrapLength
80
323
1
90
WarehouseArchitect
WrapChar
"!""#$%&'()*+,-./:;<=>?@[\]^_`{|}~"
324
1
90
WarehouseArchitect
PdmShowName
yes
325
1
90
WarehouseArchitect
PdmShowPrim
yes
326
1
90
WarehouseArchitect
PdmShowColn
yes
327
1
90
WarehouseArchitect
PdmShowDttp
no
328
1
90
WarehouseArchitect
PdmShowDomains
no
329
1
90
WarehouseArchitect
PdmShowKeys
no
330
1
90
WarehouseArchitect
PdmShowKeyLevel
no
331
1
90
WarehouseArchitect
PdmShowAkey
no
332
1
90
WarehouseArchitect
PdmShowIdxLevel
no
333
1
90
WarehouseArchitect
PdmShowNull
no
334
1
90
WarehouseArchitect
PdmShowIndx
no
335
1
90
WarehouseArchitect
PdmShowOwnr
no
336
1
90
WarehouseArchitect
PdmShowNameRefr
no
337
1
90
WarehouseArchitect
PdmShowJoinRefr
yes
338
1
90
WarehouseArchitect
PdmShowConsRefr
no
339
1
90
WarehouseArchitect
PdmShowCnstRefr
no
340
1
90
WarehouseArchitect
PdmShowIdclRefr
no
341
1
90
WarehouseArchitect
PdmShowCardRefr
no
342
1
90
WarehouseArchitect
PdmShowColnView
no
343
1
90
WarehouseArchitect
PdmShowDttpView
no
344
1
90
WarehouseArchitect
PdmShowExprView
no
345
1
90
WarehouseArchitect
PdmShowTablView
yes
346
1
90
WarehouseArchitect
PdmShowOwnrView
no
347
1
90
WarehouseArchitect
PdmRltnMode
yes
348
1
90
WarehouseArchitect
DwShowSSrv
yes
349
1
90
WarehouseArchitect
DwShowLCol
yes
350
1
90
WarehouseArchitect
DwShowLColDttp
yes
351
1
90
WarehouseArchitect
DwShowIQIndx
yes
352
1
90
WarehouseArchitect
DwShowLTblOwnr
yes
353
1
90
WarehouseArchitect
DwShowNameJref
no
354
1
90
WarehouseArchitect
DwShowJoinJref
yes
355
1
90
WarehouseArchitect
DwShowCardJref
no
356
1
91
WarehouseArchitect
PrnScale
66
357
1
91
WarehouseArchitect
Orientation
1
358
1
91
WarehouseArchitect
NoSplitting
yes
359
1
91
WarehouseArchitect
Truncation
no
360
1
91
WarehouseArchitect
Wrapping
no
361
1
91
WarehouseArchitect
WrapLength
80
362
1
91
WarehouseArchitect
WrapChar
"!""#$%&'()*+,-./:;<=>?@[\]^_`{|}~"
363
1
91
WarehouseArchitect
PdmShowName
yes
364
1
91
WarehouseArchitect
PdmShowPrim
yes
365
1
91
WarehouseArchitect
PdmShowColn
yes
366
1
91
WarehouseArchitect
PdmShowDttp
no
367
1
91
WarehouseArchitect
PdmShowDomains
no
368
1
91
WarehouseArchitect
PdmShowKeys
no
369
1
91
WarehouseArchitect
PdmShowKeyLevel
no
370
1
91
WarehouseArchitect
PdmShowAkey
no
371
1
91
WarehouseArchitect
PdmShowIdxLevel
no
372
1
91
WarehouseArchitect
PdmShowNull
no
373
1
91
WarehouseArchitect
PdmShowIndx
no
374
1
91
WarehouseArchitect
PdmShowOwnr
no
375
1
91
WarehouseArchitect
PdmShowNameRefr
no
376
1
91
WarehouseArchitect
PdmShowJoinRefr
yes
377
1
91
WarehouseArchitect
PdmShowConsRefr
no
378
1
91
WarehouseArchitect
PdmShowCnstRefr
no
379
1
91
WarehouseArchitect
PdmShowIdclRefr
no
380
1
91
WarehouseArchitect
PdmShowCardRefr
no
381
1
91
WarehouseArchitect
PdmShowColnView
no
382
1
91
WarehouseArchitect
PdmShowDttpView
no
383
1
91
WarehouseArchitect
PdmShowExprView
no
384
1
91
WarehouseArchitect
PdmShowTablView
yes
385
1
91
WarehouseArchitect
PdmShowOwnrView
no
386
1
91
WarehouseArchitect
PdmRltnMode
yes
387
1
91
WarehouseArchitect
DwShowSSrv
yes
388
1
91
WarehouseArchitect
DwShowLCol
yes
389
1
91
WarehouseArchitect
DwShowLColDttp
yes
390
1
91
WarehouseArchitect
DwShowIQIndx
yes
391
1
91
WarehouseArchitect
DwShowLTblOwnr
yes
392
1
91
WarehouseArchitect
DwShowNameJref
no
393
1
91
WarehouseArchitect
DwShowJoinJref
yes
394
1
91
WarehouseArchitect
DwShowCardJref
no
395
1
95
WarehouseArchitect
PrnScale
100
396
1
95
WarehouseArchitect
Orientation
1
397
1
95
WarehouseArchitect
NoSplitting
yes
398
1
95
WarehouseArchitect
Truncation
no
399
1
95
WarehouseArchitect
Wrapping
no
400
1
95
WarehouseArchitect
WrapLength
80
401
1
95
WarehouseArchitect
WrapChar
"!""#$%&'()*+,-./:;<=>?@[\]^_`{|}~"
402
1
95
WarehouseArchitect
PdmShowName
yes
403
1
95
WarehouseArchitect
PdmShowPrim
yes
404
1
95
WarehouseArchitect
PdmShowColn
yes
405
1
95
WarehouseArchitect
PdmShowDttp
no
406
1
95
WarehouseArchitect
PdmShowDomains
no
407
1
95
WarehouseArchitect
PdmShowKeys
no
408
1
95
WarehouseArchitect
PdmShowKeyLevel
no
409
1
95
WarehouseArchitect
PdmShowAkey
no
410
1
95
WarehouseArchitect
PdmShowIdxLevel
no
411
1
95
WarehouseArchitect
PdmShowNull
no
412
1
95
WarehouseArchitect
PdmShowIndx
no
413
1
95
WarehouseArchitect
PdmShowOwnr
no
414
1
95
WarehouseArchitect
PdmShowNameRefr
no
415
1
95
WarehouseArchitect
PdmShowJoinRefr
yes
416
1
95
WarehouseArchitect
PdmShowConsRefr
no
417
1
95
WarehouseArchitect
PdmShowCnstRefr
no
418
1
95
WarehouseArchitect
PdmShowIdclRefr
no
419
1
95
WarehouseArchitect
PdmShowCardRefr
no
420
1
95
WarehouseArchitect
PdmShowColnView
no
421
1
95
WarehouseArchitect
PdmShowDttpView
no
422
1
95
WarehouseArchitect
PdmShowExprView
no
423
1
95
WarehouseArchitect
PdmShowTablView
yes
424
1
95
WarehouseArchitect
PdmShowOwnrView
no
425
1
95
WarehouseArchitect
PdmRltnMode
yes
426
1
95
WarehouseArchitect
DwShowSSrv
yes
427
1
95
WarehouseArchitect
DwShowLCol
yes
428
1
95
WarehouseArchitect
DwShowLColDttp
yes
429
1
95
WarehouseArchitect
DwShowIQIndx
yes
430
1
95
WarehouseArchitect
DwShowLTblOwnr
yes
431
1
95
WarehouseArchitect
DwShowNameJref
no
432
1
95
WarehouseArchitect
DwShowJoinJref
yes
433
1
95
WarehouseArchitect
DwShowCardJref
no
434
1
114
WarehouseArchitect
PrnScale
100
435
1
114
WarehouseArchitect
Orientation
1
436
1
114
WarehouseArchitect
NoSplitting
yes
437
1
114
WarehouseArchitect
Truncation
no
438
1
114
WarehouseArchitect
Wrapping
no
439
1
114
WarehouseArchitect
WrapLength
80
440
1
114
WarehouseArchitect
WrapChar
"!""#$%&'()*+,-./:;<=>?@[\]^_`{|}~"
441
1
114
WarehouseArchitect
PdmShowName
yes
442
1
114
WarehouseArchitect
PdmShowPrim
yes
443
1
114
WarehouseArchitect
PdmShowColn
yes
444
1
114
WarehouseArchitect
PdmShowDttp
no
445
1
114
WarehouseArchitect
PdmShowDomains
no
446
1
114
WarehouseArchitect
PdmShowKeys
no
447
1
114
WarehouseArchitect
PdmShowKeyLevel
no
448
1
114
WarehouseArchitect
PdmShowAkey
no
449
1
114
WarehouseArchitect
PdmShowIdxLevel
no
450
1
114
WarehouseArchitect
PdmShowNull
no
451
1
114
WarehouseArchitect
PdmShowIndx
no
452
1
114
WarehouseArchitect
PdmShowOwnr
no
453
1
114
WarehouseArchitect
PdmShowNameRefr
no
454
1
114
WarehouseArchitect
PdmShowJoinRefr
yes
455
1
114
WarehouseArchitect
PdmShowConsRefr
no
456
1
114
WarehouseArchitect
PdmShowCnstRefr
no
457
1
114
WarehouseArchitect
PdmShowIdclRefr
no
458
1
114
WarehouseArchitect
PdmShowCardRefr
no
459
1
114
WarehouseArchitect
PdmShowColnView
no
460
1
114
WarehouseArchitect
PdmShowDttpView
no
461
1
114
WarehouseArchitect
PdmShowExprView
no
462
1
114
WarehouseArchitect
PdmShowTablView
yes
463
1
114
WarehouseArchitect
PdmShowOwnrView
no
464
1
114
WarehouseArchitect
PdmRltnMode
yes
465
1
114
WarehouseArchitect
DwShowSSrv
yes
466
1
114
WarehouseArchitect
DwShowLCol
yes
467
1
114
WarehouseArchitect
DwShowLColDttp
yes
468
1
114
WarehouseArchitect
DwShowIQIndx
yes
469
1
114
WarehouseArchitect
DwShowLTblOwnr
yes
470
1
114
WarehouseArchitect
DwShowNameJref
no
471
1
114
WarehouseArchitect
DwShowJoinJref
yes
472
1
114
WarehouseArchitect
DwShowCardJref
no
473
1
0
WarehouseArchitect
TSTDefNumbProf
474
1
0
WarehouseArchitect
TSTDefCharProf
475
1
0
WarehouseArchitect
TSTDefDateProf
476
1
0
WarehouseArchitect
TSTDelOldData
no
477
1
0
WarehouseArchitect
TSTDefNbRec
50
478
1
0
WarehouseArchitect
TSTCommitType
0
479
1
0
WarehouseArchitect
TSTPackNbRec
0
480
1
0
WarehouseArchitect
TSTCsvFrmt
no
/END_TABLE AMCPROP
/BEGIN_TABLE AMCSYMB
@ N5
SID N10
TSYM N5
SSYM N8
NUMR N8
CSID N10
SID1 N10
SID2 N10
CLND N10
CLNN N5
RCX1 N8
RCY1 N8
RCX2 N8
RCY2 N8
PENS N5
BRSH N5
CTXT N8
FONT N5
JUST N5
WOVL N8
HOVL N8
SARR N5
CARR N5
TARR N5
NBPT N8
LSPT BIN
LSTY N5
TEXT TXT
PICT PIC
BTMP BMP
GRPH N10
OID N10
OLE BIN
/BEGIN_DATA AMCSYMB
3
4
289
128
1
0
0
0
0
1
-60719
-11977
-52245
-8453
2
1
0
0
0
0
0
0
0
0
0
0
1
15
3
8
289
128
2
0
0
0
0
1
-63264
9640
-54490
13164
2
1
0
0
0
0
0
0
0
0
0
0
1
28
3
9
289
128
3
0
0
0
0
1
-43490
1788
-36441
5315
2
1
0
0
0
0
0
0
0
0
0
0
1
39
3
11
289
128
4
0
0
0
0
1
-45924
-26043
-39100
-22519
2
1
0
0
0
0
0
0
0
0
0
0
1
49
3
12
289
0
5
0
0
0
0
0
-65815
-17250
-55691
-21601
2
15
0
0
0
0
0
0
0
0
0
0
1
50
3
186
289
128
6
0
0
0
0
1
-52848
-18889
-47149
-15365
2
1
0
0
0
0
0
0
0
0
0
0
1
270
3
226
289
128
7
0
0
0
0
1
-46695
-4778
-40471
-8302
2
1
0
0
0
0
0
0
0
0
0
0
1
308
3
282
289
0
8
0
0
0
0
0
-57453
95476
-47554
99000
2
15
0
0
0
0
0
0
0
0
0
0
1
353
3
647
289
0
9
0
0
0
0
0
-37004
-14303
-29880
-10779
2
1
0
0
0
0
0
0
0
0
0
0
1
974
3
862
289
128
10
0
0
0
0
1
-38151
21556
-26677
25080
2
1
0
0
0
0
0
0
0
0
0
0
1
990
3
873
289
128
11
0
0
0
0
1
-75630
-24220
-66181
-20696
2
1
0
0
0
0
0
0
0
0
0
0
1
1005
3
884
289
128
12
0
0
0
0
1
-76407
14254
-66883
17778
2
1
0
0
0
0
0
0
0
0
0
0
1
1022
3
890
289
128
13
0
0
0
0
1
-79589
19016
-69915
22540
2
1
0
0
0
0
0
0
0
0
0
0
1
1031
3
924
289
128
14
0
0
0
0
1
-68887
31059
-58313
34583
2
1
0
0
0
0
0
0
0
0
0
0
1
1045
3
940
289
128
15
0
0
0
0
1
-78695
-18941
-71496
-15417
2
1
0
0
0
0
0
0
0
0
0
0
1
1076
3
1198
289
128
16
0
0
0
0
1
-33314
-1032
-27314
-4559
2
1
0
0
0
0
0
0
0
0
0
0
1
1118
3
1199
289
0
17
0
0
0
0
0
-28722
63414
-21298
66941
2
1
0
0
0
0
0
0
0
0
0
0
1
1127
3
1444
289
0
18
0
0
0
0
0
-38563
43598
-28514
40074
2
15
0
0
0
0
0
0
0
0
0
0
1
1192
3
1496
289
0
19
0
0
0
0
0
-77011
68059
-66962
71583
2
15
0
0
0
0
0
0
0
0
0
0
1
1260
3
1578
289
0
20
0
0
0
0
0
-78005
-6161
-67956
-2637
2
15
0
0
0
0
0
0
0
0
0
0
1
1351
3
1676
289
0
21
0
0
0
0
0
-54805
23155
-44906
26679
2
15
0
0
0
0
0
0
0
0
0
0
1
1468
3
1795
289
0
22
0
0
0
0
0
-33878
-29662
-23829
-26138
2
15
0
0
0
0
0
0
0
0
0
0
1
1550
3
2946
289
64
23
0
0
0
226
2
-32848
71749
-26624
68225
2
1
0
0
0
0
0
0
0
0
0
0
1
308
3
2951
289
64
24
0
0
0
4
2
-61457
65136
-52983
68660
2
1
0
0
0
0
0
0
0
0
0
0
1
15
3
2952
289
64
25
0
0
0
1198
2
-45940
59110
-39940
62637
2
1
0
0
0
0
0
0
0
0
0
0
1
1118
3
2953
289
64
26
0
0
0
8
2
-54611
77483
-45837
81007
2
1
0
0
0
0
0
0
0
0
0
0
1
28
3
2954
289
64
27
0
0
0
186
2
-23215
75973
-17516
79497
2
1
0
0
0
0
0
0
0
0
0
0
1
270
3
2955
289
64
28
0
0
0
9
2
-42815
71510
-35766
75037
2
1
0
0
0
0
0
0
0
0
0
0
1
39
3
2956
289
64
29
0
0
0
884
2
-71939
96916
-62415
100440
2
1
0
0
0
0
0
0
0
0
0
0
1
1022
3
2957
289
64
30
0
0
0
940
2
-70523
51567
-63324
55091
2
1
0
0
0
0
0
0
0
0
0
0
1
1076
3
2959
289
64
31
0
0
0
890
2
-76975
91511
-67301
95035
2
1
0
0
0
0
0
0
0
0
0
0
1
1031
3
2961
289
64
32
0
0
0
862
2
-42586
102236
-31112
105760
2
1
0
0
0
0
0
0
0
0
0
0
1
990
3
2962
289
64
33
0
0
0
11
2
-50962
45762
-44138
49286
2
1
0
0
0
0
0
0
0
0
0
0
1
49
3
2964
289
64
34
0
0
0
873
2
-77281
47399
-67832
50923
2
1
0
0
0
0
0
0
0
0
0
0
1
1005
3
2965
289
64
35
0
0
0
924
2
-74350
102238
-63776
105762
2
1
0
0
0
0
0
0
0
0
0
0
1
1045
3
27777
289
0
36
0
0
0
0
0
-24697
-5108
-14348
-1584
2
1
0
0
0
0
0
0
0
0
0
0
1
15340
3
77211
289
128
37
0
0
0
0
1
-25928
655
-18879
4180
2
1
0
0
0
0
0
0
0
0
0
0
1
29069
3
84800
289
0
38
0
0
0
0
0
-53414
112190
-44565
115714
2
1
0
0
0
0
0
0
0
0
0
0
1
38739
3
86066
289
64
39
0
0
0
77211
2
-56504
54842
-49455
58366
2
1
0
0
0
0
0
0
0
0
0
0
1
29069
/END_TABLE AMCSYMB
/BEGIN_TABLE AMCSUBG
@ N5
SUBG N10
SUBM N10
SGID N10
/BEGIN_DATA AMCSUBG
0
46453
86
0
0
47788
87
0
0
49410
88
0
0
53257
90
0
0
55413
91
0
0
63369
95
0
0
76437
114
0
/END_TABLE AMCSUBG
/BEGIN_TABLE AMCSUBS
@ N5
SID N10
TSYM N5
SSYM N8
NUMR N8
CSID N10
SID1 N10
SID2 N10
CLND N10
CLNN N5
RCX1 N8
RCY1 N8
RCX2 N8
RCY2 N8
PENS N5
BRSH N5
CTXT N8
FONT N5
JUST N5
WOVL N8
HOVL N8
SARR N5
CARR N5
TARR N5
NBPT N8
LSPT BIN
LSTY N5
TEXT TXT
PICT PIC
BTMP BMP
GRPH N10
OID N10
OLE BIN
/BEGIN_DATA AMCSUBS
3
46454
289
514
1
0
0
0
0
0
-8556
10459
1343
5133
2
1
0
0
0
0
0
0
0
0
0
0
46453
50
3
46455
289
514
2
0
0
0
0
0
-20547
-31554
-10799
-3194
2
1
0
0
0
0
0
0
0
0
0
0
46453
270
3
46456
289
514
3
0
0
0
0
0
5224
-3338
16697
-32136
2
1
0
0
0
0
0
0
0
0
0
0
46453
308
3
46457
289
514
4
0
0
0
0
0
5633
16157
14153
31965
2
1
0
0
0
0
0
0
0
0
0
0
46453
1022
3
47789
289
512
5
0
0
0
0
0
30582
16249
39281
30351
2
1
0
0
0
0
0
0
0
0
0
0
47788
15
3
47790
289
512
6
0
0
0
0
0
30387
-10060
40062
8916
2
1
0
0
0
0
0
0
0
0
0
0
47788
28
3
47791
289
512
7
0
0
0
0
0
28869
36247
42292
47947
2
1
0
0
0
0
0
0
0
0
0
0
47788
39
3
47792
289
512
8
0
0
0
0
0
-43025
9307
-31851
35107
2
1
0
0
0
0
0
0
0
0
0
0
47788
270
3
47793
289
512
9
0
0
0
0
0
-36387
-24219
-24915
-52663
2
1
0
0
0
0
0
0
0
0
0
0
47788
308
3
47794
289
512
10
0
0
0
0
0
-39776
-15325
-31078
3621
2
1
0
0
0
0
0
0
0
0
0
0
47788
974
3
47795
289
512
11
0
0
0
0
0
30987
-32316
40436
-18215
2
1
0
0
0
0
0
0
0
0
0
0
47788
1005
3
47796
289
512
12
0
0
0
0
0
-42576
41036
-34056
56844
2
1
0
0
0
0
0
0
0
0
0
0
47788
1022
3
47797
289
512
13
0
0
0
0
0
-6560
43586
1180
51254
2
1
0
0
0
0
0
0
0
0
0
0
47788
1031
3
47798
289
512
14
0
0
0
0
0
8648
-8839
18547
16963
2
1
0
0
0
0
0
0
0
0
0
0
47788
1076
3
47799
289
512
15
0
0
0
0
0
-1160
-27091
4989
-38715
2
1
0
0
0
0
0
0
0
0
0
0
47788
1118
3
47800
289
512
16
0
0
0
0
0
-15543
-9210
-4144
27316
2
1
0
0
0
0
0
0
0
0
0
0
47788
1351
3
49411
289
512
17
0
0
0
0
0
-26607
-46268
-17907
-32166
2
1
0
0
0
0
0
0
0
0
0
0
49410
15
3
49412
289
512
18
0
0
0
0
0
-36222
6786
-26548
25762
2
1
0
0
0
0
0
0
0
0
0
0
49410
28
3
49413
289
512
19
0
0
0
0
0
-35434
-10938
-24185
-736
2
1
0
0
0
0
0
0
0
0
0
0
49410
39
3
49414
289
512
20
0
0
0
0
0
25877
25932
37051
51733
2
1
0
0
0
0
0
0
0
0
0
0
49410
270
3
49415
289
512
21
0
0
0
0
0
26490
5757
35565
-22969
2
1
0
0
0
0
0
0
0
0
0
0
49410
308
3
49416
289
512
22
0
0
0
0
0
-5571
-39321
3878
-25220
2
1
0
0
0
0
0
0
0
0
0
0
49410
1005
3
49417
289
512
23
0
0
0
0
0
-35401
34732
-26701
49808
2
1
0
0
0
0
0
0
0
0
0
0
49410
1022
3
49418
289
512
24
0
0
0
0
0
-17047
43293
-8797
50569
2
1
0
0
0
0
0
0
0
0
0
0
49410
1031
3
49419
289
512
25
0
0
0
0
0
12736
-47190
22635
-21389
2
1
0
0
0
0
0
0
0
0
0
0
49410
1076
3
49420
289
512
26
0
0
0
0
0
28037
22524
34186
11348
2
1
0
0
0
0
0
0
0
0
0
0
49410
1118
3
49421
289
512
27
0
0
0
0
0
6065
44417
12739
48769
2
1
0
0
0
0
0
0
0
0
0
0
49410
1127
3
49422
289
512
28
0
0
0
0
0
-3887
-130
8637
34446
2
1
0
0
0
0
0
0
0
0
0
0
49410
1260
3
53258
289
512
29
0
0
0
0
0
19450
-29758
30323
-12004
2
1
0
0
0
0
0
0
0
0
0
0
53257
15
3
53259
289
512
30
0
0
0
0
0
-12997
-38868
-2347
-13719
2
1
0
0
0
0
0
0
0
0
0
0
53257
28
3
53260
289
512
31
0
0
0
0
0
3007
-16977
16430
-5505
2
1
0
0
0
0
0
0
0
0
0
0
53257
39
3
53261
289
512
32
0
0
0
0
0
19572
-3416
29994
26928
2
1
0
0
0
0
0
0
0
0
0
0
53257
49
3
53262
289
512
33
0
0
0
0
0
-29319
-41537
-19571
-15697
2
1
0
0
0
0
0
0
0
0
0
0
53257
270
3
53263
289
512
34
0
0
0
0
0
-29234
14440
-17761
-14444
2
1
0
0
0
0
0
0
0
0
0
0
53257
308
3
53264
289
512
35
0
0
0
0
0
16459
40306
22608
28982
2
1
0
0
0
0
0
0
0
0
0
0
53257
1118
3
53265
289
512
36
0
0
0
0
0
-28345
34669
-22165
39769
2
1
0
0
0
0
0
0
0
0
0
0
53257
1127
3
53266
289
512
37
0
0
0
0
0
-4177
29479
5571
7578
2
1
0
0
0
0
0
0
0
0
0
0
53257
1192
3
79769
289
512
38
0
0
0
0
0
6028
-34259
17702
-28110
2
1
0
0
0
0
0
0
0
0
0
0
53257
29069
3
81514
289
512
39
0
0
0
0
0
22353
-40590
30552
-36341
2
1
0
0
0
0
0
0
0
0
0
0
53257
15340
3
55414
289
512
40
0
0
0
0
0
15915
15722
24615
29824
2
1
0
0
0
0
0
0
0
0
0
0
55413
15
3
55415
289
512
41
0
0
0
0
0
27053
-2733
36727
16243
2
1
0
0
0
0
0
0
0
0
0
0
55413
28
3
55416
289
512
42
0
0
0
0
0
10279
-10721
23701
1169
2
1
0
0
0
0
0
0
0
0
0
0
55413
39
3
55417
289
512
43
0
0
0
0
0
-14302
-48892
-3128
-23090
2
1
0
0
0
0
0
0
0
0
0
0
55413
270
3
55418
289
512
44
0
0
0
0
0
-36236
26916
-24764
-1910
2
1
0
0
0
0
0
0
0
0
0
0
55413
308
3
55419
289
512
45
0
0
0
0
0
-10233
6165
641
34891
2
1
0
0
0
0
0
0
0
0
0
0
55413
353
3
55420
289
512
46
0
0
0
0
0
17980
39652
29379
50828
2
1
0
0
0
0
0
0
0
0
0
0
55413
990
3
55421
289
512
47
0
0
0
0
0
-32240
34398
-23541
49474
2
1
0
0
0
0
0
0
0
0
0
0
55413
1022
3
55422
289
512
48
0
0
0
0
0
-13860
43446
-5386
51306
2
1
0
0
0
0
0
0
0
0
0
0
55413
1031
3
55423
289
512
49
0
0
0
0
0
-29517
-49656
-20368
-18980
2
1
0
0
0
0
0
0
0
0
0
0
55413
1045
3
55424
289
512
50
0
0
0
0
0
-31630
-5001
-25481
-16425
2
1
0
0
0
0
0
0
0
0
0
0
55413
1118
3
55425
289
512
51
0
0
0
0
0
1187
47626
7861
52410
2
1
0
0
0
0
0
0
0
0
0
0
55413
1127
3
80654
289
512
52
0
0
0
0
0
16228
-23710
27927
-17409
2
1
0
0
0
0
0
0
0
0
0
0
55413
29069
3
63370
289
512
53
0
0
0
0
0
14931
18964
25804
34926
2
1
0
0
0
0
0
0
0
0
0
0
63369
15
3
63371
289
512
54
0
0
0
0
0
14990
-5658
25639
18292
2
1
0
0
0
0
0
0
0
0
0
0
63369
28
3
63372
289
512
55
0
0
0
0
0
229
33373
13652
22623
2
1
0
0
0
0
0
0
0
0
0
0
63369
39
3
63373
289
512
56
0
0
0
0
0
-25609
-32963
-15861
-7303
2
1
0
0
0
0
0
0
0
0
0
0
63369
270
3
63374
289
512
57
0
0
0
0
0
-25553
24278
-16631
-4606
2
1
0
0
0
0
0
0
0
0
0
0
63369
308
3
63375
289
512
58
0
0
0
0
0
15585
-35261
24283
-15885
2
1
0
0
0
0
0
0
0
0
0
0
63369
974
3
63376
289
512
59
0
0
0
0
0
-4462
-33681
6937
-22505
2
1
0
0
0
0
0
0
0
0
0
0
63369
990
3
63377
289
512
60
0
0
0
0
0
-13572
17834
-4873
32910
2
1
0
0
0
0
0
0
0
0
0
0
63369
1022
3
63378
289
512
61
0
0
0
0
0
-25590
26842
-17850
34010
2
1
0
0
0
0
0
0
0
0
0
0
63369
1031
3
63379
289
512
62
0
0
0
0
0
-14162
-35092
-5013
-4416
2
1
0
0
0
0
0
0
0
0
0
0
63369
1045
3
63380
289
512
63
0
0
0
0
0
7232
-23071
13381
-34773
2
1
0
0
0
0
0
0
0
0
0
0
63369
1118
3
63381
289
512
64
0
0
0
0
0
-4357
-15880
6892
20646
2
1
0
0
0
0
0
0
0
0
0
0
63369
1468
3
80649
289
512
65
0
0
0
0
0
14290
-15833
25963
-8735
2
1
0
0
0
0
0
0
0
0
0
0
63369
29069
3
76438
289
512
66
0
0
0
0
0
3915
-29396
13139
-13345
2
1
0
0
0
0
0
0
0
0
0
0
76437
15
3
76439
289
512
67
0
0
0
0
0
16002
-4413
25676
14563
2
1
0
0
0
0
0
0
0
0
0
0
76437
28
3
76440
289
512
68
0
0
0
0
0
3377
7204
14627
17405
2
1
0
0
0
0
0
0
0
0
0
0
76437
39
3
76441
289
512
69
0
0
0
0
0
-7864
5541
836
34267
2
1
0
0
0
0
0
0
0
0
0
0
76437
49
3
76443
289
512
70
0
0
0
0
0
15666
-35179
25804
-9411
2
1
0
0
0
0
0
0
0
0
0
0
76437
270
3
76444
289
512
71
0
0
0
0
0
-25736
35043
-17818
5914
2
1
0
0
0
0
0
0
0
0
0
0
76437
308
3
76446
289
512
72
0
0
0
0
0
-25553
-34310
-16854
-15334
2
1
0
0
0
0
0
0
0
0
0
0
76437
974
3
76453
289
512
73
0
0
0
0
0
-15666
25986
-10067
14978
2
1
0
0
0
0
0
0
0
0
0
0
76437
1118
3
76458
289
512
74
0
0
0
0
0
-11818
-25195
-1993
-1344
2
1
0
0
0
0
0
0
0
0
0
0
76437
1550
3
76461
289
512
75
0
0
0
0
0
16809
28874
25008
33122
2
1
0
0
0
0
0
0
0
0
0
0
76437
15340
3
79150
289
512
76
0
0
0
0
0
2277
27819
13976
21518
2
1
0
0
0
0
0
0
0
0
0
0
76437
29069
/END_TABLE AMCSUBS