RC_SIN_VW2 (SQL View)	Index Back
SIN for a Customer/Role Currently available SIN's for a Customer/Role

RC_SIN_VW2

(SQL View)

SIN for a Customer/Role

Currently available SIN's for a Customer/Role

SELECT B.BO_ID_CUST , A.SIN , %Substring(D.BO_NAME_DISPLAY,1,50) , D.BO_NAME_AC FROM PS_RF_AG_VAL_SITES A , PS_RF_AGREEMENT B , PS_BO_NAME D WHERE A.SETID = B.SETID AND A.AGREEMENT_CODE = B.AGREEMENT_CODE AND A.AGR_RENEWAL_NUM = B.AGR_RENEWAL_NUM AND A.BO_ID_CUST = B.BO_ID_CUST AND B.AGRT_STATUS = '005' AND B.END_DT >= %CurrentDateIn AND B.START_DT <= %CurrentDateIn AND A.BO_ID_CUST = D.BO_ID AND D.PRIMARY_IND = 'Y'

# 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 SIN Character(40) VARCHAR2(40) NOT NULL This field is used to represent the Site Identification Number

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

4 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

#	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	SIN	Character(40)	VARCHAR2(40) NOT NULL	This field is used to represent the Site Identification Number
3	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
4	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object