RSFM_USER_BU_VW(SQL View) |
Index Back |
---|---|
Mobile Sales UserMobile Sales User. Used by Mobile Sales. |
SELECT A.PERSON_ID , O.OPRID , A.BUSINESS_UNIT , P.SETID , P.BO_ID , P.SYNCID , P.SYNCDTTM FROM PS_RSF_SUSER A , PS_RD_COMPANY P , PS_BO_BASIC_ORG B , PS_SET_CNTRL_REC SC , PSOPRALIAS O WHERE A.BUSINESS_UNIT = SC.SETCNTRLVALUE AND SC.SETID = P.SETID AND SC.RECNAME = 'RD_COMPANY' AND A.PERSON_ID = O.PERSON_ID AND P.BO_ID=B.BO_ID AND B.BO_REL_ID=0 AND B.ROLE_TYPE_ID=2 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(15) | VARCHAR2(15) NOT NULL | Person ID | |
2 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
3 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
4 | SETID_CUSTOMER | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
5 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
6 | 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. |
7 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |