EOEN_DASHBRD

(SQL Table)
Index Back

EOEN Dash Board

EOEN Dash Board

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name

Prompt Table: EOEN_PRCS_VW

2 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category

Prompt Table: EOEN_REG

3 SEQ_NBR_EOEN Number(15,0) DECIMAL(15) NOT NULL EOEN Sequence Nbr
4 EOEN_STATUS Character(1) VARCHAR2(1) NOT NULL EOEN Status
0=Open
1=Closed

Default Value: 0

5 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: EOEC_BU_PROMPT

7 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

Prompt Table: PSPRCSRQST

8 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
9 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
11 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
12 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
13 NODE_NAME Character(40) VARCHAR2(40) NOT NULL Node Name
14 EOEN_MSG_TEXT Long Character CLOB Log Message text
15 EOEC_UL_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.