RC_PIN_VW4

(SQL View)
 Index Back

PINs for a Contact

This view shows all the currently available PINS for a Contact regardless of the customer. This is used only in Case search.

SELECT G.SETID ,B.SETID ,D.BO_ID ,H.PERSON_PIN ,%Substring(D.BO_NAME_DISPLAY,1,50) ,D.NAME_AC ,%Substring(C.BO_NAME_DISPLAY,1,50) ,C.BO_NAME_AC FROM PS_BC B , 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 H.BO_ID_CUST = B.BO_ID 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 SETID_ENTL Character(5) VARCHAR2(5) NOT NULL SetID
2 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
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)
7 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
8 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object