BO_ID_1BO_ID_2RC_PINREL_VW(SQL View) |
Index Back |
|---|---|
PIN Role ViewPIN View for BO Search Setup. It brings BO_ID of agreement contact. |
| SELECT H.BO_ID_CONTACT ,CASE WHEN H.BO_ID_CONTACT = H.BO_ID_CUST THEN 0 WHEN H.BO_ID_CONTACT <> H.BO_ID_CUST THEN H.BO_ID_CUST END ,H.PERSON_PIN FROM PS_RF_AGREEMENT G , PS_RF_AGR_CONTACT H WHERE 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 PERSON_PIN <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_1 |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 1 |
| 2 | BO_ID_2 |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 2 |
| 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 |