This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_ACCESS_HOURS_B.TASK_ID | JTF_TASKS_B |
CSF.CSF_ACCESS_HOURS_B does not reference any database object
CSF.CSF_ACCESS_HOURS_B is referenced by following:
Description: |
---|
CSF.CSF_ACCESS_HOURS_TL does not reference any database object
CSF.CSF_ACCESS_HOURS_TL is referenced by following:
Description: | CSF_DC_QUERIES_B contains WHERE-clauses for queries to populate the Dispatch Center with tasks |
---|
CSF.CSF_DC_QUERIES_B does not reference any database object
CSF.CSF_DC_QUERIES_B is referenced by following:
Description: |
---|
CSF.CSF_DC_QUERIES_TL does not reference any database object
CSF.CSF_DC_QUERIES_TL is referenced by following:
Description: | Field Service Report header information |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_DEBRIEF_HEADERS.TASK_ASSIGNMENT_ID | JTF_TASK_ASSIGNMENTS |
Foreign Key Column | Foreign Table |
---|---|
CSF_DEBRIEF_LINES.DEBRIEF_HEADER_ID | CSF_DEBRIEF_HEADERS |
CSF.CSF_DEBRIEF_HEADERS does not reference any database object
CSF.CSF_DEBRIEF_HEADERS is referenced by following:
Description: | Field Service Report lines information |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_DEBRIEF_LINES.DEBRIEF_HEADER_ID | CSF_DEBRIEF_HEADERS |
Foreign Key Column | Foreign Table |
---|---|
CS_ESTIMATE_DETAILS.ORIGINAL_SOURCE_ID | CSF_DEBRIEF_LINES |
CSF.CSF_DEBRIEF_LINES does not reference any database object
CSF.CSF_DEBRIEF_LINES is referenced by following:
Description: |
---|
Description: |
---|
CSF.CSF_EXT_LOCATIONS does not reference any database object
CSF.CSF_EXT_LOCATIONS is referenced by following:
Description: |
---|
CSF.CSF_GNTICONS_SETUP_B does not reference any database object
CSF.CSF_GNTICONS_SETUP_B is referenced by following:
Description: |
---|
CSF.CSF_GPS_DEVICES does not reference any database object
CSF.CSF_GPS_DEVICES is referenced by following:
Description: |
---|
CSF.CSF_GPS_DEVICE_ASSIGNMENTS does not reference any database object
CSF.CSF_GPS_DEVICE_ASSIGNMENTS is referenced by following:
Description: |
---|
CSF.CSF_GPS_LOCATION_FEEDS does not reference any database object
CSF.CSF_GPS_LOCATION_FEEDS is referenced by following:
Description: |
---|
CSF.CSF_GPS_VENDORS_B does not reference any database object
CSF.CSF_GPS_VENDORS_B is referenced by following:
Description: |
---|
CSF.CSF_GPS_VENDORS_TL does not reference any database object
CSF.CSF_GPS_VENDORS_TL is referenced by following:
Description: |
---|
CSF.CSF_GPS_VENDOR_STATUS_MAPS does not reference any database object
CSF.CSF_GPS_VENDOR_STATUS_MAPS is referenced by following:
Description: | Defines the available address range for a segment |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_BLOCKS.ROADSEGMENT_ID | CSF_LF_ROADSEGMENTS |
CSF.CSF_LF_BLOCKS does not reference any database object
CSF.CSF_LF_BLOCKS is referenced by following:
Description: | Stores all Name information for the Location Finder |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_PLACE_NAMES.NAME_ID | CSF_LF_NAMES |
CSF_LF_POI_NAMES.NAME_ID | CSF_LF_NAMES |
CSF_LF_ROADSEGM_NAMES.NAME_ID | CSF_LF_NAMES |
CSF.CSF_LF_NAMES does not reference any database object
CSF.CSF_LF_NAMES is referenced by following:
Description: | Contains all Administrative areas and Zones |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_PLACE_NAMES.PLACE_ID | CSF_LF_PLACES |
CSF_LF_PLACE_POSTCS.PLACE_ID | CSF_LF_PLACES |
CSF_LF_POIS.PLACE_ID | CSF_LF_PLACES |
CSF_LF_ROADSEGM_PLACES.PLACE_ID | CSF_LF_PLACES |
CSF.CSF_LF_PLACES does not reference any database object
CSF.CSF_LF_PLACES is referenced by following:
Description: | Defines relation between Place and Name |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_PLACE_NAMES.PLACE_ID | CSF_LF_PLACES |
CSF_LF_PLACE_NAMES.NAME_ID | CSF_LF_NAMES |
CSF.CSF_LF_PLACE_NAMES does not reference any database object
CSF.CSF_LF_PLACE_NAMES is referenced by following:
Description: | Defines relation between Place and Postcode tables |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_PLACE_POSTCS.PLACE_ID | CSF_LF_PLACES |
CSF_LF_PLACE_POSTCS.POSTAL_CODE_ID | CSF_LF_POSTCODES |
CSF.CSF_LF_PLACE_POSTCS does not reference any database object
CSF.CSF_LF_PLACE_POSTCS is referenced by following:
Description: | Stores POI (points of interests) in the roadnetwork that are known by the name for LF |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_POIS.ROADSEGMENT_ID | CSF_LF_ROADSEGMENTS |
CSF_LF_POIS.PLACE_ID | CSF_LF_PLACES |
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_POI_NAMES.POI_ID | CSF_LF_POIS |
Description: | Defines the relation between POI and Name tables |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_POI_NAMES.NAME_ID | CSF_LF_NAMES |
CSF_LF_POI_NAMES.POI_ID | CSF_LF_POIS |
CSF.CSF_LF_POI_NAMES does not reference any database object
CSF.CSF_LF_POI_NAMES is referenced by following:
Description: | Stores the Postcode information and the centroid of each Postcode area |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_PLACE_POSTCS.POSTAL_CODE_ID | CSF_LF_POSTCODES |
CSF_LF_ROADSEGM_POSTS.POSTAL_CODE_ID | CSF_LF_POSTCODES |
Description: | Stores roadsegments with their navigable attributes |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_BLOCKS.ROADSEGMENT_ID | CSF_LF_ROADSEGMENTS |
CSF_LF_POIS.ROADSEGMENT_ID | CSF_LF_ROADSEGMENTS |
CSF_LF_ROADSEGM_NAMES.ROADSEGMENT_ID | CSF_LF_ROADSEGMENTS |
CSF_LF_ROADSEGM_PLACES.ROADSEGMENT_ID | CSF_LF_ROADSEGMENTS |
CSF_LF_ROADSEGM_POSTS.ROADSEGMENT_ID | CSF_LF_ROADSEGMENTS |
Description: | Defines the relation between roadsegments and the name table |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_ROADSEGM_NAMES.NAME_ID | CSF_LF_NAMES |
CSF_LF_ROADSEGM_NAMES.ROADSEGMENT_ID | CSF_LF_ROADSEGMENTS |
CSF.CSF_LF_ROADSEGM_NAMES does not reference any database object
CSF.CSF_LF_ROADSEGM_NAMES is referenced by following:
Description: | Defines relation between Roadsegments and Places |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_ROADSEGM_PLACES.PLACE_ID | CSF_LF_PLACES |
CSF_LF_ROADSEGM_PLACES.ROADSEGMENT_ID | CSF_LF_ROADSEGMENTS |
Description: | Defines relation between Roadsegment and Postcodes |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_LF_ROADSEGM_POSTS.POSTAL_CODE_ID | CSF_LF_POSTCODES |
CSF_LF_ROADSEGM_POSTS.ROADSEGMENT_ID | CSF_LF_ROADSEGMENTS |
CSF.CSF_LF_ROADSEGM_POSTS does not reference any database object
CSF.CSF_LF_ROADSEGM_POSTS is referenced by following:
Description: | Agenda Layout on the Laptop |
---|
CSF.CSF_L_AGENDALAYOUTS does not reference any database object
CSF.CSF_L_AGENDALAYOUTS is referenced by following:
Description: | List of Queries |
---|
CSF.CSF_L_QUERIES does not reference any database object
CSF.CSF_L_QUERIES is referenced by following:
Description: | Requests for executing Queries |
---|
CSF.CSF_L_QUERYREQUESTS does not reference any database object
CSF.CSF_L_QUERYREQUESTS is referenced by following:
Description: | Service Order Description |
---|
CSF.CSF_L_SODS does not reference any database object
CSF.CSF_L_SODS is referenced by following:
Description: | Service Order Types |
---|
CSF.CSF_L_SOTS does not reference any database object
CSF.CSF_L_SOTS is referenced by following:
Description: |
---|
CSF.CSF_MAP_ACCESS_HOURS_B does not reference any database object
CSF.CSF_MAP_ACCESS_HOURS_B is referenced by following:
Description: |
---|
CSF.CSF_MAP_ACCESS_HOURS_TL does not reference any database object
CSF.CSF_MAP_ACCESS_HOURS_TL is referenced by following:
Description: | Defines an administrative boundary defined in a country. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_ADM_BOUNDS.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_NAMES.ADMIN_BOUND_ID | CSF_MD_ADM_BOUNDS |
Description: | Defines a hydrographic feature. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_HYDROS.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_NAMES.HYDROGRAPHY_ID | CSF_MD_HYDROS |
Description: | Defines map instance style sheets |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_ADM_BOUNDS.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
CSF_MD_HYDROS.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
CSF_MD_RD_SEGS.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
CSF_MD_LAND_USES.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
CSF_MD_LYR_METADATA.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
CSF_MD_POIS.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
CSF_MD_RAIL_SEGS.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
CSF.CSF_MD_INST_STYLE_SHTS does not reference any database object
CSF.CSF_MD_INST_STYLE_SHTS is referenced by following:
Description: | Defines the geometry of various land usages |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_LAND_USES.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_NAMES.LANDUSE_ID | CSF_MD_LAND_USES |
Description: | Defines map display layer metadata |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_LYR_METADATA.LAYER_STYLE_SHEET_ID | CSF_MD_LYR_STYLE_SHTS |
CSF_MD_LYR_METADATA.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
CSF_MD_LYR_METADATA.THEME_METADATA_ID | CSF_MD_THEME_METADATA |
CSF.CSF_MD_LYR_METADATA does not reference any database object
CSF.CSF_MD_LYR_METADATA is referenced by following:
Description: | Defines the visual display characteristics of a map layer |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_LYR_METADATA.LAYER_STYLE_SHEET_ID | CSF_MD_LYR_STYLE_SHTS |
Description: | Defines the name of the given geographic entities in the model. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_NAMES.HYDROGRAPHY_ID | CSF_MD_HYDROS |
CSF_MD_NAMES.ADMIN_BOUND_ID | CSF_MD_ADM_BOUNDS |
CSF_MD_NAMES.LANDUSE_ID | CSF_MD_LAND_USES |
CSF_MD_NAMES.RAILROAD_SEGMENT_ID | CSF_MD_RAIL_SEGS |
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_POI_NM_ASGNS.NAME_ID | CSF_MD_NAMES |
CSF_MD_RDSEG_NM_ASGNS.NAME_ID | CSF_MD_NAMES |
CSF.CSF_MD_NAMES does not reference any database object
CSF.CSF_MD_NAMES is referenced by following:
Description: |
---|
Description: |
---|
Description: |
---|
Description: |
---|
Description: | This table defines POI (point of interest) for Map Display |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_POIS.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_POI_NM_ASGNS.POI_ID | CSF_MD_POIS |
Description: | Defines the relationship between the MD NAME and the MD NAMES and MD POI tables. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_POI_NM_ASGNS.NAME_ID | CSF_MD_NAMES |
CSF_MD_POI_NM_ASGNS.POI_ID | CSF_MD_POIS |
CSF.CSF_MD_POI_NM_ASGNS does not reference any database object
CSF.CSF_MD_POI_NM_ASGNS is referenced by following:
Description: | Defines an individual line segment representing a railroad. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_RAIL_SEGS.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_NAMES.RAILROAD_SEGMENT_ID | CSF_MD_RAIL_SEGS |
Description: | Defines the relation between the road segments and names table. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_RDSEG_NM_ASGNS.ROAD_SEGMENT_ID | CSF_MD_RD_SEGS |
CSF_MD_RDSEG_NM_ASGNS.NAME_ID | CSF_MD_NAMES |
CSF.CSF_MD_RDSEG_NM_ASGNS does not reference any database object
CSF.CSF_MD_RDSEG_NM_ASGNS is referenced by following:
Description: | Defines a navigable feature. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_RD_SEGS.INST_STYLE_ID | CSF_MD_INST_STYLE_SHTS |
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_RDSEG_NM_ASGNS.ROAD_SEGMENT_ID | CSF_MD_RD_SEGS |
Description: | Defines the version information of an entire theme. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_MD_LYR_METADATA.THEME_METADATA_ID | CSF_MD_THEME_METADATA |
CSF.CSF_MD_THEME_METADATA does not reference any database object
CSF.CSF_MD_THEME_METADATA is referenced by following:
Description: |
---|
CSF.CSF_ODF_CTRY_MAPPING does not reference any database object
CSF.CSF_ODF_CTRY_MAPPING is referenced by following:
Description: | Parameters for Laptop and Palm |
---|
CSF.CSF_PARAMS does not reference any database object
CSF.CSF_PARAMS is referenced by following:
Description: |
---|
CSF.CSF_PHONETIC_VALUES does not reference any database object
CSF.CSF_PHONETIC_VALUES is referenced by following:
Description: | Associative (relationship) table to map between the territory and resource group tables |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_PLAN_TERRS.GROUP_ID | JTF_RS_GROUPS_B |
CSF_PLAN_TERRS.TERR_ID | JTF_TERR_ALL |
CSF.CSF_PLAN_TERRS does not reference any database object
CSF.CSF_PLAN_TERRS is referenced by following:
Description: | Skill types |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_SKILL_LEVELS_B.RATING_SCALE_ID | CSF_RATING_SCALES_B |
CSF_SKILL_TYPES_B.RATING_SCALE_ID | CSF_RATING_SCALES_B |
CSF.CSF_RATING_SCALES_B does not reference any database object
CSF.CSF_RATING_SCALES_B is referenced by following:
Description: | Skill types |
---|
CSF.CSF_RATING_SCALES_TL does not reference any database object
CSF.CSF_RATING_SCALES_TL is referenced by following:
Description: | This table is used to see which object has required skills |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_REQUIRED_SKILLS_B.SKILL_TYPE_ID | CSF_SKILL_TYPES_B |
CSF_REQUIRED_SKILLS_B.SKILL_ID | CSF_SKILLS_B |
CSF_REQUIRED_SKILLS_B.SKILL_LEVEL_ID | CSF_SKILL_LEVELS_B |
CSF.CSF_REQUIRED_SKILLS_B does not reference any database object
CSF.CSF_REQUIRED_SKILLS_B is referenced by following:
Description: | Skill types |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_RESOURCE_SKILLS_B.SKILL_TYPE_ID | CSF_SKILL_TYPES_B |
CSF_RESOURCE_SKILLS_B.SKILL_ID | CSF_SKILLS_B |
CSF_RESOURCE_SKILLS_B.SKILL_LEVEL_ID | CSF_SKILL_LEVELS_B |
CSF.CSF_RESOURCE_SKILLS_B does not reference any database object
CSF.CSF_RESOURCE_SKILLS_B is referenced by following:
Description: | Data table with scheduler filter definitions |
---|
CSF.CSF_R_FILTERS_ALL_B does not reference any database object
CSF.CSF_R_FILTERS_ALL_B is referenced by following:
Description: | Translated companion to table CSF_R_FILTER_DEFS_ALL_B. |
---|
CSF.CSF_R_FILTERS_ALL_TL does not reference any database object
CSF.CSF_R_FILTERS_ALL_TL is referenced by following:
Description: | Filter parameters. |
---|
CSF.CSF_R_FILTER_PARAMS_B does not reference any database object
CSF.CSF_R_FILTER_PARAMS_B is referenced by following:
Description: | Translated companion to table CSF_R_FILTER_PARAMS_B. |
---|
CSF.CSF_R_FILTER_PARAMS_TL does not reference any database object
CSF.CSF_R_FILTER_PARAMS_TL is referenced by following:
Description: | This table is for storing locations |
---|
CSF.CSF_R_HZ_LOC_EXTNS does not reference any database object
CSF.CSF_R_HZ_LOC_EXTNS is referenced by following:
Description: | Messages |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_R_MESSAGES.REQUEST_TASK_ID | CSF_R_REQUEST_TASKS |
CSF.CSF_R_MESSAGES does not reference any database object
CSF.CSF_R_MESSAGES is referenced by following:
Description: | Message tokens |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_R_MESSAGE_TOKENS.MESSAGE_ID | CSF_R_SCHED_REQUESTS |
CSF.CSF_R_MESSAGE_TOKENS does not reference any database object
CSF.CSF_R_MESSAGE_TOKENS is referenced by following:
Description: | This table is for storing the planoptions |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_R_PLAN_OPTIONS.RESOURCE_RESULT_ID | CSF_R_RESOURCE_RESULTS |
Foreign Key Column | Foreign Table |
---|---|
CSF_R_PLAN_OPTION_TASKS.PLAN_OPTION_ID | CSF_R_PLAN_OPTIONS |
CSF.CSF_R_PLAN_OPTIONS does not reference any database object
CSF.CSF_R_PLAN_OPTIONS is referenced by following:
Description: | This is a table to store the trips for which the planoptions apply |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_R_PLAN_OPTION_TASKS.PLAN_OPTION_ID | CSF_R_PLAN_OPTIONS |
CSF.CSF_R_PLAN_OPTION_TASKS does not reference any database object
CSF.CSF_R_PLAN_OPTION_TASKS is referenced by following:
Description: | This table is for storing the filter settings for a request |
---|
CSF.CSF_R_REQUEST_FILTERS does not reference any database object
CSF.CSF_R_REQUEST_FILTERS is referenced by following:
Description: | This table stores the task needs to be scheduled for a request |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_R_REQUEST_TASKS.SCHED_REQUEST_ID | CSF_R_SCHED_REQUESTS |
Foreign Key Column | Foreign Table |
---|---|
CSF_R_MESSAGES.REQUEST_TASK_ID | CSF_R_REQUEST_TASKS |
CSF_R_RESOURCE_RESULTS.REQUEST_TASK_ID | CSF_R_REQUEST_TASKS |
CSF.CSF_R_REQUEST_TASKS does not reference any database object
CSF.CSF_R_REQUEST_TASKS is referenced by following:
Description: | This table is the table tostore the values of the filters |
---|
CSF.CSF_R_REQUEST_VALUES does not reference any database object
CSF.CSF_R_REQUEST_VALUES is referenced by following:
Description: | Table containing the result of the 'resoure filters' (Prefferred, Territory, Geography, Skills) |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_R_RESOURCE_RESULTS.REQUEST_TASK_ID | CSF_R_REQUEST_TASKS |
Foreign Key Column | Foreign Table |
---|---|
CSF_R_PLAN_OPTIONS.RESOURCE_RESULT_ID | CSF_R_RESOURCE_RESULTS |
CSF_R_SPARES_OPTIONS.RESOURCE_RESULT_ID | CSF_R_RESOURCE_RESULTS |
CSF.CSF_R_RESOURCE_RESULTS does not reference any database object
CSF.CSF_R_RESOURCE_RESULTS is referenced by following:
Description: | Scenario definitions. |
---|
CSF.CSF_R_SCENARIOS_ALL_B does not reference any database object
CSF.CSF_R_SCENARIOS_ALL_B is referenced by following:
Description: | Translated companion to table CSF_R_SCENAR_DEFS_ALL_TL. |
---|
CSF.CSF_R_SCENARIOS_ALL_TL does not reference any database object
CSF.CSF_R_SCENARIOS_ALL_TL is referenced by following:
Description: | Defines the associations between scenarios and filters. |
---|
CSF.CSF_R_SCENARIO_FILTERS does not reference any database object
CSF.CSF_R_SCENARIO_FILTERS is referenced by following:
Description: | Filter parameter values. |
---|
CSF.CSF_R_SCENARIO_VALUES does not reference any database object
CSF.CSF_R_SCENARIO_VALUES is referenced by following:
Description: | Scheduler requests. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_R_MESSAGE_TOKENS.MESSAGE_ID | CSF_R_SCHED_REQUESTS |
CSF_R_REQUEST_TASKS.SCHED_REQUEST_ID | CSF_R_SCHED_REQUESTS |
CSF.CSF_R_SCHED_REQUESTS does not reference any database object
CSF.CSF_R_SCHED_REQUESTS is referenced by following:
Description: | The table that contains the result(s) after the spares api is called |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_R_SPARES_OPTIONS.RESOURCE_RESULT_ID | CSF_R_RESOURCE_RESULTS |
CSF.CSF_R_SPARES_OPTIONS does not reference any database object
CSF.CSF_R_SPARES_OPTIONS is referenced by following:
Description: | Table to store the task assignment extensions |
---|
CSF.CSF_R_TASK_ASSIGN_EXTNS does not reference any database object
CSF.CSF_R_TASK_ASSIGN_EXTNS is referenced by following:
Description: | Table to store cache routes |
---|
CSF.CSF_R_TDS_ROUTE_CACHE does not reference any database object
CSF.CSF_R_TDS_ROUTE_CACHE is referenced by following:
Description: | Defines country profiles |
---|
Description: | Skill types |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_SKILLS_B.SKILL_TYPE_ID | CSF_SKILL_TYPES_B |
Foreign Key Column | Foreign Table |
---|---|
CSF_REQUIRED_SKILLS_B.SKILL_ID | CSF_SKILLS_B |
CSF_RESOURCE_SKILLS_B.SKILL_ID | CSF_SKILLS_B |
CSF.CSF_SKILLS_B does not reference any database object
CSF.CSF_SKILLS_B is referenced by following:
Description: | Skill types |
---|
CSF.CSF_SKILLS_TL does not reference any database object
CSF.CSF_SKILLS_TL is referenced by following:
Description: | Skill types |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_SKILL_LEVELS_B.RATING_SCALE_ID | CSF_RATING_SCALES_B |
Foreign Key Column | Foreign Table |
---|---|
CSF_REQUIRED_SKILLS_B.SKILL_LEVEL_ID | CSF_SKILL_LEVELS_B |
CSF_RESOURCE_SKILLS_B.SKILL_LEVEL_ID | CSF_SKILL_LEVELS_B |
CSF.CSF_SKILL_LEVELS_B does not reference any database object
CSF.CSF_SKILL_LEVELS_B is referenced by following:
Description: | Skill types |
---|
CSF.CSF_SKILL_LEVELS_TL does not reference any database object
CSF.CSF_SKILL_LEVELS_TL is referenced by following:
Description: | Skill types |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_SKILL_TYPES_B.RATING_SCALE_ID | CSF_RATING_SCALES_B |
Foreign Key Column | Foreign Table |
---|---|
CSF_REQUIRED_SKILLS_B.SKILL_TYPE_ID | CSF_SKILL_TYPES_B |
CSF_RESOURCE_SKILLS_B.SKILL_TYPE_ID | CSF_SKILL_TYPES_B |
CSF_SKILLS_B.SKILL_TYPE_ID | CSF_SKILL_TYPES_B |
CSF.CSF_SKILL_TYPES_B does not reference any database object
CSF.CSF_SKILL_TYPES_B is referenced by following:
Description: | Skill types |
---|
CSF.CSF_SKILL_TYPES_TL does not reference any database object
CSF.CSF_SKILL_TYPES_TL is referenced by following:
Description: | Defines the digital roadmap for route calculation. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_BINARY_TILES.BINARY_MAP_ID | CSF_TDS_BINARY_MAPS |
CSF.CSF_TDS_BINARY_MAPS does not reference any database object
CSF.CSF_TDS_BINARY_MAPS is referenced by following:
Description: | Defines a spatial index to a digital map. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_BINARY_TILES.BINARY_MAP_ID | CSF_TDS_BINARY_MAPS |
CSF.CSF_TDS_BINARY_TILES does not reference any database object
CSF.CSF_TDS_BINARY_TILES is referenced by following:
Description: | This table stores the conditions for the TDS. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_CONDITIONS.INTERVAL_ID | CSF_TDS_INTERVALS |
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_COND_SEGS.CONDITION_ID | CSF_TDS_CONDITIONS |
CSF.CSF_TDS_CONDITIONS does not reference any database object
CSF.CSF_TDS_CONDITIONS is referenced by following:
Description: | Intersection table for condition and segments |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_COND_SEGS.CONDITION_ID | CSF_TDS_CONDITIONS |
CSF_TDS_COND_SEGS.SEGMENT_ID | CSF_TDS_SEGMENTS |
CSF.CSF_TDS_COND_SEGS does not reference any database object
CSF.CSF_TDS_COND_SEGS is referenced by following:
Description: | The intervals table |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_CONDITIONS.INTERVAL_ID | CSF_TDS_INTERVALS |
CSF_TDS_RDBLCK_INTVLS.INTERVAL_ID | CSF_TDS_INTERVALS |
CSF_TDS_SEGMENTS.INTERVAL_ID | CSF_TDS_INTERVALS |
CSF.CSF_TDS_INTERVALS does not reference any database object
CSF.CSF_TDS_INTERVALS is referenced by following:
Description: | The nodes table |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_NODES.TILE_ID | CSF_TDS_TILES |
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_SEGM_NODES.NODE_ID | CSF_TDS_NODES |
Description: | Intersection table for Roadblocks and intervals |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_RDBLCK_INTVLS.INTERVAL_ID | CSF_TDS_INTERVALS |
CSF_TDS_RDBLCK_INTVLS.ROADBLOCK_ID | CSF_TDS_ROADBLOCKS |
CSF.CSF_TDS_RDBLCK_INTVLS does not reference any database object
CSF.CSF_TDS_RDBLCK_INTVLS is referenced by following:
Description: | The relation between RoadBlocks and Segments |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_RDBLCK_SGMNTS.ROADBLOCK_ID | CSF_TDS_ROADBLOCKS |
CSF_TDS_RDBLCK_SGMNTS.SEGMENT_ID | CSF_TDS_SEGMENTS |
CSF.CSF_TDS_RDBLCK_SGMNTS does not reference any database object
CSF.CSF_TDS_RDBLCK_SGMNTS is referenced by following:
Description: | Defines a travel duration delay for a segment. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_RDBLCK_INTVLS.ROADBLOCK_ID | CSF_TDS_ROADBLOCKS |
CSF_TDS_RDBLCK_SGMNTS.ROADBLOCK_ID | CSF_TDS_ROADBLOCKS |
CSF.CSF_TDS_ROADBLOCKS does not reference any database object
CSF.CSF_TDS_ROADBLOCKS is referenced by following:
Description: |
---|
Description: | Defines a connection between two nodes. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_SEGMENTS.INTERVAL_ID | CSF_TDS_INTERVALS |
CSF_TDS_SEGMENTS.TILE_ID | CSF_TDS_TILES |
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_COND_SEGS.SEGMENT_ID | CSF_TDS_SEGMENTS |
CSF_TDS_RDBLCK_SGMNTS.SEGMENT_ID | CSF_TDS_SEGMENTS |
CSF_TDS_SEGM_NODES.SEGMENT_ID | CSF_TDS_SEGMENTS |
CSF.CSF_TDS_SEGMENTS does not reference any database object
CSF.CSF_TDS_SEGMENTS is referenced by following:
Description: | Defines the relation between the segments and the nodes table |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_SEGM_NODES.NODE_ID | CSF_TDS_NODES |
CSF_TDS_SEGM_NODES.SEGMENT_ID | CSF_TDS_SEGMENTS |
CSF.CSF_TDS_SEGM_NODES does not reference any database object
CSF.CSF_TDS_SEGM_NODES is referenced by following:
Description: | Defines the result of spatial index creation (tiling). |
---|
Foreign Key Column | Foreign Table |
---|---|
CSF_TDS_NODES.TILE_ID | CSF_TDS_TILES |
CSF_TDS_SEGMENTS.TILE_ID | CSF_TDS_TILES |
APPS.CSF_ACCESS_HOURS_VL is not referenced by any database object
APPS.CSF_CT_TASKS is not referenced by any database object
APPS.CSF_DEBRIEF_EXP_LINES_V is not referenced by any database object
APPS.CSF_DEBRIEF_HEADERS_V is not referenced by any database object
APPS.CSF_DEBRIEF_LAB_LINES_V is not referenced by any database object
APPS.CSF_DEBRIEF_MAT_LINES_V is not referenced by any database object
APPS.CSF_DEBRIEF_SRC_NUMBERS_V is not referenced by any database object
APPS.CSF_DEBRIEF_TASKS_V is not referenced by any database object
APPS.CSF_DEBRIEF_TRANS_TYPES_V is not referenced by any database object
APPS.CSF_ESC_TASKS_V is not referenced by any database object
APPS.CSF_GNTICONS_SETUP_V is not referenced by any database object
APPS.CSF_L_SODS_V is not referenced by any database object
APPS.CSF_MAP_ACCESS_HOURS_VL is not referenced by any database object
APPS.CSF_PHONETIC_VALUES_VL is not referenced by any database object
APPS.CSF_PLAN_OPTIONS_V is not referenced by any database object
APPS.CSF_PLAN_TERRS_V is not referenced by any database object
APPS.CSF_PO_CONTACT_POINTS_V is not referenced by any database object
APPS.CSF_RATING_SCALES_VL is not referenced by any database object
APPS.CSF_REQUIRED_SKILLS_V is not referenced by any database object
APPS.CSF_RESOURCE_SKILLS_V is not referenced by any database object
APPS.CSF_RES_INV_ASSIGNMENTS_V is not referenced by any database object
APPS.CSF_SELECTED_RESOURCES_V is not referenced by any database object
APPS.CSF_SKILLS_VL is not referenced by any database object
APPS.CSF_SR_HIST_V is not referenced by any database object
APPS.CSF_VALIDATE_TASKS_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |