EP_CUR_DOCS_VW (SQL View)	Index Back
Current Documents Dates Used to set default period begin and end dates.

EP_CUR_DOCS_VW

(SQL View)

Current Documents Dates

Used to set default period begin and end dates.

SELECT A1.EP_APPRAISAL_ID , A1.EP_MANAGER_ID , A1.PERIOD_BEGIN_DT , A1.PERIOD_END_DT FROM PS_EP_APPR A1 WHERE (A1.EP_REVIEW_STATUS <> 'CO' AND A1.EP_REVIEW_STATUS <> 'CA')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID

2 EP_MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager/Mentor ID.

3 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date

4 PERIOD_END_DT Date(10) DATE Period End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
2	EP_MANAGER_ID	Character(11)	VARCHAR2(11) NOT NULL	Manager/Mentor ID.
3	PERIOD_BEGIN_DT	Date(10)	DATE	Period Begin Date
4	PERIOD_END_DT	Date(10)	DATE	Period End Date