BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
ECO_IDPrompt Table: EG_ECO_HEADER
Prompt Table: EG_PRIORITY_CD
EG_ECR_ECO_VW(SQL View) |
Index Back |
|---|---|
Engineering ECR ECO Hdr View |
| select business_unit, eco_id, eg_priority, descr, eg_udef_acty 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
Prompt Table: EG_ECO_HEADER |
| 3 | EG_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL |
Priority Code
Prompt Table: EG_PRIORITY_CD |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | EG_UDEF_ACTY | Character(10) | VARCHAR2(10) NOT NULL | ECO Activity |