Purpose
The Application Owners CDP is a mapping table and should be used to join users to the applications they manage. Users can have different relationships to Applications from business owner, IT owner, asset owner, finance owner, etc. The CDP is ideal for answering questions of who the point of contact is for an Application depending on the use case.
Understanding the Table
The table is structured with application_id as the main row identifier, the key representing the relationship type (BU, IT, ORG_Owner, etc.), and the value being the user_id that correlates with the relationship type.
A new row will be created for each unique set of application_id, key, and value.
Use the last_seen_time and a time range along with checking if end_time is null to determine if a user is still responsible for a given application.
Schema
Example Queries
Find all records for a given user or application id
SELECT * FROM application_devices where end_date is null and user_id = {id} SELECT * FROM application_devices where end_date is null and application_id = {id}CDP Data Dictionary
Caption | Name | Requirement | Type | Description |
|---|---|---|---|---|
End Time | end_time | optional | timestamp_t | ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.owner: The owner of the product. Typically this is the user responsible for the application internal to the organization. ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.additional_owners: Other possible owners of a product. This is added to allow an array of owners, but when there is only one owner, the |
First Seen Time | first_seen_time | optional | timestamp_t | ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.owner: The owner of the product. Typically this is the user responsible for the application internal to the organization. ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.additional_owners: Other possible owners of a product. This is added to allow an array of owners, but when there is only one owner, the |
ID | id | required | integer_t | ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.vendor_name: The name of the vendor of the product. ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.version: The version of the product, as defined by the event source. For example: |
Owner Label | key | required | string_t | CDPs generated type of owner information derived from User, e.g., BU_OWNER_ID. |
Last Seen Time | last_seen_time | optional | timestamp_t | ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.owner: The owner of the product. Typically this is the user responsible for the application internal to the organization. ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.additional_owners: Other possible owners of a product. This is added to allow an array of owners, but when there is only one owner, the |
Record Created At | record_created_at | required | timestamp_t | CDPs generated timestamp when record was created. |
Record Updated At | record_updated_at | required | timestamp_t | CDPs generated timestamp when record was last updated. |
Application ID | software_application_id | required | integer_t | ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.vendor_name: The name of the vendor of the product. ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.version: The version of the product, as defined by the event source. For example: |
Data Source | source | optional | string_t | ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.owner: The owner of the product. Typically this is the user responsible for the application internal to the organization. ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.additional_owners: Other possible owners of a product. This is added to allow an array of owners, but when there is only one owner, the |
Start Time | start_time | optional | timestamp_t | ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.owner: The owner of the product. Typically this is the user responsible for the application internal to the organization. ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.additional_owners: Other possible owners of a product. This is added to allow an array of owners, but when there is only one owner, the |
Owner User ID | value | required | integer_t | ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.owner: The owner of the product. Typically this is the user responsible for the application internal to the organization. ApplicationLifecycle.app: The application that was affected by the lifecycle event. This also applies to self-updating application systems. Product.additional_owners: Other possible owners of a product. This is added to allow an array of owners, but when there is only one owner, the |