project BLF > class BUserRole > business logic query UsrRoleByUsrId
Parameters
iiUsrId | integer | |
iiCompanyId | integer | Company id |
query condition
each UsrRole where
UsrRole.Usr_ID = iiUsrId
first Role (inner-join) where
Role.Role_ID = UsrRole.Role_ID AND
each UsrRoleCompany (outer-join) where
UsrRoleCompany.Company_Id = iiCompanyId AND
UsrRoleCompany.UsrRole_ID = UsrRole.UsrRole_ID AND
first Company (outer-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = UsrRoleCompany.Company_ID AND
query resultset tqUsrRoleByUsrId
field name | data type | db field | description |
tiCompany_ID | integer | UsrRoleCompany.Company_ID | Entity |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
tiDomain_ID | integer | Company.Domain_ID | Domain |
tiRole_ID | integer | Role.Role_ID | Record ID |
tcRoleDescription | character | Role.RoleDescription | RoleDescription |
tlRoleIsActive | logical | Role.RoleIsActive | Act |
tcRoleName | character | Role.RoleName | Role Name |
tiUsr_ID | integer | UsrRole.Usr_ID | User |
tiUsrRole_ID | integer | UsrRole.UsrRole_ID | Record ID |
tiUsrRoleCompany_ID | integer | UsrRoleCompany.UsrRoleCompany_ID | Record ID |
tlUsrRoleIsDefaultRole | logical | UsrRole.UsrRoleIsDefaultRole | Indicates the default role per user. |
Internal usage
BLF
QadFinancials