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 |