<!--- Resolve employeeId / employeeIdVal for Vertex API (session, file uploader, username lookup) --->
<cfparam name="vertexEmployeeFallback" default="0" />
<cfif NOT isDefined("employeeId")>
    <cfset employeeId = 0 />
</cfif>
<cfset employeeIdVal = val(employeeId) />

<cfif employeeIdVal LTE 0>
    <cfset vertexEmpSessionKeys = "employeeid,EmployeeId,EmployeeID,ULoginID" />
    <cfloop list="#vertexEmpSessionKeys#" index="vertexEmpKey">
        <cfif structKeyExists(session, vertexEmpKey) AND val(session[vertexEmpKey]) GT 0>
            <cfset employeeIdVal = val(session[vertexEmpKey]) />
            <cfbreak />
        </cfif>
    </cfloop>
</cfif>

<cfif employeeIdVal LTE 0 AND val(vertexEmployeeFallback) GT 0>
    <cfset employeeIdVal = val(vertexEmployeeFallback) />
</cfif>

<cfif employeeIdVal LTE 0 AND structKeyExists(session, "Username") AND len(trim(session.Username & "")) AND val(session.AgencyID) GT 0>
    <cfquery name="qVertexEmpByUsername" datasource="#Application.DataSrc#">
        SELECT Emp_ID
        FROM #Request.prefix_db_lookup#.pEmployee
        WHERE Username = <cfqueryparam value="#trim(session.Username)#" cfsqltype="cf_sql_varchar">
        AND Loc_ID = <cfqueryparam value="#val(session.AgencyID)#" cfsqltype="cf_sql_integer">
        AND Status = 0
        LIMIT 1
    </cfquery>
    <cfif qVertexEmpByUsername.recordCount AND val(qVertexEmpByUsername.Emp_ID) GT 0>
        <cfset employeeIdVal = val(qVertexEmpByUsername.Emp_ID) />
    </cfif>
</cfif>

<cfset employeeId = employeeIdVal />
