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]

TABLE: CSF.CSF_TDS_CONDITIONS

Object Details

Object Name:	CSF_TDS_CONDITIONS
Object Type:	TABLE
Owner:	CSF
FND Design Data:	CSF.CSF_TDS_CONDITIONS
Subobject Name:
Status:	VALID

DEFINITION
A Condition defines a specific restriction that applies to a road segment or to a combination of road segments. It can include Vehicles type for which the condition applies and time contraints for a condition.
EXAMPLE
Turn Restriction, access limited by a Gate, temporary change in Oneway information, Construction on a road during certain period of time.
MISCELLANEOUS

Storage Details

Tablespace:	APPS_TS_MEDIA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CONDITION_ID	NUMBER	(30)	Yes	Unique identifier for Condition Table
ACCESS_BUS	VARCHAR2	(3)	Yes	does condition apply to public buses?
ACCESS_BICYCLE	VARCHAR2	(3)	Yes	does condition apply to bicycles?
ACCESS_CARS	VARCHAR2	(3)	Yes	does condition apply to passenger cars?
ACCESS_TAXI	VARCHAR2	(3)	Yes	does condition apply to taxis?
ACCESS_CARPOOL	VARCHAR2	(3)	Yes	does condition apply to carpool cars?
ACCESS_DELIVERY	VARCHAR2	(3)	Yes	does condition apply to delivery trucks?
ACCESS_TRUCK	VARCHAR2	(3)	Yes	does condition apply to trucks?
ACCESS_EMERGENCY	VARCHAR2	(3)	Yes	does condition apply to emergency vehicles?
ACCESS_PEDESTRIAN	VARCHAR2	(3)	Yes	does condition apply to pedestrians?
ACCESS_THROUGH_TRAFFIC	VARCHAR2	(3)	Yes	can segment be used for through traffic?
BIN_INDEX	NUMBER			used to generate segment index for binary TDS file
CONDITION_TYPE	NUMBER	(1)	Yes	Defines the type of Conditions
NR_SEGMENT_INVOLVED	NUMBER	(2)	Yes	specifies how many roadsegment are involved in the condition
CONSTRUCTION_STATUS	NUMBER	(1)		specifies the type of construction (open or closed)
DIRECTION_OF_TRAFFIC	NUMBER	(1)		specifies the oneway information for a segment
INTERVAL_ID	NUMBER	(30)		Unique identifier for the Interval entity
SECURITY_GROUP_ID	NUMBER			Identifier used for running in hosted mode.

Query Text

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


SELECT CONDITION_ID
,      ACCESS_BUS
,      ACCESS_BICYCLE
,      ACCESS_CARS
,      ACCESS_TAXI
,      ACCESS_CARPOOL
,      ACCESS_DELIVERY
,      ACCESS_TRUCK
,      ACCESS_EMERGENCY
,      ACCESS_PEDESTRIAN
,      ACCESS_THROUGH_TRAFFIC
,      BIN_INDEX
,      CONDITION_TYPE
,      NR_SEGMENT_INVOLVED
,      CONSTRUCTION_STATUS
,      DIRECTION_OF_TRAFFIC
,      INTERVAL_ID
,      SECURITY_GROUP_ID
FROM CSF.CSF_TDS_CONDITIONS;

Dependencies

[top of page]

CSF.CSF_TDS_CONDITIONS does not reference any database object

CSF.CSF_TDS_CONDITIONS is referenced by following:

APPS: CSF_TDS_CONDITIONS