CAL_DEFN_VW

(SQL View)
Index Back

View of Detail Calendars

View of Detail Calendars

SELECT SETID , CALENDAR_ID , DESCR FROM PS_CAL_DEFN_TBL WHERE CALENDAR_TYPE = 'D' AND DAILY_CALENDAR = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID_GL_CALNDR Character(5) VARCHAR2(5) NOT NULL GL Steed for GL Calendars
2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description