3 Logical Data Model Dimensions

1.

ACCESS METHOD TOTAL

Code for All Access Method.

1

ACCESS METHOD TYPE CODE

A code, used to uniquely identify the access method type.

FLTN

2

ACCESS METHOD TYPE DESC

A textual description of the Access Method Type.

Fixed Line Telephone Numbers

3

ACCESS METHOD TYPE NAME

The name assigned to the Access Method Type.

Fixed Line Telephone Numbers

4

LANGUAGE CODE

Unique identifier for Language

1

ACCESS METHOD CODE

A sequence of numbers (like phone number) electronically registered to telecommunications equipment that gives the Customer access to services or products. Other access method like DSL account, Service ID might be character type.

867558305000

2

ACCESS METHOD DESC

Access method full description.

WRLS867558305000

3

ACCESS METHOD NAME

ACCESS METHOD NAME. ACCESS METHOD NAME

WRLS867558305000

4

ACCESS METHOD POOL CODE

Unique identifier for Access Method Pool

5

ACCESS METHOD SEGMENT CODE

Unique identifier for Access Method Segment

1

ACCESS METHOD TYPE CODE

A code, used to uniquely identify a access method type.

FLTN

2

ACCOUNT CODE

This is usually natural key of the account. Optional column, At certain time period, the access method may not be bound to an account.

10000101

3

CUSTOMER SELECT INDICATOR

Indicates whether the phone number (access method identifier) is selected by a customer.

4

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column.

12/31/2005 12:00:00 AM

5

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column.

12/31/2005 12:00:00 AM

6

NETWORK CODE

Identifier of the network.

7

SILENT NUMBER INDICATOR

An indicator that indicates whether a party has a silent number. A silent number could not be found on the White Pages. access method full description

8

STATUS CODE

Current STATUS CODE, standard SCD2 column.

9

SWITCH CODE

Unique identifier for Switch

1.

ACCOUNT PAYMENT METHOD STATUS TYPE TOTAL

Code for All Account Payment Method Status Type.

1

ACCOUNT PAYMENT METHOD STATUS TYPE CODE

Code for Direct Debit Status

CHECK

2

ACCOUNT PAYMENT METHOD STATUS TYPE DESC

Direct Debit Status Description

CHECK

3

ACCOUNT PAYMENT METHOD STATUS TYPE NAME

Direct Debit Status Short Description

Transaction By Check

4

LANGUAGE CODE

Unique identifier for Language

1.

ACCOUNT REFUND REASON TOTAL

Code for All Account Refund Reason.

1

ACCOUNT REFUND REASON CODE

A code, used to uniquely identify ACCOUNT REFUND REASON.

INVCADJ

2

ACCOUNT REFUND REASON DESC

A textual description of ACCOUNT REFUND REASON.

Invoice Adjustment

3

ACCOUNT REFUND REASON NAME

The name assigned to ACCOUNT REFUND REASON.

Invoice Adjustment

4

LANGUAGE CODE

Unique identifier for Language

1.

ADDRESS LOCATION TOTAL

Code for All Address Locations.

1

ADDRESS DESCRIPTION

Address description. Textual description of the address.

2

ADDRESS LATITUDE MEASURE

This is the Latitude value of the specified location

3

ADDRESS LINE 1

Address. Line one of detailed postal address

123 Park Avenue

4

ADDRESS LINE 2

Address. Line two of detailed postal address

ABC Tower

5

ADDRESS LINE 3

Address. Line three of detailed postal address

Suite 1111

6

ADDRESS LINES PHONETIC

Phonetic or Kana representation of the Kanji address lines (used in Japan)

7

ADDRESS LOCATION CODE

unique identifier for the address.

8

ADDRESS LONGITUDE MEASURE

This is the longitude location of the specified address.

9

ADDRESS STYLE

Any specific style of the address. It might include the detail like All Capital words, case, font and so on.

10

ADDRESS TYPE CODE

Unique identifier for the address type.

Shipping

11

REGION NAME

Name of the Reason

12

SUBREGION DESC

description of sub region

13

TAX AUTHORITY CODE

Unique identified for the tax authority

14

WORLD DESC

Description of world

15

WORLD NAME

Name of the world

16

ADDRESS LATITUDE MEASURE

This is the Latitude value of the specified location

17

POSTAL PLUS CODE

Four digit extension to the United States Postal ZIP code.

18

STREET CODE

Uniquely identifier of state

19

CITY DESC

Description of the city

20

FLAT ROOM CODE

Uniquely identifier of the flat room

21

GEOGRAPHY STATE CODE

State of the geography

22

POST OFFICE BOX

PO box if available.

23

STATE DESC

Description of the state

24

STATE NAME

Name of the state

26

BUILDING DESC

Description for Building

27

COUNTY DESC

Description for County

28

GEOGRAPHY COUNTRY CODE

Code for Geography Country

29

POSTCODE CODE

Code for Post Code

30

ADDRESS DESCRIPTION

Address description. Textual description of the address.

31

ADDRESS TYPE CODE

Unique identifier for the address type.

32

BUILDING NAME

Name for Building

33

COUNTY NAME

Name for County

34

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column.

35

FLAT ROOM DESC

Description for Flat Room

36

GEOGRAPHY COUNTY CODE

Code for Geography County

37

GEOGRAPHY ENTITY CODE

unique geography identifier. A unique identifier for the geography entities, could be a system generated unique key for Geography entity.

38

REGION DESC

Description for Region

39

WORLD CODE

Description for World

42

LONGITUDE

The angular distance between a point on any meridian and the prime meridian at Greenwich

43

PRIMARY ADDRESS TELEPHONE

Telephonic address

44

STATUS CODE

An indicator of the address current status. For instance, this address may be valid, invalid, temporary, and so on.

47

COUNTRY NAME

Name for Country

48

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column.

49

EMPLOYEE CODE

Code for Employee

50

FLOOR DESC

Description for Floor

51

SUBREGION NAME

Name for Subregion

52

ADDRESS LOCATION CODE

unique identifier for the address.

53

CITY NAME

Name for City

54

COUNTRY DESC

Description for Country

55

FLAT ROOM NAME

Name for Flat Room

56

GEOGRAPHY CITY CODE

Code for Geography City

57

GEOGRAPHY SUBREGION CODE

Code for Geography Subregion

58

STREET DESC

Description for Street

59

STREET NAME

Name for Street

60

TIME ZONE CODE

Unique Identifier for time zone.

GEOGRAPHY LOCATION CODE

ELEVATION

ELEVATION UOM CODE

GEOGRAPHY REGION CODE

PRIMARY EMAIL ADDRESS

1.

AGE BAND TOTAL

Code for All Age Bands.

1

AGE BAND CODE

Code for Age band.

AGBND1

2

AGE BAND DESC

Long Description for age band value.

Age Band 21-30

3

AGE BAND FROM

Lower limit of age value of the slab.

21

4

AGE BAND NAME

Description for age band value.

Age Band 21-30

5

AGE BAND TO

Upper limit of age value of the slab.

30

6

LANGUAGE CODE

Unique identifier for Language

1.

AGE ON NET BAND TOTAL

Code for All Age On Net Band.

1

AGE ON NET BAND CODE

Code for age on Net band.

AGBND1

2

AGE ON NET BAND DESC

Long Description for age on net band value.

Age on net Band 0-20

3

AGE ON NET BAND FROM

Lower limit of age on net band value of the slab.

21

4

AGE ON NET BAND NAME

Description for age on net band value.

Age on net Band 21-30

5

AGE ON NET BAND TO

Upper limit of age on net band value of the slab.

30

6

LANGUAGE CODE

Unique identifier for Language.

1.

ARPU BAND TOTAL

Code for All ARPU Band.

1

ARPU BAND CODE

Unique identifier for revenue band. For example: 0_1000, 1000_3000.

ARPU1000

2

ARPU BAND DESC

Description revenue band.

ARPU Ranging From 0-1000

3

ARPU BAND END VALUE

The end point of a band (the end point is included in the band).

$1,000.00

4

ARPU BAND END VALUE LOCAL

The end point of a band.

5

ARPU BAND END VALUE REPORTING

The end point of a band.

6

ARPU BAND NAME

Name of revenue band.

7

ARPU BAND START VALUE

The start point of a band (the start value is included in the band).

$0.00

8

ARPU BAND START VALUE LOCAL

The start point of a band.

9

ARPU BAND START VALUE REPORTING

The start point of a band.

10

LANGUAGE CODE

Unique identifier for Language

1.

BANK DIRECT DEBT CHANNEL TOTAL

Code for All Bank Direct Debt Channel.

1

BANK BRANCH CODE

Bank Branch id/code.

2

BANK DIRECT DEBIT CHANNEL CODE

Unique identifier for Bank Direct Debit Channel

SHP

3

PAYMENT CHANNEL CODE

4

CHANNEL CODE

5

CHANNEL TYPE CODE

6

PARTY CODE

7

PARTY TYPE CODE

8

CHANNEL NAME

9

CHANNEL DESC

10

CAPACITY QUANTITY

11

EFFECTIVE FROM DATE

12

EFFECTIVE TO DATE

13

STATUS CODE

1.

BER FER TYPE TOTAL

Code for All Ber Fer Type.

1

BER FER TYPE CODE

Unique identifier for Ber Fer Type

BER

2

BER FER TYPE DESC

Description for Ber Fer Type

Bit Error Ratio

3

BER FER TYPE NAME

Name of Ber Fer Type

Bit Error Ratio

4

LANGUAGE CODE

Unique identifier for Language

1.

BILLING STATUS TYPE TOTAL

Code for All Billing Status Type.

1

BILLING STATUS CATEGORY CODE

BILLING STATUS CATEGORY CODE.

FAILED

2

BILLING STATUS TYPE CODE

BILLING STATUS TYPE code.

FAILDAT

3

BILLING STATUS TYPE DESC

BILLING STATUS TYPE description.

Status type of billing result: Incorrect_data_failed

4

BILLING STATUS TYPE NAME

BILLING STATUS TYPE NAME

Incorrect data failed

5

LANGUAGE CODE

Unique identifier for Language

1.

ALL BUSINESS TIME CODE

Identification for the top level value

1

BUSINESS CALENDAR NAME

Textual name of the business Calendar

BUSINESS

2

BUSINESS YEAR CODE

Unique warehouse key of the Year, in the Calendar.

20050101

3

BUSINESS YEAR DESC

Calendar year description.

BY 2005

4

BUSINESS YEAR END DATE

Calendar year end date.

12/31/2005 12:00:00 AM

5

BUSINESS YEAR NUMBER

Calendar year number

6

BUSINESS YEAR START DATE

Calendar year start date

12/31/2005 12:00:00 AM

7

BUSINESS YEAR TIMESPAN

The length, in terms of days, of this year in the Calendar. For example: 365 days

365

8

TOTAL CODE

1

BUSINESS HALF YEAR CODE

Unique key of the half year

20050101

2

BUSINESS HALF YEAR START DAY CODE

Calendar year start date

3

BUSINESS QUARTER CODE

Unique key of business quarter

20050101

4

BUSINESS QUARTER DESC

Description for business quarter

BY 2005 Q1

5

BUSINESS QUARTER END DATE

Calendar year end date

12/31/2005 0:00

6

BUSINESS QUARTER NUMBER

Number for business quarter

1

7

BUSINESS QUARTER START DATE

Calendar year start date

12/31/2005 0:00

8

BUSINESS QUARTER TIMESPAN

The length, in terms of days, of this quarter

90

9

BUSINESS YEAR CODE

Unique key of the year, in which this half year occurred in the Calendar.

10

BUSINESS YEAR START DAY CODE

Code for year start date

1

BUSINESS HALF YEAR CODE

Unique warehouse key for half year

20050101

2

BUSINESS HALF YEAR START DAY CODE

Unique warehouse key for year start day

20050101

3

BUSINESS MONTH CODE

Unique warehouse key of the month, in the Calendar.

20050101

4

BUSINESS MONTH DESC

Calendar month description.

BY 2005 M1

5

BUSINESS MONTH END DATE

Calendar month end date

12/31/2005 0:00

6

BUSINESS MONTH NUMBER

A numeric representation of the month number in the Calendar. It ranges from 1 to 12

1

7

BUSINESS MONTH START DATE

Calendar month start date

12/31/2005 0:00

8

BUSINESS MONTH TIMESPAN

The length, in terms of days, of this month in the Calendar. For example: 30 days

28

9

BUSINESS QUARTER CODE

Unique key of the quarter, in which this month occurred in the Calendar.

20050101

10

BUSINESS QUARTER START DAY CODE

Unique warehouse key for quarter start day

11

BUSINESS YEAR CODE

Unique warehouse key for year

20050101

12

BUSINESS YEAR START DAY CODE

Unique warehouse key year start day

1

BUSINESS HALF MONTH CODE

Unique warehouse key of the Fortnight, in the Calendar.

20050101

2

BUSINESS HALF MONTH DESC

Calendar half month description.

BY 2005 M1 HM1

3

BUSINESS HALF MONTH END DATE

Calendar half month end date.

12/31/2005 12:00:00 AM

4

BUSINESS HALF MONTH NUMBER

A numeric representation of the fortnight number in the Calendar. It ranges from 1 to 24

1

5

BUSINESS HALF MONTH START DATE

Calendar half month start date

12/31/2005 12:00:00 AM

6

BUSINESS HALF MONTH TIMESPAN

The length, in terms of days, of this fortnight in the Calendar. For example: 15 days

15

7

BUSINESS HALF YEAR CODE

Unique warehouse key for half year

20050101

8

BUSINESS HALF YEAR START DAY CODE

Unique warehouse key for half year start day

20050101

9

BUSINESS MONTH CODE

Unique key of the month, in which this fortnight occurred in the Calendar.

20050101

10

BUSINESS MONTH START DAY CODE

Unique warehouse key for month start day

11

BUSINESS QUARTER CODE

Unique warehouse key for quarter

20050101

12

BUSINESS QUARTER START DAY CODE

Unique warehouse key for quarter start day

13

BUSINESS YEAR CODE

Unique warehouse key for year

20050101

14

BUSINESS YEAR START DAY CODE

Unique warehouse key for year start day

1

BUSINESS CURRENT IND

Business Current indicator 'Y' or 'N'

2

BUSINESS DATE

Business date.

3

BUSINESS DATE DESC

Business Date description.

4

BUSINESS DAY CODE

Code for Calendar Day

20050101

5

BUSINESS DAY OF YEAR

Business day of year

6

BUSINESS DAY TIME SPAN

The length, in terms of days, of this fortnight in the Calendar.

7

BUSINESS END DATE

Business end date.

12/31/2005 12:00:00 AM

8

BUSINESS HALF MONTH CODE

Unique warehouse key for half month

20050101

9

BUSINESS HALF MONTH DESCRIPTION

Calendar half month description.

10

BUSINESS HALF MONTH END DATE

Calendar half month end date.

12/31/2005 12:00:00 AM

11

BUSINESS HALF MONTH NUMBER

A numeric representation of the fortnight number in the Calendar. It ranges from 1 to 24.

1

12

BUSINESS HALF MONTH START DATE

Calendar half month start date.

12/31/2005 12:00:00 AM

13

BUSINESS HALF MONTH START DAY CODE

Unique ware house key for half month start day.

20050101

14

BUSINESS HALF MONTH TIMESPAN

The length, in terms of days, of this fortnight in the Calendar. For example: 15 days

15

15

BUSINESS HALF YEAR CODE

Unique warehouse key for half year

20050101

16

BUSINESS HALF YEAR DESC

Business half year description.

17

BUSINESS HALF YEAR END DATE

Business half year end date.

12/31/2005 12:00:00 AM

18

BUSINESS HALF YEAR NUMBER

Business half year number

19

BUSINESS HALF YEAR START DATE

Business half year start date

12/31/2005 12:00:00 AM

20

BUSINESS HALF YEAR START DAY CODE

Unique warehouse key for half year start day

20050101

21

BUSINESS HALF YEAR TIMESPAN

The length, in terms of days, of this half year in the Calendar. For example: 178 days

181

22

BUSINESS MONTH CODE

Unique key of the month, in which this fortnight occurred in the Calendar

20050101

23

BUSINESS MONTH DESC

Calendar month description

BY 2005 M1

24

BUSINESS MONTH END DATE

Calendar month end date.

12/31/2005 12:00:00 AM

25

BUSINESS MONTH NUMBER

A numeric representation of the month number in the Calendar. It ranges from 1 to 12.

1

26

BUSINESS MONTH START DATE

Calendar month start date.

12/31/2005 12:00:00 AM

27

BUSINESS MONTH START DAY CODE

Unique warehouse key for month start day

20050101

28

BUSINESS MONTH TIME SPAN

The length, in terms of days, of this month in the Calendar. For example: 30 days

28

29

BUSINESS QUARTER CODE

Unique warehouse key for quarter

20050101

30

BUSINESS QUARTER DESC

Calendar quarter description.

BY 2005 Q1

31

BUSINESS QUARTER END DATE

Business quarter end date.

12/31/2005 12:00:00 AM

32

BUSINESS QUARTER NUMBER

Number for business quarter

33

BUSINESS QUARTER START DATE

Business quarter start date

12/31/2005 12:00:00 AM

34

BUSINESS QUARTER START DAY CODE

Unique warehouse key for quarter start day

20050101

35

BUSINESS QUARTER TIME SPAN

The length, in terms of days, of this year in the Calendar.

36

BUSINESS START DATE

Business start date.

12/31/2005 12:00:00 AM

37

BUSINESS WEEK CODE

Unique identifier for business week

20050101

38

BUSINESS WEEK DAY

Business week day.

39

BUSINESS WEEK DAY CODE

Unique identifier for business week day.

20050101

40

BUSINESS WEEK DAY DESC

Business week day description

41

BUSINESS WEEK DESC

Business week description.

42

BUSINESS WEEK END DATE

Business week end date.

12/31/2005 12:00:00 AM

43

BUSINESS WEEK NUMBER

Number for business week

44

BUSINESS WEEK START DATE

Business week start date.

12/31/2005 12:00:00 AM

45

BUSINESS WEEK START DAY CODE

Unique identifier for business week start day

20050101

46

BUSINESS WEEK TIME SPAN

The length, in terms of days, of this year in the Calendar.

47

BUSINESS WEEKEND IND

Weekend indicator 'Y' or 'N'

48

BUSINESS WORKING DAY IND

Working day indicator 'Y' or "N'

49

BUSINESS YEAR CODE

Unique warehouse key for year

20050101

50

BUSINESS YEAR DESC

Calendar year description

51

BUSINESS YEAR END DATE

Calendar year end date.

12/31/2005 12:00:00 AM

52

BUSINESS YEAR NUMBER

Calendar year number.

53

BUSINESS YEAR START DATE

Calendar year start date.

12/31/2005 12:00:00 AM

54

BUSINESS YEAR START DAY CODE

Unique warehouse key for year start day

20050101

55

BUSINESS YEAR TIMESPAN

The length, in terms of days, of this year in the Calendar. For example: 365 days

365

1.

ALL CALENDAR TIME CODE

Identification for the top level value

1

CALENDAR NAME

Textual name of the business Calendar

2

CALENDAR YEAR CODE

Unique warehouse key of the Year, in the Calendar.

3

CALENDAR YEAR DESC

Calendar year description.

4

CALENDAR YEAR END DATE

Calendar year end date.

12/31/2005 12:00:00 AM

5

CALENDAR YEAR NUMBER

Calendar year number.

6

CALENDAR YEAR START DATE

Calendar year start date.

12/31/2005 0:00

7

CALENDAR YEAR TIMESPAN

The length, in terms of days, of this year in the Calendar. For example: 365 days

1

CALENDAR HALF YEAR CODE

Unique warehouse key of the half year, in the Calendar.

2

CALENDAR HALF YEAR DESC

Calendar half year description.

3

CALENDAR HALF YEAR END DATE

Calendar half year end date.

12/31/2005 12:00:00 AM

4

CALENDAR HALF YEAR NUMBER

A numeric representation of half year number in the Calendar. It contains values 1 or 2.

5

CALENDAR HALF YEAR START DATE

Calendar half year start date.

12/31/2005 0:00

6

CALENDAR HALF YEAR TIMESPAN

The length, in terms of days, of this half year in the Calendar. For example: 178 days

7

CALENDAR YEAR CODE

Unique key of the year, in which this half year occurred in the Calendar.

8

CALENDAR YEAR START DAY CODE

Code for calendar year start day

1

CALENDAR HALF YEAR CODE

Unique key of the half year

20050101

2

CALENDAR HALF YEAR START DAY CODE

Calendar year start date

20050101

3

CALENDAR QUARTER CODE

Unique key of Calendar quarter

20050101

4

CALENDAR QUARTER DESC

Description for Calendar quarter

CY 2005 Q1

5

CALENDAR QUARTER END DATE

Calendar year end date

12/31/2005 0:00

6

CALENDAR QUARTER NUMBER

Number for Calendar quarter

7

CALENDAR QUARTER START DATE

Calendar year start date

12/31/2005 0:00

8

CALENDAR QUARTER TIMESPAN

The length, in terms of days, of this quarter

9

CALENDAR YEAR CODE

Unique key of the year, in which this half year occurred in the Calendar.

20050101

10

CALENDAR YEAR START DAY CODE

Code for year start date

20050101

1

CALENDAR HALF YEAR CODE

Unique warehouse key for half year

20050101

2

CALENDAR HALF YEAR START DAY CODE

Unique warehouse key for year start day

3

CALENDAR MONTH CODE

Unique warehouse key of the month, in the Calendar.

20050101

4

CALENDAR MONTH DESC

Calendar month description.

5

CALENDAR MONTH END DATE

Calendar month end date.

12/31/2005 12:00:00 AM

6

CALENDAR MONTH NUMBER

A numeric representation of the month number in the Calendar. It ranges from 1 to 12.

7

CALENDAR MONTH START DATE

Calendar month start date.

12/31/2005 0:00

8

CALENDAR MONTH TIMESPAN

The length, in terms of days, of this month in the Calendar. For example: 30 days

9

CALENDAR QUARTER CODE

Unique key of the quarter, in which this month occurred in the Calendar.

20050101

10

CALENDAR QUARTER START DAY CODE

Unique warehouse key for quarter start day

11

CALENDAR YEAR CODE

Unique warehouse key for year

20050101

12

CALENDAR YEAR START DAY CODE

Unique warehouse key year start day

1

CALENDAR HALF MONTH CODE

Unique warehouse key of the Fortnight, in the Calendar.

20050101

2

CALENDAR HALF MONTH DESC

Calendar half month description.

3

CALENDAR HALF MONTH END DATE

Calendar half month end date.

12/31/2005 12:00:00 AM

4

CALENDAR HALF MONTH NUMBER

A numeric representation of the fortnight number in the Calendar. It ranges from 1 to 24.

5

CALENDAR HALF MONTH START DATE

Calendar half month start date

6

CALENDAR HALF MONTH TIMESPAN

The length, in terms of days, of this fortnight in the Calendar. For example: 15 days

7

CALENDAR HALF YEAR CODE

Unique warehouse key for half year.

8

CALENDAR HALF YEAR START DAY CODE

Unique warehouse key for half year start day

9

CALENDAR MONTH CODE

Unique key of the month, in which this fortnight occurred in the Calendar.

20050101

10

CALENDAR MONTH START DAY CODE

Unique warehouse key for month start day

11

CALENDAR QUARTER CODE

Unique warehouse key for quarter

20050101

12

CALENDAR QUARTER START DAY CODE

Unique warehouse key for quarter start day

13

CALENDAR YEAR CODE

Unique warehouse key for year

20050101

14

CALENDAR YEAR START DAY CODE

Unique warehouse key for year start day

1

CALENDAR CURRENT IND

Calendar current indicator 'Y' or 'N'

2

CALENDAR DATE

Calendar date.

3

CALENDAR DATE DESC

Calendar date description.

4

CALENDAR DAY OF YEAR

Calendar day of year.

5

CALENDAR DAY TIMESPAN

The length, in terms of days.

6

CALENDAR END DATE

Calendar end date

12/31/2005 0:00

7

CALENDAR HALF MONTH CODE

Calendar Half Month Code

20050101

8

CALENDAR HALF MONTH DESC

Calendar half month description.

9

CALENDAR HALF MONTH END DATE

Calendar half month end date

12/31/2005 0:00

10

CALENDAR HALF MONTH NUMBER

A numeric representation of the month number in the Calendar. It ranges from 1 to 12.

11

CALENDAR HALF MONTH START DATE

Calendar half month start date.

12/31/2005 0:00

12

CALENDAR HALF MONTH START DAY CODE

The unique identifier for a calendar half month start day.

13

CALENDAR HALF MONTH TIMESPAN

The length, in terms of days, of this fortnight in the Calendar. For example: 15 days

14

CALENDAR HALF YEAR CODE

The unique identifier for a calendar half year.

20050101

15

CALENDAR HALF YEAR DESC

Calendar half year description.

16

CALENDAR HALF YEAR END DATE

Calendar half year description,

12/31/2005 0:00

17

CALENDAR HALF YEAR NUMBER

A numeric representation of half year number in the Calendar. It contains values 1 or 2.

18

CALENDAR HALF YEAR START DATE

Calendar half year start date.

12/31/2005 0:00

19

CALENDAR HALF YEAR START DAY CODE

The unique identifier for a calendar half year start day.

20050101

20

CALENDAR HALF YEAR TIME SPAN

The length, in terms of days, of this half year in the Calendar. For example: 178 days

21

CALENDAR HOLIDAY IND

It indicates holiday indicator 'Y' or 'N'

22

CALENDAR MONTH CODE

The unique identifier for a calendar month.

20050101

23

CALENDAR MONTH DESC

Calendar month description.

24

CALENDAR MONTH END DATE

Calendar month end date.

12/31/2005 0:00

25

CALENDAR MONTH NUMBER

A numeric representation of the month number in the Calendar. It ranges from 1 to 12.

26

CALENDAR MONTH START DATE

Calendar month start date.

12/31/2005 0:00

27

CALENDAR MONTH START DAY CODE

The unique identifier for a calendar month start day

20050101

28

CALENDAR MONTH TIME SPAN

The length, in terms of days, of this month in the Calendar. For example: 30 days

29

CALENDAR QUARTER CODE

The unique identifier for calendar quarter.

20050101

30

CALENDAR QUARTER DESC

Calendar quarter description.

31

CALENDAR QUARTER END DATE

Calendar quarter end date.

12/31/2005 0:00

32

CALENDAR QUARTER NUMBER

Number for Calendar quarter

33

CALENDAR QUARTER START DATE

Calendar quarter start date.

12/31/2005 0:00

34

CALENDAR QUARTER START DAY CODE

The unique identifier for a calendar quarter start day.

20050101

35

CALENDAR QUARTER TIMESPAN

The length, in terms of days, of this quarter

36

CALENDAR START DATE

Calendar Start Date

12/31/2005 0:00

37

CALENDAR WEEK CODE

The unique identifier for calendar week.

20050101

38

CALENDAR WEEK DAY

Calendar week day

39

CALENDAR WEEK DAY CODE

The unique identifier for a calendar week day.

20050101

40

CALENDAR WEEK DAY DESCRIPTION

Calendar week day description.

41

CALENDAR WEEK DESC

Calendar week description.

42

CALENDAR WEEK END DATE

Calendar week end date.

12/31/2005 0:00

43

CALENDAR WEEK NUMBER

A numeric representation of the week number in the Calendar.

44

CALENDAR WEEK START DATE

Calendar week start date

12/31/2005 0:00

45

CALENDAR WEEK TIMESPAN

The length, in terms of days, of this week

46

CALENDAR WEEKEND IND

It indicates calendar weekend indicator 'Y' or 'N'

47

CALENDAR WORKING DAY IND

It indicates the calendar working day indicator 'Y' or 'N'

48

CALENDAR YEAR CODE

The unique identifier for a calendar year.

20050101

49

CALENDAR YEAR DESC

Calendar week description.

50

CALENDAR YEAR END DATE

Calendar year end date.

12/31/2005 0:00

51

CALENDAR YEAR NUMBER

A numeric representation of the year number in the Calendar.

52

CALENDAR YEAR START DATE

Calendar year start date.

12/31/2005 0:00

53

CALENDAR YEAR START DAY CODE

The unique identifier for a calendar year starts date.

54

CALENDAR YEAR TIME SPAN

The length, in terms of days, of this year in the Calendar. For example: 365 days

55

CALENDAR WEEK START DAY CODE

The unique identifier for a calendar week starts date.

20050101

56

DAY CODE

The unique identifier for a calendar date

1.

CALL CATEGORY TOTAL

Code for All Call Categories.

1

CALL CATEGORY CODE

Code for Call Category.

DATA

2

CALL CATEGORY DESC

Description of the Call Category.

Data Call

3

CALL CATEGORY NAME

Short description of the Call Category.

Data Call

1.

CALL CENTER AGENT TOTAL

Code for All Call Center Agent Subscribers.

1

CALL CENTER AGENT TYPE DESC

Description of the Agent type.

AUTO

2

CALL CENTER AGENT TYPE NAME

Name of Agent type.

3

LANGUAGE CODE

Uniquely identifier of language

4

CALL CENTER AGENT TYPE CODE

1

CALL CENTER AGENT CODE

All the possible agents with whom the customer can make a contact like IVR, Human Agent, Corporate agent, CRC, and so on.

CODE-1

2

CALL CENTER AGENT DESC

Description of the Agent.

3

CALL CENTER AGENT NAME

Name of Agent.

HUMAN

4

CALL CENTER AGENT TYPE CODE

Foreign key, to indicate which type this agent is, for example: Auto, Human.

5

CALL CENTER CODE

Uniquely identifier of call center

6

7

BILLING ADDRESS EFFECTIVE DATE

Date on which the billing address referenced in the billing_address_id column became active. This facilitates queries such as find customers who changed address in the last 3 months.""

8

BUSINESS DIVISION EXECUTIVE NAME

BUSINESS DIVISION EXECUTIVE LAST NAME is the last name of the business division executive to whom the employee reports to. Like LOB Owner.

9

BUSINESS PHONE NUMBER

Phone number used for business purpose

10

CELL PHONE NO

Redundancy to 'party contact information'

11

CHILDREN COUNT

Number of children

12

CONTACT ADDRESS EFFECTIVE DATE

Date on which the contact address referenced in the billing_address_id column became active. This facilitates queries such as find customers who changed address in the last 3 months.""

13

COST CENTER NUMBER

The cost center to which the bank employee expenses are charged.

14

DATE OF BIRTH

Date of Birth of the individual.

15

DATE OF DEATH

Date of natural person death.

16

DEATH CERTIFICATE CODE

The certification document number for customer's death.

17

DEPENDENTS COUNT

Number of dependents

18

DRIVER LICENSE NUMBER

Driver License Number in most countries.

19

DWELLING SIZE

Size of dwelling

20

DWELLING TENURE

Tenure of dwelling

21

ECONOMICALLY ACTIVE IND

customer is economically active (is not a minor or pensioner and so on.)

22

EDUCATION CODE

The customer highest level of education.

23

EMAIL

Redundancy to 'party contact information'

24

EMPLOYEE CODE

A code for any person or business that is of interest to the Communications Service Provider.

25

EMPLOYEE DESIGNATION CODE

Unique warehouse key, representing the designation

26

EMPLOYEE DISCOUNT GROUP CODE

Unique identifier for Employee Discount Group

27

EMPLOYEE KEY

Key value for each employee

28

EMPLOYEE NUMBER

Internal number for the employee.

29

EMPLOYEE TYPE CODE

Unique identifier for Employee Type

PT

30

EMPLOYEE TYPE DESC

Description of the Employee Type

Part Time

31

EMPLOYEE TYPE NAME

Unique identifier for the Employee Type

Part Time

32

EMPLOYER TAX NUMBER

The tax code of Employer.

33

EMPLOYMENT BEGIN DATE

Start date for the employment.

12/31/2005 12:00:00 AM

34

EMPLOYMENT END DATE

If the employee quit, holds the information of past employment.

35

EMPLOYMENT EXEMPT IND

An employee is exempt from the overtime policies due to the nature of the work, as compared to (Non-Exempt).

Education requirements of the position and salary range. These employees are paid an annual salary and are not customarily eligible for overtime pay.

36

EMPLOYMENT STATUS

EMPLOYEE STATUS is the abbreviated identifier for the employment status. Employee

37

END OF JOB CONTRACT

End date of the customer's job contract (for contracts concluded for definite terms).

38

ETHNIC BACKGROUND

Customer Attribute of an employee

39

ETHNICITY

Classifies the individual for minority reporting purposes.

40

FAMILY NAME IN MAIDEN

Given name in maiden

41

FIRST NAME

First name of a party individual

42

FORM OF EMPLOYMENT

The customer's form of employment (private entrepreneur, employee, civil servant and so on.)

43

GENDER CODE

For PARTYs that are people, this is their GENDER.

For PARTYs that are organizations, this is indicates whether the organization is foreign or domestically owned.

44

GIVEN NAME IN MAIDEN

Given name in maiden

45

HOME TELEPHONE NO

Redundance to 'party contact information'

46

HOUSEHOLD KEY

The code of household which the party belongs to.

47

INCOME

Income of a party individual

48

INCOME LCL

Income of a party individual

49

INCOME RPT

Income of a party individual

50

JOB CONTRACT TYPE

Type of the customer's job contract

51

JOB KEY

Code for job of subscriber.

52

JOB POSITION

job Position.

53

LANGUAGE CODE

Unique identifier for Language

54

LAST NAME

Last name of a party individual

55

LAST PERFORMANCE RATING

This describes the annual rating assigned to the employee.

56

LAST PERFORMANCE RATING DATE

When the last rating is done.

57

LEGAL TITLE TO HOUSING

The customer's legal title to home (rents, owns and so on.)

58

LIVING AT CURRENT ADDRESS SINCE

Date since the customer has lived at the present address.

59

MANAGER CODE

manager's employee code.

60

MARITAL STATUS

CSALADI ALLAPOT. Marital status

61

MARTIAL STATUS CODE

62

MIDDLE NAME

Middle name of a party individual

63

MOTHER FIRST NAME

Mother's first name

64

MOTHER LAST NAME

Mother's last name

65

NAME OF WORKPLACE

Name of workplace

66

NAME PREFIX

Name prefix

For example: Mr, Mrs, Ms, Dr,

67

NAME SUFFIX

Name suffix. For example: PhD, MD, JD, MA

68

NATIONALITY CODE

Code for Nationality of subscriber

69

NUMBER OF EARNERS IN HOUSEHOLD

Number of wage earners in the household.

70

NUMBER OF PERSONS LIVING IN HOUSEHOLD

Number of persons sharing the customer's household.

72

OFFICE TELEPHONE NO

Redundancy to 'party contact information'

73

ORGANIZATION BUSINESS UNIT KEY

74

PERSONAL ID NUMBER

75

PLACE OF BIRTH

Where the person was born.

76

PREVIOUS EMPLOYER TAX NUMBER

Tax number of previous employer.

77

PREVIOUS EMPLOYMENT END DATE

End date of previous job.

78

PREVIOUS EMPLOYMENT START DATE

Start date of previous job.

12/31/2005 12:00:00 AM

79

SOC JOB KEY

80

SOCIAL SECURITY NUMBER

Null if a country does not have this number.

81

SOURCE OF INCOME

Source of income (can typify, may be several)

82

START OF EMPLOYMENT

Start of employment

83

TAX NUMBER

Tax number

84

ACTIVE IND

Activate Indicator

85

ADDRESS

Address

86

BARING REASON CODE

Unique identifier for Baring Reason

87

BUSINESS LEGAL STATUS CODE

A unique identifier for a legal classification of a non-residential Customer.

88

CITY

City of the party. Redundance to party location history.

89

COUNTRY

Country of the party. Redundance to party location history.

90

CUSTOMER IND

Indicator for Customer

91

EFFECTIVE FROM DATE

EFFECTIVE FROM DATE, standard SCD2 column.

92

EFFECTIVE TO DATE

EFFECTIVE TO DATE, standard SCD2 column.

93

EMPLOYEE NAME

Name of the employee

94

PARTY DESC

Description for the Party

95

PARTY KEY

Key value for Party

96

PARTY NAME

Name of the Party

97

PARTY TYPE CODE

Unique identifier for Party Type

98

POST CODE

Unique identifier for Post

99

SOURCE SYSTEM KEY

Key value for Source System

100

STATE

State Name

101

STATUS CODE

Current Status

1.

CALL CENTER CASE TITLE TOTAL

Total of all call center case titles.

1

CALL CENTER CASE SUB TYPE CODE

Code or Id for Call Center Case Sub Type.

2

CALL CENTER CASE TITLE CODE

Code or Id for Call Center Case Title.

CBPWD

3

CALL CENTER CASE TITLE DESC

Description of the Call Center Case Title.

4

CALL CENTER CASE TITLE NAME

Name of Call Center Case Title.

5

LANGUAGE CODE

Uniquely identifier of language

1.

CALL CENTER TOTAL

Code for All Call Centers.

1

CALL CENTER CODE

CODE-1

2

NUMBER OF EMPLOYEES

NUMBER OF EMPLOYEES.

3

NUMBER OF LINES

How many telephone lines (trunk) are offered.

4

PRIMARY LANGUAGE

The language/Dialects the call center can support.

5

ACCOUNT CLERK CODE

This field is client specific. The definition and use of this field is customizable for each client.

6

ADDRESS LINE 1

Address. Line one of detailed postal address

7

ADDRESS LINE 2

Address. Line two of detailed postal address

8

ADDRESS LINE 3

Address. Line three of detailed postal address

9

ADDRESS LOCATION CODE

Unique identifier for the address. unique identifier for the address location

10

ADDRESS TYPE CODE

Unique identifier of the address type.

11

ADDRESS USAGE

Describes how the address is used

12

ANNUAL REVENUE

Revenue of the company.

13

ANNUAL REVENUE LOCAL

Revenue of the company.

14

ANNUAL REVENUE REPORTING

Revenue of the company.

15

ANNUAL SALES

Sales for Annual

16

ANNUAL SALES LOCAL

Local Sales for Annual

17

ANNUAL SALES REPORTING

Reporting Sales for Annual

18

BANKRUPTCY END DATE

The end date of bankruptcy. If current date is behind start and end date is null, then the company is undergoing the bankruptcy process.

19

BANKRUPTCY START DATE

start date of bankruptcy.

20

BUSINESS ENTITY CODE

Unique Identifier for Business Entity

21

BUSINESS UNIT CONCEPT

Possible values include, Convenience, General Merchandise, Category dominant anchors with few small tenants, Fashion, Higher-end (Upscale), Fashion oriented, Manufacturer's Outlet, Leisure, Tourist oriented and Discount.

22

BUSINESS UNIT TYPE CODE

Unique identifier of the business unit type

23

CHAIRMAN CODE

Connect to Another Person Party who is responsible for this Organization.

24

CHANNEL TYPE CODE

Unique identifier of the channel type

25

COMPANY REGISTRY NUMBER

Will be same as Party. National_Identifier. Natural Key for Organization.

26

CONSTRUCTION STATUS

Identifies the status of the site such as 'Under Construction', 'New', and so on.

27

CONTACT CODE

ID of the contact person for the organization.

28

CONTACT NAME

Contact Employee for organization.

29

CONTACT NUMBER

This is the number for the method specified to contact this site. There can be multiple contact numbers of each type for each site.

30

CONTACT TYPE CODE

This is the general method to use to contact a site, that is, Phone, Fax, Telex, and so on.

31

COURT CODE

Code of the law of court.

32

DOMESTIC INDICATOR

For PARTYs that are organizations, this indicates whether the organization is foreign or domestically owned.

33

DUNS NUMBER

DUNS NUMBER is an identifier for organization.

34

EMPLOYEE COUNT

Total number of employee in the company or organization.

35

EQUITY AMOUNT

The equity value of the company/org.

36

EQUITY AMOUNT LOCAL

The equity value of the company/org.

37

EQUITY AMOUNT REPORTING

The equity value of the company/org.

38

EXTERNAL NAME

Name/Number assigned to site for electronic communication. For example: EDI transactions.

39

FINAL SETTLEMENT END DATE

End date of final settlement.

40

FINAL SETTLEMENT START DATE

Start date of final settlement

41

JUDICIAL DISTRAINT CODE

Case identifier of the judicial distraint

42

JUDICIAL DISTRAINT DATE

Date of the judicial distraint

43

LIQUIDATION END DATE

The date when the company/org was liquidated. If is null and start_date is not null, the company is undergoing the liquidation.

44

LIQUIDATION START DATE

Start date of liquidation

45

LOCATION TYPE CODE

Unique identifier for location type

46

LONG DESCRIPTION

The 10 character abbreviation of the store name

47

MANAGER CODE

ID of the manager for the organization.

48

MANAGER EMPLOYEE NUMBER

Unique key denoting the employee number of the employee's manager.

49

MANAGER NAME

Name of manager for the whole company.

50

ORGANIZATION BANNER CODE

51

ORGANIZATION BUSINESS UNIT CODE

Unique identifier for Business Unit. To identify whether the site is a store, distribution center or warehouse.

52

ORGANIZATION BUSINESS UNIT TYPE CODE

Unique identifier for Organization business unit type

53

ORGANIZATION CODE

The unique identifier of the organization

54

ORGANIZATION DISTRICT CODE

District code of ORGANIZATION DISTRICT

55

ORGANIZATION DIVISION CODE

Division code of a ORGANIZATION

56

ORGANIZATION NAME

Name of the organization

57

ORGANIZATIONAL DEMOGRAPHY VALUE CODE

Unique identifier for organization demographic value

58

PAYMENT ACCOUNT CLOSE DATE

Closing date of the account for payments.

59

PAYMENT ACCOUNT NUMBER

Account number for payments.

60

PAYMENT ACCOUNT OPEN DATE

Opening date of the account for payments.

61

POSTAL PLUS CODE

Four digit extension to the United States Postal ZIP code.

62

POSTCODE

Postal codes of interest to the Retail Organization

63

PRIMARY ADDRESS TELEPHONE

Default Address Telephone Number

64

PRIMARY BUSINESS UNIT CALENDAR CODE

Primary Business Unit Calendar Code

65

PRIMARY CURRENCY ISO CODE

The unique ISO standard identifier of the CURRENCY

66

PRIMARY EMAIL ADDRESS

Default Email Address

67

PRIMARY MARKET AREA CODE

Market area code under which the business unit falls

68

PRIMARY TRADE AREA CODE

Primary Trade area code, under which the business unit falls

69

SEAL IMAGE

The image of the Organization's Seal, or the Artificial Person's Signature.

70

SECONDARY DESCRIPTION

The secondary description or name of the store or warehouse.

72

SHOPPING CENTER TYPE

Shopping center is group of retail and other commercial establishments that is planned, developed, owned, and managed as a single property.=- Strip Center (Neighborhood, Community)- Mall (Power, Super Regional, Regional, Fashion/Specialty, Lifestyle, Outlet, Theme/Festival)

73

SHORT DESCRIPTION

The 3 character abbreviation of the store name.

74

STOCK EXCHANGE NAME

Abbreviation of listed companies as used on the stock exchange.

75

TAX EXEMPT STATUS

Indicates if the org. is tax exempt.

76

TERMINATION DATE

Termination date of the company in case of company was founded with termination date.

77

TIME ZONE

It denotes which TimeZone the Site is in.

78

TOTAL LINEAR DISTANCE

The total linear selling space of the location.

79

VALIDATION END DATE

Effective date of the deletion of the company's record from the company register.

70

SECONDARY DESCRIPTION

The secondary description or name of the store or warehouse.

80

VALIDATION START DATE

Date of the registration of the company' record deletion from the company register.

81

VAT INCLUDE INDICATOR

Indicates whether the Value Added Tax will be included in the retail prices for the store. Valid values are 'Y' or 'N'

82

VAT REGION

The number of the Value Added Tax region in which this store or warehouse is contained.

83

PARTY CODE

84

PARTY TYPE CODE

85

BUSINESS LEGAL STATUS CODE

86

SOURCE SYSTEM CODE

87

BARING REASON CODE

88

STATUS CODE

89

CITY

90

STATE

91

COUNTRY

92

PARTY NAME

93

PARTY DESC

94

ADDRESS

95

ACTIVE INDICATOR

96

CUSTOMER INDICATOR

97

EFFECTIVE FROM DATE

98

EFFECTIVE TO DATE

1.

ALL CALL DIRECTION CODE

Code for Call Directions.

1

CALL DIRECTION CODE

Code for call direction.

IN

2

CALL DIRECTION DESC

Description of call direction.

To indicate incoming call

3

CALL DIRECTION NAME

Name of the call direction.

IN

4

LANGUAGE CODE

Unique identifier for Language

1.

ALL CALL OTHER TYPE CODE

Code for Call Other Types.

1

CALL OTHER TYPE CODE

A code used to uniquely identify a category of Special Services that a Call may utilize. Examples include: 1 - Directory Assistance 2 - 800 3 - 900 4 - 911 5 - Customer Service 6 - Voice Mail.

CUSTSRVC

2

CALL OTHER TYPE DESC

A textual description of a Call Special Service Type.

Customer Service

3

CALL OTHER TYPE NAME

The name assigned to a Call Special Service Type. Examples include: Directory Assistance 800 900 911 Customer Service Voice Mail.

Customer Service

4

LANGUAGE CODE

Unique identifier for Language

1.

ALL CALL ROUTING CODE

Code for All Call Routing Subscribers.

1

CALL ROUTING TYPE CODE

The code for the type can use number or character.

ATA

2

CALL ROUTING TYPE DESC

Full Description.

Call was routed from Air To Air

3

CALL ROUTING TYPE NAME

The short name for the type.

Air To Air

4

LANGUAGE CODE

Uniquely identifier of language

1.

CALL SERVICE TYPE TOTAL CODE

Code for All Call Service Type.

1

CALL SERVICE TYPE CODE

The code.

1

2

CALL SERVICE TYPE DESC

The full description.

Fire

3

CALL SERVICE TYPE NAME

The title.

Fire

4

LANGUAGE CODE

Uniquely identifier of language

1.

CALL SOURCE DESTINATION TOTAL

Code for All Call Source Destination

1

CALL SOURCE DESTINATION CODE

Code for call destination.

8675583965191

2

CALL SOURCE DESTINATION DESC

Description of call destination.

8675583965191

3

CALL SOURCE DESTINATION NAME

Name of the destination.

8675583965191

4

DESTINATION TYPE CODE

Unique identifier of destination type.

5

EFFECTIVE FROM DATE

Active from. Standard SCD field, Effective Start Date

12/31/2005 12:00:00 AM

6

EFFECTIVE TO DATE

Date the party left the program. Will be null if the party is currently a member of the program.

7

NETWORK TYPE CODE

Unique identifier of destination network type.

8

NUMBER AREA CODE

Area code. For example: 713-Houston

9

NUMBER NETWORK TYPE CODE

Unique identifier of destination network type.

10

STATUS CODE

Current status of the assignment.

1.

ALL SUCCESSFUL/FAILED CODE

Code for All Call Successful/failed.

1

CALL SUCCESS FAILURE TYPE CODE

Call Success failure id.

FAIL

2

CALL SUCCESS FAILURE TYPE DESC

Call Success failure description.

Fail

3

CALL SUCCESS FAILURE TYPE NAME

Call Success failure short description.

Fail

4

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

1.

ALL CALL TYPE CODE

Code for All Call Type Subscribers.

1

CALL CATEGORY CODE

The code for the call category.

VOI

2

CALL TYPE CODE

The code for the call type.

INTL

3

CALL TYPE DESC

The Full Description.

International

4

CALL TYPE NAME

The title.

International

5

LANGUAGE CODE

Language ID---Unique identifier for a row in the Language dimension.

1.

ALL CAMPAIGN CHANNEL CODE

Code for All Campaign Channel.

1

CAMPAIGN CHANNEL CODE

A unique identifier for a campaign channel.

MAGAZINE

2

CAMPAIGN CHANNEL DESC

The name assigned to a campaign channel.

3

CAMPAIGN CHANNEL NAME

A textual description of an campaign channel.

4

CAMPAIGN CHANNEL TYPE CODE

A code used to uniquely identify a campaign channel type.

MGZN

5

CAPACITY QUANTITY

The number of transaction that a Channel can handle, at a point of time.

6

CHANNEL CODE

The unique identifier for each Channel. A Channel identifies each possible link where interaction between the Communications Service Provider and the Customer occurs.

7

CHANNEL DESC

Descriptions of the channels

8

CHANNEL NAME

The name assigned to a channel.

9

CHANNEL TYPE CODE

A code used to uniquely identify a major grouping of Channels. Examples: M - MailT - Telephone TV - Television.

LYLTCHNL

10

EFFECTIVE FROM DATE

The first date of the period when this Channel was valid.

12/31/2005 12:00:00 AM

11

EFFECTIVE TO DATE

The end date of the period when this Channel was valid.

12/31/2005 12:00:00 AM

12

PARTY CODE

A code for any person or business that is of interest to the Communications Service Provider.

13

PARTY TYPE CODE

Type of party

RPRSTTV

14

STATUS CODE

Current status.