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

TABLE: CSF.CSF_LF_POI_NAMES_NA

Object Details
Object Name: CSF_LF_POI_NAMES_NA
Object Type: TABLE
Owner: CSF
Subobject Name:
Status: VALID


DEFINITION
Intersection table required since one POI can have multiple names (i.e. Exoonyms, Synonyms) and one Name can be shared by multiple POIs (e.g. Shell, Holiday Inn).
EXAMPLE
MISCELLANEOUS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
POI_NAME_ID NUMBER (30) Yes Surrogate key used for primary unique identifiers
NAME_TYPE VARCHAR2 (1) Yes Indication if name is used as Official or Alternate Name for POI
POI_ID NUMBER (30) Yes Unique identifier for POI Table
NAME_ID NUMBER (30) Yes Unique key for Name
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 POI_NAME_ID
,      NAME_TYPE
,      POI_ID
,      NAME_ID
,      SECURITY_GROUP_ID
FROM CSF.CSF_LF_POI_NAMES_NA;

Dependencies

[top of page]

CSF.CSF_LF_POI_NAMES_NA does not reference any database object

CSF.CSF_LF_POI_NAMES_NA is referenced by following:

SchemaAPPS
SynonymCSF_LF_POI_NAMES_NA