Join home domain

This report shows the Set Top Boxes (STB) linked to JoinHomeDomain. Additionally it provides details on both the source and target device that was linked to the HomeDomain

Report columns

Column Name	Source DB field	Description
CASN	COR_DEVICE_STB_LINK.CA_SN	CASN (Serial Number) of the STB.
NUID	COR_DEVICE_STB_LINK.NUID	NUID (Nagra UID) of the STB.
Account Number	COR_ACCOUNT.ACC_NUM	Account Number to which the device belongs.
Link To CASN	COR_DEVICE_STB_LINK.LINK_TO_CA_SN	The CASN of the target device being linked.
Link To NUID	COR_DEVICE_STB_LINK.LINK_TO_NUID	The NUID of the target device being linked.
Join Date	COR_DEVICE_STB_LINK.CREATION_DATE	Date on which the device joined the Home Domain.

Input parameters for report generation

Parameter	Type	Description
Lower date threshold of report period	DateTime	Start Date for the report, including the specified value.
Upper threshold of report period	DateTime	End Date for the report, including the specified value.
Service Provider ID	String	The report can be generated only for a specific service provider.

>

Data extraction file

device_stb_join_homedomain_kettle.ktr

Query

CODE

CREATE OR REPLACE FORCE VIEW "KB_10JUL_O"."COR_DEVICE_STB_JOIN_RPT_V" ("CA_SN", "NUID", "ACC_NUM", "LINK_TO_CA_SN", "LINK_TO_NUID", "JOIN_DATE", "SPID")
                       AS
  SELECT LINK.CA_SN    AS CA_SN,
    LINK.NUID          AS NUID,
    ACC.ACC_NUM        AS ACC_NUM,
    LINK.LINK_TO_CA_SN AS LINK_TO_CA_SN,
    LINK.LINK_TO_NUID  AS LINK_TO_NUID,
    LINK.CREATION_DATE AS JOIN_DATE,
    LINK.SPID          AS SPID
  FROM COR_DEVICE_STB_LINK LINK
  LEFT OUTER JOIN COR_ACCOUNT ACC
  ON LINK.ACC_UID     =ACC.ACC_UID
  WHERE LINK.LINK_TYPE='S' ;

BIRT design template file

device-stb-join-homedomain.rptdesign

Sample report

The following image shows an example of a Join Home Domain report: