RX_REP_CUST_VW (SQL View)	Index Back
Self-service representative This record contains all fields required to authenticate which company the representative will self-register for.

RX_REP_CUST_VW

(SQL View)

Self-service representative

This record contains all fields required to authenticate which company the representative will self-register for.

SELECT A.RX_CUST_KEY , B.BO_NAME FROM PS_RX_REP_REG_CUST A , PS_BO_NAME b WHERE A.BO_ID_CUST = B.BO_ID AND b.PRIMARY_IND='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RX_CUST_KEY Character(12) VARCHAR2(12) NOT NULL Password for self-service representative to register.

2 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RX_CUST_KEY	Character(12)	VARCHAR2(12) NOT NULL	Password for self-service representative to register.
2	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object