TRN_CUST_EF_VW

(SQL View)
 Index Back

Customer Current Addresses


SELECT a.setid , a.cust_id , a.address_seq_num , a.descr , b.city , b.state , b.postal , b.country , b.address1 , b.address2 , b.address3 , b.address4 , b.county , %subrec(bus_phone_sbr,b) , b.alt_name1 , b.alt_name2 , b.language_cd , b.last_maint_oprid FROM ps_cust_addr_seq a , PS_CUST_ADDRESS b WHERE a.setid = b.setid AND a.cust_id= b.cust_id AND a.address_seq_num = b.address_seq_num AND b.effdt = ( SELECT MAX(effdt) FROM PS_CUST_ADDRESS WHERE setid=b.setid AND cust_id=b.cust_id AND address_seq_num=b.address_seq_num AND effdt <= %CurrentDateIn AND eff_status='A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL To Customer ID
3 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 CITY Character(30) VARCHAR2(30) NOT NULL City
6 STATE Character(6) VARCHAR2(6) NOT NULL State
7 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
9 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
10 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
11 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
12 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
13 COUNTY Character(30) VARCHAR2(30) NOT NULL County
14 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
15 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
16 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
17 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
18 ALT_NAME1 Character(40) VARCHAR2(40) NOT NULL Alternate Name 1
19 ALT_NAME2 Character(40) VARCHAR2(40) NOT NULL Alternate Name 2
20 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
21 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID