eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: CSF.CSF_TDS_SEGMENTS_NA#

Object Details

Object Name:	CSF_TDS_SEGMENTS_NA#
Object Type:	VIEW
Owner:	CSF
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SEGMENT_ID	NUMBER	(30)	Yes
FUNCTIONAL_CLASS	NUMBER	(1)	Yes
LENGTH	NUMBER		Yes
LANE_CATEGORY	NUMBER	(1)
ONEWAY_DIRECTION	NUMBER	(1)	Yes
ROAD_CONDITION	NUMBER	(1)
SPECIAL_RESTRICTIONS	NUMBER	(1)
TIME_ZONE	NUMBER
BRUNNEL_TYPE	NUMBER	(1)
AVERAGE_SPEED	NUMBER	(3)
BIN_INDEX	NUMBER
TOLL_ROAD	NUMBER	(1)	Yes
FERRY_TYPE	NUMBER	(1)
DIVIDED_ROAD_ELEMENT	NUMBER	(1)	Yes
DIVIDER_TYPE	NUMBER	(1)
ACCESS_CARS	VARCHAR2	(3)
ACCESS_BUS	VARCHAR2	(3)
ACCESS_TAXI	VARCHAR2	(3)
ACCESS_DELIVERY	VARCHAR2	(3)
ACCESS_TRUCK	VARCHAR2	(3)
ACCESS_EMERGENCY	VARCHAR2	(3)
ACCESS_PEDESTRIAN	VARCHAR2	(3)
ACCESS_BICYCLE	VARCHAR2	(3)
ACCESS_CARPOOL	VARCHAR2	(3)
ACCESS_THROUGH_TRAFFIC	VARCHAR2	(3)
TILE_ID	NUMBER	(30)
INTERVAL_ID	NUMBER	(30)
SECURITY_GROUP_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SEGMENT_ID
,      FUNCTIONAL_CLASS
,      LENGTH
,      LANE_CATEGORY
,      ONEWAY_DIRECTION
,      ROAD_CONDITION
,      SPECIAL_RESTRICTIONS
,      TIME_ZONE
,      BRUNNEL_TYPE
,      AVERAGE_SPEED
,      BIN_INDEX
,      TOLL_ROAD
,      FERRY_TYPE
,      DIVIDED_ROAD_ELEMENT
,      DIVIDER_TYPE
,      ACCESS_CARS
,      ACCESS_BUS
,      ACCESS_TAXI
,      ACCESS_DELIVERY
,      ACCESS_TRUCK
,      ACCESS_EMERGENCY
,      ACCESS_PEDESTRIAN
,      ACCESS_BICYCLE
,      ACCESS_CARPOOL
,      ACCESS_THROUGH_TRAFFIC
,      TILE_ID
,      INTERVAL_ID
,      SECURITY_GROUP_ID
FROM CSF.CSF_TDS_SEGMENTS_NA#;

Dependencies

[top of page]

CSF.CSF_TDS_SEGMENTS_NA# references the following:

CSF: CSF_TDS_SEGMENTS_NA

CSF.CSF_TDS_SEGMENTS_NA# is referenced by following:

APPS: CSF_TDS_SEGMENTS_NA