BO_IDROLE_TYPE_IDRC_PINRL_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 9 WHEN H.BO_ID_CONTACT <> H.BO_ID_CUST THEN 8 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 |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | ROLE_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 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 |