Unit of competency Outline

Date retreived
23/07/2026 2:36 AM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Maintain and use security database

Maintain and use security database

Unit of competency
National Code
CPPSEC3021A
State Code
D1422
TGA Status
Replaced
DTWD Status
Replaced
Current Release Number
1.00
Current Release Date
07/04/2011
State Implementation and Classification
Approved Date
31/10/2008
Field of Education
029901 - Security Science
Original Release Date
31/10/2008
Nominal Hours
8
Description
This unit of competency specifies the outcomes required to maintain and use database software and hardware in a security context. It requires the ability to use software and hardware appropriate to the task, input verifiable data in a standardised style and format, and fully backup and recover a database. It also requires an ability to identify and solve common database performance problems and compile reports. This unit may form part of the licensing requirements for persons involved in security operations in those states and territories where these are regulated activities.
Notes
Elements and Performance Criteria
1Prepare to use security database.
  • 1.1 Applicable provisions of legislative and organisational requirements relevant to operating a security database are identified and complied with.
  • 1.2 Ergonomic and conservation issues are identified and appropriate risk control measures implemented in accordance with Occupational Health and Safety (OHS) guidelines.
  • 1.3 Appropriate software and hardware is identified to meet task requirements and installed in accordance with manufacturer's instructions.
  • 1.4 Virus protection is monitored, maintained regularly updated to ensure the continuous integrity and protection of data.
  • 1.5 Database storage, security and access requirements are identified and complied with to ensure the confidentiality and security of data.
  • 1.6 Established housekeeping, maintenance and back-up procedures are identified and conducted on a routine basis.
  • 1.7 Stand-by database and alternative strategies are identified and implemented as required to address operational faults and deficiencies in database systems.
2Use security database.
  • 2.1 Data entry, output and presentation requirements are identified and complied with in accordance with assignment instructions.
  • 2.2 Data is obtained from verifiable sources, checked and monitored for variations in data quality.
  • 2.3 Data is entered, checked for accuracy and updated as required.
  • 2.4 Errors and lags in data processing or discrepancies are identified, diagnosed and reported.
  • 2.5 Complex faults or repair requirements outside area of responsibility or competence are reported for specialist assistance.
  • 2.6 Measures to improve database content, interfaces or effectiveness are identified and confirmed with relevant persons.
3Compile reports.
  • 3.1 Reports are prepared in a timely manner using appropriate formats and presentation methods.
  • 3.2 Reports are produced using relevant data and are reviewed and checked for accuracy.
  • 3.3 Constructive feedback to improve and maintain security database systems is received and used to inform future practice.
  • 3.4 Procedures for the safe storage and protection of data are identified and complied with in accordance with organisational procedures.
  • 3.5 Relevant documentation is completed and securely maintained with due regard to confidentiality in accordance with organisational procedures.
RANGE STATEMENT
The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.
Legislative requirements may relate to:
Australian standards and quality assurance requirements
counter-terrorism
crowd control and control of persons under the influence of intoxicating substances
force continuum, use of force guidelines
general 'duty of care' responsibilities
licensing or certification requirements
privacy and confidentiality
relevant commonwealth, state and territory legislation, codes and national standards for:
anti-discrimination
cultural and ethnic diversity
environmental issues
equal employment opportunity
industrial relations
OHS
relevant industry codes of practice
telecommunications
trespass and the removal of persons.
Organisational requirements may relate to:
access and equity policies, principles and practices
business and performance plans
client service standards
code of conduct, code of ethics
communication and reporting procedures
complaint and dispute resolution procedures
emergency and evacuation procedures
employer and employee rights and responsibilities
OHS policies, procedures and programs
own role, responsibility and authority
personal and professional development
privacy and confidentiality of information
quality assurance and continuous improvement processes and standards
resource parameters and procedures
roles, functions and responsibilities of security personnel
storage and disposal of information.
Ergonomic considerations may include:
avoiding radiation from computer screens
chair height, seat and back adjustment
document holder use
footrest use
lighting
noise minimisation
posture
rest periods and exercise breaks
screen, keyboard and mouse positions
work station height and layout.
Conservationtechniques may include:
recycling used and shredded paper
using of double sided paper
using re-used paper for drafts (observing confidentiality requirements)
utilising power-save options for equipment.
Security and accessprocedures may include:
data inputting
search and browse authorities
viewing and operation
write permission.
Back-up:
facilities range from a single tape unit to more comprehensive and complex backup facilities across the network.
Data entry, output and presentationprocedures include:
author's instructions
coding
data input
fault-finding
installation or de-installation of software or hardware
location and storage of data
log-on
password protection
standard formats
start-up or shutdown
troubleshooting
use of templates.
Sourcesmay include:
computer data files
government documents and registers
media reports
policy statements
statistical summaries
statutes.
Checksmay include:
consistency of data
ensuring accuracy of data
ensuring accuracy of formulae
ensuring instructions with regard to content and format have been followed filtering
proofreading
spelling.
Diagnosismay relate to:
hardware
input
output
running
software.
Relevant personsmay include:
clients
management
other professional or technical staff
security consultants
security personnel.
Feedbackmay include:
comments from management, colleagues or clients
formal and informal performance appraisals
personal, reflective behaviour strategies
workplace assessment.
Procedures for thestorage and protection of datamay relate to:
authorised access requirements
CD-ROM backup
maintaining hard copies
secure filing locations
storage (eg folders, sub-folders, hard drives, CDs, DVDs)
Documentationmay include:
costings
equipment faults and diagnosis
materials used, parts and components replaced
operational details
recommended repairs or disposal of equipment
repairs or servicing undertaken
testing and inspection results.
EVIDENCE GUIDE
The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria, required skills and knowledge, range statement and the Assessment Guidelines for the Training Package.
Critical aspects for assessment and evidence required to demonstrate competency in this unit
A person who demonstrates competency in this unit must be able to provide evidence of:
accurately diagnosing and rectifying errors and lags in data processing
implementing a broad application of database functions using accurate data inputting techniques to complete work tasks within designated timeframes
monitoring and reviewing database effectiveness and using constructive feedback to improve and maintain database systems.
producing reports in required formats in a timely manner and reviewing for accuracy, compatibility and reliability of data
using established storage, protection and backup procedures and security and access systems to maintain database effectiveness and data integrity.
Context of and specific resources for assessment
Context of assessment includes:
a setting in the workplace or environment that simulates the conditions of performance described in the elements, performance criteria and range statement.
Resource implications for assessment include:
access to plain English version of relevant statutes and procedures
access to a registered provider of assessment services
access to a suitable venue and equipment
assessment instruments including personal planner and assessment record book
work schedules, organisational policies and duty statements.
Reasonable adjustments must be made to assessment processes where required for people with disabilities. This could include access to modified equipment and other physical resources, and the provision of appropriate assessment support.
Method of assessment
This unit of competency could be assessed using the following methods of assessment:
observation of processes and procedures
questioning of underpinning knowledge and skills.
Guidance information for assessment
Assessment processes and techniques must be culturally appropriate and suitable to the language, literacy and numeracy capacity of the candidate and the competency being assessed. In all cases where practical assessment is used, it should be combined with targeted questioning to assess the underpinning knowledge.
Oral questioning or written assessment may be used to assess underpinning knowledge. In assessment situations where the candidate is offered a choice between oral questioning and written assessment, questions are to be identical.
Supplementary evidence may be obtained from relevant authenticated correspondence from existing supervisors, team leaders or specialist training staff.
Replaces
State Code National Code Title Type
S3820 PRSSO326A Maintain and use security database Unit of competency
Replaced By
State Code National Code Title Type
OAP52 CPPSEC3109 Use and maintain security databases and compile reports Unit of competency