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

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

File Formats for Dimension-Level Information

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

No mappings currently exist for the EDX_RPT_CURRENCY_TYPE_DIM and EDX_RPT_COUNTRY_DIM dimension tables. If the preconfigured seed data is inadequate, then you can add additional data.

Table 138 shows the file format for payment type information.

Table 138. 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 139 shows the file format for the adjustment type information.

Table 139. 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 140 shows the file format for charge type information.

Table 140. 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 141 shows the file format for subcharge type information.

Table 141. 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 142 shows the file format for plan type information.

Table 142. 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 143 shows the file format for product and subproduct type information.

Table 143. 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 Desc	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 Desc	5	100	VARCHAR2	No	COL4	EDX_RPT_SUB _PRODUCT_DIM	SUB_PRODUCT _NAME	Telco
150	Subproduct Charges	6	16,2	NUMBER	No	COL5	EDX_RPT_SUB _PRODUCT_DIM	SUB_PRODUCT _CHARGES	Telco
150	Subproduct Unit	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	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

Table 144 shows the file format for service usage type information.

Table 144. 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

Table 145 shows the file format for tariff type information.

Table 145. 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 146 shows the file format for other type (dimension) related information.

Table 146. 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 147 shows the file format for service type information.

Table 147. 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 148 shows the file format for unit type information.

Table 148. 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 149 shows the file format for charge notes information.

Table 149. 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 150 shows the file format for direction type information.

Table 150. 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 151 shows the file format for subproduct to tariff mapping information.

Table 151. Subproduct to Tariff Mapping 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
250	Rec Type	1	4	VARCHAR2	No	REC_TYPE	None	None	Telco
250	Product Code	2	50	VARCHAR2	No	COL1	None	None	Telco
250	Subproduct Code	3	50	VARCHAR2	No	COL2	EDX_RPT_PRODUCT_RATE_MAP_DIM	SUB_PRODUCT_CODE	Telco
250	Tariff Code	4	50	VARCHAR2	No	COL3	EDX_RPT_PRODUCT_RATE_MAP_DIM	TARIFF_CD	Telco

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