| Name |
Get_Y2Y_data |
| Value |
 Expression: "/* This table will contain all students from the End Of Term table and their real cohort terms. */
CREATE TABLE #student_cohort_temp
(
[StudentId] VARCHAR(9) NOT NULL
,[CohortTerm] VARCHAR(6) NOT NULL
)
INSERT INTO #student_cohort_temp
(
[StudentId]
,[CohortTerm]
)
/* Determine the students and their cohort term from the Student End Of Term table */
SELECT
EOT.STDNT_ID AS StudentId
,MIN(AH.CohortTerm) AS CohortTerm
FROM ST_STDNT_ENDOFTERM_A EOT
/* Join on set of students that completed a local credit class after the HS Grad Date */
/* The earliest such term is their cohort term. */
INNER JOIN (
/* Get first term that the student took a credit class after HS Graduation. This is Cohort Term. */
SELECT
AH2.STUDENT_ID
,MIN(AH2.AH_TERM) AS CohortTerm
FROM (
/* Join AH with Student to get AH local credit classes taken after HS Grad Date */
SELECT
AH1.STUDENT_ID,
RTRIM(SUBSTRING(CLASS_KEY,12,6)) AS AH_TERM
FROM ST_ACDMC_HIST
exec usp_FactInstitutionalRetentionY2YSnapshot_Select |
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::Get_Y2Y_data |
| Evaluate As Expression |
False |
| Expression |
"/* This table will contain all students from the End Of Term table and their real cohort terms. */
CREATE TABLE #student_cohort_temp
(
[StudentId] VARCHAR(9) NOT NULL
,[CohortTerm] VARCHAR(6) NOT NULL
)
INSERT INTO #student_cohort_temp
(
[StudentId]
,[CohortTerm]
)
/* Determine the students and their cohort term from the Student End Of Term table */
SELECT
EOT.STDNT_ID AS StudentId
,MIN(AH.CohortTerm) AS CohortTerm
FROM ST_STDNT_ENDOFTERM_A EOT
/* Join on set of students that completed a local credit class after the HS Grad Date */
/* The earliest such term is their cohort term. */
INNER JOIN (
/* Get first term that the student took a credit class after HS Graduation. This is Cohort Term. */
SELECT
AH2.STUDENT_ID
,MIN(AH2.AH_TERM) AS CohortTerm
FROM (
/* Join AH with Student to get AH local credit classes taken after HS Grad Date */
SELECT
AH1.STUDENT_ID,
RTRIM(SUBSTRING(CLASS_KEY,12,6)) AS AH_TERM
FROM ST_ACDMC_HIST |
| ID |
c9f38093-ed81-47a2-ab85-382dedb525ca |
| Raise Changed Event |
False |
Properties
