FFS_REPORT_SCHEDULE
Used to store schedule for automatic generation of reports.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_REPORT_SCHEDULE_PK |
ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ID | NUMBER | 8 | Yes | Unique identifier for scheduled report. | |
| REPORT_ID | NUMBER | 8 | Yes | Id of the report for the scheduled report. | |
| STARTDATE | DATE | Date at which the scheduled report starts. | |||
| ENDDATE | DATE | Schedule period end of the scheduled report. | |||
| TIME_FROM | NUMBER | 5 | Yes | Start time of report send period. | |
| RECURRENCE | VARCHAR2 | 8 | Periodicity of the scheduled report. | ||
| MONTHDAY | NUMBER | 3 | Yes | Week days set for the scheduled report. | |
| RECUR_WEEK | NUMBER | 3 | Yes | Recurring week for the scheduled report. | |
| VARCHAR2 | 1020 | Email id to which the scheduled report is to be sent. | |||
| RESOURCE_ID | NUMBER | 8 | Id Of The Resource, Whose Report To Be Sent. | ||
| REPORT_TYPE | VARCHAR2 | 5 | File Type For Exporting The Report. | ||
| TO_FILE | NUMBER | 3 | Yes | Flag Set To Indicate Whether Report Can Be Exported. The Default Is 0. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_REPORT_SCHEDULE_PK | Unique | DATA | ID |