[Home] [Help] [Dependency Information]
Object Name: | CSF_LF_PLACE_POSTCS_EU |
---|---|
Object Type: | TABLE |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
DEFINITION
Intersection table required since one Postcode can be located in multiple Places, and one Place can have multiple Postcodes.
EXAMPLE
MISCELLANEOUS
The information is retrieved from the GDF3.0 relations 1018 and 1009.
Relation Place-Postcode will only be available for Settlement and Municipality Place level.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLACE_POSTCODE_ID | NUMBER | (30) | Yes | Unique identifier for the Place Postcode table |
PLACE_ID | NUMBER | (30) | Yes | Unique key that identifies the place |
POSTAL_CODE_ID | NUMBER | (30) | Yes | Primary key for the Postal Code table |
SECURITY_GROUP_ID | NUMBER | Identifier used for running in hosted mode |
Cut, paste (and edit) the following text to query this object:
SELECT PLACE_POSTCODE_ID
, PLACE_ID
, POSTAL_CODE_ID
, SECURITY_GROUP_ID
FROM CSF.CSF_LF_PLACE_POSTCS_EU;
CSF.CSF_LF_PLACE_POSTCS_EU does not reference any database object
CSF.CSF_LF_PLACE_POSTCS_EU is referenced by following:
|
|
|