APM Add-In Attributes and the Data Warehouse

Most attributes for the APM add-in objects have their Include in the Data Warehouse field selected. The APM add-in attribute IDs are renamed when their respective columns are created in the Data Warehouse (DWH). 
ccppmop153
Most attributes for the APM add-in objects have their 
Include in the Data Warehouse
 field selected. The APM add-in attribute IDs are renamed when their respective columns are created in the Data Warehouse (DWH). 
Do not unselect the
Include in the Data Warehouse
field because reports depend upon the attributes.
 
Application Object Attributes
The following table lists the APM attributes and their corresponding Data Warehouse column names for the Application object:
Attribute
Attribute ID
DWH Enabled
Table
Column
Lookup Table
Notes
Acquisition Date
apm_acquisition_date
Yes
dwh_inv_application
apm_acquisition_date
Not applicable
None
Acronym
apm_acronym
Yes
dwh_inv_application
apm_acronym
Not applicable
None
Application Source
apm_app_source
Yes
dwh_inv_application
apm_app_source_key
dwh_lkp_apm_app_source
None
Application Vendor
apm_app_vendor
Yes
dwh_inv_application
apm_app_vendor_key
dwh_lkp_apm_app_vendor
None
Client Type
apm_client_type
Yes
dwh_inv_application
apm_client_type_key
dwh_lkp_apm_client_type
Created without any lookup values. Customers can add their own client types.
Contract Due Date
apm_contr_due_date
Yes
dwh_inv_application
apm_contr_due_date
Not applicable
None
Installation Type
apm_install_type
Yes
dwh_inv_application
apm_install_type_key
dwh_lkp_apm_install_type
None
Last Assessment
apm_last_assessment
No
Not applicable
Not applicable
Currently not used
Mission Critical Level
apm_m_critical_level
Yes
dwh_inv_application
apm_m_critical_level
Not applicable
Aggregated calculated attribute that is based on the application assessment subobject
Number of Users
apm_no_of_users
Yes
dwh_inv_application
apm_no_of_users
Not applicable
None
Official Application Name
apm_official_app_nme
Yes
dwh_inv_application
apm_official_app_nme
Not applicable
None
Retirement Strategy
apm_retire_strategy
Yes
dwh_inv_application
apm_retire_strategy_key
dwh_lkp_apm_retire_strategy
None
Risk Score
apm_rsk_assess_score
Yes
dwh_inv_application
apm_rsk_assess_score
Not applicable
Aggregated calculated attribute that is based on the application assessment subobject
Security Level
apm_security_level
Yes
dwh_inv_application
apm_security_level_key
dwh_lkp_apm_security_level
None
Software Category
apm_sw_category
Yes
dwh_inv_application
apm_sw_category_key
dwh_lkp_apm_sw_category
None
Software Sub-Category
apm_sw_subcategory
Yes
dwh_inv_application
apm_sw_subcategory_key
dwh_lkp_apm_sw_subcategory
None
Tagged for Retirement
apm_tag_for_retire
Yes
dwh_inv_application
apm_tag_for_retire
Not applicable
None
Target Retirement Date
apm_trgt_retire_date
Yes
dwh_inv_application
apm_trgt_retire_date
Not applicable
None
Technical Score
apm_tec_assess_score
Yes
dwh_inv_application
apm_tec_assess_score
Not applicable
Aggregated calculated attribute that is based on the application assessment subobject
Unused Licenses
apm_unused_licenses
Yes
dwh_inv_application
apm_unused_licenses
Not applicable
None
Value Score
apm_val_assess_score
Yes
dwh_inv_application
apm_val_assess_score
Not applicable
Aggregated calculated attribute that is based on the application assessment subobject
Application Assessment Object Attributes
The following table lists the APM attributes and their corresponding Data Warehouse column names for the Application Assessment object:
Attribute
Attribute ID
DWH Enabled
Table
Column
Lookup Table
Notes
Assessment Date
assessment_date
Yes
dwh_inv_apm_app_assess
assessment_date
Not applicable
None
Assessment Due Date
assessment_due_date
 
Yes
dwh_inv_apm_app_assess
assessment_due_date
Not applicable
None
Assessment Owner
assessment_owner
Yes
dwh_inv_apm_app_assess
assessment_owner_key
dwh_res_resource
None
Assessment Status
assessment_status
Yes
dwh_inv_apm_app_assess
apm_assess_status_key
dwh_lkp_apm_assess_status
None
Comments
assessment_comments
Yes
dwh_inv_apm_app_assess
assessment_comments
Not applicable
None
Competitive Advantage
val_competitive_adv
Yes
dwh_inv_apm_app_assess
apm_competitive_adv_key
dwh_lkp_apm_competitive_adv
None
Created By
created_by
No
Not applicable
Not applicable
None
Created Date
created_date
Yes
dwh_inv_apm_app_assess
clarity_created_date
Not applicable
None
Development Languages
tech_develop_lang
Yes
dwh_inv_apm_app_assess
apm_develop_lang_key
dwh_lkp_apm_develop_lang
None
Effectiveness
val_effectiveness
Yes
dwh_inv_apm_app_assess
apm_effectiveness_key
dwh_lkp_apm_effectiveness
None
Enterprise Architecture
tech_enterprise_arch
Yes
dwh_inv_apm_app_assess
apm_enterprise_arch_key
dwh_lkp_apm_enterprise_arch
None
ID
code
Yes
dwh_inv_apm_app_assess
assessment_id
Not applicable
None
Integration Options
tech_integration_opt
Yes
dwh_inv_apm_app_assess
apm_integration_opt_key
dwh_lkp_apm_integration_opt
None
IT Security
tech_it_security
Yes
dwh_inv_apm_app_assess
apm_tec_it_security_key
dwh_lkp_apm_tec_it_security
None
Last Updated Date
last_updated_date
Yes
dwh_inv_apm_app_assess
clarity_updated_date
Not applicable
None
Mission Critical Level
mc_critical_level
Yes
dwh_inv_apm_app_assess
apm_critical_level_key
dwh_lkp_apm_critical_level
None
Name
name
Yes
dwh_inv_apm_app_assess
assessment_name
Not applicable
None
Organizational Efficiencies
val_org_efficiencies
Yes
dwh_inv_apm_app_assess
apm_org_efficiency_key
dwh_lkp_apm_org_efficiency
None
Organizational Value Chain
val_org_value_chain
Yes
dwh_inv_apm_app_assess
apm_org_value_chain_key
dwh_lkp_apm_org_value_chain
None
Partition
partition_code
No
Not applicable
 
Not applicable
None
Risk Score
rsk_assess_score
Yes
dwh_inv_apm_app_assess
rsk_assess_score
Not applicable
Calculated attribute that is based on risk questions in this assessment subobject
Technical Score
tech_assess_score
Yes
dwh_inv_apm_app_assess
tech_assess_score
Not applicable
Calculated attribute that is based on technical questions in this assessment subobject
Technical Skills Available
rsk_tech_skill_avail
Yes
dwh_inv_apm_app_assess
apm_tec_skill_avail_key
dwh_lkp_apm_tec_skill_avail
None
Updated By
updated_by
No
Not applicable
Not applicable
None
Value Score
val_assess_score
Yes
dwh_inv_apm_app_assess
val_assess_score
Not applicable
Calculated attribute that is based on value questions in this assessment subobject
Vendor Support
rsk_vendor_support
Yes
dwh_inv_apm_app_assess
apm_vendor_support_key
dwh_lkp_apm_vendor_support
None
Application Certification Object Attributes
The following table lists the APM attributes and their corresponding Data Warehouse column names for the Application Certification object:
Attribute
Attribute ID
DWH Enabled
Table
Column
Lookup Table
Notes
Attachment
cert_attachment
No
Not applicable
Not applicable
Attributes that are defined with the data type of attachment are not available in the Data Warehouse.
Certification Date
cert_date
Yes
dwh_inv_apm_app_cert
cert_date
Not applicable
None
Certification Required
is_cert_required
Yes
dwh_inv_apm_app_cert
is_cert_required
Not applicable
None
Certification Target Date
cert_target_date
Yes
dwh_inv_apm_app_cert
cert_target_date
Not applicable
None
Certification Type
cert_type
Yes
dwh_inv_apm_app_cert
apm_cert_type_key
dwh_lkp_apm_cert_type
None
Certification Valid Until
cert_valid_until
Yes
dwh_inv_apm_app_cert
cert_valid_until
Not applicable
None
Certified
is_certified
Yes
dwh_inv_apm_app_cert
is_certified
Not applicable
None
Comments
cert_comments
Yes
dwh_inv_apm_app_cert
cert_comments
Not applicable
None
Created By
created_by
No
Not applicable
Not applicable
None
Created Date
created_date
Yes
dwh_inv_apm_app_cert
clarity_created_date
Not applicable
None
ID
Code
Yes
dwh_inv_apm_app_cert
certification_id
Not applicable
None
Last Updated Date
last_updated_date
Yes
dwh_inv_apm_app_cert
clarity_updated_date
Not applicable
None
Name
name
Yes
dwh_inv_apm_app_cert
certification_name
Not applicable
None
Partition
partition_code
No
Not applicable
Not applicable
None
Updated By
updated_by
No
Not applicable
Not applicable
None