EG_ECO_HDR_VW

(SQL View)
 Index Back

Engineering ECO Header View

CN# EN800-3.0, Sep 21 98, Anna Added field BomCode, rtgcode, bomtype, rtgtype

select a.business_unit, a.eco_id, b.inv_item_id, b.bom_type, b.rtg_type, b.bom_code, b.rtg_code, a.eg_priority, a.eg_approval_flag, a.descr, a.eco_state, a.eg_classification, a.eg_wf_rtg_type, a.eg_udef_acty, a.eg_analyst, a.eg_release_date from ps_eg_eco_header a, PS_EG_ECO_ASSY b where a.business_unit = b.business_unit and a.eco_id = b.eco_id and a.eco_state = 'CO' and b.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

Prompt Table: EG_ECO_HDRP_VW

3 INV_ITEM_ID_LAST Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MG_ITEM_VW

4 BOM_TYPE Character(2) VARCHAR2(2) NOT NULL 03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
5 RTG_TYPE Character(2) VARCHAR2(2) NOT NULL Routing Type
PR=Production
RW=Rework
TD=Teardown
6 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
7 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
8 EG_PRIORITY Character(4) VARCHAR2(4) NOT NULL Priority Code

Prompt Table: EG_PRIORITY_CD

9 EG_APPROV_ECO_FLAG Character(1) VARCHAR2(1) NOT NULL Status
A=Approved
C=Canceled
D=Denied
P=Pending
R=Released
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 ECO_STATE Character(2) VARCHAR2(2) NOT NULL ECR / ECO Flag
CO=Engineering Change Order
CR=Engineering Chg Request
12 EG_CLASSIFICATION Character(10) VARCHAR2(10) NOT NULL Classification

Prompt Table: EG_CLASSIFY_CD

13 EG_WF_RTG_TYPE Character(10) VARCHAR2(10) NOT NULL ECO Type

Prompt Table: EG_WF_RTG_TYPE

14 EG_UDEF_ACTY Character(10) VARCHAR2(10) NOT NULL ECO Activity

Prompt Table: EG_WF_RTG_AP_VW

15 EG_ANALYST Character(30) VARCHAR2(30) NOT NULL Analyst
16 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