Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Concept Videos

Data Reporting and Recording01:24

Data Reporting and Recording

5.0K
Reporting and recording are crucial in data documentation. The timely, thorough, and accurate documentation of facts is essential when recording patient data. Failure to record findings during an assessment or interpretation of a problem will result in loss of information and make the patient document unreliable. The reader is left with general impressions if the information is not specific. A recording is documenting data of the individual's health information in a traceable, secure, and...
5.0K
Source Transformation01:15

Source Transformation

10.5K
Source transformation is a fundamental technique employed in circuit analysis, offering a valuable tool for simplifying complex electrical circuits. This technique involves the replacement of either a voltage source in series with a resistor by a current source in parallel with a resistor, or vice versa. The key concept here is that when the original sources are deactivated (turned off), the equivalent resistance at the circuit's end terminals remains the same.
It is essential to note that when...
10.5K
Drug Biotransformation: Overview01:16

Drug Biotransformation: Overview

3.1K
Pharmaceutical substances known as xenobiotics are predominantly lipophilic and nonionized. This enables them to permeate lipid bilayers, such as cell membranes, and interact with intracellular target receptors. Lipophilic drugs have an advantage in crossing biological barriers and reaching their intended sites of action. However, lipophilic drugs often have a restricted capacity for renal expulsion or elimination from the body. When these drugs enter the kidneys and undergo glomerular...
3.1K
Instrument Transformers01:23

Instrument Transformers

182
Instrument transformers, comprising voltage transformers (VTs) and current transformers (CTs), play crucial roles in power substations by providing isolated replicas of current or voltage for measurement and protection purposes. Voltage transformers reduce the primary voltage to levels suitable for relay operation and measurement, while current transformers scale down the primary current. The primary winding of a current transformer often consists of a single turn, achieved by threading the...
182
Extraction: Advanced Methods00:56

Extraction: Advanced Methods

629
Metal ions can be separated from one another by complexation with organic ligands–the chelating agent– to form uncharged chelates. Here, the chelating agent must contain hydrophobic groups and behave as a weak acid, losing a proton to bind with the metal. Since most organic ligands used in this process are insoluble or undergo oxidation in the aqueous phase, the chelating agent is initially added to the organic phase and extracted into the aqueous phase. The metal-ligand complex is...
629
Transformers in Distribution System01:27

Transformers in Distribution System

188
Transformers in distribution systems can be broadly categorized into distribution substation transformers and other distribution transformers. They are crucial for stepping down high transmission voltages to levels suitable for distribution and end-user applications.
Distribution substation transformers come in various ratings and typically use mineral oil for insulation and cooling. To prevent moisture and air from entering the oil, some transformers use an inert gas like nitrogen to fill the...
188

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Integrating and retrieving learning analytics data from heterogeneous platforms using ontology alignment: Graph-based approach.

MethodsX·2025
Same author

Methods for studying group loans, join responsibility, and women's empowerment.

MethodsX·2022
Same author

Vocational education phenomena research method.

MethodsX·2021
Same author

Flypaper effect assessment methods in the expansion of regional autonomy.

MethodsX·2021
Same author

Dataset smartphone usage of international tourist behavior.

Data in brief·2019

Related Experiment Video

Updated: Oct 22, 2025

TBase - an Integrated Electronic Health Record and Research Database for Kidney Transplant Recipients
09:00

TBase - an Integrated Electronic Health Record and Research Database for Kidney Transplant Recipients

Published on: April 13, 2021

4.8K

Extract transform load process in banking reporting system.

Mokhamad Hendayun1, Erwin Yulianto1, Jack Febrian Rusdi2

  • 1Department of Informatics, Langlangbuana University, Bandung, Indonesia.

Methodsx
|August 26, 2021
PubMed
Summary
This summary is machine-generated.

Banks can now automate Liquidity Coverage Ratio (LCR) reporting using Extract Transform Load (ETL). This method streamlines daily compliance, avoiding penalties and improving banking operations.

Keywords:
Banking reporting systemBasel IIICore bankingData warehouseExtract transform loadLiquidity coverage ratio

More Related Videos

Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases
07:26

Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases

Published on: March 19, 2018

9.5K
Absolute Quantification of Cell-Free Protein Synthesis Metabolism by Reversed-Phase Liquid Chromatography-Mass Spectrometry
08:06

Absolute Quantification of Cell-Free Protein Synthesis Metabolism by Reversed-Phase Liquid Chromatography-Mass Spectrometry

Published on: October 25, 2019

9.4K

Related Experiment Videos

Last Updated: Oct 22, 2025

TBase - an Integrated Electronic Health Record and Research Database for Kidney Transplant Recipients
09:00

TBase - an Integrated Electronic Health Record and Research Database for Kidney Transplant Recipients

Published on: April 13, 2021

4.8K
Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases
07:26

Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases

Published on: March 19, 2018

9.5K
Absolute Quantification of Cell-Free Protein Synthesis Metabolism by Reversed-Phase Liquid Chromatography-Mass Spectrometry
08:06

Absolute Quantification of Cell-Free Protein Synthesis Metabolism by Reversed-Phase Liquid Chromatography-Mass Spectrometry

Published on: October 25, 2019

9.4K

Area of Science:

  • Banking and Financial Regulation
  • Information Systems and Technology

Background:

  • Banks are mandated to monitor liquidity via the Liquidity Coverage Ratio (LCR).
  • Current reporting in Indonesia is often manual or semi-automated, posing challenges and risks of penalties.
  • Regulatory compliance requires accurate and timely LCR reporting to authorities like OJK.

Purpose of the Study:

  • To discuss an automation process for LCR reporting using Extract Transform Load (ETL).
  • To propose a methodology for integrating banking systems with regulatory requirements based on Basel III.
  • To address the obstacles faced by banks in semi-automated LCR reporting.

Main Methods:

  • Development of an automated LCR reporting process utilizing Extract Transform Load (ETL) concepts.
  • Application of a waterfall software development model for systematic process implementation.
  • Case study analysis based on Indonesian banking practices and Basel III frameworks.

Main Results:

  • Successful implementation of an ETL-based method for automated daily LCR report generation.
  • Demonstrated effectiveness of the proposed ETL methodology in processing LCR data within the banking industry.
  • Validation of the ETL approach as a viable solution for Basel III LCR reporting.

Conclusions:

  • The ETL method provides a robust solution for automating LCR reporting in banks.
  • This methodology enhances accuracy and timeliness, mitigating compliance risks.
  • It is recommended for banks to adopt the ETL method for efficient Basel III LCR reporting.