EG_OPRID_APPROVALPrompt Table: OPERATOR_VW
BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
ECO_IDPrompt Table: EG_ECO_HEADR_VW
EG_UDEF_ACTYPrompt Table: EG_ECO_ACTY_VW
DTTM_CREATEDEG_ECO_OPAPR_VW(SQL View) |
Index Back |
|---|---|
Engineering ECO Op Apprvl View |
| select eg_oprid_approval, business_unit, eco_id, eg_udef_acty, dttm_created from PS_EG_ECO_OPR_APPR |
| # | 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)
Prompt Table: OPERATOR_VW |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 3 | ECO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
ECO Number
Prompt Table: EG_ECO_HEADR_VW |
| 4 | EG_UDEF_ACTY |
Character(10) | VARCHAR2(10) NOT NULL |
ECO Activity
Prompt Table: EG_ECO_ACTY_VW |
| 5 | DTTM_CREATED |
DateTime(26) | TIMESTAMP | Datetime Created |