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

TABLE: CSF.CSF_LF_NAMES

Object Details
Object Name: CSF_LF_NAMES
Object Type: TABLE
Owner: CSF
FND Design Data: TableCSF.CSF_LF_NAMES
Subobject Name:
Status: VALID


DEFINITION
The Name Table includes all Name information for: RoadSegment, POI and Place.
EXAMPLE
MISCELLANEOUS
The Name table will have multiple entries when an entity has multiple names. Therefore the Name table includes all available Official, Alternate, Stale, Vanity names for entities.


Storage Details
Tablespace: TablespaceAPPS_TS_MEDIA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
NAME_ID NUMBER (30) Yes Unique key for Name
NAME VARCHAR2 (70) Yes Actual name of the entity (Streetname, POI name, Place name)
LANGUAGE_CODE VARCHAR2 (3)
3 letter MARC language code for name
JUNCTION_NAME VARCHAR2 (3)
Is Name a Junction Name?
EXIT_NUMBER VARCHAR2 (3)
Is Name an Exit Number?
ROUTE_TYPE NUMBER

Indication of Route Number level (only for Route Nrs.)
PREFIX VARCHAR2 (1)
Prefix for Street Name (e.g. E, W; US only)
BASE_NAME VARCHAR2 (240)
Base Name of Street Name (e.g. 'High' in High Street)
STREET_TYPE VARCHAR2 (35)
Street Type of Street Name (e.g. 'Street' in High Street)
STREET_TYPE_ATTACHED VARCHAR2 (1)
Street Type attached to Base Name?
STREET_TYPE_BEFORE_BASE VARCHAR2 (1)
Street Type before Base Name?
SUFFIX VARCHAR2 (1)
Suffix of Street Name (e.g. N, W; US only)
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 NAME_ID
,      NAME
,      LANGUAGE_CODE
,      JUNCTION_NAME
,      EXIT_NUMBER
,      ROUTE_TYPE
,      PREFIX
,      BASE_NAME
,      STREET_TYPE
,      STREET_TYPE_ATTACHED
,      STREET_TYPE_BEFORE_BASE
,      SUFFIX
,      SECURITY_GROUP_ID
FROM CSF.CSF_LF_NAMES;

Dependencies

[top of page]

CSF.CSF_LF_NAMES does not reference any database object

CSF.CSF_LF_NAMES is referenced by following:

SchemaAPPS
SynonymCSF_LF_NAMES