This job creates an extract of students and their progression details. To create an extract for ESOS students a cohort rule should be built in GENF1000 and that cohort specified in the Cohort parameter.

The check box in the parameters for this job is used to nominate if Progression related correspondence records are to be created when the extracts are generated.  When correspondence is to be created, Callista generates an extract and creates a correspondence item but the sent date is not recorded.  The sent details are populated at the institution's discretion.
In this job the correspondence details of the extract are recorded in the correspondence tables (CORRESPONDENCE_ITEM and OUTGOING_CORRESPONDENCE), however the process of actually sending the correspondence is handled by a different process.
The data extracted is stored in the S_EXTRACT and the S_EXTRACT_RECORD tables.

The Create Progression Outcome Details Extract block contains:

Parameters** Tab:

• Progression Period (LOV)
• Course Type (LOV)
• Course Owning Org Unit (LOV)
• Course Code (Find Course button)
• Course Location (LOV)
• Attendance Mode (LOV)
• Progression Outcome Type (LOV)
• Date Applied

More Tab:

• Decision Status (poplist)
• Govt eCOE Status (LOV)
• Person ID (Find Person button)
• Person ID Group (LOV)
• Cohort Code (LOV)

Parameters tab:

• Issue Correspondence check box
• Correspondence Type (LOV)
• Date of Issue

Rules/Notes:

A Progression Period instance must be nominated.

This Date Applied parameter limits this job to those students with a Student Progression Outcome Applied Date greater than or equal to the date entered in the Parameter form.
When the Date Applied field is left at null it is not considered.

There are three copies of the Decision Status field, all with only one prompt. This is to allow the user to select multiple statuses.

There are three copies of the Govt eCOE Status field, all with only one prompt. This is to allow the user to select multiple Government ECOE Statuses.

The person ID field can contain many person ID’s separated by commas.

Only Person ID Groups created by the user will be displayed in the Person ID LOV.

There are two copies of the Correspondence Type field. This is to allow the job to generate Correspondence of two different Types.

Details of extract records created:

The S_EXTRACT table is populated with the parameters in the KEY column of that table. The parameters in the key are concatenated and separated using the ‘|’ (pipe) symbol.

For each person included in this job, a record is created in the S_EXTRACT_RECORD table with a record_type of ‘PERSON’. This record has the following values,separated by the “|” (pipe) symbol, recorded within the key column:

• PERSON_ID
• TITLE
• NVL(INTERNATIONAL_NAME,PERSON_NAME)
• CITIZENSHIP
• CORRESPONDENCE_ADDR_TYPE
• ADDR_LINE_1
• ADDR_LINE_2
• ADDR_LINE_3
• ADDR_LINE_4
• ADDR_LINE_5
• AUST_POSTCODE
• OS_CODE
• EMAIL_ADDR

For each course that the student is attempting,a record is created in the S_EXTRACT_RECORD table with a record_type of ‘COURSE_PROGRESSION’. This record has the following values,separated by the “|” (pipe) symbol, recorded within the key column:

• CAL_TYPE AND SEQUENCE_NUMBER
• COURSE_CD
• TITLE
• COURSE_ATTEMPT_STATUS
• COURSE_TYPE
• LOCATION
• ATTENDANCE_MODE
• ATTENDANCE_TYPE
• COMMENCEMENT_DT
• ORG_UNIT_CD
• START_DT (OF OWNING ORG UNIT)
• DESCRIPTION (OF OWNING ORG UNIT)

For each course that has had progression assessed in the nominated Progression Period, a record is created in the S_EXTRACT_RECORD table with a record_type of ‘STUDENT_PRG_OUTCOME’. This record has the following values,separated by the “|” (pipe) symbol, recorded within the key column:

• PROGRESSION_RULE_CAT
• PROGRESSION_RULE_CD
• PROGRESSION_OUTCOME_TYPE
• RULE_CHECK_DTDECISION_STATUS
• DECISION_ORG_UNIT_CD
• DECISION_OU_START_DT
• DECISION_DT
• COMMENTS
• APPLIED_DT
• EXPIRY_DT
• DISCONTINUED_DT
• DISCONTINUATION_REASON_CD
• RULE_MESSAGE_TEXT

For each Progression Outcome that involves a unit exclusion, a record is created in the S_EXTRACT_RECORD table with a record_type of ‘STUDENT_PRG_UNIT’. This record has the following values,separated by the “|” (pipe) symbol, recorded within the key column:

• PERSON_ID
• COURSE_CD
• SEQUENCE_NUMBER
• UNIT_CD
• S_UNIT_TYPE

For each Progression Outcome that involves a unit set exclusion, a record is created in S_EXTRACT_RECORD table with a record_type of ‘STUDENT_PRG_UNIT_SET’. This record has the following values,separated by the “|” (pipe) symbol, recorded within the key column:

• PERSON_ID
• COURSE_CD
• SEQUENCE_NUMBER
• UNIT_SET_CD
• VERSION_NUMBER

For each Progression Outcome that involves a course exclusion, a records is created in the S_EXTRACT_RECORD table with a record_type of ‘STUDENT_PRG_COURSE’. This record has the following values,separated by the “|” (pipe) symbol, recorded within the key column:

• PERSON_ID
• COURSE_CD
• SEQUENCE_NUMBER
• COURSE_CD