BATCHTIMESHEET (4.0SP20)

ID

uniqueidentifier

BATCHID

uniqueidentifier

false

Indicates the batch to which this record belongs.

VOLUNTEERID

uniqueidentifier

false

Indicates the volunteer to whom this timesheet applies.

JOBOCCURRENCEID

uniqueidentifier

false

Indicates the job occurance to which this timesheet applies.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

HOURSWORKED

decimal(20, 2)

false

Indicates the number of hours worked for this time sheet (in quarter hour increments).

STARTDATE

datetime

false

Indicates the start date for the timesheet.

ENDDATE

datetime

true

Indicates the end date for the timesheet.

SEQUENCE

int

false

Idicates the sequence of this record in the batch.

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

IX_BATCHTIMESHEET_DATEADDED

False

False

True

IX_BATCHTIMESHEET_DATECHANGED

False

False

False

IX_BATCHTIMESHEET_VOLUNTEERID

False

False

False

PK_BATCHTIMESHEET

True

True

False

TR_BATCHTIMESHEET_AUDIT_UPDATE

TR_BATCHTIMESHEET_AUDIT_DELETE

BATCHTIMESHEETBATCHSYSTEMMESSAGES

BATCHTIMESHEETID

BATCHTIMESHEETBATCHUSERMESSAGE

ID