The Daily Log Customer Record Report is a pre-defined on-demand report that is initiated from an output to the Reporting. This report lists the count of Customer Records, Pointer Records and Template Records updated on the specified date for a given Resp Org.
To view the report:
- On the Daily Log Customer Record Report Landing page, the user can select the Entity, Resp Org, NPA, NXX Start Digit or Activity Date items from the corresponding drop down menu.
Selected Number of Rows
- As the user selects each filter, the “Selected Number of Rows” will dynamically refreshes and the number of data rows for the selected filters will be displayed (see Figure 135 Daily Log Customer Record Selected Number of Rows).
Please Note: It is recommended to limit the size of the Selected Number of Rows to 200,000 for optimal performance.
Generate Preview (10 Rows)
- By selecting the “Generate Preview (10 Rows)” button, the user can preview the first 10 rows of the report. This button will be “grayed” out and displayed with a light blue background after the first time it was selected in a session (see Figure 136 Daily Log Customer Record Preview). The preview data auto refreshes every time the user modifies the filters without the need to reselect the “Generate Preview (10 Rows)” button again.
Full Report Results
- By selecting the “Generate Full Report” button, the Results page of the full report will be displayed in another tab of the browser. The user can review or download the data on this page (see Figure 137 Daily Log Customer Record Full Report).
The user can select the Daily Log Customer Record tab at the top left corner of the page to view and modify the report again.
Figure 135 Daily Log Customer Record Selected Number of Rows
Figure 136 Daily Log Customer Record Preview
Figure 137 Daily Log Customer Record Full Report
Daily Log - Customer Record Activities Field Descriptions
The following table identifies the Daily Log - Customer Record Activities fields and their descriptions (see Table 27 Daily Log - Customer Record Activities Field Descriptions).
Table 27 Daily Log - Customer Record Activities Field Descriptions
|
Daily Log - Customer Record Activities Field Descriptions |
|
|
Field |
Description |
|
Entity |
An identifier for the Entity. |
|
Resp Org |
An identifier for the Resp Org. |
|
Login ID |
The assigned SMS/800 TFN Registry Login ID. The last 3 characters of the full Login ID. |
|
Toll-Free Number/Template |
Identifies the Toll-Free Number/Template Name on which CR activities are performed. |
|
Target Toll-Free Number/Template |
Identifies the source Toll-Free Number/Template Name in case of CR Copy, Transfer (or) Disconnect. Blank for other CR activities. |
|
Turn around used |
Indicates if TFN is used as a Destination number. “Y”: TFN is also used as a Destination number. “N”: Only POTS numbers are used as Destination numbers. |
|
SO or SF |
Service Order Type or Supplementary Form Identifier for the record. |
|
End Intercept Date |
The date the Toll-Free Number will be removed from intercept, such that the caller will no longer receive disconnected announcements. Value is displayed only for CRs that contain End Intercept Date/Referral data. |
|
Hold DD |
Indicates whether or not a hold has been placed on the due date. Possible Values:
|
|
Update Mode |
Indicates if this was a normal update, Critical Update or an Emergency Update. Shall be displayed for all activity status except CR Delete.
|
|
Activity Status |
Indicates the activity that is performed on the CR. Possible Values are:
|
|
Activity Date |
The date for the day requested. |
|
Effective Date/Time |
The Effective Date and Time of the Customer Record. Format is in date format. |
|
Last Refresh Date/Time |
Identifies the date and time the report was last refreshed. |
|
Record Count |
Display the count of records associated with the filtered data set (xxxxxxx) and the grand total of records (yyyyyyy) formatted as xxxxxxx/yyyyyyy. |
Data Source Used to Create the Report
The “RHDB_CRACTLOG” data source is used to create the Daily Log - Customer Record Activities report. The fields used from this table are:
- Resporg
- Activitydate
- Msecs
- Logonid
- Dialnbr
- Targdialnbr
- Effdate
- So_or_sf
- Billtonumber
- Endinterceptdate
- Taused
- Ddholdind
- Activitystatus
- Crparts
- Updatemode
- Extractdate
- Create_logonid
- Update_logonid
- Create_time
- Update_time
Please Note: Please refer to Chapter 15.6 Customer Record Activity Log Table (RHDB_CRACTLOG) for more information.