HASCRED

Returns Y if a student has any or a specific credential record (parameter 2).

Reporting Area(s):

Credentials

Required Parameters:

1. Name ID (i.e. nmid)

Optional Parameters:

1. Condition to return value. The condition must be based on the credentials (testing) table (i.e. "tecode= 'SAT123' ")

Example(s):

HASCRED(nmid) returns Y if the student has any credential records, or N if none

HASCRED(nmid, "tecode= 'SAT123' ") Returns Y if the student has a credential record with the code "SAT123"

 

Related Topics