Spreadsheet: 67180d1267773908-look-up-two-databases-and-display-certain-values-jobdescriptions
Sheet: Sheet1

Surname | Name | UserID | Job Role |  | Job role | Action Group | Description
King | Nick | NKING | ALLOC_BATCHJOBS |  | ALLOC_BATCHJOBS | ALLOC_BATCHJOBS | Allocations [NAME] |  | [NAME] | ALLOC_BATCHJOBS, CTJR_ARREAR ADV, CTJR_VIEW ONLY, DHO_ARREARS_ACT | Allocations [NAME], GPI Batch Jobs (Letter Production), Create Manual Adjustments, Authorise and Delete Manual Adjustments
King | Nick | NKING | CTJR_ARREAR ADV |  | ALLOC_BATCHJOBS | GPI_BATCHJOBS | GPI Batch Jobs (Letter Production) |  | JOSEPHINE ABBOT | HATENQ, HRAENQ, HRMENQ, HSGJR_VIEWONLY, HSG_CUST_SERV | Produce Ad-hoc Rent Statements, View Rent Accounts, View Rent Accounts, View Addresses, View Admin Units
King | Nick | NKING | CTJR_VIEW ONLY |  | CTJR_ARREAR ADV | ACCADJ_CREATE | Create Manual Adjustments |  | [NAME] | HRAENQ, HRMENQ, HSGJR_VIEWONLY, [NAME], HSG_RMO | Arrears Actions (DHO), [NAME] for DHO staff, View Arrears Details, View Arrears Periods Details, Break Appointment
King | Nick | NKING | DHO_ARREARS_ACT |  | CTJR_ARREAR ADV | ACCADJ_MAINT | Authorise and Delete Manual Adjustments |  | [NAME] | CTJR_VIEW ONLY, [NAME], [NAME], HSG_ALLOCS, HSG_REREG | View Addresses, View Admin Units, Estates Product Area, General Enquiries, [NAME]
[NAME] | jOSEPHINE | JABBOT | CTJR_VIEW ONLY |  | CTJR_ARREAR ADV | ACCOUNT_MAINT | Maintain Rent Accounts
ABBOT | JOSEPHINE | JABBOT | HATENQ |  | CTJR_ARREAR ADV | ACCOUNT_STATMNT | Produce Ad-hoc Rent Statements
ABBOT | JOSEPHINE | JABBOT | HRAENQ |  | CTJR_ARREAR ADV | ACCOUNT_VIEW | View Rent Accounts
ABBOT | JOSEPHINE | JABBOT | HRMENQ |  | CTJR_VIEW ONLY | ACCOUNT_VIEW | View Rent Accounts
ABBOT | JOSEPHINE | JABBOT | HSGJR_VIEWONLY |  | CTJR_VIEW ONLY | ADDRESS_VIEW | View Addresses
ABBOT | JOSEPHINE | JABBOT | HSG_CUST_SERV |  | CTJR_VIEW ONLY | ADMINUNIT_VIEW | View Admin Units
ABELL | [NAME] | ABELLL | HATENQ |  | CTJR_VIEW ONLY | ARREARS_INFO2 | View Arrears Info Without Income Details
ABELL | [NAME] | ABELLL | HRAENQ |  | DHO_ARREARS_ACT | DHO_ARREARS ACT | Arrears Actions (DHO)
ABELL | [NAME] | ABELLL | HRMENQ |  | DHO_ARREARS_ACT | DHO_RENTS | Rents Updating for DHO staff
ABELL | [NAME] | ABELLL | HSGJR_VIEWONLY |  | HRAENQ | ARREARS_DETAILS | View Arrears Details
ABELL | [NAME] | ABELLL | HRMENQ |  | HRAENQ | ARREARS_PERIODS | View Arrears Periods Details
ABELL | [NAME] | ABELLL | HSG_RMO |  | HRMENQ | APT_BREAK | Break Appointment
ACHILLE | [NAME] | DACHIL | ALLOC_BATCHJOBS |  | HRMENQ | APT_CREATE | Create Appointments
ACHILLE | [NAME] | DACHIL | CTJR_VIEW ONLY |  | HSGJR_VIEWONLY | ADDRESS_VIEW | View Addresses
ACHILLE | [NAME] | DACHIL | HRAENQ |  | HSGJR_VIEWONLY | ADMINUNIT_VIEW | View Admin Units
ACHILLE | [NAME] | DACHIL | HRMENQ |  | HSGJR_VIEWONLY | ESTATES | Estates Product Area
ACHILLE | [NAME] | DACHIL | HSG_ALLOCS |  | HSGJR_VIEWONLY | GENENQ | General Enquiries
ACHILLE | [NAME] | DACHIL | HSG_REREG |  | HSGJR_VIEWONLY | HOUSEHOLD_VIEW | [NAME]
 |  |  |  |  | HSG_CUST_SERV | ADDRESS_VIEW | View Addresses
 |  |  |  |  | HSG_CUST_SERV | CONTACT_COM | HCS - Complete Contacts
 |  |  |  |  | HSG_RMO | [NAME] | Appointment View
 |  |  |  |  | HSG_RMO | APP_VIEW | View Appointments
 |  |  |  |  | HSG_RMO | APT_BREAK | Break Appointment
 |  |  |  |  | HSG_REREG | ADDRESS_MAINT | Create and Maintain Addresses
 |  |  |  |  | HSG_REREG | ADDRESS_VIEW | View Addresses