OI_STDJS_VW

(SQL View)
 Index Back

Standard Journal Schedule

Primary record for Standard Journal Schedule

SELECT SH.SETID , SH.SCHEDULE , SH.DESCR , XLI1.DESCR FREQ_DESC , XLI2.DESCR DAY_OF_WEEK , SH.DAY_OF_MONTH , SH.LAST_DAY_OF_MONTH , SH.MON , SH.TUES , SH.WED , SH.THURS , SH.FRI , SH.SAT , SH.SUN , XLI3.DESCR MONTHCD_DESC , SH.JANUARY , SH.FEBRUARY , SH.MARCH , SH.APRIL , SH.MAY , SH.JUNE , SH.JULY , SH.AUGUST , SH.SEPTEMBER , SH.OCTOBER , SH.NOVEMBER , SH.DECEMBER FROM PS_SCHEDULE_TBL SH LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = SH.FREQUENCY AND XLI1.CODESETGROUPNAME ='FREQUENCY' LEFT OUTER JOIN PS_OI_COMMON_VW XLI2 ON XLI2.CODESETNAME = SH.DAY_OF_WK AND XLI2.CODESETGROUPNAME ='DAY_OF_WK' LEFT OUTER JOIN PS_OI_COMMON_VW XLI3 ON XLI3.CODESETNAME = SH.MONTHCD AND XLI3.CODESETGROUPNAME ='MONTHCD' UNION SELECT SETID , ' ' , 'Not Available' , '-' , '-' , 0 , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' FROM PS_SETID_TBL UNION SELECT ' ' , ' ' , 'Not Available' , '-' , '-' , 0 , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 FREQ_DESC Character(30) VARCHAR2(30) NOT NULL Frequency Desc
5 DAY_OF_WEEK Character(16) VARCHAR2(16) NOT NULL Day of Week
6 DAY_OF_MONTH Number(2,0) SMALLINT NOT NULL Day of the Month
7 LAST_DAY_OF_MONTH Character(1) VARCHAR2(1) NOT NULL Last Day of the Month
8 MON Character(1) VARCHAR2(1) NOT NULL Monday
9 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday
10 WED Character(1) VARCHAR2(1) NOT NULL Wednesday
11 THURS Character(1) VARCHAR2(1) NOT NULL Thursday
12 FRI Character(1) VARCHAR2(1) NOT NULL Friday
13 SAT Character(1) VARCHAR2(1) NOT NULL Saturday
14 SUN Character(1) VARCHAR2(1) NOT NULL Sunday
15 MONTHCD_DESC Character(30) VARCHAR2(30) NOT NULL Month Code Desc
16 JANUARY Character(1) VARCHAR2(1) NOT NULL January
17 FEBRUARY Character(1) VARCHAR2(1) NOT NULL February
18 MARCH Character(1) VARCHAR2(1) NOT NULL March
19 APRIL Character(1) VARCHAR2(1) NOT NULL April
20 MAY Character(1) VARCHAR2(1) NOT NULL May
21 JUNE Character(1) VARCHAR2(1) NOT NULL June
22 JULY Character(1) VARCHAR2(1) NOT NULL July
23 AUGUST Character(1) VARCHAR2(1) NOT NULL August
24 SEPTEMBER Character(1) VARCHAR2(1) NOT NULL September
25 OCTOBER Character(1) VARCHAR2(1) NOT NULL October
26 NOVEMBER Character(1) VARCHAR2(1) NOT NULL November
27 DECEMBER Character(1) VARCHAR2(1) NOT NULL December