SYNOPSIS

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

DESCRIPTION

The MGOgetaffiliations() function returns a list of affiliation records. 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.source_code (o)
• val.status_code (o)

val.uwnetid is the uwnetid name. 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. You must specify either a uwnetid or one (or more) of validid, ein, ssn, studentid, account, system_key, clinicianid, advanceid, regid. val.lname is the last name. Wildcarding is supported by placing a "%" to represent zero or more characters, or a "_" to represent a single, non-blank character. val.source_code is the validation source reference code. val.status_code is the affiliation status reference code. The following fields are set for each selected affiliation:

• lst.next
• lst.uwnetid
• lst.validid
• lst.source_code
• lst.source_name
• lst.status_code
• lst.status_name

RETURN VALUE

Returns the number of records selected 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_VNV - The given validation information is not valid
• MGO_E_MAT - No matches found given selection criteria
• MGO_E_SQL - An SQL error occurred. See MGOerrmsg for details

AUTHENTICATION LEVEL

rmango

SEE ALSO

MGOaddaffiliation(), MGOfreevalidation(), MGOselraffstatus(), MGOselrvalsource(), MGOzero()