SYNOPSIS

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

DESCRIPTION

The MGOselvalidation() function selects validation records. Information is passed through val and returned through the linked list lst. The selection criteria fields are (the values in brackets indicate which field is valid for the indicated validation source reference code):

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

val.validid is the validation id. 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 id. val.advanceid is the advance id. val.regid is the registry id. val.lname and val.fname are the last and first names, respectively. Note: you must specify lname if you want to use fname. val.pac is the private access code. val.birthdate is the birthdate in YYYY-MM-DD form. val.source_code is the validation source reference code. You must specify one or more of (validid, ein, ssn, studentid, account, system_key, regid) plus a source_code. The following fields are set for each selected validation. The values in 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]
• lst.account [4]
• lst.system_key [2]
• lst.regid
• lst.lname
• lst.fname
• 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.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 records inserted 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_MAT - No matches found
• MGO_E_VAL - No such validation source reference code
• MGO_E_SQL - An SQL error occurred. See MGOerrmsg for details

AUTHENTICATION LEVEL

rmango

SEE ALSO

MGOdelvalidation(), MGOfreevalidation(), MGOinsvalidation(), MGOselrvalsource(), MGOupdvalidation(), MGOzero()