EG_ECO_APPR_VW2

(SQL View)
 Index Back

Engineering ECO Opr Appr Vw2

CN#DI-EZHENG-9 in FinDisMania, 7/24/98, eyz, we need a view that does not have activity in it for implementing the ECO Workflow status summary inquiry. 08/17/99 tki CN# SF800-14.0 Removed "and a.busprocname = c.busprocname" from the SQL for the view. busprocname was removed from the Tools table APPR_RULE_DETL 12/8/99 RML EG800-2.0 Added roleuser (PS_ROLEXLATOPR and PSROLEUSER) 02/07/2000 RML RML Removed dttm_created; this creates duplicate rows

SELECT DISTINCT C.ROLENAME , D.ROLEUSER , D.OPRID , B.BUSINESS_UNIT , B.ECO_ID , A.APPR_INST_STATUS , A.APPR_STEP , A.APPR_PATH FROM PS_APPR_INST_LOG A , PS_EG_ECO_WL B , PS_APPR_RULE_DETL C , PS_ROLEXLATOPR D , PSROLEUSER E WHERE A.BUSPROCNAME = B.BUSPROCNAME AND A.APPR_INSTANCE = B.APPR_INSTANCE AND A.APPR_INST_STATUS = 'P' AND A.APPR_STEP = C.APPR_STEP AND A.APPR_PATH = C.APPR_PATH AND A.APPR_RULE_SET = C.APPR_RULE_SET AND D.ROLEUSER = E.ROLEUSER AND C.ROLENAME = E.ROLENAME AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_APPR_RULE_DETL WHERE APPR_RULE_SET = A.APPR_RULE_SET AND APPR_STEP = A.APPR_STEP AND APPR_PATH = A.APPR_PATH AND EFFDT <= %DatePart(B.DTTM_CREATED))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
2 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
3 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)
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 ECO_ID Character(10) VARCHAR2(10) NOT NULL ECO Number
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
7 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
8 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