SF_EG_ROLEAP_VW(SQL View) |
Index Back |
|---|---|
Engineering ECO Opr Appr Vw1CN#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. CN#SF800-14.0 TKI 09/09/99 Removed from SQL since fields are no longer valid on both APPR_INST_LOG and APPR_RULE_DETL: AND C.BUSPROCNAME=D.BUSPROCNAME AND C.APPR_RULE_SET=D.APPR_RULE_SET |
| SELECT DISTINCT A.EG_OPRID_APPROVAL , B.ROLEUSER , B.ROLENAME , A.BUSINESS_UNIT , A.ECO_ID , A.DTTM_CREATED , A.EG_WF_APPR_FLAG , A.EG_DEN_CNL_REASON , C.APPR_STEP , C.APPR_PATH FROM PS_EG_ECO_OPR_APPR A , PS_SF_EG_OP_ROL_VW B , PS_APPR_INST_LOG C , PS_APPR_RULE_DETL D , PS_EG_ECO_WL E WHERE A.EG_OPRID_APPROVAL = B.OPRID AND B.ROLENAME = D.ROLENAME AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.ECO_ID = E.ECO_ID AND C.APPR_INSTANCE = E.APPR_INSTANCE AND C.APPR_RULE_SET = D.APPR_RULE_SET AND C.APPR_STEP = D.APPR_STEP AND C.APPR_PATH = D.APPR_PATH AND B.ROLEUSER=C.ROLEUSER |
| # | 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 | ROLEUSER |
Character(30) | VARCHAR2(30) NOT NULL | Role User |
| 3 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | ECO_ID |
Character(10) | VARCHAR2(10) NOT NULL | ECO Number |
| 6 | DTTM_CREATED |
DateTime(26) | TIMESTAMP | Datetime Created |
| 7 | 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 |
| 8 | EG_DEN_CNL_REASON | Character(254) | VARCHAR2(254) NOT NULL | Deny/Cancel Reason |
| 9 | 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 |
| 10 | 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 |