PL_BWB_SGRP_VW (SQL View)	Index Back
Schedule Group view Schedule Group view

PL_BWB_SGRP_VW

(SQL View)

Schedule Group view

SELECT DISTINCT B.PROBINST , A.SCHED_GROUP_CD , A.SCHED_FLAG , A.PO_SCHED_PRIORITY FROM PS_ITM_VND_BU_ATTR A , PS_PL_BU_GRP_BU_VW B , PS_SET_CNTRL_REC C WHERE A.SETID = C.SETID AND C.RECNAME = 'MASTER_ITEM_TBL' AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND A.SCHED_GROUP_CD <>' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

2 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field

3 SCHED_FLAG Character(1) VARCHAR2(1) NOT NULL Schedule Flag
Y/N Table Edit
Default Value: N

4 PO_SCHED_PRIORITY Character(2) VARCHAR2(2) NOT NULL Schedule Priority
10=High
20=Medium
30=Low

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	SCHED_GROUP_CD	Character(6)	VARCHAR2(6) NOT NULL	04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
3	SCHED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Schedule Flag Y/N Table Edit Default Value: N
4	PO_SCHED_PRIORITY	Character(2)	VARCHAR2(2) NOT NULL	Schedule Priority 10=High 20=Medium 30=Low