Information System of Contractor Management

1
Information SystemofContractor Management

• PC Chen
• 10/2004

2
Information System ofContractor Management

• The Management program shall cover
• Contractor Safety
• Contractor Evaluation
• Procedural document and KM

3
Data for Contractor Safety
Structural data
Non-structural data

• SAP
• Vendor Master
• Contracts
• Purchase orders
• Evaluation Records

• SAP Portal
• Procedure
• Regulations
• Training material
• Form
• Reports
• Meeting Minutes
• News, discussion Publication

• ???
• Employee Data
• Training/skill Data
• Evaluation data
• Working Records
• Event/CA Records

Suggest to integrate to SAP.
4
Database Structure

• Master Data
• Contractor master
• Employee master
• Position master
• Skill master
• Training master
• Evaluation master
• Event master
• Transaction Data
• PO records
• Contract records
• Confirmation records
• Evaluation records

• Other Records
• Training records
• License data
• Evaluation details
• Skill registration
• Event/CA records
• Audit, fine records

• Literature (Portal)
• Procedure
• Regulations
• Training material
• Form
• Reports
• Meeting Minutes
• News Publication

S A P
5
Employee master

• Master
• Personal ID number
• Name
• Birth date
• Gender
• Contact code (X)
• Safety Manager(X)
• Vendor code
• Main skill code
• Position code
• Entry block code (X)
• Remark
• Statistic data
• Status
• Create by/date
• Change by/date
• Approve by/date

• Contact data
• Phone
• Mobile phone
• Fax
• Telex
• Email

• Position master
• Position Code
• Position description
• Position type
• S Supervisory
• C Clerical
• E Engineer
• T Technical
• G General services

6
Employee skill master/records

• Skill code master
• Skill Code
• Skill description
• License required (X)
• Category
• M Mechanical
• E Elec./Instr.
• O Others

• Skill Records
• Personal ID
• Skill code
• Register date
• Rate
• License
• Remark
• statistic data
• Status
• Create by/date
• Change by/date
• Approve by/date

7
Employee training master/records

• Training code master
• Training Code
• Description
• Code type
• Training hours
• Mandatory(X)
• Validity period

• Training Records
• Personal ID
• Training code
• Register date
• Training score
• Pass(X)
• End of validity date
• Remark
• Statistic data
• Status
• Create by/date
• Change by/date
• Approve by/date

8
Employee Event master/records

• Event code master
• Event Code
• Description
• Event type

• Event Records
• Event doc. no.
• Contractor code
• Personal ID
• Event code
• Register date
• Event description
• Event class code
• Event status
• Fined dollar
• Remark
• Statistic data
• Status
• Create by/date
• Change by/date
• Approve by/date

• Event class master
• Event class code
• Description
• Degree of seriousness
• CA required ? (X)

Corrective Action Follow-up program
9
Contractor Evaluation

• Eval. Records
• Evaluation number
• Eval type
• General description
• Contractor code
• PO number
• Statistic data
• Status
• Create by/date
• Change by/date
• Approve by/date

• Eval. Type master
• Eval. Type code
• Quality
• Timeliness
• Safety
• Description

Eval.code./score

• Evaluation master
• Eval. type
• Eval Code
• Description
• Max.Score

10
Reporting

• Master data listing
• List of employee, skill, training, event,
  master data
• Record type data listing
• List of training, event, evaluation record data
• Qualified contractor worker listing
• Corrective action follow-up listing
• Vendor evaluation data analysis

11
Procedural document and KM

• Web page in public
• Entry guide
• Entry application form
• General news

• Portal (anonymous)
• Procedure
• Regulations
• Training material
• Form
• Reports
• Meeting Minutes
• News Publication

• Portal (Logon)
• Procedure
• Regulations
• Training material
• Reports
• Discussion

Accessibility shall be considered based on actual
need effectiveness
12
Summary

• Every process owner knows his roles and can
  effectively demo his roles by using this
  information network.
• A periodical report can summarize the weakness of
  running this management program, call process
  owner to take action for improvement....