EN_TOOLAVAIL_VW

(SQL View)
Index Back

Non-Pending Tools


select business_unit, tool_code, descr, tool_status from PS_EN_TOOL where tool_status <> '01'

# 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 TOOL_CODE Character(10) VARCHAR2(10) NOT NULL Tool ID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 TOOL_STATUS Character(2) VARCHAR2(2) NOT NULL Tool Status
01=Pending
02=Available
03=In Repair
04=Schd Maint

Default Value: 01