CSF — Field Service
100 documented tables · 32 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
CSF_MD_INST_STYLE_SHTS |
Defines map instance style sheets | hub-leaning |
CSF_R_SCHED_REQUESTS |
Scheduler requests. | hub-leaning |
CSF_RATING_SCALES_B |
Skill types | hub-leaning |
CSF_R_REQUEST_TASKS |
This table stores the task needs to be scheduled for a request | hub-leaning |
CSF_LF_ROADSEGMENTS |
Stores roadsegments with their navigable attributes | hub |
CSF_TDS_INTERVALS |
The intervals table | hub-leaning |
CSF_R_RESOURCE_RESULTS |
Table containing the result of the 'resoure filters' (Prefferred, Territory, Geography, Skills) | hub-leaning |
CSF_TDS_TILES |
Defines the result of spatial index creation (tiling). | hub-leaning |
CSF_SKILL_TYPES_B |
Skill types | hub-leaning |
CSF_LF_PLACES |
Contains all Administrative areas and Zones | hub-leaning |
CSF_LF_NAMES |
Stores all Name information for the Location Finder | hub-leaning |
CSF_TDS_SEGMENTS |
Defines a connection between two nodes. | hub-leaning |
CSF_DEBRIEF_HEADERS |
Field Service Report header information | satellite-leaning |
CSF_LF_POSTCODES |
Stores the Postcode information and the centroid of each Postcode area | hub-leaning |
CSF_TDS_ROADBLOCKS |
Defines a travel duration delay for a segment. | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
CSF_TASKS_PUB |
PUB | 41 | 18 packages |
CSF_DEBRIEF_PUB |
PUB | 7 | 17 packages |
CSF_RESOURCE_PUB |
PUB | 22 | 15 packages |
CSF_TASK_ASSIGNMENTS_PUB |
PUB | 4 | 10 packages |
CSF_LOCUS_PUB |
PUB | 24 | 8 packages |
CSF_ACCESS_HOURS_PUB |
PUB | 6 | 3 packages |
CSF_LF_PUB |
PUB | 4 | 3 packages |
CSF_GPS_PUB |
PUB | 7 | 3 packages |
CSF_TRIPS_PUB |
PUB | 17 | 2 packages |
CSF_ALERTS_PUB |
PUB | 22 | 1 packages |