Skip to content

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

TABLE: CSI.CSI_II_GEOLOC_INTERFACE

Object Details
Object Name: CSI_II_GEOLOC_INTERFACE
Object Type: TABLE
Owner: CSI
Subobject Name:
Status: VALID


This table contains interface information to import geocode informatin of item instances.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSI_II_GEOLOC_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINSTANCE_NUMBER
CSI_II_GEOLOC_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGEOCODE_FORMAT
CSI_II_GEOLOC_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_FLAG
Columns
Name Datatype Length Mandatory Comments
INSTANCE_NUMBER VARCHAR2 (30) Yes Instance Number to be imported
GEOCODE_FORMAT VARCHAR2 (3) Yes Geocode format in which the data is entetred.Can be 'DD' , 'DM' or 'DMS' format
INST_LATITUDE VARCHAR2 (50) Yes Latitude information.The format used should be as indicated in GEOCODE_FORMAT column
INST_LONGITUDE VARCHAR2 (50) Yes Longitude information.The format used should be as indicated in GEOCODE_FORMAT column
PROCESS_FLAG VARCHAR2 (1) Yes Marks the current record status.'R' - Ready, 'P' - Processed,'E' -Errored
ERROR_MESSAGE VARCHAR2 (4000)
Error if any during importing
PROCESS_DATE DATE

The date when data in current row was last processed
Query Text

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


SELECT INSTANCE_NUMBER
,      GEOCODE_FORMAT
,      INST_LATITUDE
,      INST_LONGITUDE
,      PROCESS_FLAG
,      ERROR_MESSAGE
,      PROCESS_DATE
FROM CSI.CSI_II_GEOLOC_INTERFACE;

Dependencies

[top of page]

CSI.CSI_II_GEOLOC_INTERFACE does not reference any database object

CSI.CSI_II_GEOLOC_INTERFACE is referenced by following:

SchemaCSI
ViewCSI_II_GEOLOC_INTERFACE#