CSF Tables (100)

CSF - Field Service — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
CSF_ACCESS_HOURS_B	40
CSF_ACCESS_HOURS_TL	10
CSF_DC_QUERIES_B	15	CSF_DC_QUERIES_B contains WHERE-clauses for queries to populate the Dispatch Center with tasks
CSF_DC_QUERIES_TL	11
CSF_DEBRIEF_HEADERS	33	Field Service Report header information
CSF_DEBRIEF_LINES	86	Field Service Report lines information
CSF_ELOC_TDS_ROUTE_CACHE	31
CSF_EXT_LOCATIONS	16
CSF_GNTICONS_SETUP_B	12
CSF_GPS_DEVICES	12
CSF_GPS_DEVICE_ASSIGNMENTS	12
CSF_GPS_LOCATION_FEEDS	11
CSF_GPS_VENDORS_B	17
CSF_GPS_VENDORS_TL	10
CSF_GPS_VENDOR_STATUS_MAPS	10
CSF_LF_BLOCKS	12	Defines the available address range for a segment
CSF_LF_NAMES	13	Stores all Name information for the Location Finder
CSF_LF_PLACES	6	Contains all Administrative areas and Zones
CSF_LF_PLACE_NAMES	5	Defines relation between Place and Name
CSF_LF_PLACE_POSTCS	4	Defines relation between Place and Postcode tables
CSF_LF_POIS	12	Stores POI (points of interests) in the roadnetwork that are known by the name for LF
CSF_LF_POI_NAMES	5	Defines the relation between POI and Name tables
CSF_LF_POSTCODES	5	Stores the Postcode information and the centroid of each Postcode area
CSF_LF_ROADSEGMENTS	5	Stores roadsegments with their navigable attributes
CSF_LF_ROADSEGM_NAMES	5	Defines the relation between roadsegments and the name table
CSF_LF_ROADSEGM_PLACES	6	Defines relation between Roadsegments and Places
CSF_LF_ROADSEGM_POSTS	5	Defines relation between Roadsegment and Postcodes
CSF_L_AGENDALAYOUTS	27	Agenda Layout on the Laptop
CSF_L_QUERIES	29	List of Queries
CSF_L_QUERYREQUESTS	27	Requests for executing Queries
CSF_L_SODS	31	Service Order Description
CSF_L_SOTS	24	Service Order Types
CSF_MAP_ACCESS_HOURS_B	41
CSF_MAP_ACCESS_HOURS_TL	10
CSF_MD_ADM_BOUNDS	7	Defines an administrative boundary defined in a country.
CSF_MD_HYDROS	7	Defines a hydrographic feature.
CSF_MD_INST_STYLE_SHTS	33	Defines map instance style sheets
CSF_MD_LAND_USES	7	Defines the geometry of various land usages
CSF_MD_LYR_METADATA	21	Defines map display layer metadata
CSF_MD_LYR_STYLE_SHTS	7	Defines the visual display characteristics of a map layer
CSF_MD_NAMES	12	Defines the name of the given geographic entities in the model.
CSF_MD_OM_ADMINS	5
CSF_MD_OM_HYDROS	5
CSF_MD_OM_POIS	4
CSF_MD_OM_ROADS	4
CSF_MD_POIS	11	This table defines POI (point of interest) for Map Display
CSF_MD_POI_NM_ASGNS	5	Defines the relationship between the MD NAME and the MD NAMES and MD POI tables.
CSF_MD_RAIL_SEGS	5	Defines an individual line segment representing a railroad.
CSF_MD_RDSEG_NM_ASGNS	5	Defines the relation between the road segments and names table.
CSF_MD_RD_SEGS	23	Defines a navigable feature.
CSF_MD_THEME_METADATA	8	Defines the version information of an entire theme.
CSF_ODF_CTRY_MAPPING	5
CSF_PARAMS	25	Parameters for Laptop and Palm
CSF_PHONETIC_VALUES	14
CSF_PLAN_TERRS	10	Associative (relationship) table to map between the territory and resource group tables
CSF_RATING_SCALES_B	28	Skill types
CSF_RATING_SCALES_TL	12	Skill types
CSF_REQUIRED_SKILLS_B	34	This table is used to see which object has required skills
CSF_RESOURCE_SKILLS_B	31	Skill types
CSF_R_FILTERS_ALL_B	30	Data table with scheduler filter definitions
CSF_R_FILTERS_ALL_TL	10	Translated companion to table CSF_R_FILTER_DEFS_ALL_B.
CSF_R_FILTER_PARAMS_B	29	Filter parameters.
CSF_R_FILTER_PARAMS_TL	10	Translated companion to table CSF_R_FILTER_PARAMS_B.
CSF_R_HZ_LOC_EXTNS	1	This table is for storing locations
CSF_R_MESSAGES	6	Messages
CSF_R_MESSAGE_TOKENS	6	Message tokens
CSF_R_PLAN_OPTIONS	12	This table is for storing the planoptions
CSF_R_PLAN_OPTION_TASKS	10	This is a table to store the trips for which the planoptions apply
CSF_R_REQUEST_FILTERS	11	This table is for storing the filter settings for a request
CSF_R_REQUEST_TASKS	6	This table stores the task needs to be scheduled for a request
CSF_R_REQUEST_VALUES	11	This table is the table tostore the values of the filters
CSF_R_RESOURCE_RESULTS	21	Table containing the result of the 'resoure filters' (Prefferred, Territory, Geography, Skills)
CSF_R_SCENARIOS_ALL_B	29	Scenario definitions.
CSF_R_SCENARIOS_ALL_TL	11	Translated companion to table CSF_R_SCENAR_DEFS_ALL_TL.
CSF_R_SCENARIO_FILTERS	11	Defines the associations between scenarios and filters.
CSF_R_SCENARIO_VALUES	11	Filter parameter values.
CSF_R_SCHED_REQUESTS	32	Scheduler requests.
CSF_R_SPARES_OPTIONS	9	The table that contains the result(s) after the spares api is called
CSF_R_TASK_ASSIGN_EXTNS	12	Table to store the task assignment extensions
CSF_R_TDS_ROUTE_CACHE	8	Table to store cache routes
CSF_SDM_CTRY_PROFILES	20	Defines country profiles
CSF_SKILLS_B	30	Skill types
CSF_SKILLS_TL	12	Skill types
CSF_SKILL_LEVELS_B	31	Skill types
CSF_SKILL_LEVELS_TL	12	Skill types
CSF_SKILL_TYPES_B	35	Skill types
CSF_SKILL_TYPES_TL	12	Skill types
CSF_TDS_BINARY_MAPS	10	Defines the digital roadmap for route calculation.
CSF_TDS_BINARY_TILES	5	Defines a spatial index to a digital map.
CSF_TDS_CONDITIONS	18	This table stores the conditions for the TDS.
CSF_TDS_COND_SEGS	6	Intersection table for condition and segments
CSF_TDS_INTERVALS	24	The intervals table
CSF_TDS_NODES	5	The nodes table
CSF_TDS_RDBLCK_INTVLS	4	Intersection table for Roadblocks and intervals
CSF_TDS_RDBLCK_SGMNTS	4	The relation between RoadBlocks and Segments
CSF_TDS_ROADBLOCKS	9	Defines a travel duration delay for a segment.
CSF_TDS_ROUTE_CACHE	27
CSF_TDS_SEGMENTS	28	Defines a connection between two nodes.
CSF_TDS_SEGM_NODES	5	Defines the relation between the segments and the nodes table
CSF_TDS_TILES	8	Defines the result of spatial index creation (tiling).