EG_ECO_APPR_VW3

(SQL View)
 Index Back

ECO approvers

Created on 03/01/2000 RML Copy of eg_eco_opr_appr - this is to resolve having a grid and a scroll on the same page (eg_ic_eco_header) using the same record name.

SELECT eg_oprid_approval , business_Unit , eco_id , dttm_created , eg_udef_acty , eg_wf_appr_flag , eg_den_cnl_reason , rolename , roleuser , eg_virtual_rt_flg , appr_step , appr_path , datetime_modified FROM PS_EG_ECO_OPR_APPR

# 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)

Prompt Table: OPERATOR_VW

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 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created

Default Value: %Datetime

5 EG_UDEF_ACTY Character(10) VARCHAR2(10) NOT NULL ECO Activity
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).

Prompt Table: ROLEUSER_VW

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