Table: Schedules

Table: CSSKTB
View: CS0030
Record length: 146
Flags: A R 

Keys: 1

Title  Flags  Fields

Schedules  SCHEDKEY

Fields: 25

Field  Type  Title  Presentation 

SCHEDKEY  String*12  Schedule Code  Mask: %-12N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
SCHEDDESC  String*60  Description   
INTERVAL  Integer  Interval  List: 6 entries
1=Daily
2=Weekly
3=Semimonthly
4=Monthly
5=Annual
11=Once
FREQUENCY  Integer  Frequency  List: 5 entries
1=Weekdays
2=Weekly
3=First and Date
4=Date and Last
5=Every
PHASE  Integer  Phase   
WEEKDAY  Integer  Weekday  List: 7 entries
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
MONTHDAY  Integer  Day of Month  List: 32 entries
1= 1st
2= 2nd
3= 3rd
4= 4th
5= 5th
6= 6th
7= 7th
8= 8th
9= 9th
10=10th
11=11th
12=12th
13=13th
14=14th
15=15th
16=16th
17=17th
18=18th
19=19th
20=20th
21=21st
22=22nd
23=23rd
24=24th
25=25th
26=26th
27=27th
28=28th
29=29th
30=30th
31=31st
99=Last
WEEK  Integer  Week in Month  List: 5 entries
1=First
2=Second
3=Third
4=Fourth
99=Last
MONTH  Integer  Month  List: 12 entries
1=January
2=February
3=March
4=April
5=May
6=June
7=July
8=August
9=September
10=October
11=November
12=December
WDFSUN  Integer  Sunday Call  List: 2 entries
0=No
1=Yes
WDFMON  Integer  Monday Call  List: 2 entries
0=No
1=Yes
WDFTUE  Integer  Tuesday Call  List: 2 entries
0=No
1=Yes
WDFWED  Integer  Wednesday Call  List: 2 entries
0=No
1=Yes
WDFTHU  Integer  Thursday Call  List: 2 entries
0=No
1=Yes
WDFFRI  Integer  Friday Call  List: 2 entries
0=No
1=Yes
WDFSAT  Integer  Saturday Call  List: 2 entries
0=No
1=Yes
LASTDATE  Date  Last Run Date   
ACTIVEDATE  Date  Schedule Start Date   
REMINDLEAD  Integer  Remind in Advance   
USERMODE  Integer  User Mode  List: 3 entries
1=No Users
2=Specific User
3=All Users
USERID  String*8  User ID  Mask: %-8N

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.