GP Tables

ReportSchedule - Report Schedule

SQL Query Builder

47 Columns

Column Description Type Length
RPTGRIND smallint 0
PRODID smallint 0
RTPACHIN smallint 0
RTCFGWIN smallint 0
RTGRSBIN numeric(19,5) 0.00
RPTGRNMS char(21) ''
Business_Desk_Report_Nam char(51) ''
Business_Desk_Report_Typ char(5) ''
Report_URL char(255) ''
Publish_Frequency smallint 0
STRTDATE datetime '1/1/1900'
STRTTIME datetime '1/1/1900'
NMBROFDYS smallint 0
DailyFrequencyOptions smallint 0
WeeklyFrequencyOptions smallint 0
MonthlyFrequencyOptions smallint 0
ScheduledDaysOfTheWeek_1 tinyint 0
ScheduledDaysOfTheWeek_2 tinyint 0
ScheduledDaysOfTheWeek_3 tinyint 0
ScheduledDaysOfTheWeek_4 tinyint 0
ScheduledDaysOfTheWeek_5 tinyint 0
ScheduledDaysOfTheWeek_6 tinyint 0
ScheduledDaysOfTheWeek_7 tinyint 0
ScheduledDayOfTheWeek smallint 0
Scheduled_Week_Of_The_Mo smallint 0
DAYOFMONTH smallint 0
ScheduledMonthOfTheYear_1 tinyint 0
ScheduledMonthOfTheYear_2 tinyint 0
ScheduledMonthOfTheYear_3 tinyint 0
ScheduledMonthOfTheYear_4 tinyint 0
ScheduledMonthOfTheYear_5 tinyint 0
ScheduledMonthOfTheYear_6 tinyint 0
ScheduledMonthOfTheYear_7 tinyint 0
ScheduledMonthOfTheYear_8 tinyint 0
ScheduledMonthOfTheYear_9 tinyint 0
ScheduledMonthOfTheYear_10 tinyint 0
ScheduledMonthOfTheYear_11 tinyint 0
ScheduledMonthOfTheYear_12 tinyint 0
Number_Of_Weeks smallint 0
Last_Date_Published datetime '1/1/1900'
Last_Time_Published datetime '1/1/1900'
Next_Day_To_Publish datetime '1/1/1900'
Next_Time_To_Publish datetime '1/1/1900'
GenerateReportScript char(81) ''
OpenReportOptionWindowSc char(81) ''
Keep_Prior_Versions smallint 0
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with ReportSchedule. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

STRTDATE

AHR2AP05 AHR2AP06 ASIEXP05 ASIEXP10 ASIEXP18 ASIEXP32 CN04000 EDCVAT09

RPTGRIND

PP000060 ReportCatalogPending ReportCentersPending ReportErrorLog ReportInternalNames ReportNames ReportPublishers ReportRoles

Business_Desk_Report_Nam

ReportCatalog ReportCatalogPending ReportCenters ReportCentersPending ReportErrorLog ReportInternalNames ReportNames ReportPublishers

PRODID

ReportCatalogPending ReportCentersPending ReportErrorLog ReportInternalNames ReportNames ReportPublishers ReportRoles ReportRolesPending

STRTTIME

ERB11300 IV41000 SV00301 SV30301 SV40201 SV70001 SVA0301

RTPACHIN

PP000060 ReportNames SY01301

RTGRSBIN

PP000060 ReportNames SY01301

NMBROFDYS

ASIEXP11 CN04000 IV00102

RPTGRNMS

EDCVAT09 ReportInternalNames