CM_GEO_ERR_VW

(SQL View)
 Index Back

Geo Code Error Log View


SELECT A.CM_ID , B.GEO_ERROR_STATUS , A.ADDRESS_SUB_TYPE , A.ADDRESS1 , A.ADDRESS2 , A.CROSS_STREET_1 , A.CROSS_STREET_2 , A.CITY , A.POSTAL , A.STATE , A.COUNTRY , A.LATITUDE , A.LONGITUDE , B.ROW_ADDED_OPRID , B.ROW_ADDED_DTTM , B.DESCR100 FROM PS_CM_GEO_ERR_LOG B , PS_CM_ADDRESS A WHERE A.CM_ID = B.CM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID
2 GEO_ERROR_STATUS Character(4) VARCHAR2(4) NOT NULL Geo Code Error Status
ERR=Error
RES=Fixed
3 ADDRESS_SUB_TYPE Character(4) VARCHAR2(4) NOT NULL Address Sub Type Field
ADDR=Address
INT=Intersection
4 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
5 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
6 CROSS_STREET_1 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location
7 CROSS_STREET_2 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location
8 CITY Character(30) VARCHAR2(30) NOT NULL City
9 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
10 STATE Character(6) VARCHAR2(6) NOT NULL State
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
12 LATITUDE Signed Number(32,20) DECIMAL(30,20) NOT NULL LATITUDE
13 LONGITUDE Signed Number(32,20) DECIMAL(30,20) NOT NULL LONGITUDE
14 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
15 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
16 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description