CAWIS/WSDRS USERID DATA ENTRY

Owned by kurt.martin
Last updated: Feb 14, 2022
3 min read

In the event, that a person phones or emails a request for access, proceed as follows.

TC employee

  • as previously noted, a TC employee will already be on the User tables.

  • Simply go to CAWIS-MAIN-MENU → Code Table Admin → Security → User

  • locate the user, if not found, check again tomorrow

 

 

  • then allocate a CAWIS ROLE CODE and password. All of the addressing info is synced against TC_directory, daily

  • TC users outside of Continuing Airworthiness are only ever given the role codes TU, TU, WP (for PMI’s) and WO (for Flight services people, only)

 

External/Industry requestor

There are 2 options available :

  • 1) allocate a new user_id as seen above, then go to the WSDRS subsystem and assign this new user to a company - or

  • 2) go directly to WSDRS--> User Maintenance and perform the entire task from there

 

Recurrent Error

For reasons unknown, External registrants often receive the “This number is already in use” error.

Examining M79 usually shows that the document number is NOT already in use under the submitter type specified by the requestor (1-AME,2-AMO,3-AOC) , but the number DOES exist on M79, under other submitter types.

Documented in : PBI 115109 , PBI 115110

At the moment (2021-10-26) , this condition has been tested in all regions, and cannot be reproduced.

NOTE: all AME/AMO/AOC numbers should be stripped down to numeric characters ONLY, before being evaluated against AME_info, AMO_info, AOC_info for validity and M79_sdr_submitter for prior use

The system allows registry of the same document number, provided submitter types are different (co-incidentally identical AMO, AOC numbers for example)

In the case of AME numbers, they need to be “active”

To acquire testing data, the query below retrieves existing AMO/AOC/AME document numbers, where the entities co-incidentally having matching document numbers, and these numbers do not yet exist as SDR users (M79 table)

/* IDENTIFY COMMON NUMBERS FOR AMO,AOC,AME /
/ AMO/AOC MATCH /
SELECT 'AMO' TYP, TO_CHAR(X.APPROVAL_NO) NUM, X.LEGAL_NAME FROM AMO_INFO X
WHERE X.APPROVAL_NO IN (SELECT CERTIFICATE_NO FROM AOC_INFO)
and TO_CHAR(X.APPROVAL_NO) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER)
UNION
/ AOC/AMO MATCH /
SELECT 'AOC', TO_CHAR(X.CERTIFICATE_NO), X.LEGAL_NAME FROM AOC_INFO X
WHERE X.CERTIFICATE_NO IN (SELECT APPROVAL_NO FROM AMO_INFO)
AND TO_CHAR(X.CERTIFICATE_NO) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER)
UNION
/ AMO/AME MATCH /
SELECT 'AMO' TYP, TO_CHAR(X.APPROVAL_NO) NUM, X.LEGAL_NAME FROM AMO_INFO X
WHERE TO_CHAR(X.APPROVAL_NO) IN (SELECT NACIS_ID FROM AME_INFO)
and TO_CHAR(X.APPROVAL_NO) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER)
UNION
/ AME/AMO MATCH /
SELECT 'AME', TO_CHAR(X.NACIS_ID), X.LASTNAME ||','||
X.FIRSTNAME || '-' || X.INACTIVE FROM AME_INFO X
WHERE X.NACIS_ID IN (SELECT TO_CHAR(APPROVAL_NO) FROM AMO_INFO)
AND TO_CHAR(X.NACIS_ID) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER)
UNION
/ AOC/AME MATCH /
SELECT 'AOC' TYP, TO_CHAR(X.CERTIFICATE_NO) NUM, X.LEGAL_NAME FROM AOC_INFO X
WHERE TO_CHAR(X.CERTIFICATE_NO) IN (SELECT NACIS_ID FROM AME_INFO)
and TO_CHAR(X.CERTIFICATE_NO) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER)
UNION
/ AME/AOC MATCH */
SELECT 'AME', TO_CHAR(X.NACIS_ID), X.LASTNAME ||','||
X.FIRSTNAME || '-' || X.INACTIVE FROM AME_INFO X
WHERE X.NACIS_ID IN (SELECT TO_CHAR(CERTIFICATE_NO) FROM AOC_INFO)
AND TO_CHAR(X.NACIS_ID) NOT IN (SELECT LICENSE_NBR FROM M79_SDR_SUBMITTER) ;