| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| apply | Apply | varchar | |
| interval_name | Interval Name | nvarchar | |
| interval_pk | Interval Id | int | |
| printer_name | Printer Name | nvarchar | |
| printer_pk | Printer Id | int | |
| reportType | Report Type | varchar | |
| repsched_createdDate | Record Creation Date | datetime | |
| repsched_creator_fk | User Id (Record Creator) | int | vr_users |
| repSched_curr_fk | Currency Id | int | vrpt_Currency |
| repSched_email | bit | ||
| repsched_emailBCC | Email BCC | nvarchar | |
| repsched_emailBody | Email Body | nvarchar | |
| repsched_emailCC | Email CC | nvarchar | |
| repsched_emailFrom | From Email | nvarchar | |
| repsched_emailOnly | Email Only | bit | |
| repsched_emailSubject | Email Subject | nvarchar | |
| repsched_emailTO | To Email | nvarchar | |
| repSched_exch_fk | Currency Exchange Id | int | |
| repSched_expirationDate | Expiration Date | datetime | |
| repsched_firstWaveID | Obsolete Column (No longer in use) | int | |
| repSched_format | Format | nvarchar | |
| repsched_friday | Indicates if this scheduled report record executes on a Friday | bit | |
| repSched_interval | Interval | smallint | |
| repSched_interval_fk | Interval Id | int | |
| repSched_lastDate | Last Date | datetime | |
| repsched_modifiedDate | Last Modified Date | datetime | |
| repsched_modifier_fk | User Id (Record Modifier) | int | vr_users |
| repSched_monday | Indicates if this scheduled report record executes on a Monday | bit | |
| repSched_nextdate | Next Date | datetime | |
| repSched_nextDateTimeToRun | Next Date Time To Run | datetime | |
| repSched_pk | Report Scheduler Id | int | |
| repSched_print | Indicates if this scheduled report record is set to print | bit | |
| repsched_printer_fk | Printer Id | int | |
| repsched_queryString | Query String | nvarchar | |
| repsched_reportType | Report Type | int | |
| repSched_rpt_fk | Report Id | int | |
| repsched_rptUserCriteriaValue | Report User Criteria Value | nvarchar | |
| repsched_rptUserInputCriteria | Report User Input Criteria | nvarchar | |
| repsched_saturday | Indicates if this scheduled report record executes on a Saturday | bit | |
| repSched_special | Indicates if this scheduled report record is a special report | bit | |
| repsched_sunday | Indicates if this scheduled report record executes on a Sunday | bit | |
| repSched_system | Indicates if this scheduled report record is a system report | bit | |
| repsched_thursday | Indicates if this scheduled report record executes on a Thursday | bit | |
| repSched_time | Time | nvarchar | |
| repsched_tuesday | Indicates if this scheduled report record executes on a Tuesday | bit | |
| repsched_user_fk | User Id | int | vr_Users |
| repsched_wednesday | Indicates if this scheduled report record executes on a Wednesday | bit | |
| repSched_windowName | Window Name | nvarchar | |
| RPT_PK | Report Id | int | |
| RPT_RPF_FK | Report Form Id | int | |
| RPT_TITLE | Report Title | nvarchar | |
| userName | User Name | nvarchar | |
| windowId | Window Id | int | vr_webtmaWindows |