EG_ECR_ACTM_VW

(SQL View)
Index Back

Eng ECR Action Maint VW

06/07/00 rml Changed prompt table for eg_action_cd from EG_ACTION_CD to EG_ACTION_CD_VW. This is to done to be consistent with reason code prompt table. The other reason is because of self service application - not necessarily to show SETID

select business_unit, eco_id, eco_state, eg_action_cd, text254 from PS_EG_ECO_ACTION where eco_state='CR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUMGOP_NONVW

2 ECR_ID Character(10) VARCHAR2(10) NOT NULL ECR Number
3 ECO_STATE Character(2) VARCHAR2(2) NOT NULL ECR / ECO Flag
CO=Engineering Change Order
CR=Engineering Chg Request

Default Value: CR

4 EG_ACTION_CD Character(10) VARCHAR2(10) NOT NULL Action Code

Prompt Table: EG_ACTION_CD_VW

5 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text