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, you can add additional data.

Table 136 shows the file format for payment type information.

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

Table 137. Adjustment Type
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
File Format

Table 138 shows the file format for charge type information.

Table 138. Charge Type
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
File Format

Table 139 shows the file format for sub-charge type information.

Table 139. Sub-Charge Type
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
File Format

Table 140 shows the file format for plan type information.

Table 140. Plan Type
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
File Format

Table 141 shows the file format for product and sub-product type information.

Table 141. Product and Sub-Product Type
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
3
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
File Format

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

Table 142. Service Usage Type
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
File Format

Table 143 shows the file format for tariff type information.

Table 143. Tariff Type
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
File Format

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

Table 144. Other Type (Dimension) Related Information 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 145 shows the file format for service type information.

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

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

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

Table 148. 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
Implementation Guide for Oracle Self-Service E-Billing Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.