EG_ECO_WFL_WRK(SQL Table) |
Index Back |
|---|---|
Engineering ECO Oprid Apprvl7/23/98, eyz, created for the summary inquiry of ECO workflow approvals/denials/recycles. 11/16/99 RML Moved peoplecode from dttm_created.savepostchange to eg_eco_head_sbr; causing infinite loop because of scrollselect |
| # | 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
Default Value: OPR_DEF_TBL_FS.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 |