EG_ECO_HDRP_VW(SQL View) |
Index Back |
|---|---|
Engineering ECO Hdr Prmpt View09/17/99 TW (CN#R-ANURUD-5M33P) Replaced field EG_APPROVAL_FLAG with EG_APPROV_ECO_FLAG so that the correct xlat table(for ECOs) is used. |
| select business_unit, eco_id, eco_state, eg_priority, eg_approval_flag, descr, eg_classification, eg_wf_rtg_type, eg_udef_acty, eg_analyst, eg_release_date from PS_EG_ECO_HEADER where eco_state = 'CO' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 2 | ECO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
ECO Number
Default Value: NEXT |
| 3 | ECO_STATE | Character(2) | VARCHAR2(2) NOT NULL |
ECR / ECO Flag
CO=Engineering Change Order CR=Engineering Chg Request |
| 4 | EG_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL |
Priority Code
Prompt Table: EG_PRIORITY_CD |
| 5 | EG_APPROV_ECO_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Status
A=Approved C=Canceled D=Denied P=Pending R=Released |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | EG_CLASSIFICATION | Character(10) | VARCHAR2(10) NOT NULL |
Classification
Prompt Table: EG_CLASSIFY_CD |
| 8 | EG_WF_RTG_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
ECO Type
Prompt Table: EG_WF_RTG_TYPE |
| 9 | EG_UDEF_ACTY | Character(10) | VARCHAR2(10) NOT NULL |
ECO Activity
Prompt Table: EG_WF_RTG_AP_VW |
| 10 | EG_ANALYST | Character(30) | VARCHAR2(30) NOT NULL | Analyst |
| 11 | EG_RELEASE_DATE | Date(10) | DATE |
07/31/00...LAJ
Added eg_release_date2 label id. This will be used on the ECO line status page.
Default Value: %date |