Element

SQL Data Type

Description

ID

Integer

Staff Members community ID

AppraisalSeq

Integer (fk)

Appraisal reference (See table StaffAppraisal)

FileType

Varchar(1)(fk)

Example Academic (See the lookup table luFileType)

LearningAreaCode

Varchar(15)(fk)

Learning area code. (see table LearningAreas)

CourseTitle

Varchar(100)

Course Title/ Name.

CourseDetails

Varchar(MAX)

Details of the course.

ProviderCode

Varchar(15)

Company/person supplying the course.

Venue

Varchar(100)

Where the course is being held.

Presenter

Varchar(50)

Name of the presenter presenting the course.

DateStart

Datetime

The starting date of the course.

DateFinish

Datetime

The last day of the course.

AccreditedHours

Decimal(6, 2)

Accredited hours for course.

RegistrationAmount

Money

Sum of registration feeds. Example 199.99 ($199.99)

ReplacementAmount

Money

Example 199.99 ($199.99)

TravelAmount

Money

Sum of travel expenses. Example 199.99 ($199.99)

Outcome

Varchar(MAX)

Expected outcome of the course.

Comment

Varchar(MAX)

Additional comments about course.

CourseStatus

Varchar(15)(fk)

The current status of this PD application. Example approved or completed. (See table luStaffTrainingStatus)

CourseStandard

Varchar(15)(fk)

Course and/or Training standard. (See table luStaffTrainingStandard)

GLCode

Varchar(15)(fk)

General ledger code. (see table GeneralLedger)

GLSuballocationCode

Varchar(15)(fk)

Sub allocation general ledger code. (see table GeneralLedger)

StaffCampus

Varchar(3) (fk)

Staff campus. (see lookup table luCampus)

StaffYearLevel

Tinyint (fk)

Staff year level. (see lookup table luYearlevel)

StaffCategory

Varchar(15) (fk)

Staff Category. (see lookup table luStaffCategory)

StaffDepartment

Varchar(15) (fk)

Staff department. ( See lookup table luStaffDepartment)

CourseReason

Varchar(100)(fk)

Reason for attending course (see lookup table luStaffTrainingReason)

CourseCategory

Varchar(15) (fk)

Course category (see lookup table luStaffTrainingCategory)

GLCode2

Varchar(15) (fk)

General Ledger codes two. (see table GeneralLedger)

GLSuballocationCode2

Varchar(15) (fk)

General ledger sub allocation code two. (see table GeneralLedger)

GLCode3

Varchar(15) (fk)

General Ledger code three. (see table GeneralLedger)

GLSuballocationCode3

Varchar(15) (fk)

General ledger sub allocation code three. (see table GeneralLedger)

StaffTrainingApplicationDate

Datetime

Application lodgement date.