SCHDLVERSION_VW

(SQL View)
Index Back

SELECT DISTINCT A.SCHEDULENAME , A.JOBNAMESRC , A.PRCSNAME , A.PRCSTYPE FROM PS_SCHDLITEM A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name
2 JOBNAMESRC Character(8) VARCHAR2(8) NOT NULL Job Name Source
3 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
4 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type