Service Coverage Term Line

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

Table Description
tsctm130 Traveling Terms
tsctm131 Material Terms
tsctm132 Labor Terms
tsctm135 Helpdesk Terms
tsctm136 Other Terms
tsctm139 Uptime Terms
tsmdm210 Service Item Groups

This table shows the attribute mapping for the dimension:

Attribute Mapping
Business Day Counter Solution Finish tsctm135.bsfn
Business Day Counter Solution Start tsctm135.bsls
Company For tsctm130-139: compnr
Configuration Line For tsctm130-139: cfln
Coverage Line For tsctm130-139: nrbt
Coverage Time Calendar for Helpdesk tsctm135.ccal
Coverage Time Calendar for Solution Limits tsctm135.srcl
Coverage Type For tsctm130-139: cctp
Labor Rate Code tsctm132.clrt
Labor Type tsctm132.chlt
Processed tsctm139.proc
Processed Filter tsctm139.proc
Processed Sort tsctm139.proc
Reaction Period tsctm135.rctt
Response Time tsctm135.crtc
Response Time Definition Method tsctm135.rsin
Response Time Definition Method Filter tsctm135.rsin
Response Time Definition Method Sort tsctm135.rsin
Response Time Unit tsctm135.rstu
Service Area tsctm130.csar
Service Coverage Term Line Desc tsctm135.desc, tsctm136.desc
Service Coverage Term Line ID Desc For tsctm130-139: cseq + tsctm135.desc, tsctm136.desc
Service Coverage Term Line Source tsctm130, tsctm131, tsctm132, tsctm135, tsctm136, tsctm139
Service Coverage Term Line Type Traveling for tsctm130

Material for tsctm131

Labor for tsctm132

Helpdesk for tsctm135

Other for tsctm136

Uptime for tsctm139

Service Item Group tsctm131.csgr
Solution Finish Period tsctm135.slfn
Solution Start Period tsctm135.slst
Term For tsctm130-139: term
Term is Derived from Reference Activity tsctm131.dspc, tsctm132.dspc, tsctm136.dspc
Term is Derived from Reference Activity Filter tsctm131.dspc, tsctm132.dspc, tsctm136.dspc
Term is Derived from Reference Activity Sort tsctm131.dspc, tsctm132.dspc, tsctm136.dspc
Term Line For tsctm130-139: cseq
Term Type tsctm139.cotp
Term Type Filter tsctm139.cotp
Term Type Sort tsctm139.cotp
Unknown 1 for null records, else 0
deleted 1 if deleted in LN, else 0
Customer Defined Fields Standard list of fields