Subscription

Field No.

Field Name

Unique?

Type

Length

Details

1

Subscription

Y

Numeric

8,0

CMP Subscription Number

2

Subscription Username

 

Alphanumeric

30

CMP Subscription Username

3

Account

 

Numeric

8,0

CMP Account Number

4

Company

 

Alphanumeric

3

CMP Company Number

5

Agreement

 

Numeric

8,0

CMP Agreement Number

6

Group

 

Alphanumeric

6

CMP Group Code

7

Corporate

 

Alphanumeric

6

CMP Corporate Code

8

Tariff

 

Alphanumeric

6

Tariff Code
9 Tariff Description   Alphanumeric 30 CMP Tariff Code Description

10

Package

 

Alphanumeric

6

Package Code
11 Package Description   Alphanumeric 30 CMP Package Code Description

12

Network

 

Alphanumeric

6

Network Code
13 Network Description   Alphanumeric 30 CMP Network Code Description

14

Network Serial Number 1

 

Alphanumeric

25

As stored in CMP. Typically a mobile number or landline CLI as stored in Managed Serial Number 1.

15

Network Serial Number 2

 

Alphanumeric

25

This value varies by CMP implementation/environment. In mobile implementations this is typically a SIM related serial number

16

Network Serial Number 3

 

Alphanumeric

25

This value varies by CMP implementation/environment. In mobile implementations this is typically a SIM related serial number

17

Network Serial Number 4

 

Alphanumeric

25

This value varies by CMP implementation/environment. In mobile implementations this is typically a SIM related serial number

18

Network Serial Number 5

 

Alphanumeric

25

This value varies by CMP implementation/environment.

19

Address Line 1

 

Alphanumeric

40

As stored in CMP

20

Address Line 2

 

Alphanumeric

40

As stored in CMP

21

Address Line 3

 

Alphanumeric

40

As stored in CMP

22

Address Line 4

 

Alphanumeric

40

As stored in CMP

23

Address Line 5

 

Alphanumeric

40

As stored in CMP

24

Address Post Code

 

Alphanumeric

10

As stored in CMP

25

Connected Date

 

Numeric

7,0

Date Connected in CMP. YYYY-MM-DD format.

26

Disconnected Date

 

Numeric

7,0

Date Disconnected in CMP. YYYY-MM-DD format. "0" if not disconnected.

27

Subscription Status

 

Alphanumeric

6

First, Normal, Final

28

Connected Reason

 

Alphanumeric

4

Reason the Sub was Connected (Code)

29

Connected Reason Description

 

Alphanumeric

30

Reason the Sub was Connected (Description)

30

Disconnection Reason

 

Alphanumeric

4

Reason the Sub was Disconnected (Code)

31

Disconnection Reason Description

 

Alphanumeric

30

Reason the Sub was Disconnected (Description)

32

Contract Start Date

 

Numeric

7,0

Contract Start Date in CMP. YYYY-MM-DD format.

33

Contract Term

 

Numeric

3,0

Contract term (months)

34

Contract Number

 

Alphanumeric

12

Contract Number for Agreement

35

Title

 

Alphanumeric

10

Title from CMP (for example: Ms, Mr, Mrs)

36

Forename

 

Alphanumeric

15

First name from CMP

37

Middle Name

 

Alphanumeric

10

Middle name from CMP

38

Surname

 

Alphanumeric

25

Last name from CMP

39

Gender

 

Alphanumeric

1

Gender from CMP

- '0' = Male

- '1' = Female

- '2' = Unknown

For Personal Address records where the Gender status is returned as ‘Unknown’ the Title field is used to further determine the Gender. Thus if the Title = ‘Mr’, the Gender is set to ‘Male’, and if the Title is one of ‘Mrs’ , ‘Miss’, or ‘Ms’, it is set to ‘Female’.

Note: For Business Address records the Gender Status is set to ‘Unknown’.

40

Date of Birth

 

Numeric

7,0

YYYY-MM-DD format.

41

Date Created

 

Numeric

7,0

Date record created in CMP. YYYY-MM-DD format.

42

Created By

 

Alphanumeric

10

User ID of user who created the record

44

Date Changed

 

Numeric

7,0

Date record changed in CMP. YYYY-MM-DD format.

45

Changed By

 

Alphanumeric

10

User ID of user who last changed the record

46

Data Extract Date

 

Numeric

7,0

Date that the data above was extracted from CMP. YYYY-MM-DD format.