WS_ITEM_SUB_VW

(SQL View)
Index Back

Worksheet Item By Setid


SELECT DISTINCT WS_BU , WS_ID , SUB_GROUP_ID FROM PS_WS_ITEM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WS_BU Character(5) VARCHAR2(5) NOT NULL Worksheet Business Unit
2 WS_ID Character(15) VARCHAR2(15) NOT NULL Worksheet ID
3 SUB_GROUP_ID Number(6,0) INTEGER NOT NULL Sub Group ID