RC_SIN_VW (SQL View)	Index Back
SIN for a Customer Currently Available SIN's for a Customer. Used in BO search Setup

RC_SIN_VW

(SQL View)

SIN for a Customer

Currently Available SIN's for a Customer. Used in BO search Setup

SELECT C.BO_ID , A.BO_ID_CUST , A.SIN FROM PS_RF_AG_VAL_SITES A , PS_RF_AGREEMENT B , PS_RD_SITE C WHERE A.SETID = B.SETID 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.AGREEMENT_CODE = B.AGREEMENT_CODE AND A.AGR_RENEWAL_NUM = B.AGR_RENEWAL_NUM AND A.SETID = C.SETID AND A.SITE_ID = C.SITE_ID AND A.SIN <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

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

3 SIN Character(40) VARCHAR2(40) NOT NULL This field is used to represent the Site Identification Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
3	SIN	Character(40)	VARCHAR2(40) NOT NULL	This field is used to represent the Site Identification Number