|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | TrackingYears |
| Database Table Name | TrackingYears |
| Schema | |
| Friendly Name | TrackingYears |
| Table Type | View |
| Query Definition | SELECT CAST(- 1 AS smallint) AS KeyColumn, 'Not Applicable' AS NameColumn UNION ALL SELECT CAST(0 AS smallint) AS KeyColumn, '0 Year Mark' AS NameColumn UNION ALL SELECT CAST(1 AS smallint) AS KeyColumn, '1 Year Mark' AS NameColumn UNION ALL SELECT CAST(2 AS smallint) AS KeyColumn, '2 Year Mark' AS NameColumn UNION ALL SELECT CAST(3 AS smallint) AS KeyColumn, '3 Year Mark' AS NameColumn UNION ALL SELECT CAST(4 AS smallint) AS KeyColumn, '4 Year Mark' AS NameColumn UNION ALL SELECT CAST(5 AS smallint) AS KeyColumn, '5 Year Mark' AS NameColumn UNION ALL SELECT CAST(6 AS smallint) AS KeyColumn, '6 Year Mark' AS NameColumn UNION ALL SELECT CAST(7 AS smallint) AS KeyColumn, '7 Year Mark' AS NameColumn UNION ALL SELECT CAST(8 AS smallint) AS KeyColumn, '8 Year Mark' AS NameColumn UNION ALL SELECT CAST(9 AS smallint) AS KeyColumn, '9 Year Mark' AS NameColumn UNION ALL SELECT CAST(10 AS smallint) AS KeyColumn, '10 Year Mark' AS NameColumn |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
KeyColumn |
KeyColumn |
System.Int16 | ||
 |
NameColumn |
NameColumn |
System.String(14) |
Parent Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
Child Relations
Table Name |
Using Column |
Friendly Name |
Table Type |
Is Logical |
Description |
TrackingYearsAfterCohortTerm |
FactProgramRetentionSnapshot |
Table |
False |
| Powered by BI Documenter |
