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 previously imported from TC Directory.
Its mandatory that all CAWIS TC users, have a Userid that matches their TC Network id. To help manage this rule, 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 is done 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 the Organizations listed below have full update and submission access to both the 5008/AAIR subsystem and 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 any USER that is 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