TC INTERNAL |
WSDRS/TC INTERNAL |
WSDRS EXTERNAL |
SYSTEM USERIDS |
TC internal
I) ACTIVE
Includes All TC Continuing Airworthiness users – Role code AU=ADMIN
All TC regional airworthiness users – HU (allows 5008 & WSDRS read/update access)
All other TC Civil Aviation personnel – TU=Read only (allows 5008 & WSDRS read access)
Regional PMI’s with SDR submitting companies reporting to them - WP (allows 5008 & WSDRS read/update access - same as role code HU, but with SDR inbox and notification features)
II) INACTIVE
Note: TC users NOT found on TC_directory_client are automatically set to inactive.
TC_directory_client sample
This category consists of retired personnel and inactive users imported from TC Directory.
Its mandatory that all CAWIS TC users, have a Userid that matches their TC Network id. To help manage this, CAWIS imports ALL TC_userid’s as they appear on TC Directory during the overnight sync job. They are saved with an NS (no services) role code until needed.
This helps to
prevent data entry errors when allocating accounts for new staff (since the required ID will already be on file, the CAWIS manager need only assign a Role code and password ) This was a frequent issue when CAWIS was first released.
prevent conflicts with new external WSDRS Userids since they are allocated with the same logic as used by TC Directory. (Enhancement request : ALL new external WSDRS userids should be allocated with a numeric digit suffix)
III) WSDRS TC internal
TC users in these Organization have full update and submission access to WSDRS. There are 4 TC User organizations in CAWIS/WSDRS
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 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 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)) |
ALL CAWIS users are stored on the A01_USER table with a Party_id linking to Y50_party, Y55_individual.
ALL WSDRS users are tied together into Organizations on the M79_SDR_SUBMITTER table
External accounts
An External account is an USER NOT found on TC_directory_client and not having a tc.gc.ca email domain
All External accounts pertain to the WSDRS subsystem.
CAWIS has a public Airworthiness Directive page and a Public SDR search page, neither of these pages require user accounts.
The public AAIR subsystem requires a user ACCESS Code, (tied to user Client_id/party_id) which maps directly to the system userid CLIENT.
System userid’s
Some Examples of system Ids - “CLIENT”, “ccarcsupd”, “AAIRRUN” etc . . .
These are Specific purpose userids that are never to be altered or deactivated.
A Full list is available at Z980_TERM_CONVERSION where Term_type_cd = “SYSID”
0 Comments