NOTES FOR PREPARING A DATA FILE Save file using the file type "Formatted text (space delimited)" Then rename the file using the naming convention in the manual. Note: anything with a space as the left most character in column A is treated as a comment record. RECORD FORMAT Each Data record should contain the following fields: Field Justification Field size Record Field Contents within field (column width) Positions 1. Filing Carrier Name Characters Left 15 1-15 note that character 15 in the name field should be a blank or an "A" for annual data. 2. Year of data Numbers Right 2 16-17 3. U.S. Point served Numbers Right 5 18-22 4. International Point or region Numbers Right 5 23-27 5. Service Code Numbers Right 3 28-30 6. Footnote indicator Characters Right 3 31-33 7. Description (Country name) Characters Left 36 34-69 8. Billing Code Numbers Right 2 70-71 9. Data Field #1 Numbers Right 12 72-83 10. Data Field #2 Numbers Right 12 84-95 11. Data Field #3 Numbers Right 12 96-107 12. Data Field #4 Numbers Right 12 108-119 13. Data Field #5 Numbers Right 12 120-131 EXAMPLE OF A 43.61 REPORT FOR A FACILITIES-BASED/FACILITIES-RESALE CARRIER 43.61 Report for: New Carrier International (a facilities-based/facilities-resale carrier) Data as of 12/31/2003 filed as of October 31, 2004 <<<<<<<<<<<<>>>>>>>>>>> 15((left) 2 5 5 3 3 36(left) 2 12 12 12 12 12 Data 1 Data2 Data 3 Data4 Data5 *PROPRIETARY VERSION OF DATA* Billed & Service Code Billing Code Settlement Settlement Retained Carrier Yr Footnote Field Messages Minutes Revenue Payments Revenue Description Field International Message Telephone Service: U.S. billed facilities-based/facilities-resale service NewCarrier 06 1327 326 1 United Kingdom 1 1125 7031 4100 4500 -400 NewCarrier 06 1327 9001 1 Western Europe 1 1125 7031 4100 4500 -400 NewCarrier 06 1327 9999 1 World Total 1 1125 7031 4100 4500 -400 Calls Originate Outside the U.S., Billed by U.S. Carrier as "Country Direct/Country Beyond" Service NewCarrier 06 1327 326 1 United Kingdom 4 275 1375 2750 900 1850 NewCarrier 06 1327 9001 1 Western Europe 4 275 1375 2750 900 1850 NewCarrier 06 1327 9999 1 World Total 4 275 1375 2750 900 1850 Calls Originated Outside the U.S., Billed by Foreign Carrier, Reoriginated by U.S. Carrier, Terminated via facilities-based/facilities-resale service NewCarrier 06 1327 326 1 United Kingdom 5 275 1375 2750 900 1850 NewCarrier 06 1327 9001 1 Western Europe 5 275 1375 2750 900 1850 NewCarrier 06 1327 9999 1 World Total 5 275 1375 2750 900 1850 NewCarrier 06 1327 84 1 Dominican Republic 6 275 1375 NewCarrier 06 1327 9004 1 Caribbean 6 275 1375 NewCarrier 06 1327 9999 1 World Total 6 275 1375 International Message Telephone Service: Foreign billed facilities-based/facilities-resale service NewCarrier 06 1327 326 1 United Kingdom 2 1000 4000 2560 NewCarrier 06 1327 9001 1 Western Europe 2 1000 4000 2560 NewCarrier 06 1327 9999 1 World Total 2 1000 4000 2560 International Message Telephone Service: Traditional Transiting facilities-based/facilities-resale service NewCarrier 06 1327 326 1 United Kingdom 3 14000 7000 4000 3000 NewCarrier 06 1327 9001 1 Western Europe 3 14000 7000 4000 3000 NewCarrier 06 1327 9999 1 World Total 3 14000 7000 4000 3000 # of circuits #of 64kbps Billed Rev. International Private Line Video (converted to 64 kbps equivalent circuits): U.S. Billed facilities-based service NewCarrier 06 1327 326 11 United Kingdom 1 10 54 2500 NewCarrier 06 1327 9001 11 Western Europe 1 10 54 2500 NewCarrier 06 1327 9999 11 World Total 1 10 54 2500 Attachment 2 6