SYNCIDRD_PERS_CFG_VW(SQL View) |
Index Back |
|---|---|
RD_PERS_CFG_VWSELECT G.SYNCID , D.BO_NAME , B.BO_NAME FROM PS_RD_PERSON G , PS_BO D , PS_BO_REL A , PS_BO_NAME B WHERE A.START_DT <= %CurrentDateIn AND A.END_DT > %CurrentDateIn AND A.BO_ID_2 = D.BO_ID AND A.BO_ID_1 = G.BO_ID AND B.BO_ID = G.BO_ID AND B.PRIMARY_IND = 'Y' AND A.ROLE_TYPE_ID_1 = 8 AND A.ROLE_TYPE_ID_2 = 2 |
| SELECT G.SYNCID , D.BO_NAME , B.BO_NAME FROM PS_RD_PERSON G , PS_BO D , PS_BO_REL A , PS_BO_NAME B WHERE A.START_DT <= %CurrentDateIn AND A.END_DT > %CurrentDateIn AND A.BO_ID_2 = D.BO_ID AND A.BO_ID_1 = G.BO_ID AND B.BO_ID = G.BO_ID AND B.PRIMARY_IND = 'Y' AND A.ROLE_TYPE_ID_1 = 8 AND A.ROLE_TYPE_ID_2 = 2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SYNCID |
Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 2 | BO_NAME_CUST | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 3 | BO_NAME_CONTACT | Character(50) | VARCHAR2(50) NOT NULL | BO_NAME_CONTACT |