Service Engineer Assignment Detail
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tssoc205 | Service Engineer Assignments |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Accept Date | tssoc205.actm |
| Actual Finish Date | tssoc205.aftm |
| Actual Start Date | tssoc205.astm |
| Actual Travel Finish Date | tssoc205.atft |
| Actual Travel Start Date | tssoc205.atst |
| Downloaded Time | tssoc205.dltm |
| Escalation Date | tssoc205.esdt |
| Job Sheet Completion Date | tssoc205.jctm |
| Last Changed Date | tssoc205.ltct |
| On Time Finish Indicator | 1 if Planned Finish Date >= Actual Finish Date, else 0 |
| On Time Start Indicator | 1 if Planned Start Date >= Actual Start Date, else 0 |
| Order Line | tssoc205.line |
| Origin | tssoc205.orgn |
| Origin Filter | tssoc205.orgn |
| Origin Sort | tssoc205.orgn |
| Pager or Phone Enabled | tssoc205.pged |
| Pager or Phone Enabled Filter | tssoc205.pged |
| Pager or Phone Enabled Sort | tssoc205.pged |
| Planned Finish Date | tssoc205.pftm |
| Planned Start Date | tssoc205.pstm |
| Planned Travel Finish Date | tssoc205.ptft |
| Planned Travel Start Date | tssoc205.ptst |
| Reject Date | tssoc205.rjtm |
| Status | tssoc205.stat |
| Status Filter | tssoc205.stat |
| Status Sort | tssoc205.stat |
| Travel Distance Unit | tsmdm000.undi |
| Use Engineer Calendar for Planning | tssoc205.uecp |
| Use Engineer Calendar for Planning Filter | tssoc205.uecp |
| Use Engineer Calendar for Planning Sort | tssoc205.uecp |