checkEligUpdate: Returns TRUE if the Student Eligibility Window (S.E.W.) needs...

In johninpdx/RSTools: Data Mangement Tools for RSiena and Other Network Packages

Description

The table 'dbo.StudentEligibilityWindow in the database table has 1 row for each eligibility period (startdate, enddate) for each student who was ever survey-eligible. If Eligibility has not expired, the enddate will be set to the last date the update sproc (called dbo.StudentEligibilityWindows) was run.

Usage

checkEligUpdate()

Details

There are no parameters; the sproc simply obtains the date that the S.E.W. was last updated, and then the most recent date of any survey in the table dbo.SWave (which records wave-specific survey data by participating student), and compares the two. If the last S.E.W. was more recent than the most recent survey, no update is needed (return FALSE); otherwise, it is needed (return TRUE).

Value

A logical variable

Note

This function is mainly to be used internally, but a user might consider calling it out of curiosity, as to when the last S.E.W. table update occurred.

johninpdx/RSTools documentation built on May 19, 2019, 5:15 p.m.