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

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

Field Name

Field Description

Max Length

Type

Source / Value

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

Field Name

Field Description

Max Length

Type

Source / Value

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 check box

1

char

addr_type.correspondence _ind

Field Name

Field Description

Max Length

Type

Source / Value

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

Field Name

Field Description

Max Length

Type

Source / Value

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

Field Name

Field Description

Max Length

Type

Source / Value

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

Field Name

Field Description

Max Length

Type

Source / Value

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