Ellis improvement

SELECT
T.HOTEL_CODE AS hotelCode
, HOTEL_CONTRACT_SEQ AS hotelContractSeq
, A.VENDOR_ROOM_TYPE_SEQ AS roomSq
, A.LEFT_COUNT_SUM AS leftCount
, A.SALES_STOP_YN AS isStop
, A.ALLOTMENT_CMS_PMS_COMP_CODE AS cmsCompCode
, A.LOCAL_ALLOTMENT_YN AS isLocalAllotment
, A.SELLER_COMP_CODE AS sellerCompCode
, A.MIN_NIGHTS AS minNight
, A.CHECK_IN_ABLE_YN AS cta
, A.CHECK_OUT_ABLE_YN AS ctd
FROM VD_VENDOR_ROOM_ALLOTMENT A
INNER JOIN VD_VENDOR_ROOM_TYPE T ON T.VENDOR_ROOM_TYPE_SEQ = A.VENDOR_ROOM_TYPE_SEQ
WHERE APPLIED_DATE >= '20250720'

package com.ohmy.elasticsearch.common.models;

import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import com.fasterxml.jackson.annotation.JsonProperty;
import com.ohmy.elasticsearch.common.BaseDoc;
import lombok.Data;
import lombok.EqualsAndHashCode;
import org.joda.time.Instant;

@Data
@EqualsAndHashCode(callSuper = false)
@JsonIgnoreProperties(ignoreUnknown=true)
public class RoomAllotment extends BaseDoc {
public RoomAllotment() {
lastModify = Instant.now().toString();
}
@Override
public String getId() {
return String.format("%s-%s-%s-%s-%s-%s", hotelCode, hotelContractSq, cmsCompCode, sellerComCode, roomSq, date);
}

@JsonProperty("d")
    private int date;
    @JsonProperty("htc")
    private long hotelCode;
    @JsonProperty("csq")
    private long hotelContractSq = 0;
    @JsonProperty("rsq")
    private long roomSq;
    @JsonProperty("ltc")
    private int leftCount;
    @JsonProperty("isS")
    private boolean isStop;
    @JsonProperty("cmsC")
    private int cmsCompCode;
    @JsonProperty("isL")
    private boolean isLocalAllotment;
    @JsonProperty("slc")
    private int sellerComCode;
    @JsonProperty("mnt")
    private int minNight = 1;
    @JsonProperty("cta")
    private boolean cta;
    @JsonProperty("ctd")
    private boolean ctd;
    @JsonProperty("lstMdf")
    private String lastModify;

public String generateId() {
        return String.format("%s-%s-%s-%s-%s-%s", hotelCode, hotelContractSq, cmsCompCode, sellerComCode, roomSq, date);
    }
}