Table : staff

Raw table description

Fields

id id

{
  "name": "id",
  "type": "primaryKey"
}

organizationUnitId M  → organizationUnits

{
  "name": "organizationUnitId",
  "type": "foreignKey",
  "table": "organizationUnits",
  "mandatory": "true"
}

userAccountId M  → userAccounts

{
  "name": "userAccountId",
  "type": "foreignKey",
  "table": "userAccounts",
  "schema": "mspx_admin",
  "mandatory": "true"
}

isAdminOnUnit bit  (Only used for ACCESS_RIGHT_ORGANIZATION_UNIT_ADMIN. Need to have ACCESS_RIGHT_ORGANIZATION_UNIT_ADMIN to be admin on an orgUnit. Protected bit, only set by ACCESS_RIGHT_ADMIN and ACCESS_RIGHT_API)

{
  "name": "isAdminOnUnit",
  "type": "bit",
  "note": "Only used for ACCESS_RIGHT_ORGANIZATION_UNIT_ADMIN. Need to have ACCESS_RIGHT_ORGANIZATION_UNIT_ADMIN to be admin on an orgUnit. Protected bit, only set by ACCESS_RIGHT_ADMIN and ACCESS_RIGHT_API"
}

isDebtUnit bit  (If set to true, this unit will be invoiced for the user. If none is set to true, we will invoice the first orgUnit we can find that the user belongs to. Only one unit can be debtUnit for each userAccountId)

{
  "name": "isDebtUnit",
  "type": "bit",
  "note": "If set to true, this unit will be invoiced for the user. If none is set to true, we will invoice the first orgUnit we can find that the user belongs to. Only one unit can be debtUnit for each userAccountId"
}

displayOrder   (Which order a user should be displayed on websites)

{
  "name": "displayOrder",
  "type": "int",
  "note": "Which order a user should be displayed on websites"
}

isPublic bit  (If user should be visible on websites)

{
  "name": "isPublic",
  "type": "bit",
  "note": "If user should be visible on websites"
}

updatedDate

{
  "name": "updatedDate",
  "type": "updated"
}