Complexity guidelines for .

Net/Java
Low Medium
Fields / Controls <= 10 > 10 And <= 20
Validation <= 8 > 8 And <= 16
Simple code with some business Requires defining new
logic. Requires use of simple class/methods/property with minimal
conditional statements. Invoking complexity business logic
existing methods from
Business/Data/Utility classes.
Methods / Functions
Controls and syntax are migrated Controls and syntax are migrated
using Wizard. Only minimal using Wizard but one-third of all
Migration - Partly Supported changes required controls and syntax need to rewritten
Controls / syntax
Migration - Obsolete <=15
Controls > 15 And <= 25
Simple code with some business Requires defining new
logic. Requires use of simple class/methods/property with minimal
conditional statements. Invoking complexity business logic
existing methods from
Migration - Obsolete System
Business/Data/Utility classes.
Functions/Methods

Complexity guidelines for VBA

Low Medium
Fields / Controls <=15 >15 AND <=25
Formatting / Textual Changes<=20 >20 AND <=40
Bookmarks <=20 >20 AND <=35
Simple code with some business Requires defining new methods with
logic. Requires use of simple minimal complexity business logic
conditional statements. Invoking
existing methods from Template
Library.
Methods / Functions

Complexity guidelines for Oracle Forms and Reports

Low Medium
Display only Fields <=10 >10 AND <=20
Updatable Fields <=5 > 5 AND <= 15
Modify Block and Canvas <=2 >2 AND <= 5
New Block and Canvas <=1 >1 AND <=2
Modify LOV <=5 >5 AND <=10
New LOV <=2 >2 AND <= 5
Creating Triggers / Simple code with some business Requires defining new methods with
Functions / Packages / logic. Requires use of simple minimal complexity business logic
Procedures conditional statements.
Modifying Triggers / Simple code with some business Requires defining new methods with
Functions / Packages / logic. Requires use of simple minimal complexity business logic
Procedures conditional statements.
Modifying Reports Simple reports Medium complexity reports
Creating New Reports Simple reports Medium complexity reports
 Complexity guidelines for Oracle PL/SQL
Low Medium
Table Creation (No of <=5 >5 AND <=15
columns)
<=5 > 5 AND <= 15
Table / Sequence
Modification (No of columns)
Insert / Update / Delete <=10 >10 AND <= 15
Records
Simple views with simple logic Views with minimal complexity logic
Views Creation
Simple views with simple logic Views with minimal complexity logic
Views Modification
Creating Triggers / Simple code with some business Requires defining new methods with
Functions / Packages / logic. minimal complexity business logic
Procedures / Anonymous
block
Modifying Triggers / Simple code with some business Requires defining new methods with
Functions / Packages / logic. Requires use of simple minimal complexity business logic
Procedures / Anonymous conditional statements.
block
Modifying SQL Reports Simple reports Medium complexity reports
Simple reports Medium complexity reports
Creating New SQL Reports

Complexity guidelines for Lotus Notes

Low Medium
New database NA NA
Forms <=5 > 5 AND <= 15
Views <=10 >10 AND <= 15
Editable fields <=10 >10 AND <= 15
Formula fields <=10 >10 AND <= 15
Simple code with some business Requires defining new methods with
Agents/Script – Within db logic. minimal complexity business logic
(like send mail, setup etc…).
Simple code with some business Requires defining new methods with
Agents/Script – Refresh from logic. minimal complexity business logic
other lotus db.
Simple code with some business Requires defining new methods with
Agents/Script – Refresh from logic. minimal complexity business logic
other relational db
Frameset/Pages/Outlines <=5 > 5 AND <= 15

Complexity guidelines for DataStage (ETL)

Low Medium
Table Creation (No of <=5 >5 AND <=15
columns)
Table / Sequence <=5 > 5 AND <= 15
Modification (No of
columns)
Insert / Update / Delete <=10 >10 AND <= 15
Records
Simple views with simple logic Views with minimal complexity logic
Views Creation
Simple views with simple logic Views with minimal complexity logic
Views Modification
Job Parameters Creation <=2 >2 AND <= 5
Job Parameters <=2 >2 AND <= 5
Modification
Job Creation Simple logic Minimal complexity logic
Job Modification Simple logic Minimal complexity logic
Job Sequence Creation Simple sequence Linked sequence
Job Sequence Modification
Simple sequence Linked sequence
Scheduling of Jobs & Jobs & Sequences are having
Sequences Jobs & Sequences are simple minimal complexity
<=5 > 5 AND <= 15
Import & Export Table
definition, Jobs, Sequences
Simple jobs with some business Requires defining new methods with
Performance tuning of Jobs logic. minimal complexity business logic
and Sequences
Creating Table definition <=10 >10 AND <=20
Environment Variable <=2 >2 AND <= 5
Setup and Alteration
 High
> 20
> 16
Defining complex business logic with
complex functionality and research
involved. Invoking COM methods.

Controls and syntax are migrated

using Wizard but more than half of
all controls and syntax need to
rewritten

> 25
Defining complex business logic with
complex functionality and research
and upgraded skill involved.

High
>25
>40
>35
Defining complex business logic with
complex functionality with database
connectivity/query and invoking
methods from Template Library

eports
High
>20
>15
>5
>2
>10
>5
Defining complex business logic with
complex functionality.

Defining complex business logic with

complex functionality.

Complex Reports
Complex Reports
 High
>15

>15

>15

Views with complex logic

Views with complex logic

Defining complex business logic with

complex functionality.

Defining complex business logic with

complex functionality.

Complex Reports
Complex Reports

High
NA
>15
>15
>15
>15
Defining complex business logic with
complex functionality.

Defining complex business logic with

complex functionality.

Defining complex business logic with

complex functionality.

>15

)
High
>15

>15

>15

Views with complex logic

Views with complex logic

>5
>5

Complex logic
Complex logic
Nested sequence

Nested sequence
Jobs & Sequences are having
maximum complexity
>15

Defining complex business logic with

complex functionality.

>20
>5
SB Estimation Release Date :28/06/2010

Note: Cells in white needs to be only filled

CR/ Req Size

Tech Combination Total Size
Oracle 3.75

Component for Oracle Forms and Reports Low

Display only Fields 0
Updatable Fields 0
Modify Block and Canvas 0
New Block and Canvas 0
Modify LOV 0
New LOV 0
Creating Triggers / Functions / Packages / Procedures 0

Modifying Triggers / Functions / Packages / Procedures 0

Modifying Reports 0
Creating New Reports 0
Component for Oracle PL/SQL Low
Table Creation (No of columns) 0
Table / Sequence Modification (No of columns) 3
Insert / Update / Delete Records 0
Views Creation 0
Views Modification 0
Creating Triggers / Functions / Packages / Procedures / Anonymous block 0

Modifying Triggers / Functions / Packages / Procedures / Anonymous block 1

Modifying SQL Reports 0
Creating New SQL Reports 0
New Database Directory

Copyrights Trademarks
Version 1.0 10
Infrasoft Technologies Limited.
SB Estimation Release Date :28/06/2010

Medium High Size

0 0
0 0
0 0
0 0
0 0
0 0
0.00
0 0

0 0
0 0
0 0
Medium High Size
0 0
0 0
0 0
0 0
0 0
3.75
0 0

1 0
0 0
0 0

Copyrights Trademarks
Version 1.0 10
Infrasoft Technologies Limited.
SB Estimation Release Date :28/06/2010

Weightage for Oracle Forms and Reports Low

Display only Fields 0.5
Updatable Fields 0.5
Modify Block and Canvas 0.5
New Block and Canvas 1
Modify LOV 0.25
New LOV 0.5
Creating Triggers / Functions / Packages / Procedures 1

Modifying Triggers / Functions / Packages / Procedures 0.5

Modifying Reports 0.25
Creating New Reports 0.5
Weightage for Oracle PL/SQL Low
Table Creation (No of columns) 0.25
Table Modification (No of columns) 0.25
Insert / Update / Delete Records 0.25
Views Creation 0.5
Views Modification 0.25
Creating Triggers / Functions / Packages / Procedures /
2
Anonymous block
Modifying Triggers / Functions / Packages / Procedures /
1
Anonymous block
Modifying SQL Reports 0.5
Creating New SQL Reports 1
Views Creation 0.5
Views Modification 0.25
Job Parameters Creation 0.5
Job Parameters Modification 0.25
Job Creation 2.5
Job Modification 1
Job Sequence Creation 1.5
Job Sequence Modification 1
Scheduling of Jobs & Sequences 1
Import & Export Table defination, Jobs, Sequences 1
Performance tuning of Jobs and Sequences 2
Creatig Table defination 1.5
Environment Variable Setup and Alteration 0.5
New Database Directory

Copyrights Trademarks
Version 1.0 10
Infrasoft Technologies Limited.
SB Estimation Release Date :28/06/2010

Medium High
0.75 1.5
0.75 1.5
1 2
2 4
0.5 0.75
1 1.5
2 3

1 2
0.5 1
1 2
Medium High
0.375 0.75
0.375 0.75
0.375 0.5
1 2
0.5 1
3 4

2 4
1 2
2 3
0.75 1.25
0.5 1
1 1.5
0.5 0.75
6 12
2.75 5
2.5 5.5
1.5 3
1.5 2
2 3
5 8
2.5 3.5
1.5 2.5

Copyrights Trademarks
Version 1.0 10
Infrasoft Technologies Limited.