RDM_BASIC_IND_V(SQL View) |
Index Back |
|---|---|
BO Basic Ind ViewThis view is to get all individual BOs of role type 4, 8, and 9 from the BASIC table. It is used as a base view for the other two views, RDM_PRSN_SRCHVW and RDM_PRSN_SYNC_V. They are all used in mobile. |
| SELECT BO_ID , MAX(SYNCDTTM) FROM PS_BO_BASIC_IND WHERE ROLE_TYPE_ID IN (4,8,9) GROUP BY BO_ID |
| # | 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 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |