EPO_CASC_TAO4

(SQL Table)
Index Back

Temp Record of cascade Process

Cascade Items staging temporary table to store subitems

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID
2 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Section type

Prompt Table: EP_SECTION_DEFN

3 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.
4 EPO_OBJ_SUBITEM_ID Number(8,0) INTEGER NOT NULL Objectives Management: Object Sub Item ID. Used as a key to hold Sub Item ID values because Sub Item ID is not a key and its value will be copied over to SubItem ID of ePerformance document which will be unique.
5 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier

Prompt Table: %EDITTABLE

6 EP_ITEM_SEQ Number(2,0) SMALLINT NOT NULL Item sequence number
7 EP_SUB_ID Character(12) VARCHAR2(12) NOT NULL Sub-Item unique identifier
8 EP_SUB_SEQ Number(2,0) SMALLINT NOT NULL Sub-Item sequence number
9 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item
10 EP_ITEM_ACTION Character(1) VARCHAR2(1) NOT NULL Objectives field to keep track whether tan item was copied, aligned or cascaded
A=Align Objective
B=Copy Objective
C=Copy Performance Document
D=Cascade Item
N=Non Display Item
P=Performance Item