SCC_STG_CON_VW

(SQL View)
 Index Back

Constituent Ovwrall View

Constituent Ovwrall View

SELECT A.SCC_TEMP_ID , A.USERID , A.EMPLID , A.SCC_TRANSAC_CD , A.BIRTHDATE , A.BIRTHPLACE , A. BIRTHSTATE , A.BIRTHCOUNTRY , A.DT_OF_DEATH , E.NAME , E.LAST_NAME , E.FIRST_NAME ,E.MIDDLE_NAME , B.COUNTRY , B.ADDRESS1 , B.ADDRESS2 , B.ADDRESS3 , B.ADDRESS4 , B.CITY , B.NUM1 , B.NUM2 , B.HOUSE_TYPE , B.ADDR_FIELD1 , B.ADDR_FIELD2 , B.ADDR_FIELD3 , B.COUNTY , B.STATE , B.POSTAL , B.GEO_CODE , B.IN_CITY_LIMIT , D.EMAIL_ADDR , C.COUNTRY_CODE , C.PHONE FROM PS_SCC_STG_CONSTIT A LEFT OUTER JOIN PS_SCC_STG_ADDR B ON (A.SCC_TEMP_ID = B.SCC_TEMP_ID) LEFT OUTER JOIN PS_SCC_STG_PHONE C ON (A.SCC_TEMP_ID = C.SCC_TEMP_ID) LEFT OUTER JOIN PS_SCC_STG_EMAIL D ON (A.SCC_TEMP_ID = D.SCC_TEMP_ID) LEFT OUTER JOIN PS_SCC_STG_NAMES E ON (A.SCC_TEMP_ID = E.SCC_TEMP_ID) WHERE E.NAME_TYPE = 'PRI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
2 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

4 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction

Prompt Table: SCC_TRNSAC_DTLS

5 BIRTHDATE Date(10) DATE Date of Birth
6 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
7 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State
8 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
9 DT_OF_DEATH Date(10) DATE Date of Death
10 NAME Character(50) VARCHAR2(50) NOT NULL Name
11 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
12 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
13 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

15 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
16 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
17 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
18 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
19 CITY Character(30) VARCHAR2(30) NOT NULL City
20 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
21 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
22 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
23 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
24 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
25 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
26 COUNTY Character(30) VARCHAR2(30) NOT NULL County
27 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

28 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
29 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
30 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

31 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
32 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
33 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone