SP_SINSCD_CLSVW (SQL View)	Index Back
View of schedules setid

SP_SINSCD_CLSVW

(SQL View)

View of schedules setid

SELECT DISTINCT c.oprclass ,A.Setid FROM PS_SCHEDULE_TBL A ,PS_SETID_TBL B ,PS_SEC_SETID_CLS c WHERE A.SETID=B.SETID AND b.setid=c.setid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

2 STL_NETSCHED_SETID Character(5) VARCHAR2(5) NOT NULL SetID for Settlement Instructions used on other objects that don't contain setid as part of their key.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
2	STL_NETSCHED_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID for Settlement Instructions used on other objects that don't contain setid as part of their key.