User functions used by comm. jobs and the comm. plan

 

User functions allow comm. job users to select precise groups of students.  They work in conjunction with other parameters entered into GJAPCTL or GUAMAI1 to exclude students or prospects who do not meet the given criteria.  For example, if PROCOMM is run without only a term parameter, it will return a file of prospects for that term.  If the user function local is added, only prospects from the local region will be included in the file.  If the function levelpro with the parameter FT is added, only local, first-time prospects will be included.  The short-hand for this request would be: user1=local user2=levelpro(FT).

 

The function names have been chosen so that similar functions are grouped together.  The idea is that you will notice related functions when looking at list.  Thus, we used unitsmin and unitsmax rather than minunits and maxunits.  In some cases, similar functions exist for prospects, students, and degree candidates.  These will be differentiated by suffixes.  For example: majorpro, majorstu, and majordeg.

 

Since GJAPCTL is case specific, we decided to use all lower case letters in function names, except for the parts of function names that are acronyms that would normally be capitalized, such as HSU, NSE, HOP, or GPA.

 

Many functions accept multiple parameters.  For example, majorpro will accept a list of major codes.  majorpro(OCN) will return oceanography majors; majorpro(OCN,BIOL) will return prospects who are either oceanography or biology majors.  There is no limit to the number of parameters you may include, except for the 30-character limit currently imposed on the parameter fields by GJAPCTL.

 

All functions may also be negated by using not at the beginning of the parameter field.  local(not) will return students who are not local.  majorpro(not OCN,BIOL) will return prospects who have a major other than oceanography or biology.

 

Further documentation can also be found in the following locations:

 

 

 

Details of selected user functions

 

appdec                   Checks for particular decisions ever having been made.  This considers all decisions, not just the last one. 

 

appstatus               Selects the current application status:  NA=no app, I=incomplete, C=complete but no decision, or enter particular application decision codes.

 

contact                  This function looks for particular contact codes in the student’s record on SRAPRO1.  If you want to limit how recent this contact must have occurred, you may use contact30, contact180, or contact 356

 

contactnew            This function looks for any contact that has taken place since a particular letter (or variation) was sent.  If no parameter is included, it will find people with contacts since any communication took place (according to SUAMAIL).  Only S system letters and material <> NOT are considered communication.  Multiple letter codes can be used, e.g. contactnew(PROSPECT,PROFUTURE)

 

degawarded          This function can be used without parameters to select degrees awarded (degstat=A) and ignore degrees sought or credentials cleared, etc.  Terms may also be included as parameters.  This is the equivalent of combining degawarded() and termin() function to select particular terms from the range of possible terms that degcomm would return otherwise.  Example: degawarded(200420,200430) will get degrees awarded just these two terms, assuming the term parameter is set to 200420.

 

enrapp                   This determines if an applicant enrolled by checking that the Admit field matches the term in a student’s record for the given term.  It also checks to see that the student status is not IS, CN, CC, or EE and that they have some non EE registration.

 

ethnic                    The ethnic function selects students with particular ethnic codes.  The codes used are the CSU codes in the ethnic code table.  For example, entering the parameter 4 will return all Latino ethnic codes (4,A,B,Q,P) except Mexican American. Entering 3,4 will get all Latinos.  Use this function with no parameters to return anyone that is not White or Unknown (7,8,9,D).

 

GPAmaxhs            High school GPA functions use official GPA if available; otherwise, they check self-reported GPA from application.

 

hoopelig                Eligible for online orientation program.  This function accepts an optional cutoff date parameter.  Use U_HOOPELIG to store the date for a particular term so that it doesn’t need to be included when the function is used.

 

HOPreg                 Be careful about using HOPreg with PROCOMM as a mechanism for selecting all registrants for a particular HOP session.  The term code attached is the student’s admit term, so there may be some summer admits enrolled in a fall HOP.  Use STUCOMM to be safe.

 

letter/letter10         If the parameter is a single letter code ending with a * (e.g. ADMIT*) the function will find all letters that are equivalent to the parameter (ADMIT, ADMIT-LATE,ADMIT-GRAD, etc.).  Otherwise, letters which exactly match the parameter list will be found.

 

levelstu                  Select a particular student level (UG, GR, FT, TR, RT, NM, MA, UN, 2B, CR, CG, CU).  UG and GR are the undergraduate and graduate student levels.  CG and CU are continuing grads/undergrads.  MA are students seeking a masters degree.  The other codes all come from the STVRSTA table: FT=first-time, TR=transfer, RT=returning, 2B=second bachelors, CR=credential; NM=nonmatriculated (e.g. transitory), and UN=undeclared grad.

 

majminstu              Students whose 1st or 2nd major or 1st or 2nd minor matches parameter.  You may use either major codes or major option codes.

 

majorpro                Looks at the most recent major provided by a prospect.  If the student has applied, this will be the major given on the application.  If no major is provided, the student is assumed to be undeclared. You may use either major codes or major option codes.

 

majorstu                Students with a particular major or major group listed as either their first or second major.  You may use either major codes or major option codes.  BIEC will return only those students in the Ecology option of biology while BIOL will return students in any biology major, including BIOL, BIEC, BIDI, and others.

 

majproall               Considers all majors mentioned by a prospect in the last 18 months.  You may use either major codes or major option codes.

 

missing                  This function checks for outstanding items on the student’s application checklist.  The student may already have been admitted!  In the case of a missing final transcript, the function does not consider the transcript missing until the “attend-to-term” has completed.

 

residency               This function looks at the residency field in the current student record first.  If no student record is found, it looks at the residency field in the most recent application.

 

unitsmin/max         These functions only consider regular units, not audited units.