RC_PIN_VW5 (SQL View)	Index Back
PIN for a Consumer This view shows all the currently valid PINS for a Consumer. Used in Case Search.

RC_PIN_VW5

(SQL View)

PIN for a Consumer

This view shows all the currently valid PINS for a Consumer. Used in Case Search.

SELECT G.SETID ,B.SETID ,B.BO_ID ,H.PERSON_PIN ,%Substring(D.BO_NAME_DISPLAY,1,50) ,D.NAME_AC FROM PS_BC B , PS_BO_NAME D , PS_RF_AGREEMENT G , PS_RF_AGR_CONTACT H WHERE B.BO_ID = D.BO_ID AND D.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 = B.BO_ID AND H.BO_ID_CONTACT = B.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID_ENTL Character(5) VARCHAR2(5) NOT NULL SetID

2 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID

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

4 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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID_ENTL	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SETID_CUSTOMER	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
3	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
4	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
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name (Alternate Character)