CREATE TABLE cloverleaf_ingestion(
	pk NUMBER(20),
	File_name VARCHAR2(200),
	Cl_file_size_in_bytes NUMBER(22),
	Cl_checksum VARCHAR2(32),
	CL_created_date_time DATE, 
	Status VARCHAR2(20),
	Mn_file_size_in_bytes NUMBER(22),
	Mn_checksum VARCHAR2(32),
	Failed_retries NUMBER(11),
	Processed_date_time DATE,
	ftp_acknowledgement VARCHAR2(20),
	ohf_processing_status VARCHAR2(20),
	ohf_processing_datetime DATE,
	ohf_total_rows NUMBER(22),
	ohf_failed_rows NUMBER(22),
	ohf_processed_rows NUMBER(22),
	hdfs_processing_status VARCHAR2(20),
	hdfs_processing_datetime DATE,
	hdfs_checksum VARCHAR2(60),
	hdfs_file_size_in_bytes NUMBER(22),
	CONSTRAINT cloverleaf_ingestion_pk PRIMARY KEY (pk)
);