OCD_FINISHBP_VW (SQL View)	Index Back
business project finish time This is a dashboard view of the time a business project finished.

OCD_FINISHBP_VW

(SQL View)

business project finish time

This 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.

#	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.