EN_WC_RESRC

(SQL Table)
Index Back

Work Center Resources

CN #MG800-1.0 - 7/30/98 rs - Scrolls to grid conversion - made PCode changes and moved PCode from Crew/Machine/Tool FEd/FCh to EN_PANELS_WRK.RESRC_CODE

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

Prompt Table: BUS_UNIT_OPT_MG

2 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
3 RESRC_TYPE Character(2) VARCHAR2(2) NOT NULL Resource Type
10=Primary Crew
20=Alt Crew
30=Primary Machine
40=Alt Machine
50=Primary Tool
60=Alternate Tool
4 CREW_CODE Character(10) VARCHAR2(10) NOT NULL Crew Name

Prompt Table: EN_CREWAVAIL_VW

5 MACHINE_CODE Character(10) VARCHAR2(10) NOT NULL Machine Code

Prompt Table: EN_MACHAVAIL_VW

6 TOOL_CODE Character(10) VARCHAR2(10) NOT NULL Tool ID

Prompt Table: EN_TOOLAVAIL_VW

7 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

Default Value: 10