access timestamp Data Element
Description:
The date and time that the database was accessed
Alias:
ACS_TMSTP
Data element attributes
Domain: event timestamp
Storage Type: DateTime
Default: SYSTIMESTAMP
Null Type: NotNull
Notes:
Location:
Entity --> Processing Access Log
Date Last Altered: 8/4/2009 Date Created: 2/11/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
address Data Structure
Description:
The description of a place where mail is delivered
Alias:
ADDR
Composition:
suite
street
city name
state
postal code
country
Notes:
One of the attribute types used to end the data analysis for a logical data
model
The USPS defines a postal address as:
line 1 - Name or attention
line 2 - Company (optional)
line 3 - suite or apartment number (optional)
line 4 - delivery address
line 5 - city, state, ZIP code
line 6 - country (optional if delivery is in the USA)
Location:
Attributive Entity --> Business Unit Address
Attributive Entity --> Customer Address
Attributive Entity --> Employee Address
Attributive Entity --> Supplier Address
Data Structure --> Shipping Address
Date Last Altered: 6/17/2010 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
address type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
ADDR_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Business Unit Address
Attributive Entity --> Customer Address
Attributive Entity --> Employee Address
Attributive Entity --> Supplier Address
Date Last Altered: 6/16/2010 Date Created: 5/28/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
altitude Data Structure
Description:
The altitude of a geographic location
Alias:
ALT
Composition:
measured quantity
Location:
Entity --> Geographic Location
Date Last Altered: 8/31/2006 Date Created: 8/31/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
amount Data Element
Description:
The value of the monetary amount
Alias:
AMT
Data element attributes
Storage Type: Decimal
Length: 21, 2
Default: 0
Null Type: NotNull
Location:
Data Structure --> monetary amount
Date Last Altered: 6/30/2006 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
application id Data Element
Description:
The code that identifies the source application where the data was created
Alias:
APPL_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Data Structure --> document
Data Structure --> source row meta data
Date Last Altered: 10/24/2009 Date Created: 8/8/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
area code Data Element
Description:
The portion of the phone number that represents the area or city within the country in which the phone number is
located
Alias:
AREA_CD
Data element attributes
Storage Type: National VarChar
Length: 31
Default: 0
Null Type: NotNull
Location:
Data Structure --> phone number
Date Last Altered: 10/24/2009 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
bill date Data Element
Description:
A specific chronological date using calendar conventions.
Alias:
BILL_DT
Data element attributes
Domain: calendar date
Storage Type: Date
Default: SYSDATE
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Customer Bill Information
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
birthdate Data Element
Description:
the date on which a person was born
Alias:
BRTH_DT
Data element attributes
Domain: calendar date
Storage Type: Date
Default: SYSDATE
Null Type: NotNull
Notes:
Location:
Entity --> Employee
Date Last Altered: 6/17/2010 Date Created: 5/28/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
bu01 Relationship
Attached Objects:
Business Unit
bu01 MIN: 0 MAX: many
Purchase Order
[ bu01 ] MIN: 1 MAX: 1
Foreign Key(s):
Business Unit 'bu01' Purchase Order
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm purchase order
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
bu01 Relationship
Attached Objects:
Business Unit
bu01 MIN: 0 MAX: many
Time Card
[ bu01 ] MIN: 1 MAX: 1
Foreign Key(s):
Business Unit 'bu01' Time Card
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm time card
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
bu01 Relationship
Attached Objects:
Business Unit
bu01 MIN: 0 MAX: many
Business Unit Relationship
[ bu01 ] MIN: 1 MAX: 1
Foreign Key(s):
Business Unit 'bu01' Business Unit Relationship
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Business Unit
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
bu02 Relationship
Associator Element:
to business unit
Attached Objects:
Business Unit
bu02 MIN: 0 MAX: many
Business Unit Relationship
[ bu02 ] MIN: 1 MAX: 1
Foreign Key(s):
Business Unit 'bu02' Business Unit Relationship
business unit key -> to business unit
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Business Unit
logical data model
Date Last Altered: 6/7/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
bu03 Relationship
Attached Objects:
Business Unit
bu03 MIN: 0 MAX: many
Business Unit Status History
[ bu03 ] MIN: 1 MAX: 1
Foreign Key(s):
Business Unit 'bu03' Business Unit Status History
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Business Unit
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
bu04 Relationship
Attached Objects:
Business Unit
bu04 MIN: 0 MAX: many
Business Unit Identification
[ bu04 ] MIN: 1 MAX: 1
Foreign Key(s):
Business Unit 'bu04' Business Unit Identification
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Business Unit
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
bu05 Relationship
Attached Objects:
Business Unit
bu05 MIN: 0 MAX: many
Business Unit Address
[ bu05 ] MIN: 1 MAX: 1
Foreign Key(s):
Business Unit 'bu05' Business Unit Address
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Business Unit
logical data model
Date Last Altered: 6/4/2010 Date Created: 6/4/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
bu1 Relationship
Attached Objects:
Business Unit
bu1 MIN: 0 MAX: many
Sales Order
[ bu1 ] MIN: 1 MAX: 1
Foreign Key(s):
Business Unit 'bu1' Sales Order
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm sales order
logical data model
Date Last Altered: 5/26/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
bui01 Relationship
Attached Objects:
Business Unit
bui01 MIN: 0 MAX: many
Business Unit Index
[ bui01 ] MIN: 1 MAX: 1
Foreign Key(s):
Business Unit 'bui01' Business Unit Index
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
bui02 Relationship
Attached Objects:
Chart of Accounts
bui02 MIN: 0 MAX: many
Business Unit Index
[ bui02 ] MIN: 1 MAX: 1
Foreign Key(s):
Chart of Accounts 'bui02' Business Unit Index
chart of account key -> chart of account key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Business Unit Entity
Description:
the entity contains the name and key of the business unit in the company
Alias:
LM_D_BU
Composition:
[PK] business unit key
business unit name
description
source row meta data
row meta data
Notes:
Business Unit is a business object that contains the identification and description of all the functional divisions of
the company. The fundamental or indivisible level of a business unit is position within the company (e.g., Chief
Operating Officer,
Knowledge Manager, etc.).
Primary Key:
Index Name: Generated by VAW
Column(s): business unit key [ ASC ]
Location:
bm purchase order
Attached relationships on bm purchase order:
bu01 MIN: 0 MAX: many
Purchase Order
bm sales order
Attached relationships on bm sales order:
bu1 MIN: 0 MAX: many
Sales Order
bm time card
Attached relationships on bm time card:
bu01 MIN: 0 MAX: many
Time Card
Business Unit
Attached relationships on Business Unit:
bu03 MIN: 0 MAX: many
Business Unit Status History
bu01 MIN: 0 MAX: many
Business Unit Relationship
bu02 MIN: 0 MAX: many
Business Unit Relationship
bu04 MIN: 0 MAX: many
Business Unit Identification
bu05 MIN: 0 MAX: many
Business Unit Address
logical data model
Attached relationships on logical data model:
bu1 MIN: 0 MAX: many
Sales Order
bu05 MIN: 0 MAX: many
Business Unit Address
bu01 MIN: 0 MAX: many
Business Unit Relationship
bu02 MIN: 0 MAX: many
Business Unit Relationship
bu04 MIN: 0 MAX: many
Business Unit Identification
bu03 MIN: 0 MAX: many
Business Unit Status History
master data organization
Attached relationships on master data organization:
bui01 MIN: 0 MAX: many
Business Unit Index
Date Last Altered: 6/7/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Business Unit Address Attributive Entity
Description:
contains the list of customer addresses
Alias:
LM_D_BU_ADDR
Composition:
[PK] [FK] business unit key
[PK] address type
address
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): business unit key [ ASC ]
address type [ ASC ]
Foreign Key(s):
Business Unit 'bu05' Business Unit Address
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Business Unit
Attached relationships on Business Unit:
[ bu05 ] MIN: 1 MAX: 1
Business Unit
logical data model
Attached relationships on logical data model:
[ bu05 ] MIN: 1 MAX: 1
Business Unit
Date Last Altered: 6/16/2010 Date Created: 6/4/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Business Unit Identification Attributive Entity
Description:
contains the identification of a business unit by external systems such as legal jurisdictions or application systems
Alias:
LM_D_BU_ID
Composition:
[PK] [FK] business unit key
[PK] identification
time interval
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): business unit key [ ASC ]
identification [ ASC ]
Foreign Key(s):
Business Unit 'bu04' Business Unit Identification
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Business Unit
Attached relationships on Business Unit:
[ bu04 ] MIN: 1 MAX: 1
Business Unit
logical data model
Attached relationships on logical data model:
[ bu04 ] MIN: 1 MAX: 1
Business Unit
Date Last Altered: 6/3/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Business Unit Index Associative Entity
Description:
The business unit index is the relationship between the business unit and all of the named business unit hierarchies
Alias:
LM_D_BU_IDX
Composition:
[PK] [FK] business unit key
[PK] [FK] chart of account key
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): business unit key [ ASC ]
chart of account key [ ASC ]
Foreign Key(s):
Business Unit 'bui01' Business Unit Index
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Chart of Accounts 'bui02' Business Unit Index
chart of account key -> chart of account key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Attached relationships on master data organization:
[ bui01 ] MIN: 1 MAX: 1
Business Unit
[ bui02 ] MIN: 1 MAX: 1
Chart of Accounts
Date Last Altered: 6/8/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
business unit key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
BU_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Associative Entity --> Purchase Order
Entity --> Business Unit
Associative Entity --> Sales Order
Associative Entity --> Time Card
Attributive Entity --> Business Unit Status History
Associative Entity --> Business Unit Relationship
Attributive Entity --> Business Unit Identification
Attributive Entity --> Business Unit Address
Associative Entity --> Business Unit Index
Date Last Altered: 6/3/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
business unit name Data Element
Description:
A string data type
Alias:
BU_NM
Values & Meanings:
An unstructured attribute type is resolved as an element of type
character that we can record the description of the attribute. A description or comment attribute is of type unstructured.
Data element attributes
Domain: unstructured full
Storage Type: National VarChar
Length: 255
Null Type: Null
Notes:
One of the attribute types used to end the data analysis for a logical data
model (unstructured string)
Location:
Entity --> Business Unit
Date Last Altered: 6/8/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Business Unit Relationship Associative Entity
Description:
contains the list of relationships between one business unit and any other business unit, ie. between a unit and the
parent
Alias:
LM_D_BU_RELAT
Composition:
[PK] [FK] business unit key
[PK] [FK] to business unit
[PK] relationship type
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): business unit key [ ASC ]
to business unit [ ASC ]
relationship type [ ASC ]
Foreign Key(s):
Business Unit 'bu01' Business Unit Relationship
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Business Unit 'bu02' Business Unit Relationship
business unit key -> to business unit
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Business Unit
Attached relationships on Business Unit:
[ bu01 ] MIN: 1 MAX: 1
Business Unit
[ bu02 ] MIN: 1 MAX: 1
Business Unit
logical data model
Attached relationships on logical data model:
[ bu01 ] MIN: 1 MAX: 1
Business Unit
[ bu02 ] MIN: 1 MAX: 1
Business Unit
Date Last Altered: 6/16/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Business Unit Status History Attributive Entity
Description:
contains the business unit attributes that are time dependent, such as type, class
Alias:
LM_D_BU_STUS_HIST
Composition:
[PK] [FK] business unit key
[PK] time interval
business unit type
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): business unit key [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Business Unit 'bu03' Business Unit Status History
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Business Unit
Attached relationships on Business Unit:
[ bu03 ] MIN: 1 MAX: 1
Business Unit
logical data model
Attached relationships on logical data model:
[ bu03 ] MIN: 1 MAX: 1
Business Unit
Date Last Altered: 6/3/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
business unit type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
BU_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Business Unit Status History
Date Last Altered: 6/16/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c01 Relationship
Attached Objects:
Customer
c01 MIN: 0 MAX: many
Purchase Order
[ c01 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c01' Purchase Order
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm purchase order
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c01 Relationship
Attached Objects:
Customer
c01 MIN: 0 MAX: many
Time Card
[ c01 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c01' Time Card
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm time card
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c1 Relationship
Attached Objects:
Customer
c1 MIN: 0 MAX: many
Customer Balance History
[ c1 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c1' Customer Balance History
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/19/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c10 Relationship
Attached Objects:
Customer
c10 MIN: 0 MAX: many
Customer Contract History
[ c10 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c10' Customer Contract History
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/26/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c12 Relationship
Attached Objects:
Customer
c12 MIN: 0 MAX: many
Sales Order
[ c12 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c12' Sales Order
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm sales order
logical data model
Date Last Altered: 5/26/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c2 Relationship
Attached Objects:
Customer
c2 MIN: 0 MAX: many
Customer Marketing Profile History
[ c2 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c2' Customer Marketing Profile History
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/19/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c3 Relationship
Attached Objects:
Customer
c3 MIN: 0 MAX: many
Customer Status History
[ c3 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c3' Customer Status History
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/19/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c4 Relationship
Attached Objects:
Customer
c4 MIN: 0 MAX: many
Customer Location History
[ c4 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c4' Customer Location History
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/19/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c5 Relationship
Attached Objects:
Customer
c5 MIN: 0 MAX: many
Customer Address
[ c5 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c5' Customer Address
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/19/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c6 Relationship
Attached Objects:
Customer
c6 MIN: 0 MAX: many
Customer Authorization
[ c6 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c6' Customer Authorization
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/19/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c7 Relationship
Attached Objects:
Customer
c7 MIN: 0 MAX: many
Customer Bill Information
[ c7 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c7' Customer Bill Information
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/19/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c8 Relationship
Attached Objects:
Customer
c8 MIN: 0 MAX: many
Customer Contact
[ c8 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c8' Customer Contact
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/19/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
c9 Relationship
Attached Objects:
Customer
c9 MIN: 0 MAX: many
Customer Identification
[ c9 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'c9' Customer Identification
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/19/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
calendar date Data Element [Domain]
Description:
A specific chronological date using calendar conventions.
Alias:
DT
Data element attributes
Storage Type: Date
Default: SYSDATE
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Data Element --> bill date
Data Element --> birthdate
Data Element --> Event Date
Data Element --> Purchase Date
Data Element --> Sales Order::Sales Date
Data Element --> version date
Data Element --> working date
Date Last Altered: 8/19/2009 Date Created: 12/13/1995
--------------------------------------------------------------------------------------------------------------------------------------------------
Calendar Index Associative Entity
Description:
The calendar index is the relationship between the date and all of the named calendar hierarchies
Alias:
LM_D_DATE_IDX
Composition:
[PK] [FK] calendar organization id
[PK] [FK] calendar organization key
[PK] [FK] working date
[PK] time interval
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): working date [ ASC ]
calendar organization id [ ASC ]
calendar organization key [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Date 'R_CLNDR_01' Calendar Index
working date -> working date
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Calendar Organization 'R_CLNDR_ORG_01' Calendar Index
calendar organization id -> calendar organization id
calendar organization key -> calendar organization key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Date
Attached relationships on Date:
[ R_CLNDR_01 ] MIN: 1 MAX: 1
Date
[ R_CLNDR_ORG_01 ] MIN: 1 MAX: 1
Calendar Organization
Reference_Calendar
Attached relationships on Reference_Calendar:
[ R_CLNDR_01 ] MIN: 1 MAX: 1
Date
[ R_CLNDR_ORG_01 ] MIN: 1 MAX: 1
Calendar Organization
Date Last Altered: 6/8/2010 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
Calendar Organization Attributive Entity
Description:
The entity contains the hierarchy trees of the financial calendars used to organize the dates
Alias:
LM_D_DATE_ORG
Composition:
[PK] [FK] calendar organization id
[PK] calendar organization key
[FK] parent32
sort order
description
row meta data
Notes:
The Cisco Financial Calendar Organization is a business object that contains the identification and description of
all categories into which the Date data entity can be placed. A single financial date can be related to many
categories such as religious
holidays, regional holidays, factory shutdowns, etc.
Primary Key:
Index Name: Generated by VAW
Column(s): calendar organization id [ ASC ]
calendar organization key [ ASC ]
Foreign Key(s):
Calendar Organization 'R_CLNDR_ORG_00Calendar Organizationon
calendar organization id -> parent32
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Calendar Organization Name 'R_CLNDR_ORG_NM_01Calendar Organizationon
calendar organization id -> calendar organization id
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Date
Attached relationships on Date:
R_CLNDR_ORG_01 MIN: 0 MAX: many
Calendar Index
R_CLNDR_ORG_00 MIN: 0 MAX: many
Calendar Organization
R_CLNDR_ORG_00 MIN: 0 MAX: many
Calendar Organization
[ R_CLNDR_ORG_NM_01 ] MIN: 1 MAX: 1
Calendar Organization Name
Reference_Calendar
Attached relationships on Reference_Calendar:
R_CLNDR_ORG_01 MIN: 0 MAX: many
Calendar Index
[ R_CLNDR_ORG_NM_01 ] MIN: 1 MAX: 1
Calendar Organization Name
R_CLNDR_ORG_00 MIN: 0 MAX: many
Calendar Organization
R_CLNDR_ORG_00 MIN: 0 MAX: many
Calendar Organization
Date Last Altered: 6/3/2010 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
calendar organization id Data Element
Description:
The assigned key for this calendar organization
Alias:
CLNDR_ORG_ID
Data element attributes
Domain: unstructured code
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Associative Entity --> Calendar Index
Attributive Entity --> Calendar Organization
Entity --> Calendar Organization Name
Date Last Altered: 10/24/2009 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
calendar organization key Data Element
Description:
The unique identifier for this calendar organization table row
Alias:
CLNDR_ORG_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
This value should be assigned by the person building the calendar tree. If the value is assigned by the DBMS, then
it becomes impossible to move branches within the tree
Location:
Associative Entity --> Calendar Index
Attributive Entity --> Calendar Organization
Date Last Altered: 9/12/2007 Date Created: 7/10/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
calendar organization name Data Element
Description:
The unique name given to an organization scheme for the calendar
Alias:
CLNDR_ORG_NM
Values & Meanings:
Data element attributes
Domain: unstructured quarter
Storage Type: National VarChar
Length: 63
Null Type: Null
Notes:
Location:
Entity --> Calendar Organization Name
Date Last Altered: 8/4/2009 Date Created: 7/10/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
Calendar Organization Name Entity
Description:
The entity contains the list of names of the hierarchies used to organize the calendar
Alias:
LM_D_DATE_ORG_NM
Composition:
[PK] calendar organization id
calendar organization name
sort order
maximum depth
description
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): calendar organization id [ ASC ]
Location:
Date
Attached relationships on Date:
R_CLNDR_ORG_NM_01 MIN: 0 MAX: many
Calendar Organization
Reference_Calendar
Attached relationships on Reference_Calendar:
R_CLNDR_ORG_NM_01 MIN: 0 MAX: many
Calendar Organization
Date Last Altered: 6/3/2010 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
cc1 Relationship
Attached Objects:
Customer Contact
cc1 MIN: 0 MAX: many
Customer Contact Email
[ cc1 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer Contact 'cc1' Customer Contact Email
customer key -> customer key
customer contact key -> customer contact key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/19/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
cc2 Relationship
Attached Objects:
Customer Contact
cc2 MIN: 0 MAX: many
Customer Contact Phone
[ cc2 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer Contact 'cc2' Customer Contact Phone
customer key -> customer key
customer contact key -> customer contact key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/19/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
chart of account key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
COA_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Entity --> Chart of Accounts
Associative Entity --> Business Unit Index
Date Last Altered: 6/8/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Chart of Accounts Entity
Description:
The entity contains the hierarchy trees of the charts of accounts used to organize the company's business units
Alias:
LM_D_COA
Composition:
[PK] chart of account key
description
source row meta data
row meta data
Notes:
The Chart of Accounts is a data object that contains the identification and description of all categories into which
the Business Units can be placed. There can be different charts of account for each purpose envisioned by the
company (e.g., Shareholders
CoA, SEC CoA, Organizational Chart, etc.).
Primary Key:
Index Name: Generated by VAW
Column(s): chart of account key [ ASC ]
Location:
master data organization
Attached relationships on master data organization:
bui02 MIN: 0 MAX: many
Business Unit Index
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ci01 Relationship
Attached Objects:
Customer
ci01 MIN: 0 MAX: many
Customer Index
[ ci01 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'ci01' Customer Index
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ci02 Relationship
Attached Objects:
Territory Organization
ci02 MIN: 0 MAX: many
Customer Index
[ ci02 ] MIN: 1 MAX: 1
Foreign Key(s):
Territory Organization 'ci02' Customer Index
territory key -> territory key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
city name Data Element
Description:
The city in which the street is located
Alias:
CITY
Values & Meanings:
Data element attributes
Storage Type: National VarChar
Length: 63
Null Type: Null
Notes:
The first part of line 5 according to the USPS
Location:
Data Structure --> address
Date Last Altered: 7/28/2009 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
clock time Data Element [Domain]
Description:
The time of day within the date.
Alias:
TM
Data element attributes
Storage Type: Time
Default: '00:00'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Data Element --> end time
Data Element --> Start Time
Date Last Altered: 12/23/2008 Date Created: 6/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
compensation Data Structure
Alias:
CMPNSAT
Composition:
monetary amount
Location:
Attributive Entity --> Employee Status History
Date Last Altered: 6/17/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
contract type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
CONTR_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Customer Contract History
Attributive Entity --> Supplier Contract History
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
country Data Element
Description:
The name of the country for the mailing address
Alias:
CTRY
Values & Meanings:
Data element attributes
Storage Type: National VarChar
Length: 63
Null Type: Null
Notes:
The last line (line 6) of the postal address
Location:
Data Structure --> address
Date Last Altered: 7/28/2009 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
country code Data Element
Description:
The portion of the phone number that represents the country in which the phone number is located
Alias:
CTRY_CD
Data element attributes
Storage Type: National VarChar
Length: 7
Default: '1'
Null Type: NotNull
Location:
Data Structure --> phone number
Date Last Altered: 8/4/2009 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
cr1 Relationship
Attached Objects:
Customer
cr1 MIN: 0 MAX: many
Customer Relationship
[ cr1 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'cr1' Customer Relationship
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 6/16/2010 Date Created: 5/28/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
cr2 Relationship
Associator Element:
to customer
Attached Objects:
Customer
cr2 MIN: 0 MAX: many
Customer Relationship
[ cr2 ] MIN: 1 MAX: 1
Foreign Key(s):
Customer 'cr2' Customer Relationship
customer key -> to customer
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
logical data model
Date Last Altered: 5/28/2010 Date Created: 5/28/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
create date Data Element
Description:
The date on which the table row was created
Alias:
CREAT_DT
Data element attributes
Storage Type: Date
Default: SYSDATE
Null Type: NotNull
Notes:
Location:
Data Structure --> row meta data
Data Structure --> source row meta data
Date Last Altered: 8/4/2009 Date Created: 4/6/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
create process Data Element
Description:
The identification of the the person or process that created the table row
Alias:
CREAT_PRCS
Data element attributes
Storage Type: National VarChar
Length: 63
Default: 'UNSIGNED'
Null Type: NotNull
Location:
Data Structure --> row meta data
Data Structure --> source row meta data
Date Last Altered: 7/28/2009 Date Created: 4/6/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
credit limit Data Structure
Composition:
monetary amount
Location:
Attributive Entity --> Customer Balance History
Date Last Altered: 6/8/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
currency Data Element
Description:
The name of the currency that was used for the monetary amount
Alias:
CURR_CD
Values & Meanings:
USD - US dollars
YEN - Japanese yen
CDN - Canadian dollars
PSO - Mexican peso
etc.
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Data Structure --> monetary amount
Date Last Altered: 10/24/2009 Date Created: 6/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
current balance Data Structure
Composition:
monetary amount
Location:
Attributive Entity --> Customer Balance History
Date Last Altered: 6/8/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Entity
Description:
The entity contains the name and key of the customer
Alias:
Account
Lead
Opportunity
Composition:
[PK] customer key
customer name
description
source row meta data
row meta data
Notes:
The Customer subject area identifies and describes of all those entities that use or are expected use WebEx
Services. Customers are WebEx’s view of the entities that send WebEx money for goods, services, or information.
Or they sent WebEx money in the
past. Or WebEx expects them to send money in the future. These Customers can be individuals, other businesses,
governments, the business itself, its subsidiaries, etc., In fact, anyone that uses a WebEx Service
Primary Key:
Index Name: Generated by VAW
Column(s): customer key [ ASC ]
Location:
bm purchase order
Attached relationships on bm purchase order:
c01 MIN: 0 MAX: many
Purchase Order
bm sales order
Attached relationships on bm sales order:
c12 MIN: 0 MAX: many
Sales Order
bm time card
Attached relationships on bm time card:
c01 MIN: 0 MAX: many
Time Card
Customer
Attached relationships on Customer:
c1 MIN: 0 MAX: many
Customer Balance History
c2 MIN: 0 MAX: many
Customer Marketing Profile History
c3 MIN: 0 MAX: many
Customer Status History
c4 MIN: 0 MAX: many
Customer Location History
c5 MIN: 0 MAX: many
Customer Address
c6 MIN: 0 MAX: many
Customer Authorization
c7 MIN: 0 MAX: many
Customer Bill Information
c8 MIN: 0 MAX: many
Customer Contact
c9 MIN: 0 MAX: many
Customer Identification
c10 MIN: 0 MAX: many
Customer Contract History
cr1 MIN: 0 MAX: many
Customer Relationship
cr2 MIN: 0 MAX: many
Customer Relationship
logical data model
Attached relationships on logical data model:
c12 MIN: 0 MAX: many
Sales Order
cr1 MIN: 0 MAX: many
Customer Relationship
cr2 MIN: 0 MAX: many
Customer Relationship
c1 MIN: 0 MAX: many
Customer Balance History
c5 MIN: 0 MAX: many
Customer Address
c6 MIN: 0 MAX: many
Customer Authorization
c7 MIN: 0 MAX: many
Customer Bill Information
c8 MIN: 0 MAX: many
Customer Contact
c10 MIN: 0 MAX: many
Customer Contract History
c9 MIN: 0 MAX: many
Customer Identification
c4 MIN: 0 MAX: many
Customer Location History
c2 MIN: 0 MAX: many
Customer Marketing Profile History
c3 MIN: 0 MAX: many
Customer Status History
master data organization
Attached relationships on master data organization:
ci01 MIN: 0 MAX: many
Customer Index
Date Last Altered: 8/28/2013 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Address Attributive Entity
Description:
contains the list of customer addresses
Alias:
LM_D_CUST_ADDR
Composition:
[PK] [FK] customer key
[PK] address type
address
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): address type [ ASC ]
customer key [ ASC ]
Foreign Key(s):
Customer 'c5' Customer Address
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ c5 ] MIN: 1 MAX: 1
Customer
logical data model
Attached relationships on logical data model:
[ c5 ] MIN: 1 MAX: 1
Customer
Date Last Altered: 6/3/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Authorization Attributive Entity
Description:
contains the customer's authentication
Alias:
LM_D_CUST_AUTH
Composition:
[PK] [FK] customer key
[PK] identification
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): customer key [ ASC ]
identification [ ASC ]
Foreign Key(s):
Customer 'c6' Customer Authorization
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ c6 ] MIN: 1 MAX: 1
Customer
logical data model
Attached relationships on logical data model:
[ c6 ] MIN: 1 MAX: 1
Customer
Date Last Altered: 6/3/2010 Date Created: 5/19/2010
Customer Balance History Attributive Entity
Description:
contains the customer balance values that are time dependent
Alias:
LM_D_CUST_BLNC_HIST
Composition:
[PK] [FK] customer key
[PK] time interval
current balance
thirty day balance
sixty day balance
credit limit
description
source row meta data
row meta data
Notes:
Each row in the table is for a specified time interval.
A customer has at least one history record
A customer's history records cover the entire period of history with no
gaps or overlaps.
Primary Key:
Index Name: Generated by VAW
Column(s): time interval [ ASC ]
customer key [ ASC ]
Foreign Key(s):
Customer 'c1' Customer Balance History
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ c1 ] MIN: 1 MAX: 1
Customer
logical data model
Attached relationships on logical data model:
[ c1 ] MIN: 1 MAX: 1
Customer
Date Last Altered: 6/3/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Bill Information Attributive Entity
Description:
contains the customer's billing presentation parameters
Alias:
LM_D_CUST_BILL_INFO
Composition:
[PK] [FK] customer key
[PK] bill date
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): customer key [ ASC ]
bill date [ ASC ]
Foreign Key(s):
Customer 'c7' Customer Bill Information
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ c7 ] MIN: 1 MAX: 1
Customer
logical data model
Attached relationships on logical data model:
[ c7 ] MIN: 1 MAX: 1
Customer
Date Last Altered: 6/3/2010 Date Created: 5/19/2010
customer class Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
CUST_CLAS_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Customer Status History
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Contact Attributive Entity
Description:
contains the list of people at the customer that can be contacted
Alias:
LM_D_CUST_CNTCT
Composition:
[PK] [FK] customer key
[PK] customer contact key
person name
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): customer key [ ASC ]
customer contact key [ ASC ]
Foreign Key(s):
Customer 'c8' Customer Contact
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ c8 ] MIN: 1 MAX: 1
Customer
cc1 MIN: 0 MAX: many
Customer Contact Email
cc2 MIN: 0 MAX: many
Customer Contact Phone
logical data model
Attached relationships on logical data model:
[ c8 ] MIN: 1 MAX: 1
Customer
cc1 MIN: 0 MAX: many
Customer Contact Email
cc2 MIN: 0 MAX: many
Customer Contact Phone
Date Last Altered: 6/16/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Contact Email Attributive Entity
Description:
contains the list of email addresses for this customer contact
Alias:
LM_D_CUST_CNTCT_EMAIL
Composition:
[PK] [FK] customer key
[PK] [FK] customer contact key
[PK] email name
[PK] domain
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): customer key [ ASC ]
customer contact key [ ASC ]
email name [ ASC ]
domain [ ASC ]
Foreign Key(s):
Customer Contact 'cc1' Customer Contact Email
customer key -> customer key
customer contact key -> customer contact key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ cc1 ] MIN: 1 MAX: 1
Customer Contact
logical data model
Attached relationships on logical data model:
[ cc1 ] MIN: 1 MAX: 1
Customer Contact
Date Last Altered: 6/16/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
customer contact key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
CUST_CNTCT_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Attributive Entity --> Customer Contact
Attributive Entity --> Customer Contact Email
Attributive Entity --> Customer Contact Phone
Date Last Altered: 6/16/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Contact Phone Attributive Entity
Description:
contains the list of phone number for this customer contact
Alias:
LM_D_CUST_CNTCT_PHN
Composition:
[PK] [FK] customer key
[PK] [FK] customer contact key
[PK] phone type
phone number
time zone
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): customer key [ ASC ]
customer contact key [ ASC ]
phone type [ ASC ]
Foreign Key(s):
Customer Contact 'cc2' Customer Contact Phone
customer key -> customer key
customer contact key -> customer contact key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ cc2 ] MIN: 1 MAX: 1
Customer Contact
logical data model
Attached relationships on logical data model:
[ cc2 ] MIN: 1 MAX: 1
Customer Contact
Date Last Altered: 6/16/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Contract History Attributive Entity
Description:
contains the service and sale price for a customer's contract or subscription
Alias:
LM_D_CUST_CONTR_HIST
Composition:
[PK] [FK] customer key
[PK] time interval
[PK] contract type
service key
sale price
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): time interval [ ASC ]
customer key [ ASC ]
contract type [ ASC ]
Foreign Key(s):
Customer 'c10' Customer Contract History
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ c10 ] MIN: 1 MAX: 1
Customer
logical data model
Attached relationships on logical data model:
[ c10 ] MIN: 1 MAX: 1
Customer
Date Last Altered: 6/3/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Identification Attributive Entity
Description:
contains the identification of a customer by external systems such as legal jurisdictions or application systems
Alias:
LM_D_CUST_ID
Composition:
[PK] [FK] customer key
[PK] identification
time interval
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): identification [ ASC ]
customer key [ ASC ]
Foreign Key(s):
Customer 'c9' Customer Identification
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ c9 ] MIN: 1 MAX: 1
Customer
logical data model
Attached relationships on logical data model:
[ c9 ] MIN: 1 MAX: 1
Customer
Date Last Altered: 6/3/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Index Associative Entity
Description:
The customer index is the relationship between the customer and all of the named customer hierarchies
Alias:
LM_D_CUST_IDX
Composition:
[PK] [FK] customer key
[PK] [FK] territory key
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): customer key [ ASC ]
territory key [ ASC ]
Foreign Key(s):
Territory Organization 'ci02' Customer Index
territory key -> territory key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Customer 'ci01' Customer Index
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Attached relationships on master data organization:
[ ci02 ] MIN: 1 MAX: 1
Territory Organization
[ ci01 ] MIN: 1 MAX: 1
Customer
Date Last Altered: 6/16/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
customer key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
CUST_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Associative Entity --> Purchase Order
Entity --> Customer
Associative Entity --> Sales Order
Associative Entity --> Time Card
Attributive Entity --> Customer Contract History
Attributive Entity --> Customer Identification
Attributive Entity --> Customer Authorization
Attributive Entity --> Customer Balance History
Attributive Entity --> Customer Bill Information
Attributive Entity --> Customer Address
Attributive Entity --> Customer Contact
Attributive Entity --> Customer Status History
Attributive Entity --> Customer Marketing Profile History
Associative Entity --> Customer Relationship
Attributive Entity --> Customer Location History
Attributive Entity --> Customer Contact Email
Attributive Entity --> Customer Contact Phone
Associative Entity --> Customer Index
Date Last Altered: 6/16/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Location History Attributive Entity
Description:
contains the customer location values that are time dependent
Alias:
LM_D_CUST_LOCAT_HIST
Composition:
[PK] [FK] customer key
[PK] time interval
geographic location
description
source row meta data
row meta data
Notes:
Each row in the table is for a specified time interval.
A customer has at least one history record
A customer's history records cover the entire period of history with no
gaps or overlaps.
Primary Key:
Index Name: Generated by VAW
Column(s): time interval [ ASC ]
customer key [ ASC ]
Foreign Key(s):
Customer 'c4' Customer Location History
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ c4 ] MIN: 1 MAX: 1
Customer
logical data model
Attached relationships on logical data model:
[ c4 ] MIN: 1 MAX: 1
Customer
Date Last Altered: 6/3/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Marketing Profile History Attributive Entity
Description:
contains the customer marketing values that are time dependent
Alias:
LM_D_CUST_MRKT_HIST
Composition:
[PK] [FK] customer key
[PK] time interval
standard industrial classification
employee count
gross income
profit
description
source row meta data
row meta data
Notes:
Each row in the table is for a specified time interval.
A customer has at least one history record
A customer's history records cover the entire period of history with no
gaps or overlaps.
Primary Key:
Index Name: Generated by VAW
Column(s): time interval [ ASC ]
customer key [ ASC ]
Foreign Key(s):
Customer 'c2' Customer Marketing Profile History
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ c2 ] MIN: 1 MAX: 1
Customer
logical data model
Attached relationships on logical data model:
[ c2 ] MIN: 1 MAX: 1
Customer
Date Last Altered: 6/8/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
customer name Data Element
Description:
A string data type
Alias:
CUST_NM
Values & Meanings:
An unstructured attribute type is resolved as an element of type
character that we can record the description of the attribute. A description or comment attribute is of type unstructured.
Data element attributes
Domain: unstructured full
Storage Type: National VarChar
Length: 255
Null Type: Null
Notes:
One of the attribute types used to end the data analysis for a logical data
model (unstructured string)
Location:
Entity --> Customer
Date Last Altered: 6/16/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Relationship Associative Entity
Description:
contains the list of relationships between one customer and any other customer, ie. between a store and the parent
Alias:
LM_D_CUST_RELAT
Composition:
[PK] [FK] customer key
[PK] [FK] to customer
[PK] relationship type
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): customer key [ ASC ]
to customer [ ASC ]
relationship type [ ASC ]
Foreign Key(s):
Customer 'cr1' Customer Relationship
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Customer 'cr2' Customer Relationship
customer key -> to customer
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ cr1 ] MIN: 1 MAX: 1
Customer
[ cr2 ] MIN: 1 MAX: 1
Customer
logical data model
Attached relationships on logical data model:
[ cr1 ] MIN: 1 MAX: 1
Customer
[ cr2 ] MIN: 1 MAX: 1
Customer
Date Last Altered: 6/16/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Customer Status History Attributive Entity
Description:
contains the customer attributes that are time dependent, such as type, class
Alias:
LM_D_CUST_STUS_HIST
Composition:
[PK] [FK] customer key
[PK] time interval
customer type
customer class
description
source row meta data
row meta data
Notes:
Each row in the table is for a specified time interval.
A customer has at least one history record
A customer's history records cover the entire period of history with no
gaps or overlaps.
Primary Key:
Index Name: Generated by VAW
Column(s): customer key [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Customer 'c3' Customer Status History
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Customer
Attached relationships on Customer:
[ c3 ] MIN: 1 MAX: 1
Customer
logical data model
Attached relationships on logical data model:
[ c3 ] MIN: 1 MAX: 1
Customer
Date Last Altered: 6/8/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
customer type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
CUST_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Customer Status History
Date Last Altered: 6/16/2010 Date Created: 5/28/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
data value Data Element
Description:
the value of the key of the record that is being accessed.
Alias:
REC_KEY
Values & Meanings:
Data element attributes
Domain: unstructured full
Storage Type: National VarChar
Length: 255
Null Type: Null
Notes:
Location:
Entity --> Processing Message Log
Entity --> Processing Access Log
Date Last Altered: 3/16/2009 Date Created: 12/27/2008
--------------------------------------------------------------------------------------------------------------------------------------------------
Database Version Log Entity
Description:
The current version of the database design
Alias:
WC_C_DB_VRSN
Composition:
[PK] version date
version number
description
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): version date [ ASC ]
Location:
Test
Date Last Altered: 6/3/2010 Date Created: 3/17/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
Date Entity
Description:
the entity contains the list of all of the dates used to do business and prepare financial statements.
Alias:
LM_D_DATE
Composition:
[PK] working date
day name
day short name
day of week
day of month
day of quarter
day of year
week of month
week of quarter
week of year
month name
month short name
month of quarter
month of year
quarter name
quarter short name
quarter of year
season name
season short name
year
year short
description
row meta data
Notes:
The Calendar is a business object that contains the identification and description of all the days on which the
business plans to produce inventory or perform services. These days are the list of all the dates in the calendar.
The table contains all the levels of the generally accepted calendar
Primary Key:
Index Name: Generated by VAW
Column(s): working date [ ASC ]
Location:
Date
Attached relationships on Date:
R_CLNDR_01 MIN: 0 MAX: many
Calendar Index
Reference_Calendar
Attached relationships on Reference_Calendar:
R_CLNDR_01 MIN: 0 MAX: many
Calendar Index
Date Last Altered: 6/7/2010 Date Created: 12/13/1995
--------------------------------------------------------------------------------------------------------------------------------------------------
day name Data Element
Description:
The name of the day in the week of this working date
Alias:
DY_NM
Values & Meanings:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Data element attributes
Domain: unstructured quarter
Storage Type: National VarChar
Length: 63
Null Type: Null
Notes:
Location:
Entity --> Date
Date Last Altered: 8/4/2009 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
day of month Data Element
Description:
The number of the day in the month of this working date
Alias:
DOM
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 4/20/2007 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
day of quarter Data Element
Description:
The number of the day in the quarter of this working date
Alias:
DOQ
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 9/7/2007 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
day of week Data Element
Description:
The number of the day in the week of this working date
Alias:
DOW
Values & Meanings:
1
2
3
4
5
6
7
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 9/7/2007 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
day of year Data Element
Description:
The number of the day in the year of this working date
Alias:
DOY
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 4/20/2007 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
day short name Data Element
Description:
the short name of the day of the week for this working date
Alias:
DY_SHRT_NM
Values & Meanings:
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Data element attributes
Domain: unstructured code
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 10/24/2009 Date Created: 5/22/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
description Data Element
Description:
The free form description for the row in a table
Alias:
DESCR
Values & Meanings:
Data element attributes
Domain: unstructured full
Storage Type: National VarChar
Length: 255
Null Type: Null
Notes:
Location:
Associative Entity --> Purchase Order
Entity --> Customer
Entity --> Employee
Entity --> Network Equipment
Entity --> Supplier
Entity --> Sales Process Task
Entity --> Service
Entity --> Business Unit
Associative Entity --> Sales Order
Associative Entity --> Time Card
Attributive Entity --> Business Unit Status History
Associative Entity --> Business Unit Relationship
Attributive Entity --> Business Unit Identification
Attributive Entity --> Business Unit Address
Attributive Entity --> Customer Contract History
Attributive Entity --> Customer Identification
Attributive Entity --> Customer Authorization
Attributive Entity --> Customer Balance History
Attributive Entity --> Customer Bill Information
Attributive Entity --> Customer Address
Attributive Entity --> Customer Contact
Attributive Entity --> Customer Status History
Attributive Entity --> Customer Marketing Profile History
Associative Entity --> Customer Relationship
Attributive Entity --> Customer Location History
Attributive Entity --> Customer Contact Email
Attributive Entity --> Customer Contact Phone
Entity --> Date
Associative Entity --> Calendar Index
Attributive Entity --> Calendar Organization
Entity --> Calendar Organization Name
Attributive Entity --> Employee Identification
Attributive Entity --> Employee Address
Attributive Entity --> Employee Email
Attributive Entity --> Employee Phone
Associative Entity --> Employee Relationship
Attributive Entity --> Employee Status History
Associative Entity --> Network Equipment Relationship
Attributive Entity --> Network Equipment Identification
Attributive Entity --> Network Equipment Status History
Associative Entity --> Supplier Relationship
Attributive Entity --> Supplier Contract History
Attributive Entity --> Supplier Address
Attributive Entity --> Supplier Contact
Attributive Entity --> Supplier Contact Email
Attributive Entity --> Supplier Contact Phone
Attributive Entity --> Supplier Location History
Attributive Entity --> Supplier Purchasing Profile History
Attributive Entity --> Supplier Status History
Associative Entity --> Sales Process Task Relationship
Attributive Entity --> Sales Process Task Identification
Attributive Entity --> Sales Process Task Status History
Associative Entity --> Service Relationship
Attributive Entity --> Service Identification
Attributive Entity --> Service List Price History
Attributive Entity --> Service Specification
Attributive Entity --> Service Status History
Entity --> Chart of Accounts
Entity --> Territory Organization
Entity --> Supplier Organization
Entity --> Service Catalog
Entity --> Sales Heirarchy
Entity --> Network Organization
Entity --> Process Organization
Associative Entity --> Business Unit Index
Associative Entity --> Customer Index
Associative Entity --> Supplier Index
Associative Entity --> Service Index
Associative Entity --> Employee Index
Associative Entity --> Network Index
Associative Entity --> Task Index
Entity --> Geographic Location
Entity --> Location Organization Name
Attributive Entity --> Location Organization
Associative Entity --> Location Index
Entity --> Indicator Value Lookup Table
Entity --> Processing Message Log
Entity --> Processing Access Log
Entity --> Database Version Log
Date Last Altered: 6/3/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
document Data Structure
Description:
The properties that identify a document in an application system
Composition:
application id
document id
line number
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Data Structure --> Reference Document
Data Structure --> Source Document
Date Last Altered: 9/7/2007 Date Created: 8/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
document id Data Element
Description:
The identification number given to this document by the originating application
Alias:
DOC_ID
Data element attributes
Storage Type: National VarChar
Length: 63
Null Type: Null
Location:
Data Structure --> document
Date Last Altered: 6/17/2010 Date Created: 8/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
domain Data Element
Description:
A string data type
Alias:
EMAIL_DMN
Values & Meanings:
An unstructured attribute type is resolved as an element of type
character that we can record the description of the attribute. A description or comment attribute is of type unstructured.
Data element attributes
Domain: unstructured full
Storage Type: National VarChar
Length: 255
Null Type: Null
Notes:
One of the attribute types used to end the data analysis for a logical data
model (unstructured string)
Location:
Attributive Entity --> Customer Contact Email
Attributive Entity --> Employee Email
Attributive Entity --> Supplier Contact Email
Date Last Altered: 6/16/2010 Date Created: 5/28/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
e01 Relationship
Attached Objects:
Employee
e01 MIN: 0 MAX: many
Purchase Order
[ e01 ] MIN: 1 MAX: 1
Foreign Key(s):
Employee 'e01' Purchase Order
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm purchase order
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
e01 Relationship
Attached Objects:
Employee
e01 MIN: 0 MAX: many
Time Card
[ e01 ] MIN: 1 MAX: 1
Foreign Key(s):
Employee 'e01' Time Card
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm time card
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
e01 Relationship
Attached Objects:
Employee
e01 MIN: 0 MAX: many
Employee Relationship
[ e01 ] MIN: 1 MAX: 1
Foreign Key(s):
Employee 'e01' Employee Relationship
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
e02 Relationship
Associator Element:
to employee
Attached Objects:
Employee
e02 MIN: 0 MAX: many
Employee Relationship
[ e02 ] MIN: 1 MAX: 1
Foreign Key(s):
Employee 'e02' Employee Relationship
employee key -> to employee
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
logical data model
Date Last Altered: 6/7/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
e04 Relationship
Attached Objects:
Employee
e04 MIN: 0 MAX: many
Employee Status History
[ e04 ] MIN: 1 MAX: 1
Foreign Key(s):
Employee 'e04' Employee Status History
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
e05 Relationship
Attached Objects:
Employee
e05 MIN: 0 MAX: many
Employee Identification
[ e05 ] MIN: 1 MAX: 1
Foreign Key(s):
Employee 'e05' Employee Identification
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
e06 Relationship
Attached Objects:
Employee
e06 MIN: 0 MAX: many
Employee Address
[ e06 ] MIN: 1 MAX: 1
Foreign Key(s):
Employee 'e06' Employee Address
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
e07 Relationship
Attached Objects:
Employee
e07 MIN: 0 MAX: many
Employee Email
[ e07 ] MIN: 1 MAX: 1
Foreign Key(s):
Employee 'e07' Employee Email
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
e08 Relationship
Attached Objects:
Employee
e08 MIN: 0 MAX: many
Employee Phone
[ e08 ] MIN: 1 MAX: 1
Foreign Key(s):
Employee 'e08' Employee Phone
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
e1 Relationship
Attached Objects:
Employee
e1 MIN: 0 MAX: many
Sales Order
[ e1 ] MIN: 1 MAX: 1
Foreign Key(s):
Employee 'e1' Sales Order
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm sales order
logical data model
Date Last Altered: 5/26/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ei01 Relationship
Attached Objects:
Employee
ei01 MIN: 0 MAX: many
Employee Index
[ ei01 ] MIN: 1 MAX: 1
Foreign Key(s):
Employee 'ei01' Employee Index
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ei02 Relationship
Attached Objects:
Sales Heirarchy
ei02 MIN: 0 MAX: many
Employee Index
[ ei02 ] MIN: 1 MAX: 1
Foreign Key(s):
Sales Heirarchy 'ei02' Employee Index
sales heirarchy key -> sales heirarchy key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
email name Data Element
Description:
A string data type
Alias:
EMAIL_NM
Values & Meanings:
An unstructured attribute type is resolved as an element of type
character that we can record the description of the attribute. A description or comment attribute is of type unstructured.
Data element attributes
Domain: unstructured full
Storage Type: National VarChar
Length: 255
Null Type: Null
Notes:
One of the attribute types used to end the data analysis for a logical data
model (unstructured string)
Location:
Attributive Entity --> Customer Contact Email
Attributive Entity --> Employee Email
Attributive Entity --> Supplier Contact Email
Date Last Altered: 6/16/2010 Date Created: 6/16/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Employee Entity
Description:
the entity contains the name and key of the employee
Alias:
LM_D_EMPE
Composition:
[PK] employee key
person name
gender
birthdate
description
source row meta data
row meta data
Notes:
Employee is a business object that contains the identification and description of all the people who provide labor
during the business processes. They can be full time employees, part time employees, contractors, temporaries,
etc.
Primary Key:
Index Name: Generated by VAW
Column(s): employee key [ ASC ]
Location:
bm purchase order
Attached relationships on bm purchase order:
e01 MIN: 0 MAX: many
Purchase Order
bm sales order
Attached relationships on bm sales order:
e1 MIN: 0 MAX: many
Sales Order
bm time card
Attached relationships on bm time card:
e01 MIN: 0 MAX: many
Time Card
Employee
Attached relationships on Employee:
e01 MIN: 0 MAX: many
Employee Relationship
e02 MIN: 0 MAX: many
Employee Relationship
e04 MIN: 0 MAX: many
Employee Status History
e05 MIN: 0 MAX: many
Employee Identification
e06 MIN: 0 MAX: many
Employee Address
e07 MIN: 0 MAX: many
Employee Email
e08 MIN: 0 MAX: many
Employee Phone
logical data model
Attached relationships on logical data model:
e1 MIN: 0 MAX: many
Sales Order
e01 MIN: 0 MAX: many
Employee Relationship
e02 MIN: 0 MAX: many
Employee Relationship
e04 MIN: 0 MAX: many
Employee Status History
e06 MIN: 0 MAX: many
Employee Address
e07 MIN: 0 MAX: many
Employee Email
e05 MIN: 0 MAX: many
Employee Identification
e08 MIN: 0 MAX: many
Employee Phone
master data organization
Attached relationships on master data organization:
ei01 MIN: 0 MAX: many
Employee Index
Date Last Altered: 6/7/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Employee Address Attributive Entity
Description:
contains the list of addresses at which the employee can be reached
Alias:
LM_D_EMPE_ADDR
Composition:
[PK] [FK] employee key
[PK] address type
address
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): employee key [ ASC ]
address type [ ASC ]
Foreign Key(s):
Employee 'e06' Employee Address
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
Attached relationships on Employee:
[ e06 ] MIN: 1 MAX: 1
Employee
logical data model
Attached relationships on logical data model:
[ e06 ] MIN: 1 MAX: 1
Employee
Date Last Altered: 6/3/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
employee count Data Structure
Composition:
measured quantity
Location:
Attributive Entity --> Customer Marketing Profile History
Attributive Entity --> Supplier Purchasing Profile History
Date Last Altered: 6/8/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Employee Email Attributive Entity
Description:
contains the list of email addresses for this employee
Alias:
LM_D_EMPE_EMAIL
Composition:
[PK] [FK] employee key
[PK] email name
[PK] domain
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): employee key [ ASC ]
email name [ ASC ]
domain [ ASC ]
Foreign Key(s):
Employee 'e07' Employee Email
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
Attached relationships on Employee:
[ e07 ] MIN: 1 MAX: 1
Employee
logical data model
Attached relationships on logical data model:
[ e07 ] MIN: 1 MAX: 1
Employee
Date Last Altered: 6/16/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Employee Identification Attributive Entity
Description:
contains the identification of an employee by external systems such as legal jurisdictions or application systems
Alias:
LM_D_EMPE_ID
Composition:
[PK] [FK] employee key
[PK] identification
time interval
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): employee key [ ASC ]
identification [ ASC ]
Foreign Key(s):
Employee 'e05' Employee Identification
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
Attached relationships on Employee:
[ e05 ] MIN: 1 MAX: 1
Employee
logical data model
Attached relationships on logical data model:
[ e05 ] MIN: 1 MAX: 1
Employee
Date Last Altered: 6/3/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Employee Index Associative Entity
Description:
The employee index is the relationship between the employee and all of the named employee hierarchies
Alias:
LM_D_EMPE_IDX
Composition:
[PK] [FK] employee key
[PK] [FK] sales heirarchy key
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): employee key [ ASC ]
sales heirarchy key [ ASC ]
Foreign Key(s):
Employee 'ei01' Employee Index
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Sales Heirarchy 'ei02' Employee Index
sales heirarchy key -> sales heirarchy key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Attached relationships on master data organization:
[ ei01 ] MIN: 1 MAX: 1
Employee
[ ei02 ] MIN: 1 MAX: 1
Sales Heirarchy
Date Last Altered: 6/8/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
employee key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
EMPE_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Associative Entity --> Purchase Order
Entity --> Employee
Associative Entity --> Sales Order
Associative Entity --> Time Card
Attributive Entity --> Employee Identification
Attributive Entity --> Employee Address
Attributive Entity --> Employee Email
Attributive Entity --> Employee Phone
Associative Entity --> Employee Relationship
Attributive Entity --> Employee Status History
Associative Entity --> Employee Index
Date Last Altered: 6/3/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Employee Phone Attributive Entity
Description:
contains the list of phone number for this employee
Alias:
LM_D_EMPE_PHN
Composition:
[PK] [FK] employee key
[PK] phone type
phone number
time zone
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): employee key [ ASC ]
phone type [ ASC ]
Foreign Key(s):
Employee 'e08' Employee Phone
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
Attached relationships on Employee:
[ e08 ] MIN: 1 MAX: 1
Employee
logical data model
Attached relationships on logical data model:
[ e08 ] MIN: 1 MAX: 1
Employee
Date Last Altered: 6/3/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Employee Relationship Associative Entity
Description:
contains the list of relationships between one employee and any other employee
Alias:
LM_D_EMPE_RELAT
Composition:
[PK] [FK] employee key
[PK] [FK] to employee
[PK] relationship type
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): employee key [ ASC ]
to employee [ ASC ]
relationship type [ ASC ]
Foreign Key(s):
Employee 'e01' Employee Relationship
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Employee 'e02' Employee Relationship
employee key -> to employee
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
Attached relationships on Employee:
[ e01 ] MIN: 1 MAX: 1
Employee
[ e02 ] MIN: 1 MAX: 1
Employee
logical data model
Attached relationships on logical data model:
[ e01 ] MIN: 1 MAX: 1
Employee
[ e02 ] MIN: 1 MAX: 1
Employee
Date Last Altered: 6/16/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Employee Status History Attributive Entity
Description:
contains the employee attributes that are time dependent, such as type, class
Alias:
LM_D_EMPE_STUS_HIST
Composition:
[PK] [FK] employee key
[PK] time interval
employee type
race
ethnicity
compensation
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): employee key [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Employee 'e04' Employee Status History
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Employee
Attached relationships on Employee:
[ e04 ] MIN: 1 MAX: 1
Employee
logical data model
Attached relationships on logical data model:
[ e04 ] MIN: 1 MAX: 1
Employee
Date Last Altered: 6/3/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
employee type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
EMPE_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Employee Status History
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
end date Data Element
Description:
The end date of an interval of time
Alias:
END_DT
Data element attributes
Storage Type: Date
Default: '31-DEC-9999'
Null Type: NotNull
Notes:
Location:
Data Structure --> time interval
Date Last Altered: 8/4/2009 Date Created: 10/17/1996
--------------------------------------------------------------------------------------------------------------------------------------------------
end time Data Element
Description:
The time of day within the date.
Alias:
END_TM
Data element attributes
Domain: clock time
Storage Type: Time
Default: '00:00'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Associative Entity --> Time Card
Date Last Altered: 6/17/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
enumerated Data Element [Domain]
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
CD
Data element attributes
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Data Element --> address type
Data Element --> application id
Data Element --> business unit type
Data Element --> contract type
Data Element --> currency
Data Element --> customer class
Data Element --> customer type
Data Element --> employee type
Data Element --> equipment type
Data Element --> ethnicity
Data Element --> frequency
Data Element --> gender
Data Element --> identification owner
Data Element --> identification type
Data Element --> location type
Data Element --> phone type
Data Element --> race
Data Element --> relationship type
Data Element --> service type
Data Element --> specification type
Data Element --> standard industrial classification
Data Element --> supplier class
Data Element --> supplier type
Data Element --> task type
Data Element --> title
Data Element --> unit of measure
Date Last Altered: 10/24/2009 Date Created: 12/13/1995
--------------------------------------------------------------------------------------------------------------------------------------------------
equipment key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
EQUIP_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Associative Entity --> Purchase Order
Entity --> Network Equipment
Associative Entity --> Sales Order
Associative Entity --> Time Card
Associative Entity --> Network Equipment Relationship
Attributive Entity --> Network Equipment Identification
Attributive Entity --> Network Equipment Status History
Associative Entity --> Network Index
Date Last Altered: 6/3/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
equipment type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
EQUIP_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Network Equipment Status History
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
error message Data Element
Description:
The DBMS generated message for the error that was logged
Alias:
ERR_MSG
Values & Meanings:
Data element attributes
Domain: unstructured full
Storage Type: National VarChar
Length: 255
Null Type: Null
Notes:
Location:
Entity --> Processing Message Log
Date Last Altered: 8/20/2009 Date Created: 2/5/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
error number Data Element
Description:
The DBMS generated error number for the error that was logged
Alias:
ERR_NBR
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Processing Message Log
Date Last Altered: 3/16/2009 Date Created: 2/5/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
error timestamp Data Element
Description:
The DBMS time when the error occurred
Alias:
ERR_TMSTP
Data element attributes
Domain: event timestamp
Storage Type: DateTime
Default: SYSTIMESTAMP
Null Type: NotNull
Notes:
Location:
Entity --> Processing Message Log
Date Last Altered: 8/20/2009 Date Created: 2/5/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
ethnicity Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
ETHN_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Employee Status History
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Event Date Data Element
Description:
A specific chronological date using calendar conventions.
Alias:
EVENT_DT
Data element attributes
Domain: calendar date
Storage Type: Date
Default: SYSDATE
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Associative Entity --> Time Card
Date Last Altered: 6/17/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
event timestamp Data Element [Domain]
Description:
The date and time of a recorded event. Includes year, month, day, hour, minutes and seconds.
Alias:
TMSTP
Data element attributes
Storage Type: DateTime
Default: SYSTIMESTAMP
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Data Element --> access timestamp
Data Element --> error timestamp
Date Last Altered: 2/5/2009 Date Created: 6/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
exchange code Data Element
Description:
The portion of the phone number that identifies the telephone exchange
Alias:
EXCH_CD
Data element attributes
Storage Type: National VarChar
Length: 7
Null Type: Null
Location:
Data Structure --> phone number
Date Last Altered: 7/28/2009 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
extension Data Element
Description:
the portion of the phone number that identifies the PBX extension number
Alias:
EXT
Data element attributes
Storage Type: National VarChar
Length: 7
Null Type: Null
Location:
Data Structure --> phone number
Date Last Altered: 7/28/2009 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
first name Data Element
Description:
The person's first name
Alias:
FIRST_NM
Data element attributes
Storage Type: National VarChar
Length: 63
Null Type: Null
Location:
Data Structure --> person name
Date Last Altered: 7/28/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
frequency Data Element
Description:
The frequency at which the monetary amount is to be paid
Alias:
FREQ_CD
Values & Meanings:
EACH - once
WKLY - every week
MNTH - every month
etc.
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Data Structure --> monetary amount
Date Last Altered: 10/24/2009 Date Created: 6/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
gender Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
GNDR_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Entity --> Employee
Date Last Altered: 6/16/2010 Date Created: 5/28/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
geographic location Data Element
Description:
The unique identifier for this geographic location
Alias:
GEO_LOCAT
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Attributive Entity --> Customer Location History
Attributive Entity --> Network Equipment Status History
Attributive Entity --> Supplier Location History
Entity --> Geographic Location
Associative Entity --> Location Index
Date Last Altered: 5/19/2010 Date Created: 8/31/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
Geographic Location Entity
Description:
The list of geographic locations of interest to the business
Alias:
WC_R_GEO_LOCAT
Composition:
[PK] geographic location
[AK1] location type
[AK1] location id
latitude
longitude
altitude
description
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): geographic location [ ASC ]
Alternate Key 1:
Index Name: Generated by VAW
Column(s): location type [ ASC ]
location id [ ASC ]
Location:
Reference_GeographicLocation
Attached relationships on Reference_GeographicLocation:
R_GEO_LOCAT_01 MIN: 0 MAX: many
Location Index
Date Last Altered: 6/3/2010 Date Created: 12/13/1995
--------------------------------------------------------------------------------------------------------------------------------------------------
gross income Data Structure
Composition:
monetary amount
Location:
Attributive Entity --> Customer Marketing Profile History
Attributive Entity --> Supplier Purchasing Profile History
Date Last Altered: 6/8/2010 Date Created: 6/8/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
identification Data Structure
Description:
the identification for an employee, customer, vendor or product
Alias:
IDNTFCTN
Composition:
identification type
identification owner
identification number
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Business Unit Identification
Attributive Entity --> Customer Identification
Attributive Entity --> Customer Authorization
Attributive Entity --> Employee Identification
Attributive Entity --> Network Equipment Identification
Attributive Entity --> Supplier Identification
Attributive Entity --> Sales Process Task Identification
Attributive Entity --> Service Identification
Date Last Altered: 6/17/2010 Date Created: 11/15/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
identification number Data Element
Description:
The number assigned to the identification by the issuer of the identification
Alias:
ID_NBR
Data element attributes
Storage Type: National VarChar
Length: 63
Default: '0'
Null Type: NotNull
Location:
Data Structure --> identification
Date Last Altered: 7/28/2009 Date Created: 11/15/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
identification owner Data Element
Description:
the name of the entity that issued the identification
Alias:
ID_OWNR_CD
Values & Meanings:
Social Security Administration
US State Department
Immigration Service
Government of Canada
State of California
etc.
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Data Structure --> identification
Date Last Altered: 10/24/2009 Date Created: 11/15/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
identification type Data Element
Description:
The kind of identification, e.g., passport, drivers license, application system key, etc.
Alias:
ID_CD
Values & Meanings:
passport
I-90
drivers licence
SSN
etc.
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Data Structure --> identification
Date Last Altered: 10/24/2009 Date Created: 11/15/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
in use Data Element
Description:
An indicator to show whether or not the data in the row is still being used
Alias:
IN_USE_IND
Values & Meanings:
yes,
no,
unknown.
system default
Data element attributes
Storage Type: National Char
Length: 1
Default: 'Y'
Null Type: NotNull
Notes:
Location:
Data Structure --> row meta data
Date Last Altered: 8/19/2009 Date Created: 4/6/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
indicator Data Element [Domain]
Description:
An attribute whose values are a standard limited list of values.
Values & Meanings:
0 is system default
1 is Unknown
N is No
Y is Yes
The default is system default.
Data element attributes
Storage Type: National Char
Length: 1
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Data Element --> indicator code
Date Last Altered: 8/19/2009 Date Created: 12/13/1995
--------------------------------------------------------------------------------------------------------------------------------------------------
indicator code Data Element
Description:
The generalization of yes no answers
Alias:
IND_CD
Values & Meanings:
0 is system default
1 is Unknown
N is No
Y is Yes
The default is system default.
Data element attributes
Domain: indicator
Storage Type: National Char
Length: 1
Default: '0'
Null Type: NotNull
Notes:
Location:
Entity --> Indicator Value Lookup Table
Date Last Altered: 8/4/2009 Date Created: 8/1/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
Indicator Value Lookup Table Entity
Description:
The list of valid values for an indicator
Alias:
WC_V_IND_CD
Composition:
[PK] indicator code
sort order
description
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): indicator code [ ASC ]
Location:
Test
Date Last Altered: 6/3/2010 Date Created: 12/23/2008
--------------------------------------------------------------------------------------------------------------------------------------------------
last name Data Element
Description:
The person's last name
Alias:
LAST_NM
Data element attributes
Storage Type: National VarChar
Length: 63
Null Type: Null
Location:
Data Structure --> person name
Date Last Altered: 7/28/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
latitude Data Structure
Description:
The latitude of a geographic location
Alias:
LAT
Composition:
measured quantity
Location:
Entity --> Geographic Location
Date Last Altered: 8/31/2006 Date Created: 8/31/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
line number Data Element
Description:
The position at which the data could be found in the document
Alias:
LN_NBR
Values & Meanings:
Data element attributes
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Data Structure --> document
Date Last Altered: 7/28/2009 Date Created: 8/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
List Price Data Structure
Alias:
LIST_PR
Composition:
monetary amount
Location:
Associative Entity --> Sales Order
Date Last Altered: 6/3/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
location id Data Element
Description:
The coded value given to a particular location
Alias:
LOCAT_ID
Data element attributes
Domain: unstructured code
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Entity --> Geographic Location
Date Last Altered: 10/24/2009 Date Created: 12/23/2008
--------------------------------------------------------------------------------------------------------------------------------------------------
Location Index Associative Entity
Description:
The geographic location index is the relationship between the geographic location and all of the named geographic
location hierarchies
Alias:
WC_R_GEO_LOCAT_IDX
Composition:
[PK] [FK] location organization id
[PK] [FK] location organization key
[PK] [FK] geographic location
[PK] time interval
description
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): location organization id [ ASC ]
location organization key [ ASC ]
geographic location [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Geographic Location 'R_GEO_LOCAT_01' Location Index
geographic location -> geographic location
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location Organization 'R_GEO_LOCAT_ORG_01' Location Index
location organization id -> location organization id
location organization key -> location organization key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Reference_GeographicLocation
Attached relationships on Reference_GeographicLocation:
[ R_GEO_LOCAT_01 ] MIN: 1 MAX: 1
Geographic Location
[ R_GEO_LOCAT_ORG_01 ] MIN: 1 MAX: 1
Location Organization
Date Last Altered: 6/8/2010 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
Location Organization Attributive Entity
Description:
The location organization contains the hierarchy trees for each named location organization
Alias:
WC_R_GEO_LOCAT_ORG
Composition:
[PK] [FK] location organization id
[PK] location organization key
[FK] parent31
sort order
description
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): location organization id [ ASC ]
location organization key [ ASC ]
Foreign Key(s):
Location Organization Name 'R_GEO_LOCAT_ORG_NM_01Location Organizationon
location organization id -> location organization id
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location Organization 'R_GEO_LOCAT_ORG_00Location Organizationon
location organization id -> parent31
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Reference_GeographicLocation
Attached relationships on Reference_GeographicLocation:
R_GEO_LOCAT_ORG_01 MIN: 0 MAX: many
Location Index
[ R_GEO_LOCAT_ORG_NM_01 ] MIN: 1 MAX: 1
Location Organization Name
R_GEO_LOCAT_ORG_00 MIN: 0 MAX: many
Location Organization
R_GEO_LOCAT_ORG_00 MIN: 0 MAX: many
Location Organization
Date Last Altered: 6/3/2010 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
location organization id Data Element
Description:
The assigned code key for the location
Alias:
LOC_ORG_ID
Data element attributes
Domain: unstructured code
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Entity --> Location Organization Name
Attributive Entity --> Location Organization
Associative Entity --> Location Index
Date Last Altered: 10/24/2009 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
location organization key Data Element
Description:
The unique identifier for this geographic location organization table row
Alias:
LOC_ORG_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Attributive Entity --> Location Organization
Associative Entity --> Location Index
Date Last Altered: 4/20/2007 Date Created: 7/10/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
location organization name Data Element
Description:
The unique name given to an organization scheme for the geographic location
Alias:
LOC_ORG_NM
Values & Meanings:
Data element attributes
Domain: unstructured full
Storage Type: National VarChar
Length: 255
Null Type: Null
Notes:
Location:
Entity --> Location Organization Name
Date Last Altered: 9/14/2007 Date Created: 7/10/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
Location Organization Name Entity
Description:
The entity contains the list of names of the hierarchies used to organize the financial calendar
Alias:
WC_R_GEO_LOCAT_ORG_NM
Composition:
[PK] location organization id
location organization name
sort order
maximum depth
description
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): location organization id [ ASC ]
Location:
Reference_GeographicLocation
Attached relationships on Reference_GeographicLocation:
R_GEO_LOCAT_ORG_NM_01 MIN: 0 MAX: many
Location Organization
Date Last Altered: 6/3/2010 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
location type Data Element
Description:
The type of geographic location
Alias:
LOCAT_CD
Values & Meanings:
country
city
state
etc
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Entity --> Geographic Location
Date Last Altered: 12/23/2008 Date Created: 12/23/2008
--------------------------------------------------------------------------------------------------------------------------------------------------
longitude Data Structure
Description:
The longitude of a geographic location
Alias:
LONG
Composition:
measured quantity
Location:
Entity --> Geographic Location
Date Last Altered: 8/31/2006 Date Created: 8/31/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
maximum depth Data Element
Description:
The number of levels allowed in an organizational hierarchy
Alias:
MAX_DPTH
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Calendar Organization Name
Entity --> Location Organization Name
Date Last Altered: 8/20/2009 Date Created: 4/6/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
measured quantity Data Structure
Description:
An attribute that represents a physical measurement on the business data object.
Composition:
quantity
unit of measure
Notes:
One of the attribute types used to end the data analysis for a logical data
model
A measured quantity attribute type is resolved as two elements:
quantity and unit of measure. The unit of measure for a particular
attribute includes values such as each, inches, feet, pounds and rates
such as feet per second, miles per hour, etc.
Location:
Data Structure --> altitude
Data Structure --> employee count
Data Structure --> latitude
Data Structure --> longitude
Data Structure --> Purchase Quantity
Data Structure --> Sold Quantity
Data Structure --> specification measurement
Data Structure --> Used Quantity
Date Last Altered: 6/17/2010 Date Created: 6/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
middle name Data Element
Description:
The middle name of a person
Alias:
MDL_NM
Data element attributes
Storage Type: National VarChar
Length: 63
Null Type: Null
Location:
Data Structure --> person name
Date Last Altered: 7/28/2009 Date Created: 10/20/1995
--------------------------------------------------------------------------------------------------------------------------------------------------
modified date Data Element
Description:
The date on which the table row was changed
Alias:
MODF_DT
Data element attributes
Storage Type: Date
Default: SYSDATE
Null Type: NotNull
Notes:
Location:
Data Structure --> row meta data
Data Structure --> source row meta data
Date Last Altered: 8/4/2009 Date Created: 6/12/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
modified process Data Element
Description:
The identification of the person or process that changed the table row
Alias:
MODF_PRCS
Data element attributes
Storage Type: National VarChar
Length: 63
Default: 'UNSIGNED'
Null Type: NotNull
Location:
Data Structure --> row meta data
Data Structure --> source row meta data
Date Last Altered: 7/28/2009 Date Created: 4/6/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
monetary amount Data Structure
Description:
An attribute that represents an amount of money in a business transaction.
Composition:
amount
currency
frequency
Notes:
One of the attribute types used to end the data analysis for a logical data
model
A monetary amount attribute type is resolved as three element: a
value, a currency and a frequency. The currency for a particular
attribute includes codes such as pounds, US dollars, yen, etc. The
frequency codes rates such as each, per hour, per month, etc.A monetary amount attribute type is resolved as three
element: a
value, a currency and a frequency. The currency for a particular
attribute includes codes such as pounds, US dollars, yen, etc. The
frequency codes rates such as each, per hour, per month, etc.
Location:
Data Structure --> compensation
Data Structure --> credit limit
Data Structure --> current balance
Data Structure --> gross income
Data Structure --> List Price
Data Structure --> profit
Data Structure --> Purchase Price
Data Structure --> sale price
Data Structure --> sixty day balance
Data Structure --> thirty day balance
Date Last Altered: 6/17/2010 Date Created: 6/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
month name Data Element
Description:
The name of the month in the year of this working date
Alias:
MTH_NM
Values & Meanings:
January
February
March
April
May
June
July
August
September
October
November
December
Data element attributes
Domain: unstructured short
Storage Type: National VarChar
Length: 15
Null Type: Null
Notes:
Location:
Entity --> Date
Date Last Altered: 8/20/2009 Date Created: 7/13/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
month of quarter Data Element
Description:
The number of the month in the quarter of this working date
Alias:
MOQ
Values & Meanings:
1
2
3
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 9/7/2007 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
month of year Data Element
Description:
The number of the month in the year of this working date
Alias:
MOY
Values & Meanings:
1
2
3
4
5
6
7
8
9
10
11
12
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 9/7/2007 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
month short name Data Element
Description:
The short name of the month in the year of this working date
Alias:
MTH_SHRT_NM
Values & Meanings:
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Data element attributes
Domain: unstructured code
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 10/24/2009 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
name Data Element
Description:
the label for a table row
Alias:
NM
Values & Meanings:
Data element attributes
Domain: unstructured full
Storage Type: National VarChar
Length: 255
Null Type: Null
Notes:
Location:
Entity --> Network Equipment
Entity --> Sales Process Task
Entity --> Service
Date Last Altered: 6/17/2010 Date Created: 5/28/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ne01 Relationship
Attached Objects:
Network Equipment
ne01 MIN: 0 MAX: many
Purchase Order
[ ne01 ] MIN: 1 MAX: 1
Foreign Key(s):
Network Equipment 'ne01' Purchase Order
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm purchase order
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ne01 Relationship
Attached Objects:
Network Equipment
ne01 MIN: 0 MAX: many
Time Card
[ ne01 ] MIN: 1 MAX: 1
Foreign Key(s):
Network Equipment 'ne01' Time Card
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm time card
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ne01 Relationship
Attached Objects:
Network Equipment
ne01 MIN: 0 MAX: many
Network Equipment Relationship
[ ne01 ] MIN: 1 MAX: 1
Foreign Key(s):
Network Equipment 'ne01' Network Equipment Relationship
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Equipment
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ne02 Relationship
Associator Element:
to equipment
Attached Objects:
Network Equipment
ne02 MIN: 0 MAX: many
Network Equipment Relationship
[ ne02 ] MIN: 1 MAX: 1
Foreign Key(s):
Network Equipment 'ne02' Network Equipment Relationship
equipment key -> to equipment
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Equipment
logical data model
Date Last Altered: 6/7/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ne03 Relationship
Attached Objects:
Network Equipment
ne03 MIN: 0 MAX: many
Network Equipment Status History
[ ne03 ] MIN: 1 MAX: 1
Foreign Key(s):
Network Equipment 'ne03' Network Equipment Status History
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Equipment
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ne04 Relationship
Attached Objects:
Network Equipment
ne04 MIN: 0 MAX: many
Network Equipment Identification
[ ne04 ] MIN: 1 MAX: 1
Foreign Key(s):
Network Equipment 'ne04' Network Equipment Identification
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Equipment
logical data model
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ne1 Relationship
Attached Objects:
Network Equipment
ne1 MIN: 0 MAX: many
Sales Order
[ ne1 ] MIN: 1 MAX: 1
Foreign Key(s):
Network Equipment 'ne1' Sales Order
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm sales order
logical data model
Date Last Altered: 5/26/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Network Equipment Entity
Description:
the name and key of the network equipment
Alias:
LM_D_NETWK_EQUIP
Composition:
[PK] equipment key
name
description
source row meta data
row meta data
Notes:
Network Equipment and Telephony is a business object that contains the identification and description of all the
goods and information purchased, used, or created by WebEx during the service creation process. Network
Equipment items are things that WebEx
has spent money to acquire and may be offered for sale during the lifetime of WebEx.
Primary Key:
Index Name: Generated by VAW
Column(s): equipment key [ ASC ]
Location:
bm purchase order
Attached relationships on bm purchase order:
ne01 MIN: 0 MAX: many
Purchase Order
bm sales order
Attached relationships on bm sales order:
ne1 MIN: 0 MAX: many
Sales Order
bm time card
Attached relationships on bm time card:
ne01 MIN: 0 MAX: many
Time Card
Equipment
Attached relationships on Equipment:
ne01 MIN: 0 MAX: many
Network Equipment Relationship
ne02 MIN: 0 MAX: many
Network Equipment Relationship
ne03 MIN: 0 MAX: many
Network Equipment Status History
ne04 MIN: 0 MAX: many
Network Equipment Identification
logical data model
Attached relationships on logical data model:
ne1 MIN: 0 MAX: many
Sales Order
ne01 MIN: 0 MAX: many
Network Equipment Relationship
ne02 MIN: 0 MAX: many
Network Equipment Relationship
ne04 MIN: 0 MAX: many
Network Equipment Identification
ne03 MIN: 0 MAX: many
Network Equipment Status History
master data organization
Attached relationships on master data organization:
ni01 MIN: 0 MAX: many
Network Index
Date Last Altered: 6/7/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Network Equipment Identification Attributive Entity
Description:
contains the identification of a network equipment by external systems such as legal jurisdictions or application
systems
Alias:
LM_D_NETWK_EQUIP_ID
Composition:
[PK] [FK] equipment key
[PK] identification
time interval
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): equipment key [ ASC ]
identification [ ASC ]
Foreign Key(s):
Network Equipment 'ne04' Network Equipment Identification
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Equipment
Attached relationships on Equipment:
[ ne04 ] MIN: 1 MAX: 1
Network Equipment
logical data model
Attached relationships on logical data model:
[ ne04 ] MIN: 1 MAX: 1
Network Equipment
Date Last Altered: 6/9/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Network Equipment Relationship Associative Entity
Description:
contains the list of relationships between one piece of network equipment and any other piece
Alias:
LM_D_NETWK_EQUIP_RELAT
Composition:
[PK] [FK] equipment key
[PK] [FK] to equipment
[PK] relationship type
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): equipment key [ ASC ]
to equipment [ ASC ]
relationship type [ ASC ]
Foreign Key(s):
Network Equipment 'ne01' Network Equipment Relationship
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Network Equipment 'ne02' Network Equipment Relationship
equipment key -> to equipment
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Equipment
Attached relationships on Equipment:
[ ne01 ] MIN: 1 MAX: 1
Network Equipment
[ ne02 ] MIN: 1 MAX: 1
Network Equipment
logical data model
Attached relationships on logical data model:
[ ne01 ] MIN: 1 MAX: 1
Network Equipment
[ ne02 ] MIN: 1 MAX: 1
Network Equipment
Date Last Altered: 6/16/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Network Equipment Status History Attributive Entity
Description:
contains the business unit attributes that are time dependent, such as type, in production. etc.
Alias:
LM_D_NETWK_EQUIP_STUS_HIST
Composition:
[PK] [FK] equipment key
[PK] time interval
equipment type
geographic location
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): equipment key [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Network Equipment 'ne03' Network Equipment Status History
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Equipment
Attached relationships on Equipment:
[ ne03 ] MIN: 1 MAX: 1
Network Equipment
logical data model
Attached relationships on logical data model:
[ ne03 ] MIN: 1 MAX: 1
Network Equipment
Date Last Altered: 6/9/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Network Index Associative Entity
Description:
The network index is the relationship between the network equipment and all of the named network hierarchies
Alias:
LM_D_NETWK_EQUIP_IDX
Composition:
[PK] [FK] equipment key
[PK] [FK] network organization key
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): equipment key [ ASC ]
network organization key [ ASC ]
Foreign Key(s):
Network Equipment 'ni01' Network Index
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Network Organization 'ni02' Network Index
network organization key -> network organization key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Attached relationships on master data organization:
[ ni01 ] MIN: 1 MAX: 1
Network Equipment
[ ni02 ] MIN: 1 MAX: 1
Network Organization
Date Last Altered: 6/8/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Network Organization Entity
Description:
The entity contains the hierarchy trees of the network organization used to organize the company's network
equipment
Alias:
LM_D_NETWK_ORG
Composition:
[PK] network organization key
description
source row meta data
row meta data
Notes:
The Network Organization is a data object that contains the identification and description of all categories into
which the Network Equipment / Telephony subject area can be placed. In normal accounting usage, Network
Equipment items are categorized as
fixed assets, expenses, etc.
Primary Key:
Index Name: Generated by VAW
Column(s): network organization key [ ASC ]
Location:
master data organization
Attached relationships on master data organization:
ni02 MIN: 0 MAX: many
Network Index
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
network organization key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
NETWK_ORG_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Entity --> Network Organization
Associative Entity --> Network Index
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ni01 Relationship
Attached Objects:
Network Equipment
ni01 MIN: 0 MAX: many
Network Index
[ ni01 ] MIN: 1 MAX: 1
Foreign Key(s):
Network Equipment 'ni01' Network Index
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ni02 Relationship
Attached Objects:
Network Organization
ni02 MIN: 0 MAX: many
Network Index
[ ni02 ] MIN: 1 MAX: 1
Foreign Key(s):
Network Organization 'ni02' Network Index
network organization key -> network organization key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
nickname Data Element
Description:
A person's nickname
Alias:
NK_NM
Data element attributes
Storage Type: National VarChar
Length: 63
Null Type: Null
Location:
Data Structure --> person name
Date Last Altered: 7/28/2009 Date Created: 10/20/1995
--------------------------------------------------------------------------------------------------------------------------------------------------
ordinal Data Element [Domain]
Description:
An attribute used to order a series of business data objects.
Alias:
NUM
Data element attributes
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Data Element --> day of month
Data Element --> day of quarter
Data Element --> day of week
Data Element --> day of year
Data Element --> error number
Data Element --> maximum depth
Data Element --> month of quarter
Data Element --> month of year
Data Element --> quarter of year
Data Element --> sequence number
Data Element --> sort order
Data Element --> time zone
Data Element --> week of month
Data Element --> week of quarter
Data Element --> week of year
Data Element --> year
Data Element --> year short
Date Last Altered: 8/20/2009 Date Created: 6/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
parent31 Data Element [ Associator ]
Description:
The relationship between the child and the parent in the hierarchy
Alias:
PRNT31
Location:
Attributive Entity --> Location Organization
Relationship --> R_GEO_LOCAT_ORG_00
Associator element for:
Location Organization
R_GEO_LOCAT_ORG_00 MIN: 0 MAX: many
Location Organization
Date Last Altered: 3/16/2009 Date Created: 8/31/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
parent32 Data Element [ Associator ]
Description:
The relationship between the child and the parent in the hierarchy
Alias:
PRNT32
Location:
Attributive Entity --> Calendar Organization
Relationship --> R_CLNDR_ORG_00
Associator element for:
Calendar Organization
R_CLNDR_ORG_00 MIN: 0 MAX: many
Calendar Organization
Date Last Altered: 3/16/2009 Date Created: 7/10/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
percentage Data Element [Domain]
Description:
An attribute that records the number of parts in or to every hundred
Alias:
PCT
Data element attributes
Storage Type: Decimal
Length: 10, 5
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Date Last Altered: 9/7/2007 Date Created: 6/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
person name Data Structure
Description:
The structure of the name of a person
Alias:
PERSN
Composition:
title
first name
nickname
middle name
last name
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Entity --> Employee
Attributive Entity --> Customer Contact
Attributive Entity --> Supplier Contact
Date Last Altered: 6/17/2010 Date Created: 7/23/1996
--------------------------------------------------------------------------------------------------------------------------------------------------
phone number Data Structure
Description:
The address of a handset (logical phone line port) on the global telephone network
Alias:
PHONE_NBR
Composition:
country code
area code
exchange code
station code
extension
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Customer Contact Phone
Attributive Entity --> Employee Phone
Attributive Entity --> Supplier Contact Phone
Date Last Altered: 9/14/2007 Date Created: 6/20/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
phone type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
PHN_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Customer Contact Phone
Attributive Entity --> Employee Phone
Attributive Entity --> Supplier Contact Phone
Date Last Altered: 6/16/2010 Date Created: 5/28/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
postal code Data Element
Description:
The mail delivery code for the address
Alias:
PSTL_CD
Data element attributes
Storage Type: National VarChar
Length: 15
Null Type: Null
Notes:
The last part of line 5 according to the USPS
Location:
Data Structure --> address
Date Last Altered: 7/28/2009 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
process name Data Element
Description:
The name of the process that caused the log entry to be made
Alias:
PRCS_NM
Values & Meanings:
Data element attributes
Domain: unstructured full
Storage Type: National VarChar
Length: 255
Null Type: NotNull
Notes:
Location:
Entity --> Processing Message Log
Entity --> Processing Access Log
Date Last Altered: 8/20/2009 Date Created: 12/27/2008
--------------------------------------------------------------------------------------------------------------------------------------------------
Process Organization Entity
Description:
The entity contains the hierarchy trees of the process organization used to organize the company's tasks and
processes
Alias:
LM_D_PRCS_ORG
Composition:
[PK] process organization key
description
source row meta data
row meta data
Notes:
The Process Organization is a business object that contains the identification and description of all categories into
which the Process data entity can be placed. There can be different process categories for each purpose envisioned
by the business
(e.g., Sales Process, Purchase Process, Provisioning Process, etc.).
Primary Key:
Index Name: Generated by VAW
Column(s): process organization key [ ASC ]
Location:
master data organization
Attached relationships on master data organization:
ti02 MIN: 0 MAX: many
Task Index
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
process organization key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
PRCS_ORG_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Entity --> Process Organization
Associative Entity --> Task Index
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Processing Access Log Entity
Description:
The log of the database accesses made by the processes using the database
Alias:
WC_C_ACS_LOG
Composition:
[PK] access timestamp
[PK] process name
data value
description
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): access timestamp [ ASC ]
process name [ ASC ]
Location:
Test
Date Last Altered: 6/3/2010 Date Created: 2/11/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
Processing Message Log Entity
Description:
The log of the error message encounted by the processes using the database
Alias:
WC_C_ERR_LOG
Composition:
[PK] error timestamp
[PK] process name
data value
error number
error message
description
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): error timestamp [ ASC ]
process name [ ASC ]
Location:
Test
Date Last Altered: 6/3/2010 Date Created: 12/27/2008
--------------------------------------------------------------------------------------------------------------------------------------------------
production date Data Element
Description:
The date on which the row was extracted for input to the operational application.
Alias:
PRODTN_DT
Data element attributes
Storage Type: Date
Null Type: Null
Notes:
Location:
Data Structure --> row meta data
Date Last Altered: 8/19/2009 Date Created: 4/6/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
profit Data Structure
Composition:
monetary amount
Location:
Attributive Entity --> Customer Marketing Profile History
Attributive Entity --> Supplier Purchasing Profile History
Date Last Altered: 6/8/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Purchase Date Data Element
Description:
A specific chronological date using calendar conventions.
Alias:
PURCH_DT
Data element attributes
Domain: calendar date
Storage Type: Date
Default: SYSDATE
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Associative Entity --> Purchase Order
Date Last Altered: 6/17/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Purchase Order Associative Entity
Description:
The list of Purchase Order lines
Alias:
LM_F_PO
Composition:
[PK] [FK] business unit key
[PK] [FK] customer key
[PK] [FK] employee key
[PK] [FK] equipment key
[PK] [FK] service key
[PK] [FK] supplier key
[PK] [FK] task key
[PK] Purchase Date
Purchase Quantity
Purchase Price
Shipping Address
Source Document
Reference Document
description
source row meta data
row meta data
Notes:
The Purchase Order items are process measurements that the business makes during the purchase process. The
purchase process is a sequence of events (documents, states, etc.) that records the quantity and price of an
inventory item, from the initial
purchase request until the inventory item is paid for and used by the business. The business chooses the locations
in the purchasing process at which the measurements are made.
Primary Key:
Index Name: Generated by VAW
Column(s): business unit key [ ASC ]
customer key [ ASC ]
employee key [ ASC ]
equipment key [ ASC ]
service key [ ASC ]
supplier key [ ASC ]
task key [ ASC ]
Purchase Date [ ASC ]
Foreign Key(s):
Employee 'e01' Purchase Order
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Customer 'c01' Purchase Order
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Business Unit 'bu01' Purchase Order
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Service 's01' Purchase Order
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Network Equipment 'ne01' Purchase Order
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Sales Process Task 't01' Purchase Order
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Supplier 's01' Purchase Order
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm purchase order
Attached relationships on bm purchase order:
[ e01 ] MIN: 1 MAX: 1
Employee
[ c01 ] MIN: 1 MAX: 1
Customer
[ bu01 ] MIN: 1 MAX: 1
Business Unit
[ s01 ] MIN: 1 MAX: 1
Service
[ ne01 ] MIN: 1 MAX: 1
Network Equipment
[ t01 ] MIN: 1 MAX: 1
Sales Process Task
[ s01 ] MIN: 1 MAX: 1
Supplier
bm purchase order detail
Date Last Altered: 6/16/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Purchase Price Data Structure
Alias:
PURCH_PR
Composition:
monetary amount
Location:
Associative Entity --> Purchase Order
Date Last Altered: 6/17/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Purchase Quantity Data Structure
Alias:
PURCH
Composition:
measured quantity
Location:
Associative Entity --> Purchase Order
Date Last Altered: 6/17/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
quantity Data Element
Description:
The value that was recorded when the measurement was made
Alias:
QTY
Data element attributes
Storage Type: Decimal
Length: 16, 5
Default: 0
Null Type: NotNull
Location:
Data Structure --> measured quantity
Date Last Altered: 6/29/2006 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
quarter name Data Element
Description:
The name of the quarter in the year of this working date
Alias:
QTR_NM
Values & Meanings:
Data element attributes
Domain: unstructured quarter
Storage Type: National VarChar
Length: 63
Null Type: Null
Notes:
Location:
Entity --> Date
Date Last Altered: 8/4/2009 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
quarter of year Data Element
Description:
The number of the quarter in the year of this working date
Alias:
QOY
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 4/20/2007 Date Created: 7/24/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
quarter short name Data Element
Description:
The short name of the quarter in the year of this working date
Alias:
QTR_SHRT_NM
Data element attributes
Domain: unstructured code
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 10/24/2009 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
R_CLNDR_01 Relationship
Attached Objects:
Date
R_CLNDR_01 MIN: 0 MAX: many
Calendar Index
[ R_CLNDR_01 ] MIN: 1 MAX: 1
Foreign Key(s):
Date 'R_CLNDR_01' Calendar Index
working date -> working date
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Date
Reference_Calendar
Date Last Altered: 8/20/2009 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
R_CLNDR_ORG_00 Relationship
Associator Element:
parent32
Attached Objects:
Calendar Organization
R_CLNDR_ORG_00 MIN: 0 MAX: many
Calendar Organization
[ R_CLNDR_ORG_00 ] MIN: 1 MAX: 1
Foreign Key(s):
Calendar Organization 'R_CLNDR_ORG_00Calendar Organizationon
calendar organization id -> parent32
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Date
Reference_Calendar
Date Last Altered: 8/20/2009 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
R_CLNDR_ORG_01 Relationship
Attached Objects:
Calendar Organization
R_CLNDR_ORG_01 MIN: 0 MAX: many
Calendar Index
[ R_CLNDR_ORG_01 ] MIN: 1 MAX: 1
Foreign Key(s):
Calendar Organization 'R_CLNDR_ORG_01' Calendar Index
calendar organization id -> calendar organization id
calendar organization key -> calendar organization key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Date
Reference_Calendar
Date Last Altered: 8/20/2009 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
R_CLNDR_ORG_NM_01 Relationship
Attached Objects:
Calendar Organization Name
R_CLNDR_ORG_NM_01 MIN: 0 MAX: many
Calendar Organization
[ R_CLNDR_ORG_NM_01 ] MIN: 1 MAX: 1
Foreign Key(s):
Calendar Organization Name 'R_CLNDR_ORG_NM_01Calendar Organizationon
calendar organization id -> calendar organization id
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Date
Reference_Calendar
Date Last Altered: 8/20/2009 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
R_GEO_LOCAT_01 Relationship
Attached Objects:
Geographic Location
R_GEO_LOCAT_01 MIN: 0 MAX: many
Location Index
[ R_GEO_LOCAT_01 ] MIN: 1 MAX: 1
Foreign Key(s):
Geographic Location 'R_GEO_LOCAT_01' Location Index
geographic location -> geographic location
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Reference_GeographicLocation
Date Last Altered: 8/20/2009 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
R_GEO_LOCAT_ORG_00 Relationship
Associator Element:
parent31
Attached Objects:
Location Organization
R_GEO_LOCAT_ORG_00 MIN: 0 MAX: many
Location Organization
[ R_GEO_LOCAT_ORG_00 ] MIN: 1 MAX: 1
Foreign Key(s):
Location Organization 'R_GEO_LOCAT_ORG_00Location Organizationon
location organization id -> parent31
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Reference_GeographicLocation
Date Last Altered: 8/20/2009 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
R_GEO_LOCAT_ORG_01 Relationship
Attached Objects:
Location Organization
R_GEO_LOCAT_ORG_01 MIN: 0 MAX: many
Location Index
[ R_GEO_LOCAT_ORG_01 ] MIN: 1 MAX: 1
Foreign Key(s):
Location Organization 'R_GEO_LOCAT_ORG_01' Location Index
location organization id -> location organization id
location organization key -> location organization key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Reference_GeographicLocation
Date Last Altered: 8/20/2009 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
R_GEO_LOCAT_ORG_NM_01 Relationship
Attached Objects:
Location Organization Name
R_GEO_LOCAT_ORG_NM_01 MIN: 0 MAX: many
Location Organization
[ R_GEO_LOCAT_ORG_NM_01 ] MIN: 1 MAX: 1
Foreign Key(s):
Location Organization Name 'R_GEO_LOCAT_ORG_NM_01Location Organizationon
location organization id -> location organization id
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
Reference_GeographicLocation
Date Last Altered: 8/20/2009 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
race Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
RACE_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Employee Status History
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Reference Document Data Structure
Alias:
RFER_DOC
Composition:
document
Location:
Associative Entity --> Purchase Order
Associative Entity --> Sales Order
Associative Entity --> Time Card
Date Last Altered: 6/3/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
relationship type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
RELAT_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Associative Entity --> Business Unit Relationship
Associative Entity --> Customer Relationship
Associative Entity --> Employee Relationship
Associative Entity --> Network Equipment Relationship
Associative Entity --> Supplier Relationship
Associative Entity --> Sales Process Task Relationship
Associative Entity --> Service Relationship
Date Last Altered: 6/16/2010 Date Created: 5/28/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
row meta data Data Structure
Description:
The fields attached to each row in a table to track the events that happened to the row
Alias:
RMD
Composition:
create date
create process
in use
production date
modified date
modified process
Notes:
One of the attributes added to an entity during the database design
process as the design moves from logical design to physical
implementation.
The attribute describes the when, who, and how of the table row.
Location:
Associative Entity --> Purchase Order
Entity --> Customer
Entity --> Employee
Entity --> Network Equipment
Entity --> Supplier
Entity --> Sales Process Task
Entity --> Service
Entity --> Business Unit
Associative Entity --> Sales Order
Associative Entity --> Time Card
Attributive Entity --> Business Unit Status History
Associative Entity --> Business Unit Relationship
Attributive Entity --> Business Unit Identification
Attributive Entity --> Business Unit Address
Attributive Entity --> Customer Contract History
Attributive Entity --> Customer Identification
Attributive Entity --> Customer Authorization
Attributive Entity --> Customer Balance History
Attributive Entity --> Customer Bill Information
Attributive Entity --> Customer Address
Attributive Entity --> Customer Contact
Attributive Entity --> Customer Status History
Attributive Entity --> Customer Marketing Profile History
Associative Entity --> Customer Relationship
Attributive Entity --> Customer Location History
Attributive Entity --> Customer Contact Email
Attributive Entity --> Customer Contact Phone
Entity --> Date
Associative Entity --> Calendar Index
Attributive Entity --> Calendar Organization
Entity --> Calendar Organization Name
Attributive Entity --> Employee Identification
Attributive Entity --> Employee Address
Attributive Entity --> Employee Email
Attributive Entity --> Employee Phone
Associative Entity --> Employee Relationship
Attributive Entity --> Employee Status History
Associative Entity --> Network Equipment Relationship
Attributive Entity --> Network Equipment Identification
Attributive Entity --> Network Equipment Status History
Associative Entity --> Supplier Relationship
Attributive Entity --> Supplier Contract History
Attributive Entity --> Supplier Address
Attributive Entity --> Supplier Contact
Attributive Entity --> Supplier Contact Email
Attributive Entity --> Supplier Contact Phone
Attributive Entity --> Supplier Identification
Attributive Entity --> Supplier Location History
Attributive Entity --> Supplier Purchasing Profile History
Attributive Entity --> Supplier Status History
Associative Entity --> Sales Process Task Relationship
Attributive Entity --> Sales Process Task Identification
Attributive Entity --> Sales Process Task Status History
Associative Entity --> Service Relationship
Attributive Entity --> Service Identification
Attributive Entity --> Service List Price History
Attributive Entity --> Service Specification
Attributive Entity --> Service Status History
Entity --> Chart of Accounts
Entity --> Territory Organization
Entity --> Supplier Organization
Entity --> Service Catalog
Entity --> Sales Heirarchy
Entity --> Network Organization
Entity --> Process Organization
Associative Entity --> Business Unit Index
Associative Entity --> Customer Index
Associative Entity --> Supplier Index
Associative Entity --> Service Index
Associative Entity --> Employee Index
Associative Entity --> Network Index
Associative Entity --> Task Index
Entity --> Geographic Location
Entity --> Location Organization Name
Attributive Entity --> Location Organization
Associative Entity --> Location Index
Entity --> Indicator Value Lookup Table
Entity --> Processing Message Log
Entity --> Processing Access Log
Entity --> Database Version Log
Date Last Altered: 6/3/2010 Date Created: 9/3/1996
--------------------------------------------------------------------------------------------------------------------------------------------------
s01 Relationship
Attached Objects:
Service
s01 MIN: 0 MAX: many
Purchase Order
[ s01 ] MIN: 1 MAX: 1
Foreign Key(s):
Service 's01' Purchase Order
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm purchase order
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s01 Relationship
Attached Objects:
Supplier
s01 MIN: 0 MAX: many
Purchase Order
[ s01 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's01' Purchase Order
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm purchase order
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s01 Relationship
Attached Objects:
Supplier
s01 MIN: 0 MAX: many
Time Card
[ s01 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's01' Time Card
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm time card
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s01 Relationship
Attached Objects:
Service
s01 MIN: 0 MAX: many
Time Card
[ s01 ] MIN: 1 MAX: 1
Foreign Key(s):
Service 's01' Time Card
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm time card
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s01 Relationship
Attached Objects:
Supplier
s01 MIN: 0 MAX: many
Supplier Relationship
[ s01 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's01' Supplier Relationship
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Supplier
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s01 Relationship
Attached Objects:
Service
s01 MIN: 0 MAX: many
Service Relationship
[ s01 ] MIN: 1 MAX: 1
Foreign Key(s):
Service 's01' Service Relationship
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Service
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s02 Relationship
Associator Element:
to supplier
Attached Objects:
Supplier
s02 MIN: 0 MAX: many
Supplier Relationship
[ s02 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's02' Supplier Relationship
supplier key -> to supplier
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Supplier
Date Last Altered: 6/7/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s02 Relationship
Associator Element:
to service
Attached Objects:
Service
s02 MIN: 0 MAX: many
Service Relationship
[ s02 ] MIN: 1 MAX: 1
Foreign Key(s):
Service 's02' Service Relationship
service key -> to service
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Service
Date Last Altered: 6/7/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s03 Relationship
Attached Objects:
Supplier
s03 MIN: 0 MAX: many
Supplier Contract History
[ s03 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's03' Supplier Contract History
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Supplier
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s03 Relationship
Attached Objects:
Service
s03 MIN: 0 MAX: many
Service Status History
[ s03 ] MIN: 1 MAX: 1
Foreign Key(s):
Service 's03' Service Status History
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Service
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s04 Relationship
Attached Objects:
Supplier
s04 MIN: 0 MAX: many
Supplier Location History
[ s04 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's04' Supplier Location History
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Supplier
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s04 Relationship
Attached Objects:
Service
s04 MIN: 0 MAX: many
Service List Price History
[ s04 ] MIN: 1 MAX: 1
Foreign Key(s):
Service 's04' Service List Price History
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Service
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s05 Relationship
Attached Objects:
Supplier
s05 MIN: 0 MAX: many
Supplier Purchasing Profile History
[ s05 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's05' Supplier Purchasing Profile History
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Supplier
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s05 Relationship
Attached Objects:
Service
s05 MIN: 0 MAX: many
Service Identification
[ s05 ] MIN: 1 MAX: 1
Foreign Key(s):
Service 's05' Service Identification
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Service
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s06 Relationship
Attached Objects:
Supplier
s06 MIN: 0 MAX: many
Supplier Status History
[ s06 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's06' Supplier Status History
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Supplier
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s06 Relationship
Attached Objects:
Service
s06 MIN: 0 MAX: many
Service Specification
[ s06 ] MIN: 1 MAX: 1
Foreign Key(s):
Service 's06' Service Specification
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Service
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s07 Relationship
Attached Objects:
Supplier
s07 MIN: 0 MAX: many
Supplier Address
[ s07 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's07' Supplier Address
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Supplier
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s08 Relationship
Attached Objects:
Supplier
s08 MIN: 0 MAX: many
Supplier Identification
[ s08 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's08' Supplier Identification
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Supplier
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s09 Relationship
Attached Objects:
Supplier
s09 MIN: 0 MAX: many
Supplier Contact
[ s09 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's09' Supplier Contact
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Supplier
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s1 Relationship
Attached Objects:
Service
s1 MIN: 0 MAX: many
Sales Order
[ s1 ] MIN: 1 MAX: 1
Foreign Key(s):
Service 's1' Sales Order
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm sales order
logical data model
Date Last Altered: 5/26/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
s1 Relationship
Attached Objects:
Supplier
s1 MIN: 0 MAX: many
Sales Order
[ s1 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 's1' Sales Order
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm sales order
logical data model
Date Last Altered: 5/26/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
sale price Data Structure
Alias:
SLS_PR
Composition:
monetary amount
Location:
Associative Entity --> Sales Order
Attributive Entity --> Customer Contract History
Attributive Entity --> Supplier Contract History
Attributive Entity --> Service List Price History
Date Last Altered: 6/17/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Sales Date Data Element
Sales Order::Sales Date
Description:
A specific chronological date using calendar conventions.
Alias:
SLS_DT
Data element attributes
Domain: calendar date
Storage Type: Date
Default: SYSDATE
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Associative Entity --> Sales Order
Date Last Altered: 6/3/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Sales Heirarchy Entity
Description:
The entity contains the hierarchy trees of the sales heirarchies used to organize the company's employees
Alias:
LM_D_SLS_HIER
Composition:
[PK] sales heirarchy key
description
source row meta data
row meta data
Notes:
The Sales Hierarchy is a data object that contains the identification and description of all categories into which the
Employees can be placed. There can be different employee categories for each purpose envisioned by the business
(e.g., Sales Hierarchy,
Cross Functional Team, Apollo Project Team, etc.).
Primary Key:
Index Name: Generated by VAW
Column(s): sales heirarchy key [ ASC ]
Location:
master data organization
Attached relationships on master data organization:
ei02 MIN: 0 MAX: many
Employee Index
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
sales heirarchy key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
SLS_HIER_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Entity --> Sales Heirarchy
Associative Entity --> Employee Index
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Sales Order Associative Entity
Description:
The list of Sales Order lines
Alias:
LM_F_SO
Composition:
[PK] [FK] business unit key
[PK] [FK] customer key
[PK] [FK] employee key
[PK] [FK] equipment key
[PK] [FK] service key
[PK] [FK] supplier key
[PK] [FK] task key
[PK] Sales Date
Sold Quantity
sale price
List Price
Shipping Address
Source Document
Reference Document
description
source row meta data
row meta data
Notes:
The Sales Order items are the process measurements that the business makes during the sales order process. The
sales order process is a sequence of events (documents, states, etc.) that records the quantity and price of a service,
from the initial sales
opportunity until the service is paid for and used by the customer. The business chooses the points in the sales
order process at which the measurements are made.
Primary Key:
Index Name: Generated by VAW
Column(s): business unit key [ ASC ]
service key [ ASC ]
equipment key [ ASC ]
supplier key [ ASC ]
task key [ ASC ]
employee key [ ASC ]
customer key [ ASC ]
Sales Date [ ASC ]
Foreign Key(s):
Customer 'c12' Sales Order
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Employee 'e1' Sales Order
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Business Unit 'bu1' Sales Order
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Service 's1' Sales Order
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Network Equipment 'ne1' Sales Order
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Supplier 's1' Sales Order
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Sales Process Task 't1' Sales Order
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm sales order
Attached relationships on bm sales order:
[ c12 ] MIN: 1 MAX: 1
Customer
[ e1 ] MIN: 1 MAX: 1
Employee
[ bu1 ] MIN: 1 MAX: 1
Business Unit
[ s1 ] MIN: 1 MAX: 1
Service
[ ne1 ] MIN: 1 MAX: 1
Network Equipment
[ s1 ] MIN: 1 MAX: 1
Supplier
[ t1 ] MIN: 1 MAX: 1
Sales Process Task
bm sales order detail
logical data model
Attached relationships on logical data model:
[ e1 ] MIN: 1 MAX: 1
Employee
[ c12 ] MIN: 1 MAX: 1
Customer
[ s1 ] MIN: 1 MAX: 1
Supplier
[ bu1 ] MIN: 1 MAX: 1
Business Unit
[ t1 ] MIN: 1 MAX: 1
Sales Process Task
[ s1 ] MIN: 1 MAX: 1
Service
[ ne1 ] MIN: 1 MAX: 1
Network Equipment
Date Last Altered: 6/17/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Sales Process Task Entity
Description:
the name and key of the tasks performed in the company
Alias:
LM_D_TASK
Composition:
[PK] task key
name
description
source row meta data
row meta data
Notes:
Sales Process Task is a business object that contains the identification and description of all the processes
(activities or tasks) that are have been used by the business in the past, are currently used by the business or are
planned to be used by the
business. These processes can be processes, functions, tasks, activities, etc. An example of business tasks is the
documentation provided for the ISO 9000 certification.
Primary Key:
Index Name: Generated by VAW
Column(s): task key [ ASC ]
Location:
bm purchase order
Attached relationships on bm purchase order:
t01 MIN: 0 MAX: many
Purchase Order
bm sales order
Attached relationships on bm sales order:
t1 MIN: 0 MAX: many
Sales Order
bm time card
Attached relationships on bm time card:
t01 MIN: 0 MAX: many
Time Card
logical data model
Attached relationships on logical data model:
t1 MIN: 0 MAX: many
Sales Order
t01 MIN: 0 MAX: many
Sales Process Task Relationship
t02 MIN: 0 MAX: many
Sales Process Task Relationship
t04 MIN: 0 MAX: many
Sales Process Task Identification
t03 MIN: 0 MAX: many
Sales Process Task Status History
master data organization
Attached relationships on master data organization:
ti01 MIN: 0 MAX: many
Task Index
Task
Attached relationships on Task:
t01 MIN: 0 MAX: many
Sales Process Task Relationship
t02 MIN: 0 MAX: many
Sales Process Task Relationship
t03 MIN: 0 MAX: many
Sales Process Task Status History
t04 MIN: 0 MAX: many
Sales Process Task Identification
Date Last Altered: 6/7/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Sales Process Task Identification Attributive Entity
Description:
contains the identification of a customer by external systems such as legal jurisdictions or application systems
Alias:
LM_D_TASK_ID
Composition:
[PK] [FK] task key
[PK] identification
time interval
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): task key [ ASC ]
identification [ ASC ]
Foreign Key(s):
Sales Process Task 't04' Sales Process Task Identification
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ t04 ] MIN: 1 MAX: 1
Sales Process Task
Task
Attached relationships on Task:
[ t04 ] MIN: 1 MAX: 1
Sales Process Task
Date Last Altered: 6/3/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Sales Process Task Relationship Associative Entity
Description:
contains the list of relationships between one task/process and any other task/process, ie. between a task and the
parent
Alias:
LM_D_TASK_RELAT
Composition:
[PK] [FK] task key
[PK] [FK] to task
[PK] relationship type
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): task key [ ASC ]
to task [ ASC ]
relationship type [ ASC ]
Foreign Key(s):
Sales Process Task 't01' Sales Process Task Relationship
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Sales Process Task 't02' Sales Process Task Relationship
task key -> to task
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ t01 ] MIN: 1 MAX: 1
Sales Process Task
[ t02 ] MIN: 1 MAX: 1
Sales Process Task
Task
Attached relationships on Task:
[ t01 ] MIN: 1 MAX: 1
Sales Process Task
[ t02 ] MIN: 1 MAX: 1
Sales Process Task
Date Last Altered: 6/16/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Sales Process Task Status History Attributive Entity
Description:
contains the task/process attributes that are time dependent, such as type, class
Alias:
LM_D_TASK_STUS_HIST
Composition:
[PK] [FK] task key
[PK] time interval
task type
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): task key [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Sales Process Task 't03' Sales Process Task Status History
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ t03 ] MIN: 1 MAX: 1
Sales Process Task
Task
Attached relationships on Task:
[ t03 ] MIN: 1 MAX: 1
Sales Process Task
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
sc01 Relationship
Attached Objects:
Supplier Contact
sc01 MIN: 0 MAX: many
Supplier Contact Phone
[ sc01 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier Contact 'sc01' Supplier Contact Phone
supplier key -> supplier key
supplier contact key -> supplier contact key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Supplier
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
sc02 Relationship
Attached Objects:
Supplier Contact
sc02 MIN: 0 MAX: many
Supplier Contact Email
[ sc02 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier Contact 'sc02' Supplier Contact Email
supplier key -> supplier key
supplier contact key -> supplier contact key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Supplier
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
season name Data Element
Description:
The name of the season in the year of this working date
Alias:
SESN_NM
Values & Meanings:
Data element attributes
Domain: unstructured quarter
Storage Type: National VarChar
Length: 63
Null Type: Null
Notes:
Location:
Entity --> Date
Date Last Altered: 8/4/2009 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
season short name Data Element
Description:
The short name of the season in the year of this working date
Alias:
SESN_SHRT_NM
Data element attributes
Domain: unstructured code
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 10/24/2009 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
sequence number Data Element
Description:
The sequence of a subset of table rows
Alias:
SEQ_NBR
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 1
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Date Last Altered: 2/3/2010 Date Created: 2/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Service Entity
Description:
the entity contains the name and key of the service/product sold by the company
Alias:
LM_D_SRVC
Composition:
[PK] service key
name
description
source row meta data
row meta data
Notes:
Service is a business object that contains the identification, description, specification and prices of all the Services
that WebEx has sold in the past, is selling currently or plans to sell in the future. These Services can be goods,
services, or
information. The Services include shipping services, handling services, and third party Services such as taxes that
are resold for government suppliers.
Primary Key:
Index Name: Generated by VAW
Column(s): service key [ ASC ]
Location:
bm purchase order
Attached relationships on bm purchase order:
s01 MIN: 0 MAX: many
Purchase Order
bm sales order
Attached relationships on bm sales order:
s1 MIN: 0 MAX: many
Sales Order
bm time card
Attached relationships on bm time card:
s01 MIN: 0 MAX: many
Time Card
logical data model
Attached relationships on logical data model:
s1 MIN: 0 MAX: many
Sales Order
s01 MIN: 0 MAX: many
Service Relationship
s02 MIN: 0 MAX: many
Service Relationship
s05 MIN: 0 MAX: many
Service Identification
s04 MIN: 0 MAX: many
Service List Price History
s06 MIN: 0 MAX: many
Service Specification
s03 MIN: 0 MAX: many
Service Status History
master data organization
Attached relationships on master data organization:
svi01 MIN: 0 MAX: many
Service Index
Service
Attached relationships on Service:
s01 MIN: 0 MAX: many
Service Relationship
s02 MIN: 0 MAX: many
Service Relationship
s03 MIN: 0 MAX: many
Service Status History
s04 MIN: 0 MAX: many
Service List Price History
s05 MIN: 0 MAX: many
Service Identification
s06 MIN: 0 MAX: many
Service Specification
Date Last Altered: 6/16/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Service Catalog Entity
Description:
The entity contains the hierarchy trees of the service catalogs used to organize the company's services
Alias:
LM_D_SRVC_CATLG
Composition:
[PK] service catalog key
description
source row meta data
row meta data
Notes:
The Service Catalog is a data object that contains the identification and description of all categories into which the
Service can be placed. There can be different Service categories for each purpose envisioned by the company
(e.g., Large Business,
Small Business, Consumer, etc.).
Primary Key:
Index Name: Generated by VAW
Column(s): service catalog key [ ASC ]
Location:
master data organization
Attached relationships on master data organization:
svi02 MIN: 0 MAX: many
Service Index
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
service catalog key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
SRVC_CATLG_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Entity --> Service Catalog
Associative Entity --> Service Index
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Service Identification Attributive Entity
Description:
contains the identification of a service by external systems such as bar codes or application systems
Alias:
LM_D_SRVC_ID
Composition:
[PK] [FK] service key
[PK] identification
time interval
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): service key [ ASC ]
identification [ ASC ]
Foreign Key(s):
Service 's05' Service Identification
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s05 ] MIN: 1 MAX: 1
Service
Service
Attached relationships on Service:
[ s05 ] MIN: 1 MAX: 1
Service
Date Last Altered: 6/3/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Service Index Associative Entity
Description:
The service index is the relationship between the service unit and all of the named service catalog hierarchies
Alias:
LM_D_SRVC_IDX
Composition:
[PK] [FK] service key
[PK] [FK] service catalog key
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): service key [ ASC ]
service catalog key [ ASC ]
Foreign Key(s):
Service 'svi01' Service Index
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Service Catalog 'svi02' Service Index
service catalog key -> service catalog key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Attached relationships on master data organization:
[ svi01 ] MIN: 1 MAX: 1
Service
[ svi02 ] MIN: 1 MAX: 1
Service Catalog
Date Last Altered: 6/8/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
service key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
SRVC_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Associative Entity --> Purchase Order
Entity --> Service
Associative Entity --> Sales Order
Associative Entity --> Time Card
Attributive Entity --> Customer Contract History
Attributive Entity --> Supplier Contract History
Associative Entity --> Service Relationship
Attributive Entity --> Service Identification
Attributive Entity --> Service List Price History
Attributive Entity --> Service Specification
Attributive Entity --> Service Status History
Associative Entity --> Service Index
Date Last Altered: 6/3/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Service List Price History Attributive Entity
Description:
contains the service list price which is time dependent
Alias:
LM_D_SRVC_PR_HIST
Composition:
[PK] [FK] service key
[PK] time interval
sale price
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): service key [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Service 's04' Service List Price History
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s04 ] MIN: 1 MAX: 1
Service
Service
Attached relationships on Service:
[ s04 ] MIN: 1 MAX: 1
Service
Date Last Altered: 6/17/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Service Relationship Associative Entity
Description:
contains the list of relationships between one service and any other service, ie. is part of a bundle
Alias:
LM_D_SRVC_RELAT
Composition:
[PK] [FK] service key
[PK] [FK] to service
[PK] relationship type
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): service key [ ASC ]
to service [ ASC ]
relationship type [ ASC ]
Foreign Key(s):
Service 's01' Service Relationship
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Service 's02' Service Relationship
service key -> to service
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s01 ] MIN: 1 MAX: 1
Service
[ s02 ] MIN: 1 MAX: 1
Service
Service
Attached relationships on Service:
[ s01 ] MIN: 1 MAX: 1
Service
[ s02 ] MIN: 1 MAX: 1
Service
Date Last Altered: 6/16/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Service Specification Attributive Entity
Description:
contain the detailed specification of the service or product
Alias:
LM_D_SRVC_SPEC
Composition:
[PK] [FK] service key
[PK] specification type
specification measurement
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): service key [ ASC ]
specification type [ ASC ]
Foreign Key(s):
Service 's06' Service Specification
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s06 ] MIN: 1 MAX: 1
Service
Service
Attached relationships on Service:
[ s06 ] MIN: 1 MAX: 1
Service
Date Last Altered: 6/17/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Service Status History Attributive Entity
Description:
contains the service attributes that are time dependent, such as type, class
Alias:
LM_D_SRVC_STUS_HIST
Composition:
[PK] [FK] service key
[PK] time interval
service type
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): service key [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Service 's03' Service Status History
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s03 ] MIN: 1 MAX: 1
Service
Service
Attached relationships on Service:
[ s03 ] MIN: 1 MAX: 1
Service
Date Last Altered: 6/3/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
service type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
SRVC_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Service Status History
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Shipping Address Data Structure
Alias:
SHIP_ADDR
Composition:
address
Location:
Associative Entity --> Purchase Order
Associative Entity --> Sales Order
Date Last Altered: 6/17/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
si01 Relationship
Attached Objects:
Supplier
si01 MIN: 0 MAX: many
Supplier Index
[ si01 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier 'si01' Supplier Index
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
si02 Relationship
Attached Objects:
Supplier Organization
si02 MIN: 0 MAX: many
Supplier Index
[ si02 ] MIN: 1 MAX: 1
Foreign Key(s):
Supplier Organization 'si02' Supplier Index
supplier organization key -> supplier organization key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
sixty day balance Data Structure
Composition:
monetary amount
Location:
Attributive Entity --> Customer Balance History
Date Last Altered: 6/8/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Sold Quantity Data Structure
Alias:
SOLD_QTY
Composition:
measured quantity
Location:
Associative Entity --> Sales Order
Date Last Altered: 6/3/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
sort order Data Element
Description:
the display order for the table rows
Alias:
SORT_ORD
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Attributive Entity --> Calendar Organization
Entity --> Calendar Organization Name
Entity --> Location Organization Name
Attributive Entity --> Location Organization
Entity --> Indicator Value Lookup Table
Date Last Altered: 9/14/2007 Date Created: 4/6/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
Source Document Data Structure
Alias:
SRCE_DOC
Composition:
document
Location:
Associative Entity --> Purchase Order
Associative Entity --> Sales Order
Associative Entity --> Time Card
Date Last Altered: 6/3/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
source row meta data Data Structure
Description:
the description of how the table row was created and modified by the source operational application
Alias:
SRMD
Composition:
application id
create date
create process
modified date
modified process
Notes:
One of the attributes added to an entity during the database design
process as the design moves from logical design to physical
implementation.
Location:
Associative Entity --> Purchase Order
Entity --> Customer
Entity --> Employee
Entity --> Network Equipment
Entity --> Supplier
Entity --> Sales Process Task
Entity --> Service
Entity --> Business Unit
Associative Entity --> Sales Order
Associative Entity --> Time Card
Attributive Entity --> Business Unit Status History
Associative Entity --> Business Unit Relationship
Attributive Entity --> Business Unit Identification
Attributive Entity --> Business Unit Address
Attributive Entity --> Customer Contract History
Attributive Entity --> Customer Identification
Attributive Entity --> Customer Authorization
Attributive Entity --> Customer Balance History
Attributive Entity --> Customer Bill Information
Attributive Entity --> Customer Address
Attributive Entity --> Customer Contact
Attributive Entity --> Customer Status History
Attributive Entity --> Customer Marketing Profile History
Associative Entity --> Customer Relationship
Attributive Entity --> Customer Location History
Attributive Entity --> Customer Contact Email
Attributive Entity --> Customer Contact Phone
Associative Entity --> Calendar Index
Attributive Entity --> Employee Identification
Attributive Entity --> Employee Address
Attributive Entity --> Employee Email
Attributive Entity --> Employee Phone
Associative Entity --> Employee Relationship
Attributive Entity --> Employee Status History
Associative Entity --> Network Equipment Relationship
Attributive Entity --> Network Equipment Identification
Attributive Entity --> Network Equipment Status History
Associative Entity --> Supplier Relationship
Attributive Entity --> Supplier Contract History
Attributive Entity --> Supplier Address
Attributive Entity --> Supplier Contact
Attributive Entity --> Supplier Contact Email
Attributive Entity --> Supplier Contact Phone
Attributive Entity --> Supplier Identification
Attributive Entity --> Supplier Location History
Attributive Entity --> Supplier Purchasing Profile History
Attributive Entity --> Supplier Status History
Associative Entity --> Sales Process Task Relationship
Attributive Entity --> Sales Process Task Identification
Attributive Entity --> Sales Process Task Status History
Associative Entity --> Service Relationship
Attributive Entity --> Service Identification
Attributive Entity --> Service List Price History
Attributive Entity --> Service Specification
Attributive Entity --> Service Status History
Entity --> Chart of Accounts
Entity --> Territory Organization
Entity --> Supplier Organization
Entity --> Service Catalog
Entity --> Sales Heirarchy
Entity --> Network Organization
Entity --> Process Organization
Associative Entity --> Business Unit Index
Associative Entity --> Customer Index
Associative Entity --> Supplier Index
Associative Entity --> Service Index
Associative Entity --> Employee Index
Associative Entity --> Network Index
Associative Entity --> Task Index
Date Last Altered: 6/3/2010 Date Created: 8/8/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
specification measurement Data Structure
Alias:
SPEC
Composition:
measured quantity
Location:
Attributive Entity --> Service Specification
Date Last Altered: 6/17/2010 Date Created: 6/17/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
specification type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
SPEC_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Service Specification
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
standard industrial classification Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
SIC_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Customer Marketing Profile History
Attributive Entity --> Supplier Purchasing Profile History
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
start date Data Element
Description:
The beginning date of a time interval
Alias:
STRT_DT
Data element attributes
Storage Type: Date
Default: '01-JAN-1900'
Null Type: NotNull
Notes:
Location:
Data Structure --> time interval
Date Last Altered: 8/4/2009 Date Created: 10/17/1996
--------------------------------------------------------------------------------------------------------------------------------------------------
Start Time Data Element
Description:
The time of day within the date.
Alias:
STRT_TM
Data element attributes
Domain: clock time
Storage Type: Time
Default: '00:00'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Associative Entity --> Time Card
Date Last Altered: 6/17/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
state Data Element
Description:
The state in which the city is located
Alias:
ST
Values & Meanings:
Data element attributes
Storage Type: National VarChar
Length: 63
Default: 0
Null Type: NotNull
Notes:
The second part of line 5 according to the USPS
Location:
Data Structure --> address
Date Last Altered: 7/28/2009 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
station code Data Element
Description:
The portion of the phone number that identifies the handset.
Alias:
STATN_CD
Data element attributes
Storage Type: National VarChar
Length: 7
Null Type: Null
Location:
Data Structure --> phone number
Date Last Altered: 7/28/2009 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
street Data Element
Description:
The street number and street name of the postal address
Alias:
STRET
Values & Meanings:
Data element attributes
Storage Type: National VarChar
Length: 63
Null Type: Null
Notes:
The delivery address (line 4) according to the USPS
Location:
Data Structure --> address
Date Last Altered: 7/28/2009 Date Created: 6/29/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
structured Data Element [Domain]
Description:
Alphanumeric data that can be decomposed into attributes with the structured data object.
Values & Meanings:
An attribute that describes a business data object or data that has not been analysed for structured contents
Data element attributes
Storage Type: National VarChar
Length: 255
Null Type: Null
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Date Last Altered: 10/24/2009 Date Created: 6/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
suite Data Element
Description:
The suite or apartment number of the address
Alias:
APT
Values & Meanings:
Data element attributes
Domain: unstructured short
Storage Type: National VarChar
Length: 15
Null Type: Null
Notes:
Location:
Data Structure --> address
Date Last Altered: 8/19/2009 Date Created: 8/4/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Entity
Description:
the name and the key of the supplier
Alias:
LM_D_SUPLR
Composition:
[PK] supplier key
description
source row meta data
row meta data
Notes:
The Supplier is a business object that contains the identification and description of all the suppliers that interact
with WebEx at the start of the service creation process. Suppliers are the entities that WebEx sends money to for
goods, services or
information. Or we sent them money in the past. Or we expect to send them money in the future. These suppliers
can be individuals, other businesses, governments, the business itself, subsidiaries, etc.
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
Location:
bm purchase order
Attached relationships on bm purchase order:
s01 MIN: 0 MAX: many
Purchase Order
bm sales order
Attached relationships on bm sales order:
s1 MIN: 0 MAX: many
Sales Order
bm time card
Attached relationships on bm time card:
s01 MIN: 0 MAX: many
Time Card
logical data model
Attached relationships on logical data model:
s1 MIN: 0 MAX: many
Sales Order
s01 MIN: 0 MAX: many
Supplier Relationship
s02 MIN: 0 MAX: many
Supplier Relationship
s03 MIN: 0 MAX: many
Supplier Contract History
s07 MIN: 0 MAX: many
Supplier Address
s09 MIN: 0 MAX: many
Supplier Contact
s08 MIN: 0 MAX: many
Supplier Identification
s04 MIN: 0 MAX: many
Supplier Location History
s05 MIN: 0 MAX: many
Supplier Purchasing Profile History
s06 MIN: 0 MAX: many
Supplier Status History
master data organization
Attached relationships on master data organization:
si01 MIN: 0 MAX: many
Supplier Index
Supplier
Attached relationships on Supplier:
s01 MIN: 0 MAX: many
Supplier Relationship
s02 MIN: 0 MAX: many
Supplier Relationship
s03 MIN: 0 MAX: many
Supplier Contract History
s04 MIN: 0 MAX: many
Supplier Location History
s05 MIN: 0 MAX: many
Supplier Purchasing Profile History
s06 MIN: 0 MAX: many
Supplier Status History
s07 MIN: 0 MAX: many
Supplier Address
s08 MIN: 0 MAX: many
Supplier Identification
s09 MIN: 0 MAX: many
Supplier Contact
Date Last Altered: 6/7/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Address Attributive Entity
Description:
contains the list of supplier addresses
Alias:
LM_D_SUPLR_ADDR
Composition:
[PK] [FK] supplier key
[PK] address type
address
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
address type [ ASC ]
Foreign Key(s):
Supplier 's07' Supplier Address
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s07 ] MIN: 1 MAX: 1
Supplier
Supplier
Attached relationships on Supplier:
[ s07 ] MIN: 1 MAX: 1
Supplier
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
supplier class Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
SUPLR_CLAS_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Supplier Status History
Date Last Altered: 6/16/2010 Date Created: 6/8/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Contact Attributive Entity
Description:
contains the list of people at the supplier that can be contacted
Alias:
LM_D_SUPLR_CNTCT
Composition:
[PK] [FK] supplier key
[PK] supplier contact key
person name
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
supplier contact key [ ASC ]
Foreign Key(s):
Supplier 's09' Supplier Contact
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s09 ] MIN: 1 MAX: 1
Supplier
sc02 MIN: 0 MAX: many
Supplier Contact Email
sc01 MIN: 0 MAX: many
Supplier Contact Phone
Supplier
Attached relationships on Supplier:
[ s09 ] MIN: 1 MAX: 1
Supplier
sc01 MIN: 0 MAX: many
Supplier Contact Phone
sc02 MIN: 0 MAX: many
Supplier Contact Email
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Contact Email Attributive Entity
Description:
contains the list of email addresses for this supplier contact
Alias:
LM_D_SUPLR_CNTCT_EMAIL
Composition:
[PK] [FK] supplier key
[PK] [FK] supplier contact key
[PK] email name
[PK] domain
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
supplier contact key [ ASC ]
email name [ ASC ]
domain [ ASC ]
Foreign Key(s):
Supplier Contact 'sc02' Supplier Contact Email
supplier key -> supplier key
supplier contact key -> supplier contact key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ sc02 ] MIN: 1 MAX: 1
Supplier Contact
Supplier
Attached relationships on Supplier:
[ sc02 ] MIN: 1 MAX: 1
Supplier Contact
Date Last Altered: 6/16/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
supplier contact key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
SUPLR_CNTCT_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Attributive Entity --> Supplier Contact
Attributive Entity --> Supplier Contact Email
Attributive Entity --> Supplier Contact Phone
Date Last Altered: 6/16/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Contact Phone Attributive Entity
Description:
contains the list of phone number for this supplier contact
Alias:
LM_D_SUPLR_CNTCT_PHN
Composition:
[PK] [FK] supplier key
[PK] [FK] supplier contact key
[PK] phone type
phone number
time zone
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
supplier contact key [ ASC ]
phone type [ ASC ]
Foreign Key(s):
Supplier Contact 'sc01' Supplier Contact Phone
supplier key -> supplier key
supplier contact key -> supplier contact key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ sc01 ] MIN: 1 MAX: 1
Supplier Contact
Supplier
Attached relationships on Supplier:
[ sc01 ] MIN: 1 MAX: 1
Supplier Contact
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Contract History Attributive Entity
Description:
contains the service and sale price for a supplier's contract
Alias:
LM_D_SUPLR_CONTR_HIST
Composition:
[PK] [FK] supplier key
[PK] time interval
[PK] contract type
service key
sale price
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
time interval [ ASC ]
contract type [ ASC ]
Foreign Key(s):
Supplier 's03' Supplier Contract History
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s03 ] MIN: 1 MAX: 1
Supplier
Supplier
Attached relationships on Supplier:
[ s03 ] MIN: 1 MAX: 1
Supplier
Date Last Altered: 6/16/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Identification Attributive Entity
Description:
contains the identification of a supplier by external systems such as legal jurisdictions or application systems
Alias:
LM_D_SUPLR_ID
Composition:
[PK] [FK] supplier key
[PK] identification
time interval
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
identification [ ASC ]
Foreign Key(s):
Supplier 's08' Supplier Identification
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s08 ] MIN: 1 MAX: 1
Supplier
Supplier
Attached relationships on Supplier:
[ s08 ] MIN: 1 MAX: 1
Supplier
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
Supplier Index Associative Entity
Description:
The supplier index is the relationship between the supplier and all of the named supplier unit hierarchies
Alias:
LM_D_SUPLR_IDX
Composition:
[PK] [FK] supplier key
[PK] [FK] supplier organization key
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
supplier organization key [ ASC ]
Foreign Key(s):
Supplier 'si01' Supplier Index
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Supplier Organization 'si02' Supplier Index
supplier organization key -> supplier organization key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Attached relationships on master data organization:
[ si01 ] MIN: 1 MAX: 1
Supplier
[ si02 ] MIN: 1 MAX: 1
Supplier Organization
Date Last Altered: 6/8/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
supplier key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
SUPLR_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Associative Entity --> Purchase Order
Entity --> Supplier
Associative Entity --> Sales Order
Associative Entity --> Time Card
Associative Entity --> Supplier Relationship
Attributive Entity --> Supplier Contract History
Attributive Entity --> Supplier Address
Attributive Entity --> Supplier Contact
Attributive Entity --> Supplier Contact Email
Attributive Entity --> Supplier Contact Phone
Attributive Entity --> Supplier Identification
Attributive Entity --> Supplier Location History
Attributive Entity --> Supplier Purchasing Profile History
Attributive Entity --> Supplier Status History
Associative Entity --> Supplier Index
Date Last Altered: 6/3/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Location History Attributive Entity
Description:
contains the supplier location values that are time dependent
Alias:
LM_D_SUPLR_LOCAT_HIST
Composition:
[PK] [FK] supplier key
[PK] time interval
geographic location
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Supplier 's04' Supplier Location History
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s04 ] MIN: 1 MAX: 1
Supplier
Supplier
Attached relationships on Supplier:
[ s04 ] MIN: 1 MAX: 1
Supplier
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Organization Entity
Description:
The entity contains the hierarchy trees of the supplier organization used to organize the company's suppliers
Alias:
LM_D_SUPLR_ORG
Composition:
[PK] supplier organization key
description
source row meta data
row meta data
Notes:
The Supplier Organization is a data object that contains the identification and description of all categories into
which the Supplier can be placed. There can be different supplier categories for each purpose envisioned by the
business (e.g., Supplier
Tiers, Logistics, etc.).
Primary Key:
Index Name: Generated by VAW
Column(s): supplier organization key [ ASC ]
Location:
master data organization
Attached relationships on master data organization:
si02 MIN: 0 MAX: many
Supplier Index
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
supplier organization key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
SUPLR_ORG_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Entity --> Supplier Organization
Associative Entity --> Supplier Index
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Purchasing Profile History Attributive Entity
Description:
contains the supplier purchasing values that are time dependent
Alias:
LM_D_SUPLR_PURCH_HIST
Composition:
[PK] [FK] supplier key
[PK] time interval
standard industrial classification
employee count
gross income
profit
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Supplier 's05' Supplier Purchasing Profile History
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s05 ] MIN: 1 MAX: 1
Supplier
Supplier
Attached relationships on Supplier:
[ s05 ] MIN: 1 MAX: 1
Supplier
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Relationship Associative Entity
Description:
contains the list of relationships between one supplier and any other supplier, ie. between a supplier and a
substitute supplier
Alias:
LM_D_SUPLR_RELAT
Composition:
[PK] [FK] supplier key
[PK] [FK] to supplier
[PK] relationship type
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
to supplier [ ASC ]
relationship type [ ASC ]
Foreign Key(s):
Supplier 's01' Supplier Relationship
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Supplier 's02' Supplier Relationship
supplier key -> to supplier
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s01 ] MIN: 1 MAX: 1
Supplier
[ s02 ] MIN: 1 MAX: 1
Supplier
Supplier
Attached relationships on Supplier:
[ s01 ] MIN: 1 MAX: 1
Supplier
[ s02 ] MIN: 1 MAX: 1
Supplier
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Supplier Status History Attributive Entity
Description:
contains the supplier attributes that are time dependent, such as type, class
Alias:
LM_D_SUPLR_STUS_HIST
Composition:
[PK] [FK] supplier key
[PK] time interval
supplier type
supplier class
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): supplier key [ ASC ]
time interval [ ASC ]
Foreign Key(s):
Supplier 's06' Supplier Status History
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Attached relationships on logical data model:
[ s06 ] MIN: 1 MAX: 1
Supplier
Supplier
Attached relationships on Supplier:
[ s06 ] MIN: 1 MAX: 1
Supplier
Date Last Altered: 6/8/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
supplier type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
SUPLR_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Supplier Status History
Date Last Altered: 6/16/2010 Date Created: 6/8/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
svi01 Relationship
Attached Objects:
Service
svi01 MIN: 0 MAX: many
Service Index
[ svi01 ] MIN: 1 MAX: 1
Foreign Key(s):
Service 'svi01' Service Index
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
svi02 Relationship
Attached Objects:
Service Catalog
svi02 MIN: 0 MAX: many
Service Index
[ svi02 ] MIN: 1 MAX: 1
Foreign Key(s):
Service Catalog 'svi02' Service Index
service catalog key -> service catalog key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
t01 Relationship
Attached Objects:
Sales Process Task
t01 MIN: 0 MAX: many
Purchase Order
[ t01 ] MIN: 1 MAX: 1
Foreign Key(s):
Sales Process Task 't01' Purchase Order
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm purchase order
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
t01 Relationship
Attached Objects:
Sales Process Task
t01 MIN: 0 MAX: many
Time Card
[ t01 ] MIN: 1 MAX: 1
Foreign Key(s):
Sales Process Task 't01' Time Card
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm time card
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
t01 Relationship
Attached Objects:
Sales Process Task
t01 MIN: 0 MAX: many
Sales Process Task Relationship
[ t01 ] MIN: 1 MAX: 1
Foreign Key(s):
Sales Process Task 't01' Sales Process Task Relationship
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Task
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
t02 Relationship
Associator Element:
to task
Attached Objects:
Sales Process Task
t02 MIN: 0 MAX: many
Sales Process Task Relationship
[ t02 ] MIN: 1 MAX: 1
Foreign Key(s):
Sales Process Task 't02' Sales Process Task Relationship
task key -> to task
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Task
Date Last Altered: 6/7/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
t03 Relationship
Attached Objects:
Sales Process Task
t03 MIN: 0 MAX: many
Sales Process Task Status History
[ t03 ] MIN: 1 MAX: 1
Foreign Key(s):
Sales Process Task 't03' Sales Process Task Status History
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Task
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
t04 Relationship
Attached Objects:
Sales Process Task
t04 MIN: 0 MAX: many
Sales Process Task Identification
[ t04 ] MIN: 1 MAX: 1
Foreign Key(s):
Sales Process Task 't04' Sales Process Task Identification
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
logical data model
Task
Date Last Altered: 6/1/2010 Date Created: 6/1/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
t1 Relationship
Attached Objects:
Sales Process Task
t1 MIN: 0 MAX: many
Sales Order
[ t1 ] MIN: 1 MAX: 1
Foreign Key(s):
Sales Process Task 't1' Sales Order
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm sales order
logical data model
Date Last Altered: 5/26/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
table key Data Element [Domain]
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
KEY
Data element attributes
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Data Element --> business unit key
Data Element --> calendar organization key
Data Element --> chart of account key
Data Element --> customer contact key
Data Element --> customer key
Data Element --> employee key
Data Element --> equipment key
Data Element --> geographic location
Data Element --> location organization key
Data Element --> network organization key
Data Element --> process organization key
Data Element --> sales heirarchy key
Data Element --> service catalog key
Data Element --> service key
Data Element --> supplier contact key
Data Element --> supplier key
Data Element --> supplier organization key
Data Element --> task key
Data Element --> territory key
Date Last Altered: 6/17/2010 Date Created: 12/13/1995
--------------------------------------------------------------------------------------------------------------------------------------------------
Task Index Associative Entity
Description:
The task index is the relationship between the sales process task and all of the named process hierarchies
Alias:
LM_D_TASK_IDX
Composition:
[PK] [FK] task key
[PK] [FK] process organization key
description
source row meta data
row meta data
Primary Key:
Index Name: Generated by VAW
Column(s): task key [ ASC ]
process organization key [ ASC ]
Foreign Key(s):
Sales Process Task 'ti01' Task Index
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Process Organization 'ti02' Task Index
process organization key -> process organization key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Attached relationships on master data organization:
[ ti01 ] MIN: 1 MAX: 1
Sales Process Task
[ ti02 ] MIN: 1 MAX: 1
Process Organization
Date Last Altered: 6/8/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
task key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
TASK_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Associative Entity --> Purchase Order
Entity --> Sales Process Task
Associative Entity --> Sales Order
Associative Entity --> Time Card
Associative Entity --> Sales Process Task Relationship
Attributive Entity --> Sales Process Task Identification
Attributive Entity --> Sales Process Task Status History
Associative Entity --> Task Index
Date Last Altered: 6/3/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
task type Data Element
Description:
The attribute that is constrainted to a list of allowed values. For example, color, unit of measure, currency, etc.
Alias:
TASK_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Sales Process Task Status History
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
territory key Data Element
Description:
A system generated number used to uniquely designate each row of one entity
Alias:
TERR_KEY
Data element attributes
Domain: table key
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data model
One of the attributes added to an entity during the database design process as the design moves from logical
design to physical implementation.
Location:
Entity --> Territory Organization
Associative Entity --> Customer Index
Date Last Altered: 6/16/2010 Date Created: 5/26/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Territory Organization Entity
Description:
The entity contains the hierarchy trees of the territory organization used to organize the company's customers
Alias:
LM_D_TERR_ORG
Composition:
[PK] territory key
description
source row meta data
row meta data
Notes:
Territory is a data object that contains the identification and description of all categories into which the Customer
can be placed. There can be different Customer categories for each purpose envisioned by WebEx (e.g., Sales,
Logistics, Marketing,
Customer Segmentation, etc.).
Primary Key:
Index Name: Generated by VAW
Column(s): territory key [ ASC ]
Location:
master data organization
Attached relationships on master data organization:
ci02 MIN: 0 MAX: many
Customer Index
Date Last Altered: 6/8/2010 Date Created: 5/19/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
thirty day balance Data Structure
Composition:
monetary amount
Location:
Attributive Entity --> Customer Balance History
Date Last Altered: 6/8/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ti01 Relationship
Attached Objects:
Sales Process Task
ti01 MIN: 0 MAX: many
Task Index
[ ti01 ] MIN: 1 MAX: 1
Foreign Key(s):
Sales Process Task 'ti01' Task Index
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
ti02 Relationship
Attached Objects:
Process Organization
ti02 MIN: 0 MAX: many
Task Index
[ ti02 ] MIN: 1 MAX: 1
Foreign Key(s):
Process Organization 'ti02' Task Index
process organization key -> process organization key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
master data organization
Date Last Altered: 6/7/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
Time Card Associative Entity
Description:
The list of Time Card lines
Alias:
LM_F_TC
Composition:
[PK] [FK] business unit key
[PK] [FK] customer key
[PK] [FK] employee key
[PK] [FK] equipment key
[PK] [FK] service key
[PK] [FK] supplier key
[PK] [FK] task key
[PK] Event Date
[PK] Start Time
end time
time interval
Used Quantity
Source Document
Reference Document
description
source row meta data
row meta data
Notes:
The Sales Events are measurements of the time an employee spends in a Sales Process Task during the course of
selling WebEx Services. A set of sales process events is a time card that records the tasks (state changes) as the
employee navigates the sales
process.
Primary Key:
Index Name: Generated by VAW
Column(s): business unit key [ ASC ]
customer key [ ASC ]
employee key [ ASC ]
equipment key [ ASC ]
service key [ ASC ]
supplier key [ ASC ]
task key [ ASC ]
Event Date [ ASC ]
Start Time [ ASC ]
Foreign Key(s):
Customer 'c01' Time Card
customer key -> customer key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Employee 'e01' Time Card
employee key -> employee key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Network Equipment 'ne01' Time Card
equipment key -> equipment key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Supplier 's01' Time Card
supplier key -> supplier key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Sales Process Task 't01' Time Card
task key -> task key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Service 's01' Time Card
service key -> service key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Business Unit 'bu01' Time Card
business unit key -> business unit key
On Delete Restrict
On Update Restrict
On Insert of Child Row Restrict
Location:
bm time card
Attached relationships on bm time card:
[ c01 ] MIN: 1 MAX: 1
Customer
[ e01 ] MIN: 1 MAX: 1
Employee
[ ne01 ] MIN: 1 MAX: 1
Network Equipment
[ s01 ] MIN: 1 MAX: 1
Supplier
[ t01 ] MIN: 1 MAX: 1
Sales Process Task
[ s01 ] MIN: 1 MAX: 1
Service
[ bu01 ] MIN: 1 MAX: 1
Business Unit
bm time card detail
Date Last Altered: 6/16/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
time interval Data Structure
Description:
The specification of a time interval with a start and an end.
Alias:
TME_INTVL
Composition:
start date
end date
Notes:
One of the attribute types used to end the data analysis for a logical data
model
The time interval includes both the start date and the end date
Location:
Associative Entity --> Time Card
Attributive Entity --> Business Unit Status History
Attributive Entity --> Business Unit Identification
Attributive Entity --> Customer Contract History
Attributive Entity --> Customer Identification
Attributive Entity --> Customer Balance History
Attributive Entity --> Customer Status History
Attributive Entity --> Customer Marketing Profile History
Attributive Entity --> Customer Location History
Associative Entity --> Calendar Index
Attributive Entity --> Employee Identification
Attributive Entity --> Employee Status History
Attributive Entity --> Network Equipment Identification
Attributive Entity --> Network Equipment Status History
Attributive Entity --> Supplier Contract History
Attributive Entity --> Supplier Identification
Attributive Entity --> Supplier Location History
Attributive Entity --> Supplier Purchasing Profile History
Attributive Entity --> Supplier Status History
Attributive Entity --> Sales Process Task Identification
Attributive Entity --> Sales Process Task Status History
Attributive Entity --> Service Identification
Attributive Entity --> Service List Price History
Attributive Entity --> Service Status History
Associative Entity --> Location Index
Date Last Altered: 6/16/2010 Date Created: 6/12/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
time zone Data Element
Description:
An attribute used to order a series of business data objects.
Alias:
TME_ZONE
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Attributive Entity --> Customer Contact Phone
Attributive Entity --> Employee Phone
Attributive Entity --> Supplier Contact Phone
Date Last Altered: 6/16/2010 Date Created: 6/3/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
title Data Element
Description:
the courtesy title for the person
Alias:
TITL_CD
Values & Meanings:
Mr.
Mrs.
Ms.
Dr.
Prof.
etc.
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Data Structure --> person name
Date Last Altered: 10/24/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
to business unit Data Element [ Associator ]
Alias:
TO_BU
Location:
Associative Entity --> Business Unit Relationship
Relationship --> bu02
Associator element for:
Business Unit
bu02 MIN: 0 MAX: many
Business Unit Relationship
Date Last Altered: 6/17/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
to customer Data Element [ Associator ]
Alias:
TO_CUST
Location:
Associative Entity --> Customer Relationship
Relationship --> cr2
Associator element for:
Customer
cr2 MIN: 0 MAX: many
Customer Relationship
Date Last Altered: 6/17/2010 Date Created: 5/28/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
to employee Data Element [ Associator ]
Alias:
TO_EMPE
Location:
Associative Entity --> Employee Relationship
Relationship --> e02
Associator element for:
Employee
e02 MIN: 0 MAX: many
Employee Relationship
Date Last Altered: 6/17/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
to equipment Data Element [ Associator ]
Alias:
TO_EQUIP
Location:
Associative Entity --> Network Equipment Relationship
Relationship --> ne02
Associator element for:
Network Equipment
ne02 MIN: 0 MAX: many
Network Equipment Relationship
Date Last Altered: 6/17/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
to service Data Element [ Associator ]
Alias:
TO_SRVC
Location:
Associative Entity --> Service Relationship
Relationship --> s02
Associator element for:
Service
s02 MIN: 0 MAX: many
Service Relationship
Date Last Altered: 6/16/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
to supplier Data Element [ Associator ]
Alias:
TO_SUPLR
Location:
Associative Entity --> Supplier Relationship
Relationship --> s02
Associator element for:
Supplier
s02 MIN: 0 MAX: many
Supplier Relationship
Date Last Altered: 6/16/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
to task Data Element [ Associator ]
Alias:
TO_TASK
Location:
Associative Entity --> Sales Process Task Relationship
Relationship --> t02
Associator element for:
Sales Process Task
t02 MIN: 0 MAX: many
Sales Process Task Relationship
Date Last Altered: 6/16/2010 Date Created: 6/7/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
unit of measure Data Element
Description:
The measurement units (e.g. inches, feet, meters, etc.) used when making the measurement
Alias:
UOM_CD
Data element attributes
Domain: enumerated
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
Location:
Data Structure --> measured quantity
Date Last Altered: 10/24/2009 Date Created: 6/28/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
unstructured code Data Element [Domain]
Description:
A string data type
Data element attributes
Storage Type: National VarChar
Length: 4
Default: '0'
Null Type: NotNull
Notes:
One of the attribute types used to end the data analysis for a logical data
model
Location:
Data Element --> calendar organization id
Data Element --> day short name
Data Element --> location id
Data Element --> location organization id
Data Element --> month short name
Data Element --> quarter short name
Data Element --> season short name
Date Last Altered: 10/24/2009 Date Created: 10/24/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
unstructured eighth Data Element [Domain]
Description:
A string data type
Values & Meanings:
An unstructured attribute type is resolved as an element of type
character that we can record the description of the attribute. A description or comment attribute is of type unstructured.
Data element attributes
Storage Type: National VarChar
Length: 31
Null Type: Null
Notes:
One of the attribute types used to end the data analysis for a logical data
model (unstructured string)
Date Last Altered: 10/24/2009 Date Created: 7/28/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
unstructured full Data Element [Domain]
Description:
A string data type
Values & Meanings:
An unstructured attribute type is resolved as an element of type
character that we can record the description of the attribute. A description or comment attribute is of type unstructured.
Data element attributes
Storage Type: National VarChar
Length: 255
Null Type: Null
Notes:
One of the attribute types used to end the data analysis for a logical data
model (unstructured string)
Location:
Data Element --> business unit name
Data Element --> customer name
Data Element --> data value
Data Element --> description
Data Element --> domain
Data Element --> email name
Data Element --> error message
Data Element --> location organization name
Data Element --> name
Data Element --> process name
Date Last Altered: 6/16/2010 Date Created: 12/13/1995
--------------------------------------------------------------------------------------------------------------------------------------------------
unstructured half Data Element
Description:
A string data type
Values & Meanings:
An unstructured attribute type is resolved as an element of type
character that we can record the description of the attribute. A description or comment attribute is of type unstructured.
Data element attributes
Storage Type: National VarChar
Length: 127
Null Type: Null
Notes:
One of the attribute types used to end the data analysis for a logical data
model (unstructured string)
Date Last Altered: 10/24/2009 Date Created: 7/28/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
unstructured quarter Data Element [Domain]
Description:
A string data type
Values & Meanings:
An unstructured attribute type is resolved as an element of type
character that we can record the description of the attribute. A description or comment attribute is of type unstructured.
Data element attributes
Storage Type: National VarChar
Length: 63
Null Type: Null
Notes:
One of the attribute types used to end the data analysis for a logical data
model (unstructured string)
Location:
Data Element --> calendar organization name
Data Element --> day name
Data Element --> quarter name
Data Element --> season name
Data Element --> version number
Date Last Altered: 10/24/2009 Date Created: 7/28/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
unstructured short Data Element [Domain]
Description:
A string data type
Values & Meanings:
An unstructured attribute type is resolved as an element of type
character that we can record the description of the attribute. A description or comment attribute is of type unstructured.
Data element attributes
Storage Type: National VarChar
Length: 15
Null Type: Null
Notes:
One of the attribute types used to end the data analysis for a logical data
model (unstructured string)
Location:
Data Element --> month name
Data Element --> suite
Date Last Altered: 10/24/2009 Date Created: 7/28/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
Used Quantity Data Structure
Alias:
USE
Composition:
measured quantity
Location:
Associative Entity --> Time Card
Date Last Altered: 6/17/2010 Date Created: 5/13/2010
--------------------------------------------------------------------------------------------------------------------------------------------------
version date Data Element
Description:
the date of the current database version
Alias:
VRSN_DT
Values & Meanings:
.
Data element attributes
Domain: calendar date
Storage Type: Date
Default: SYSDATE
Null Type: NotNull
Notes:
Location:
Entity --> Database Version Log
Date Last Altered: 3/17/2009 Date Created: 3/17/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
version number Data Element
Description:
the number of the current database
Alias:
VRSN_NBR
Values & Meanings:
Data element attributes
Domain: unstructured quarter
Storage Type: National VarChar
Length: 63
Null Type: Null
Notes:
Location:
Entity --> Database Version Log
Date Last Altered: 8/5/2009 Date Created: 3/17/2009
--------------------------------------------------------------------------------------------------------------------------------------------------
week of month Data Element
Description:
The number of the week in the month of this working date
Alias:
WOM
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 4/20/2007 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
week of quarter Data Element
Description:
The number of the week in the quarter of this working date
Alias:
WOQ
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 9/7/2007 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
week of year Data Element
Description:
The number of the week in the year of this working date
Alias:
WOY
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 4/20/2007 Date Created: 7/9/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
working date Data Element [Domain]
Description:
The key of the financial calendar
Alias:
WRKG_DT
Values & Meanings:
the minimum value of working date is 1/1/1900
the maximum value of working date is 12/31/9999
Data element attributes
Domain: calendar date
Storage Type: Date
Default: SYSDATE
Null Type: NotNull
Notes:
Location:
Entity --> Date
Associative Entity --> Calendar Index
Date Last Altered: 5/28/2010 Date Created: 7/10/2006
--------------------------------------------------------------------------------------------------------------------------------------------------
year Data Element
Description:
The 4 digit number of the year
Alias:
YR
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 9/7/2007 Date Created: 7/13/2007
--------------------------------------------------------------------------------------------------------------------------------------------------
year short Data Element
Description:
The 2 digit number of the year
Alias:
YR_SHRT
Data element attributes
Domain: ordinal
Storage Type: Decimal
Length: 10
Default: 0
Null Type: NotNull
Notes:
Location:
Entity --> Date
Date Last Altered: 9/7/2007 Date Created: 9/7/2007
--------------------------------------------------------------------------------------------------------------------------------------------------