client workstations for tv content management system gambarajah.pdf · client workstations for tv...

30
Client Workstations for TV Content Management System Storage server (12TB) Content Quality x 16 (Level 2) Network Switch Creative Content Unit x 6 (Level 1) Film Censorships x 6 (LG) Network Switch Network Switch Library x 3(LG) Channel (TV1, TV2, TVi , BES, and Promo) x 5 (Level 1) Application server Web server RTM Web Diagram - 1

Upload: nguyendan

Post on 04-May-2018

218 views

Category:

Documents


3 download

TRANSCRIPT

Client Workstations for TV Content Management System Storage server (12TB) Content Quality x 16 (Level 2)

Network Switch

Creative Content Unit x 6 (Level 1)

Film Censorships x 6 (LG)

Network Switch

Network Switch

Library x 3(LG)

Channel (TV1, TV2, TVi , BES, and Promo) x 5 (Level 1)

Application server Web server

RTM Web

Diagram - 1

W-1

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – SYNDICATION

Page 1 of 7

MODULE 1

MODULE 1 : ONLINE WEB PORTAL AND REGISTATION

Log information of invitees

Content provider upload associated supporting doc (Company profile, certificates, bank statement)

Validate company registration checklist

Pre- Selection of successful company Refer to appendix A

rejected

end

Online Web Portal Supplier register / updates company

details on web portal (company profile)

OK

validate

Start module 1

End Module 1

W-1

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – SYNDICATION

Page 2 of 7

MODULE 2

MODULE 2 : NEED STATMENT AND INVITATION

Display the need statement

Set the limitation period for pitching proposal registration

Set the number of proposal sumbitted

Invite supplier via email

Register the proposals

Manage schedule of pitching appointments based on response from qualified supplier via email

Refer to appendix B

RTM advertises Need Statements

Invitation

Pitching appointments

end

rejected

Validate/limit

OK

Proposal registration on web portal system checking

End Module 2

Start module 2

W-1

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – SYNDICATION

Page 3 of 7

MODULE 3

MODULE 3 : PROPOSAL UPLOADING

Allow content provider to upload their associated supporting documents after log in(Document / Images / videos)

List of titles uploaded

Automatically detects and display information related to the proposal and respective suppliers within the database.

Refer to appendix C

Proposal Uploading on web portal

Start module 3

End Module 3

W-1

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – SYNDICATION

Page 4 of 7

MODULE 4 & MODULE 5

MODULE 4 : PITCHING SESSION EVALUATION

List of titles uploaded for evaluation

Notify the content evaluator via system

Evaluator selection

Download and view content via MP4 media player at workstation

Record the evaluation and accumulated marks (Content for syndication / Pitching presentation for local production)

List, sort and select marks for pre-procurement committee evaluation

Generate pitching session evaluation report Refer to appendix D

OK

MODULE 5 : SELECTION PROCESS

List and record of the titles approved Keep the unselected proposal for re-evaluation Notify the successful supplier via email Record the details(Letter of Intent) Generate report for selection result

Refer to appendix E rejected

(Bank script)

Kept the unselected proposal for re-evaluated (bin/ bank script)

Pitching Session

evaluation end

rejected

Selection Process (Pre-procurement)

Selection Process (Board Approval)

OK

Letter of Intent

Start Module 4

End Module 5

OK

W-1

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – SYNDICATION

Page 5 of 7

MODULE 6

Negotiation Meeting

Acknowledgement

MODULE 6 : ACKNOWLEDGEMENT

List and record of successful supplier

Invite the successful supplier for meeting via email

Record the result from the negotiation meeting

Notify the successful supplier via email

Record the details(Letter of Acceptance) Refer to appendix F

end

rejected

end

rejected

OK

OK

Start Module 6

End Module 6

Letter of Acceptance

W-1

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – SYNDICATION

Page 6 of 7

MODULE 7

Quality Content/ LPF

Technical QC

(High Resolution)

MODULE 7 : CONTENT EVALUATION

List and record successful titles approved Notify the content evaluator via email Download and view content via MP4 media player

at workstation Marking, grading and reporting via email Notify the supplier via email for:

i.Corrections ii.Request for High Resolution copy for technical evaluation

Generate content evaluation report

Refer to appendix G

Rejected (edit 3 times)

OK

Library Depository

TX

Start Module 7

OK

End Module 7

end

end

Uploading (Low Resolution)

Receive Hard Disc (Physical Copy)

W-1

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – SYNDICATION

Page 7 of 7

MODULE 8 & MODULE 9

LAD

Monitoring

MODULE 8 : PAYMENT

Record the payment

Calculate the budget details

List of titles has been paid and to be paid

for budget allocation of each titles

Calculate the LAD (Liquidated and Ascertained Damages)

Customise the payment report

Refer to appendix H

MODULE 9 : MONITORING AND REPORTING

Monitor contract period

Tabulating and sorting

Update asset information for library depository

Create report into Microsoft Office and PDF file Refer to appendix I

Start Module 8

End Module 9

Payment

process end

OK

W-2

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – LOCAL

Page 1 of 7

MODULE 1

MODULE 1 : ONLINE WEB PORTAL AND REGISTATION

Log information of invitees

Content provider upload associated supporting doc (Company profile, certificates, bank statement)

Validate company registration checklist

Pre- Selection of successful company Refer to appendix A

rejected

end

Online Web Portal Supplier register / updates company

details on web portal (company profile)

OK

validate

Start module 1

End Module 1

W-2

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – LOCAL

Page 2 of 7

MODULE 2

MODULE 2 : NEED STATMENT AND INVITATION

Display the need statement

Set the limitation period for pitching proposal registration

Set the number of proposal sumbitted

Invite supplier via email

Register the proposals

Manage schedule of pitching appointments based on response from qualified supplier via email

Refer to appendix B

RTM advertises Need Statements

Invitation

Pitching appointments

end

rejected

Validate/limit

OK

Proposal registration on web portal system checking

End Module 2

Start module 2

W-2

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – LOCAL

Page 3 of 7

MODULE 3

MODULE 3 : PROPOSAL UPLOADING

Allow content provider to upload their associated supporting documents after log in(Document / Images / videos)

List of titles uploaded

Automatically detects and display information related to the proposal and respective suppliers within the database.

Refer to appendix C

Proposal Uploading on web portal

Start module 3

End Module 3

W-2

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – LOCAL

Page 4 of 7

MODULE 4 & MODULE 5

MODULE 4 : PITCHING SESSION EVALUATION

List of titles uploaded for evaluation

Notify the content evaluator via system

Evaluator selection

Download and view content via MP4 media player at workstation

Record the evaluation and accumulated marks (Content for syndication / Pitching presentation for local production)

List, sort and select marks for pre-procurement committee evaluation

Generate pitching session evaluation report Refer to appendix D

OK

MODULE 5 : SELECTION PROCESS

List and record of the titles approved Keep the unselected proposal for re-evaluation Notify the successful supplier via email Record the details(Letter of Intent) Generate report for selection result

Refer to appendix E rejected

(Bank script)

Kept the unselected proposal for re-evaluated (bin/ bank script)

Pitching Session

evaluation end

rejected

Selection Process (Pre-procurement)

Selection Process (Board Approval)

OK

Letter of Intent

Start Module 4

End Module 5

OK

W-2

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – LOCAL

Page 5 of 7

MODULE 6

Production Meeting

Acknowledgement

MODULE 6 : ACKNOWLEDGEMENT

List and record of successful supplier

Invite the successful supplier for meeting via email

Record the result from the production meeting

Notify the successful supplier via email

Record the details(Letter of Acceptance) Refer to appendix F

end

rejected

end

rejected

OK

OK

Start Module 6

End Module 6

Letter of Acceptance

W-2

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – LOCAL

Page 6 of 7

MODULE 7

Quality Content/ LPF

Technical QC

(High Resolution)

MODULE 7 : CONTENT EVALUATION

List and record successful titles approved Notify the content evaluator via email Download and view content via MP4 media player

at workstation Marking, grading and reporting via email Notify the supplier via email for:

i.Corrections ii.Request for High Resolution copy for technical evaluation

Generate content evaluation report

Refer to appendix G

Rejected (edit 3 times)

OK

Library Depository

TX

Start Module 7

OK

End Module 7

end

end

Uploading (Low Resolution)

Receive Hard Disc (Physical Copy)

W-2

TV CONTENT MANAGEMENT SYSTEM WORKFLOW PROCESS – LOCAL

Page 7 of 7

MODULE 8 & MODULE 9

LAD

Monitoring

MODULE 8 : PAYMENT

Record the payment

Calculate the budget details

List of titles has been paid and to be paid

for budget allocation of each titles

Calculate the LAD (Liquidated and Ascertained Damages)

Customise the payment report

Refer to appendix H

MODULE 9 : MONITORING AND REPORTING

Monitor contract period

Tabulating and sorting

Update asset information for library depository

Create report into Microsoft Office and PDF file Refer to appendix I

Start Module 8

End Module 9

Payment

process end

OK

Page 1 of 1

APPENDIX A

MODULE 1 : ONLINE WEB PORTAL AND REGISTRATION GUI

Data field Requirements

A. Company Profile

a. Company

Text (Allow user to update the profile information)

b. Address

c. Telephone / Fax No

d. Email

e. Company Status

f. Board of Directors

g. Experiences Text (List of experience for the past 2 years from registration date)

h. Latest Audit Report / date Image (Attachment report PDF) / dd-mm-yyyy

i. Paid-up capital (RM)

Text (Alphanumeric)

Image (Attachment bank statement PDF)

B. Certificates:

a. Ministry Of Finance Certificate (MOF) No

Validate by date Image (Attachment certificate PDF)

b. Expiry Date (MOF) Certificate

c. KKMM Registration Certificate

d. Expiry Date (KKMM) Certificate

e. FINAS Certificate No

f. Expiry Date (FINAS) Certificate

C. Bank Statement

a. No.Akaun Bank

Image (Attachment certificate PDF)

b. Nama Bank

c. Cawangan Bank

Page 1 of 1

APPENDIX B

MODULE 2 : NEED STATEMENTS AND INVITATION GUI

Data field Requirements

1. Display the need statement

i. Program Type Combo Box (Syndication / Local Production)

ii. Category Combo Box (Movie, Drama)

iii. Category Code Combo Box (ANM, DKT, MGZ)

iv. No. Of Episode Auto Generate

v. Type / Genre / Format Text (Alphanumeric)

vi. Duration Combo Box (Animation,Documentary, Magazine)

vii. Language Hours / Minutes

viii. Theme Combo Box (Malay, Hindi, Cantonese)

ix. Program Concept Combo Box (Family, Father’s Day, Mother’s Day)

2. Set the limitation period for pitching proposal registration

Date (dd-mm-yyyy) :

3. Set the limitation number of the proposal submitted

Set the date for the pitching registration period

4. Invite supplier to register the proposal via email

Number

5. Register the proposals for pitching Text (Email)

6. Manage schedule for pitching appointments based on response from qualified supplier via email

Text

Page 1 of 2  

APPENDIX  C‐i 

MODULE 3 :  PROPOSAL UPLOADING GUI  FOR SYNDICATION 

 

 

 

Data field  Requirements 

A. Allow content provider to upload their associated supporting documents after log in, requested by RTM 

 

1. Content Proposal   

i. Title  Text 

ii. Category  Combo Box (Movie, Drama) 

iii. Category Code i. Combo Box  (ANM, DKT, 

MGZ) ii. Auto Generate 

iii. Episode  Text 

iv. Duration  Hours / Minutes  

v. Language Combo Box (Malay, Hindi, Mandarin) 

vi. Year of Production  Combo Box (yyyy) 

vii. Country  Combo Box 

viii. Offer Price (RM)  Number 

ix. Actor/Actress  Text 

x. Synopsis  Text (Not More Than 500 Words) 

xi. Remarks  Text (Award Received) 

xii. Broadcast Rights 

Text (Name Of Broadcast Owner) 

Text (Period Of Broadcast Right ) 

Image (Attach Authorize Letter In PDF Format) 

2. Screener And Finished Product  MP4  Format  

3. Script  PDF Format 

4. Trailer / Still Photo / Promo i. Trailer/Promo MP4 Format ii. Still Photo JPEG Format 

Page 2 of 2  

APPENDIX  C‐ii 

MODULE 3 :  PROPOSAL UPLOADING GUI  FOR LOCAL PRODUCTION 

 

Data field  Requirements 

A. Allow content provider to upload their associated supporting documents after log in, requested by RTM 

 

1. Content Proposal   

i. Title  Text 

ii. Category  Combo Box (Movie, Drama) 

iii. Category Code i. Combo Box  (ANM, DKT, 

MGZ) ii. Auto Generate 

iii. Episode  Text 

iv. Duration  Hours / Minutes  

v. Offer Price (RM)  Number 

vi. Language Combo Box (Malay, Hindi, Mandarin) 

vii. Theme Combo Box (Family, Father’s Day, Mother’s Day) 

viii. Program Concept  Text (Not More Than 200 Words) 

ix. Synopsis  Text (Not More Than 500 Words) 

2. Multimedia Presentation Storyboard  MP4 Format (Presentation) 

3. Trailer / Still Photo / Promo i. Trailer / Promo MP4 

Format ii. Still Photo JPEG Format 

Page 1 of 2

APPENDIX D-i

MODULE 4 : PITCHING SESSION EVALUATION FOR SYNDICATION GUI

Data field Requirements

1. List of titles uploaded for evaluation Combo Box (Movie, Drama)

2. Notify the content evaluator via email Text (Email)

3. Evaluator selection Combo Box (List Of Evaluators)

4. Download and content viewing Download and view content via windows media player at workstation with MP4 format

5. Record the evaluation and marks of content and pitching

i. Needs Statement Requirement Combo Box (Yes / No)

ii. Evaluation 1 - Genre And Theme Text , Marks (%)

iii. Evaluation 2 - Actor/Actress, Commercial Value

Text , Marks (%)

iv. Evaluation 3 - Subject, Plot, Cinematography

Text , Marks (%)

v. Commercial Value Combo Box (Yes / No)

vi. Remarks Text (Not More Than 200 Words)

6. List , sort and select total marks for pre-procurement committee evaluation

Text (auto sorting from the highest marks to the lowest marks)

Marks 80% and above will be forwarded for the next stage

Mark 79% and below will be remain in the storage

7. Generate pitching session evaluation report for daily, monthly and yearly

Text (Selection by category, title, date of evaluation, accumulated marks in PDF format)

Page 2 of 2

APPENDIX D-ii

MODULE 4 : PITCHING SESSION EVALUATION FOR LOCAL PRODUCTION GUI

Data field Requirements

1. List of titles uploaded for evaluation Combo Box (Movie, Drama)

2. Notify the content evaluator via email Text (Email)

3. Evaluator selection Combo Box (List Of Evaluators)

4. Download and content viewing Download and view content via windows media player at workstation with MP4 format

5. Record the evaluation and accumulated marks of content and pitching

i. Three (3) evaluators - subject matter/treatment/approach /style

Sum of the accumulated for Marks, Result, Remarks

6. List , sort and select total marks for pre-procurement committee evaluation

Text (auto sorting from the highest marks to the lowest marks)

Marks 80% and above will be forwarded for the next stage

Mark 79% and below will be remain in the storage

7. Generate pitching session evaluation report for daily, monthly and yearly

Text (Selection by category, title, date of evaluation, accumulated marks in PDF format)

Page 1 of 1

APPENDIX E

MODULE 5 : SELECTION PROCESS FOR SYNDICATION AND LOCAL PRODUCTION GUI

Data field Requirements

1. List and record of the titles approved Combo Box (Syndication, Local Production)

i. Date of Approval Meetings

Date (dd-mm-yyyy) : i. Technical Committee

Meeting ii. Pre – LPA Meeting

iii. Lembaga Perolehan A Meeting (LPA)

iv. Channel Combo Box

2. Keep the unselected proposal for re-evaluation

Combo Box

3. Supplier notification (Letter Of Intent) via email

Text (Email)

4. Record the details of letter (Letter of Intent)

Date (dd-mm-yyyy) : i. Letter of Intent (Issued)

ii. Letter Of Intent (Accepted)

Text i. Letter Of Intent reference

number

5. Generate report for selection result

Text (Selection by category, title, date of approval, supplier in Microsoft Office and PDF format)

Page 1 of 2

APPENDIX F-i

MODULE 6 : ACKNOWLEDGEMENT FOR SYNDICATION GUI

Data field Requirements

1. List all successful suppliers

i. Supplier Combo Box

ii. Category Combo Box (Movie, Drama)

iii. Title Text

2. Invite the successful supplier via email for price negotiation

Notification to the successful supplier by email

3. Record of price negotiation result

Date (dd-mm-yyyy) : i. Date Of Broadcast Right

ii. Date Of Negotiation iii. Delivery Period

Text (Alphanumeric) i. Offer Price

ii. Negotation Price iii. Episode

4. Notify successful supplier via email (Letter of Acceptance)

Text (Email)

5. Record the details of letter (Letter of Acceptance)

Date (dd-mm-yyyy) : i. Date Of Letter Issued

ii. Date Of Letter Acceptance

Text i. Reference Number (Letter

Of Acceptance)

6. Generate report for selection result

Text (Selection by category, title, date of evaluation, accumulated marks in PDF format)

Page 2 of 2

APPENDIX F-ii

MODULE 6 : ACKNOWLEDGEMENT FOR LOCAL PRODUCTION GUI

Data field Requirements

1. List all successful suppliers

i. Supplier Combo Box

ii. Category Combo Box (Movie, Drama)

iii. Title Text

2. Invite the successful supplier via email for production meeting

Notification to the successful supplier by email

3. Record of production meeting result

Date (dd-mm-yyyy) : i. Date Of production

meeting ii. Delivery Period

Text Production Meeting Result

4. Notify successful supplier via email (Letter of Acceptance)

Text (Email)

5. Record the details of letter (Letter of Acceptance)

Date (dd-mm-yyyy) : i. Date Of Letter Issued

ii. Date Of Letter Acceptance

Text i. Reference Number (Letter

Of Acceptance)

6. Generate report for selection result

Text (Selection by category, title, date of evaluation, accumulated marks in PDF format)

Page 1 of 1

APPENDIX G

MODULE 7 : CONTENT EVALUATION FOR SYNDICATION AND LOCAL PRODUCTION GUI

Data field Requirements

1. List and record successful titles approved

i. Category Combo Box (Movie, Drama)

ii. Title Text

iii. Episode Number

2. Content evaluator notification Notify Via Email

3. Content downloading and content viewing

Via MP4 Media Player

4. Marking, grading and reporting via email on content evaluation

Combo Box (Content Evaluator, Lembaga Penapisan Filem, Technical QC)

i. Grading

Evaluator 1

Evaluator 2

Evaluator 3

Text

ii. Marks (Accumulated) Number, Marks (%)

iii. Treatment Text

iv. Cinematography Text

v. Evaluation Comment Text

vi. Result

Text i. Content Evaluation

ii. Lembaga Penapisan Filem (LPF)

iii. Content And Techical QC

iv. Date of Evaluation

Date (dd-mm-yyyy) : i. Content Evaluation

ii. Lembaga Penapisan Filem (LPF)

iii. Content And Techical QC

5. Notify the supplier for : i. Corrections

ii. Request for high resolution copy for Technical Evaluation

Notify Via Email

6. Generate content evaluation report for daily, monthly and yearly

Generate Report In PDF Format

Page 1 of 2

APPENDIX H

MODULE 8 : PAYMENT GUI

Data field Requirements

1. Record the payment

i. Type of acquisition Combo Box (Direct Deal, Contract)

ii. Invoice No Text

iii. Invoice Date dd-mm-yyyy

iv. Local Order No Text

v. Delivery Order No Text

vi. Delivery Order Date dd-mm-yyyy

vii. Title Text

viii. Category Combo Box (Movie, Drama)

ix. Category Code Combo Box (ANM, DKT, MGZ) (Auto Generate)

x. Asset Category Default (Rights)

xi. Sub-Category Combo Box (Audio, Audio Visual, Audio Visual)

xii. Type / Genre / format Combo Box (Animation, Documentary, Magazine)

xiii. Episode Text

xiv. Duration Hours / Minutes / Second

xv. Price Text (Alphanumeric)

xvi. Budget Combo Box (Budget ABM, Budget Pembangunan)

2. Calculate the budget for budget spent, current remaining budget and total spending

Calculation i. Total Budget

ii. Budget Spent iii. Remaining Budget iv. Total Spend

3. List of titles has been paid and to be paid for budget allocation for each titles

Text

Page 2 of 2

4. Calculate the LAD (Liquidated and Ascertained Damages)

Calculation i. LAD (Liquidated and

Ascertained Damages) calculation formula

= number of late days 365 day x Base Lending Rate (BLR) x Contract Value

ii. Number of late days from the contract expiry date

5. Customize the payment report

Combo Box (TV1, TV2, TVi, BES) i. Syndication

ii. Local Production iii. Bumiputera/Non

Bumiputera iv. Date (Letter Of Intend) v. Date

(Letter Of Acceptance) vi. Total Hours

vii. Total Price Offered viii. Total Price Paid

ix. GST x. Title

xi. Category xii. Episode

xiii. Date (Quality Control Approved)

xiv. Date (Transmission)

Page 1 of 3

APPENDIX I

MODULE 9 : MONITORING AND REPORTING GUI

Data field Requirements

1. Monitor contract period for every title:

i. Date of Contract dd-mm-yyyy

ii. Contract Expiry Date

i. dd-mm-yyyy ii. Text

(Contract expiry date and notify the supplier at least 30 days before contract expired via email)

iii. Bond Value

i. Bond Value Calculation Formula:

2.5% of the procurement value worth RM200K-RM500

5% of the procurement value worth RM500k and above

ii. Submission Date

(dd-mm-yyyy) iii. Notify the supplier of bond

reminder 30 days after contract started via email

iv. Production Timeline a. Local Production

Date / Days i. Pre Production

ii. Production iii. Post Production iv. Content Evaluation v. Lembaga Penapisan Filem

(LPF) Evaluation vi. Technical Evaluation

vii. Payment viii. Total Number Of Days

Completed

b. Syndication

Date / Days i. Content Evaluation

ii. Lembaga Penapisan Filem (LPF) Evaluation

iii. Technical Evaluation iv. Payment v. Total Number Of Days

Completed

Page 2 of 3

vi. Tracking Assets By Location Location / Date

2. Tabulating and sorting any specific information needed for contract documentation and intangible assets

a) Information needed for contract documentation as follows: i. Supplier Name

ii. Tittle iii. Category iv. Type/ Genre/ Format v. Episode

vi. Duration vii. Media Format

viii. Contract Period ix. Contract Value x. Contract Reference

Number xi. GST

xii. Broadcast Rights / Intellectual Properties

xiii. Letter Of Intent Reference Number

xiv. Letter Of Acceptance Reference Number

b) Date as the following:

i. Meeting Approval ii. Negotiation

iii. Production Meeting iv. Letter Of Intent (Issued) v. Letter Of Intent

(Accepted) vi. Letter Of Acceptance

(Issued) vii. Letter Of Acceptance

(Accepted) viii. Contract

ix. Content of delivery timeline status for local production

x. Uploading the finished product status for syndication

xi. Content and technical QC report

xii. Lembaga Penapisan Filem (LPF) report

Page 3 of 3

3. Library depository

Date (dd-mm-yyyy) i. Title

ii. Category iii. Type / Genre / Format iv. Type Of Procurement v. Episode

vi. Archive No. vii. Location

viii. Officer In Charge ix. Intangible Assets

(Payment)

4. Create Report Microsoft Office and PDF