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

Implementation Guide for Oracle Billing Insight > Load Input File Specifications and Data Mapping >

File Formats for Dimension-Level Information

This topic shows the file formats for dimension-level information.

Table 123 shows the file format for payment type information.

Table 123. Payment Type 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
100	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
100	Payment Type Code	2	50	VARCHAR2	No	COL1	EDX_RPT_PAYMENT_TYPE_DIM	PAYMENT_TYPE_CD	Telco and Utility
100	Payment Type Name	3	100	VARCHAR2	No	COL2	EDX_RPT_PAYMENT_TYPE_DIM	PAYMENT_TYPE_NAME	Telco and Utility

Table 124 shows the file format for the adjustment type information.

Table 124. Adjustment Type 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
110	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
110	Adjustment Type Code	2	50	VARCHAR2	No	COL1	EDX_RPT _ADJUSTMENT_TYPE_DIM	ADJUSTMENT_TYPE _CD	Telco and Utility
110	Adjustment Type Name	3	100	VARCHAR2	No	COL2	EDX_RPT _ADJUSTMENT_TYPE_DIM	ADJUSTMENT_TYPE _NAME	Telco and Utility

Table 125 shows the file format for charge type information.

Table 125. Charge Type 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
120	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
120	Charge Type Code	2	50	VARCHAR2	No	COL1	EDX_RPT_CHARGE_TYPE_DIM	CHARGE_TYPE_CD	Telco and Utility
120	Charge Type Name	3	100	VARCHAR2	No	COL2	EDX_RPT_CHARGE_TYPE_DIM	CHARGE_TYPE_NAME	Telco and Utility

Table 126 shows the file format for subcharge type information.

Table 126. Subcharge Type 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
130	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
130	Sub Charge Type Code	2	50	VARCHAR2	No	COL1	EDX_RPT_SUB _CHARGE_TYPE _DIM	SUB_CHARGE_TYPE _CD	Telco and Utility
130	Sub Charge Type Name	3	100	VARCHAR2	No	COL2	EDX_RPT_SUB _CHARGE_TYPE _DIM	SUB_CHARGE_TYPE _NAME	Telco and Utility

Table 127 shows the file format for plan type information.

Table 127. Plan Type 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
140	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco
140	Plan Type Code	2	50	VARCHAR2	No	COL1	EDX_RPT_PLAN _TYPE_DIM	PLAN_TYPE_CD	Telco
140	Plan Type Name	3	100	VARCHAR2	No	COL2	EDX_RPT_PLAN _TYPE_DIM	PLAN_TYPE_NAME	Telco

Table 128 shows the file format for product and subproduct type information.

Table 128. Product and Subproduct Type 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
150	Rec Type	1	4	VARCHAR2	No	REC_TYPE	None	None	Telco
150	Product Code	2	50	VARCHAR2	No	COL1	EDX_RPT_PRODUCT _DIM	PRODUCT_CD	Telco
150	Product Name	3	100	VARCHAR2	No	COL2	EDX_RPT_PRODUCT _DIM	PRODUCT_NAME	Telco
150	Subproduct Code	4	50	VARCHAR2	No	COL3	EDX_RPT_SUB _PRODUCT_DIM	SUB_PRODUCT _CD	Telco
150	Subproduct Name	5	100	VARCHAR2	No	COL4	EDX_RPT_SUB _PRODUCT_DIM	SUB_PRODUCT _NAME	Telco
150	Subproduct Usage	6	16,2	NUMBER	No	COL5	EDX_RPT_SUB _PRODUCT_DIM	SUB_PRODUCT _USAGE	Telco
150	Subproduct Unit (Not used by reporting)	7	20	VARCHAR2	No	COL6	EDX_RPT_SUB _PRODUCT_DIM	SUB_PRODUCT _UNIT	Telco
150	Product Note1	8	2000	VARCHAR2	No	COL7	EDX_RPT_PRODUCT _DIM	PRODUCT_NOTE1	Telco
150	Product Note2	9	2000	VARCHAR2	No	COL8	EDX_RPT_PRODUCT _DIM	PRODUCT_NOTE2	Telco
150	Product Note3	10	2000	VARCHAR2	No	COL9	EDX_RPT_PRODUCT _DIM	PRODUCT_NOTE3	Telco
150	Allowance Indicator (Not used by reporting)	11	1	VARCHAR2	No	COL10	EDX_RPT_SUB_ PRODUCT_DIM	ALLOWANCE_ID	Telco
150	Add on Indicator	12	1	VARCHAR2	No	COL11	EDX_RPT_PRODUCT _DIM	ADD_ON_FLAG	Telco
150	Product Description	13	500	VARCHAR2	No	COL12	EDX_RPT_PRODUCT _DIM	PRODUCT _DESC	Telco
150	Subproduct Description	14	500	VARCHAR2	No	COL13	EDX_RPT_SUB_ PRODUCT_DIM	SUB_PRODUCT _DESC	Telco

Table 129 shows the file format for service usage type information. For the Usage Type Category Key, select the Key value from the preconfigured list in the EDX_RPT_USAGE_CATEGORY_DIM table.

Table 129. Service Usage Type 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
160	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
160	Usage Type Code	2	50	VARCHAR2	No	COL1	EDX_RPT_USAGE _TYPE_DIM	USAGE_TYPE_CD	Telco and Utility
160	Usage Type Name	3	100	VARCHAR2	No	COL2	EDX_RPT_USAGE _TYPE_DIM	USAGE_TYPE_NAME	Telco and Utility
160	Usage Type Category Description	4	50	VARCHAR2	No	COL3	EDX_RPT_USAGE _TYPE_DIM	USAGE_TYPE_DESC	Telco and Utility
160	Usage Type Category Key	5	8	NUMBER	No	COL4	EDX_RPT_USAGE _TYPE_DIM	USAGE_TYPE_CATE _KEY	Telco

Table 130 shows the file format for tariff type information.

Table 130. Tariff Type 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
170	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco
170	Tariff Code	2	50	VARCHAR2	No	COL1	EDX_RPT_TARIFF _DIM	TARIFF_CD	Telco
170	Tariff Name	3	100	VARCHAR2	No	COL2	EDX_RPT_TARIFF _DIM	TARIFF_NAME	Telco

Table 131 shows the file format for other type (dimension) related information.

Table 131. Other Type (Dimension) Related 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
180	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco
180	Region Code	2	50	VARCHAR2	No	COL1	EDX_RPT_REGION_DIM	REGION_CD	Telco
180	Region Name	3	100	VARCHAR2	No	COL2	EDX_RPT_REGION_DIM	REGION_NAME	Telco
190	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco
190	Carrier Code	2	50	VARCHAR2	No	COL1	EDX_RPT_CARRIER_DIM	CARRIER_CD	Telco
190	Carrier Name	3	100	VARCHAR2	No	COL2	EDX_RPT_CARRIER_DIM	CARRIER_NAME	Telco
190	Carrier SMS Gateway	4	255	VARCHAR2	No	COL3	EDX_RPT_CARRIER_DIM	CARRIER_SMS_GATEWAY Note: The service number must be enclosed in parentheses, as in 0(Number)@Company-sms.de	Telco
190	Resource bundle Key	5	255	VARCHAR2	No	COL4	EDX_RPT_CARRIER_DIM	RESOURCE_BUNDLE_ID	Telco
200	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco
200	Calling/Called City and State	2	100	VARCHAR2	No	COL1	EDX_RPT_AREA_CD_DIM	AREA_CD	Telco
200	Calling/Called Country	3	100	VARCHAR2	No	COL2	EDX_RPT_AREA_CD_DIM	COUNTRY_CD	Telco

Table 132 shows the file format for service type information.

Table 132. Service Type 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
210	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
210	Service Type Code	2	50	VARCHAR2	No	COL1	EDX_RPT_SERVICE_TYPE_DIM	SERVICE_TYPE_CD	Telco and Utility
210	Service Type Name	3	100	VARCHAR2	No	COL2	EDX_RPT_SERVICE_TYPE_DIM	SERVICE_TYPE _NAME	Telco and Utility

Table 133 shows the file format for unit type information.

Table 133. Unit Type 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
220	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
220	Unit Code	2	50	VARCHAR2	No	COL1	EDX_RPT_UNIT _DIM	UNIT_CD	Telco and Utility
220	Unit Name	3	100	VARCHAR2	No	COL2	EDX_RPT_UNIT _DIM	UNIT_NAME	Telco and Utility

Table 134 shows the file format for charge notes information.

Table 134. Charge Notes 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
230	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Utility
230	Notes Code	2	50	VARCHAR2	No	COL1	EDX_RPT_CHARGE_ NOTES_DIM	NOTES_CD	Utility
230	Notes Name	3	100	VARCHAR2	No	COL2	EDX_RPT_CHARGE_ NOTES_DIM	NOTES_NAME	Utility

Table 135 shows the file format for direction type information.

Table 135. Direction Type 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
240	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco
240	Direction Code	2	50	VARCHAR2	No	COL1	EDX_RPT_DIRECTION_DIM	DIRECTION_CD	Telco
240	Direction Name	3	100	VARCHAR2	No	COL2	EDX_RPT_DIRECTION_DIM	DIRECTION_NAME	Telco

Table 136 shows the file format for country information.

Table 136. Country 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
260	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
260	Country Code	2	50	VARCHAR2	No	COL1	EDX_RPT_COUNTRY_DIM	COUNTRY_CD	Telco and Utility
260	Country Name	3	100	VARCHAR2	No	COL2	EDX_RPT_COUNTRY_DIM	COUNTRY_NAME	Telco and Utility
260	Country Desc	4	255	VARCHAR2	No	COL3	EDX_RPT_COUNTRY_DIM	COUNTRY_DESC	Telco and Utility

Table 137 shows the file format for currency information.

Table 137. Currency 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
270	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
270	Currency Code	2	50	VARCHAR2	No	COL1	EDX_RPT_CURRENCY_TYPE_DIM	CURRENCY_TYPE_CD	Telco and Utility
270	Currency Name	3	100	VARCHAR2	No	COL2	EDX_RPT_CURRENCY_TYPE_DIM	CURRENCY_TYPE _NAME	Telco and Utility
270	Currency Desc	4	255	VARCHAR2	No	COL3	EDX_RPT_CURRENCY_TYPE_DIM	CURRENCY_TYPE _DESC	Telco and Utility
270	Currency Type Symbol	15	30	VARCHAR2	No	COL14	EDX_RPT_CURRENCY_TYPE_DIM	CURRENCY_TYPE _SYMBOL Note: If this column is null, the currency symbol cannot display correctly for multiple languages. Instead, the currency code will appear.	Telco and Utility
270	Currency Is Default	16	1	VARCHAR2	No	COL15	EDX_RPT_CURRENCY_TYPE_DIM	CURRENCY_IS _DEFAULT	Telco and Utility

Table 138 shows the file format for time zone information.

Table 138. Time Zone 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
280	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
280	Time Zone Code	2	50	VARCHAR2	No	COL1	EDX_RPT_TIME_ ZONE_DIM	TIME_ZONE_CD	Telco and Utility
280	Time Zone Name	3	100	VARCHAR2	No	COL2	EDX_RPT_TIME_ ZONE_DIM	TIME_ZONE_NAME	Telco and Utility
280	Time Zone Desc	4	255	VARCHAR2	No	COL3	EDX_RPT_TIME_ ZONE_DIM	TIME_ZONE_DESC	Telco and Utility

Implementation Guide for Oracle Billing Insight		Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.