RUNCTL_EPO_CASC(SQL Table) |
Index Back |
---|---|
Cascade Items RunControl RecRun 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
|
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 |