RD_PLNOW_DST_VW(SQL View) |
Index Back |
---|---|
Account as Plan Owner ViewThis is a view lists out all the account as Plan Owner View. |
SELECT A.SYNCID , P.PERSON_ID FROM PS_BO_ROLE A , PS_RSP_TP_HEADER B , PS_RSP_TP_TEAM C , PS_RD_PERSON P WHERE A.BO_ID = B.BO_ID AND B.RSP_UID20 = C.RSP_UID20 AND C.BO_ID_PERSON = P.BO_ID AND C.OWNER = 'Y' |
# | 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 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |