Bookshelf Home | Contents | Index | PDF     

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

File Format for Dimension Level Information

This topic shows the file format for dimension level information.

Table 96 shows the file format for payment type information.

Table 96. Payment Type Format
RECORD TYPE
FIELD
POSITION
MAX LENGTH
DATA TYPE
REQ?
STAGING TABLE (STG_CDR) COLUMN NAME
DB_TABLE_NAME
DB_COLUMN_NAME
100
Rec Type
1
3
VARCHAR2
No
REC_TYPE
 
 
100
Payment Type Code
2
50
VARCHAR2
No
COL1
EDX_RPT_PAYMENT_TYPE_DIM
PAYMENT_TYPE_CD
100
Payment Type Name
3
100
VARCHAR2
No
COL2
EDX_RPT_PAYMENT_TYPE_DIM
PAYMENT_TYPE_NAME

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

Table 97. Adjustment Type
RECORD TYPE
FIELD
POSITION
MAX LENGTH
DATA TYPE
REQ?
STAGING TABLE (STG_CDR) COLUMN NAME
DB_TABLE_NAME
DB_COLUMN_NAME
110
Rec Type
1
3
VARCHAR2
No
REC_TYPE
 
 
110
Adjustment Type Code
2
50
VARCHAR2
No
COL1
EDX_RPT_ADJUSTMENT_TYPE_DIM
ADJUSTMENT_TYPE_CD
110
Adjustment Type Name
3
100
VARCHAR2
No
COL2
EDX_RPT_ADJUSTMENT_TYPE_DIM
ADJUSTMENT_TYPE_NAME
Format

Table 98 shows the file format for charge type information.

Table 98. Charge Type
RECORD TYPE
FIELD
POSITION
MAX LENGTH
DATA TYPE
REQ?
STAGING TABLE (STG_CDR) COLUMN NAME
DB_TABLE_NAME
DB_COLUMN_NAME
120
Rec Type
1
3
VARCHAR2
No
REC_TYPE
 
 
120
Charge Type Code
2
50
VARCHAR2
No
COL1
EDX_RPT_CHARGE_TYPE_DIM
CHARGE_TYPE_CD
120
Charge Type Name
3
100
VARCHAR2
No
COL2
EDX_RPT_CHARGE_TYPE_DIM
CHARGE_TYPE_NAME
Format

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

Table 99. Sub-Charge Type
RECORD TYPE
FIELD
POSITION
MAX LENGTH
DATA TYPE
REQ?
STAGING TABLE (STG_CDR) COLUMN NAME
DB_TABLE_NAME
DB_COLUMN_NAME
130
Rec Type
1
3
VARCHAR2
No
REC_TYPE
 
 
130
Sub Charge Type Code
2
50
VARCHAR2
No
COL1
EDX_RPT_SUB_CHARGE_TYPE_DIM
SUB_CHARGE_TYPE_CD
130
Sub Charge Type Name
3
100
VARCHAR2
No
COL2
EDX_RPT_SUB_CHARGE_TYPE_DIM
SUB_CHARGE_TYPE_NAME
Format

Table 100 shows the file format for plan type information.

Table 100. Plan Type
RECORD TYPE
FIELD
POSITION
MAX LENGTH
DATA TYPE
REQ?
STAGING TABLE (STG_CDR) COLUMN NAME
DB_TABLE_NAME
DB_COLUMN_NAME
140
Rec Type
1
3
VARCHAR2
No
REC_TYPE
 
 
140
Plan Type Code
2
50
VARCHAR2
No
COL1
EDX_RPT_PLAN_TYPE_DIM
PLAN_TYPE_CD
140
Plan Type Name
3
100
VARCHAR2
No
COL2
EDX_RPT_PLAN_TYPE_DIM
PLAN_TYPE_NAME
Format

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

Table 101. Product and Sub-Product Type
RECORD TYPE
FIELD
POSITION
MAX LENGTH
DATA TYPE
REQ?
STAGING TABLE (STG_CDR) COLUMN NAME
DB_TABLE_NAME
DB_COLUMN_NAME
150
Rec Type
1
3
VARCHAR2
No
REC_TYPE
 
 
150
Product Code
2
50
VARCHAR2
No
COL1
EDX_RPT_PRODUCT_DIM
PRODUCT_CD
150
Product Desc
3
100
VARCHAR2
No
COL2
EDX_RPT_PRODUCT_DIM
PRODUCT_NAME
150
Subproduct Code
4
50
VARCHAR2
No
COL3
EDX_RPT_SUB_PRODUCT_DIM
SUB_PRODUCT_CD
150
Subproduct Desc
5
100
VARCHAR2
No
COL4
EDX_RPT_SUB_PRODUCT_DIM
SUB_PRODUCT_NAME
150
Subproduct Charges
6
16,2
NUMBER
No
COL5
EDX_RPT_SUB_PRODUCT_DIM
SUB_PRODUCT_CHARGES
150
Subproduct Unit
7
20
VARCHAR2
No
COL6
EDX_RPT_SUB_PRODUCT_DIM
SUB_PRODUCT_UNIT
150
Product Note1
8
2000
VARCHAR2
No
COL7
EDX_RPT_PRODUCT_DIM
PRODUCT_NOTE1
150
Product Note2
9
2000
VARCHAR2
No
COL8
EDX_RPT_PRODUCT_DIM
PRODUCT_NOTE2
150
Product Note3
10
2000
VARCHAR2
No
COL9
EDX_RPT_PRODUCT_DIM
PRODUCT_NOTE3
Format

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

Table 102. Service Usage Type
RECORD TYPE
FIELD
POSITION
MAX LENGTH
DATA TYPE
REQ?
STAGING TABLE (STG_CDR) COLUMN NAME
DB_TABLE_NAME
DB_COLUMN_NAME
160
Rec Type
1
3
VARCHAR2
No
REC_TYPE
 
 
160
Usage Type Code
2
50
VARCHAR2
No
COL1
EDX_RPT_USAGE_TYPE_DIM
USAGE_TYPE_CD
160
Usage Type Name
3
100
VARCHAR2
No
COL2
EDX_RPT_USAGE_TYPE_DIM
USAGE_TYPE_NAME
Format

Table 103 shows the file format for tariff type information.

Table 103. Tariff Type
RECORD TYPE
FIELD
POSITION
MAX LENGTH
DATA TYPE
REQ?
STAGING TABLE (STG_CDR) COLUMN NAME
DB_TABLE_NAME
DB_COLUMN_NAME
170
Rec Type
1
3
VARCHAR2
No
REC_TYPE
 
 
170
Tariff Code
2
50
VARCHAR2
No
COL1
EDX_RPT_TARIFF_DIM
TARIFF_CD
170
Tariff Name
3
100
VARCHAR2
No
COL2
EDX_RPT_TARIFF_DIM
TARIFF_NAME
Format

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

Table 104. Other Type (Dimension) Related Information Format
RECORD TYPE
FIELD
POSITION
MAX LENGTH
DATA TYPE
REQ?
STAGING TABLE (STG_CDR) COLUMN NAME
DB_TABLE_NAME
DB_COLUMN_NAME
180
Rec Type
1
3
VARCHAR2
No
REC_TYPE
 
 
180
Region Code
2
50
VARCHAR2
No
COL1
EDX_RPT_REGION_DIM
REGION_CD
180
Region Name
3
100
VARCHAR2
No
COL2
EDX_RPT_REGION_DIM
REGION_NAME
190
Rec Type
1
3
VARCHAR2
No
REC_TYPE
 
 
190
Carrier Code
2
50
VARCHAR2
No
COL1
EDX_RPT_CARRIER_DIM
CARRIER_CD
190
Carrier Name
3
100
VARCHAR2
No
COL2
EDX_RPT_CARRIER_DIM
CARRIER_NAME
200
Rec Type
1
3
VARCHAR2
No
REC_TYPE
 
 
200
Calling/Called City and State
2
100
VARCHAR2
No
COL1
EDX_RPT_AREA_CD_DIM
AREA_CD
200
Calling/Called Country
3
100
VARCHAR2
No
COL2
EDX_RPT_AREA_CD_DIM
COUNTRY_CD

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