RUNCTL_EPO_CASC

(SQL Table)
Index Back

Cascade Items RunControl Rec

Run Control Record of cascade batch process

# 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_OBJ_PLAN Character(8) VARCHAR2(8) NOT NULL Objectives Management: Objective Plan ID field

Prompt Table: EPO_PLAN_VW

4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: EPO_SETID_VW

6 EPO_NODE_ID Character(10) VARCHAR2(10) NOT NULL Objectives Management. Used to store the Node ID associated with the Objective Plan
7 EPO_PAGE_ID Number(8,0) INTEGER NOT NULL Objectives Management: Objective Page ID
8 EPO_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Objectives Section type

Prompt Table: EPO_SECTN_DEFN

9 EPO_PAGE_TITLE Character(100) VARCHAR2(100) NOT NULL Title on the Objectives Page
10 EPO_RUN_TYPE Character(1) VARCHAR2(1) NOT NULL Cascade Run Type - Preview or Confirm
C=Confirm Cascade Items
P=Preview Cascade Items

Default Value: P

11 PERIOD_BEGIN_DT Date(10) DATE NOT NULL Period Begin Date

Default Value: EPO_OBJ_PLAN.EPO_PLAN_BEGIN_DT

12 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

Prompt Table: EP_REVW_TYP_VW

13 EP_MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager/Mentor ID.

Prompt Table: EP_EE_ID_VW

14 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Section type

Prompt Table: EP_SECTION_DEFN
Set Control Field: EP_SECTION_TYPE

15 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
16 PERIOD_END_DT Date(10) DATE Period End Date
17 EPO_CASC_LVL Character(1) VARCHAR2(1) NOT NULL Cascade Levels - All or One level
A=All Levels
O=One Level

Default Value: O

18 EP_ITEM_OVRWRT_FLG Character(1) VARCHAR2(1) NOT NULL Item existing in document should be overwritten by Cascade process or not.

Y/N Table Edit

Default Value: N

19 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
20 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
21 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
22 PORTAL_LINK_URL Long Character CLOB Link Definition
23 EPO_PORTAL_LNK_URL Long Character CLOB Link Definition
24 EPO_MGR_LNK_URL Long Character CLOB Link Definition