SP_SINSCD_OPRVW (SQL View)	Index Back
View of schedules setid

SP_SINSCD_OPRVW

(SQL View)

View of schedules setid

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
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.