Oracle Self-Service E-Billing v6.2: File Formats for Prepaid Information

Implementation Guide for Oracle Self-Service E-Billing > ETL Input File Specifications and Data Mapping >

File Formats for Prepaid Information

Table 171 shows the file format for prepaid account information.

Table 171. Prepaid Account File Format
Record Type	Field	Pos	Max Len	Data Type	Req?	Staging Table (STG_CDR) Column Name	DB_TABLE_NAME	DB_COLUMN_NAME	Industry Application
9000	Rec Type	1	4	VARCHAR2	Yes	None	None	None	Telco
9000	Account Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_PREPAY_ACCOUNT_FACT	ACCOUNT_KEY	Telco
9000	Month Charge Amt	3	16,2	NUMBER	Yes	COL2	EDX_RPT_PREPAY_ACCOUNT_FACT	MONTHLY_CHARGE_AMT	Telco
9000	Usage Amt	4	16,2	NUMBER	No	COL3	EDX_RPT_PREPAY_ACCOUNT_FACT	USAGE_CHARGE_AMT	Telco
9000	Adjustment Amt	5	16,2	NUMBER	No	COL4	EDX_RPT_PREPAY_ACCOUNT_FACT	ADJUST_AMT	Telco
9000	Other Charges Amt	6	16,2	NUMBER	No	COL5	EDX_RPT_PREPAY_ACCOUNT_FACT	OTHER_CHARGE_AMT	Telco
9000	Taxes and Fees	7	16,2	NUMBER	No	COL6	EDX_RPT_PREPAY_ACCOUNT_FACT	TAXES_SURCHARGES_FEE	Telco
9000	Total Charge Amt	8	16,2	NUMBER	Yes	COL7	EDX_RPT_PREPAY_ACCOUNT_FACT	TOTAL_CHARGE_AMT	Telco
9000	Top Off Date	9	8	DATE	Yes	COL8	EDX_RPT_PREPAY_ACCOUNT_FACT	TOP_OFF_DATE	Telco
9000	Expiry Date	10	8	DATE	Yes	COL9	EDX_RPT_PREPAY_ACCOUNT_FACT	EXPIRY_DATE	Telco
9000	FlexField1	17	225	VARCHAR2	No	COL10	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD1	Telco
9000	FlexField2	18	225	VARCHAR2	No	COL11	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD2	Telco
9000	FlexField3	19	225	VARCHAR2	No	COL12	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD3	Telco
9000	FlexField4	20	225	VARCHAR2	No	COL13	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD4	Telco
9000	FlexField5	21	225	VARCHAR2	No	COL14	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD5	Telco
9000	FlexField6	22	16,2	NUMBER	No	COL15	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD6	Telco
9000	FlexField7	23	16,2	NUMBER	No	COL16	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD7	Telco
9000	FlexField8	24	16,2	NUMBER	No	COL17	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD8	Telco
9000	FlexField9	25	8	DATE	No	COL18	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD9	Telco
9000	FlexField10	26	8	DATE	No	COL19	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD10	Telco

Table 172 shows the file format for prepaid product information. This table stores charges for a product and plan.

Table 172. Prepaid Product File Format
Record Type	Field	Pos	Max Len	Data Type	Req?	Staging Table (STG_CDR) Column Name	DB_TABLE_NAME	DB_COLUMN_NAME	Industry Application
9200	Rec Type	1	4	VARCHAR2	Yes	REC_TYPE	None	None	Telco
9200	Account Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_PREPAY_PRODUCT_FACT	ACCOUNT_KEY	Telco
9200	Service Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_PREPAY_PRODUCT_FACT	SERVICE_KEY	Telco
9200	Plan Type Code	4	50	VARCHAR2	Yes	COL3	EDX_RPT_PREPAY_PRODUCT_FACT	PLAN_TYPE_KEY	Telco
9200	Product Code	5	50	VARCHAR2	Yes	COL4	EDX_RPT_PREPAY_PRODUCT_FACT	PRODUCT_PARENT _KEY	Telco
9200	Monthly Charge Amount	6	16,2	NUMBER	Yes	COL5	EDX_RPT_PREPAY_PRODUCT_FACT	CHARGE_AMT	Telco
9200	Product Sub Code	7	50	VARCHAR2	Yes	COL6	EDX_RPT_PREPAY_PRODUCT_FACT	PRODUCT_CHILD _KEY	Telco
9200	Transaction Date	8	8	DATE	Yes	COL7	EDX_RPT_PREPAY_PRODUCT_FACT	TRANS_DT	Telco

Table 173 shows the file format for prepay detail information. This file contains details for each transaction performed by a user.

Table 173. Prepaid Detail File Format
Record Type	Field	Pos	Max Len	Data Type	Req?	Staging Table (STG_CDR) Column Name	DB_TABLE_NAME	DB_COLUMN_NAME	Industry Application
9500	Rec Type	1	4	VARCHAR2	Yes	REC_TYPE	None	None	Telco
9500	Account Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_PREPAY_DETAIL_FACT	ACCOUNT_KEY	Telco
9500	Service Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_PREPAY_DETAIL_FACT	SERVICE_KEY	Telco
9500	Transaction Date	4	8	DATE	Yes	COL3	EDX_RPT_PREPAY_DETAIL_FACT	TRANS_DT	Telco
9500	Called Number	6	20	VARCHAR2	Yes	COL4	EDX_RPT_PREPAY_DETAIL_FACT	CALLED_NUM	Telco
9500	Usage Type Code	7	50	VARCHAR2	Yes	COL5	EDX_RPT_PREPAY_DETAIL_FACT	USAGE_TYPE_KEY	Telco
9500	Tariff Code	8	50	VARCHAR2	Yes	COL6	EDX_RPT_PREPAY_DETAIL_FACT	TARIFF_KEY	Telco
9500	Usage Unit Code	9	50	VARCHAR2	Yes	COL7	EDX_RPT_PREPAY_DETAIL_FACT	UNIT_KEY	Telco
9500	Call Type Code	10	50	VARCHAR2	No	COL8	EDX_RPT_PREPAY_DETAIL_FACT	CALL_TYPE_KEY	Telco
9500	Direction Code	11	20	VARCHAR2	Yes	COL9	EDX_RPT_PREPAY_DETAIL_FACT	DIRECTION_KEY	Telco
9500	Calling City, State Code	12	100	VARCHAR2	Yes	COL10	EDX_RPT_PREPAY_DETAIL_FACT	CALLING_AREA_CD_KEY	Telco
9500	Calling Country Code	13	100	VARCHAR2	Yes	COL11	EDX_RPT_PREPAY_DETAIL_FACT	CALLING_AREA_CD_KEY	Telco
9500	Called City, State Code	14	100	VARCHAR2	Yes	COL12	EDX_RPT_PREPAY_DETAIL_FACT	CALLED_AREA_CD_KEY	Telco
9500	Called Country Code	15	100	VARCHAR2	Yes	COL13	EDX_RPT_PREPAY_DETAIL_FACT	CALLED_AREA_CD_KEY	Telco
9500	Total Usages	16	16,2	NUMBER	Yes	COL14	EDX_RPT_PREPAY_DETAIL_FACT	TOTAL_USAGE	Telco
9500	Total Charge	17	16,2	NUMBER	Yes	COL15	EDX_RPT_PREPAY_DETAIL_FACT	TOTAL_CHARGE_AMT	Telco
9500	Other Charge	16	16,2	NUMBER	No	COL16	EDX_RPT_PREPAY_DETAIL_FACT	OTHER_CHARGE_AMT	Telco
9500	FlexField1	17	255	VARCHAR2	No	COL17	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD1	Telco
9500	FlexField2	18	255	VARCHAR2	No	COL18	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD2	Telco
9500	FlexField3	19	255	VARCHAR2	No	COL19	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD3	Telco
9500	FlexField4	20	255	VARCHAR2	No	COL20	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD4	Telco
9500	FlexField5	21	255	VARCHAR2	No	COL21	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD5	Telco
9500	FlexField6	22	16,2	NUMBER	No	COL22	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD6	Telco
9500	FlexField7	23	16,2	NUMBER	No	COL23	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD7	Telco
9500	FlexField8	24	16,2	NUMBER	No	COL24	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD8	Telco
9500	FlexField9	25	8	DATE	No	COL25	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD9	Telco
9500	FlexField10	26	8	DATE	No	COL26	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD10	Telco

Implementation Guide for Oracle Self-Service E-Billing		Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.