Get check-in/out status of a GroupShare file

Is there a GroupShare API call which specifies whether a language file is checked in or out?

This API call seems to be the closest I can find as it has germane information but it doesn't have the specific detail I need.

If there is no such API call, can anyone help with a DB query using the username and language file ID? I have something which I thought was correct but it doesn't match with the GroupShare web UI when the project contains multiple translatable files.

SELECT
    TOP (1) fo.FileOperationTypeId,
                fo.Comment,
                LanguageFileUniqueId,
                f.[Name]
FROM
    [SDLSystem].[proj].[ProjectFile] pf
    INNER JOIN [SDLSystem].[proj].[ProjectUser] pu ON pf.ProjectId = pu.ProjectId
    INNER JOIN [SDLSystem].[proj].[FileOperation] fo ON pf.ProjectId = fo.ProjectId
    INNER JOIN [SDLSystem].[proj].[LanguageFile] lf ON pf.ProjectFileId = lf.ProjectFileId
    INNER JOIN [SDLSystem].[proj].[File] f ON lf.LanguageFileId = f.LanguageFileId
WHERE
    pu.[User] = @username
AND
    pf.ProjectFileRoleId = 1 -- Translatable
AND
    lf.LanguageFileUniqueId = @language_file_id
ORDER BY
    fo.FileOperationId DESC;