EG_SS_ECOHDR_VW(SQL View) |
Index Back |
|---|---|
Self Service ECO Header ViewCreated on 05/02/00 RML Used on self service ECO as search record for eg_ic_eco_maint - cannot just eg_ic_ecohdr_vw because it does not include ECOs with supplier approvals. Cannot use eg_eco_hdr_vw or eg_eco_header because they either have none or different search keys. Must use a search record with business unit, eco_id, and eco_state as search keys. |
| SELECT a.business_unit , a.eco_id , a.eco_state , 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.eg_classification , a.eg_wf_rtg_type , a.eg_udef_acty , a.eg_analyst , a.eg_release_date , a.vendor_setid , a.vendor_id 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 | ECO_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
ECR / ECO Flag
CO=Engineering Change Order CR=Engineering Chg Request |
| 4 | INV_ITEM_ID_LAST | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MG_ITEM_VW |
| 5 | BOM_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production RW=Rework |
| 6 | RTG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown |
| 7 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 8 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 9 | EG_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL |
Priority Code
Prompt Table: EG_PRIORITY_CD |
| 10 | EG_APPROV_ECO_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Status
A=Approved C=Canceled D=Denied P=Pending R=Released |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 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 |
| 17 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 18 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |