Cohort Rules

Cohort Rules

Membership of a Cohort is defined by Cohort Rules. These Cohort Rules can be created or modified using RULF2000 - accessed via GENF1000 (Maintain Cohorts).

If a Cohort Rule returns 'True' then membership of the Cohort is established.

There are nine Rule Types used to define Cohort Rules in Callista:

COHORT-AA Rules to define Admission Applications
COHORT-ADM Rules to define Cohorts for Students during Admission Application Creation/Update/Tracking
COHORT-CC Rules to define Callista Connect
COHORT-FEE Rules to define Cohort of students whose Fees are assessed at a particular rate
COHORT-GRD Rules to define Cohorts of Students Graduating
COHORT-SCA Rules to define Cohorts of Student Course Attempts
COHORT-SUA Rules to define Cohorts of Student Unit Attempts
COHORTAGNT Rules to define Cohorts of Agents
COHORTPRSN Rules to define Cohorts of Students.

1. Options Available to most Cohort Rules

Rule Option	Usage
,	Comma used to separate Elements in a set. e.g. UNIT_SET IN {ACDM001, ACMJ001})
.	Definition: Full stop/period is used as a separator between grading schema code and grade. It may also be available for use as a separator between a course/unit code and version number, if so designated in RULF0100. Example: Must pass 3 credit points in {ADH601 } with grade of at least STANDARD . C COURSE_CODE IN {A300.2} For course A300, only considers version 2
:	Definition: Colon may be available for use as a separator between course/unit code and version number, if so designated in RULF0100 Example: COURSE_CODE IN {A300, A313, A316:2} For course A316, only considers version 2
`[text]`	Accent symbol used to delimit a string of text. e.g. SURNAME LIKE `VERRAS`
NOT	Logical negate. e.g. NOT ENROLMENT_COMPLETION
IN	Value in specified set. e.g. UNIT_SET IN {ACMN}
NOT IN	Value not in specified set e.g. UNIT_SET NOT IN {ACMN}
AND	Logical AND returns True if conditions are satisfied. e.g. UNIT_SET IN {ACMN} AND SCA_LOCATION IN {G}
OR	Logical OR returns True if either or both conditions are satisfied. e.g. UNIT_SET IN {ACMN} OR SCA_LOCATION IN {G}
LIKE	Returns True if the value matches the text string.
BETWEEN	Denotes a range of values. e.g. SURNAME BETWEEN `AA AND `DZ` returns True if SURNAME begins with A,B,C or D.
( )	Parentheses are used to force the order of operation where OR and AND statements are in the same rule. e.g. (UNIT_SET IN

2a. Rule Options Available for COHORT-AA Rules

Rule Stem	Examples	Comments
ACA_COURSE_TYPE	ACA_COURSE_TYPE IN {10} ACA_COURSE_TYPE NOT IN {10}
ADMISSION_ACADEMIC_YEAR	ADMISSION_ACADEMIC_YEAR IN {2008} ADMISSION_ACADEMIC_YEAR NOT IN {2008}
ADMISSION_PERIOD_TYPE	ADMISSION_PERIOD_TYPE IN {ADM-1} ADMISSION_PERIOD_TYPE NOT IN {ADM-1}
AGENCY_TYPE IN/NOT	AGENCY_TYPE IN {INTERNAT} AGENCY_TYPE NOT IN {INTERNAT}
COUNTRY_CODE	COUNTRY_CODE IN {10} COUNTRY_CODE NOT IN {10}

2b. Rule Options Available for COHORT-ADM Rules

Rule Stem	Examples	Comments
ACA_COURSE_TYPE	ACA_COURSE_TYPE IN {10} ACA_COURSE_TYPE NOT IN {10}

2c. Rule Options Available for COHORT-CC Rules

Rule Stem	Examples	Comments
No rules available for this Cohort Rule Type

2d. Rule Options Available for COHORT-FEE Rules

Rule Stem	Examples	Comments
CORRESPONDENCE_CATEGORY	CORRESPONDENCE_CATEGORY IN {INTERNATNL} CORRESPONDENCE_CATEGORY NOT IN {INTERNATNL}
DIFFERENTIAL_HECS_IND	DIFFERENTIAL_HECS_IND = N
PERSON_ADDRESS_TYPE	PERSON_ADDRESS_TYPE IN {POSTAL} PERSON_ADDRESS_TYPE NOT IN {POSTAL}
is female	is female
is male	is male
is unknown	is unknown

2e. Rule Options Available for COHORT-GRD Rules

Rule Stem	Examples	Comments
AWARD_CODE IN {	AWARD_CODE IN {1005}
AWARD_CODE NOT IN {	AWARD_CODE NOT IN {1005}
AWARD_COURSE_CODE IN {	AWARD_COURSE_CODE IN {M300}
AWARD_COURSE_CODE NOT IN {	AWARD_COURSE_CODE NOT IN {M300}
COHORT(	COHORT(SPECIAL STUDENTS)
GRADUAND_APPROVAL_STATUS IN {	GRADUAND_APPROVAL_STATUS IN {APPROVED}
GRADUAND_STATUS IN {	GRADUAND_STATUS IN {POTENTIAL}
GRADUAND_TYPE IN {	GRADUAND_TYPE IN {ATTENDING}

2f. Rule Options Available for COHORT-SCA Rules

Rule Stem	Examples	Comments
ADMISSION_CAL_TYP	ADMISSION_CAL_TYPE IN {VISUAL IMP} ADMISSION_CAL_TYPE NOT IN {VISUAL IMP}
ADMISSION_CAT	ADMISSION_CAT IN {VISUAL IMP} ADMISSION_CAT NOT IN {VISUAL IMP}
ATTENDANCE_MODE_DERIVED	ATTENDANCE_MODE_DERIVED IN {N} ATTENDANCE_MODE_DERIVED NOT IN {N}
ATTENDANCE_MODE_NOMINATED	ATTENDANCE_MODE_NOMINATED IN {N} ATTENDANCE_MODE_NOMINATED NOT IN {N}
ATTENDANCE_TYPE_DERIVED	ATTENDANCE_TYPE_DERIVED IN {N} ATTENDANCE_TYPE_DERIVED NOT IN {N}
ATTENDANCE_TYPE_NOMINATED	ATTENDANCE_TYPE_NOMINATED IN {N} ATTENDANCE_TYPE_NOMINATED NOT IN {N}
COHORT	COHORT (NAMES_A-E)
COMMENCEMENT_TYPE	COMMENCEMENT_TYPE=NEW COMMENCEMENT_TYPE=RETURN
CORRESPONDENCE_CATEGORY	CORRESPONDENCE_CATEGORY IN {MBA} CORRESPONDENCE_CATEGORY NOT IN {MBA}
COURSE_ATTEMPT_STATUS	COURSE_ATTEMPT_STATUS IN {ENROLLED} COURSE_ATTEMPT_STATUS NOT IN {ENROLLED}
COURSE_CATEGORY IN	COURSE_CATEGORY IN
COURSE_CATEGORY NOT IN	COURSE_CATEGORY NOT IN
COURSE_CODE IN	COURSE_CODE IN {M300}
COURSE_CODE NOT IN	COURSE_CODE NOT IN {M300}
COURSE_GROUP	COURSE_GROUP IN {ARCH/BUILD} COURSE_GROUP NOT IN {ARCH/BUILD}
COURSE_GROUP_TYPE	COURSE_GROUP_TYPE IN {COMBINED} COURSE_GROUP_TYPE NOT IN {COMBINED}
COURSE_TYPE	COURSE_TYPE IN {10} COURSE_TYPE NOT IN {10}
DATE-TIME	DATE-TIME > ECOE_END_DT DATE-TIME < ECOE_END_DT DATE-TIME >= ECOE_END_DT DATE-TIME <= ECOE_END_DT	DATE-TIME > ECOE_END_DT would return True, if ECOE_END_DT is in the past. See note for ECOE_END_DT and ECOE_STATUS_DERIVED options below.
DERIVED_COMPLETION_PERD	DERIVED_COMPLETION_PERD IN {S} DERIVED_COMPLETION_PERD NOT IN {S}
DERIVED_COMPLETION_YR	DERIVED_COMPLETION_YR IN {2008} DERIVED_COMPLETION_YR NOT IN {2008}
ECOE_END_DT	ECOE_END_DT > DATE-TIME ECOE_END_DT = SYSDATE LESS 2 MONTHS	ECOE_END_DT > DATE-TIME would return True, if the ECOE_END_DT is in the future. These rules can be used to determine a student's current ESOS -SVH standing. The Cohorts defined by may be included in Progression rules to create distinct rules for student visa holders. See Progression Rules. The ECOE_STATUS_DERIVED value that is checked by this rule can be seen in ADMF32T0 (Govt ECOE Status).
ECOE_STATUS_DERIVED	ECOE_STATUS_DERIVED IN { FINALISED } ECOE_STATUS_DERIVED NOT IN { FINALISED }
ENROLMENT_CAL_TYPE	ENROLMENT_CAL_TYPE IN {ENR-PER-1} ENROLMENT_CAL_TYPE NOT IN {ENR-PER-1}
ENROLMENT_CATEGORY	ENROLMENT_CATEGORY IN {INTERNAT} ENROLMENT_CATEGORY NOT IN {INTERNAT}
ENROLMENT_COMPLETION	ENROLMENT_COMPLETION ENROLMENT_COMPLETION
FEE_CATEGORY	FEE_CATEGORY IN {DOM-HECS} FEE_CATEGORY NOT IN {DOM-HECS}
FUNDING_SOURCE	FUNDING_SOURCE IN {FUND_SOURCE} FUNDING_SOURCE NOT IN {FUND_SOURCE}
GRADUAND_STATUS IN	GRADUAND_STATUS IN {ELIGIBLE}
GRADUAND_STATUS NOT IN	GRADUAND_STATUS NOT IN {ELIGIBLE}
HECS_PAYMENT_OPTION	HECS_PAYMENT_OPTION IN {110} HECS_PAYMENT_OPTION NOT IN {110}
Must have formally accepted offer through the admissions process	Must have formally accepted offer through the admissions process
Must not have a ceremony round	Must not have a ceremony round GB-ROUND starting { 01/01/2004 }
Must not have a deferred admission offer	Must not have a deferred admission offer
Must not have applied for deferral	Must not have applied for deferral
NOMINATED_COMPLETION_PERD	NOMINATED_COMPLETION_PERD IN {E} NOMINATED_COMPLETION_PERD NOT IN {E}
NOMINATED_COMPLETION_YR	NOMINATED_COMPLETION_YR IN {2008} NOMINATED_COMPLETION_YR NOT IN {2008}
OWNING_ORG_UNIT	OWNING_ORG_UNIT IN {0102} OWNING_ORG_UNIT NOT IN {0102}
PERSON_ID_GROUP	PERSON_ID_GROUP IN {VISUAL_IMP} PERSON_ID_GROUP NOT IN {VISUAL_IMP}
RESP_ORG_UNIT	RESP_ORG_UNIT IN {0102} RESP_ORG_UNIT NOT IN {0102}
SCA_LOCATION	SCA_LOCATION IN {G} SCA_LOCATION NOT IN {G}
SURNAME	SURNAME LIKE `JON%` SURNAME BETWEEN `A` AND `E`
SYSDATE LESS 3 MONTHS > ECOE_END_DT	SYSDATE LESS 3 MONTHS > ECOE_END_DT SYSDATE LESS 3 MONTHS > ECOE_END_DT	SYSDATE LESS 3 MONTHS > ECOE_END_DT would return True, if the ECOE_END_DT is more than 3 months past. See note for ECOE_END_DT and ECOE_STATUS_DERIVED options above.
UNIT_SET	UNIT_SET IN {CORE_STUDIES} UNIT_SET NOT IN {CORE_STUDIES}

2g. Rule Options Available for COHORT-SUA Rules

Rule Stem	Examples	Comments
All of those options listed above for COHORT-SCA plus the ones listed below
UNIT_CLASS	UNIT_CLASS IN {COMPOSITE} UNIT_CLASS NOT IN {COMPOSITE}
UNIT_CODE	UNIT_CODE IN {MAA101} UNIT_CODE NOT IN {MAA101}
UOO_LOCATION	UOO_LOCATION IN {BUR} UOO_LOCATION NOT IN {BUR}
UOO_MODE	SUA_LOCATION IN {G} SUA_LOCATION NOT IN {G}

2h. Rule Options Available for COHORTAGNT Rules

Rule Stem	Examples	Comments
AGENT_COUNTRY_CODE	AGENT_COUNTRY_CODE IN {01,02} AGENT_COUNTRY_CODE NOT IN {01,02}
COHORT(	COHORT (SPECIAL STUDENTS)
PERSON_ID_GROUP	PERSON_ID_GROUP IN {SPECIAL_STUDENTS} PERSON_ID_GROUP NOT IN {SPECIAL_STUDENTS}
SURNAME	SURNAME LIKE `JON%` SURNAME BETWEEN `A` AND `E`

2i. Rule Options Available for COHORTPRSN Rules

Rule Stem	Examples	Comments
COHORT(	COHORT (SPECIAL STUDENTS)
PERSON_ID_GROUP	PERSON_ID_GROUP IN {SPECIAL_STUDENTS} PERSON_ID_GROUP NOT IN {SPECIAL_STUDENTS}
SURNAME LIKE/BETWEEN	SURNAME LIKE `JON%` SURNAME BETWEEN `A` AND `E`

Last Modified on 31 May, 2012 4:11 PM

History Information

Release Version	Project	Change to Document
11.0.0.2.0.0	1508 - VET Rules	Added colon and full stop operators.
11.0.0.2.0.0	Calipso 24399	Updated all parts of help page.