Page Comparison

...

• CAMIS.YA096_PERSON

• CAMIS.YA001_MEDICAL_EXAMINER

• CAMIS.YA006_PERSON_TELEPHONE

• CAMIS.UA031_MEDICAL_EXAMINER_OFFICE

• CAMIS.UA041_MEDICAL_OFFICE_TEL

• CAMIS.UA045_STAMP

• CAMIS.AA008_APPLICATION_USER

Note: the following table TC019_ADDRESS contain reference data for UA031_MEDICAL_EXAMINER_OFFICE.

The rows to backup can be identified by running queries similar to the following

1) A query to select the relevant rows from UA045_STAMP based on MEDICAL_OFFICE_ADDRESS IDS

select distinct MEDICAL_OFFICE_ADDRESS_ID from UA045_STAMP
where MEDICAL_EXAMINER_PERSON_ID in (762968,
762940,
762942,	
762818,
762900,
762960,
762967,
721858,
762965,
762964,
762966,
762921,
763069,
762968,
762940,
762942,	
762818,
762900,
762960,
762967,
721858,
762965,
762964,
762966,
762921,
763069)

2) Query to retrieve the Medical Office Addresses from UA031_MEDICAL_EXAMINER_OFFICE:
TC019_ADDRESS

select * from UA031_MEDICAL_EXAMINER_OFFICE
where MEDICAL_OFFICE_ADDRESS_ID in(100607,
325820,
352444,
352403,
249515,
352383,
352423,
352424)

Exporting data to “sql” script files:

...

Insert into CAMIS.UA045_STAMP
(STAMP_NUMBER_TXT, MEDICAL_EXAMINER_PERSON_ID, MEDICAL_OFFICE_ADDRESS_ID, STAMP_ASSIGNED_DTE, DATE_CREATED_DTE,
DATE_LAST_UPDATE_DTE, USER_LAST_UPDATE_ID)
Values
('2159', 558662, 346591, TO_DATE('2023/07/01', 'YYYY/MM/DD'), TO_DATE('2023/07/21 7:45:01 AM', 'YYYY/MM/DD HH:MI:SS AM'),
TO_DATE('2023/07/21 7:45:01 AM', 'YYYY/MM/DD HH:MI:SS AM'), 557838);
COMMIT;
code