System and method for intelligent data extraction for telecommunications invoices

[0001] 1. Field of the Invention

[0002] The present invention relates generally to invoices and, more particularly, to telecommunications invoices.

[0003] 2. Related Art

[0004] Interconnection arrangements in the telecommunications industry have a long history. Interconnection first became a contractual issue in 1894 when Alexander Graham Bell's initial patents expired. Beginning in 1894, the Bell System had to enter into interconnecting contracts with independent telephone companies, and the independent telephone companies similarly signed contracts with each other that governed the terms of interconnection.

[0005] Telecommunications legislation and regulatory actions in the past few decades in the United States has led to creation of a large number of incumbent local exchange carriers (ILECs), intra exchange carriers (IXCs), and competitive local exchange carriers (CLECs). Through a complex system of regulation, telephone calls are placed through these multi-vendor networks using the vast networks of cooperating companies.

[0006] In 1984, AT&T was broken up by antitrust regulators in the U.S., forming a network of local phone companies (the ILECs), and long distance companies (the IXCs). Following the breakup, initially each local loop was monopolized and run by a LEC, typically a Regional Bell Operating Company (RBOC) or an independent telephone company such as GTE. Excluding cellular phones, the local loop was a required input in the production of long distance services, and typically long distance companies did not have their own comparable local loop. In telecommunications, the use of a local exchange incurred charges to originate calls (access origination) or to terminate calls (access termination).

[0007] Passage of the Telecommunications Act of 1996, authorizing competition in the local phone service market, has permitted CLECs to compete with ILECs in providing local exchange services. This competition has created even more companies which may charge for origination or termination.

[0008] When a customer places a telephone call, the call may often originate onto an ILEC, may be transported over a network of the ILEC, and/or an IXC's network, and then may be terminated on an ILECs' facilities. If a call originates at an ILEC, is terminated onto a CLEC's facilities, and then is terminated, e.g., at an Internet Service Provider (ISP), then the ILEC owes the CLEC reciprocal compensation for the termination of the call. Thus, reciprocal compensation is basically a settlement mechanism for telephone traffic transferred between two local networks. This arrangement was pursuant to the FCC Interconnection Order. The money follows the calls. Most ISP calls are from users and terminated to ISPs. This potentially means a lot of money flowing from ILECs to CLECs who have ISPs as customers. The ISPs are considered “end users” pursuant to FCC rules, and therefore the call is considered a local call. If a call is considered a long distance transmission, then reciprocal compensation did not apply. Many ILECs may pay CLECs reciprocal compensation.

[0009] Because of the many origination and termination fees that are charged by telephone companies, an ILEC, for instance, can receive enormous numbers of often enormously sized invoices from many different individual telecommunications service providers. Individual large companies may also receive many telecommunications services invoices for their entities. The processing of telecommunications invoices which come from many different entities with largely non-uniform billing systems, can be an extremely costly process, which may be fraught with potential billing errors.

[0010] A telecommunications carrier may send and receive thousands of invoices each month. Most of these invoices between carriers may be electronic (perhaps 60-80% depending on the carrier). There are several structured industry formats for providing electronic invoices. The structured industry formats include CABS and SECAB formats which are maintained and improved by industry associations. However, many bills are not available in these formats.

[0011] Since most companies do not have the means to create separate custom tools to accept any non-standard input format, most carriers still obtain a large proportion of bills on printed paper. Indeed, many bills are still provided in printed form as a large paper document. The result is that every telecommunications carrier spends considerable manual effort to process, audit and pay thousands of manual invoices.

[0012] Processing paper invoices is extremely time-consuming and costly. The cost of creating loading programs and maintaining them for multiple carriers is also time consuming and costly. As a result, manual invoices are often paid without any automated auditing or detailed review. The lack of detailed review results in even higher costs and processing errors to telecommunications carriers.

[0013] The present invention sets forth various exemplary embodiments of systems, methods and computer program products for extracting telecommunications invoice data from an electronic data stream, modeling and mapping the telecommunications invoice data stream into a normalized data format.

[0014] According to an exemplary embodiment of the present invention, a method may include: receiving a telecommunications invoice data stream in a first data format; analyzing the telecommunications invoice data stream to determine the first data format; modeling the telecommunications invoice data stream; and mapping the modeled telecommunications invoice data stream to a normalized data format.

[0015] According to another exemplary embodiment of the present invention, the method may include: where the modeling of the telecommunications invoice data stream further may include at least one of: creating a model for the first data format; modeling the telecommunications invoice data stream according to the model; and/or modeling the telecommunications invoice data stream with an intelligent adapter.

[0016] In yet another exemplary embodiment of the present invention, the method may further include: validating the parsed data by comparing a first telecommunications invoice generated from the telecommunications invoice data stream in the first data format with a second telecommunications invoice generated from the mapped telecommunications invoice data stream.

[0017] According to an exemplary embodiment of the present invention, the method may further include: auditing the telecommunications invoice printer data stream for billing accuracy may include at least one of: comparing telecommunications invoice charges with telecommunications invoice total cost included in the telecommunications invoice data stream; confirming field integrity; confirming numerical accuracy; and/or confirming expected field lengths.

[0018] According to an exemplary embodiment of the present invention, the method may include where the received telecommunications invoice data stream may include at least one of a non-industry standard data format and/or a captured electronic print data file.

[0019] According to an exemplary embodiment of the present invention, the method may include where the captured electronic print data file is captured at a remote site.

[0020] According to an exemplary embodiment of the present invention, the method may include where the telecommunications invoice data stream may include a electronic print data file of a telecommunications invoice.

[0021] According to an exemplary embodiment of the present invention, the method may include where the telecommunications invoice data stream may include a company telecommunications invoice data stream.

[0022] According to an exemplary embodiment of the present invention, the method may include where the first data format may include at least one of a non-industry standard data file, a PDF file, a PRN file, an LPT file, and/or a TIFF file.

[0023] According to an exemplary embodiment of the present invention, the method may include where the normalized data format may include at least one of an XTrak interchange format (xif), an extensible markup language (xml) format, an industry standard format, and/or a proprietary format.

[0024] According to an exemplary embodiment of the present invention, the method may include the step of mapping the modeled invoice data further may include at least one of: mapping the modeled telecommunications invoice data stream according to mapping codes; mapping the modeled telecommunications invoice data stream with an intelligent adapter; blending a record into a record may include a superset of fields of an industry standard record and/or mapping the modeled telecommunications invoice data stream using fuzzy logic.

[0025] According to an exemplary embodiment of the present invention, the method may include where the received telecommunications invoice data stream is received at a centralized site from a remote site.

[0026] According to an exemplary embodiment of the present invention, the method may further include: transmitting the mapped telecommunications invoice data stream to a centralized site from a remote site.

[0027] According to an exemplary embodiment of the present invention, the method may include the first data format, which may include at least one of: usage records; facilities records; switched call records; dedicated facilities records; call detail records (CDRs); facility cost records (FCRs); voice over Internet Protocol (VoIP) records; packet records; content records; ringtone records; audio records; video records; broadcast records; wireless records; CATV records; satellite records; other usage records; other facility records; and/or other charge records.

[0028] According to an exemplary embodiment of the present invention, a machine-readable medium may include providing instructions, which when executed by a computing platform, may cause the computing platform to perform operations, which may include a method, which may include: receiving a telecommunications invoice data stream in a first data format; analyzing the telecommunications invoice data stream to determine the first data format; modeling the telecommunications invoice data stream; and mapping the modeled telecommunications invoice data stream to a normalized data format.

[0029] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the modeling of the telecommunications invoice data stream further may include at least one of: creating a model for the first data format; modeling the telecommunications invoice data stream according to the modeling model; and/or modeling with an intelligent adapter the telecommunications invoice data stream.

[0030] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the method further may include: validating the parsed data by comparing a first telecommunications invoice generated from the telecommunications invoice data stream in the first data format with a second telecommunications invoice generated from the mapped telecommunications invoice data stream.

[0031] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the method further may include: auditing the telecommunications invoice printer data stream for billing accuracy may include at least one of: comparing telecommunications invoice charges with telecommunications invoice total cost included in the telecommunications invoice data stream; confirming field integrity; confirming numerical accuracy; and/or confirming expected field lengths.

[0032] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the received telecommunications invoice data stream may include a captured electronic print file.

[0033] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the captured electronic print file is captured at a remote site.

[0034] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the telecommunications invoice data stream may include a electronic print file of a telecommunications invoice.

[0035] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the telecommunications invoice data stream may include a company telecommunications invoice data stream.

[0036] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the first data format may include at least one of a non-industry standard file, a PDF file, a PRN file, an LPT file, and/or a TIFF file.

[0037] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the second normalized data format may include at least one of an XTrak interchange format (xif), an extensible markup language (xml) format, an industry standard format, and/or a proprietary format.

[0038] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the step of mapping the parsed invoice data further may include at least one of: mapping the modeled telecommunications invoice data stream according to mapping codes; mapping the modeled telecommunications invoice data stream with an intelligent adapter; blending a record into a record may include a superset of fields of an industry standard record and/or mapping the modeled telecommunications invoice data stream using fuzzy logic.

[0039] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the received telecommunications invoice data stream is received at a centralized site from a remote site.

[0040] According to another exemplary embodiment of the present invention, the machine-readable medium may include where the method further may include: transmitting the mapped telecommunications invoice data stream to a centralized site from a remote site.

[0041] According to an exemplary embodiment of the present invention, a system may include: receiving means for receiving a telecommunications invoice data stream in a first data format; analyzing means for analyzing the telecommunications invoice data stream to determine the first data format; modeling means for modeling the telecommunications invoice data stream; and mapping means for mapping the modeled telecommunications invoice data stream to a normalized data format.

[0042] According to another exemplary embodiment of the present invention, the system may include where the modeling means further may include: means for creating a modeling model for the first data format; means for modeling the telecommunications invoice data stream according to the modeling model; means for blending a record into a record may include a superset of fields of an industry standard record; and/or means for modeling the telecommunications invoice data stream with an intelligent adapter.

[0043] According to another exemplary embodiment of the present invention, the system may further include: means for validating the parsed data by comparing a first telecommunications invoice generated from the telecommunications invoice data stream in the first printer data stream format with a second telecommunications invoice generated from the mapped telecommunications invoice data stream.

[0044] According to another exemplary embodiment of the present invention, the system may further include: means for auditing the telecommunications invoice printer data stream for billing accuracy may include at least one of: means for comparing telecommunications invoice charges with telecommunications invoice total cost included in the telecommunications invoice data stream; means for confirming field integrity; means for confirming numerical accuracy; and/or means for confirming expected field lengths.

[0045] According to another exemplary embodiment of the present invention, the system may include where the received telecommunications invoice data stream may include a captured electronic print file.

[0046] According to another exemplary embodiment of the present invention, the system may include where the captured electronic print file is captured at a remote site.

[0047] According to another exemplary embodiment of the present invention, the system may include where the telecommunications invoice data stream may include a electronic print file of a telecommunications invoice.

[0048] According to another exemplary embodiment of the present invention, the system may include where the telecommunications invoice data stream may include a company telecommunications invoice data stream.

[0049] According to another exemplary embodiment of the present invention, the system may include where the first printer data stream format may include at least one of a non-industry standard format, a PDF file, a PRN file, an LPT file, and/or a TIFF file.

[0050] According to another exemplary embodiment of the present invention, the system may include where the second normalized data format may include at least one of an XTrak interchange format (xif), an extensible markup language (xml) format, an industry standard format, and/or a proprietary format.

[0051] According to another exemplary embodiment of the present invention, the system may include where the mapping means further may include at least one of: means for mapping the modeled telecommunications invoice data stream according to mapping codes; means for mapping the modeled telecommunications invoice data stream with an intelligent adapter; and/or means for mapping the modeled telecommunications invoice data stream using fuzzy logic.

[0052] According to another exemplary embodiment of the present invention, the system may include where the received telecommunications invoice data stream is received at a centralized site from a remote site.

[0053] According to another exemplary embodiment of the present invention, the system may further include: means for transmitting the mapped telecommunications invoice data stream to a centralized site from a remote site.

[0054] Various exemplary features and advantages of the invention will be apparent from the following, more particular description of exemplary embodiments of the present invention, as illustrated in the accompanying drawings wherein like reference numbers generally indicate identical, functionally similar, and/or structurally similar elements. The left most digits in the corresponding reference number indicate the drawing in which an element first appears.

[0055] FIG. 1 is an exemplary embodiment of a block diagram providing an overview of an exemplary telecommunications network providing exemplary local exchange carrier (LECs) services within one or more local access and transport areas (LATAs);

[0056] FIG. 2 is an exemplary embodiment of a block diagram illustrating an exemplary overview of a telecommunications network providing both local exchange carrier (LEC) and interexchange carrier (IXC) services between subscribers located in different local access and transport areas (LATAs);

[0057] FIG. 3 illustrates an exemplary embodiment of a block diagram of an exemplary voice over data network providing what may be an exemplary competitive local exchange carrier (CLEC) service between subscribers;

[0058] FIG. 4 depicts an exemplary embodiment of a block diagram of an XTrak invoice process according to an exemplary embodiment of the present invention;

[0059] FIG. 5 depicts an exemplary embodiment of a computer system that may be used in computing devices such as, e.g., client and/or server devices according to an exemplary embodiment of the present invention.

[0060] A preferred exemplary embodiment of the invention is discussed in detail below. While specific exemplary embodiments are discussed, it should be understood that this is done for illustration purposes only. A person skilled in the relevant art will recognize that other components and configurations may be used without parting from the spirit and scope of the invention.

Overview of the Invention

[0061] An exemplary embodiment of the present invention represents a process and software adapted to convert a telecommunications invoice and/or contract information from a large number of dissimilar formats into a single, unified, proprietary format, the *.xif format. The XTrak. Interchange format (XIF) *.xif format (also, XIF™) is a proprietary format available from TEOCO Corporation of Fairfax, Va., USA.

[0062] In addition to the structured industry formats CABS and SECAB, there may be other proprietary output formats of the sending carrier's billing systems. Examples of formats which are not the structured industry formats may include, e.g., but are not limited to: PDF, XML, PRN, Text, Excel spreadsheet format, DBF, MDB, RTF, TIFF, Word and electronic data interchange (EDI) formats. These formats require the receiving carrier to spend significant resources to process these files and to write loading programs for each file received. As a result of the effort required, most carriers opt to receive the paper version of the invoice rather than invest the IT resources necessary to create the loading programs to be able to access the non-industry formats.

[0063] The XTrak system available from TEOCO Corporation, according to an exemplary embodiment of the present invention, takes the burden of converting non-standard invoice formats off the telecommunications carrier. The exemplary embodiment of the present invention processes dissimilar formats into a single proprietary format known as XIF™ (XTrak Interchange Format). From this format, licensees of XTrak need only one loading program for all dissimilar input formats.

[0064] According to an exemplary embodiment of the present invention, first, a person with a detailed understanding of the Telecommunication Industry data and formats may analyze the different input formats and may determine the appropriate mapping the different input formats into the XIF format. The mapping process, according to an exemplary embodiment may include a process incorporating human intelligence and a working knowledge of industry standards.

[0065] Second, once the mapping is complete, an intelligent adapter may be created that may parse data out of a carrier specific format, may perform field integrity validations, and may place the information into the XIF database. The modeling program can recognize and adjust to different field locations, currencies and languages. Third, once the invoice data stream is in the XIF database, then, e.g., but not limited to, invoice and contractual data can be extracted for analysis and auditing.

[0066] According to an exemplary embodiment, XTrak may reduce carrier costs and may improve analysis, by providing a more detailed analysis of information than previously accessible to a carrier. Intelligent adapters may accelerate the process of data extraction by moving from the classic way of writing line by line parsing programs, and by moving to creating data models which hunt for the appropriate data in a file. The result is a much faster development cycle to create adaptors for the wide variety of carrier files.

[0067] According to an exemplary embodiment of the present invention, XTrak may use the latest multi-processing technologies to allow for processing of large files (greater than 1 million records) in minutes.

[0068] FIG. 4 depicts an exemplary embodiment of the XTrak Process Flow 400, according to an exemplary embodiment of the present invention. In an exemplary embodiment, an exemplary telecommunications carrier may process 25,000 to 30,000 invoices per month. An exemplary distribution by value of invoices may include 35% of Carrier Access Billing (CABS) format electronic bills 402, (in an exemplary embodiment, the bills may be CABS v.10), 20% Small Enterprise CABS format bills 404, (in an exemplary embodiment, the bills may be SECAB v.10). Examples of industry standard invoice formats are included in Table 2 below. The remaining 45% of the invoices, by value, of the invoices of the exemplary telecommunications carrier, related to approximately 400 carriers, generally provide paper invoices 406.

[0069] In an exemplary embodiment, in order to audit the invoices and to review the invoices for any errors, a system such as, e.g., but not limited to, Bill Trak Pro (BTP), available from TEOCO Corporation of Fairfax, Va., USA. The BTP system may include a BTP database 424, as shown. In order to load data into the BTP system, data must be loaded into the BTP DB 424. Industry standard invoices such as, e.g., but not limited to, EDI, CABS 402 and SECAB 404, etc. formatted data may be loaded into BTP DB 424 using an appropriate data loader 422. Unfortunately, invoice standards such as, CABS 402 and SECAB 404 continually change, and sometimes, a billing system may not use the latest industry standard format, thus even industry standard invoices may not always be easily loaded into an auditing system. Unfortunately, paper invoices also may not be loaded into a billing auditing system. Non-standard electronic invoices, conventionally may also not be imported into the BTP DB 424 bill auditing system. For most non-standard invoice formats, there is no individual data loader 422 to load the invoice data. Further, for paper invoices 406, the invoices conventionally must be scanned, the data must be recognized using, e.g., but not limited to, an optical character recognition (OCR) system, and then the results of the recognition must be proofread, since OCR conventionally is only 99.8% accurate. Although 99.8% accuracy may sound very accurate, in the case of invoice data, this level of accuracy is unacceptable, and only 100% accuracy is acceptable. For example, OCR cannot distinguish between a lower case L (l), a number one (1), a capital I. Also, OCR cannot distinguish between a zero and the letter O. Telecommunications invoices are all numbers (e.g., dollar amounts), and words, so they are difficult for OCR programs to figure out. Also, telecom invoice data amounts can be large dollar values, so one wrong digit, or a misplaced decimal point can make a big difference. Thus, any scanning and OCR of an invoice requires manual intervention. Thus, conventionally, only face pages of invoices are scanned, i.e., the first page of a bill (without any detail), and then the results of scanning, OCR and proofing 408, are required to be corrected using manual data entry and correction 410. If one only scans the face page of a bill, then payment of the paper invoice may be possible, however, almost no auditing is possible with only a face page of an invoice. Unfortunately, if one scans only the face page of an invoice, much of the invoice's information is lost and the bill auditing system then is unable to fully audit the bill.

[0070] According to an exemplary embodiment of the present invention, the print data streams of the paper invoices 406 of the 400 carriers may be intercepted and stored, prior to printing. These print data stream invoices may be thought of as quasi-electronic invoices 430, in the print data stream format. Conventional printer data stream formats may include, e.g., but not limited to, TXT, PRN, PDF, XLS, DAT, Custom formats, proprietary billing system output formats, etc. Exemplary print datastream formats appear below in Table 1. The printer datastream format electronic invoices 430 may be parsed using a parser 414 to break the data into an XTrak Invoice database 416 format, according to an exemplary embodiment of the present invention. The modeling process, according to an exemplary embodiment of the present invention may include building a modeling model using a datamining tool such as, e.g., but not limited to, a DATAWATCH® MONARCH PRO product data mining tool to map the input invoice print datastream format into a proprietary XTrak database format (XIF) format. The modeling model may be created using the datamining tool, and the mapped data may be cleaned up, and validated, using software, and/or manual data entry or correction 410, as shown. Once the modeling model has been created for a given input datastream format, then the invoice data may be mapped into the XTrak invoice data model format 420. In addition, some invoices may be created using industry standard invoice database 426 format systems such as, e.g., but not limited to, MDB, DBF, etc., for such invoice databases 426, the invoice data may be converted using a converter 428 into an XTrak Invoice database 416, according to an exemplary embodiment of the present invention.

[0071] According to an exemplary embodiment, data from XTrak invoice database 416 may be exported using XIF xPorter 418 to generate an XTrak Invoice Format (XIF) normalized invoice for input into data loader 422. Normalization may include, in an exemplary embodiment, blending data records into a single record format. In an exemplary embodiment, data records may be blended into a record which may include a superset of fields of an industry standard data format. Exemplary records which may be blended, and/or mapped, according to an exemplary embodiment, may include usage records, facilities records, switched call records, dedicated facilities records, call detail records (CDRs), facility cost records (FCRs), voice over Internet Protocol (VoIP) records, packet records, content, ringtone, audio, video, broadcast, wireless, CATV, satellite and other usage, facility and/or other charges, etc. The XTrak invoice format (XIF) invoice is a proprietary invoice format which is a robust data structure including a super set of all invoice data from CABS, SECAB, non-industry standard invoice formats, proprietary invoice formats, and any custom data from customers. An exemplary XIF layout is included below in Table 3. XIF invoice format mapping is shown below in Table 4.

[0072] According to an exemplary embodiment of the present invention, the model may be fed into a database.

[0073] According to another exemplary embodiment, the modeling model, after being constructed, may be validated to check for errors. For example, if the modeling model breaks up components of a total, as well as the total, a sum of the components may be calculated and compared to the parsed total as a validation. The modeling validation process may identify billing errors. The billing auditing system may also identify billing errors.

[0074] According to another exemplary embodiment, a user may add map code to remap data for specific customer needs.

[0075] According to an exemplary embodiment, a customer may request to customize the XIF format to include additional fields of particular interest to a customer.

[0076] According to another exemplary embodiment, the XIF format may be mapped to convert data to another format such as, e.g., but not limited to, a standard billing format, a CABS format, a SECAB format, an EDI format (such as, e.g., but not limited to, an EDI 811), an extensible markup format (XML), etc.

Supported Input File Extensions

[0077] An exemplary embodiment of the present invention may accept any of the exemplary file extensions noted in Table 1, below:

TABLE 1
File Extensions Supported by Xtrak
Extension	Source
.txt	ASCII text
.mdb	Microsoft
.tif	Tag image bitmap file (TIFF)
.xls	Microsoft ® Excel ® Spreadsheet
.dbf	A dBASE file, a format originated by Ashton-Tate
.pdf	Portable Document file (Adobe Acrobat)
.db	Borland ® Paradox ® 7 table database
.htm	A Web page (a file containing Hypertext Markup Language)
.prn	Windows Print File format

[0078] In addition to the non-standard, print data file formats noted in Table 1, in an exemplary embodiment, the present invention may also accept certain standard industry formats including those noted in Table 2, below:

TABLE 2
Industry Standard Formats Supported by XTrak
Format Name	Description
EDI 811	EDI Telecommunications Billing (ETB) is an
	industry group comprised of representatives from
	telecommunications providers and customers.
Carrier Access Billing	Carrier Access Billing System (Telcordia
Specifications (CABS)	Technologies, Inc.)
Small Exchange	Industry-created and agreed upon standards
Carrier Access	and guidelines for billing access charges
Billing Specifications	within the telecommunications industry for small
(SECAB)	exchange carriers (SECs)

[0079] According to an exemplary embodiment, the present invention may support any database system including, e.g., but not limited to, those available from Microsoft Corporation of Redmond, Wash., Oracle of Redwood Shores, Calif., IBM Corporation of Armonk, N.Y., Sybase of Dublin, Calif., Foxpro available from Microsoft, and Dbase available from dataBased Intelligence, Inc. of Vestal, N.Y. Of course these are merely examples of some common databases, and the present invention is equally applicable to any other available database, database management, or the like.

[0080] An exemplary embodiment of the XIF layout according to an exemplary embodiment of the present invention appears below in Table 3:

TABLE 3
XTrak Interchange Format (XIF) Layout
	File Conventions
	Delimiter = Tab.
	Carriage Return used as end of line character.
	Dollar Amounts should be rounded to (2) decimal places unless otherwise specified.
	Credit Amounts sent through XIF are expected to contain a negative sign preceding the actual
	dollar value.
Record	Field Name	Data Type	Position	Min/Max	Required	Definition
HDR - Header Record (1 Occurrence per file)
HDR	RECORD_TYPE	STRING	1	3/3	Y
HDR	FORMAT	STRING	6	4/4	Y
HDR	VERSION	STRING	7	1/12	Y
HDR	EXPORT_DATE	DATE	8	10/10
SUM - Summary Record (1 Occurrence per Invoice)
SUM	RECORD_TYPE	STRING	1	3/3	Y
SUM	ACCT_NUM	STRING	2	1/18	Y
SUM	MASTER_ACCT_NUM	STRING	3	1/18
SUM	INV_NUM	STRING	4	1/50	Y
SUM	BILL_DATE	DATE	5	10/10	Y
SUM	INV_CO_CODE	STRING	6	1/4
SUM	VENDOR_NAME	STRING	7	1/35
SUM	DATA_FILE_NAME	STRING	8	1/80
SUM	TRANSMIT_DATE	DATE	9	8/8
SUM	DUE_DATE	DATE	10	8/8
SUM	ICSC_CODE	STRING	11	1/4
SUM	INV_FROM_DATE	DATE	12	8/8
SUM	INV_THRU_DATE	DATE	13	8/8
SUM	SOURCE_TYPE	STRING	14	1/5	Y
SUM	ACCT_TYPE	STRING	15	1/35
SUM	MIN_DUE	FLOAT	16	1/11
SUM	INV_MPB_IND	STRING	17	1/1
SUM	BAL_FORWARD_AMT	FLOAT	18	1/11
SUM	TOT_ADJ_AMT	FLOAT	19	1/11
SUM	TOT_LAST_AMT	FLOAT	20	1/11
SUM	TOT_LPC_AMT	FLOAT	21	1/11
SUM	TOT_MRC_AMT	FLOAT	22	1/11
SUM	TOT_OCC_AMT	FLOAT	23	1/11
SUM	TOT_PAYMENT_AMT	FLOAT	24	1/11
SUM	TOT_REG_FEE_AMT	FLOAT	25	1/11
SUM	TOT_REJECT_AMT	FLOAT	26	1/11
SUM	TOT_SURCHRG_AMT	FLOAT	27	1/11
SUM	TOT_TAX_AMT	FLOAT	28	1/11
SUM	TOT_USG_AMT	FLOAT	29	1/11
SUM	TOT_DUE_AMT	FLOAT	30	1/11
SUM	CURRENT_DUE_AMT	FLOAT	31	1/11
DTL - Detail Record (0 to many Occurrences per Invoice)
DTL	RECORD_TYPE	STRING	1	3/3	Y
DTL	ACCT_NUM	STRING	2	1/18	Y
DTL	INV_NUM	STRING	3	1/50	Y
DTL	BILL_DATE	DATE	4	10/10	Y
DTL	INV_CO_CODE	STRING	5	1/4
DTL	CHRG_TYPE	STRING	6	3/3
DTL	AUDIT_NUM	STRING	7	1/30
DTL	BIP	STRING	8	3/3
DTL	CELLULAR_USAGE_IND	STRING	9	1/1
DTL	CFA	STRING	10	1/42
DTL	CHRG_BASE_AMT	FLOAT	11	1/11
DTL	CHRG_BILLED_AMT	FLOAT	12	1/11
DTL	CHRG_CODE_TYPE	STRING	13	1/20
DTL	CHRG_CODE	STRING	14	1/13
DTL	CHRG_DESC	STRING	15	1/80
DTL	CHRG_DISC_AMT	FLOAT	16	1/11
DTL	CHRG_FED_TAX_AMT	FLOAT	17	1/11
DTL	CHRG_FROM_DATE	DATE	18	8/8
DTL	CHRG_MPB_IND	STRING	19	1/1
DTL	CHRG_REG_FEE_AMT	FLOAT	20	1/11
DTL	CHRG_SRV_EST_DATE	DATE	21	8/8
DTL	CHRG_ST_LCL_TAX_AMT	FLOAT	22	1/11
DTL	CHRG_SURCHRG_AMT	FLOAT	23	1/11
DTL	CHRG_THRU_DATE	DATE	24	8/8
DTL	CIC	STRING	25	1/5
DTL	CKT_SRV_EST_DATE	DATE	26	8/8
DTL	COMPLETION_DATE	DATE	27	8/8
DTL	CUST_NAME	STRING	28	1/35
DTL	DAYS_LATE	INTEGER	29	1/3
DTL	DIRECTIONALITY_IND	STRING	30	1/1
DTL	EC_CIRCUIT_ID	STRING	31	1/53
DTL	END_OFC_ID	STRING	32	1/11
DTL	IC_CIRCUIT_ID	STRING	33	1/53
DTL	JURISDICTION	STRING	34	1/2
DTL	LATA	STRING	35	3/5
DTL	LPIC	STRING	36	1/10
DTL	MILEAGE	INTEGER	37	1/9
DTL	MILEAGE_UNIT	STRING	38	1/2
DTL	MRP1	STRING	39	1/11
DTL	MRP2	STRING	40	1/11
DTL	MRP1_TYPE	STRING	41	1/4
DTL	MRP2_TYPE	STRING	42	1/4
DTL	MSG_RATE_CLASS	STRING	43	1/2
DTL	NC_CODE	STRING	44	1/4
DTL	NCI_CODE	STRING	45	1/12
DTL	NPA_NXX	STRING	46	3/6
DTL	ORIG_ADDR	STRING	47	1/90
DTL	ORIG_CITY	STRING	48	1/35
DTL	ORIG_COUNTRY	STRING	49	1/35
DTL	ORIG_COUNTRY_CODE	STRING	50	3/4
DTL	ORIG_STATE	STRING	51	2/2
DTL	ORIG_TN	STRING	52	1/24
DTL	PIC	STRING	53	1/10
DTL	PIU	STRING	54	3/3
DTL	PLU	STRING	55	3/3
DTL	PON	STRING	56	1/30
DTL	PPU	STRING	57	3/3
DTL	PREMIUM_IND	STRING	58	1/1
DTL	PRICE_FLEX_IND	STRING	59	1/1
DTL	QTY1	FLOAT	60	1/15
DTL	QTY2	INTEGER	61	15
DTL	RATCHET_FACTOR	FLOAT	62	1/8
DTL	RATE_PERIOD_IND	STRING	63	1/2 1/2
DTL	RATE_ZONE_IND	STRING	64	1/1
DTL	SON	STRING	65	1/30
DTL	ST_LVL_CO_CODE	STRING	66	4/4
DTL	STATE	STRING	67	2/2
DTL	SUMMARY_USAGE_IND	STRING	68	1/1
DTL	TANDEM_ID	STRING	69	1/11
DTL	TERM_ADDR	STRING	70	1/90
DTL	TERM_CITY	STRING	71	1/35
DTL	TERM_COUNTRY	STRING	72	1/35
DTL	TERM_COUNTRY_CODE	STRING	73	3/4
DTL	TERM_END_DATE	DATE	74	8/8
DTL	TERM_LENGTH	INTEGER	75	1/3
DTL	TERM_PLAN_ID	STRING	76	1/35
DTL	TERM_START_DATE	DATE	77	8/8
DTL	TERM_STATE	STRING	78	2/2
DTL	TERM_TN	STRING	79	1/24
DTL	TN	STRING	80	1/24
DTL	UNIT_RATE	FLOAT	81	1/17
DTL	UNIT	STRING	82	1/2
DTL	ORIG_IP_ADDRESS	STRING	83	8/15
DTL	TERM_IP_ADDRESS	STRING	84	8/15
DTL	FTR_GRP	STRING	85	1/1
DTL	CKT_CLASS_CODE	STRING	86	1/10
DTL	CKT_CLASS_CODE_TYPE	STRING	87	1/1
DTL	FRAC_MOU_IND	STRING	88	1/1
DTL	ORIG_CITY_CODE	STRING	89	1/6
DTL	TERM_CITY_CODE	STRING	90	1/6
DTL	TRANS_RATE_ELE_IND	STRING	91	1/2
DTL	VERT_FTR_IND	STRING	92	1
DTL	SEC_NCI_CODE	STRING	93	1/12
DTL	ACCESS_SVC_GRP	STRING	94	1/11
DTL	TRANS_AMT	FLOAT	95	1/11
DTL	ACCESS_AMT	FLOAT	96	1/11
END - Detail Record (1 Occurrence per Invoice)
END	RECORD_TYPE	STRING	1	3/3	Y
END	DTL_RECORD_COUNT	INTEGER	6	1/6	Y

[0081]

DTL Record Sort Order
From Development, the XIF shall be sorted using the following order
to maximize performance:
	ACCT_NUM
	INV_CO_CODE
	INV_NUM
	BILL_DATE
	CHRG_TYPE
	USAGE_SUMMARY_IND
	PON
	SON
	TANDEM_ID
	END_OFC_ID
	EC_CIRCUIT_ID
	TN

[0082]

TLR - Detail Record (1 Occurrence per file)
			Posi-	Min/	Re-	Defini-
Record	Field Name	Data Type	tion	Max	quired	tion
TLR	RECORD_TYPE	STRING	1	3/3	Y
TLR	INV_COUNT	INTEGER	6	1/6	Y

[0083]

XIF Mapping
1.	2.
Req.	Source		4. Destination		6.
#	Record	3. Source Field	Table.Field	5. Population Rules	Message
	SUM	ACCT_NUM	BL.ban_id	Dataloader shall create a record	N/A
		INV_CO_CODE		in BAN_LIST generating a
				unique ban_id for each unique
				SUM.ACCT_NUM (compare
				against BL.ban) and
				SUM.INV_CO_CODE
				(BL.originating_company_code)
				combination not already found
				in BAN_LIST.
				If BAN is found in BL,
				DataLoader shall use the
				existing BL.ban_id.
	SUM	ACCT_NUM	BL.ban	DataLoader shall insert	N/A
				SUM.acct_num into BL.ban.
	SUM	INV_CO_CODE	BL.originating_company_code	DataLoader shall insert	N/A
				SUM.inv_co_code into
				BL.originating_company_code.
	SUM	BILL_DATE	BL.bill_period	DataLoader shall extract the day	N/A
				(DD) value from SUM.bill_date
				and insert value into
				BL.bill_period. The XIF date
				format is MM-DD-YYYY.
	SUM	ACCT_TYPE	BL.account_type	DataLoader shall insert	N/A
				SUM.acct_type into
				BL.account_type unless the
				SUM.acct_type is null. If the
				SUM.acct_type is null then
				DataLoader shall set
				BL.account_type = ‘M’.
	SUM	ICSC_CODE	BL.icsc	If SUM.icsc_code is not null,	N/A
				then DataLoader shall insert
				SUM.icsc_code in BL.icsc. If
				SUM.icsc_code is null, then
				DataLoader shall leave BL.icsc
				null.
	SUM	INV_MPB_IND	BL.mpb_ind	If SUM.inv_mpb_ind is not null,	N/A
				then DataLoader shall insert
				SUM.inv_mpb_ind in
				BL.mpb_ind. If
				SUM.inv_mpb_ind is null, then
				DataLoader shall leave
				BL.mpb_ind null.
			BL.ban_status	DataLoader shall set	N/A
				BL.ban_status = ‘NEW’.
			BL.createdby	DataLoader shall set	N/A
				BL.createdby with the system
				ID.
			BL.datecreated	DataLoader shall set	N/A
				BL.datecreated with system
				date.
			BL.dispute_ban_id	DataLoader shall set	N/A
				BL.dispute_ban_id = BL.ban_id.
	SUM	ACCT_NUM	I.invoice_seq_id	Dataloader shall create a record	Use
		INV_CO_CODE		in INVOICE generating a unique	Standard
		INV_NUM		invoice_seq_id for the unique	Duplicate
		BILL_DATE		combination of SUM.acct_num,	Invoice
				SUM.inv_co_code (DataLoader	Fatal
				shall use the SUM.acct_num	Message
				and SUM.inv_co_code to	and fail
				retrieve the BL.ban_id),	file.
				SUM.inv_num, and
				SUM.bill_date combination.
				If the ban_id, SUM.inv_num,
				and SUM.bill_date combination
				already exists in INVOICE then
				a fatal error will occur and
				DataLoader will fail the file.
			I.master_invoice_seq_id	DataLoader shall set	N/A
				I.master_invoice_seq_id = I.invoice_seq_id.
	SUM	MASTER_ACCT_NUM	I.assn_type	If SUM.master_acct_num is null,	N/A
		ACCT_NUM		then DataLoader shall set
				I.assn_type = ‘0’.
				If SUM.master_acct_num is not
				null and SUM.master_acct_num = SUM.acct_num,
				then
				DataLoader shall set
				I.assn_type = ‘1’.
				If SUM.master_acct_num is not
				null and SUM.master_acct_num
				does not equal SUM.acct_num,
				then DataLoader shall set
				I.assn_type = ‘2’.
	SUM	ACCT_NUM	I.ban_id	DataLoader shall insert the	N/A
		INV_CO_CODE		corresponding BL.ban_id into
				I.ban_id using the
				SUM.acct_num and
				SUM.inv_co_code for reference.
	SUM	INV_NUM	I.invoice	DataLoader shall insert	N/A
				SUM.inv_num into I.invoice.
	SUM	BILL_DATE	I.bill_date	DataLoader shall insert	N/A
				SUM.bill_date into I.bill_date.
	SUM	SOURCE_TYPE	I.inv_format	DataLoader shall set	N/A
				concatenate value = ‘XIF-’ to
				the SUM.source_type and insert
				the value into I.inv_format.
	HDR	VERSION	I.version	DataLoader shall insert	DataLoader
				HDR.version into I.version.	should
					use
					Code = 235/
					Name = FORMAT_VERSION_NOT_SUPPORTED
					if
					the
					version is
					no longer
					supported.
	SUM	BAL_FORWARD_AMT	I.balance_fwd	DataLoader shall insert	N/A
				SUM.bal_forward_amt into
				I.balance_fwd.
	SUM	TOT_ADJ_AMT	I.adjustments	DataLoader shall insert	N/A
				SUM.tot_adj_amt into
				I.adjustments.
	SUM	TOT_PAYMENT_AMT	I.payments	DataLoader shall insert	N/A
				SUM.tot_payment_amt into I
				payments.
	SUM	CURRENT_DUE_AMT	I.current_due	DataLoader shall insert	N/A
				SUM.current_due_amt into
				I.current_due.
	SUM	TOT_LAST_AMT	I.total_last	DataLoader shall insert	N/A
				SUM.tot_last_amt into
				I.total_last.
	SUM	TOT_DUE_AMT	I.total_due	DataLoader shall insert	N/A
				SUM.tot_due_amt into
				I.total_due.
	SUM	TOT_USG_AMT	I.usage_amt	DataLoader shall insert	N/A
				SUM.tot_usg_amt into
				I.usage_amt.
	SUM	TOT_OCC_AMT	I.occ_total_amt	DataLoader shall insert	N/A
				SUM.tot_occ_amt into
				I.occ_total_amt.
	SUM	TOT_TAX_AMT	I.taxes	DataLoader shall insert	N/A
				SUM.tot_tax_amt into
				INVOICE.taxes.
	SUM	TOT_LPC_AMT	I.late_charge	DataLoader shall insert	N/A
				SUM.tot_lpc_amt into
				I.late_charge.
	SUM	TOT_MRC_AMT	I.monthly_charge	DataLoader shall insert	N/A
				SUM.tot_mrc_amt into
				I.monthly_charge.
	SUM	TOT_REG_FEE_AMT	I.regulatory_fees	DataLoader shall insert	N/A
				SUM.tot_reg_fee_amt into
				I.regulatory_fees.
	SUM	TOT_REJECT_AMT	I.bank_reject_amt	DataLoader shall insert	N/A
				SUM.tot_reject_amt into
				I.bank_reject_amt.
	SUM	TOT_SURCHRG_AMT	I.surcharges	DataLoader shall insert	N/A
				SUM.tot_surchrg_amt into
				I.surcharges.
	SUM	MIN_DUE	I.min_due	DataLoader shall insert	N/A
				SUM.min_due into I.min_due.
	SUM	INV_FROM_DATE	I.monthly_charge_from_date	DataLoader shall insert	N/A
				SUM.inv_from_date into
				I.monthly_charge_from_date.
	SUM	INV_THRU_DATE	I.monthly_charge_thru_date	DataLoader shall insert	N/A
				SUM.inv_thru_date into
				I.monthly_charge_thru_date.
	SUM	TRANSMIT_DATE	I.transmit_date	DataLoader shall insert	N/A
				SUM.transmit_date into
				I.transmit_date.
	SUM	DUE_DATE	I.due_date	DataLoader shall insert	N/A
				SUM.due_date into I.due_date.
			I.logged_date	DataLoader shall insert the date	N/A
				of the batch is processed into
				I.logged_date.
			I.createdby	Populate I.CreatedBy with the	N/A
				Users.User_ID associated with
				the Users.Name that appears in
				VVREF.Descrip for the
				VVREF.VV_Obj_Name = ‘WORKASSIGNMENT’
				and
				VVREF.VV_Code = ‘XIF’. If a
				match is not found in the Users
				table then populate I.Createdby
				with ‘1’ (indicating System as
				the user).
	DTL	CHRG_TYPE	LD.lpc_dtl_seq_id	Dataloader shall create a record	N/A
			LD.invoice_seq_id	in LPC_DETAIL generating a
				unique lpc_dtl_seq_id for each
				record where DTL.chrg_type = ‘LPC’
				and CHRG_BILLED_AMT
				is not null or equal to zero.
				DataLoader shall insert the
				corresponding I.invoice_seq_id
				into LD.invoice_seq_id
	DTL	CHRG_FROM_DATE	LD.lpc_from_date	If not null, DataLoader shall	N/A
				insert DTL.chrg_from_date into
				LD.lpc_from_date.
	DTL	CHRG_THRU_DATE	LD.lpc_thru_date	If not null, DataLoader shall	N/A
				insert DTL.chrg_thru_date into
				LD.lpc_thru_date.
	DTL	CHRG_BILLED_AMT	LD.lpc_total	DataLoader shall insert	N/A
				DTL.chrg_billed_amt into
				LD.lpc_total.
	DTL	JURISDICTION	LD.lpc_jur_ind	If not null, DataLoader shall	N/A
				insert DTL.jurisdiction into
				LD.lpc_jur_ind. If
				DTL.jurisdiction is null
				LD.jur_ind = ‘0’.
	DTL	CHRG_DESC	LD.descrip	If not null, DataLoader shall	N/A
				insert DTL.CHRG_DESC into
				LD.descrip.
			LD.occ_adj_ind	DataLoader shall set the	N/A
				LD.occ_adj_ind = “O”.
	DTL	EC_CIRCUIT_ID	LD.ec_circuit_id	If not null, DataLoader shall	N/A
				insert DTL.ec_circuit_id into
				LD.ec_circuit_id.
			LD.strip_ec_circuit_id	DataLoader shall remove all	N/A
				spaces, periods, slashes,
				commas, and dashes from
				LD.ec_circuit_id and insert
				converted value into
				LD.strip_ec_circuit_id.
	DTL	STATE	LD.state_code	If not null, DataLoader shall	N/A
				insert DTL.state into
				LD.state_code.
	DTL	PIU	LD.lpc_piu	If not null and not greater than	N/A
				100, DataLoader shall insert
				DTL.PIU into LD.PIU otherwise
				leave null
	DTL	PLU	LD.lpc_plu	If not null and not greater than	N/A
				100, DataLoader shall insert
				DTL.PLU into LD.LPC_PLU
				otherwise leave null.
	DTL	DAYS_LATE	LD.lpc_num_days	If not null, DataLoader shall	N/A
				insert DTL.days_late into
				LD.lpc_num_days
	DTL	CHRG_BASE_AMT	LD.lpc_base_amt	If not null, DataLoader shall	N/A
				insert DTL.chrg_base_amt into
				LD.lpc_base_amt.
	DTL	CHRG_BASE_AMT	LD.amt_excluded_from_lpc	If DTL.CHRG_BASE_AMT is	N/A
		CHRG_BILLED_AMT		not null, then DataLoader shall
				calculate
				LD.amt_excluded_from_lpc
				using the following formula:
				(CHRG_BILLED_AMT − CHRG_BASE_AMT) =
				LD.amt_excluded_from_lpc.
	DTL	AUDIT_NUM	LD.audit_num	If not null, DataLoader shall	N/A
				insert DTL.audit_num into
				LD.audit_num. If value exceeds
				Databases constraints truncate
				value.
	DTL	CHRG_TYPE	OCC_TOTAL.occ_total_id	Dataloader shall consider a	N/A
		PON	OCC_TOTAL.invoice_seq_id	record eligible for insertion into
		SON		OCC_TOTAL where
		CHRG_BILLED_AMT		DTL.chrg_type = ‘FRC’ or
				‘NRC’, DTL.chrg_billed_amt is
				not null or equal to zero, and
				DTL.pon or DTL.son is not null.
				DataLoader shall generate a
				unique
				OCC_TOTAL.occ_total_id for
				eligible records using the
				DTL.pon and DTL.son
				combination to indicate a group.
				DataLoader shall insert the
				corresponding I.invoice_seq_id
				into
				OCC_TOTAL.invoice_seq_id.
	DTL	CHRG_BILLED_AMT	OCC_TOTAL.occ_billed_amt	DataLoader shall provide a sum	N/A
				of the DTL.chrg_billed_amt for
				the group and insert the value
				into
				OCC_TOTAL.occ_billed_amt.
	DTL	COMPLETION_DATE	OCC_TOTAL.completion_date	DataLoader shall insert	N/A
				DTL.completion_date into
				OCC_TOTAL.completion_date
				from the first record in the
				group.
	DTL	PON	OCC_TOTAL.purchase_order_num	If not null, DataLoader shall	N/A
				insert DTL.pon into
				OCC_TOTAL.purchase_order_num.
	DTL	SON	OCC_TOTAL.service_order_num	If not null, DataLoader shall	N/A
				insert DTL.son into
				OCC_TOTAL.service_order_num.
	DTL	ST_LVL_CO_CODE	OCC_TOTAL.state_level_company_code	If not null, DataLoader shall	N/A
				insert DTL.st_lvl_co_code into
				OCC_TOTAL.state_level_company_code
				from the first record in
				the group.
	DTL	STATE	OCC_TOTAL.state_code	If not null, DataLoader shall	N/A
				insert DTL.state into
				OCC_TOTAL.state_code from
				the first record in the group.
	DTL	CHRG_TYPE	OCC_TOTAL.occ_fractional_amt	Where DTL.chrg_typ = ‘FRC’,	N/A
		CHRG_BILLED_AMT		DataLoader shall sum
				DTL.chrg_billed_amt for the
				group and insert into
				OCC_TOTAL.occ_fractional_amt.
	DTL	CHRG_TYPE	OCC_TOTAL.occ_one_time_amt	Where DTL.chrg_typ = ‘NRC’,	N/A
		CHRG_BILLED_AMT		DataLoader shall sum
				DTL.chrg_billed_amt for the
				group and insert into
				OCC_TOTAL.occ_one_time_amt.
	DTL	CHRG_TYPE	OAD.occ_adj_dtl_id	Dataloader shall create a record	N/A
		CHRG_BILLED_AMT	OAD.invoice_seq_id	in OCC_ADJ_DTL generating a
				unique occ_adj_dtl_id for each
				record where the DTL.chrg_type = ‘FRC’,
				‘NRC’, or ‘ADJ’ and
				DTL.chrg_billed_amt is not null
				or equal to zero. If
				DTL.chrg_billed_amt is null or is
				equal to zero, then no record
				will be generated in the OAD
				table or subordinate structures
				(PDD, OACD, and JD)
				regardless of other conditions.
				DataLoader shall insert the
				corresponding l.invoice_seq_id
				into OAD.invoice_seq_id.
	DTL	CHRG_TYPE	OAD.occ_total_id	If DTL.chrg_type = ‘FRC’ or	N/A
				‘NRC’, DataLoader shall insert
				the corresponding
				OCC_TOTAL.occ_total_id into
				OAD.occ_total_id if record
				meets criteria of OCC_TOTAL
				otherwise leave null.
				If DTL.chrg_type = ‘ADJ’,
				DataLoader shall leave
				OAD.occ_total_id null.
	DTL	CHRG_TYPE	OAD.occ_adj_ind	DataLoader shall set	N/A
				OAD.occ_adj_ind = ‘A’ when
				DTL.chrg_type = ‘ADJ’.
				DataLoader shall set
				OAD.occ_adj_ind = ‘O’ when
				DTL.chrg_type = ‘FRC’ or ‘NRC’.
	DTL	CHRG_FROM_DATE	OAD.from_date	If not null, DataLoader shall	N/A
				insert DTL.chrg_from_date into
				OAD.from_date.
	DTL	CHRG_THRU_DATE	OAD.thru_date	If not null, DataLoader shall	N/A
				insert DTL.chrg_thru_date into
				OAD.thru_date.
	DTL	CHRG_BILLED_AMT	OAD.amt_total	DataLoader shall insert	N/A
				DTL.chrg_billed_amt into
				OAD.amt_total.
	DTL	QTY2	OAD.qty	DataLoader shall insert	N/A
				DTL.qty2 into OAD.qty.
	DTL	UNIT	OAD.unit	DataLoader shall insert DTL.unit	N/A
				into OAD.unit.
	DTL	CHRG_TYPE	OAD.bal_due_current_chg_ind	DataLoader shall set OAD.	N/A
				bal_due_current_chg_ind = ‘0’
				when DTL.chrg_type = ‘ADJ’.
				DataLoader shall set OAD.
				bal_due_current_chg_ind = ‘1’
				when DTL.chrg_type = ‘FRC’ or
				‘NRC’.
	DTL	CHRG_CODE	OAD.line_item_code	If not null, DataLoader shall	N/A
				insert DTL.chrg_code into
				OAD.line_item_code. If null,
				DataLoader shall set
				OAD.line_item_code = ‘UNKNOWN’.
	DTL	CHRG_DESC	OAD.line_item_code_desc	DataLoader shall insert	N/A
				DTL.chrg_desc into
				OAD.line_item_code_desc.
	DTL	CHRG_CODE_TYPE	OAD.code_type_ind	If not null, DataLoader shall	N/A
				insert DTL.chrg_code_type into
				OAD.code_type_ind.
				If null and CHRG_TYPE = ‘FRC’
				then DataLoader shall set
				OAD.code_type_ind = ‘30’.
				If null and CHRG_TYPE = ‘NRC’
				or ‘ADJ’, then DataLoader
				shall set OAD.code_type_ind = ‘29’
	DTL	INV_NUM	OAD.apply_inv	DataLoader shall insert	N/A
				DTL.inv_num into
				OAD.apply_inv.
	DTL	CHRG_TYPE	OAD.adj_date	DataLoader shall insert	N/A
		CHRG_FROM_DATE		DTL.chrg_from_date into
				OAD.adj_date when
				DTL.chrg_type = ‘ADJ’.
				DataLoader shall leave
				OAD.adj_date NULL when
				DTL.chrg_type = ‘FRC’ or ‘NRC.
	DTL	CHRG_TYPE	OAD.recurring_chg_ind	If DTL.chrg_type = ‘FRC’ then	N/A
				DataLoader shall set the
				OAD_recurring_chg_ind = ‘1’.
				If DTL.chrg_type = ‘NRC’ then
				DataLoader shall set the
				OAD.recurring_chg_ind = ‘2’.
				If DTL.chrg_type = ‘ADJ’ then
				DataLoader shall set the
				OAD.recurring_chg_ind = ‘0’.
	DTL	PIU	OAD.piu	If not null andnot greater than	N/A
				100, DataLoader shall insert
				DTL.piu into OAD.piu otherwise
				leave null.
	DTL	BIP	OAD.bip	If not null and not greater than	N/A
				100, DataLoader shall insert
				DTL.bip into OAD.bip otherwise
				leave null.
	DTL	LATA	OAD.lata	If not null, DataLoader shall	N/A
				insert DTL.lata into OAD.lata.
	DTL	STATE	OAD.st_code	If not null, DataLoader shall	N/A
				insert DTL.state into
				OAD.st_code.
	DTL	ST_LVL_CO_CODE	OAD.st_lvl_co_code	If not null, DataLoader shall	N/A
				insert DTL.st_lvl_co_code into
				OAD.st_lvl_co_code.
	DTL	UNIT_RATE	OAD.rate	If not null, DataLoader shall	N/A
				insert DTL.unit_rate into
				OAD.rate. If value exceeds the
				whole number (left of decimal),
				then DataLoader shall skip
				insert.
	DTL	AUDIT_NUM	OAD.audit_num	If not null, DataLoader shall	N/A
				insert DTL.audit_num into
				OAD.audit_num.
	DTL	TERM_PLAN_ID	PDD.plan_disc_dtl_id	Dataloader shall create a record	N/A
		TERM_START_DATE	PDD.occ_adj_dtl_id	in PLAN_DISC_DTL generating
		TERM_END_DATE		a unique plan_disc_dtl_id for
		TERM_LENGTH		each record where the
		CHRG_BASE_AMT		DTL.chrg_type = ‘FRC’, ‘NRC’,
		CHRG_DISC_AMT		or ‘ADJ’ and one or more of the
				following fields is populated for
				the record:
				DTL.term_plan_id
				DTL.term_start_date
				DTL.term_end_date
				DTL.term_length
				DTL.chrg_base_amt
				DTL.chrg_disc_amt
				DataLoader shall insert the
				corresponding
				OAD.occ_adj_dtl_id into
				PDD.occ_adj_dtl_id.
	DTL	TERM_PLAN_ID	PDD.plan_id	If not null, DataLoader shall	N/A
				insert DTL.term_plan_id into
				PDD.plan_id.
	DTL	TERM_START_DATE	PDD.term_agree_start_date	If not null, DataLoader shall	N/A
				insert DTL.term_start_date into
				PDD.term_agree_start_date
	DTL	TERM_END_DATE	PDD.term_agree_end_date	If not null, DataLoader shall	N/A
				insert DTL.term_end_date into
				PDD.term_agree_end_date.
	DTL	TERM_LENGTH	PDD.length_of_term	If not null, DataLoader shall	N/A
		TERM_START_DATE		insert DTL.term_length into
		TERM_END_DATE		PDD.length_of_term.
				If null and DTL.term_start_date
				AND DTL.term_end_date are
				populated, then DataLoader
				shall calculate the number of
				months between the
				DTL.term_start_date and
				DTL.term_end_date and insert
				the calculated value into
				PDD.length_of_term.
	DTL	CHRG_BASE_AMT	PDD.base_amt	If not null, DataLoader shall	N/A
		CHRG_DISC_AMT		insert DTL.chrg_base_amt into
		CHRG_BILLED_AMT		PDD.base_amt.
				If null and DTL.chrg_disc_amt is
				not null, then DataLoader shall
				calculate the PDD.base_amt
				using the following formula:
				(DTL.chrg_billed_amt + DTL.chrg_disc_amt) = PDD.base_amt
	DTL	CHRG_DISC_AMT	PDD.disc_amt	If not null, DataLoader shall	N/A
		CHRG_BASE_AMT		insert DTL.chrg_disc_amt into
		CHRG_BILLED_AMT		PDD.disc_amt.
				If null and DTL.chrg_base_amt
				is not null, then DataLoader
				shall calculate the
				PDD.disc_amt using the
				following formula:
				(DTL.chrg_base_amt − DTL.chrg_billed_amt) = PDD.disc_amt
			PDD.disc_pct	If the PDD.base_amt is not null,	N/A
				DataLoader shall calculate the
				PDD.disc_pct using the
				following calculation:
				(PDD.disc_amt/PDD.base_amt) = PDD.disc_pct
			JD.jur_dtl_id	Dataloader shall create a record	N/A
			JD.occ_adj_dtl_id	in JUR_DTL with a unique
				jur_dtl_id for each
				OCC_ADJ_DTL record
				generated in the invoice load.
				Upon creation of the JUR_DTL
				record, DataLoader shall insert
				the corresponding
				OAD.occ_adj_dtl_id into
				JD.occ_adj_dtl_id creating a 1:1
				relationship between
				OCC_ADJ_DTL and JUR_DTL.
	DTL	JURISDICTION	JD.jur_ind	If not null, Data Loader shall	N/A
				insert DTL.jurisiction into
				JD.jur_ind. If DTL.jurisdiction is
				null, DataLoader shall set
				JD.jur_ind = ‘0’.
	DTL	CHRG_BILLED_AMT	JD.amt	DataLoader shall insert	N/A
				DTL.chrg_billed_amt into
				JD.amt.
	DTL	RATE_ZONE_IND	JD.rate_zone_ind	DataLoader shall insert	N/A
				DTL.rate_zone_ind into
				JD.rate_zone_ind.
	DTL	CHRG_TYPETN	OACD.occ_adj_circuit_dtl_id	Dataloader shall create a record	N/A
		EC_CIRCUIT_ID	OACD.occ_adj_dtl_id	in OCC_ADJ_CIRCUIT_DTL
		IC_CIRCUIT_ID		with a unique
		END_OFC_ID		occ_adj_circuit_dtl_id for each
				OCC_ADJ_DTL record where
				the DTL.chrg_type = ‘FRC’, or
				‘NRC’ and one or more of the
				following fields is populated for
				the record:
				DTL.end_ofc_id
				DTL.ec_circuit_id
				DTL.ic_circuit_id
				DTL.tn
				DataLoader shall insert the
				corresponding
				OAD.occ_adj_dtl_id into
				OACD.occ_adj_dtl_id.
	DTL	EC_CIRCUIT_ID	OACD.circuit_heading	If DTL.ec_circuit_id is not null,	N/A
		TN	OACD.circuit_heading_ind	DataLoader shall insert
				DTL.ec_circuit_id into
				OACD.circuit_heading and set
				OACD.circuit_heading_ind = ‘CLS’.
				If DTL.ec_circuit_id is null and
				DTL.tn is not null, DataLoader
				shall insert DTL.tn into
				OACD.circuit_heading and set
				OACD.circuit_heading_ind = ‘TN’.
				Otherwise leave null.
			OACD.strip_circuit_heading	DataLoader shall remove all	N/A
				spaces, periods, slashes,
				commas, and dashes from
				OACD.circuit_heading and
				insert converted value into
				OACD.strip_circuit_heading.
	DTL	RATCHET_FACTOR	OACD.ratchet_factor	If not null, DataLoader shall	N/A
				insert DTL.ratchet_factor into
				OACD.ratchet_factor.
	DTL	MRP1	OACD.mrp1	If not null, DataLoader shall	N/A
				insert DTL.mrp1 into
				OACD.mrp1.
	DTL	MRP2	OACD.mrp2	If not null, DataLoader shall	N/A
				insert DTL.mrp2 into
				OACD.mrp2.
	DTL	MRP1_TYPE	OACD.mrp1_type	If not null, DataLoader shall	N/A
				insert DTL.mrp1_type into
				OACD.mrp1_type.
	DTL	MRP2_TYPE	OACD.mrp2_type	If not null, DataLoader shall	N/A
				insert DTL.mrp2_type into
				OACD.mrp2_type.
	DTL	STATE	OACD.rate_state	If not null, DataLoader shall	N/A
				insert DTL.state into
				OACD.rate_state.
	DTL	IC_CIRCUIT_ID	OACD.ic_circuit_id	If not null, DataLoader shall	N/A
				insert DTL.ic_circuit_id into
				OACD.ic_circuit_id.
	DTL	END_OFC_ID	OACD.group_heading	If not null. DataLoader shall	N/A
		TANDEM_ID		insert DTL.end_ofc_id into
				OACD.group_heading and set
				OACD.group_heading_ind = ‘OCL’.
				If DTL.end_ofc_id is null and
				DTL.tandem_id is not null,
				DataLoader shall insert
				DTL.tandem_id into
				OACD.group_heading and set
				OACD.group_heading_ind = ‘OCL’.
				Otherwise leave
				OACD.group_heading and
				OACD.group_heading_ind null.
	DTL	CHRG_FED_TAX_AMT	TSD.ts_detail_id	DataLoader shall create a	N/A
		CHRG_ST_LCL_TAX_AMT	TSD.invoice_seq_id	record in
		CHRG_REG_FEE_AMT		TAX_SURCHARGE_DETAIL
		CHRG_SURCHRG_AMT		generating a unique ts_detail_id
		CHRG_TYPE		only if the record meets the
		CHRG_BILLED_AMT		following rules
				DTL.chrg_type != ‘TAX’ and
				DTL.chrg_fed_tax_amt is not
				null or equal to zero.
				Or
				DTL.chrg_type != ‘TAX’ and
				DTL.chrg_st_lcl_tax_amt is not
				null or equal to zero.
				Or
				DTL.chrg_type != ‘TAX’ and
				DTL.chrg_reg_fee_amt is not
				null or equal to zero.
				Or
				DTL.chrg_type != ‘TAX’ and
				DTL.chrg_surchrg_amt is not
				null or equal to zero.
				Or
				DTL.chrg_type = ‘TAX’ and
				DTL.chrg_billed_amt is not null
				or equal to zero.
				If record has meets more than
				one of the above conditions
				DataLoader shall generate a
				unique record for each passed
				condition.
				Generate
				TAX_SURCHARGE_DETAIL
				record and insert the
				corresponding I.invoice_seq_id
				into TSD.invoice_seq_id,
	DTL	CHRG_FED_TAX_AMT	TSD.ts_rec_type	If record was generated by	N/A
		CHRG_ST_LCL_TAX_AMT		DTL.chrg_fed_tax_amt or
		CHRG_REG_FEE_AMT		DTL.chrg_st_lcl_tax_amt,
		CHRG_SURCHRG_AMT		DataLoader shall set
		CHRG_TYPE		TSD.ts_rec_type = ‘TAX’.
		CHRG_CODE_TYPE		If record was generated by
				DTL.chrg_reg_fee_amt,
				DataLoader shall set
				TSD.ts_rec_type = ‘REGULATORY’.
				If record was generated by
				DTL.chrg_surchrg_amt,
				DataLoader shall set
				TSD.ts_rec_type = ‘SURCHARGE’.
				If record was generated by
				DTL.chrg_type = ‘TAX’ and
				DTL.chrg_code_type is not null
				then, DataLoader shall insert
				the DTL.chrg_code_type into
				TSD.ts_rec_type, otherwise
				leave null.
	DTL	CHRG_TYPE	TSD.occ_adj_ind	If DTL.chrg_type = ‘FRC’ or	N/A
				‘NRC’, DataLoader shall set
				TSD.occ_adj_ind = ‘O’ (O—Omega.)
				If DTL.chrg_type = ‘ADJ’,
				DataLoader shall set
				TSD.occ_adj_ind = ‘A’.
				Otherwise leave null.
	DTL	CHRG_FED_TAX_AMT	TSD.ts_type_ind	If record was generated by	N/A
		CHRG_ST_LCL_TAX_AMT		DTL.chrg_fed_tax_amt,
		CHRG_REG_FEE_AMT		DataLoader shall set
		CHRG_SURCHRG_AMT		TSD.ts_type_ind = ‘1’.
		CHRG_TYPE		If record was generated by
		CHRG_CODE		DTL.chrg_st_lcl_tax_amt,
				DataLoader shall set
				TSD.ts_type_ind = ‘2’.
				If record was generated by
				DTL.chrg_reg_fee_amt,
				DataLoader shall set
				TSD.ts_type_ind = ‘19’.
				If record was generated by
				DTL.chrg_surchrg_amt,
				DataLoader shall set
				TSD.ts_type_ind = ‘27’.
				If record was generated by
				DTL.chrg_type = ‘TAX’ and
				DTL.chrg_code is not null then,
				DataLoader shall insert the
				DTL.chrg_code into
				TSD.ts_type_ind, otherwise
				leave null.
	DTL	CHRG_FED_TAX_AMT	TSD.ts_type_total	If record was generated by	N/A
		CHRG_ST_LCL_TAX_AMT		DTL.chrg_fed_tax_amt,
		CHRG_REG_FEE_AMT		DataLoader shall insert
		CHRG_SURCHRG_AMT		DTL.chrg_fed_tax_amt into
		CHRG_TYPE		TSD.ts_type_total.
		CHRG_BILLED_AMT		If record was generated by
				DTL.chrg_st_lcl_tax_amt,
				DataLoader shall insert
				DTL.chrg_st_lcl_tax_amt into
				TSD.ts_type_total.
				If record was generated by
				DTL.chrg_reg_fee_amt,
				DataLoader shall insert
				DTL.chrg_reg_fee_amt into
				TSD.ts_type_total.
				If record was generated by
				DTL.chrg_surchrg_amt,
				DataLoader shall insert
				DTL.chrg_surchrg_amt into
				TSD.ts_type_total.
				If record was generated by
				DTL.chrg_type = ‘TAX’ then
				DataLoader shall insert the
				DTL.chrg_billed_amt into
				TSD.ts_type_total.
	DTL	JURISDICTION	TSD.jur_ind	If not null, DataLoader shall	N/A
				insert DTL.jurisiction int
				TSD.jur_ind. If DTL.jurisdiction
				is null TSD.jur_ind = ‘0’.
	DTL	CHRG_CODE	TSD.remarks	DataLoader shall concatenate	N/A
		CHRG_DESC		DTL.chrg_code and
				DTL.chrg_desc into
				TSD.remarks using a hyphen as
				a separator.
	DTL	CHRG_FROM_DATE	TSD.from_date	If not null, DataLoader shall	N/A
				insert DTL.chrg_from_date into
				TSD.from_date.
	DTL	CHRG_THRU_DATE	TSD.thru_date	If not null, DataLoader shall	N/A
				insert DTL.chrg_thru_date into
				TSD.thru_date.
	DTL	EC_CIRCUIT_ID	TSD.ec_circuit_id	If DTL.ec_circuit_id is not null,	N/A
		TN		DataLoader shall insert
				DTL.ec_circuit_id into
				TSD.ec_circuit_id.
				If DTL.ec_circuit_id is null and
				DTL.tn is not null, DataLoader
				shall insert DTL.tn into
				TSD.ec_circuit_id.
				Otherwise leave null.
			TSD.strip_ec_circuit_id	DataLoader shall remove all	N/A
				spaces, periods, slashes,
				commas, and dashes from
				TSD.ec_circuit_id and insert
				converted value into
				TSD.strip_ec_circuit_id.
	DTL	CHRG_TYPE	TSD.other_amt_subject_to_tax	If the DTL.chrg_type = ‘MRC’,	N/A
		CHRG_BILLED_AMT	TSD.monthly_amt_subject_to_tax	then DataLoader shall insert the
			TSD.usage_amt_subject_to_tax	DTL.chrg_billed_amt into
				TSD.monthly_amt_subject_to_tax.
				If the DTL.chrg_type = ‘FRC’,
				‘NRC’, or ‘ADJ’, then
				DataLoader shall insert the
				DTL.chrg_billed_amt into
				TSD.other_amt_subject_to_tax.
				If the DTL.chrg_type = ‘USG’,
				then DataLoader shall insert the
				DTL.chrg_billed_amt into
				TSD.usage_amt_subject_to_tax.
	DTL	STATE	TSD.state_code	If not null, DataLoader shall	N/A
				insert DTL.state into
				TSD.state_code.
	DTL	ST_LVL_CO_CODE	TSD.state_level_company_code	If not null, DataLoader shall	N/A
				insert DTL.st_lvl_co_code into
				TSD.state_level_company_code.
	DTL	AUDIT_NUM	TSD.audit_num	If not null, DataLoader shall	N/A
				insert DTL.audit_num into
				TSD.audit_num.
	DTL	CHRG_TYPE	VPR.vendor_payment_rec_id	DataLoader shall create a	N/A
		CHRG_BILLED_AMT	VPR.invoice_seq_id	record in
				VENDOR_PAYMENT_RECEIVED
				generating a unique
				vendor_payment_rec_id only if
				DTL.chrg_type = ‘PAY’ and
				DTL.chrg_billed_amt is not null
				or equal to zero.
				DataLoader shall insert the
				corresponding I.invoice_seq_id
				into VPR.invoice_seq_id.
	DTL	CHRG_CODE	VPR.payment_phrase	DataLoader shall concatenate	N/A
		CHRG_DESC		DTL.chrg_code and
				DTL.chrg_desc into
				VPR.payment_phrase using a
				hyphen as a separator.
	DTL	CHRG_BILLED_AMT	VPR.received_amt	DataLoader shall insert	N/A
				DTL.chrg_billed_amt into
				VPR.received_amt.
	DTL	CHRG_FROM_DATE	VPR.payment_date	DataLoader shall insert	N/A
				DTL.chrg_from_date into
				VPR.payment_date.
	DTL	CHRG_TYPE	CA.csr_account_id	If DTL.chrg_type = ‘MRC’ for	N/A
		ACCT_NUM	CA.ban_id	any record in the invoice, then
		INV_CO_CODE		DataLoader shall create a
		INV_NUM		record in CSR_ACCOUNT
		BILL_DATE		generating a unique
				csr_account_id for the invoice.
				This action will create a
				grouping of monthly recurring
				charge records.
				Dataloader will use the
				DTL.acct_num and
				DTL.inv_co_code to insert the
				corresponding ban_id from
				BL.ban_id into CA.ban_id.
	DTL	INV_NUM	CA.invoice	DataLoader shall insert	N/A
				DTL.inv_num into CA.invoice.
	DTL	ACCT_NUM	CA.ban	DataLoader shall insert the	N/A
				value of DTL.acct_num into
				CA.ban from the grouping of
				records.
	DTL	BILL_DATE	CA.account_date	DataLoader shall insert	N/A
				DTL.bill_date into
				CA.account_date.
			CA.final_csr_ind	DataLoader shall set	N/A
				CA.final_csr_ind = ‘0’.
	HDR	VERSION	CA.version	DataLoader shall insert	N/A
				HDR.version into CA.version.
	SUM	ACCT_TYPE	CA.account_type	DataLoader shall insert	N/A
				SUM.acct_type into
				CA.account_type unless the
				SUM.acct_type is null. If the
				SUM.acct_type is null then
				DataLoader shall use CA.ban_id
				to retrieve the BL.account_type
				from BAN_LIST. DataLoader
				shall insert BL.account_type into
				CA.account_type.
	DTL	BILL_DATE	CA.bill_date	DataLoader shall insert the	N/A
				DTL.bill_date into CA.bill_date.
	DTL	LATA	CA.lata_code	DataLoader shall insert the	N/A
				DTL.lata into CA.lata_code.
	DTL	CHRG_TYPE	AO.asg_ocl_id	Dataloader shall create a record	N/A
		TANDEM_ID	AO.csr_account_id	in ASG_OCL with a unique
		END_OFC_ID		asg_ocl_seq_id for each unique
		ACCESS_SVC_GRP		combination of
				AO.access_service_group and
				AO.ocl_location where
				DTL.chrg_type = ‘MRC’.
				DataLoader shall insert the
				corresponding
				CA.csr_account_id into
				ASG_OCL.csr_account_id
	DTL	CKT_SRV_EST_DATE	AO.service_est_date	If not null, DataLoader shall	N/A
				insert DTL.ckt_srv_est_date into
				AO.service_est_date.
	DTL	END_OFC_ID	AO.ocl_location	If not null. DataLoader shall	N/A
		TANDEM_ID		insert DTL.end_ofc_id into
				AO.ocl_location.
				If DTL.end_ofc_id is null and
				DTL.tandem_id is not null,
				DataLoader shall insert
				DTL.tandem_id into
				AO.ocl_location.
	DTL	CHRG_TYPE	CCL.csr_circuit_listing_id	If the DTL.chrg_type = ‘MRC’,	N/A
		EC_CIRCUIT_ID	CCL.csr_account_id	Dataloader shall create a unique
		TN		record in
				CSR_CIRCUIT_LISTING
				generating a unique
				CCL.csr_circuit_listing_id for
				each unique DTL.ec_circuit_id
				or DTL.tn. DataLoader shall not
				generate a group where both
				DTL.ec_circuit_id and DTL.tn
				are null.
				DataLoader shall insert the
				corresponding
				CA.csr_account_id into
				CCL.csr_account_id.
	DTL	END_OFC_ID	CCL.asg_ocl_seq_id	If DTL.end_ofc_id is not null,	N/A
		TANDEM_ID		then DataLoader shall retrieve
				the ASG_OCL.asg_ocl_seq_id
				using the DTL.end_ofc_id for
				the CSR_ACCOUNT and insert
				into CCL.asg_ocl_seq_id.
				If DTL.end_ofc_id is null and
				DTL.tandem_id is not null, then
				DataLoader shall retrieve the
				ASG_OCL.asg_ocl_seq_id
				using the DTL.tandem_id for the
				CSR_ACCOUNT and insert into
				CCL.asg_ocl_seq_id.
				If both DTL.end_ofc_id and
				DTL.tandem_id are null then
				DataLoader shall leave
				CCL.asg_ocl_seq_id null.
	DTL	EC_CIRCUIT_ID	CCL.ec_circuit_id	If DTL.ec_circuit_id is not null,	N/A
		TN	CCL.circuit_format_desc	DataLoader shall insert
				DTL.ec_circuit_id into
				CCL.ec_circuit_id and set
				CCL.circuit_format_desc = ‘CLS’.
				If DTL.ec_circuit_id is null and
				DTL.tn is not null, DataLoader
				shall insert DTL.tn into
				CCL.ec_circuit_id and set
				CCL.circuit_format_desc = ‘TN’.
			CCL.strip_ec_circuit_id	DataLoader shall remove all	N/A
				spaces, periods, slashes,
				commas, and dashes from
				CCL.ec_circuit_id and insert
				converted value into
				CCL.strip_ec_circuit_id
			CCL.total_billed_amt	DataLoader shall sum LIJD_amt	N/A
				related to the CCL record.
	DTL	CKT_SRV_EST_DATE	CCL.svc_est_date	DataLoader shall insert	N/A
				DTL.ckt_srv_est_date into
				CCL.svc_est_date from the first
				record in the group.
	DTL	PON	CCL.pon	If not null, DataLoader shall	N/A
				insert DTL.pon into CCL.pon
				from the first record in the
				group.
	DTL	SON	CCL.son	If not null, DataLoader shall	N/A
				insert DTL.son into CCL.son
				from the first record in the
				group.
	DTL	NC_CODE	CCL.nc_code	If not null, DataLoader shall	N/A
				insert DTL.nc_code into
				CCL.nc_code from the first
				record in the group.
	DTL	PIU	CCL.piu	If not null and not greater than	N/A
				100, DataLoader shall insert
				DTL.piu into CCL.piu from the
				first record in the group.
				Otherwise leave null.
	DTL	CHRG_MPB_IND	CCL.mpb_ind	If not null, DataLoader shall	N/A
				insert DTL.chrg_mpb_ind into
				CCL.mpb_ind from the first
				record in the group.
	DTL	TERM_PLAN_ID	CCL.plan_id	If not null, DataLoader shall	N/A
				insert DTL.term_plan_id into
				CCL.plan_id from the first
				record in the group.
	DTL	TERM_START_DATE	CCL.term_agree_start_date	If not null, DataLoader shall	N/A
				insert DTL.term_start_date into
				CCL.term_agree_start_date
				from the first record in the group
	DTL	TERM_END_DATE	CCL.term_agree_end_date	If not null, DataLoader shall	N/A
				insert DTL.term_end_date into
				CCL.term_agree_end_date from
				the first record in the group.
	DTL	TERM_LENGTH	CCL.length_of_term	If not null, DataLoader shall	N/A
				insert DTL.term_length into
				CCL.length_of_term from the
				first record in the group.
				If null and DTL.term_start_date
				AND DTL.term_end_date are
				populated, then DataLoader
				shall calculate the number of
				months between the
				DTL.term_start_date and
				DTL.term_end_date and insert
				the calculated value into
				CCL.length_of_term.
	DTL	MRP1	CCL.mrp1	If not null, DataLoader shall	N/A
				insert DTL.mrp1 into CCL.mrp1
				from the first record in the
				group.
	DTL	MRP2	CCL.mrp2	If not null, DataLoader shall	N/A
				insert DTL.mrp2 into CCL.mrp2
				from the first record in the
				group.
	DTL	MRP1_TYPE	CCL.mrp1_type	If not null, DataLoader shall	N/A
				insert DTL.mrp1_type into
				CCL.mrp1_type from the first
				record in the group.
	DTL	MRP2_TYPE	CCL.mrp2_type	If not null, DataLoader shall	N/A
				insert DTL.mrp2_type into
				CCL.mrp2_type from the first
				record in the group.
	DTL	CFA	CCL.cfa	If not null, DataLoader shall	N/A
				insert DTL.cfa into CCL.cfa from
				the first record in the group.
	DTL	CHRG_TYPE	CL.circuit_loc_id	Then Dataloader shall create a	N/A
		ORIG_ADDR	CL.csr_circuit_listing_id	record in CIRCUIT_LOC
		ORIG_CITY		generating a unique
		ORIG_STATE		circuit_loc_id where the
		TERM_ADDR		following conditions are met for
		TERM_CITY		the CCL group:
		TERM_STATE		DTL.chrg_type = ‘MRC’
		NCI_CODE		AND
		SEC_NCI_CODE		DTL.orig_addr or
				DTL.orig_city or
				DTL.orig_state or
				DTL.nci_code are not
				null.
				-OR-
				DTL.chrg_type = ‘MRC’
				AND
				DTL.term_addr or
				DTL.term_city or
				DTL.term_state or
				DTL.sec_nci_code
				are not null.
				DataLoader shall
				insert the
				corresponding
				CCL.csr_circuit_listing_id
				into
				CL.csr_circuit_listing_id.
				Note: If both conditions are met
				then DataLoader shall generate
				(2) CIRCUIT_LOC records for
				invoices coming from XTrak as
				this information is the same in
				all records for the circuit, but in
				the event that other vendors use
				XIF to import invoices into BTP,
				this may yield more
				combinations.
			CL.circuit_loc	DataLoader shall increment the	N/A
				CL.circuit_loc by 1 starting with
				‘1’ for each record
				corresponding to the parent
				CCL.csr_circuit_listing_id.
	DTL	ORIG_ADDR	CL.circuit_loc_address	If record was generated by	N/A
		TERM_ADDR		DTL.orig_addr or DTL.orig_city
				or DTL.orig_state, DataLoader
				shall insert DTL.orig_addr into
				CL.circuit_loc_address.
				If record was generated by
				DTL.term_addr or DTL.term_city
				or DTL.term_state, DataLoader
				shall insert DTL.term_addr into
				CL.circuit_loc_address.
	DTL	CKT_SRV_EST_DATE	CL.svc_est_date	If not null, DataLoader shall	N/A
				insert DTL.ckt_srv_est_date into
				CL.svc_est_date.
	DTL	CUST_NAME	CL.cust_name	If not null, DataLoader shall	N/A
				insert DTL.cust_name into
				CL.cust_name
	DTL	NCI_CODE	CL.nci_code	If not null, DataLoader shall	N/A
				insert DTL.nci_code into
				CL.nci_code for the originating
				location record.
	DTL	CFA	CL.cfa	If not null, DataLoader shall	N/A
				insert DTL.cfa into CL.cfa.
	DTL	LATA	CL.lata	If not null, DataLoader shall	N/A
				insert DTL.lata into CL.lata.
	DTL	ORIG_STATE	CL.rate_state	If record was generated by	N/A
		TERM_STATE		DTL.orig_addr or DTL.orig_city
				or DTL.orig_state, DataLoader
				shall insert DTL.orig_state into
				CL.rate_state.
				If record was generated by
				DTL.term_addr or DTL.term_city
				or DTL.term_state, DataLoader
				shall insert DTL.term_state into
				CL.rate_state.
	DTL	ORIG_CITY	CL.rate_city	If record was generated by	N/A
		TERM_CITY		DTL.orig_addr or DTL.orig_city
				or DTL.orig_state, DataLoader
				shall insert DTL.orig_city into
				CL.rate_city.
				If record was generated by
				DTL.term_addr or DTL.term_city
				or DTL.term_state, DataLoader
				shall insert DTL.term_city into
				CL.rate_city.
	DTL	CHRG_TYPE	LI.line_item_id	Dataloader shall create a record	N/A
		CHRG_BILLED_AMT	LI.circuit_loc_id	in LINE_ITEM generating a
				unique line_item_id for each
				record where the DTL.chrg_type = ‘MRC’
				and the
				DTL.chrg_billed_amt is not
				NULL or not equal to zero.
				If a record was created for
				CIRCUIT_LOC, then
				DataLoader shall insert the
				corresponding CL.circuit_loc_id
				into LI.circuit_loc_id.
				Note: If both ORIG and TERM
				CIRCUIT_LOC records are
				generated the LINE_ITEM
				record will be associated with
				the ORIG Location.
				If a record was not created for
				CIRCUIT_LOC, then
				DataLoader shall leave
				LI.circuit_loc_id null.
	DTL	CHRG_CODE	LI.line_item_code	If not null, DataLoader shall	N/A
				insert DTL.chrg_code into
				LI.line_item_code. If null,
				DataLoader shall set
				LI.line_item_code = ‘UNKNOWN’.
	DTL	CHRG_CODE_TYPE	LI.code_type_ind	If not null, DataLoader shall	N/A
				DTL.chrg_code_type into
				LI.code_type_ind.
				If null DataLoader shall set
				LI.code_type_ind = ‘30’.
	DTL	CHRG_SRV_EST_DATE	LI.svc_est_date	If not null, DataLoader shall	N/A
				insert DTL.chrg_srv_est_date
				into LI.svc_est_date.
	DTL	QTY2	LI.svc_qty	DataLoader shall insert	N/A
				DTL.qty2 into LI.svc_qty.
	DTL	CHRG_DESC	LI.line_item_code_text	If not null, DataLoader shall	N/A
				insert DTL.chrg_desc into
				LI.line_item_code_text.
	DTL	EC_CIRCUIT_ID	LI.source_type	If the DTL.ec_circuit_id or	N/A
		TN	LI.source_seq_id	DTL.tn are not null, DataLoader
				shall set LI.source_type = ‘CKT’
				and insert
				CCL.csr_circuit_listing_id into
				LI.source_seq_id.
				If the DTL.ec_circuit_id and
				DTL.tn are null, DataLoader
				shall set LI.source_type = ‘ACCT’
				and insert
				CA.csr_account_id into
				LI.source_seq_id.
	DTL	TERM_PLAN_ID	LI.plan_id	If not null, DataLoader shall	N/A
				insert DTL.term_plan_id into
				LI.plan_id.
	DTL	TERM_START_DATE	LI.term_agree_start_date	If not null, DataLoader shall	N/A
				insert DTL.term_start_date into
				LI.term_agree_start_date
	DTL	TERM_END_DATE	LI.term_agree_end_date	If not null, DataLoader shall	N/A
				insert DTL.term_end_date into
				LI.term_agree_end_date.
	DTL	TERM_LENGTH	LI.length_of_term	If not null, DataLoader shall	N/A
				insert DTL.term_length into
				LI.length_of_term.
				If null and DTL.term_start_date
				AND DTL.term_end_date are
				populated, then DataLoader
				shall calculate the number of
				months between the
				DTL.term_start_date and
				DTL.term_end_date and insert
				the calculated value into
				LI.length_of_term.
	DTL	PIC	LI.pic	If not null, DataLoader shall	N/A
				insert DTL.pic into LI.pic.
	DTL	LPIC	LI.lpic	If not null, DataLoader shall	N/A
				insert DTL.lpic into LI.lpic
	DTL	TN	LI.wtn	If not null, DataLoader shall	N/A
				insert DTL.tn into LI.wtn.
	DTL	CHRG_TYPE	LID.line_item_dtl_id	Dataloader shall create a record	N/A
		CHRG_BILLED_AMT	LID.line_item_id	in LINE_ITEM_DETAIL
				generating a unique
				line_item_dtl_id for each record
				where the DTL.chrg_type = ‘MRC’
				and the
				DTL.chrg_billed_amt is not
				NULL or not equal to zero.
				DataLoader shall insert the
				corresponding LI.line_item_id
				into LID.line_item_id.
	DTL	QTY2	LID.line_item_code_qty	DataLoader shall insert	N/A
				DTL.qty2 into
				LID.line_item_code_qty.
	DTL	BIP	LID.bip	If not null, DataLoader shall	N/A
				insert DTL.bip into LID.bip.
	DTL	RATCHET_FACTOR	LID.ratchet_factor	If not null, DataLoader shall	N/A
				insert DTL.ratchet_factor into
				LID.ratchet_factor.
	DTL	STATE	LID.state_code	If not null, DataLoader shall	N/A
				insert DTL.state into
				LID.state_code.
	DTL	ST_LVL_CO_CODE	LID.st_lvl_co_code	If not null, DataLoader shall	N/A
				insert DTL.st_lvl_co_code into
				LID.st_lvl_co_code.
	DTL	MILEAGE	LID.line_item_code_qty_2	If no null, DataLoader shall	N/A
				insert DTL.mileage into
				LID.line_item_code_qty_2.
	DTL	MILEAGE	LID.line_item_code_rate_type_2	If DTL.mileage is not null,	N/A
				DataLoader shall set
				LID.line_item_code_rate_type_2 = ‘M’.
	DTL	CHRG_TYPE	LIJD.line_item_jur_dtl_id	Dataloader shall create a record	N/A
		CHRG_BILLED_AMT	LIJD.line_item_dtl_id	in LINE_ITEM_JUR_DTL
				generating a unique
				line_item_jur_dtl_id for each
				record where the DTL.chrg_type = ‘MRC’
				and the
				DTL.chrg_billed_amt is not
				NULL or not equal to zero.
				DataLoader shall insert the
				corresponding LID.line_item_id
				into LIJD.line_item_jur_id.
	DTL	JURISDICTION	LIJD.jur_ind	If not null, DataLoader shall	N/A
				insert DTL.jurisiction int
				LIJD.jur_ind. If DTL.jurisdiction
				is null LIJD.jur_ind = ‘0’.
	DTL	CHRG_BILLED_AMT	LIJD.amt	DataLoader shall insert	N/A
				DTL.chrg_billed_amt into
				LIJD.amt.
	DTL	RATE_ZONE_IND	LIJD.rate_zone_ind	If not null, DataLoader shall	N/A
				insert DTL.rate_zone_ind into
				LIJD.rate_zone_ind.
	DTL	UNIT_RATE	LIJD.unit_rate	If not null, DataLoader shall	N/A
				insert DTL.unit_rate into
				LIJD.unit_rate. If DTLunit_rate
				exceeds the length following the
				decimal, then DataLoader shall
				round the value to meet
				database constraints. If
				DTL.unit_rate exceeds whole
				number allowed by the
				database (to the left of the
				decimal) then DataLoader shall
				skip inserting value.
	DTL	CHRG_DISC_AMT	LIJD.disc_amt	If not null, DataLoader shall	N/A
				insert DTL.chrg_disc_amt into
				LIJD.disc_amt.
	DTL	PRICE_FLEX_IND	LIJD.pricing_flex_ind	If not null, DataLoader shall	N/A
				insert DTL.price_flex_ind into
				LIJD.pricing_flex_ind
	DTL	CHRG_TYPE	RED.rate_ele_dtl_id	Dataloader shall create a record	N/A
		SUMMARY_USAGE_IND	RED.invoice_seq_id	in RATE_ELE_DTL generating
		CHRG_BILLED_AMT		a unique rate_ele_dtl_id for
				each record where the
				DTL.chrg_type = ‘USG’ and
				DTL.summary_usage_ind = ‘0’
				or is null and
				DTL.chrg_billed_amt is not null
				or equal to zero.
				DataLoader shall insert the
				corresponding I.invoice_seq_id
				into RED.invoice_seq_id.
	DTL	CHRG_BILLED_AMT	RED.rate_ele_dtl_id	Dataloader shall create a record in	N/A
		CHRG_TYPE	RED.invoice_seq_id	RATE_ELE_DTL generating a
		SUMMARY_USAGE_IND		unique rate_ele_dtl_id for each
		TN		group of records where the
		UNIT		DTL.chrg_type = ‘USG’ and
		CHRG_CODE		DTL.summary_usage_ind = ‘1’ and
		CHRG_CODE_TYPE		the sum of DTL.chrg_billed_amt is
		JURISDICTION		not null or equal to zero. DataLoader
		DIRECTIONALITY_IND		shall group by the following fields
		END_OFC_ID		when the DTL.summary_usage_ind = ‘1’:
		TANDEM_ID		DTL.TN
		LATA		DTL.UNIT
		STATE		DTL.CHRG_CODE
		CIC		DTL.CHRG_CODE_TYPE
		ST_LVL_CO_CODE		DTL.JURISDICTION
		ORIG_COUNTRY_CODE		DTL.DIRECTIONALITY_IND
		TERM_COUNTRY_CODE		DTL.END_OFC_ID
		RATE_PERIOD_IND		DTL.TANDEM_ID
		RATE_ZONE_IND		DTL.LATA
		BIP		DTL.STATE
		MRP1		DTL.CIC
		MRP2		DTL.ST_LVL_CO_CODE
		MRP1_TYPE		DTL.ORIG_COUNTRY_CODE
		MRP2_TYPE		DTL.TERM_COUNTRY_CODE
		CELL_USG_IND		DTL.RATE_PERIOD_IND
		NPA_NXX		DTL.RATE_ZONE_IND
		PIU		DTL.BIP
		MSG_RATE_CLASS		DTL.MRP1
		MILEAGE_UNIT		DTL.MRP2
		FTR_GRP		DTL.MRP1_TYPE
				DTL.MRP2_TYPE
				DTL.CELL_USG_IND
				DTL.NPA_NXX
				DTL.PIU
				DTL.MSG_RATE_CLASS,
				DTL.VERT_FTR_IND,
				DTL.TRANS_RATE_ELE_IND, DTL.MILEAGE_UNIT,
				DTL.FTR_GRP, ORIG_CITY_CODE,
				TERM_CITY_CODE
				DataLoader shall insert the
				corresponding I.invoice_seq_id into
				RED.invoice_seq_id.
	DTL	TN	RED.tn	DataLoader shall populate the	N/A
				DTL.tn for the group into
				RED.tn.
	DTL	CHRG_FROM_DATE	RED.cycle_start	DataLoader shall take the oldest	N/A
		CHRG_THRU_DATE	RED.cycle_stop	DTL.chrg_from_date for the RED
				group and insert into
				RATE_ELE_DTL.cycle_start.
				DataLoader shall take the
				newest DTL.chrg_thru_date for
				the RED group and insert in
				RATE_ELE_DTL.cycle_stop.
	DTL	CHRG_CODE	RED.element_id	DataLoader shall insert the	N/A
			RED.traffic_type_ind	DTL.chrg_code into
				RED.element_id and
				RED.traffic_type_ind.
				DataLoader shall truncate the
				DTL.chrg_code if value exceeds
				database constraint.
				If no value is retrieved, then
				DataLoader shall set
				RED.element_id = ‘UNKN’ and
				RED.traffic_type_ind = ‘UNKN’.
	DTL	CHRG_CODE_TYPE	RED.record_type	DataLoader shall insert	N/A
				DTL.chrg_code_type into
				RED.record_type. DataLoader
				shall truncate the
				DTL.chrg_code if value exceeds
				database constraint. If null,
				DataLoader shall set
				RED.record_type = ‘0’.
	DTL	JURISDICTION	RED.jur_ind	If not null, DataLoader shall	N/A
				insert DTL.jurisiction into
				RED.jur_ind. If DTL.jurisdiction
				is null RED.jur_ind = ‘0’.
	DTL	CHRG_BILLED_AMT	RED.usage_billed_amt	DataLoader shall provide a sum	N/A
				of the DTL.chrg_billed_amt from
				all CDR records contained
				within a group and the summed
				value shall be populated in the
				RED.usage_billed_amt.
	DTL	DIRECTIONALITY_IND	RED.directionality_ind	If not null, DataLoader shall	N/A
				insert DTL.directionality_ind into
				RED.directionality_ind. If null,
				DataLoader shall set
				RED.directionality = ‘0’.
	DTL	DIRECTIONALITY_IND	RED.traffic_type	If not null for the group and	N/A
				DTL.directionality_ind = ‘1’, then
				DataLoader shall set
				RED.traffic_type = ‘’ORIG’.
				If not null for the group and
				DTL.directionality_ind = ‘2’, then
				DataLoader shall set
				RED.traffic_type = ‘’TERM’.
				If null for the group or
				DTL.directionality_ind != ‘1’ or
				!= ‘2’. then DataLoader shall set
				RED.traffic_type = ‘’OTHR’.
	DTL	END_OFC_ID	RED.summary_ofc_id	If DTL.end_ofc_id is not null for	N/A
		TANDEM_OFC_ID	RED.summary_ofc_id_ind	the RED group, DataLoader
				shall insert DTL.end_ofc_id into
				RED.summary_ofc_id and set
				RED.summary_ofc_id_ind = ‘0’.
				If DTL.end_ofc_id is null and
				DTL.tandem_id is not null for
				the RED group, DataLoader
				shall insert DTL.tandem_id into
				RED.summary_ofc_id and set
				RED.summary_ofc_id_ind = ‘1’.
	DTL	LATA	RED.lata	If not null for the group,	N/A
				DataLoader shall insert DTL.lata
				into RED.lata.
	DTL	STATE	RED.state_code	If not null for the group,	N/A
				DataLoader shall insert
				DTL.state into RED.state_code.
	DTL	ST_LVL_CO_CODE	RED.st_lvl_co_code	If not null for the group,	N/A
				DataLoader shall insert
				DTL.st_lvl_co_code into
				RED.st_lvl_co_code.
	DTL	CIC	RED.cic	If not null for the group,	N/A
				DataLoader shall insert DTL.cic
				into RED.cic.
	DTL	ORIG_COUNTRY_CODE	RED.country_code	If not null for the group,	N/A
		TERM_COUNTRY_CODE		DataLoader shall insert
				DTL.orig_country_code into
				RED.country_code.
				If DTL.orig_country_code is null
				and DTL.term_country_code is
				not null, then DataLoader shall
				insert DTL.term_country_code
				into RED.country_code.
				Otherwise leave null.
	DTL	UNIT_RATE	RED.usage_rate	If not null for the group,	N/A
				DataLoader shall insert
				DTL.unit_rate into
				RED.usage_rate.
	DTL	RATE_PERIOD_IND	RED.rate_period_ind	If not null for the group,	N/A
				DataLoader shall insert
				DTL.rate_period_ind into
				RED.rate_period_ind.
	DTL	RATE_ZONE_IND	RED.rate_zone_ind	If not null for the group,	N/A
				DataLoader shall insert
				DTL.rate_zone_ind into
				RED.rate_zone_ind.
	DTL	TANDEM_ID	RED.tandem_id	If not null for the group,	N/A
				DataLoader shall insert
				DTL.tandem_id into
				RED.tandem_id.
	DTL	CHRG_TYPE	DD.disc_dtl_id	Dataloader shall create a record	N/A
		CHRG_BASE_AMT	DD.rate_ele_dtl_id	in DISC_DTL generating a
		CHRG_DISC_AMT		unique disc_dtl_id for the group
				where the DTL.chrg_type = ‘USG’
				and one or more of the
				following fields is populated for
				the record:
				DTL.chrg_base_amt
				DTL.chrg_disc_amt
				DataLoader shall insert the
				corresponding
				RED.rate_ele_dtl_id into
				DD.rate_ele_dtl_id.
	DTL	CHRG_BASE_AMT	DD.base_amt	If not null for the group,	N/A
		CHRG_DISC_AMT		DataLoader shall sum
				DTL.chrg_base_amt and insert
				the calculated value into
				DD.base_amt.
				If null for the group and
				DTL.chrg_disc_amt is not null,
				then DataLoader shall calculate
				the DD.base_amt using the
				following formula:
				(SUM of DTL.chrg_billed_amt + SUM
				of DTL.chrg_disc_amt) = DD.chrg_base_amt
	DTL	CHRG_BASE_AMT	DD.disc_amt	If not null for the group,	N/A
		CHRG_DISC_AMT		DataLoader shall sum
				DTL.chrg_disc_amt and insert
				the calculated value into
				DD.disc_amt.
				If null for the group and
				DTL.chrg_base_amt is not null,
				then DataLoader shall calculate
				the DD.disc_amt using the
				following formula:
				(SUM of DTL.chrg_base_amt − SUM
				of DTL.chrg_billed_amt) = DD.disc_amt
			DD.disc_pct	If the DD.base_amt is not null,	N/A
				DataLoader shall calculate the
				DD.disc_pct using the following
				calculation:
				(DD.disc_amt/DD.base_amt) = DD.disc_pct
	DTL	BIP	MPBD.mpb_dtl_id	Dataloader shall create a record	N/A
			MPBD.rate_ele_dtl_id	in MPB_DTL generating a
				unique mpb_dtl_id for the group
				where the DTL.chrg_type = ‘USG’
				and one or more of the
				following fields is populated for
				the record:
				DTL.bip
				DataLoader shall insert the
				corresponding
				RED.rate_ele_dtl_id into
				MPBD.rate_ele_dtl_id.
	DTL	BIP	MPBD.bip	If not null for the RED group,	N/A
				DataLoader shall insert dtl.bip
				into MPBD.bip.
	DTL	MILEAGE	MD.mileage_dtl_id	Dataloader shall create a record	N/A
		MILEAGE_UNIT	MD.rate_ele_dtl_id	in MILEAGE_DTL generating a
		MRP1		unique mileage_dtl_id for the
		MRP2		group where the DTL.chrg_type = ‘USG’
		MRP1_TYPE		and one or more of the
		MRP2_TYPE		following fields is populated for
				the record:
				DTL.mileage
				DTL.mileage_unit
				DTL.mrp1
				DTL.mrp2
				DTL.mrp1_type
				DTL.mrp2_type
				DataLoader shall insert the
				corresponding
				RED.rate_ele_dtl_id into
				MD.rate_ele_dtl_id.
	DTL	MILEAGE	MD.mileage_qty	If not NULL for the group,	N/A
				DataLoader shall sum
				DTL.mileage and insert
				calculated value into
				MD.mileage_qty.
	DTL	MILEAGE_UNIT	MD.unit	If not NULL for the group,	N/A
				DataLoader shall insert
				DTL.mileage_unit into MD.unit.
	DTL	MRP1	MD.rating_point1_ofc_id	If not null for the group	N/A
				DataLoader shall insert
				DTL.mrp1 into
				MD.rating_point1_ofc_id.
	DTL	MRP2	MD.rating_point2_ofc_id	If not null for the group,	N/A
				DataLoader shall insert
				DTL.mrp2 into
				MD.rating_point2_ofc_id.
	DTL	MRP1_TYPE	MD.rating_point1_ofc_id_ind	If not null for the group,	N/A
				DataLoader shall insert
				DTL.mrp1_type into
				MD.rating_point1_ofc_id_ind.
	DTL	MRP2_TYPE	MD.rating_point2_ofc_id_ind	If not null for the group,	N/A
				DataLoader shall insert
				DTL.mrp2_type into
				MD.rating_point2_ofc_id_ind.
	DTL	CELL_USG_IND	UD.usage_dtl_id	Dataloader shall create a record	N/A
		NPA_NXX	UD.rate_ele_dtl_id	in USAGE_DTL generating a
		PIU		unique usage_dtl_id for the
				group where the DTL.chrg_type = ‘USG’
				and one or more of the
				following fields is populated for
				the record:
				DTL.cell_usg_ind
				DTL.npa_nxx
				DTL.piu
				DTL.ftr_grp
				DTL.trans_rate_ele_ind
				DTL.vert_ftr_ind
				DataLoader shall insert the
				corresponding
				RED.rate_ele_dtl_id into
				UD.rate_ele_dtl_id.
	DTL	CELL_USG_IND	UD.cellular_usage_ind	If not null for the group,	N/A
				DataLoader shall insert
				DTL.cell_usg_ind into
				UD.cellular_usage_ind.
	DTL	NPA_NXX	UD.npa_nxx	If not null for the group,	N/A
				DataLoader shall insert
				DTL.npa_nxx into UD.npa_nxx.
	DTL	PIU	UD.piu	If not null for not greater than	N/A
				100 for the group, DataLoader
				shall insert DTL.piu into UD.piu
				otherwise leave null.
	DTL	TN	LUD.local_usage_dtl_id	Dataloader shall create a record	N/A
		MSG_RATE_CLASS	LUD.rate_ele_dtl_id	in LOCAL_USAGE_DTL
				generating a unique
				local_usage_dtl_id for the group
				where the DTL.chrg_type = ‘USG’
				and one or more of the
				following fields is populated for
				the record:
				DTL.tn
				DTL.msg_rate_class
				OR
				Record(s) meet the criteria for
				loading LOCAL_CALL_DTL,
				then DataLoader must create a
				LUD record to link the LCD
				record back to RED Table.
				DataLoader shall insert the
				corresponding
				RED.rate_ele_dtl_id into
				LUD.rate_ele_dtl_id.
	DTL	TN	LUD.tn	If not null for the group, then	N/A
				DataLoader shall insert DTL.tn
				into LUD.tn.
	DTL	MSG_RATE_CLASS	LUD.msg_rate_class	If not null for the group, then	N/A
				DataLoader shall insert
				DTL.msg_rate_class into
				LUD.msg_rate_class.
	DTL	CHRG_TYPE	REQ.rate_ele_qty_id	Dataloader shall create	N/A
		QTY1	REQ.rate_ele_dtl_id	record(s) in RATE_ELE_QTY
		UNIT	REQ.qty	generating a unique
			REQ.unit	rate_ele_qtyl_id for the group
			REQ.usage_summary_ind	where the DTL.chrg_type = ‘USG’
				and the following
				conditions have been met:
				DataLoader shall sum of the
				DTL.qty1 for group and where
				the resulting sum is not null or
				equal to zero then DataLoader
				shall create a record in
				RATE_ELE_QTY generating a
				unique REQ.rate_ele_qty_id.
				Then DataLoader shall insert
				the sum of DTL.qty1 for the
				RATE_ELE_DTL group by into
				REQ.qty. DataLoader shall
				populate the corresponding
				REQ.rate_ele_dtl_id for the
				group by, populate
				REQ.usage_summary_ind
				equal to ‘1’, and insert DTL.unit
				into REQ.unit.
				DataLoader shall count the
				number of records rolled up into
				the RATE_ELE_DTL group by
				and populate the count into
				REQ.qty. On the insert into
				RATE_ELE_QTY generate a
				unique rate_ele_qty_id,
				populate the corresponding
				REQ.rate_ele_dtl_id, and
				populate Unit equal to ‘01’.
				DataLoader shall populate
				REQ.usage_summary_ind with
				‘1’, if no other record was not
				created in RATE_ELE_QTY.
				Otherwise populate
				REQ.usage_summary_ind with
				‘0’.
			US	DataLoader shall use the	N/A
				standard Usage Summary
				function for populating the
				USAGE_SUMMARY table. The
				only deviations from the
				standard will be the omission of
				the batchid and will not rely on
				USAGE_STATISTICS_DETAIL.
	DTL	CHRG_TYPE	LCD.local_call_dtl_id	Dataloader shall create a record	N/A
		CHRG_BILLED_AMT	LCD.local_usage_dtl_id	in LOCAL_CALL_DTL
		ORIG_TN		generating a unique
		TERM_TN		local_usage_dtl_id for each
		ORIG_CITY		record where the DTL.chrg_type = ‘USG’
		TERM_CITY		and one or more of the
		ORIG_STATE		following fields is populated for
		TERM_STATE		the record:
		ORIG_COUNTRY		DTL.charge_billed_amt ! = ‘0’ or
		TERM_COUNTRY		NULL.
				DTL.orig_tn
				DTL.term_tn
				DTL.orig_city
				DTL.term_city
				DTL.orig_state
				DTL.term_state
				DTL.orig_country
				DTL.term_country
				DataLoader shall insert the
				corresponding
				LUD.local_usage_dtl_id into
				LCD.local_usage_dtl_id.
				Note: If all fields listed above
				are nul except
				charge_billed_amt do not
				generate a record in the LCD.
	DTL	CHRG_FROM_DATE	LCD.call_date	If DTL.chrg_from_date is not	N/A
		CHRG_THRU_DATE		null, then DataLoader shall
				insert DTL.chrg_from_date into
				LCD.call_date.
				If DTL.chrg_from_date is null
				and DTL.chrg_thru_date is not
				null, then DataLoader shall
				insert DTL.chrg_thru_date into
				LCD.call_date.
				Otherwise leave null.
	DTL	ORIG_TN	LCD.from_tn	If not null, DataLoader shall	N/A
				insert DTL.orig_tn into
				LCD.from_tn.
	DTL	TERM_TN	LCD.to_tn	If not null, DataLoader shall	N/A
				insert DTL.term_tn into
				LCD.to_tn.
	DTL	ORIG_CITY	LCD.from_city	If not null, DataLoader shall	N/A
				insert DTL.orig_city into
				LCD.from_city.
	DTL	TERM_CITY	LCD.to_city	If not null, DataLoader shall	N/A
				insert DTL.term_city into
	DTL	ORIG_STATE	LCD.from_state	If not null, DataLoader shall	N/A
				insert DTL.orig_state into
				LCD.from_state.
	DTL	TERM_STATE	LCD.to_state	If not null, DataLoader shall	N/A
				insert DTL.term_state into
				LCD.to_state.
	DTL	ORIG_COUNTRY	LCD.from_country	If not null, DataLoader shall	N/A
				insert DTL.orig_country into
				LCD.from_country.
	DTL	TERM_COUNTRY	LCD.to_country	If not null, DataLoader shall	N/A
				insert DTL.term_country into
				LCD.to_country.
	DTL	QTY1	LCD.call_duration_mou	If DTL.unit = ‘02’ or ‘03’ and	N/A
		UNIT	LCD.call_duration_sec	DTL.frac_mou_ind is null or
		FRAC_MOU_IND		equal to zero then insert
				DTL.qty1 into
				LCD.call_duration_mou.
				If DTL.unit = ‘02’ or ‘03’ and
				DTL.frac_mou_ind = ‘1’ then
				populate whole number value
				(left of decimal) into
				LCD.Call_Duration_MOU.
				Convert fractional value (right of
				decimal) into seconds by
				multiplying fractional value × 60
				and insert converted value into
				LCD.Call_Duration_SEC.
				If DTL.unit = ‘12’ then insert
				DTL.qty1 into
				LCD.call_duration_sec
	DTL	CHRG_BILLED_AMT	LCD.call_usage_amt	DataLoader shall insert	N/A
				DTL.chrg_billed_amt into
				LCD.call_usage_amt.
	DTL	CHRG_DISC_AMT	LCD.disced_usage_amt	If not null, DataLoader shall	N/A
				insert DTL.chrg_disc_amt into
				LCD.disced_usage_amt.
			ICM	DataLoader shall use the	N/A
				standard Invoice Circuit Master
				function for populating the
				INVOICE_CIRCUIT_MASTER
				table. The only deviation from
				the standard will be the
				omission of the batchid if the
				SUM.source_type = ‘MAN’ or
				‘SCAN’
	SUM	SOURCE_TYPE	ALL.batchid	DataLoader shall store the	N/A
				invoice in DRAFT MODE if the
				SUM.source_type = ‘MAN’ or
				‘SCAN’. Otherwise, DataLoader
				shall load the invoice in
				ELECTRONIC MODE. When
				loading in DRAFT MODE the
				batchid for all populated tables
				will remain null. When loading
				in ELECTRONIC MODE the
				batchid will populated for all
				tables where data is loaded for
				the invoice.
	DTL	CHRG_TYPE	LINE_ITEM.csr_glossary_id	DataLoader shall verify that the	N/A
		CHRG_CODE_TYPE	CSR_GLOSSARY.csr_glossary_id	XIF.chrg_code exists in
		CHRG_CODE	CSR_GLOSSARY.code_type_ind	CSR_GLOSSARY where the
		CHRG_DESC	CSR_GLOSSARY.line_item_code	XIF.chrg_type = ‘MRC’ and
			CSR_GLOSSARY.line_item_code_desc	CSR_GLOSSARY.line_item_code = value
				and the
				CSR_GLOSSARY.code_type_ind = ‘30’
				where
				DTL.chrg_code_type
				is null.
				-or-
				and the
				CSR_GLOSSARY.code_type_ind = DTL.chrg_code_type
				when the field is not
				null.
				If the combination already exists
				in CSR_GLOSSARY, insert the
				csr_glossary_id into
				LINE_ITEM.csr_glossary_id.
				If the DTL.chrg_code is NULL,
				then DataLoader shall use the
				value = ‘UNKNOWN’ when
				attempting to search the
				CSR_GLOSSARY table for a
				match..
				If the combination does not
				exist, DataLoader shall generate
				a record in CSR_GLOSSARY
				creating a unique
				csr_glossary_id,
				set
				CSR_GLOSSARY.code_type_ind = ‘30’
				where
				DTL.chrg_code_type
				is null.
				-or-
				set
				CSR_GLOSSARY.code_type_ind = DTL.chrg_code_type
				when the field is not
				null.
				Then insert DTL.chrg_code into
				CSR_GLOSSARY.line_item_code
				or insert ‘UNKNOWN’ if the
				DTL.chrg_code was null, and
				insert DTL.chrg_desc into
				CSR_GLOSSARY.line_item_code_desc.
				DataLoader shall
				insert the csr_glossary_id
				generated for the new
				CSR_GLOSSARY record into
				LINE_ITEM.csr_glossary_id.
				At the end of the Invoice load	N/A
				kick off the balance entry
				procedure. Note: The
				requirements are found in SS
				TTS\Special
				Projects\Sprint\Phase II
				Development\Outstanding
				Balance Design.doc
	SUM	VENDOR_NAME	BL.remarks	If not null, DataLoader shall	N/A
				insert SUM.vendor_name into
				BL.remarks when new
				BAN_LIST records are created.
	SUM	MASTER_ACCT_NUM	SA.sub_account_id	If the SUM.master_acct_num is	N/A
		ACCT_NUM	SA.invoice_seq_id	not null and does not equal
				SUM.acct_num, then create a
				new record in SUB_ACCOUNT
				generating a unique
				SA.sub_account_id.
				DataLoader shall insert the
				corresponding I.invoice_seq_id
				for the Master Invoice into
				SA.invoice_seq_id.
	SUM	MASTER_ACCT_NUM	SA.sub_account_total	If the SUM.master_acct_num is	N/A
		ACCT_NUM		not null and does not equal
		TOT_DUE_AMT		SUM.acct_num, then insert
				SUM.tot_due_amt into
				SA.sub_account_total.
	SUM	MASTER_ACCT_NUM	SA.sub_account_num	If the SUM.master_acct_num is	N/A
		ACCT_NUM		not null and does not equal
				SUM.acct_num, then
				DataLoader shall insert
				SUM.acct_num into
				SA.sub_account_num.
	TRL	SA.sub_account_num	I.sub_account_total	If SUM.master_acct_num is not	N/A
				null and SUM.master_acct_num = SUM.acct_num,
				then
				DataLoader shall sum
				SA.sub_account_total for all
				records where the
				I.invoice_seq_id = SA.invoice_seq_id
				and insert
				the calculated value into
				I.sub_account_total. This
				operation must occur prior to re-
				calculating the I.total_due for
				the Master Invoice.
	DTL	FTR_GRP	UD.ftr_grp	If not null for the group,	N/A
				DataLoader shall insert
				DTL.ftr_grp into UD.ftr_grp.
	DTL	CKT_CLASS_CODE	CCL.class_of_circuit	If not null, DataLoader shall	N/A
				insert DTL.ckt_class_code into
				CCL.class_of_circuit from the
				first record in the group.
	DTL	CKT_CLASS_CODE_TYPE	CCL.class_of_circuit_ind	If not null, DataLoader shall	N/A
				insert DTL.ckt_class_code_type
				into CCL.class_of_circuit_ind
				from the first record in the
				group.
	DTL	ORIG_CITY_CODE	RED.intl_city_code	If not null for the group,	N/A
		TERM_CITY_CODE		DataLoader shall insert
				DTL.orig_city_code into RED.
				intl_city_code.
				If DTL. orig_city_code is null
				and DTL.term_city_code is not
				null, then DataLoader shall
				insert DTL.term_city_code into
				RED. intl_city_code.
				Otherwise leave null.
	DTL	TRANS_RATE_ELE_IND	UD.transport_rate_ele_ind	If not null for the group,	N/A
				DataLoader shall insert
				DTL.trans_rate_ele_ind into
				UD.transport_rate_ele_ind.
	DTL	VERT_FTR_IND	UD.vertical_features_ind	If not null for the group,	N/A
				DataLoader shall insert
				DTL.vert_ftr_ind into
				UD.vertical_features_ind.
	DTL	SEC_NCI_CODE	CL.nci_code	If not null, DataLoader shall	N/A
				insert DTL.sec_nci_code into
				CL.nci_code for the terminating
				location record.
	DTL	ACCESS_SVC_GRP	AO.access_service_group	If not null. DataLoader shall	N/A
				insert DTL.access_svc_grp into
				AO. access_service_group
	DTL	TRANS_AMT	RED.	DataLoader shall provide a sum	N/A
			Transport_Billed_Amt	of the DTL.trans_amt from all
				CDR records contained within a
				group and the summed value
				shall be populated in the
				RED.transport_billed_amt.
	DTL	ACCESS_AMT	RED.	DataLoader shall provide a sum	N/A
			Access_Billed_Amt	of the DTL.access_amt from all
				CDR records contained within a
				group and the summed value
				shall be populated in the
				RED.access_billed_amt.