Customer Information File
The Customer Information file contains data about all customers currently active in your information system.
| Column | Description |
|---|---|
| CID |
Unique customer identifier. Type: VARCHAR2(64) Can be empty?: No. |
| ACCOUNT_TYPE |
Customer account type. Type: VARCHAR2(255) Can be empty?: No. |
| LATITUDE |
Latitude of the customer device location. Type: NUMBER Can be empty?: No. |
| LONGITUDE |
Longitude of the customer device location. Type: NUMBER Can be empty?: No. |
| ADDRESS |
Customer address. Type: VARCHAR2(200) Can be empty?: Yes. |
| CITY_STATE |
City, state part of the customer address. Type: VARCHAR2(50) Can be empty?: Yes. |
| ZIP_CODE |
Zip or postal code part of the customer address. Type: VARCHAR2(10) Can be empty?: Yes. |
| DEVICE_CLS |
Class portion of the customer device handle. Type: NUMBER Can be empty?: Yes. |
| DEVICE_IDX |
Index portion of the customer device handle. This is a number to identify the specific device or device instance. Type: NUMBER Can be empty?: Yes. |
| DEVICE_NAME |
Customer device name. Type: VARCHAR2(64) Can be empty?: Yes. |
| METER_NUMBER |
Customer meter number. Type: VARCHAR2(20) Can be empty?: Yes. |
| FEEDER |
Customer feeder name or id. Type: VARCHAR2(64) Can be empty?: No. |
| RPT_LEVEL_1 |
Reporting level 1. Type: VARCHAR2 Can be empty?: No. |
| RPT_LEVEL_1_TYPE |
Label for reporting level 1. Type: VARCHAR2 Can be empty?: No. |
| RPT_LEVEL_2 |
Reporting level 2. Type: VARCHAR2 Can be empty?: No. |
| RPT_LEVEL_2_TYPE |
Label for reporting level 2. Type: VARCHAR2 Can be empty?: No. |
| RPT_LEVEL_3 |
Reporting level 3. Type: VARCHAR2 Can be empty?: No. |
| RPT_LEVEL_3_TYPE |
Label for reporting level 3. Type: VARCHAR2 Can be empty?: No. |
| RPT_LEVEL_4 |
Reporting level 4. Type: VARCHAR2 Can be empty?: No. |
| RPT_LEVEL_4_TYPE |
Label for reporting level 4. Type: VARCHAR2 Can be empty?: No. |
| RPT_LEVEL_5 |
Reporting level 5. Type: VARCHAR2 Can be empty?: No. |
| RPT_LEVEL_5_TYPE |
Label for reporting level 5. Type: VARCHAR2 Can be empty?: No. |
Example Customer Information File
"CID"|"ACCOUNT_TYPE"|"LATITUDE"|"LONGITUDE"|"ADDRESS"|"CITY_STATE"|"ZIP_CODE"|"DEVICE_CLS"|"DEVICE_IDX"|"DEVICE_NAME"|"METER_NUMBER"|"FEEDER"|"RTP_LEVEL_1"|"RTP_LEVEL_1_TYPE"|"RTP_LEVEL_2"|"RTP_LEVEL_2_TYPE"|"RTP_LEVEL_3"|"RTP_LEVEL_3_TYPE"|"RTP_LEVEL_4"|"RTP_LEVEL_4_TYPE"|"RTP_LEVEL_5"|"RTP_LEVEL_5_TYPE"
"0987654321"|"Customer"|<LATITUDE>|<LONGITUDE>|"1 ORACLE ST"|"O"|"78741"|167|1385345040|"MA:44AD:9463:BSV:1385345040"|12345678|"or_ac_lea"|"11385"|"Zip Code"|"Q"|"Municipality"|"1234 ORACLE ST # 5 REDWOOD"|"County"||||
"0987654322"|"Customer"|<LATITUDE>|<LONGITUDE>|"3000 ORACLE 22ND ST"|"M"|"78741"|167|1369183741|"JH:64AM:T54:BSV:1369183741"|12345679|"or_ac_leb"|"11369"|"Zip Code"|"Q"|"Municipality"|"1000 ORACLE LANE"|"County"||||
"0987654323"|"Customer"|<LATITUDE>|<LONGITUDE>|"54321 ORACLE AVE"|"R"|"78741"|167|14185934|"SS:17F:32010:BSV:14185934"|12345677|"or_ac_lec"|"10014"|"Zip Code"|"M"|"Municipality"|"2200 ORACLE AVE AUSTIN"|"County"||||