Groups
SERVICE
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comment |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | SUBSCRIPTION_ID | NUMBER | 22 | Y | Foreign key referencing SUBSCRIPTION-table | |
| 3 | CODE | VARCHAR2 | 10 | Y | Refers to type of service, references SERVICE_CLASS.CODE | |
| 4 | STATUS_ID | NUMBER | 22 | Y | Status of the service, references STATUS.ID | |
| 5 | IMSI | VARCHAR2 | 50 | Y | International Mobile Subscriber Identity | |
| 6 | PHONE_NUMBER | VARCHAR2 | 20 | Y | Phone number | |
| 7 | MAILBOX_NUMBER | VARCHAR2 | 50 | Y | Mailbox number | |
| 8 | DATA_FAX_NUMBER | VARCHAR2 | 50 | Y | Data fax number | |
| 9 | PHONEBOOK_ENTRY | NUMBER | 22 | Y | ||
| 10 | FOREIGN_CALLS | NUMBER | 22 | Y | ||
| 11 | SIM_DELIVERED | NUMBER | 22 | Y | Indicates whether SIM card is delivered | |
| 12 | FAX_NUMBER | VARCHAR2 | 50 | Y | Fax number | |
| 13 | DUAL_IMSI | VARCHAR2 | 50 | Y | Second IMSI number if one exists | |
| 14 | DUAL_PHONE_NUMBER | VARCHAR2 | 50 | Y | Second phone number if one exists | |
| 15 | NETWORK_ICC | VARCHAR2 | 100 | Y | Network Integrated Circuit Card | |
| 16 | NETWORK_PHONENUMBER | VARCHAR2 | 100 | Y | Network phone number | |
| 17 | ESN | VARCHAR2 | 50 | Y | Electronic Serial Number | |
| 18 | NETWORK_ESN | VARCHAR2 | 50 | Y | Network ESN | |
| 19 | SERVICE_CLASS_ID | NUMBER | 22 | Y | Foreign key referencing SERVICE_CLASS.ID | |
| 20 | CDMAPHONE_GROUP_ID | NUMBER | 22 | Y | Foreign key referencing CDMA_PHONE_GROUP.ID | |
| 21 | SHOP_PRODUCT_ID | NUMBER | 22 | Y | Foreign key referencing SHOP_PRODUCT.ID | |
| 22 | DIRECTORY_KEY | VARCHAR2 | 15 | Y | ||
| 23 | BRAND_ID | NUMBER | 22 | Y | Foreign key referencing BRAND_ID | |
| 24 | IS_SUSPEND | NUMBER | 22 | N | Indicates whether service is suspended | |
| 25 | NETWORK_SUB_ID | VARCHAR2 | 400 | Y | ||
| 26 | BLOCKED_FROM_DATE | DATE | 7 | Y | Date of blocking | |
| 27 | EXTERNAL_ACCOUNT_REFERENCE | VARCHAR2 | 32 | Y | ||
| 28 | DISCONNECT_DATE | DATE | 7 | Y | Date of disconnecting | |
| 29 | LAST_SPEED_CHANGE_DATE | DATE | 7 | Y | Date of latest speed change | |
| 30 | INSTALLATION_ID | NUMBER | 22 | Y | ||
| 31 | USER_NO | VARCHAR2 | 200 | Y | User number | |
| 32 | IP_NUMBER | VARCHAR2 | 50 | Y | IP-number | |
| 33 | MAC_ADDRESS_NUMBER | VARCHAR2 | 50 | Y | Mac address number | |
| 34 | NETWORK_USER_ID | NUMBER | 22 | Y | ||
| 35 | SERVICE_TAG | VARCHAR2 | 100 | Y | ||
| 36 | LAST_PROVISIONING_SYNC_DATE | DATE | 7 | Y | Date of latest provisioning synchronization | |
| 37 | CUSTOM_VALUE1 | VARCHAR2 | 4000 | Y | Custom value | |
| 38 | CUSTOM_VALUE2 | VARCHAR2 | 4000 | Y | Custom value | |
| 39 | CUSTOM_VALUE3 | VARCHAR2 | 4000 | Y | Custom value | |
| 40 | CSA_ZIP | VARCHAR2 | 200 | Y | ||
| 41 | CSA | VARCHAR2 | 400 | Y | ||
| 42 | HEX_MEID | VARCHAR2 | 200 | Y | MEID in hex-format | |
| 43 | MEID | VARCHAR2 | 50 | Y | Mobile Equipment ID | |
| 44 | NETWORK_MEID | VARCHAR2 | 50 | Y | Network MEID | |
| 45 | MIN | VARCHAR2 | 200 | Y | Mobile Identification Number | |
| 46 | CSA_NUMBER | VARCHAR2 | 400 | Y | ||
| 47 | NETWORK_MIN | VARCHAR2 | 200 | Y | Network MIN | |
| 48 | FIRST_CDR_RATED_DATE | DATE | 7 | Y | Date of first rating |