When calculating summary data (including cost), the contractor shall first total each of the cost components that comprise the service including CLIN unit price (prorating if applicable), taxes, fees, and surcharges then aggregate the charges at the service level while maintaining the full 6 decimal places. When totaling the entire submitted bill, the contractor shall aggregate the individual service charges and then round the total value to 2 decimal places using the following standards: Upward rounding will when the 3rd decimal place is 5 or higher. Downward rounding shall occur with the 3rd decimal place is 4 or lower. For example: if the total amount due was $8395.4681674, since the 3rd decimal place is 8 the calculated amount due would be $8395.47. Rounding Example Table CLIN Pricing Category Pricing Component Unit Value Qty Cost of Each Pricing Component Rounding Notes EIS Service Voice Service 500.567800 3 $1,501.703400 No Rounding Required Government Fee AGF 0.050000 $75.085170 No Rounding Required Taxes & Surcharges Universal Service Fund 0.161000 $241.774247 241.7742474 rounded to six decimal places Number Portability 2.150000 $2.150000 No Rounding Required 911 14.950000 $14.950000 No Rounding Required Total EIS Service Cost [Total Service Cost + Fees + Surcharges] $1,835.662817 No Rounding Required EIS Service DS3 Data Service: NRC (Installation) 279.370000 5 $1,396.850000 No Rounding Required DS3 Data Service: MRC 1083.370000 5 $5,416.850000 No Rounding Required
Deliverables & Data Exchange Government-Provided Data Sets The following table lists the data sets the government will provide as part of this process. Detailed contents of each data set are in Section J.2.10.3 Data Set Content. For each line item below, the contractor shall support all listed transfer mechanisms as defined in Section J.2.9 Data Transfer Mechanisms unless the mechanism is specifically listed as optional. Government-Provided Data Sets Name Frequency Transfer Mechanism Dispute (D) As required Secure FTP Email Contractor's Website Means as agreed or required in the TO Contractor-Provided Data Sets The following lists the deliverables the contractor shall provide as part of this process. Detailed contents of each set of data are in Section J.2.10.3 Data Set Content. For each line item below, the contractor shall support all listed transfer mechanisms as defined in Section J.2.9 Data Transfer Mechanisms unless the mechanism is specifically listed as optional. Contractor-Provided Data Sets Table Name Frequency Transfer Mechanism Billing Adjustment (BA) Monthly, NLT 15th day (as needed) Secure FTP Email (if requested by the customer) Contractor's Website Means as agreed or required in the TO Dispute (D) As needed Secure FTP Email (if requested by the customer) Contractor's Website Other Means as agreed or required in the TO
Contractor-Provided Data Sets The following table lists the deliverables the contractor shall provide as part of this process. Detailed contents of each set of data are in Section J.2.10.3 Data Set Content. For each line item below, the contractor shall support all listed transfer mechanisms as defined in Section J.2.9 Data Transfer Mechanisms unless the mechanism is specifically listed as optional. Contractor-Provided Data Sets Table Name Frequency Transfer Mechanism Service Level Agreement Report (SLAR) Monthly, NLT 15th day of month Secure FTP (if requested by the customer) Other means as agreed or required in the TO SLA Credit Request Response Within 30 days of SLACR Email Other means as agreed or required in the TO Trouble Management Performance Summary Report Quarterly, NLT 14 days after the end of the FY quarter Email means as agreed or required in the TO Trouble Management Incident Performance Report Quarterly, NLT 14 days after the end of the FY quarter Email Other means as agreed or required in the TO Billing Adjustment (BA) Monthly, NLT 15th business day (as needed) See Section J.2.5 Billing Data Transfer Mechanisms Unless specified as optional, the contractor shall support all data transfer mechanisms listed for a particular data set.
10865 Contractor_Invoice_Level_Account_Number Always 51850 Invoice_Method_Code Always 208900 Agency_Identifier Always 209100 GSA_Account_Number Always Direct Billed Agency Setup (DBAS) Element ID Element Name Element Value Requirement 10400 Contract_Number Always 10865 Contractor_Invoice_Level_Account_Number Always 51850 Invoice_Method_Code Always 208900 Agency_Identifier Always 211000 Tax_Exempt Always Dispute Element ID Element Name Element Value Requirement Data_Transaction_Code Always 10300 Data_Transaction_File_Date Always Contract_Number Always 10650 Agency_Hierarchy_Code Always 10700 Agency_Service_Request_Number_1 If Applicable 10800 Agency_Service_Request_Number_2 If Applicable 10850 Contractor_Service_Request_Number Always 10865 Contractor_Invoice_Level_Account_Number If Applicable 10900 Agency_Task_Order_Num If Applicable 11000 Agency_Task_Order_Modification_Number If Applicable 20000 Data_Transaction_Line_Sequence_Number Always 20010 Unique_Billing_Identifier If Applicable 20200 Contract_Line_Item_Number Always 20300 Individual_Case_Basis_Code_Number If Applicable 20700 Quantity If Applicable
Access Framing Element ID Element Name Element Value Requirement 202000 Code Always 202100 Description Always 202200 Condition Always Access Jack Type Element ID Element Name Element Value Requirement 202600 Code Always 202700 Description Always 202800 Condition Always Access Provisioning Element ID Element Name Element Value Requirement 203200 Code Always 203300 Description Always Account Type Element ID Element Name Element Value Requirement 203700 Code Always 203800 Description Always Active Inactive Element ID Element Name Element Value Requirement 204200 Code Always 204300 Description Always
Dispute Status Element ID Element Name Element Value Requirement 219000 Code Always 219100 Description Always KPI Unit Type Element ID Element Name Element Value Requirement 220100 Code Always 220200 Description Always Line Coding Element ID Element Name Element Value Requirement 220600 Code Always 220700 Description Always 220800 Condition Always LOA Dependencies Element ID Element Name Element Value Requirement 221200 Code Always 221300 Description Always Location Element ID Element Name Element Value Requirement 221700 ICONECTIV_NSC Always 221900 Country Always 222000 Street_Prefix Always 222010 Street_Number Always 222020 Street_Name Always
222030 Street_Type Always 222040 Street_Suffix Always 222100 Address_2 Always 222200 City Always 222300 State Always 222400 Province Always 222450 County Always 222500 Postal_Code Always 222510 Vertical_Coordinates Always 222520 Horizontal_Coordinates Always 222600 Latitude Always 222700 Longitude Always Order Rejection Element ID Element Name Element Value Requirement 223100 Code Always 223200 Description Always Type at Header Level Element ID Element Name Element Value Requirement 223600 Code Always 223700 Description Always Order Type at Line Item Level Element ID Element Name Element Value Requirement 224010 Code Always 224020 Description Always
Primary Interchange Carrier (PIC) Element ID Element Name Element Value Requirement 227800 Code Always 227900 Description Always Service Element ID Element Name Element Value Requirement 232100 Contract_Code Always 232200 Service_Area Always 232300 Service Always 232400 Mandatory_Optional Always 232500 Service_Code Always 232600 Service_CLIN_Prefix Always 232700 Section_C_Reference Always 232710 Section_B_Reference Always 232720 CBSA_Based_Service Always Telecommunications Service Priority (TSP) Element ID Element Name Element Value Requirement 234800 Control_Code Always 234900 Provisioning_Priority Always 235000 Restoration_Priority Always 235100 Effective_Date Always 235200 End_Renewal_Date Always Element ID Element Name Element Value Requirement
number; however, may be assigned in the quote cycle to track to service completion. DOD uses this field for a CSA number. 10800 Agency service tracking identification ID_2; this would be an order number; however, may be assigned in the quote cycle to track to service completion. DOD uses this field for a TSR number. 50 Contractor service tracking identification; This is a contractor order tracking number. 50 Contractor Invoice Level Account Number for an agency not the central invoice. Each agency may have more than one account. 25 AS 10875 This is a Contractor account number for the service; this number will be used to group all components of a service or an account that 50
11900 Order Rejection Code 25 Code 12200 Contracting Officer Representative (COR) email address 100 12201 Contracting Officer Representative First Name 30 12202 Contracting Officer Representative Last Name 30 12203 Contracting Officer Representative Work Phone Number Numeric 15 Contracting Officer Representative Work Extension Numeric 5 NNNNN 12205 Contracting Officer Representative Work Mobile Phone Number Numeric 15 Point of Contact (POC) email address 100
12301 Point of Contact First Name 30 12302 Point of Contact Last Name 30 Order Point of Contact Work Phone Number Numeric 15 Order Point of Contact Work Phone Extension Numeric 5 NNNNN 12305 Point of Contact Work Mobile Phone Number Numeric 15 12400 Technical Point of Contact (POC) email address 100 12401 Technical of Contact First Name 30 12402 Technical Point of Contact Last Name 30
12403 Technical of Contact Work Phone Number Numeric 15 12404 Technical Point of Contact Work Phone Extension Numeric 5 NNNNN 12405 Technical Point of Contact Work Mobile Phone Number Numeric 15 20000 Data Transaction data line sequence number; each data record must have a unique line item number for each data record Numeric 14 20010 This ID is Contractor assigned and keeps a service grouped together over multiple orders and changes to the service over time. 86 20200 Contract Line Item Numbers (CLINs); Agency or Contractor may provide CLINs; all CLINs must be approved via an order by the Agency prior to the activity occurring 7 Identifier
30050 Location_State State for this order location (Service Delivery Address) Alpha 50 Location 30060 Province for this location (Service Delivery Address) 50 Location Province 30070 Postal code for this order location (Service Delivery Address) 10 Location Postal Code 30080 Delivery latitude (Service Delivery Address) Numeric 10 Location Latitude 30090 Delivery longitude (Service Delivery Address) Numeric 10 Location Longitude 30100 Building Building (Service Delivery Address) 20 30110 Floor Floor (Service Delivery Address) 10 30120 Room Room (Service Delivery Address) 10 30130 Applies to domestic or (Service Delivery Address) Numeric 6 Country Jurisdiction_ID 30140 Originating site of Contact (POC) email address 100
30141 First Name 30 30142 Last Name 30 Phone Number of Contact Numeric 15 30144 Phone extension of Contact Numeric 5 NNNNN 30145 Mobile phone number of Contact Numeric 15 30150 Time of Day at which Originating Site building opens for Contractor personnel access Time 8 HH:MM:SS 30160 Time of Day at which Originating Site building closes for Contractor personnel access Time 8 HH:MM:SS 30165 Site advanced hours notification required Numeric 2 0, 24, 48, 72, 99(See Special Instructions) 30170 Originating Site Special Instructions 255
Reserved for future billing use 250 Reserved for future billing use 250 53450 Reserved for future billing use 250 53500 Reserved for future billing use 250 53550 Reserved for future billing use 250 Reserved for future billing use 250 53650 Agency Associated Government Fee Percent (AGF) rate Numeric 10 ` 53850 Non-Recurring Charge (NRC) waiver Yes or No 1 Yes_No Code 53900 This is the taxable amount. NO AGF, Taxes, or Surcharges may be in this amount. Numeric 23 54000 Billed_Amount Numeric 23
80700 Service Level Agreement (SLA) credit ID 60 80800 Service Level Agreement (SLA) credit amount Numeric 23 90000 Tax identification number 20 Allowable_Tax Item_Number Tax identification modification number 20 Allowable_Tax Item_Number 100000 Amount that Contractor billed directly to agency for AGF fee and collected for GSA Numeric 23 100100 Adjusted amount that Contractor billed for AGF fee and collected for GSA Numeric 23 100400 Associated Government Fee (AGF) amount that was wire transferred to GSA Numeric 23 100500 Date that Associated Government Fee (AGF) was wire transferred to GSA Date 10 208900 from the ABCODE 9 ABCODE
202800 Condition Access Jack Type Condition 50 203200 Code Access Provisioning Provider Code 2 203300 Description Access Provisioning Provider Description 256 203700 Code Account Type Code 4 203800 Description Account Type Description 256 204200 Code Active or Inactive Code 1 204300 Description Active or Inactive Description 256 204700 Code Adjustment Outcome Code 25 204800 Description Adjustment Outcome Description 256 205200 Code Adjustment Reason Code 25 205300 Description Adjustment Reason Description 256 207390 Tax identification number 20
207900 Citation Tax Citation by Statute, DR Rule, County Code, Muni Code, PUC Rule. example AZ Statute 255 208050 Effective_Date Date to begin collection of tax Date/time 22 HH:MM:SS 208060 End_Date Date tax collection ends. May need Language that the contractor must monitor end dates based on tax. This end date is an audit Date/time 22 HH:MM:SS 211000 Agency Tax Exempt status 50 211500 Code Authoritative System Type Code 1 211600 Description Authoritative System Type Description 256 211700 Condition Authoritative System Type Condition 50 213400 Code Bandwidth Code 25 213500 Description Bandwidth Description 256 213900 Code Central Direct Code 1
215720 Contract End Date Date 12 215730 Total_Amount Contract Total Amount Numeric 23 215740 Contract Government Contracting Officer 100 POC 215750 Contract Contractor Contracting Officer 100 POC 215760 Contract Modification Number 25 215770 Contract Modification Effective Date Date 12 216100 ISO_ALPHA_2 2-letter alphanumeric ISO country code Alpha 2 216200 ISO_ALPHA_3 3-letter alphanumeric ISO country code Alpha 3 216300 ISO Numeric Country Code Numeric 3 NNN 216400 Country Jurisdiction ID Numeric 6 216430 AOW Area of the World (AOW) Numeric 6
232100 Contract_Code Contract Number as assigned by Contract Award 20 Contract Number 232200 Service_Area Service_Area (See B Section) 256 232300 Service Service (See B Section) 256 232400 Mandatory_Optional (See B Section) Alpha 1 232500 Service_Code Service_Code (See B Section) 20 232600 Service_CLIN_Prefix (See B Section) Alpha 2 232700 Section_C_Reference (See B Section) String 20 232710 Section_B_Reference (See B Section) String 20 232720 CBSA_Based_Service (See B Section) String 20 234300 Code True False Code 1 234400 Description True False Description 256 234800 Control_Code TSP Control ID 9