EP_PRF_NOTES_VW

(SQL View)

SELECT A.EP_REVIEWER_ID ,A.EMPLID ,A.DATETIME_STAMP ,B.NAME ,C.NAME ,A.EP_COMMENTS FROM PS_EP_PERF_NOTES A , PS_PERSON_NAME B , PS_PERSON_NAME C WHERE A.EP_REVIEWER_ID = B.EMPLID AND A.EMPLID = C.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID
Prompt Table: EP_REVWR_ID_VW

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

3 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

4 EP_REVIEWER_NAME Character(50) VARCHAR2(50) NOT NULL Author

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

6 EP_COMMENTS Long Character CLOB Comments field used for documenting performance notes.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID Prompt Table: EP_REVWR_ID_VW
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
3	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
4	EP_REVIEWER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Author
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	EP_COMMENTS	Long Character	CLOB	Comments field used for documenting performance notes.