EPO_CASC_TAO (SQL Table)	Index Back
Objective Mgmnt Cascade Temp Temporary record to store items to be cascaded

EPO_CASC_TAO

(SQL Table)

Objective Mgmnt Cascade Temp

Temporary record to store items to be cascaded

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 EPO_PAGE_ID Number(8,0) INTEGER NOT NULL Objectives Management: Objective Page ID
Prompt Table: EPO_PG_HDR

4 EPO_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Objectives Section type
Prompt Table: EPO_SECTN_DEFN

5 EPO_OBJ_ITEM_ID Number(8,0) INTEGER NOT NULL Objectives Management: Objective Item ID. Used as a key to hold unique values as Item ID is not a key in Objective Management. It will uniquely define an item on ePerformance document when cascaded or copied over.

6 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item

7 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EPO_PAGE_ID	Number(8,0)	INTEGER NOT NULL	Objectives Management: Objective Page ID Prompt Table: EPO_PG_HDR
4	EPO_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Objectives Section type Prompt Table: EPO_SECTN_DEFN
5	EPO_OBJ_ITEM_ID	Number(8,0)	INTEGER NOT NULL	Objectives Management: Objective Item ID. Used as a key to hold unique values as Item ID is not a key in Objective Management. It will uniquely define an item on ePerformance document when cascaded or copied over.
6	EP_TITLE	Character(60)	VARCHAR2(60) NOT NULL	Title of an item
7	EP_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Item unique identifier