SAD_CRM_BOID_VW(SQL View) |
Index Back |
|---|---|
CRM/SA integration EMPLID/BOIDThis view is used by the Application Message CS_STUDENT_BOID_SYNC to retrive the mapping of the EMPLID and BO_ID from the TS189 Staging tables. It will select the records that have been posted via the TS189 People S/M/P process. |
| SELECT DISTINCT A.EMPLID , C.BO_ID FROM PS_ADM_T189_PER_EC A , PS_ADM_T189_FOS_EC B , PS_ADM_T189_CRM_EC C WHERE A.ECTRANSID = B.ECTRANSID AND B.ECTRANSID = C.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND B.ECQUEUEINSTANCE = C.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND B.ECTRANSINOUTSW = C.ECTRANSINOUTSW AND A.TRANS_CNTRL_NBR = B.TRANS_CNTRL_NBR AND B.TRANS_CNTRL_NBR = C.TRANS_CNTRL_NBR AND A.RELATIONSHIP_NBR = 1 AND B.APP_PST = 'Y' AND C.POSTED_FLAG = 'N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | BO Id |