Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SDR ORGANIZATION ID

TYPE

DESCRIPTION

51171000

TC DATA ENTRY

All of Continuing Airworthiness (AARDG)

30000

TC SUPS

The Suspected Unapproved parts section (AARTM)

29986

TC PMI

All TC users where role-cd = "WP". The Principal Maintenance Inspector (PMI) organization is auto-maintained by finding any TC Userid’s listed as company PMI’s on the following views

V_CAWIS_AMM_ORGANIZATIONS@NNPRODC.WORLD
V_SDRS_APPROVED_OPERATORS@NNPRODC.WORLD

A Userid meeting the above criteria and that is not already on organization #29986 will get auto-added to that group. Conversely, anyone in this group, not found on TC Directory is de-activated (deleted from M79, and set to inactive on A01)

50049450

TC FSS

Government of Canada, Department of Transport - Flight Services (AAFBA)

This is a special case account, treated as both an internal and external organization with each user having role codes = "WO" (AMO SDR External submitter) and "HU" (TC internal CAWIS user))

...

A Full list is available at Z980_TERM_CONVERSION where Term_type_cd = “SYSID”

...

PMI TROUBLESHOOTING

Quite often, a PMI (organization 29986) will complain that they are not receiving automatic notifications from their designated companies.

PMI userid/COMPANY mapping is performed in these NACIS views :

V_CAWIS_AMM_ORGANIZATIONS@NNPRODC.WORLD
V_SDRS_APPROVED_OPERATORS@NNPRODC.WORLD

which in turn, populate these CAWIS tables, daily

AMO_INFO

AOC_INFO

So it becomes necessary to review, which companies are assigned to which users and possibly contact NACIS management for data updates.

Go into edit mode on that PMI’s Userid, and click “switch to user view”

...

The check the companies assigned to that person by clicking “PMI TOOLBOX” on the left-hand menu.

Image Added

Notes

  1. There are primary, secondary and third userids assigned to many companies. The first non-null Userid found, is deemed to be the PMI for a given company

  2. Many companies have NO PMI/user assigned

  3. Occasionally companies change name - this poses a problem with numbered companies, CAWIS does not see trade names. NACIS lookup required in these instances. If you alter the License_number assigned to a company in CAWIS, it will find the correct PMI in NACIS afterward.

  4. There are many companies assigned to retired TC personnel, however these all pertain to inactive companies. The Emails assigned to these users are “SDRS@TC.GC.CA” to notify SDR management, in case there was ever to be some sort of activity on SDR’s associated with an inactive company.

  5. There are many PMI’s with NO companies assigned to them. They have been allocated to org 29986 because they are CASI’s (Civil Aviation Safety Inspectors) and they need to be able to produce “comprehensive” SDR reports (as opposed to “Concise” SDR reports that are provided to the public and lower security level CAWIS users) The WP role code allows for this.