| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EG_OPRID_APPROVAL |
Character(30) |
VARCHAR2(30) NOT NULL |
02/18/2000 RML Operator ID length expanded from 8 to 30
EG_ECO_APPROVAL (Panel)
EG_ECO_OPR_APPR (Panel)
EG_ECO_OPR_APPR (Panel)
EG_ECO_ROUTINGS (Panel)
EG_IC_ECO_APPR_SBP (Panel) - obsolete panel; to be deleted
EG_IC_ECO_HEADER (Panel)
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUMGOP_NONVW
|
| 3 |
ECO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
ECO Number
Prompt Table:
EG_ECO_HEADR_VW
|
| 4 |
EG_UDEF_ACTY |
Character(10) |
VARCHAR2(10) NOT NULL |
ECO Activity
Prompt Table:
EG_ECO_ACTY_VW
|
| 5 |
DTTM_CREATED |
DateTime(26) |
TIMESTAMP |
Datetime Created
Default Value: %datetime
|
| 6 |
EG_WF_APPR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
03/01/2000 RML Added Submitted - use to indicate which role user submitted ECO for approval in the approval detail grid
A=Approved
D=Denied
P=Pending
R=Recycle
X=Submitted
Default Value: P
|
| 7 |
EG_DEN_CNL_REASON |
Character(254) |
VARCHAR2(254) NOT NULL |
Deny/Cancel Reason
|
| 8 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
|
| 9 |
ROLEUSER |
Character(30) |
VARCHAR2(30) NOT NULL |
Role User
|
| 10 |
EG_VIRTUAL_RT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Virtual Router
Default Value: N
|
| 11 |
APPR_STEP |
Character(3) |
VARCHAR2(3) NOT NULL |
Approval Step
1=Approval Step 1
2=Approval Step 2
3=Approval Step 3
4=Approval Step 4
5=Approval Step 5
6=Approval Step 6
7=Approval Step 7
8=Approval Step 8
9=Approval Step 9
|
| 12 |
APPR_PATH |
Character(3) |
VARCHAR2(3) NOT NULL |
Approval Path
A=Approval Path A
B=Approval Path B
C=Approval Path C
D=Approval Path D
E=Approval Path E
|
| 13 |
DATETIME_MODIFIED |
DateTime(26) |
TIMESTAMP |
Datetime Modified
|