SELECT OrgId, OrgType
FROM tbl_FSPro_Members
WHERE FSL_TableCode =
AND OwnerId =
AND FSPro_UserId =
AND nullif( orgType, '' ) is not null
SELECT o.oprcompanyType, o.FSL_ChoId, o.territoryId
FROM tbl_FSPro_Members m
INNER JOIN tbl_OPR_ClientOperators o
ON m.OrgId = o.OperatorID
WHERE m.FSL_TableCode =
AND m.OwnerId =
AND m.FSPro_UserId =
SELECT cho.cho_name, cho.cho_id, o.territoryId
FROM tbl_OPR_ClientOperators o
INNER JOIN tbl_OPR_ClientOperators o2
ON o.OwnerID = o2.FSL_ChoId
AND o2.FSLTableCode =
AND o2.OwnerId =
INNER JOIN tbl_CHO_Operators cho
ON o2.FSL_ChoId = cho.cho_id
AND cho.cho_1FSSchoolsMember = 'Y'
WHERE o.FSL_ChoID =
AND o.FSLTableCode = 'CHO'
AND o2.oprcompanytype = 'G'
AND o2.crmactive = 'Y'
client.skuOwnerId = _skuOwnerId;
client.skuOwnerType = _skuOwnerType;
client.ofsOrgId = _ofsOrgId;
client.ofsOrgType = _ofsOrgType;
if (isdefined("_ofsSchoolGpoId")) { client.ofsSchoolGpoId = _ofsSchoolGpoId; } else { client.ofsSchoolGpoId = 0; }
if (isdefined("_ofsBrokerRole")) { client.ofsBrokerRole = _ofsBrokerRole; } else { client.ofsBrokerRole = 0; }
client.ID = variables.FSPro_UserID;
client.User = "#variables.FirstName# #variables.LastName#";
client.User_First = variables.FirstName;
client.User_Last = variables.LastName;
client.User_Zip = variables.ZipCode;
client.login = 1;
client.listGroups = variables.ListGroups;
client.listSecAreasIDs = variables.secureids;
client.fsproUserId = variables.FSPro_UserID;