|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Table Name | dbo_DimProgramRetentionCohort |
| Database Table Name | DimProgramRetentionCohort |
| Schema | dbo |
| Friendly Name | DimProgramRetentionCohort |
| Table Type | Table |
| Query Definition | |
| Description |
Columns
Column Name |
Friendly Name |
Data Type |
Computed Column Expression |
Description |
|
 |
ProgramRetentionCohortSK |
ProgramRetentionCohortSK |
System.Int32 | ||
 |
ProgramRetentionCohortAK |
ProgramRetentionCohortAK |
System.String(20) | ||
|
StudentId |
StudentId |
System.String(9) | ||
|
CohortTerm |
CohortTerm |
System.String(6) | ||
|
CohortTermTitle |
CohortTermTitle |
System.String(30) | ||
|
ProgramCode |
ProgramCode |
System.String(5) | ||
|
Program |
Program |
System.String(30) | ||
|
ProgramAdmitStatus |
ProgramAdmitStatus |
System.String(3) | ||
|
AwardTypeCode |
AwardTypeCode |
System.String(3) | ||
|
AwardType |
AwardType |
System.String(30) | ||
|
CIPCode |
CIPCode |
System.String(10) | ||
|
CIP |
CIP |
System.String(30) | ||
|
AgeAtProgramRetentionCohort |
AgeAtProgramRetentionCohort |
System.Int16 | ||
|
AgeRangeAtProgramRetentionCohort |
AgeRangeAtProgramRetentionCohort |
System.String(10) | ||
|
SwitchedProgramCode |
SwitchedProgramCode |
System.String(5) | ||
|
SwitchedProgram |
SwitchedProgram |
System.String(30) | ||
|
SwitchedTerm |
SwitchedTerm |
System.String(6) | ||
|
SwitchedTermTitle |
SwitchedTermTitle |
System.String(30) | ||
|
SwitchedAwardTypeCode |
SwitchedAwardTypeCode |
System.String(3) | ||
|
SwitchedAwardType |
SwitchedAwardType |
System.String(30) | ||
|
SwitchedCIPCode |
SwitchedCIPCode |
System.String(10) | ||
|
SwitchedCIP |
SwitchedCIP |
System.String(30) | ||
|
RowIsCurrent |
RowIsCurrent |
System.String(1) | ||
|
RowStartDate |
RowStartDate |
System.DateTime | ||
|
RowEndDate |
RowEndDate |
System.DateTime | ||
|
AgeRangeSort |
System.String(13) | CASE WHEN LEFT(AgeRangeAtProgramRetentionCohort,1) = '>' THEN 'zz1' + AgeRangeAtProgramRetentionCohort WHEN AgeRangeAtProgramRetentionCohort = 'Other' THEN 'zz2' + AgeRangeAtProgramRetentionCohort WHEN AgeRangeAtProgramRetentionCohort = 'N/A' THEN 'zz3' + AgeRangeAtProgramRetentionCohort ELSE AgeRangeAtProgramRetentionCohort END |
Sorting sequence for program retention cohort age range. |
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 |
ProgramRetentionCohortSK |
FactProgramRetentionSnapshot |
Table |
False |
| Powered by BI Documenter |
