Service Coverage Term

This table shows the table from which fields are retrieved for the dimension:

Table	Description
tsctm120	Coverage Terms

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Company	tsctm120_compnr
Cost Covering Method	tsctm120.ccov
Cost Covering Method Filter	tsctm120.ccov
Cost Covering Method Sort	tsctm120.ccov
Coverage Line	tsctm120.nrbt
Coverage Line Type	tsctm120.cvtp
Coverage Line Type Filter	tsctm120.cvtp
Coverage Line Type Sort	tsctm120.cvtp
Coverage Percentage	tsctm120.disc
Coverage Type	tsctm120.cctp
End Date	tsctm120.endt
Number of Periods	tsctm120.nrpe
Period Unit	tsctm120.peru
Period Unit Filter	tsctm120.peru
Period Unit Sort	tsctm120.peru
Service Coverage Term	tsctm120.cfln +'*' + tsctm120.term + '*' + tsctm120.cctp + *' + tsctm120.cotp + '*' tsctm120.nrbt
Service Coverage Term Desc	tsctm120.desc
Service Coverage Term ID Desc	tsctm120.term + tsctm120.desc
Start Date	tsctm120.stdt
Term	tsctm120.term
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields