---
title: "SCHEDULE (AccountView)"
description: "Alerts"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/vismaaccountview/AccountView..SCHEDULE
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..SCHEDULE
updated: 2026-11-16T21:14:52Z
license: https://documentation.invantive.eu/es/
---

# SCHEDULE: AccountView Alerts

`read only`

- Catálogo: `AccountView`
- Label: Alerts

Solo puede recuperar datos.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `SCHEDULE`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACT_CODE` | `varchar2(10)` | User activity | [ ] |  |  |
| `ADM_CODE` | `varchar2(10)` | Administration | [ ] |  |  |
| `CNG_DATE` | `datetime` | Date modified | [ ] |  |  |
| `CNG_NR` | `int32` | Change number | [ ] |  |  |
| `CNG_USR` | `varchar2(20)` | Employee last modified | [ ] |  |  |
| `D_INTERVAL` | `int32` | Interval (daily) | [ ] |  |  |
| `DEL_FINISH` | `char` | 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` | Fecha Final | [ ] |  |  |
| `EXP_ADMC` | `varchar2(10)` | Active administration | [ ] |  |  |
| `EXP_ADMD` | `varchar2(100)` | Active administration description | [ ] |  |  |
| `EXP_LIC` | `varchar2(100)` | Licence name | [ ] |  |  |
| `EXP_TIME` | `datetime` | Actual alert time | [ ] |  |  |
| `INP_DATE` | `datetime` | Entry date | [ ] |  |  |
| `INP_USR` | `varchar2(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` | `varchar2(4)` | Email text | [ ] |  |  |
| `MAIL_NDTXT` | `varchar2(4)` | Email text if there is no data | [ ] |  |  |
| `MAIL_NODAT` | `char` | Send email if there is no data | [ ] |  |  |
| `MAIL_SUBJ` | `varchar2(160)` | Email subject | [ ] |  |  |
| `REC_BLK` | `char` | Blocked | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Unique code | [ ] |  |  |
| `RPT_EXPTYP` | `varchar2(10)` | File format | [ ] |  |  |
| `RUN_DATE` | `datetime` | Planned alert time | [ ] |  |  |
| `RUN_DATEV` | `datetime` | Planned alert date | [ ] |  |  |
| `SCH_ENDED` | `char` | Alert completed | [ ] |  |  |
| `SCHED_CODE` | `varchar2(10)` | Alert code | [ ] |  |  |
| `SCHED_DESC` | `varchar2(40)` | Alert description | [ ] |  |  |
| `SCHED_STAT` | `int32` | Alert status | [ ] |  |  |
| `SCHED_SYS` | `char` | System alert | [ ] |  |  |
| `SCHED_TYPE` | `int32` | Frequency | [ ] |  |  |
| `START_DATE` | `datetime` | Fecha inicial | [ ] |  |  |
| `TGT_DIR` | `varchar2(240)` | Target folder | [ ] |  |  |
| `TGT_FILE` | `varchar2(160)` | File name | [ ] |  |  |
| `TGT_LINK` | `varchar2(240)` | Target link | [ ] |  |  |
| `TGT_MAIL` | `varchar2(4)` | Dirección de correo electrónico | [ ] |  |  |
| `TGT_MAILBC` | `varchar2(4)` | Email address bcc | [ ] |  |  |
| `TGT_MAILCC` | `varchar2(4)` | Email address cc | [ ] |  |  |
| `TGT_TYPE` | `int32` | Destination | [ ] |  |  |
| `TGT_XMLRP` | `char` | Keep XML response | [ ] |  |  |
| `W_DAYS` | `varchar2(7)` | Days (weekly) | [ ] |  |  |
| `W_INTERVAL` | `int32` | Interval (weekly) | [ ] |  |  |
