Scheduled Report Function - Fields Description

At this function, user will come across various fields or columns that needs to be maintained with relevant data.

The descriptions of the respective field or column, are as follows:-

Scheduled Reports (Panel)

Report Group Code

This is a unique code to identify a group of reports tied to this group for a scheduled report extraction, e.g., HP DAILY.

Group Description

This is the description of the respective report group code.

Active

This is to indicate whether the respective group of reports' extraction schedule has been executed.

Note: Checked check box indicates that the report group’s reports schedule for extraction has been executed.

Scheduling Type

This is the period format to be applied for the report extraction’s schedule.

The available options, are as follows:-

  • Period (Involves executing the reports schedule at the pre-defined time intervals, e.g., every 60 seconds)

  • Cron (Involves executing the reports schedule at a pre-defined precise time patterns using a combination of days, hours and minutes.)

  • This panel will be display when the function screen has been opened.

  • The purposes of this panel is to allow user to do the followings:-

    • Access point to related panels to input or update the details for each group report group to be scheduled for the reports' extractions.

    • To ad hoc execute the extraction of the selected group of reports.

    • To select the relevant reports group’s extraction schedule record for activation.

    • To select activated reports group’s extraction schedule record for deactivation.

    • To remove report groups.
Report Group Edit (Panel)

Report Group Code

This is a unique code to identify a group of reports tied to this group for a scheduled report extraction, e.g., HP DAILY.

Group Description

This is the description of the respective report group code.

Task ID

This is the system generated unique reference number associated with the respective report groups' report extraction schedule.

Scheduling Type

This is the period format to be applied for the report extraction’s schedule.

The available options, are as follows:-

  • Period (Involves executing the reports schedule at the pre-defined time intervals, e.g., every 60 seconds)

  • Cron (Involves executing the reports schedule at a pre-defined precise time patterns using a combination of days, hours and minutes.)

Period (Seconds)

This is the report extraction schedule period (in seconds) for a particular group of reports to take place in system.

Note: This field will be enabled for data input, provided the value selected at the 'Scheduling Type' field is the 'Period' option only.

Cron

This is the report extraction schedule period for a particular group of reports to take place in system, that takes the form of minute, hour, day, month, day of a week separated by spaces.

Some examples, are as follows:-

  • Minute (0-59)

  • Hour (0-23)

  • Day-Date (1-31)

  • Month (1-12)

  • Day Name (0-6)

Note: This field will be enabled for data input, provided the value selected at the 'Scheduling Type' field is the 'Cron' option only.

Report List (Sub-Panel)

ID

This is the unique reference number associated with each report that has been pre-defined in system, e.g., 20100600.

Report Name

This is the system’s report code associated with a Report ID.

Description

This is the brief description of the respective report associated with a Report ID and Report Name in system.

Output Type

This is the type of the respective report output, e.g., PDF, XLSX, DOCX.

Report By

This indicates whether the respective report’s data has been reported by a certain branch, or segment in system.

  • This panel will be displayed after user has done either the followings:-

    • Clicked once on the CreateNewRecord button, located at the top of the function screen, upon the function screen opened.

    • Clicked once on the Details icon of a report group record.

  • The purposes of this panel is to allow user to do the followings:-

    • To input the report group details and add the relevant reports to be scheduled for extraction.

    • To make changes on the relevant fields and add or remove the relevant reports to be included into the selected reports group code, which have not been activated.
Report Details (Panel)

Report Group Code

This is a unique code to identify a group of reports tied to this group for a scheduled report extraction, e.g., HP DAILY.

Report

This is the brief description of the respective report associated with a Report ID and Report Name in system.

Output Type

This is the type of the respective report output, e.g., PDF, XLSX, DOCX.

Report by

This indicates whether the respective report’s data has been reported by a certain branch, or segment in system.

Parameter List

Parameter Code

This is the code associated with the respective report filter’s parameter e.g, MOD_CD, BRN_FROM, BRN_TO.

Description

This is the description of the respective report filter’s parameter code.

Value

This is the parameter value of the respective report filter’s parameter code.

  • This panel will bew displayed after user has done either one of the followings:-

    • Click once on the Details icon of a report at the 'Report Group Edit' panel.

    • Click once on the Add button at the 'Report Group Edit' panel.

  • The purposes of this panel, are as follows:-

    • To search and select for the relevant report to be included into the selected reports group to be scheduled for extraction.

    • To reselect the report output format and report data filter parameters of the relevant report under the selected reports group.
Reports (Panel)

Module Code

This is area in system that the respective report belongs.

Some available options, are as follows:-

  • AP - CREDIT APPLICATION

  • CIF - CUSTOMER INFORMATION FILE

  • CS - COMMON BUSINESS SERVICES

  • KERN - KERNEL

  • LN - FINANCING

ALL

This is the radio button to indicate that all the available reports are relevant in the report search,

Document

This is the check box to indicate that only documents are relevant in the 'report' search.

Report Code

This is the unique reference number associated with each report that has been pre-defined in system, e.g., 20100600.

Report Name

This is the system’s report code associated with a Report Code.

Module Code

This is area in system that the respective report belongs.

Some available options, are as follows:-

  • AP - CREDIT APPLICATION

  • CIF - CUSTOMER INFORMATION FILE

  • CS - COMMON BUSINESS SERVICES

  • KERN - KERNEL

  • LN - FINANCING

Document

This is to indicate whether the record of report is a document.

The available options, are as follows:-

  • Y - Yes (considered a document)

  • N - No (considered not a document)

  • This panel will be displayed after user has clicked once on the '…​' icon at the 'Report' field, under the 'Reports' panel.

  • The purpose of this panel is to allow user to select a report from the list of available reports in the system.
Scheduled Execution History (Pop-Up window)

Server

A server is a central component (a specialised computer or software application) which responds and communicates to requests from clients (e.g., computers, smartphones, or other devices) by providing services or data within a network; it acts as a mediator between clients and the resources required.

This is referring to the brief details of the server that stores and manage the data relating to the reports that had been scheduled for extraction, e.g., 10.10.6.139:8443/lendnow-core.

Start Time

This is the scheduled execution’s starting date and time of a group of reports' extraction.

Finish Time

This is the schedule execution’s ending date and time of a group of reports' extraction.

Duration, Sec

This is the time taken (in seconds) to complete executing the schedule extraction of a group of reports.

Result

This is the possible further information of the executed "reports' extraction schedule" task.