CloudScend Foresight Data Dictionary for Knowledge Discovery
You are able to use your own instance of Metabase or any other Business Intelligence product to create your desired analytics using CloudScend Foresight data. We have provided read only access to the database tables below so you can create charts, graphs and perform analysis with the CloudScend Foresight data. The read only account information was provided with your CloudScend Foresight licenses.
CloudScend Foresight Database
| Table Name | Description |
|---|---|
| app_analysis_loe_results | Table containing the data needed to calculate the Migration Estimate. |
| Field Name | Data Type | Description |
|---|---|---|
| P* id | INTEGER | Table specific key |
| * app_global_id | VARCHAR2(255) | Application Global ID used as application key across CloudScend Foresight tables |
| estimated_survey_app_analysis_effort_hours | INTEGER | Estimated AA effort hours from AA Summary |
| estimated_app_analysis_effort_cost | INTEGER | Estimated AA effort cost from AA Summary |
| estimated_app_analysis_effort_bucket | VARCHAR2(10) | Estimated AA effort bucket from AA Summary |
| actual_survey_app_analysis_effort_hours | INTEGER | Actual AA effort hours - entered by user when complete |
| actual_app_analysis_effort_cost | INTEGER | Actual AA cost - entered by user when complete |
| actual_app_analysis_effort_bucket | VARCHAR2(10) | Actual AA bucket - entered by user when complete |
| eff_date | DATE | Date the analysis was performed |
| end_date | DATE | |
| estimated_migration_effort_bucket | VARCHAR2(16) | Calculated Estimated Refactor Effort Bucket from Refactor Details |
| actual_migration_effort_bucket | VARCHAR2(16) | Actual Refactor Effort Bucket entered by user when complete |
| estimated_migration_effort_hours | VARCHAR2(255) | Calculated Estimated Refactor Hours from Refactor Details |
| actual_migration_effort_hours | INTEGER | Actual Refactor Hours entered by user when complete |
| estimated_migration_effort_cost | VARCHAR2(255) | Calculated Estimated Refactor Cost from Refactor Details |
| actual_migration_effort_cost | INTEGER | Actual Refactor Cost entered by user when complete |
| estimated_app_analysis_total_score | INTEGER | Total Calculated Score from AA Details Summary |
| Table Name | Description |
|---|---|
| app_cast_highlight_tech_properties | Table containing data for major CAST Highlight metrics. |
| Field Name | Data Type | Description |
|---|---|---|
| P* table_id | INTEGER | Table specific key |
| app_cast_highlight_cloud_blocker_index | NUMBER | CAST HL Cloud Blocker Index - Lower scores indicate fewer blockers to Cloud migration |
| app_cast_highlight_cloud_readiness_index | NUMBER | CAST HL Cloud Readiness Index - Higher scores indicate an application is better suited for Cloud migration with fewer modifications |
| app_cast_highlight_security_vulnerability_index_critical | INTEGER | CAST HL Critical Security Vulnerabilities Index |
| app_cast_highlight_security_vulnerability_index_high | INTEGER | CAST HL High Security Vulnerabilities Index |
| app_cast_highlight_security_vulnerability_index_low | INTEGER | CAST HL Low Security Vulnerabilities Index |
| app_cast_highlight_security_vulnerability_index_medium | INTEGER | CAST HL Medium Security Vulnerabilities Index |
| app_cast_highlight_tech_debt | NUMBER | CAST HL technical debt value refers to the cost to fix the structural quality of the application per CAST Highlight calculations |
| app_cast_app_id | INTEGER | CAST HL Application ID |
| app_cast_major_technology | VARCHAR2(255) | CAST HL provided major languages used |
| app_cast_software_agility_index | NUMBER | CAST HL Software Agility Index represents the ease of maintaining your application source code |
| app_cast_software_elegance_index | NUMBER | CAST HL Software Elegance Index represents code complexity |
| app_cast_software_resiliency_index | NUMBER | CAST HL Resiliency Index represents the presence of good or bad programming habits within your source code that make it more or less robust and secure |
| app_cast_software_sloc_count | INTEGER | CAST HL Source Lines Of Code Count |
| app_global_id | VARCHAR2(255) | CloudScend Foresight Application Global ID used as application key across CloudScend Foresight tables |
| eff_date | DATE | Date analysis was performed |
| end_date | DATE | |
| app_cast_app_name | VARCHAR2(255) | Application Name |
| app_cast_functional_organization | VARCHAR2(255) | Application Functional Organization |
| app_cast_highlight_obsolescence_outdated | INTEGER | CAST HL Outdated Obsolescence Index. Obsolesence information informs you of the number of frameworks that are obsolete and need remediation |
| app_cast_highlight_obsolescence_nearly_outdated | INTEGER | CAST HL Nearly Outdated Obsolescence Index. Obsolesence information informs you of the number of frameworks that are obsolete and need remediation |
| app_cast_highlight_obsolescence_not_outdated | INTEGER | CAST HL Not Outdated Obsolescence Index. |
| Table Name | Description |
|---|---|
| app_cast_highlight_technologies_slocs | Table contains data regarding SLOC by technology per application. |
| Field Name | Data Type | Description |
|---|---|---|
| P*table_id | INTEGER | Table specific key |
| app_global_id | VARCHAR2(255) | Application Global ID used as application key across CloudScend Foresight tables |
| technology | VARCHAR2(255) | Software Language |
| slocs | INTEGER | Number of Source Lines of Code |
| cloud_readiness_supported | CHAR(1) | Indicator showing if cloud readiness is supported for this language |
| Table Name | Description |
|---|---|
| app_history | Table contains data showing history and location of source code uploads by application. |
| Field Name | Data Type | Description |
|---|---|---|
| * id | INTEGER | Table specific key |
| * app_global_id | VARCHAR2 (255) | Application Global ID used as application key across CloudScend Foresight tables |
| git_tag | VARCHAR2 (255) | GIT location for uploaded source code |
| upload_timestamp | TIMESTAMP | Date/Time the instance of the source code was uploaded |
| Table Name | Description |
|---|---|
| app_org | Table contains data regarding application ownership and organization. |
| Field Name | Data Type | Description |
|---|---|---|
| P * id | INTEGER | Table specific key |
| app_org | VARCHAR2 (255) | Application Organization entered during Onboarding |
| app_owner | VARCHAR2 (255) | Application Owner entered during Onboarding |
| app_project_manager | VARCHAR2 (255) | Application Project Manager entered during Onboarding |
| * app_global_id | VARCHAR2 (255) | Application Global ID used as application key across CloudScend Foresight tables |
| eff_date | DATE | Date application was onboarded |
| end_date | DATE |
| Table Name | Description |
|---|---|
| app_sonarqube_metrics | Table contains data regarding technical debt and vulnerabilities determined by SonarQube scan. |
| Field Name | Data Type | Description |
|---|---|---|
| P * id | NTEGER | Table specific key |
| * app_global_id | VARCHAR2 (255) | Application Global ID used as application key across CloudScend Foresight tables |
| technical_debt_rating | NUMBER | Technical Debt rating for application received from SonarQube scan - 1.0 means very low technical debt and 5.0 means very high technical debt |
| vulnerability_count | INTEGER | Vulnerability count from SonarQube scan |
| Table Name | Description |
|---|---|
| application | Table contains main application data information. |
| Field Name | Data Type | Description |
|---|---|---|
| P * id | INTEGER | Table specific key |
| * analysis_status | VARCHAR2 (255) | Current status of analysis for the application |
| * app_id | VARCHAR2 (255) | Application Global ID used as application key across CloudScend Foresight tables |
| * app_language | VARCHAR2 (255) | Main programming language determined following Onboarding |
| * app_name | VARCHAR2 (255) | Application Name entered during Onboarding |
| * app_user | VARCHAR2 (255) | Application User entered during Onboarding |
| * functional | VARCHAR2 (255) | Application Functional Org entered during Onboarding |
| * project_manager | VARCHAR2 (255) | Application Project Manager entered during Onboarding |
| artifact_url | VARCHAR2 (255) | URL to location of stored artifacts |
| app_owner | VARCHAR2 (255) | Application Owner entered during Onboarding |