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 |