OCD_FINISHBP_VW(SQL View) |
Index Back |
|---|---|
business project finish timeThis is a dashboard view of the time a business project finished. |
| SELECT activ.BUS_PROC_INSTANCE , MAX(activ.ROW_LASTMANT_DTTM) FROM PS_RC_ACTIV_STATUS activ GROUP BY activ.BUS_PROC_INSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUS_PROC_INSTANCE | Number(18,0) | DECIMAL(18) NOT NULL | Business Project Instance. This is the Business Project instance of a business project. |
| 2 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |