*Pages 1--1 from sample template 43.6r.xls* 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 <<<<<<<<<<<<< Data entered as numeric fields>>>>>>>>>>>> 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 03 1327 326 1 United Kingdom 1 1125 7031 4100 4500 -400 NewCarrier 03 1327 9001 1 Western Europe 1 1125 7031 4100 4500 -400 NewCarrier 03 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 03 1327 326 1 United Kingdom 4 275 1375 2750 900 1850 NewCarrier 03 1327 9001 1 Western Europe 4 275 1375 2750 900 1850 NewCarrier 03 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 03 1327 326 1 United Kingdom 5 275 1375 2750 900 1850 NewCarrier 03 1327 9001 1 Western Europe 5 275 1375 2750 900 1850 NewCarrier 03 1327 9999 1 World Total 5 275 1375 2750 900 1850 NewCarrier 03 1327 84 1 Dominican Republic 6 275 1375 NewCarrier 03 1327 9004 1 Caribbean 6 275 1375 NewCarrier 03 1327 9999 1 World Total 6 275 1375 International Message Telephone Service: Foreign billed facilities- based/ facilities- resale service NewCarrier 03 1327 326 1 United Kingdom 2 1000 4000 2560 NewCarrier 03 1327 9001 1 Western Europe 2 1000 4000 2560 NewCarrier 03 1327 9999 1 World Total 2 1000 4000 2560 International Message Telephone Service: Traditional Transiting facilities- based/ facilities- resale service NewCarrier 03 1327 326 1 United Kingdom 3 14000 7000 4000 3000 NewCarrier 03 1327 9001 1 Western Europe 3 14000 7000 4000 3000 NewCarrier 03 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 03 1327 326 11 United Kingdom 1 10 54 2500 NewCarrier 03 1327 9001 11 Western Europe 1 10 54 2500 NewCarrier 03 1327 9999 11 World Total 1 10 54 2500 Attachment 2 1