Bookshelf Home | Contents | Index | PDF     

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

File Formats for Unbilled Detail-Level Information

Table 170 shows the file format for unbilled detail information.

Table 170. Unbilled 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
4900
Rec Type
1
4
VARCHAR2
Yes
REC_TYPE
None
None
Telco
4900
Account Number
 
2
20
VARCHAR2
Yes
COL1
EDX_RPT_UNBILLED_DETAIL _FACT
ACCOUNT_KEY
Telco
4900
Service Number
 
3
20
VARCHAR2
Yes
COL2
EDX_RPT_UNBILLED_DETAIL _FACT
SERVICE_KEY
Telco
4900
Called Date
 
4
8
DATE
Yes
COL3
EDX_RPT_UNBILLED_DETAIL _FACT
DATE_KEY
Telco
4900
Duration
 
 
5
10
VARCHAR2
Yes
COL4
EDX_RPT_UNBILLED_DETAIL _FACT
TIME_KEY
Telco
4900
Called Number
6
20
VARCHAR2
Yes
COL5
EDX_RPT_UNBILLED_DETAIL _FACT
CALLED_NUM
 
 
Telco
4900
Usage Type Code
7
50
VARCHAR2
Yes
COL6
EDX_RPT_UNBILLED_DETAIL _FACT
USAGE_TYPE_KEY
Telco
4900
Tariff Code
 
8
50
VARCHAR2
Yes
COL7
EDX_RPT_UNBILLED_DETAIL _FACT
TARIFF_KEY
Telco
4900
Usage Unit Code
9
50
VARCHAR2
Yes
COL8
EDX_RPT_UNBILLED_DETAIL _FACT
UNIT_KEY
Telco
4900
Call Type Code
 
10
50
VARCHAR2
No
COL9
EDX_RPT_UNBILLED_DETAIL _FACT
CALL_TYPE_KEY
Telco
4900
Direction Code
 
11
20
VARCHAR2
Yes
COL10
EDX_RPT_UNBILLED_DETAIL _FACT
DIRECTION_KEY
Telco
4900
Calling City, State Code
12
100
VARCHAR2
Yes
COL11
EDX_RPT_UNBILLED_DETAIL _FACT
CALLING_AREA_CD_KEY
 
 
Telco
4900
Calling Country Code
 
13
100
VARCHAR2
Yes
COL12
EDX_RPT_UNBILLED_DETAIL _FACT
CALLING_AREA_CD_KEY
 
Telco
4900
Called City, State Code
 
14
100
VARCHAR2
Yes
COL13
EDX_RPT_UNBILLED_DETAIL _FACT
CALLED_AREA_CD_KEY
 
Telco
4900
Called Country Code
15
100
VARCHAR2
Yes
COL14
EDX_RPT_UNBILLED_DETAIL _FACT
CALLED_AREA_CD_KEY
 
Telco
4900
Total Usages
 
16
16,2
NUMBER
Yes
COL15
EDX_RPT_UNBILLED_DETAIL _FACT
TOTAL_USAGE
Telco
4900
Total Charge
 
17
16,2
NUMBER
Yes
COL16
EDX_RPT_UNBILLED_DETAIL _FACT
TOTAL_CHARGE_AMT
Telco
4900
Other Charge
 
16
16,2
NUMBER
No
COL17
EDX_RPT_UNBILLED_DETAIL _FACT
OTHER_CHARGE_AMT
Telco
4900
FlexField1
17
255
VARCHAR2
No
COL18
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD1
Telco
4900
FlexField2
18
255
VARCHAR2
No
COL19
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD2
Telco
4900
FlexField3
19
255
VARCHAR2
No
COL20
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD3
Telco
4900
FlexField4
20
255
VARCHAR2
No
COL21
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD4
Telco
4900
FlexField5
21
255
VARCHAR2
No
COL22
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD5
Telco
4900
FlexField6
22
16,2
NUMBER
No
COL23
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD6
Telco
4900
FlexField7
23
16,2
NUMBER
No
COL24
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD7
Telco
4900
FlexField8
24
16,2
NUMBER
No
COL25
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD8
Telco
4900
FlexField9
25
8
DATE
No
COL26
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD9
Telco
4900
FlexField10
26
8
DATE
No
COL27
EDX_RPT_UNBILLED_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.