A
Account balances
ACCOUNT BALANCES entity
Accounting
ACCOUNTING PERIOD entity
ACCOUNTING PERIOD TYPE entity
ACCOUNTING TRANSACTION entity
ACCOUNTING TRANSACTION TYPE entity
account number attribute
acctg period num attribute
ACQUIRING ITEM entity
ACTIVITY entity
ACTIVITY REQUEST entity
actual arrival datetime attribute
actual completion datetime attribute
actual employer paid percentage attribute
actual from date attribute
actual hours attribute
actual ship cost attribute
actual start datetime attribute
actual thru date attribute
add delete flag attribute
addendum creation date attribute
addendum effective date attribute
ADDENDUM entity
addendum text attribute
address1 attribute
address2 attribute
ADDRESSES dimension
address_id
address_line1
address_line2
ADJUSTMENT ITEM entity
ADJUSTMENT TYPE entity
affected by attribute
age
AGENT entity
AGREEMENT entity
orders and
AGREEMENT EXHIBIT entity
AGREEMENT GEOGRAPHICAL APPLICABILITY
entity
AGREEMENT ITEM entity
Agreement item prices, table of
Agreement items
AGREEMENT ITEM TERMS entity
AGREEMENT ORGANIZATION APPLICABILITY
entity
AGREEMENT PRICE COMPONENT entity
Agreement pricing
AGREEMENT PRICING PROGRAM entity
AGREEMENT PRODUCT APPLICABILITY entity
AGREEMENT PRODUCT TYPE APPLICABILITY
entity
AGREEMENT ROLE entity
AGREEMENT ROLE TYPE entity
Agreements
in data models
defined
table of
AGREEMENT SECTION entity
AGREEMENT TERM entity
Agreement terms
table of
AGREEMENT TYPE entity
alias name attribute
allocated cost attribute
AMORTIZATION entity
amount
amount attribute
amount change attribute
ANSI-compliant databases
Anticipated demand, work effort and
Applications, in data models
approved date attribute
Architected data warehouses
arising from attribute
Arrays, of data
Artifacts
Asset depreciation
asset ID attribute
Associated transactions, of invoices
ASSOCIATION entity
Asterisk (*), with mandatory keys
Atomic level
Attributes
of entities
mandatory
naming conventions for
optional
in unique identifiers
available from date attribute
available thru date attribute
available time attribute
average age
average annual pay
average years employed
average_years_experience
B
Backorders
Balancing accounts
BANK ACCOUNT entity
BANKING CARD entity
bank name attribute
BASE PRICE entity
BASE PRODUCT PRICE entity
benefit percent attribute
Benefits, for employees
BENEFIT TYPE entity
billed from attribute
billed to attribute
billed_to_contact_mechanism
billed_to_customer_id
Billing
BILLING ACCOUNT entity
BILLING ACCOUNT ROLE entity
BILLING ACCOUNT ROLE TYPE entity
BILLING FEATURE entity
BILL OF LADING entity
BILL TO CUSTOMER entity
defined during transaction
Bill-to parties, contact mechanisms for
BILL TO PURCHASER entity
birthdate attribute
blood type attribute
BRAND [NAME] entity
Buckets, in accounting
BUDGET_DETAILS table
budgeted amount attribute
BUDGET entity
budget ID attribute
Budgeting
BUDGET ITEM entity
BUDGET ITEM SCENARIO entity
BUDGET ITEM TYPE entity
BUDGET REVIEW entity
BUDGET REVIEW RESULT TYPE entity
Budget reviews
BUDGET REVISION entity
BUDGET REVISION IMPACT entity
Budget revisions
BUDGET ROLE entity
BUDGET ROLE TYPE entity
BUDGET SCENARIO APPLICATION entity
BUDGET SCENARIO entity
BUDGET SCENARIO RULE entity
Budget scenarios
BUDGET STATUS entity
BUDGET STATUS TYPE entity
BUDGET TYPE entity
BUILDING entity
BUSINESS ENTITY CONTACT METHOD entity
BUSINESS ENTITY CONTACT METHOD PURPOSE entity
BUSINESS ENTITY CONTACT PURPOSE entity
BUSINESS ENTITY entity
BUSINESS ENTITY ROLE TYPE entity
Business phone numbers, in data models
Business problems, Universal Data Models and
Business processes
table of
Business transactions, 267. See also Transactions
C
CAPITAL BUDGET entity
CAPITALIZATION entity
CARD entity
Cardinality, of relationships
Career paths
CARRIER entity
CARRIER SHIPMENT METHOD entity
CASE (Computer-Aided Systems Engineering) tools
CASE entity
CASE ROLE entity
CASE ROLE TYPE entity
CASE STATUS TYPE entity
Categories
multiple
of products
table of product
category_description
CD-ROM
Cell phone numbers, in data models
CERTIFICATION entity
Chart of accounts, creating
Chen, Peter
CITIZENSHIP entity
CITY entity
city_name
claim date attribute
Classifications, of subtypes
Cleansing of data
Code, in attribute names
COLOR entity
comment attribute
for products
comments attribute
Commitments, against budgets
committed quantity going out attribute
Common party relationships, in data models
COMMUNICATION EVENT entity
follow-ups for
Communication event follow-ups
in data models
table of
COMMUNICATION EVENT PURPOSE entity
COMMUNICATION EVENT PURPOSE TYPE entity
COMMUNICATION EVENT ROLE entity
COMMUNICATION EVENT ROLE TYPE entity
Communication events. See Party communication events
COMMUNICATION EVENT STATUS TYPE entity
COMMUNICATION EVENT WORK EFFORT entity
COMPETITOR entity
composed of attribute
comprised of attribute
CONFERENCE entity
confirmation number attribute
Connectedness, in holistic system development
Consulting, on database design
contacted via relationship
CONTACT entity
Contact information
in customer relationship management
in data models
CONTACT MECHANISM entity
order roles and
contact mechanism id attribute
CONTACT MECHANISM LINK entity
CONTACT MECHANISM PURPOSE TYPE entity
contact mechanism purpose type id attribute
CONTACT MECHANISM TYPE entity
CONTACT MECHANISM TYPE FORMAT entity
CONTACT METHOD entity
contact method id attribute
CONTACT METHOD PURPOSE TYPE entity
CONTACT METHOD RELATIONSHIP entity
CONTACT METHOD TYPE entity
CONTACT METHOD TYPE FORMAT entity
CONTACT TYPE entity
CONTAINER entity
CONTAINER TYPE entity
CONTRACTOR entity
conversion factor attribute
Corporate data models
Corporations, as organizations
corresponding PO ID attribute
cost attribute
COST CENTER entity
COST COMPONENT TYPE entity
Costing, of products
COUNTRY entity
country_name
COUNTY CITY entity
COUNTY entity
CREDIT CARD entity
CREDIT LINE entity
CREDIT MEMO entity
credit_rating
Crowsfoot notation
CURRENCY MEASURE entity
current first name attribute
current last name attribute
current middle name attribute
current passport number attribute
CUSTOMER_ADDRESSES table
CUSTOMER CONTACT METHOD entity
CUSTOMER CONTACT METHOD PURPOSE entity
CUSTOMER_DEMOGRAPHICS dimension
customer_demographics_id
CUSTOMER_DEMOGRAPHICS table
CUSTOMER entity
contact mechanisms for
defined during transaction
in standard order model
customer_id
customer id attribute
CUSTOMER_INVOICES dimension
CUSTOMER_INVOICES table
customer_name
CUSTOMER RELATIONSHIP entity
Customer relationship management
CUSTOMER_REP_SALES dimension
CUSTOMER REQUIREMENT entity
CUSTOMER RETURN entity
CUSTOMER_SALES dimension
CUSTOMER SALES table
CUSTOMERS dimension
CUSTOMER SERVICE CALL entity
CUSTOMER SHIPMENT entity
CUSTOMERS table
CUSTOMER TYPE entity
customer type id attribute
CUSTOMER_TYPES table
Customizing data models
D
Data. See also Transformation of data
adding derived
arrays of
cleansing of
granularity of
merging tables of
removing operational
slices of
stability of
in system integration
Database administrator (DBA)
Database management systems (DBMSs)
Databases
designing
Universal Data Models for
Data development professionals
Data extraction
Data marts
product analysis with
sales analysis with
sales rep performance analysis with
Data models, 1-2. See also Data warehouses; Universal Data Models
for accounting and budgeting
added to second edition (table)
CD-ROM and
human resources in
integrating corporate
for invoicing
need for
notational conventions for
order adjustments within
for ordering products
organizations in
people in
products in
for shipping products
in this book
Data warehouses
architecture of
departmental
designing
enterprise data model and
maintaining data in
sample
star schema designs for
transforming enterprise data model into
date acquired attribute
date hired attribute
date last serviced attribute
date next service attribute
date sent attribute
datetime attribute
datetime ended attribute
datetime received attribute
datetime started attribute
day
debit/credit flag attribute
Decision support system (DSS)
DEDUCTION entity
DEDUCTION TYPE entity
DEGREE entity
DELIVERABLE entity
DELIVERABLE TYPE entity
Departmental data warehouses
DEPARTMENT entity
DEPLOYMENT USAGE entity, defined during transaction
DEPOSIT entity
Deposits, tracking of
Depreciation
DEPRECIATION entity
DEPRECIATION METHOD entity
DEPT entity
Derived data, adding
described by attribute
description
Description, in attribute names
description attribute
for party relationships
for party roles
for persons
for products
in TYPE entities
designated to be billed to attribute designated to be installed at attribute,
designated to be shipped to attribute
DESIRED FEATURE entity
DIMENSION entity
Dimensions, in star schema
directions attribute
DISBURSEMENT ACCTG TRANS entity
DISBURSEMENT entity
DISCOUNT ADJUSTMENT entity
DISCOUNT COMPONENT entity
DISTRIBUTION CHANNEL entity
DISTRIBUTION CHANNEL RELATIONSHIP entity
DISTRIBUTOR entity
DIVISION entity
DOCUMENT entity
Documents, for shipments
DOCUMENT TYPE entity
Double quotes (“), with illustration tables
DROP SHIPMENT entity
E
EEOC (Equal Employment Opportunity Commission)
EEOC (Equal Employment Opportunity Commission) CLASSIFICATION entity
eeoc_type_id
EEOC_TYPES dimension
effective date attribute
ELECTRONIC ADDRESS entity
facilities and
EMAIL ADDRESS entity
E-mail addresses, in data models
EMAIL COMMUNICATION entity
EMP DEPT model
EMP entity
emp id attribute
EMPLOYEE entity
employee id attribute
EMPLOYEE PERFORMANCE REVIEW entity
Employees
applications from
benefits for
in data models
payrolls for
performance of
salaries for
termination of
EMPLOYEES table
EMPLOYER entity
employer paid percentage attribute
EMPLOYMENT AGREEMENT entity
EMPLOYMENT APPLICATION entity
EMPLOYMENT APPLICATION SOURCE TYPE entity
EMPLOYMENT APPLICATION STATUS TYPE entity
EMPLOYMENT entity
emp name attribute
end mileage attribute
END USER CUSTOMER entity
defined during transaction
Enterprise data models
data warehouses and
transforming into data warehouse
Universal Data Models and
Enterprises. See also Organizations
accounting by
budgeting by
CASE efforts for
database models for
Enterprises (Cont.)
defined
invoicing by
product costing by
product ordering by
product pricing by
products of
requirements of
sample data warehouse for
Universal Data Models for
Entities, 8. See also Subtypes; Supertypes
attributes of
in changing from enterprise data model
in exclusive arcs
foreign keys in
intersection
notational conventions for
organization
for people
relationships between
“Entity-Relationship Modeling” (Chen)
entry date attribute
EQUIPMENT entity
estimated arrival date attribute
estimated arrival datetime attribute
estimated budget attribute
estimated cost attribute
ESTIMATED COST COMPONENT entity
estimated delivery date attribute
estimated duration attribute
estimated from date attribute
estimated hours attribute
ESTIMATED LABOR COST entity
ESTIMATED MATERIALS COST entity
estimated num people attribute
ESTIMATED OTHER COSTS entity
ESTIMATED PRODUCT COST COMPONENT entity
ESTIMATED PRODUCT COST entity
Estimated product costs, table of
estimated quantity attribute
estimated ready date attribute
estimated ship cost attribute
estimated ship date attribute
estimated start datetime attribute
estimated thru date attribute
Exclusive arcs, of relationships
EXPORT DOCUMENTATION entity
extended amount
EXTERNAL ACCTG TRANS entity
Extracting of data
F
FACE TO FACE COMMUNICATION entity
Facilities, in data models
FACILITY CONTACT MECHANISM entity
FACILITY entity
inventorying and
with product suppliers
FACILITY ROLE entity
FACILITY ROLE TYPE entity
FACILITY TYPE entity
Fact tables
Families, as organizations
FAMILY MEMBER entity
FAX COMMUNICATION entity
Fax numbers, in data models
FEATURE INTERACTION DEPENDENCY entity
FEATURE INTERACTION INCOMPATIBILITY entity
federal tax ID
for ORGANIZATION entities
in subtypes and supertypes
FEE entity
Figure references, conventions for
FINANCIAL ACCOUNT ADJUSTMENT entity
FINANCIAL ACCOUNT entity
FINANCIAL ACCOUNT ROLE entity
FINANCIAL ACCOUNT ROLE TYPE entity
Financial accounts
star schema design for managing
tracking of
FINANCIAL ACCOUNT TRANSACTION entity
FINANCIAL ACCOUNT TYPE entity
FINANCIAL TERM entity
FINISHED GOOD entity
first_name
FIRST NAME entity
first string format attribute
fiscal_year
FIXED ASSET DEPRECIATION METHOD entity
FIXED ASSET entity
Fixed assets, work effort and
FIXED ASSET TYPE entity
Flag, in attribute names
flat amount attribute
FLOOR entity
for attribute
Foreign keys
inheritance of
formula attribute
for the hours of attribute
freight amount attribute
freight charge attribute
from date
in attribute names
from date attribute
from datetime attribute
from day attribute
from quantity attribute
fuel used attribute
G
gender attribute
GENDER dimension
gender id
GENDER TYPE entity
GENERAL LEDGER ACCOUNT entity
general ledger account ID attribute
GENERAL LEDGER ACCOUNT TYPE entity
General ledgers
budgets and
types of
Generating work efforts
Generic order parties, contact mechanisms for
GEOGRAPHIC_BOUNDARIES table
GEOGRAPHIC BOUNDARY ASSOCIATION entity
GEOGRAPHIC BOUNDARY entity
GEOGRAPHIC BOUNDARY TYPE entity
geo_id
GL ACCOUNT TYPE entity
GL BUDGET XREF entity
GOOD entity
GOOD IDENTIFICATION entity
Goods
in PRODUCT entity
Government agencies, as organizations
Granularity, of data
gross sales
H
handling instructions attribute
HARDWARE FEATURE entity
HAZARDOUS MATERIALS DOCUMENT entity
Hierarchies
of employment
of party relationships
High-level models
Holistic approach, to systems development
hours attribute
HOUSEHOLD entity
Human resources
benefits for
in data models
described
employment applications of
employment of
monitoring performance of
salaries for
standard model for
star schema designs for
termination and
tracking of
HUMAN_RESOURCES_FACT table
HUMAN_RESOURCES_SUMMARY_FACT table
I
id attribute, in TYPE entities
Identification codes, for products
IDENTIFICATION TYPE entity
ID string, in attribute names
ID value attribute
Illustration tables, conventions for
INCENTIVE entity
INCOME CLASSIFICATION entity
INCOMING SHIPMENT entity
Ind, in attribute names
INDUSTRY CLASSIFICATION entity
Informal organizations
Information systems (IS) industry, database design in
Inheritance, of foreign keys
INQUIRY entity
INSTALLATION CUSTOMER entity
instruction attribute
INSTRUCTION entity
Integration
of data
of systems
INTERNAL ACCOUNTING TRANSACTION entity
INTERNAL ACCTG TRANS entity
INTERNAL_ORG_ADDRESSES table
INTERNAL ORGANIZATION CONTACT entity
INTERNAL ORGANIZATION entity
internal_organization_id
internal organization ind attribute
internal_organization_name
INTERNAL ORGANIZATIONS dimension
INTERNAL REQUIREMENT entity
INTERNAL TRANSACTION entity
International product pricing
Intersection entities
introduction date attribute
Inventories
anticipated demand and
of products
star schema design for managing
work effort and
INVENTORY ITEM entity
INVENTORY ITEM FACT entity
Inventory items, table of
INVENTORY ITEM STATUS entity
INVENTORY ITEM STATUS TYPE entity
INVENTORY ITEM VARIANCE entity
INVENTORY STATUS entity
INVESTMENT ACCOUNT entity
INVOICE ACQUIRING ITEM entity
INVOICE ADJUSTMENT entity
invoice date
invoice date attribute
INVOICE DISCOUNT ADJUSTMENT entity
INVOICE entity
defined during transaction
INVOICE FEE entity
invoice_id
INVOICE ITEM entity
invoice_item_id
invoice_item_seq_id
INVOICE ITEM TYPE entity
INVOICE MISCELLANEOUS CHARGE entity
INVOICE PAYMENT APPLICATION entity
INVOICE PAYMENT ITEM APPLICATION entity
INVOICE PRODUCT FEATURE ITEM entity
INVOICE PRODUCT ITEM entity
INVOICE ROLE entity
INVOICE ROLE TYPE entity
INVOICE SALES TAX entity
INVOICE SHIPPING AND HANDLING CHARGE entity
INVOICE STATUS entity
INVOICE STATUS TYPE entity
INVOICE SURCHARGE ADJUSTMENT entity
INVOICE TERM entity
INVOICE TIME ENTRY ITEM entity
INVOICE WORK EFFORT ITEM entity
Invoicing
accounting and
from associated transactions
data models for
roles for
status of
terms for
tracking payments and
IP ADDRESS entity
ISBN (International Standard Book Number)
ISBN entity
issue date attribute
issued from attribute
item description attribute
ITEM ISSUANCE entity
ITEM ISSUANCE ROLE entity
ITEM ISSUANCE ROLE TYPE entity
Item issuances
for outgoing shipments
table of
ITEM VARIANCE ACCTG TRANS entity
ITEM VARIANCE entity
J
JOB entity
Job sharing
justification attribute
K
Keys. See also Foreign keys; Primary key
adding time element to
in changing from enterprise data model
L
last contact date attribute
last_name
LAST NAME entity
last updated attribute
Legal organizations
LEGAL TERM entity
LENGTH OF SERVICE dimension
LETTER CORRESPONDENCE entity
level_name
level_org_type
Levels, of supertypes
Libraries, of data models
load_date
LOCATIONS entity
Logical data models
building
examples of
LOT entity
lot ids attribute
M
MAINTENANCE entity
MANAGER entity
manager_rep_first_name
manager_rep_id
manager_rep_last_name
Mandatory attributes
Mandatory relationships
MANIFEST entity
manufactured by relationship
MANUFACTURER ID entity
Manufacturers, of products
MANUFACTURER SUGGESTED PRICE entity
Many-to-many relationships
marital status
MARITAL STATUS entity
MARITAL STATUS TYPE entity
MARKETING PACKAGING entity
MARKET INTEREST entity
maximum amount attribute
Measures
MEETING entity
Merging tables
message attribute
Mid-level models
MINORITY CLASSIFICATION entity
MISCELLANEOUS CHARGE entity
month
month_id
MONTHLY_TIME_PERIODS dimension
mother's maiden name attribute
Multiple categories
N
Name, in attribute names
name
for ORGANIZATION entities
in subtypes and supertypes
name attribute
for products
Non-mutually exclusive subtypes
NON-SERIALIZED INVENTORY ITEM entity
non-solicitation indicator attribute
note attribute
NOTE entity
number of employees
O
OBLIGATION ACCTG TRANS entity
OBLIGATION entity
obtained via attribute
o character, with optional keys
OFFICE entity
ONE TIME CHARGE entity
One-to-many relationships
One-to-one relationships
on-hand amount attribute
on-hand quantity attribute
Online transaction processing (OLTP) systems
OPERATING BUDGET entity
Operational data, removing
Optional attributes
OPTIONAL FEATURE entity
optional ind attribute
Optional order models
agreements in
quotes in
requests in
requirements in
Optional relationships
ORDER ADJUSTMENT entity
Order adjustments
ORDER ADJUSTMENT TYPE entity
ORDER CONTACT MECHANISM entity
order date attribute
ordered for attribute
ordered quantity expected in attribute
ordered with attribute
ORDER entity
in agreements
defined during transaction
order adjustments and
shipments and
order ID attribute
foreign keys and
Ordering. See also Purchase orders; Sales orders
data models and
work requirements and
ORDER ITEM ASSOCIATION entity
ORDER ITEM BILLING entity
ORDER ITEM CONTACT MECHANISM entity
ORDER ITEM entity
order adjustments and
ORDER ITEM ROLE entity
order item seq id attribute
ORDER LINE ITEM entity
ORDER REQUIREMENT COMMITMENT entity
ORDER REQUIREMENT entity
ORDER ROLE entity
Order roles
party contact mechanisms and
table of
ORDER ROLE TYPE entity
Orders. See also Purchase orders; Sales orders
billing for
shipment of
ORDER SHIPMENT entity
Order status
ORDER STATUS entity
ORDER STATUS TYPE entity
ORDER TERM entity
Order terms
ORDER TERMS entity
ORDER VALUE entity
ORGANIZATION CLASSIFICATION entity
ORGANIZATION CONTACT RELATIONSHIP entity
ORGANIZATION dimension
ORGANIZATION entity
in communication events
in PARTY entity
ORGANIZATION GL ACCOUNT BALANCE entity
ORGANIZATION GL ACCOUNT entity
organization_id
organization id attribute
organization name attribute
ORGANIZATION ROLE entity
Organization roles, in data models
ORGANIZATION ROLLUP entity, 40-43
Organizations. See also Enterprises
in data models
defined
designing databases for
general ledgers for
holistic system development for
sales orders by
subsidiaries of
subtypes of (table)
ORGANIZATIONS dimension
Organization-to-organization party relationships
table of
ORGANIZATION TYPE entity
ORGANIZATION UNIT entity
org_type
OTHER AGREEMENT entity
OTHER AGREEMENT TERM entity
OTHER ASSET entity
OTHER FEATURE entity
OTHER FIXED ASSET entity
OTHER ID entity
OTHER INTERNAL ACCTG TRANS entity
OTHER OBLIGATION entity
OTHER ORGANIZATION UNIT entity
OTHER QUOTE entity
OTHER SHIPPING DOCUMENT entity
OUTGOING SHIPMENT entity
Outgoing shipments
“Over time,” in relationships
P
PACKAGING CONTENT entity
PACKAGING SLIP entity
Pager numbers, in data models
PARENT ORGANIZATION entity
PART BOM (bill of materials) entity
PART CONTACT MECHANISM entity
PART entity
Parties. See also Organizations; People; Persons
in data models
table of
PARTNER entity
PARTNERSHIP AGREEMENT entity
PARTNERSHIP entity
part of relationship
Parts, products and
PARTY ASSET ASSIGN STATUS TYPE entity
PARTY BENEFIT entity
PARTY CLASSIFICATION entity
PARTY COMMUNICATION EVENT entity
Party communication events
in data models
table of
Party contact information. See Contact information
PARTY CONTACT MECHANISM entity
facilities and
PARTY CONTACT MECHANISM PURPOSE entity
Party contact mechanisms
bill-to party in
in data models
expanded
facilities versus
generic orders and
order roles and
purchase orders and
purposes for
sales orders and
shipments and
standard order model and
table of
PARTY entity
in accounting
in agreements
in billing
in budgets
in communication events
contact mechanisms and
facilities and
in financial transactions
in fixed asset assignment
in invoicing
order roles and
in party contact mechanisms
in payments
payrolls and
in position fulfillment
postal addresses and
quotes and
in requests
shipments and
skills and
in work effort assignment
work requirement roles and
PARTY FACILITY entity
PARTY FIXED ASSET ASSIGNMENT entity
party_id
party id attribute
PARTY NAME entity
Party order roles
table of
Party placing order, contact mechanism for
PARTY POSTAL ADDRESS entity
Party postal addresses, in data models
PARTY QUALIFICATION entity
PARTY RATE entity
PARTY RELATIONSHIP entity
communication events and
subtypes of
Party relationships
in data models
table of
PARTY RELATIONSHIP STATUS TYPE entity
PARTY RELATIONSHIP TYPE entity
party relationship type id attribute
party rel type id attribute
PARTY ROLE entity
in communication events
subtypes of
party role id attribute
Party roles
in data models
defined during transaction
examples of
examples of (table)
table of
PARTY ROLE TYPE entity
PARTY SKILL entity
PARTY STATUS entity
PARTY table
Party taking order, contact mechanism for
PARTY TYPE entity
PARTY WORK REQUIREMENT ROLE entity
PASSPORT entity
passport expiration date attribute
PAYCHECK entity
PAY GRADE dimension
PAY GRADE entity
PAY HISTORY entity
PAYMENT ACCTG TRANS entity
PAYMENT APPLICATION entity
PAYMENT BUDGET ALLOCATION entity
PAYMENT entity
payment ID attribute
PAYMENT METHOD TYPE entity
payment ref num attribute
Payments
against budgets
tracking of
PAYROLL PREFERENCE entity
Payrolls
People, in data models
percentage attribute
percentage change attribute
percent attribute
percent contribution attribute
PERFORMANCE NOTE entity
PERFORMANCE REVIEW entity
PERFORMANCE REVIEW ITEM entity
PERF REVIEW ITEM TYPE entity
PERIOD TYPE entity
PERSON CLASSIFICATION entity
PERSON entity
in communication events
in PARTY entity
postal addresses and
person id attribute
PERSON ID entity
PERSON NAME entity
PERSON NAME TYPE entity
PERSON ROLE entity
Person roles
in data models
for orders
Persons. See also People
in data models
data on (table)
PERSON SKILL entity
Person-to-organization party relationships
table of
Person-to-person party relationships
table of
PERSON TRAINING entity
PHASE entity
PHONE COMMUNICATION entity
PHONE NUMBER entity
PHYSICAL CHARACTERISTIC entity
PHYSICAL CHARACTERISTIC TYPE entity
Physical database designs
basic principles for
creating
examples of
physical inventory date attribute
PICKLIST entity
PICKLIST ITEM entity
placed by attribute
placed using attribute
PLACING BUYER entity
PLACING CUSTOMER entity
PLACING PARTY entity
PLANT entity
PORT CHARGES DOCUMENT entity
position attribute
position class
POSITION CLASSIFICATION TYPE entity
POSITION entity
POSITION FULFILLMENT entity
position ID attribute
POSITION REPORTING STRUCTURE entity
POSITION RESPONSIBILITY entity
Positions, for employees
POSITIONS table
POSITION STATUS TYPE entity
position type
POSITION TYPE CLASS entity
POSITION TYPE entity
position_type_id
position type ID attribute
POSITION TYPE RATE entity
POSITION_TYPES dimension
POSTAL ADDRESS BOUNDARY entity
POSTAL ADDRESS entity
in contact mechanisms
facilities and
Postal address information
in contact mechanisms
in data models
POSTAL CODE entity
PREFERENCE TYPE entity
PREFERRED CONTACT TIME entity
preferred name attribute
price attribute
PRICE COMPONENT entity
Pricing
international
of products
table for product
primary_flag
primary flag attribute
Primary key
of entities
primary supplier name attribute
PRIORITY TYPE entity
Process models
PRODUCT AGREEMENT entity
Product analysis data mart
PRODUCT ASSOCIATION entity
PRODUCT ASSOCIATION TYPE entity
PRODUCT_CATEGORIES table
PRODUCT CATEGORY CLASSIFICATION entity
PRODUCT CATEGORY entity
product_category_id
PRODUCT CATEGORY ROLLUP entity
PRODUCT CLASSIFICATION CATEGORY entity
PRODUCT COMPATIBILITY entity
PRODUCT COMPLEMENT entity
PRODUCT COMPONENT entity
Product components, table of
product_cost
PRODUCT COST COMPONENT entity
product description
PRODUCT dimension
PRODUCT entity
categories for
with features
with identification codes
in product costing
in product pricing
in product-to-product associations
in standard order model
PRODUCT FEATURE APPLICABILITY entity
PRODUCT FEATURE CATEGORY entity
PRODUCT FEATURE entity
subtypes of
PRODUCT FEATURE INTERACTION entity
Product features
examples of
interactions of
subtypes of
table of
units of measure for
PRODUCT HISTORY table
product_id
product id attribute
PRODUCT INCOMPATIBILITY entity
PRODUCT INDUSTRY CATEGORIZATION entity
production capacity attribute
PRODUCTION RUN entity
PRODUCT MATERIALS CATEGORIZATION entity
PRODUCT OBSOLESCENCE entity
PRODUCT ORDER ITEM entity
PRODUCT PACKAGING entity
PRODUCT PRICE COMPONENT entity
PRODUCT QUALITY entity
PRODUCT QUOTE entity
PRODUCT REQUIREMENT entity
Products
associations among
categories of
costing of
in data models
defined
identification codes for
inventorying of
manufacturers of
ordering
parts and
pricing of
suppliers of
table for pricing
table of
PRODUCT_SALES dimension
PRODUCTS dimension
PRODUCT SNAPSHOT entity
PRODUCT_SNAPSHOTS table
PRODUCTS table
PRODUCT SUBSTITUTE entity
Product-to-product associations
PRODUCT TYPE entity
PRODUCT USAGE CATEGORIZATION entity
PROGRAM entity
PROJECT entity
promised order shipment date attribute
PROPERTY entity
PROPOSAL entity
PROSPECT entity
PROVINCE entity
PURCHASE AGREEMENT entity
PURCHASE INVOICE entity
PURCHASE INVOICE ITEM entity
PURCHASE_INVOICES table
PURCHASE ORDER entity
PURCHASE ORDER FACT entity
PURCHASE ORDER ITEM entity
PURCHASE ORDER LINE ITEM entity
Purchase order parties, contact mechanisms for
Purchase order roles, table of
Purchase orders
contact mechanisms for
data models for
star schema design for managing
table of
PURCHASE RETURN entity
PURCHASE SHIPMENT entity
purpose attribute
Purposes, for party contact mechanisms
Q
QUALIFICATION TYPE entity
quantity
quantity accepted attribute
quantity attribute
QUANTITY BREAK entity
quantity damaged attribute
quantity on hand attribute
quantity produced attribute
quantity rejected attribute
quantity to produce attribute
quantity used attribute
quarter
QUOTE entity
QUOTE ITEM entity
Quote items
table of
QUOTE ROLE entity
Quote roles
QUOTE ROLE TYPE entity
Quotes
in data models
table of
QUOTE TERM entity
Quote terms
R
range
RANGE TYPE entity
rate attribute
RATE entity
Rates, for work effort
RATE TYPE entity
rating attribute
RATING entity
RATING TYPE entity
RAW MATERIAL entity
reason attribute
REASON entity
RECEIPT ACCTG TRANS entity
RECEIPT entity
Receipts, for shipments
receiving contact number for attribute
RECURRING CHARGE entity
Recursive relationships
Reference tables
REGION entity
REGULATORY AGENCY entity
REJECTION REASON entity
Relational database management systems (RDBMSs)
Relationship artifacts
creating
described
Relationships, 12. See also Party relationships
cardinality of
in data models
between entities
exclusive arcs of
mandatory
many-to-many
one-to-many
one-to-one
optional
recursive
REORDER GUIDELINE entity
reorder level attribute
reorder quantity attribute
Reporting structure, in employment
request date attribute
REQUEST entity
REQUEST ITEM entity
Request items
table of
request item seq ID attribute
request required date attribute
REQUEST ROLE entity
REQUEST ROLE TYPE entity
Requests
in data models
table of
required by date attribute
REQUIRED FEATURE entity
REQUIREMENT BUDGET ALLOCATION entity
requirement creation date attribute
REQUIREMENT entity
REQUIREMENT ITEM BUDGET ALLOCATION entity
REQUIREMENT REQUEST entity
REQUIREMENT ROLE entity
REQUIREMENT ROLE TYPE entity
Requirements
in data models
defined
table of
REQUIREMENT STATUS entity
REQUIREMENT STATUS TYPE entity
REQUIREMENT TYPE entity
Requisitions
RESEARCH entity
RESPONDING PARTY entity
RESPONSIBILITY TYPE entity
RESPONSIBLE PARTY entity
RESPONSIBLE PERSON entity
RESUME entity
review date attribute
revised amount attribute
revision reason attribute
revision seq attribute
RFI (request for information) entity
RFP (request for proposal) entity
RFQ (request for quote) entity
Roles. See Organization roles; Party roles; Person roles
ROLE TYPE entity
role type id attribute
ROOM entity
Routing, of shipments
routing number attribute
S
Salaries
SALARY STEP entity
SALE ORDER ITEM entity
SALES ACCTG TRANS entity
SALES AGREEMENT entity
Sales analysis
star schema designs for
sales discontinuation date attribute
SALES FOLLOW-UP entity
SALES INVOICE entity
SALES INVOICE ITEM entity
SALES ORDER entity
SALES ORDER ITEM entity
SALES ORDER LINE ITEM entity
Sales order parties, contact mechanisms for
Sales orders
contact mechanisms for
data models for
table of
sales_rep_first_name
sales_rep_id
sales_rep_last_name
Sales rep performance data mart
SALES_REP_SALES table
SALES_REPS dimension
SALES_REPS table
SALES TAX entity
SALES TAX LOOKUP entity
SALES TERRITORY entity
SALE TYPE entity
scheduled completion date attribute
scheduled start date attribute
second string format attribute
SELECTABLE FEATURE entity
SELECTION INTERACTION INCOMPATIBILITY
SEMINAR entity
sent date attribute
Seq id, in attribute names
SERIALIZED INVENTORY ITEM entity
serial num[ber] attribute
SERVICE entity
Services, 69. See also Work effort
in PRODUCT entity
SERVICE TERRITORY entity
SHAREHOLDER entity
Sharp sign (#), with primary keys
SHIP FROM entity
shipment contents description attribute
SHIPMENT DOCUMENT entity
SHIPMENT entity
defined during transaction
SHIPMENT FACT entity
SHIPMENT INVOICE entity
SHIPMENT ITEM BILLING entity
SHIPMENT ITEM entity, 163-180
SHIPMENT ITEM FEATURE entity
SHIPMENT METHOD entity
SHIPMENT METHOD TYPE entity
SHIPMENT PACKAGE entity
shipment package id attribute
SHIPMENT RECEIPT entity
SHIPMENT RECEIPT ROLE entity
SHIPMENT RECEIPT ROLE TYPE entity
shipment received date attribute
SHIPMENT ROLE entity
SHIPMENT ROLE TYPE entity
SHIPMENT ROUTE SEGMENT entity
Shipments
billing for
contact mechanisms and
in data models
documents for
invoicing of
orders and
outgoing
Shipments (Cont.)
receipts for
routing of
star schema design for managing
types of
SHIPMENT STATUS entity
SHIPMENT STATUS HISTORY entity
SHIPMENT STATUS TYPE entity
SHIPMENT TYPE entity
shipped from attribute
shipped from relationship
shipped to attribute
SHIPPING AND HANDLING CHARGES entity
shipping instructions attribute
SHIP TO BUYER entity
SHIP TO CUSTOMER entity
defined during transaction
SHIP TO entity
Ship-to parties, contact mechanisms for
SIZE CLASSIFICATION entity
SIZE entity
SKILL TYPE entity
SKU (stock-keeping unit)
SKU entity
Slices of data
snapshot_date
social security number attribute
SOFTWARE FEATURE entity
sold with attribute
special terms attribute
Specific party relationships, in data models
specifying attribute
SQL scripts, in CD-ROM
Stability, of data
STANDARD FEATURE entity
Standard human resources model
standard lead time attribute
Standard order model
order items in
Standards, for work effort
STANDARD TIME PERIOD entity
standard work hours attribute
Star schema
sales analysis with
tracking human resources with
start mileage attribute
state_abbrv
STATE entity
status attribute
status date attribute
status datetime attribute
STATUS dimension
STATUS TYPE entity
SUB AGREEMENT entity
SUBASSEMBLY entity
Subsidiaries, in data models
Subsidiary accounts
SUBSIDIARY entity
Substitute products, table of
Subtypes
implementing
non-mutually exclusive sets of
notational conventions for
of organizations (table)
of party roles
Supertypes
implementing
notational conventions for
SUPPLIER_ADDRESSES table
SUPPLIER entity
contact mechanisms for
in standard order model
SUPPLIER OFFERING entity
SUPPLIER PRODUCT entity
Supplier products, table of
SUPPLIER RELATIONSHIP entity
Suppliers, of products
SUPPORT CALL entity
support discontinuation date attribute
SURCHARGE ADJUSTMENT entity
SURCHARGE COMPONENT entity
System professionals
Systems development
T
Tables
merging
reference
in star schema designs
taken by attribute
taken via attribute
TASK entity
taxable_flag
taxable flag attribute
tax amount attribute
TAX AND TARIFF DOCUMENT entity
TAX DUE entity
Teams, as organizations
TELECOMMUNICATIONS NUMBER entity
facilities and
Telephone cards
Telephone numbers, in data models
Termination, of employees
TERMINATION REASON entity
TERMINATION TYPE entity
Terminology, customizing data models and
Terms, in quotes
TERM TYPE entity
term value attribute
TERRITORY entity
text attribute
the source of relationship
THRESHOLD entity
thru date
thru_date
thru date, in attribute names
thru date attribute
thru datetime attribute
thru day attribute
thru quantity attribute
Tilde (~), in foreign keys
TIME dimension
Time element, adding
TIME entity
Time entries, billing for
TIME ENTRY BILLING entity
TIME ENTRY entity
TIME FREQUENCY MEASURE entity
TIME_PERIODS dimension
TIMESHEET entity
TIMESHEET ROLE entity
TIMESHEET ROLE TYPE entity
Time tracking, of work effort
title attribute
total dollars allowed attribute
total hours allowed attribute
TRAINING CLASS TYPE entity
transaction date attribute
TRANSACTION DETAIL entity
transaction ID attribute
Transaction-oriented sales data marts
Transactions
accounting
roles defined during
trans detail seq id attribute
TRANSFER entity
Transformation of data
in changing from enterprise data model
TYPE entities, 10. See also Subtypes; Supertypes notational conventions for
for party roles
for roles
U
UNEMPLOYMENT CLAIM entity
UNEMPLOYMENT CLAIM STATUS TYPE entity
UNION entity
Unique identifiers, of entities
UNIT OF MEASURE CONVERSION entity
UNIT OF MEASURE entity
unit price attribute
Universal database structures
development of
need for
Universal Data Models
applications of
customizing
defined
described
implementing
need for
physical database design with
purposes of
using
UPCA (Universal Product Code-American)
UPCA entity
UPCE (Universal Product Code-European)
UPCE entity
used by relationship
used to inquire about attribute
use permission ind attribute
UTILIZATION CHARGE entity
V
VALID CONTACT MECHANISM ROLE entity
VALID RESPONSIBILITY entity
valid thru date attribute
VEHICLE entity
Vehicles, for shipment
void date attribute
W
WAREHOUSE entity
WEB ADDRESS entity
WEB SITE COMMUNICATION entity
week
with a requested bill to attribute
WITHDRAWAL entity
Withdrawals, tracking of
within attribute
WORK EFF ASSET ASSIGN STATUS TYPE entity
Work effort
anticipated demand and
billing for
described
fixed asset assignments for
inventory assignments for
rates for
star schema design for managing
type standards for
work requirement and
WORK EFFORT ASSET ASSIGNMENT entity
WORK EFFORT ASSIGNMENT RATE entity
WORK EFFORT ASSOCIATION entity
WORK EFFORT BILLING entity
WORK EFFORT BREAKDOWN entity
WORK EFFORT CONCURRENCY entity
WORK EFFORT DELIVERABLE PRODUCED entity
WORK EFFORT DEPENDENCY entity
WORK EFFORT entity
WORK EFFORT FACILITY entity
WORK EFFORT FACT entity
WORK EFFORT FIXED ASSET ASSIGNMENT entity
WORK EFFORT FIXED ASSET REQUIREMENT entity
WORK EFFORT FIXED ASSET STANDARD entity
WORK EFFORT GOOD STANDARD entity
WORK EFFORT INVENTORY ASSIGNMENT entity
WORK EFFORT INVENTORY PRODUCED entity
WORK EFFORT PARTY ASSIGNMENT entity
WORK EFFORT PRECEDENCY entity
WORK EFFORT PURPOSE entity
WORK EFFORT PURPOSE TYPE entity
WORK EFFORT ROLE TYPE entity
WORK EFFORT SKILL STANDARD entity
WORK EFFORT STATUS entity
WORK EFFORT STATUS TYPE entity
WORK EFFORT TYPE ASSOCIATION entity
WORK EFFORT TYPE BREAKDOWN entity
WORK EFFORT TYPE DEPENDENCY entity
WORK EFFORT TYPE entity
WORKER entity
WORK FLOW entity
WORK ORDER ITEM entity
WORK ORDER ITEM FULFILLMENT entity
Work requirement
roles in
work effort and
WORK REQUIREMENT entity
WORK REQUIREMENT FULFILLMENT entity
work requirement ID attribute
WORK REQUIREMENT ROLE entity
WORK REQUIREMENT ROLE TYPE entity
WORK REQUIREMENT STATUS entity
WORK TASK entity
Y
year
years experience attribute
The CD-ROM
The accompanying CD-ROM product, which is included in the back of this book and needs to be licensed separately, provides all the SQL scripts needed to implement the data models described in this book, electronic versions of the diagrams contained in the book, and numerous reports with information about the models in the book. The CD-ROM in the back of the book also contains demos to illustrate what you can expect on the complete CD-ROM and includes directories vl demo and v2 demo, which include a small sample of SQL code for a single data model from Volume 1 and a single data model from Volume 2. The full install of the CD-ROM contains the SQL code, diagrams, and reports for all the models in the book. The contents may be unlocked by contacting John Wiley & Sons via phone at (800) 825-8763 weekdays between 9 a.m. and 5 p.m. Eastern Standard Time, or online (http://silverston.wiley.com).
Both the demo and the complete CD-ROM include SQL scripts to implement the models, reports about the models, and electronic versions of the data models. SQL scripts are included that can be run in Oracle, SQL Server, and generic ODBC scripts that are included for use with other relational database management systems (RDBMSs). These SQL scripts may be used to either build a database or reverse-engineer the models into a CASE tool for further analysis and modifications.
The reports show a great deal of information and cross-referencing on the subject data areas, entities, attributes, tables, and columns. Electronic versions of the data model diagrams are included in Visio format and JPEG format. The JPEG files allow you to view all the models in an electronic manner. The Visio files allow you to modify the data model diagrams for your own purposes, if you have Visio 2000 software.
Within each of the root directories vl cdrom, vl demo and v2 demo, are five more directories, three directories for each database platform, one for reports ( eports), and one for the diagrams (diagrams)
Each of the three database-named directories contain SQL scripts for each supported database on the CD-ROM. SQL scripts for Oracle are found in the oracle directory; Microsoft SQL Server in the sqlserver directory; and generic OBDC scripts in the odbc directory. Within each of these directories can be found three scripts. These subdirectories correspond to the logical data models, data warehouse data models, and star schema design models described in this book. The Mogicaldm subdirectory contains the scripts to implement the logical data models that are part of the corporate data model described in Chapters 2 through 9. The dataware-house subdirectory contains scripts to build the sample enterprise data warehouse described in Chapter 11. The starschema subdirectory has the scripts to build the star schemas described in Chapters 12 through 14.
Within each of the subdirectories can be found files that contain the actual SQL code needed to build the described models. The files with a .tab extension can be used to build all the tables and referential integrity constraints for the model. The files with a .ind extension contain the SQL code to build all the indexes.
Using the Scripts
Using the scripts provided on the CD-ROM is quite simple. They can be used immediately if no changes are going to be made or they could be copied to a working directory on a hard drive or file server so they can be edited before execution. In either case, the scripts are ASCII files that can be loaded and executed from the standard SQL interface for the database selected (e.g., SQL*Plus for Oracle, ISQL/w for MS SQL Server). Be sure to execute the files (to build tables) before the .ind file (which builds indexes).
Most modeling tools have a reverse-engineering feature, which allows the extraction of object definitions from the database into the CASE tool. So once the models have been built in the target database, tools such as Oracle Designer/2000, ERwin, or StarDesignor can be used to reverse-engineer the definitions for further analysis or reengineering. Many popular CASE tools even have the ability to reverse-engineer directly from the SQL scripts.
Additional Information
This CD-ROM may be supplemented with the Data Model Resource Industry Download, which contains industry-specific model constructs for each of the eight industries. These are available for licensing at http://silverston.wiley.com. (See Volume 2 for details.)
Please read any additional notes and specific platform comments on the CD-ROM readme.htm file in the root directory of the CD-ROM.
CUSTOMER NOTE: IF THIS BOOK IS ACCOMPANIED BY SOFTWARE, PLEASE READ THE FOLLOWING BEFORE OPENING THE PACKAGE.
This software contains files to help you utilize the models described in the accompanying book. By opening the package, you are agreeing to be bound by the following agreement:
This software product is protected by copyright and all rights are reserved by the author, John Wiley & Sons, Inc., or their licensors. You are licensed to use this software as described in the software and the accompanying book. Copying the software for any other purpose may be a violation of the U.S. Copyright Law.
This software product is sold as is without warranty of any kind, either express or implied, including but not limited to the implied warranty of merchantability and fitness for a particular purpose. Neither Wiley nor its dealers or distributors assumes any liability for any alleged or actual damages arising from the use of or the inability to use this software. (Some states do not allow the exclusion of implied warranties, so the exclusion may not apply to you.)
To use this CD-ROM, your system must meet the following requirements:
Windows® 95, NT 4.0, or higher
64 MB RAM
24 MB free space
CD-ROM drive, Web browser