Top of ASS | Index | Table of Contents | Feedback | ![]() |
Assignment Cover Extract View Details
The table shows the fields presented by this view.
Field Name |
Field Description |
Data Source |
|
CREATION_DT |
extract creation date |
system |
|
COMMENTS |
comments for inclusion on all assignment covers in the run |
job run parameter |
|
ACAD_CAL_TYPE |
the Academic Period for which the extract was run |
job run parameter |
|
ACAD_CI_SEQUENCE_NUMBER |
|||
TEACH_CAL_TYPE |
the teaching period for which the extract was run |
job run parameter |
|
TEACH_CI_SEQUENCE_NUMBER |
|||
COURSE_CD |
the Course Code for which the extract was run |
job run parameter |
|
UNIT_CD |
the Unit Code for which the extract was run |
job run parameter |
|
LOCATION_CD |
the location code for which the extract was run |
job run parameter |
|
UNIT_MODE |
the unit mode for which the extract was run |
job run parameter |
|
UNIT_CLASS |
the unit class for which the extract was run |
job run parameter |
|
PERSON_ID |
the Person ID for which the extract was run |
job run parameter |
|
ASS_ID |
the assessment item code for which the extract was run |
job run parameter |
|
REPRODUCE |
indicates that the assignment attachments are reproductions |
set when produced by ASSJ3500R |
|
REQUEST_JOB_RUN_ID |
system generated ID number of the request job run |
passed by job scheduler |
|
REQUEST_NUM |
system generated number of the request in which the job was run |
derived from request job run ID |
|
UPDATE_WHO |
. |
system |
|
UPDATE_ON |
. |
system |
Assignment Cover Sheet Record View Details
The table provides details of the different Record Types presented by this view and the fields in each Record Type.
1.
Header
2. Person
3. Addresses
4. Course Attempts
5. Unit Attempts
6. Assessment Details
7. Footer
ASS_COVER_RECORD_V |
|||||
Note: All references to source database tables and columns are in italics. Fields in bold type are included for sorting purposes. Field Names in blue are key fields, specifically included for sorting purposes. |
|||||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
|
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
|
PERSON_ID |
. |
10 |
num |
'0000000000' |
|
COURSE_CD |
. |
. |
. |
blank |
|
UNIT_CD |
. |
. |
. |
blank |
|
VERSION_NUMBER |
. |
. |
. |
blank |
|
RECORD_TYPE |
Record Type |
20 |
char |
'HEADER' |
|
FIELD1 |
Comment |
60 |
char |
parameter |
|
FIELD2 - 14 |
. |
. |
. |
blank |
|
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
|
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
|
PERSON_ID |
. |
10 |
num |
person.person_id |
|
COURSE_CD |
. |
. |
. |
blank |
|
UNIT_CD |
. |
. |
. |
blank |
|
VERSION_NUMBER |
. |
. |
. |
blank |
|
RECORD_TYPE |
Record Type |
20 |
char |
'PERSON' |
|
FIELD1 |
Person ID |
10 |
num |
person.person_id |
|
FIELD2 |
Title |
10 |
char |
uses person_alias.title or, if null, uses person.title |
|
FIELD3 |
Surname |
30 |
char |
uses person_alias.surname or, if null, uses person.surname |
|
FIELD4 |
Given Names |
40 |
char |
uses person_alias.given_names or, if null, uses person.given_names |
|
FIELD5 - 14 |
. |
. |
. |
blank |
|
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
|
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
|
PERSON_ID |
. |
10 |
num |
person.person_id |
|
COURSE_CD |
. |
. |
. |
blank |
|
UNIT_CD |
. |
. |
. |
blank |
|
VERSION_NUMBER |
. |
. |
. |
blank |
|
RECORD_TYPE |
Record Type |
20 |
char |
'ADDRESS' |
|
FIELD1 |
Person ID |
10 |
num |
person.person_id |
|
FIELD2 |
Addr Type |
10 |
char |
person_addr .addr_type |
|
FIELD3 |
Addr Line 1 |
40 |
char |
person_addr .addr_line_1 |
|
FIELD4 |
Addr Line 2 |
40 |
char |
person_addr .addr_line_2 |
|
FIELD5 |
Addr Line 3 |
40 |
char |
perso _addr .addr_line_3 |
|
FIELD6 |
Addr Line 4 |
40 |
char |
person_addr .addr_line_4 |
|
FIELD7 |
Addr Line 5 |
40 |
char |
person_addr .addr_line_5 |
|
FIELD8 |
Aust Postcode |
4 |
num |
person_addr .aust_postcode |
|
FIELD9 |
OS Code |
10 |
char |
person_addr .os_code |
|
FIELD10 |
Phone 1 |
20 |
char |
person_addr .phone_1 |
|
FIELD11 |
Phone 2 |
20 |
char |
person_addr .phone_2 |
|
FIELD12 |
Phone 3 |
20 |
char |
person_addr .phone_3 |
|
FIELD13 |
Other Details |
40 |
char |
person_addr .other_details1 |
|
FIELD14 |
Correspondence check box |
1 |
char |
addr_type.correspondence _ind |
|
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
|
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
|
PERSON_ID |
. |
10 |
num |
person.person_id |
|
COURSE_CD |
. |
. |
. |
blank |
|
UNIT_CD |
. |
. |
. |
blank |
|
VERSION_NUMBER |
. |
. |
. |
blank |
|
RECORD_TYPE |
Record Type |
20 |
char |
'COURSE ATTEMPTS' |
|
FIELD1 |
Person ID |
10 |
num |
person.person_id |
|
FIELD2 |
Course Code |
6 |
char |
student_course_attempt.course_cd |
|
FIELD3 |
Course Version |
6 |
num |
student_course_attempt.version_number |
|
FIELD4 |
Title |
90 |
char |
course_version.title |
|
FIELD5 |
Short Title |
40 |
char |
course_version.short_title |
|
FIELD6 - 14 |
. |
. |
. |
blank |
|
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
|
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
|
PERSON_ID |
. |
10 |
num |
person.person_id |
|
COURSE_CD |
. |
6 |
char |
student_course_attempt.course_cd |
|
UNIT_CD |
. |
. |
. |
blank |
|
VERSION_NUMBER |
. |
. |
. |
blank |
|
RECORD_TYPE |
Record Type |
20 |
char |
'UNIT ATTEMPTS' |
|
FIELD1 |
Person ID |
10 |
num |
person.person_id |
|
FIELD2 |
Course Code |
6 |
char |
student_course_attempt.course_cd |
|
FIELD3 |
Unit Code |
10 |
char |
student_unit_attempt.unit_cd |
|
FIELD4 |
Unit Version Number |
6 |
num |
student_unit_attempt.version_number |
|
FIELD5 |
Unit Short Title |
40 |
char |
unit_version.short_title |
|
FIELD6 |
Teaching Period Calendar Type |
10 |
char |
student_unit_attempt.cal_type |
|
FIELD7 |
Teaching Period Sequence Number |
6 |
num |
student_unit_attempt.ci_sequence_number |
|
FIELD8 |
Location |
10 |
char |
student_unit_attempt.location_cd |
|
FIELD9 |
Class |
10 |
char |
student_unit_attempt.unit _class |
|
FIELD10 |
Mode |
10 |
char |
unit_class.unit_mode |
|
FIELD11 |
System Unit Mode |
10 |
char |
unit_mode.s_unit_mode |
|
FIELD12 - 14 |
. |
. |
. |
blank |
|
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
|
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
|
PERSON_ID |
. |
10 |
num |
person.person_id |
|
COURSE_CD |
. |
6 |
char |
student_course_attempt.course_cd |
|
UNIT_CD |
. |
10 |
char |
student_unit_attempt.unit_cd |
|
VERSION_NUMBER |
. |
6 |
num |
student_unit_attempt.version_number |
|
RECORD_TYPE |
Record Type |
20 |
char |
'ASSESSMENT DETAILS' |
|
FIELD1 |
Person ID |
10 |
num |
person.person_id |
|
FIELD2 |
Course Code |
6 |
char |
student_course_attempt.course_cd |
|
FIELD3 |
Unit Code |
10 |
char |
student_unit_attempt.unit_cd |
|
FIELD4 |
Unit Version Number |
6 |
num |
student_unit_attempt.version_number |
|
FIELD5 |
Academic Period Alternate Code (year) |
10 |
char |
student_unit_attempt_ass_v.acad_alternate_cd |
|
FIELD6 |
Teaching Period Alternate Code (semester) |
10 |
char |
student_unit_attempt_ass_v.teach_alternate_cd |
|
FIELD7 |
Assessment Item ID |
10 |
num |
studnt_unit_atmpt_ass_item.ass_id |
|
FIELD8 |
Student Assessment Item Creation Date |
19 |
char |
stdnt_unit_atmpt_ass_item.creation_dt |
|
FIELD9 |
Assessment Item Reference |
10 |
char |
unit_assessment_item.reference |
|
FIELD10 |
Assessment Item Description |
180 |
char |
assessment_item.description |
|
FIELD11 |
Due Date |
10 |
char |
uses
unit_assessment_item.due_dt |
|
FIELD12 |
Tracking Id |
9 |
num |
stdnt_unit_atmpt_ass_item.tracking_id |
|
FIELD13 - 14 |
. |
. |
. |
blank |
|
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
|
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
|
PERSON_ID |
. |
10 |
num |
'9999999999' |
|
COURSE_CD |
. |
. |
. |
blank |
|
UNIT_CD |
. |
. |
. |
blank |
|
VERSION_NUMBER |
. |
. |
. |
blank |
|
RECORD_TYPE |
Record Type |
20 |
char |
'FOOTER' |
|
FIELD1 |
Count of Record Type 2 |
6 |
num |
calculated |
|
FIELD2 |
Count of Record Type 3 |
6 |
num |
calculated |
|
FIELD3 |
Count of Record Type 4 |
6 |
num |
calculated |
|
FIELD4 |
Count of Record Type 5 |
6 |
num |
calculated |
|
FIELD5 |
Count of Record Type 6 |
6 |
num |
calculated |
|
FIELD6 - 14 |
. |
. |
. |
blank |
Last Modified on 3 March, 2004