DP_PUBFCDATE_VW (SQL View)	Index Back
list pub dates for pub fcast used as prompt table for pub forecast pub-dates

DP_PUBFCDATE_VW

(SQL View)

list pub dates for pub fcast

used as prompt table for pub forecast pub-dates

SELECT A.DP_PUBLISHNAME , A.DP_PUBLISH_DATE FROM PS_DP_PUB_FCAST A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name

2 DP_PUBLISH_DATE Date(10) DATE DP_PUBLISH_DATE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DP_PUBLISHNAME	Character(20)	VARCHAR2(20) NOT NULL	Publish Name
2	DP_PUBLISH_DATE	Date(10)	DATE	DP_PUBLISH_DATE