Product | Admissions |
|---|---|
Database Path | CVMSQLSVR.ProfessionalProgram |
TDX - Incident | https://service.tamu.edu/TDNext/Apps/34/Tickets/TicketDet.aspx?TicketID=46042 |
TDX - Service | https://service.tamu.edu/TDNext/Apps/34/Tickets/TicketDet.aspx?TicketID=46355 |
Overview
User requested information on supplemental applications for the year 2025. This data is not within the Custom Application Data Report.
Technical Notes
[include query scripts or reports that were used to produce the data]
...
| Code Block | ||
|---|---|---|
| ||
WITH RankedScores AS (
SELECT supp.[Id],
supp.[ApplicantId],
supp.[Year],
supp.[IsPaid],
supp.[IsSubmitted],
appl.[TmdsasUserId],
us.[UserID],
us.FirstName,
us.LastName,
score.DateModified,
ROW_NUMBER() OVER (PARTITION BY supp.Id ORDER BY score.DateModified DESC) AS RowNum
FROM [ProfessionalProgram].[dbo].[Ads_SupplementalApplication] supp
LEFT JOIN [ProfessionalProgram].[dbo].[Ads_Applicant] appl ON appl.Id = supp.ApplicantId
LEFT JOIN Users.dbo.tblUser us ON us.UserID = appl.UserId
LEFT JOIN [ProfessionalProgram].[dbo].[Ads_SupplementalApplicationScore] score
ON score.SupplementalApplicationId = supp.Id
WHERE supp.Year = 2025
)
SELECT RankedScores.[Id],
RankedScores.[ApplicantId],
RankedScores.[Year],
RankedScores.[IsPaid],
RankedScores.[IsSubmitted],
RankedScores.[TmdsasUserId],
RankedScores.[UserID],
RankedScores.FirstName,
RankedScores.LastName,
RankedScores.DateModified AS LastSubmittedScoreDate
FROM RankedScores
WHERE RankedScores.RowNum = 1
AND RankedScores.DateModified IS NOT NULL
AND RankedScores.DateModified BETWEEN '2024-08-30' AND GETDATE()
ORDER BY LastSubmittedScoreDate DESC; |
Background History:
I need to run a final report for supplemental application submission date. Previous reports show the below information with the date showing the date (ex. 10/1/24) and the time (ex. 3:50 PM).
...