# SCHEDULE: Alerts - Name: `SCHEDULE` - Catalog: `AccountView` - Label: Alerts - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `SCHEDULE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACT_CODE` | `string(10)` | User activity | ☐ | | | `ADM_CODE` | `string(10)` | Administration | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `D_INTERVAL` | `int32` | Interval (daily) | ☐ | | | `DEL_FINISH` | `boolean` | Delete alert after completion | ☐ | | | `DF_END` | `int32` | End time (daily interval) | ☐ | | | `DF_HOUR` | `int32` | Daily interval | ☐ | | | `DF_START` | `int32` | Start time (daily interval) | ☐ | | | `DF_TIME` | `int32` | Alert time (daily) | ☐ | | | `DF_TYPE` | `int32` | Daily frequency type | ☐ | | | `END_DATE` | `datetime` | End Date | ☐ | | | `EXP_ADMC` | `string(10)` | Active administration | ☐ | | | `EXP_ADMD` | `string(100)` | Active administration description | ☐ | | | `EXP_LIC` | `string(100)` | Licence name | ☐ | | | `EXP_TIME` | `datetime` | Actual alert time | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `LST_RUN` | `datetime` | Last executed date | ☐ | | | `M_DAY` | `int32` | Day number (monthly) | ☐ | | | `M_INTERVAL` | `int32` | Interval (monthly) | ☐ | | | `M_TYPE` | `int32` | Monthly frequency type | ☐ | | | `M_WEEKDAY` | `int32` | Weekday (monthly) | ☐ | | | `M_WEEKNR` | `int32` | Week number (monthly) | ☐ | | | `MAIL_BODY` | `string(4)` | Email text | ☐ | | | `MAIL_NDTXT` | `string(4)` | Email text if there is no data | ☐ | | | `MAIL_NODAT` | `boolean` | Send email if there is no data | ☐ | | | `MAIL_SUBJ` | `string(160)` | Email subject | ☐ | | | `REC_BLK` | `boolean` | Blocked | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `RPT_EXPTYP` | `string(10)` | File format | ☐ | | | `RUN_DATE` | `datetime` | Planned alert time | ☐ | | | `RUN_DATEV` | `datetime` | Planned alert date | ☐ | | | `SCH_ENDED` | `boolean` | Alert completed | ☐ | | | `SCHED_CODE` | `string(10)` | Alert code | ☐ | | | `SCHED_DESC` | `string(40)` | Alert description | ☐ | | | `SCHED_STAT` | `int32` | Alert status | ☐ | | | `SCHED_SYS` | `boolean` | System alert | ☐ | | | `SCHED_TYPE` | `int32` | Frequency | ☐ | | | `START_DATE` | `datetime` | Start date | ☐ | | | `TGT_DIR` | `string(240)` | Target folder | ☐ | | | `TGT_FILE` | `string(160)` | File name | ☐ | | | `TGT_LINK` | `string(240)` | Target link | ☐ | | | `TGT_MAIL` | `string(4)` | Email address | ☐ | | | `TGT_MAILBC` | `string(4)` | Email address bcc | ☐ | | | `TGT_MAILCC` | `string(4)` | Email address cc | ☐ | | | `TGT_TYPE` | `int32` | Destination | ☐ | | | `TGT_XMLRP` | `boolean` | Keep XML response | ☐ | | | `W_DAYS` | `string(7)` | Days (weekly) | ☐ | | | `W_INTERVAL` | `int32` | Interval (weekly) | ☐ | |