BUSINESS INFORMATION ERVER BY VIC ROOZA S
Download
Report
Transcript BUSINESS INFORMATION ERVER BY VIC ROOZA S
BUSINESS INFORMATION SERVER
BY VIC ROOZA
BACKGROUND
BIBC IT in existence since late 1960’s
IBM / Sperry / Unisys Mainframes
RPG / Cobol / Mapper
External Customers
Y2K, Conversion, Migration 1996-2003
2003 – 50% Non Intelligent Terminals
2003 – De-commissioned Mainframe
2003 – Migrated to BIS & Server platform
Complete History records from 1983
CONNECTIVITY AND PROGRAMS
BIS Software is installed on the Server
Desktops from Bellville, Paarl, Somerset West,
Worcester, BWU & TU SFD are all connected to
the Server in Bellville
Over 2500 Programs and screens
BELLVILLE
SOMERSET
WEST
PAARL
BIBC
SERVER
BUILDING
WORKERS
UNION
BIBC
WORCESTER
BIBC
VREDENBURG
TRADE UNION
SICK FUND
SYSTEMS
Accounting
Automation
Holiday Fund
Labour Relations
Medical Aid
Payroll
Pension Fund
Registrations – Employees
Registrations – Employers
Sick Fund
DESIGN & STORAGE CONSIDERATIONS
Rid sizes based on Enquiry / Update
considerations
Use Cabinet / Rid Names if required
Use Year, Month, Account as Rid Number
Where data is spread over 100 Rids, for
example, use last 2 digits of HF No as Rid
Number. Numbers with digits 00 will be found
in rid 100. This allows for rapid data access for
updates and enquiries.
BACKUPS
Daily scheduled Purge
Daily scheduled Incremental Purge
Purge history dating back 12 months
Audit Trails backed up
Backup Site
PRACTICAL EXTRACTS & EXAMPLES
Summarising the 2007 Automation Master File using ;
The Search Function
(S)
The Count Function
(Cnt)
The Sort Function
(Sort)
The Totalise Function
(Tot)
All of these Functions cause a Result
The 2007 file presently containing 1133805 records is stored
across 1000 rids. The last 3 digits of the Member number is
the Rid number. Digits 000 are found in rid 1000
All other Systems are spread across 100 rids, the last 2 digits
of the member number being the rid number .
This provides for instant access and rapid speed of processing
for enquiry or updating by member number
LOOKING AHEAD
BIS 10.1
ICE – Internet Commerce Enabler
GUI – Graphical User Interface
Training and Development
TRAINING AND DEVELOPMENT
IT Staff History
Current IT Staff
The Future
IT Manager
Assistant IT
Manager
Network
Administrator
BIS
Contractor
Trainee
Programmer
Trainee
Programmer
TRAINING AND DEVELOPMENT
Trainee
Programmers
Core Group
BIS Training
Contractor
In House
Training
PDP’s
Mentorship
TRAINING AND DEVELOPMENT - PDP
BIS SYSTEM
AUTOMATION
KNOWLEDGE TYPE
D1 - LOW
COMPETENCY
OPERATIONAL
D2 – SOME
COMPETENCY
X (P1)
OPERATIONAL
X (O2)
DATABASE
PAYOUT
X
X (P2)
OPERATIONAL
X
DATABASE
X
PROGRAMMING
PAYROLL
X
OPERATIONAL
X
DATABASE
X
PROGRAMMING
COMPETENCY
X
PROGRAMMING
PROGRAMMING
D4 – FULL
X (O1)
DATABASE
MEDICAL AID
D3 – GOOD
COMPETENCY
X