SETID_ENTLSETID_CUSTOMERSINRC_SIN_VW1(SQL View) |
Index Back |
|---|---|
SIN for a CustomerCurrently Available SIN's for a Customer |
| SELECT A.SETID , D.SETID , A.SIN , %Substring(E.BO_NAME_DISPLAY,1,50) , E.BO_NAME_AC , %Substring(F.BO_NAME_DISPLAY,1,50) , F.BO_NAME_AC FROM PS_RF_AG_VAL_SITES A , PS_RF_AGREEMENT B , PS_RD_SITE C , PS_BC D , PS_BO_NAME E , PS_BO_NAME F 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.BO_ID_CUST = D.BO_ID AND D.BO_ID = E.BO_ID AND E.PRIMARY_IND = 'Y' AND C.BO_ID = F.BO_ID AND F.PRIMARY_IND = 'Y' |
| # | 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 | SIN |
Character(40) | VARCHAR2(40) NOT NULL | This field is used to represent the Site Identification Number |
| 4 | NAME1 | Character(50) | VARCHAR2(50) NOT NULL | Generic 50 character name field for storing names. |
| 5 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name (Alternate Character) |
| 6 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 7 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |