You are browsing the archive for CSF.

Oracle Field Service Tables

Database table information for Oracle Field Service modules:

  • CSF_ACCESS_HOURS_B
  • CSF_ACCESS_HOURS_TL
  • CSF_DC_QUERIES_B
  • CSF_DC_QUERIES_TL
  • CSF_DEBRIEF_HEADERS
  • CSF_DEBRIEF_LINES
  • CSF_EXT_LOCATIONS
  • CSF_GNTICONS_SETUP_B
  • CSF_LF_BLOCKS
  • CSF_LF_NAMES
  • CSF_LF_PLACES
  • CSF_LF_PLACE_NAMES
  • CSF_LF_PLACE_POSTCS
  • CSF_LF_POIS
  • CSF_LF_POI_NAMES
  • CSF_LF_POSTCODES
  • CSF_LF_ROADSEGMENTS
  • CSF_LF_ROADSEGM_NAMES
  • CSF_LF_ROADSEGM_PLACES
  • CSF_LF_ROADSEGM_POSTS
  • CSF_L_AGENDALAYOUTS
  • CSF_L_QUERIES
  • CSF_L_QUERYREQUESTS
  • CSF_L_SODS
  • CSF_L_SOTS
  • CSF_MAP_ACCESS_HOURS_B
  • CSF_MAP_ACCESS_HOURS_TL
  • CSF_MD_ADM_BOUNDS
  • CSF_MD_HYDROS
  • CSF_MD_INST_STYLE_SHTS
  • CSF_MD_LAND_USES
  • CSF_MD_LYR_METADATA
  • CSF_MD_LYR_STYLE_SHTS
  • CSF_MD_NAMES
  • CSF_MD_OM_ADMINS
  • CSF_MD_OM_HYDROS
  • CSF_MD_OM_POIS
  • CSF_MD_OM_ROADS
  • CSF_MD_POIS
  • CSF_MD_POI_NM_ASGNS
  • CSF_MD_RAIL_SEGS
  • CSF_MD_RDSEG_NM_ASGNS
  • CSF_MD_RD_SEGS
  • CSF_MD_THEME_METADATA
  • CSF_PARAMS
  • CSF_PHONETIC_VALUES
  • CSF_PLAN_TERRS
  • CSF_RATING_SCALES_B
  • CSF_RATING_SCALES_TL
  • CSF_REQUIRED_SKILLS_B
  • CSF_RESOURCE_SKILLS_B
  • CSF_R_FILTERS_ALL_B
  • CSF_R_FILTERS_ALL_TL
  • CSF_R_FILTER_PARAMS_B
  • CSF_R_FILTER_PARAMS_TL
  • CSF_R_HZ_LOC_EXTNS
  • CSF_R_MESSAGES
  • CSF_R_MESSAGE_TOKENS
  • CSF_R_PLAN_OPTIONS
  • CSF_R_PLAN_OPTION_TASKS
  • CSF_R_REQUEST_FILTERS
  • CSF_R_REQUEST_TASKS
  • CSF_R_REQUEST_VALUES
  • CSF_R_RESOURCE_RESULTS
  • CSF_R_SCENARIOS_ALL_B
  • CSF_R_SCENARIOS_ALL_TL
  • CSF_R_SCENARIO_FILTERS
  • CSF_R_SCENARIO_VALUES
  • CSF_R_SCHED_REQUESTS
  • CSF_R_SPARES_OPTIONS
  • CSF_R_TASK_ASSIGN_EXTNS
  • CSF_R_TDS_ROUTE_CACHE
  • CSF_SDM_CTRY_PROFILES
  • CSF_SKILLS_B
  • CSF_SKILLS_TL
  • CSF_SKILL_LEVELS_B
  • CSF_SKILL_LEVELS_TL
  • CSF_SKILL_TYPES_B
  • CSF_SKILL_TYPES_TL
  • CSF_TDS_BINARY_MAPS
  • CSF_TDS_BINARY_TILES
  • CSF_TDS_CONDITIONS
  • CSF_TDS_COND_SEGS
  • CSF_TDS_INTERVALS
  • CSF_TDS_NODES
  • CSF_TDS_RDBLCK_INTVLS
  • CSF_TDS_RDBLCK_SGMNTS
  • CSF_TDS_ROADBLOCKS
  • CSF_TDS_SEGMENTS
  • CSF_TDS_SEGM_NODES
  • CSF_TDS_TILES

Oracle Field Service Forms

Oracle Field Service Module Forms

FORM SHORT CODE ORACLE FORM NAME
CSFTESEL Select Territories
CSFCTMAI Control Tower
CSFFEDBF Debrief
CSFCTDBR Commit Schedule
CSFCMRSL Resources Subinventories Assignment
CSFSEPLT Assign Territories to Planner Groups
CSFCMLAY Agenda Layout
CSFCMPAR Configuration Parameters
CSFCMWFT Field Service Report Types
CSFCMWFM Field Service Report Manager
CSFCMQRY User Defined Queries
CSFCRSHF Create Trips
CSFDCGTR Read Only Scheduling Chart
CSFGCSTP Tooltip Setup Form
CSFACHRS Access Hours
CSFCTCON Customer Confirmation
CSFDCTKD Task Dependency
CSFDCPCM Parent Child Model
CSFGTSTP Scheduling Chart Setup Form
CSFQRYTO Task Owner Enforcement for Queries
CSFDCMAI Dispatch Center
CSFDCTER Select Territories(1)
CSFDCCMS Commit Schedule(1)
CSFDCHIS Service History
CSFSKMGT Skills Management
CSFSKASN Skills Assignment to Task
CSFTSKCL Task’s Custom Color Setup
CSFDCTRM Trip Management
CSFCGITA Change Invalid Address

Field Service Profile Options

Oracle Field Service Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
CSF_DEBRIEF_COUNTER_CHECK CSF: Debrief Check for Counter Updates
CSF_DEF_TIME_FRAME_ADV_FIND CSF: Time Frame in Days for Advanced Find Query based on Task Creation Date
CSF_DEFAULT_ACCEPTED_STATUS CSF: Default Accepted Task Status
CSF_DEFAULT_REJECTED_STATUS CSF: Default Rejected Task Status
CSF_ALERT_SEND_PREF CSF: Alert Send Preference
CSF_ALERTS_MIN_BEFORE_SHIFT CSF: Alert before shift begins in minutes
CSF_ALERT_PRIORITY CSF: Alerts Task Priority Level
CSF_ALERTS_RESPONSE_TIME_MIN CSF: Alert Response Due Time in minutes
CSF_SELECTED_TERRITORIES CSF: Selected territories
CSF_DEFAULT_TASK_NEW_STATUS CSF: Default New task status
CSF_DEFAULT_TASK_INPLANNING_STATUS CSF: Default “In planning” task status
CSF_DEFAULT_TASK_ASSIGNED_STATUS CSF: Default commit  task status
CSF_DEFAULT_TASK_CANCELLED_STATUS CSF: Default Cancelled task status
CSF_RESOURCE_PROGRESS_MARGIN CSF: Resource progress delay margin
CSF_MAP_LEFT_TOP_X CSF: Map Left Top X-coordinate
CSF_MAP_LEFT_TOP_Y CSF: Map Left Top Y-coordinate
CSF_MAP_RIGHT_BOTTOM_X CSF: Map Right Bottom X-coordinate
CSF_MAP_RIGHT_BOTTOM_Y CSF: Map Right Bottom Y-coordinate
CSF_MAP_SERVICE_AREA CSF: Last used service area on the map
CSF_MAP_DB_ADDRESS CSF: Address of the Database machine
CSF_MAP_DB_SID CSF: SID of the database
CSF_MAP_WEB_SERVER CSF: Web server address where the images are stored for the map
CSF_MAP_DB_PORT CSF: Database port to receive data
CSF_MAP_SERVER_ADDRESS CSF: Address of the Map-server
CSF_LF_INSTALLED CSF: Location Finder Installed
CSF_L_CONFLICT_RULE CSF: ConflictRule_L
CSF_M_CONFLICT_RULE CSF: ConflictRule_M
CSF_L_HISTORY CSF: History_L
CSF_L_INSTALLEDBASEPRODUCT CSF: InstalledBaseProduct_L
CSF_M_INSTALLEDBASEPRODUCT CSF: InstalledBaseProduct_M
CSF_M_HISTORY CSF: History_M
CSF_MAP_SERVER_PORT CSF: Port of the Map Server
CSF_TDS_FACTOR CSF: Time distance server calculation factor
CSF_TDS_DEFAULT_DURATION CSF: Default travel duration for Time Distance Server
CSF_TDS_DEFAULT_DISTANCE CSF: Default travel distance for Time Distance Server
CSF_UOM_MINUTES CSF: The unit of measure for minutes
CSF_UOM_HOURS CSF: The unit of measure for hours
CSFW_RETURN_ROUTER CSFW: Return Router
CSF_LAPTOP_ITEM_ORGANIZATION CSF: Laptop Item Organization
CSF_EMAP_BASEMAP CSF: eLocation Map basemap name
CSF_EMAP_DS_DRIVER CSF: eLocation Map JDBC driver type
CSF_EMAP_DS_MAPPERS CSF: eLocation mappers count
CSF_EMAP_DS_NAME CSF: eLocation Map data source name
CSF_EMAP_DS_UID CSF: eLocation Map user identification
CSF_EMAP_ICON_URL CSF: eLocation Map icon URL
CSF_EMAP_RMI_PORT CSF: eLocation Map http port number
CSF_EMAP_V_MAX_Y CSF: eLocation Map high latitude coordinate
CSF_EMAP_V_MIN_Y CSF: eLocation Map low latitude coordinate
CSF_MOBILE_OVERLAPPING_LABOR_LINES CSF: Allow overlapping labor lines
CSF_USE_EMAP CSF: Use eLocation Map
CSF_L_MAT_TRANSFER_HISTORY CSF: Material Transfer History
CSFW_ROUTER_LOCATION CSFW: Router Location
CSFWDATEFORMAT CSFW: Date Format
CSF_EMAP_DS_MAPS_TABLE CSF: eLocation Map maps table name
CSF_EMAP_DEBUGGING CSF: eLocation Map enable java debugging
CSF_EMAP_DS_THEMES_TABLE CSF: eLocation Map themes table
CSF_EMAP_RMI_BINDING_NAME CSF: eLocation Map binding name
CSF_EMAP_V_MAX_X CSF: eLocation Map high longitude coordinate
CSF_EMAP_SERVICE_AREA CSF: eLocation Map last used service area number
CSF_DEFAULT_SPARES_AVAIL CSF: Default Spares Availability
CSF_EMAP_DS_HOST CSF: eLocation Map host name
CSF_DEFAULT_QUERY CSF: Default Query
CSF_PALM_ITEM_ORGANIZATION CSF: Palm Item Organization
CSF_EMAP_DS_PORT CSF: eLocation Map port number
CSF_EMAP_DS_SID CSF: eLocation Map database SID
CSF_EMAP_RMI_HOST CSF: eLocation MapViewer URL
CSFW_TASK_DISPLAY1 CSFW: Task Display1
CSFW_TASK_DISPLAY2 CSFW: Task display2
CSFW_TASK_MAX CSFW: Task Max
CSF_EMAP_DS_STYLES_TABLE CSF: eLocation Map styles table
CSF_EMAP_MOVE_FACTOR CSF: eLocation Map move factor (between 0.1 and 1)
CSF_EMAP_V_MIN_X CSF: eLocation Map low longitude coordinate
CSF_L_REPLICATE_CATEGORIES CSF: Replicate_Categories_L
CSF_MOBILE_TASK_TIMES_UPDATABLE CSF: Update planned/scheduled times allowed
CSF_RETURN_REASON CSF: Default Return Reason (For Material Debrief)
CSF_TDS_CACHE_RADIUS CSF: Time distance server cache radius
CSF_MAP_MOVE_FACTOR CSF: Map Move Factor (between 0.1 and 1)
CSF_MOBILE_CONFORM_TO_SCHEDULE CSF: Conform to schedule
CSF_STATUS_RESPONSIBILITY CSF: Default Status Responsibility
CSF_GOOGLE_MAP_KEY CSF: Google Map Key
CSFW_HOME_PAGE CSFW: Home Page
CSF_R_SKIP_PREFERENCES CSF: Skip Scheduling Preferences
CSF_R_DFLT_SCENARIO CSF: Default Scheduling Scenario
CSFWAUDIOPATH CSFW: Audio Path
CSFW_SR_HISTORY_DAYS CSFW: Service History Days
CSF:DEFAULT DEBRIEF TRANSACTION TYPE CSF: Default Debrief Service Activity Code
CSF_BUSINESS_PROCESS CSF:Business Process
CSF_R_DFLT_SCHED_TYPE CSF: Default Scheduling Type
CSF_DEFAULT_TASK_BLOCKEDASS_STATUS CSF: Default Task Blocked Assigned Status
CSF_SCHED_VIEW_GANTT CSF: View scheduling results in Gantt chart
CSF_SCHED_SHOW_SHIFTS CSF: Display shifts in scheduling results Gantt chart
CSF_DFLT_SOURCE_FOR_CONTACT CSF: Default Source for Contact
CSF_USE_CUSTOM_CHROMATICS CSF: Use Custom Color Coding Scheme
CSF_INVENTORY_ORG CSF: Inventory Organization ID
CSFPM_INCIDENT_TYPE CSF:PM Service Request Type
CSF_SKILL_LEVEL_MATCH CSF: Skill Level Match
CSFPM_LAST_RUN_DATE CSF:PM SR Generation Last Run Date
CSF_DEFAULT_TASK_BLOCKEDWOR_STATUS CSF: Default Blocked working task status
CSF_DEFAULT_TASK_BLOCKEDIP_STATUS CSF: Default Task Blocked “In Planning” Status
CSFW_DEFAULT_DISTANCE_UNIT CSF: Default Distance Unit
CSF_DEFAULT_TASK_WORKING_STATUS CSF: Default Working task status
CSFPM_TASK_CONFIRM_STATUS CSF:PM Task Confirm Status
CSF:DEFAULT DEBRIEF BUSINESS PROCESS CSF: Default Debrief Business Process
CSF_LABOR_DEBRIEF_DEFAULT_UOM CSF:Service Debrief Default UOM for Labor
CSFPM_INCIDENT_STATUS CSF:PM Service Request Status
CSF_ALERTS_AUTO_REJECT CSF: Alert Auto Reject
CSF_ALERTS_REMINDER_TIME_MIN CSF: Alert Reminder Response Due Time in minutes
CSF_ALERTS_ENABLE CSF: Enable Alerts
CSF_TDS_CACHING CSF: TDS Caching Activated
CSF_DISPLAY_LABEL_ON_TASK CSF: Display Label on Task
CSF_DEBRIEF_OVERLAPPING_LABOR CSF: Allow overlapping Labor lines for Debrief
CSF_DFLT_AUTO_CLOSE_TASK_STATUS CSF: Default Auto Close Task Status
CSFW_VOICE_EXP_ACT_CODE CSFW: Voice Expense Activity Code
CSFW_VOICE_EXP_ITEM CSFW: Voice Expense Item
CSFW_VOICE_LAB_ACT_CODE CSFW: Voice Labor Activity Code
CSFW_VOICE_LAB_ITEM CSFW: Voice Labor Item
CSF_CHECK_HTML_SERVICE_IMPL CSF:HTML Service Implemented
CSF_SERVICE_HISTORY_TIMEFRAME_NUMBER CSF: Service History Time Frame Number
CSF_SERVICE_HISTORY_TIMEFRAME_UOM CSF: Service History Time Frame UOM
CSF_DEFAULT_SERVICE_HISTORY_DISPLAY CSF: Default Service History Display
CSFW_ENABLE_SIGNATURE_CAPTURE CSFW: Enable Signature Control
CSF_DEFAULT_EFFORT CSF: Default Effort
CSF_DEFAULT_EFFORT_UOM CSF: Default Effort UOM
CSF_TASK_SIGNAL_COLOR CSF: Task Signal Color
CSF_DEFAULT_TASK_UNSCHEDULED_STATUS CSF: Default Unscheduled task status
CSFW_TASK_DISPLAY3 CSFW:Task Display3
CSFW_PLANNED_TASK_WINDOW CSFW: Planned Task Window
CSF_TDS_TILE_MAX_MEM_SIZE CSF: Maximum Tile Memory Size (in MB)
CSF_SR_ITEM_TO_TASK_REQ CSF: Copy Service Request Item to Task Skill Requirements
CSF_DFLT_SKILL_LEVEL CSF: Default Skill Level Copy for Service Request Item
CSFW_UPD_SCHEDULABLE CSFW: Update Schedulable Task
CSF_DEFAULT_TIMEZONE_SC CSF: Default Time Zone Source – Schedule Advice
CSF_DEBRIEF_PARTS_AVAILABILITY CSF: Debrief Display Warning Message for Negative Inventory Balance
CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS CSF: Default Task Blocked Planned Status
CSF: DEFAULT_FIND_TASKS_FUNCTION CSF: Default Find Tasks function
CSF_DEFAULT_TIMEZONE_DC CSF: Default Time Zone Source – Dispatch Center
CSF_DEFAULT_DISPATCH_CENTER_DISPLAY CSF: Default Dispatch Center Display
CSF_SCHEDULER_ACTIVE CSF: Scheduler Active
CSF_DATA_WINDOW_IN_GANTT CSF: Data window in days for Gantt
CSF_DEFAULT_AUTO_COMMIT_QUERY CSF: Selection of tasks for Auto Commit Tasks
CSF_DEFAULT_TASK_PLANNED_STATUS CSF: Default Planned Task Status for Planned Task
CSF_CAPTURE_TRAVEL CSF:Capture travel information
CSFW_SCHEDULABLE_OPTIONS CSFW: Technicians Schedulable Options
CSFW_VOICE_ITEM_TYPE Csfw: Voice Item Type
CSFW_VOICE_PARENT_TYPE Csfw: Voice Parent Product Type
CSFW_VOICE_RECOVERED_TYPE Csfw: Voice Recovered Product Type
CSFW_VOICE_SERIAL_TYPE Csfw: Voice Serial Number Type
CSFW_VOICE_ORD_ACT_CODE CSFW: Voice Install Service Activity Code
CSFW_VOICE_RET_ACT_CODE CSFW: Voice Return Service Activity Code
CSF_DISABLE_HTML_DEBRIEF CSF: Disable HTML Debrief
CSFW_USE_ICONS CSFW: Use Icons for buttons
CSF_DEFAULT_TASK_STATUS_PERSONAL CSF: Default Task Status for Personal Tasks
CSF_DEFAULT_TASK_TYPE_PERSONAL CSF: Default Task Type for Personal Tasks
CSFW_DISP_PO_NR CSFW: Display PO Number
CSF_SHOW_ARR_DEP_TASK CSF: Display Arrival Departure Tasks in Gantt
CSF_SHOW_DND_WARN_MSG CSF: Display Messages in Scheduling Chart
CSF_LOC_ACC_LEVELS CSF: Location Finder Accuracy Level
CSFW_ATTACHMENT_SIZE_LIMIT CSFW: Attachment Size Limit
CSF_DEBRIEF_SERVICE_DATE CSF: Debrief Allow Service Date in Future
CSF_DEFAULT_LABOR_DEBRIEF_DATETIME CSF: Default Labor Debrief Date/Time
CSF_SPATIAL_DATASET_NAME CSF: Enable Spatial dataset
CSF_SPATIAL_MULTIDATASET_ENABLED CSF: Enable Multi Dataset
CSF: MANDATORY_LABOR_DEBRIEF CSF: Mandatory Labor Debrief
CSF_SR_ITEM_CAT_TO_TASK_REQ CSF: Copy Service Request Item Category to Task Skill Requirements
CSF_ADDR_SOURCE CSF: Default Departure and Arrival Address Source
CSF_DC_DISPLAY_ONLY_TECHNICIANS CSF: Display only Technicians in Dispatch Center
CSF_SC_DATE_TO_PB CSF: Pass Scheduling Chart context date to Plan Board
CSF_GENERATE_SHIFT_ADDRESS CSF: Shift Task Address Source
CSF_SKILL_VALIDATION_OVERIDE CSF: Override Task Skill Requirement for rescheduling in Scheduling Chart
CSF_EMAP_DATASET_NAME CSF: eLocation Map last used spatial dataset
CSF_GPS_CONFIG CSF: GPS Configuration
CSF_DEBRIEF_RESTRICT_INSTANCE CSF: Debrief Restrict Return by Instance on Service Request
CSF_RESTRICT_SERVICE_REQUEST_CREATION_ TO_ SCHEDULED_SITES CSF: Restrict Service Request Creation to Scheduled Sites
CSF_MANDATORY_RESOLUTION_CODE CSF: Mandatory Resolution Code
CSF_DEBRIEF_LABOR_SAC CSF:Default Service Activity Code for Labor
CSF_DEBRIEF_TRAVEL_SAC CSF:Default Service Activity Code for Travel
CSF_ENABLE_GPS CSF: Enable GPS
CSF_AUTO_POPULATE_ACCESS_HRS CSF: Automatic Association of Access Hours to Field Service Task