[Home] [Help] [Dependency Information]
Object Name: | CSI_II_GEOLOC_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | CSI |
Subobject Name: | |
Status: | VALID |
This table contains interface information to import geocode details for item instances
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSI_II_GEOLOC_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INSTANCE_NUMBER |
CSI_II_GEOLOC_INTERFACE_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GEOCODE_FORMAT |
CSI_II_GEOLOC_INTERFACE_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PROCESS_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTANCE_NUMBER | VARCHAR2 | (30) | Yes | Instance Number to be imported |
GEOCODE_FORMAT | VARCHAR2 | (3) | 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 |
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;
CSI.CSI_II_GEOLOC_INTERFACE does not reference any database object
CSI.CSI_II_GEOLOC_INTERFACE is referenced by following:
|
|
|