Documents required for a review by the Tenure and Appointments Committee (TAC) for Faculty of Arts and Sciences (FAS) departments can be found here, for the Standing Advisory and Appointment Committee (SAAC) for the Professional Schools can be found here, and for the Medical School can be found here.
One of the ways to determine who is up next for either a reappointment or promotion is to run one of the following reports in Workday: Academic - Expiring Appointments - Yale or Academic - View Current Appointments - Yale.
Best practice is to have the case wrapped up by the pennultimate year.
Consult the Faculty Handbook and contact one of the areas above should you need further assistance.