EP_APPR_NOMINEE (SQL Table)	Index Back
Nominate Participants This record is used to hold list of nominees which have been submitted as participants for a review. This record is used during the Track Nominations process.

EP_APPR_NOMINEE

(SQL Table)

Nominate Participants

This record is used to hold list of nominees which have been submitted as participants for a review. This record is used during the Track Nominations process.

Parent record: EP_APPR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID
Prompt Table: EP_APPR

2 EP_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID

3 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier
Prompt Table: EP_APPR_PART_VW

4 EP_APPR_NOM_STATUS Character(1) VARCHAR2(1) NOT NULL Appraisal Nomination Status
A=Accepted
C=Cancelled
D=Declined
N=New
P=Pending

5 EP_SUBMIT_NOM_DT Date(10) DATE Date Submitted

6 EP_NOM_ADDED_BY Character(11) VARCHAR2(11) NOT NULL Nomination Added by

7 EP_NOM_SUBMIT_EMPL Character(11) VARCHAR2(11) NOT NULL Nomination Submitted by

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID Prompt Table: EP_APPR
2	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID
3	EP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier Prompt Table: EP_APPR_PART_VW
4	EP_APPR_NOM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Appraisal Nomination Status A=Accepted C=Cancelled D=Declined N=New P=Pending
5	EP_SUBMIT_NOM_DT	Date(10)	DATE	Date Submitted
6	EP_NOM_ADDED_BY	Character(11)	VARCHAR2(11) NOT NULL	Nomination Added by
7	EP_NOM_SUBMIT_EMPL	Character(11)	VARCHAR2(11) NOT NULL	Nomination Submitted by
8	EP_COMMENTS	Long Character	CLOB	Comments field used for documenting performance notes.