EN_WC_CREW_VW

(SQL View)
Index Back

WC / Crew View


select a.business_unit, a.work_center_code,a.crew_code,b.descr from PS_EN_WC_RESRC a, ps_en_crew b where a.business_unit=b.business_unit and a.crew_code=b.crew_code

# 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 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
3 CREW_CODE Character(10) VARCHAR2(10) NOT NULL Crew Name
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description