SYNOPSIS

int MGOgetvalidations (Validation **lst, Validation *val)

DESCRIPTION

The MGOgetvalidations() function returns a list of validation records affiliated with the given search criteria. Information is passed through val and returned through the linked list lst. The required and optional selection criteria fields are (the values in brackets indicate which validation tables are searched through when the field is specified):

• val.uwnetid (r)
• val.validid (r)
• val.ein (r) [1]
• val.ssn (r)
• val.studentid (r) [1, 2, 7]
• val.account (r) [4]
• val.system_key (r) [2]
• val.clinicianid (r) [3]
• val.advanceid (r) [7]
• val.regid (r)
• val.lname (o)
• val.fname (o)
• val.pac (o)
• val.birthdate (o)
• val.source_code (o)
• val.status_code (o)

val.validid is the validation id. If specified, this will match only validation records which have been auto-affiliated. In most cases, this is what you want. val.source_code is the validation source reference code. val.status_code is the validation status reference code. Specify these to limit the search to a particular validation table and/or validation status.

The remaining fields are useful for nailing down a certain validation (most likely only one validation will match all search criteria) or for data-mining searches where auto-affiliations are not a concern. val.ein is the employee number. val.ssn is the social security number. val.studentid is the student number. val.account is the AVF account name. val.system_key is the student system key value. val.clinicianid is the clinician number. val.advanceid is the advance number. val.regid is the registry id. val.lname and val.fname are the last and first names, respectively. Wildcarding is supported by placing a "%" to represent zero or more characters, or a "_" to represent a single, non-blank character. Note: you must specify lname if you want to use fname. val.pac is the private access code. If specified and the pac is marked as one-time, the pac will expire automatically in two hours. val.birthdate is the birthdate in YYYY-MM-DD form.

You must specify either a uwnetid, or a validid with optional source_code and status_code, or one (or more) of the following ein, ssn, studentid, account, system_key, clinicianid, advanceid, regid.

The following fields are set for each matched validation. The values between the brackets indicate these fields are set depending on the validation source reference code (lst.source_code):

• lst.next
• lst.validid
• lst.ein [1]
• lst.prior_ein [1]
• lst.ssn
• lst.studentid [1, 2, 7]
• lst.account [4]
• lst.system_key [2, 5]
• lst.advanceid [7]
• lst.regid
• lst.lname
• lst.fname
• lst.sec_lname [7]
• lst.sec_fname [7]
• lst.pac_code
• lst.birthdate
• lst.college [1, 2]
• lst.department [1, 2, 4]
• lst.unit [1]
• lst.hepps_type [1]
• lst.budget [1]
• lst.faccode [1]
• lst.mailstop [1]
• lst.sdb_class [2]
• lst.sdb_status [2]
• lst.employee_status [2]
• lst.expiration [4]
• lst.branch [2]
• lst.techfee [2]
• lst.alumni_member [7]
• lst.alumni_type [7]
• lst.comment_name [4]
• lst.comment_code [4]
• lst.category_name
• lst.category_code
• lst.verify1 [4]
• lst.verify1_name [4]
• lst.verify1_code [4]
• lst.verify2 [4]
• lst.verify2_name [4]
• lst.verify2_code [4]
• lst.notify_code
• lst.notify_date
• lst.source_name
• lst.source_code
• lst.status_name
• lst.status_code

RETURN VALUE

Returns the number of validations found upon success or -1 if an error occurred (in which case MGOerrno and MGOerrmsg are set appropriately).

ERRORS

• MGO_E_MAR - One or more of the required arguments were missing
• MGO_E_IAR - Invalid or ambiguous argument
• MGO_E_PMD - Permission denied. See access control
• MGO_E_VAL - No such validation source reference code
• MGO_E_MAT - No match found given the selection criteria
• MGO_E_SQL - An SQL error occurred. See MGOerrmsg for details

AUTHENTICATION LEVEL

rmango

SEE ALSO

MGOfreevalidation(), MGOselrvalsource(), MGOzero()