RC_PIN_VW1

(SQL View)
 Index Back

PIN for all Customers

This view shows all currently available PINS for all customers. Used in case search

SELECT H.SETID ,B.SETID ,H.PERSON_PIN ,%Substring(D.BO_NAME_DISPLAY,1,50) ,D.NAME_AC ,C.BO_NAME ,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 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)
6 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
7 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object