Related: PBI-172152 - resource Resource monitor report ; PBI-172153 Documentation required
CAWIS version 1.0 used a table called Z930_COLUMNS to administrate the text of all input fields and error messages.
...
A copy of the Resource Monitor report can be found in the attachments section of this article. Its simply a dump of the DA005 table. The advantage of the report, is that it allows the system administrator to “globally” look at review the contents of the resource table when determining required changes.
...
needed to be located and altered to meet the new departmental standards in all onscreen messaging
1 TC.CAWWEBFEEDBACK-RETROACTIONWEBMDLN.TC@TC.GC.CA
though the original email addresses (circulated on CAW publications and forms for 20+ years) have auto-forwards placed on them.
Notes:
Revisions made to the resource table in the CAWIS test regions (DEV/ACC) are not migrated to production during a release. Any revisions made in the test regions need to be copied and pasted into production manually after the release -or- a script would need to be included in the release which updates DA005 accordingly
NOT ALL screen labels are actually found in the DA005 table. Example : the report titles under NEW on the reports menu
Maintenance
...
Revisions to the Resource table can only be
...
performed by
...
a CAWIS
...
admin user on the INTERNAL site.
Maintenance
To access the Resource table admin facility
CAWIS-MAIN-MENU → CODE-TABLE-ADMIN → RESOURCE
Note : this option is ONLY available on the CAWIS Internal site.
Fig 1 CAWIS Code table Admin menu
...
Fig 2 The Resource Monitor page
...
Options
1.Reset CACHE - clear browser Cache
2.Reset APPLICATION DOMAIN - reset all CAWIS Login values (field labels, etc) This need to be done to invoke and review any changes made to the DA005 table using this facility
3.DAPLS - reset/renew DAPLS password. This taken care of by CAWIS admin.
NOTE the actual link to DAPLS is found under AAIR maintenance shown here
...
under “STEP 5 APPLICANT LOOKUP“
unsure why this option is included here, it is unrelated to the function of the resource table. DAPLS info is occasionally used in the AAIR subsystem to acquire contact info for Owner individuals, who also have pilot licenses, when CAWIS contact data is found to be incomplete.
4.Resource Statistics - ?? The Value of this feature is questionable. Client does not understand this.
5.Select a page / enter a value - perform update operations on messages within specified subsystem of CAWIS
...
Fig 3 - Select a page - Identify the page where you need to make updates . In this instance, the 5008 advanced query page
(described here: CAWIS 5008 FILE MAINTENANCE )
Fig 4 - Select a page -
1- In “value”, enter freeform text of the messages you’d like to review (example : weight - returns all messages/labels related to aircraft weights found on that page )
2- in “select a key” we select the actual label to be updated - in this example, lblACWeight.Text
...
In this instance we make any desired update to the screen label in the VALUE box, then punch SAVE, Reset CACHE, Reset APPLICATION Domain - then go to the 5008 screen advanced search page and review our change on a sample aircraft down in the Weight section
...
Fig 6 Make a change, save & Reset Application Domain
...
Fig 7 Label change is successfully reflected on the 5008 advanced search 
REPORT REQUIRED - CAWIS MESSAGES
###################################################
select
PATH_NM || ' ' ,
KEY_CD || ' ' ,
CULTURE_NM || ' ' ,
GLOBAL_IND || ' ' ,
VALUE_TXT || ' ' ,
VIRTUAL_KEY_NUM || ' ' ,
to_char(DATE_CREATED_DTE,'YYYY-MM-DD') || ' ',
TO_CHAR(DATE_DELETED_DTE,'YYYY-MM-DD') || ' ',
TO_CHAR(DATE_LAST_UPDATE_DTE,'YYYY-MM-DD') || ' ',
USER_LAST_UPDATE_ID || ' ',
TO_CHAR(SYSDATE,'YYYY-MM-DD') || ' ' AS RUNDATE
from DA005_RESOURCE ;
####################################################