...
Publishing to acceptance and production CAWIS External: use the Staging profile to publish to acceptance and production. It does not contain the admin modules. Using the incorrect profile will expose protected B info. CAWIS Internal: use the Acc profile to publish to acceptance and production Refer to the following document: |
|---|
Updated Messages, Labels, etc.
The scripts are backed up to: \\Tc4s0a\groups\AARA\AARAD\CAWIS\Developer_Documents\_backups\317538_CAWIS_Notification_Emails_RDIMS_Link
AAIR Accounts on development and acceptance:
SCENARIO | USER ID | Mark (tailmark) |
|---|---|---|
Password for all accounts is Clark2005! for development and acceptance | ||
005256 | ||
Single Aircraft | 005197 | |
Owner not reported in years | 596873 | |
Regular user | 014885 | |
Fleet | 558885 | FALE |
Fleet | 003530 | One of them is GDCL |
Goes directly to Modify mode without having to press a Modify button. | 004084 | |
007278 | ||
...
TC login uses the TC login ID but the password is not the same.
For TC Login, the same credential works on both CAWIS internal and external.
I have provided access for the TC Login option on CAWIS development and acceptance to all members of the maintenance team.
Maintenance team have access to CAWIS prod for maintenance purposes only (Only for work related to tasks submitted by the client. No changes can be made without approval from the client)
AAIR does not use our TC Login credentials.
AAIR login is unlocked on CAWIS external for development and acceptance.
The same AAIR credentials work on both CAWIS external and internal
AAIR login is currently purposely locked on prod per work that Hiren and I collaborated on in March 2023
See also https://dev.azure.com/transport-canada/DSD-CIVAV%20Support/_boards/board/t/AAIR/Backlog%20items
AAIR login is locked on all CAWIS internal instances (development, acceptance and production).
See Subtask 301363 https://dev.azure.com/transport-canada/DSD-CIVAV%20Support/_boards/board/t/AAIR/Backlog%20items
Should the option for AAIR login be displayed on CAWIS internal?
AAIR - Export Query for AAIR Owner’s Update List
By using this query, we can generate the updated data regarding the addresses of aircraft owners.
Need to modify according to the requirement of start date and end date.
Export the result in Excel or CSV through TOAD.
| Code Block | ||
|---|---|---|
| ||
/* Formatted on 2024-02-27 10:41:38 AM (QP5 v5.294) */
SELECT --Y02.aircraft_id,
Y50.CLIENT_ID,
Y55.NAME_FIRST_NM || ' ' || Y55.NAME_LAST_NM AS OWNER,
Y56.NAME_COMMON_NM,
--Existing Address
--A90.ADDRESS_ID,
A90.ADDRESS_LINE1_TXT,
A90.ADDRESS_LINE2_TXT,
A90.CITY_TXT,
A90.PROVINCE_CD,
A90.POSTAL_CODE_ID,
TR21.COUNTRY_ETXT,
-- New Address if anything change
CASE
WHEN A90.ADDRESS_LINE1_TXT <> A90.ADDRESS_LINE1_UPDATED_TXT
THEN
A90.ADDRESS_LINE1_UPDATED_TXT
WHEN A90.ADDRESS_LINE1_TXT IS NULL
AND TRIM (A90.ADDRESS_LINE1_UPDATED_TXT) IS NOT NULL
THEN
A90.ADDRESS_LINE1_UPDATED_TXT
END
AS UPDATED_ADDRESS_LINE1,
CASE
WHEN A90.ADDRESS_LINE2_TXT <> A90.ADDRESS_LINE2_UPDATED_TXT
THEN
A90.ADDRESS_LINE2_UPDATED_TXT
WHEN A90.ADDRESS_LINE2_TXT IS NULL
AND TRIM (A90.ADDRESS_LINE2_UPDATED_TXT) IS NOT NULL
THEN
A90.ADDRESS_LINE2_UPDATED_TXT
END
AS UPDATED_ADDRESS_LINE2,
CASE
WHEN A90.CITY_TXT <> A90.CITY_UPDATED_TXT
THEN
A90.CITY_UPDATED_TXT
WHEN A90.CITY_TXT IS NULL
AND TRIM (A90.CITY_UPDATED_TXT) IS NOT NULL
THEN
A90.CITY_UPDATED_TXT
END
AS UPDATED_CITY_TXT,
CASE
WHEN A90.PROVINCE_CD <> A90.PROVINCE_UPDATED_CD
THEN
A90.PROVINCE_UPDATED_CD
WHEN A90.PROVINCE_CD IS NULL
AND TRIM (A90.PROVINCE_UPDATED_CD) IS NOT NULL
THEN
A90.PROVINCE_UPDATED_CD
END
AS UPDATED_PROVINCE_CD,
CASE
WHEN A90.POSTAL_CODE_ID <> A90.POSTAL_CODE_UPDATED_ID
THEN
A90.POSTAL_CODE_UPDATED_ID
WHEN A90.POSTAL_CODE_ID IS NULL
AND TRIM (A90.POSTAL_CODE_UPDATED_ID) IS NOT NULL
THEN
A90.POSTAL_CODE_UPDATED_ID
END
AS UPDATED_POSTAL_CODE,
CASE
WHEN A90.COUNTRY_CD <> A90.COUNTRY_UPDATED_CD
THEN
TR21U.COUNTRY_ETXT
WHEN A90.COUNTRY_CD IS NULL
AND TRIM (A90.COUNTRY_UPDATED_CD) IS NOT NULL
THEN
TR21U.COUNTRY_ETXT
END
AS UPDATED_COUNTRY_CD,
(SELECT A92.ADDRESS_PROPERTY_TXT
FROM A92_ADDRESS_PROPERTY A92
WHERE A92.ADDRESS_ID = A90.ADDRESS_ID
AND A92.ADDRESS_PROPERTY_TYPE_CD = '1'
AND A92.ORDINAL_NBR = 1
AND A92.Last_Mod_timestamp_dte BETWEEN TO_DATE ('01Dec2023')
AND TO_DATE ('05Feb2024'))
AS ADDR_PHONE,
A92.ADDRESS_PROPERTY_TXT AS ADDR_EMAIL,
A90.Last_Mod_timestamp_dte
FROM Y50_PARTY Y50
LEFT JOIN Y90_PARTY_CONTACT Y90 ON Y90.PARTY_ID = Y50.PARTY_ID
JOIN A90_ADDRESS A90
ON A90.ADDRESS_ID = Y90.ADDRESS_ID
AND A90.Last_Mod_timestamp_dte BETWEEN TO_DATE ('01Dec2023')
AND TO_DATE ('05Feb2024')
LEFT OUTER JOIN Y55_INDIVIDUAL Y55 ON Y55.PARTY_ID = Y50.PARTY_ID
LEFT OUTER JOIN Y56_ORGANIZATION Y56 ON Y56.PARTY_ID = Y50.PARTY_ID
LEFT JOIN A92_ADDRESS_PROPERTY A92
ON A90.ADDRESS_ID = A92.ADDRESS_ID
AND A92.ADDRESS_PROPERTY_TYPE_CD = '3'
AND A92.Last_Mod_timestamp_dte BETWEEN TO_DATE ('01Dec2023')
AND TO_DATE ('05Feb2024')
LEFT OUTER JOIN TR21_COUNTRY TR21 ON TR21.COUNTRY_CD = A90.COUNTRY_CD
LEFT OUTER JOIN TR21_COUNTRY TR21U
ON TR21U.COUNTRY_CD = A90.COUNTRY_UPDATED_CD
WHERE TRIM (A90.ADDRESS_LINE1_UPDATED_TXT) IS NOT NULL
OR TRIM (A90.ADDRESS_LINE2_UPDATED_TXT) IS NOT NULL
OR TRIM (A90.CITY_UPDATED_TXT) IS NOT NULL
OR TRIM (A90.COUNTRY_UPDATED_CD) IS NOT NULL
OR TRIM (A90.POSTAL_CODE_UPDATED_ID) IS NOT NULL
OR TRIM (A90.PROVINCE_UPDATED_CD) IS NOT NULL
AND A90.ADDRESS_ID IN
(SELECT Y90.ADDRESS_ID
FROM Y02_AIRCRAFT_HISTORY Y02
JOIN Y53_PARTY_LIST Y53
ON Y53.AIRCRAFT_PARTY_LIST_ID = Y02.AIRCRAFT_ID
JOIN Y50_PARTY Y50 ON Y50.PARTY_ID = Y53.PARTY_ID
LEFT JOIN Y90_PARTY_CONTACT Y90
ON Y90.PARTY_ID = Y50.PARTY_ID
WHERE -- Y02.AIRCRAFT_ID = 14633 AND
NOT EXISTS
(SELECT 1
FROM Y02_AIRCRAFT_HISTORY Y02a
WHERE Y02a.AIRCRAFT_ID =
Y02.AIRCRAFT_ID
AND Y02A.DATE_START_DTE >
Y02.DATE_START_DTE)
AND Y90.ADDRESS_TYPE_CD = '1'
AND Y53.DATE_STOP_DTE IS NULL
AND Y02.ACTIVE_INACTIVE_IND = 'A'
AND Y53.REGISTERED_OWNER_IND = 'Y')
ORDER BY A90.Last_Mod_timestamp_dte DESC; |