RBG_CUST_ADD_VW (SQL View)	Index Back
RBG_CUST_ADD_VW This view gets the address of Customer associated with Case transactions.

RBG_CUST_ADD_VW

(SQL View)

RBG_CUST_ADD_VW

This view gets the address of Customer associated with Case transactions.

SELECT A.BUSINESS_UNIT , A.CASE_ID , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , E.ADDRESS1 , E.CITY , E.COUNTRY , E.STATE , E.POSTAL , E.LATITUDE , E.LONGITUDE , %subrec(RB_AUDIT_SBR, A) FROM PS_RC_CASE A , PS_BO_SRCH_ADD E WHERE E.BO_ID = A.BO_ID_CUST AND E.PROFILE_CM_SEQ = A.PROFILE_CM_SEQ_ADD AND E.BO_CM_USE_TYPE = 'R' AND E.PRIMARY_IND = 'Y' AND E.ROLE_TYPE_ID = A.ROLE_TYPE_ID_CUST AND E.LATITUDE <> 0 AND E.LONGITUDE <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_RC_VR_NONVW

2 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.

3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

4 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

5 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other

6 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other

7 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
Prompt Table: COUNTRY_TBL

8 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

9 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other

10 LATITUDE Signed Number(32,20) DECIMAL(30,20) NOT NULL LATITUDE

11 LONGITUDE Signed Number(32,20) DECIMAL(30,20) NOT NULL LONGITUDE

12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

15 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

16 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

17 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_RC_VR_NONVW
2	CASE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
3	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
4	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
5	ADDRESS1_OTHER	Character(55)	VARCHAR2(55) NOT NULL	Address 1 Other
6	CITY_OTHER	Character(30)	VARCHAR2(30) NOT NULL	City Other
7	COUNTRY_OTHER	Character(3)	VARCHAR2(3) NOT NULL	Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT Prompt Table: COUNTRY_TBL
8	STATE_OTHER	Character(6)	VARCHAR2(6) NOT NULL	State Other
9	POSTAL_OTHER	Character(12)	VARCHAR2(12) NOT NULL	Postal Other
10	LATITUDE	Signed Number(32,20)	DECIMAL(30,20) NOT NULL	LATITUDE
11	LONGITUDE	Signed Number(32,20)	DECIMAL(30,20) NOT NULL	LONGITUDE
12	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
13	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
14	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
15	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
16	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
17	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time