Assignment Cover Sheet Extract - View Details

Assignment Cover Extract View Details

The table shows the fields presented by this view.

ASS_COVER _EXTRACT_V

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.

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

1. HEADER

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

2. PERSON

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

3. ADDRESSES

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 indicator

1

char

addr_type.correspondence
_ind

4. COURSE ATTEMPTS

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

5. UNIT ATTEMPTS

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

6. ASSESSMENT DETAILS

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
DD/MM/YYYY HH:MI:SS

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
DD/MM/YYYY

char

uses unit_assessment_item.due_dt
or stdnt_unit_atmpt_ass_item.
override_due_dt

FIELD12

tracking id

9

num

stdnt_unit_atmpt_ass_item.
tracking_id

FIELD13 - 14

 

 

 

blank

7. FOOTER

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 20 December, 1999