RO_SITECM_CADDR (SQL View)	Index Back
Site Current Addresses Gets all site current addresses ala BO_SITECM_CADDR. However, this view also includes anonymous sites (sites where BO_ID_PARENT=0). BO_SITECM_CADDR does not include anonymous sites.

RO_SITECM_CADDR

(SQL View)

Site Current Addresses

Gets all site current addresses ala BO_SITECM_CADDR. However, this view also includes anonymous sites (sites where BO_ID_PARENT=0). BO_SITECM_CADDR does not include anonymous sites.

SELECT DISTINCT A.SETID , A.SITE_ID , B.PROFILE_CM_SEQ , B.CM_USE_START_DT , A.BO_ID , B.ROLE_TYPE_ID , A.BO_ID_PARENT , B.BO_CM_START_DT , B.BO_CM_END_DT , B.CM_USE_END_DT , B.CM_TYPE_ID , B.CM_ID , B.PRIMARY_IND , B.CM_NICKNAME , B.CM_PURPOSE_TYPE_ID , B.PHYSICAL_LOCATION , %subrec(CM_ADDRESS_SBR, B) FROM PS_RD_SITE A , PS_BO_ROLECM_ADDR B WHERE A.BO_ID = B.BO_ID AND B.ROLE_TYPE_ID = 3 AND B.BO_CM_START_DT <= %CurrentDateIn AND B.BO_CM_END_DT > %CurrentDateIn AND B.CM_USE_START_DT <= %CurrentDateIn AND B.CM_USE_END_DT > %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

3 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

4 CM_USE_START_DT Date(10) DATE Contact Method Use Start Date

5 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

6 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

7 BO_ID_PARENT Number(31,0) DECIMAL(31) NOT NULL Business Object ID of the Parent Company.

8 BO_CM_START_DT Date(10) DATE The date that a Contact Method of a Business Object takes effect.

9 BO_CM_END_DT Date(10) DATE End date of a Contact Method of a Business Object

10 CM_USE_END_DT Date(10) DATE End date of a Contact Method Use

11 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID

12 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

13 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes

14 CM_NICKNAME Character(30) VARCHAR2(30) NOT NULL Nickname of a Contact Method

15 CM_PURPOSE_TYPE_ID Number(6,0) INTEGER NOT NULL Relationship Contact Method Purpose ID
Prompt Table: CM_PURP_TYPE

16 PHYSICAL_LOCATION Character(30) VARCHAR2(30) NOT NULL Physical Location (Free-Form)

17 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

18 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

19 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

20 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

21 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

22 CITY Character(30) VARCHAR2(30) NOT NULL City

23 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

24 NUM2 Character(4) VARCHAR2(4) NOT NULL Number 2

25 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference

26 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

27 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

28 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

29 COUNTY Character(30) VARCHAR2(30) NOT NULL County

30 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

31 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

32 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

33 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit
Default Value: Y

34 CROSS_STREET_1 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location

35 CROSS_STREET_2 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location

36 ADDRESS_SUB_TYPE Character(4) VARCHAR2(4) NOT NULL Address Sub Type Field
ADDR=Address
INT=Intersection
Default Value: ADDR

37 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS1_AC

38 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS3_AC

39 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS2_AC

40 ADDRESS4_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 4.

41 CITY_AC Character(30) VARCHAR2(30) NOT NULL CITY_AC

42 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
Prompt Table: RD_REGION_VW

43 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
Prompt Table: PSTIMEZONE

44 CM_ID_PHONE Number(31,0) DECIMAL(31) NOT NULL CM_ID_PHONE
Prompt Table: CM_PHONE

45 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	SITE_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	PROFILE_CM_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
4	CM_USE_START_DT	Date(10)	DATE	Contact Method Use Start Date
5	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
6	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
7	BO_ID_PARENT	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID of the Parent Company.
8	BO_CM_START_DT	Date(10)	DATE	The date that a Contact Method of a Business Object takes effect.
9	BO_CM_END_DT	Date(10)	DATE	End date of a Contact Method of a Business Object
10	CM_USE_END_DT	Date(10)	DATE	End date of a Contact Method Use
11	CM_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Contact Method Type ID
12	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
13	PRIMARY_IND	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether or not it is Primary N=No Y=Yes
14	CM_NICKNAME	Character(30)	VARCHAR2(30) NOT NULL	Nickname of a Contact Method
15	CM_PURPOSE_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Relationship Contact Method Purpose ID Prompt Table: CM_PURP_TYPE
16	PHYSICAL_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Physical Location (Free-Form)
17	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
18	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
19	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
20	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
21	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
22	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
23	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
24	NUM2	Character(4)	VARCHAR2(4) NOT NULL	Number 2
25	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
26	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
27	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
28	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
29	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
30	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
31	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
32	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
33	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit Default Value: Y
34	CROSS_STREET_1	Character(50)	VARCHAR2(50) NOT NULL	Cross Street of a location
35	CROSS_STREET_2	Character(50)	VARCHAR2(50) NOT NULL	Cross Street of a location
36	ADDRESS_SUB_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Sub Type Field ADDR=Address INT=Intersection Default Value: ADDR
37	ADDRESS1_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS1_AC
38	ADDRESS3_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS3_AC
39	ADDRESS2_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS2_AC
40	ADDRESS4_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 4.
41	CITY_AC	Character(30)	VARCHAR2(30) NOT NULL	CITY_AC
42	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value. Prompt Table: RD_REGION_VW
43	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
44	CM_ID_PHONE	Number(31,0)	DECIMAL(31) NOT NULL	CM_ID_PHONE Prompt Table: CM_PHONE
45	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code