Superexchanges and Charge Transfer in the La$_3$Ni$_2$O$_7$ Thin Films

The recent discovery of ambient-pressure superconductivity with $T_c$ above 40 K in La$_3$Ni$_2$O$_7$ thin films represents a significant advance in the field of nickelate superconductor. Motivated by the experimental reports, here we study an 11-band $d-p$ Hubbard model with tight-binding parameters derived from \textit{ab initio} calculations, using large scale determinant quantum Monte Carlo and cellular dynamical mean-field theory. Our results reveal that the major superexchange couplings in La$_3$Ni$_2$O$_7$ thin films can be substantially weaker than in the bulk material at 29.5 Gpa. Specifically, the out-of-plane antiferromagnetic correlation between Ni$-d_{3z^2-r^2}$ orbitals is reduced by about 27\% in film, while the in-plane magnetic correlations remain largely unaffected. We evaluate the corresponding antiferromagnetic coupling constants, $J_{\perp}$ and $J_{\parallel}$ using perturbation theory. With regard to charge transfer properties, we find that the biaxial compression in films reduces charge transfer gap. We also resolve the orbital distribution of doped holes and electrons among the in-plane (Ni$-d_{x^2-y^2}$ and O$-p_x/p_y$) and the out-of-plane (Ni$-d_{3z^2-r^2}$ and O$-p_z$) orbitals, uncovering a pronounced particle-hole asymmetry. Theses findings lay a groundwork for the study of low-energy $t-J$ model of La$_3$Ni$_2$O$_7$ films and provide key insights into the understanding of physical distinctions between the film and bulk bilayer nickelates.