EPO_CASCADE_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	PERIOD_BEGIN_DT	Date(10)	DATE	Period Begin Date
5	PERIOD_END_DT	Date(10)	DATE	Period End Date
6	EP_EST_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Translate field that determines the state (status) of the establish criteria step. CO=Completed IP=In Progress NA=Not Applicable NS=Not Started
7	EP_REVIEW_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately. AK=Acknowledged AR=Shared with Employee CA=Canceled CO=Completed EC=Define Criteria IP=Evaluation in Progress NS=Not Started PA=Approval RH=Pending Acknowledgement TP=Track Progress
8	EP_MANAGER_ID	Character(11)	VARCHAR2(11) NOT NULL	Manager/Mentor ID. Prompt Table: PERSON
9	EP_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Section type
10	EPO_DR_FND	Character(1)	VARCHAR2(1) NOT NULL	Direct Report Found flag
11	EPO_CASC_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Cascade document processes
12	EP_APPROVAL_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field tracks the current approval status of a review. This is separate from the review's lifecycle status, which is tracked separately. APRV=Approved DENY=Denied ERRO=Approval Error NREQ=Not Required OPEN=Not Submitted SUBM=Submitted