RC_PIN_VW3 (SQL View)	Index Back
PIN for a Customer/Contact This view shows only the currently available PINs for a specific contact at a specific customer. Used in case search and the case component.

RC_PIN_VW3

(SQL View)

PIN for a Customer/Contact

This view shows only the currently available PINs for a specific contact at a specific customer. Used in case search and the case component.

SELECT C.BO_ID , D.BO_ID , H.PERSON_PIN , %Substring(D.BO_NAME_DISPLAY,1,50) , D.NAME_AC FROM PS_BO_NAME C , PS_BO_NAME D , PS_RF_AGREEMENT G , PS_RF_AGR_CONTACT H WHERE C.PRIMARY_IND = 'Y' AND D.PRIMARY_IND = 'Y' AND G.AGRT_STATUS = '005' AND G.END_DT >= %CurrentDateIn AND G.START_DT <= %CurrentDateIn AND G.SETID = H.SETID AND G.AGREEMENT_CODE = H.AGREEMENT_CODE AND G.AGR_RENEWAL_NUM = H.AGR_RENEWAL_NUM AND H.BO_ID_CUST = C.BO_ID AND H.BO_ID_CONTACT = D.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

3 PERSON_PIN Character(40) VARCHAR2(40) NOT NULL This field is used to store the Personal Identification Number of a person for use in agreements

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

5 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
2	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
3	PERSON_PIN	Character(40)	VARCHAR2(40) NOT NULL	This field is used to store the Personal Identification Number of a person for use in agreements
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name (Alternate Character)