|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | PastYears |
| Database Table Name | PastYears |
| Schema | |
| Friendly Name | PastYears |
| Table Type | View |
| Query Definition | SELECT CAST(0 AS smallint) AS KeyColumn, 'Not Applicable' AS NameColumn UNION ALL SELECT CAST(1 AS smallint) AS KeyColumn, 'Current Year' AS NameColumn UNION ALL SELECT CAST(2 AS smallint) AS KeyColumn, '1 Year Prior to Current' AS NameColumn UNION ALL SELECT CAST(3 AS smallint) AS KeyColumn, '2 Years Prior to Current' AS NameColumn UNION ALL SELECT CAST(4 AS smallint) AS KeyColumn, '3 Years Prior to Current' AS NameColumn UNION ALL SELECT CAST(5 AS smallint) AS KeyColumn, '4 Years Prior to Current' AS NameColumn UNION ALL SELECT CAST(6 AS smallint) AS KeyColumn, '5 Years Prior to Current' AS NameColumn UNION ALL SELECT CAST(7 AS smallint) AS KeyColumn, '6 Years Prior to Current' AS NameColumn UNION ALL SELECT CAST(8 AS smallint) AS KeyColumn, '7 Years Prior to Current' AS NameColumn |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
KeyColumn |
KeyColumn |
System.Int16 | ||
 |
NameColumn |
NameColumn |
System.String(24) |
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 |
RetentionYearCount |
FactInstitutionalRetentionSnapshot |
Table |
False |
| Powered by BI Documenter |
