S_SEQ

sequence

x

S_INITIALS

char

10

x

S_NAME

char

40

x

S_ADDRESS1

char

50

S_ADDRESS2

char

50

S_ADDRESS3

char

50

S_TASK

char

4

x

S_BILL_RATE

short num

2dp

S_COST_RATE

short num

2dp

S_SSN

char

20

S_PC_NUM

char

10

Which PC do they belong to?

S_MTD

short num

2dp

S_YTD

short num

2dp

S_HOURS

short num

2dp

S_1

short num

2dp

this year's billable time, by month

S_2

short num

2dp

this year's billable time, by month

S_3

short num

2dp

this year's billable time, by month

S_4

short num

2dp

this year's billable time, by month

S_5

short num

2dp

this year's billable time, by month

S_6

short num

2dp

this year's billable time, by month

S_7

short num

2dp

this year's billable time, by month

S_8

short num

2dp

this year's billable time, by month

S_9

short num

2dp

this year's billable time, by month

S_10

short num

2dp

this year's billable time, by month

S_11

short num

2dp

this year's billable time, by month

S_12

short num

2dp

this year's billable time, by month

S_B1

short num

2dp

this year's budgeted time, by month

S_B2

short num

2dp

this year's budgeted time, by month

S_B3

short num

2dp

this year's budgeted time, by month

S_B4

short num

2dp

this year's budgeted time, by month

S_B5

short num

2dp

this year's budgeted time, by month

S_B6

short num

2dp

this year's budgeted time, by month

S_B7

short num

2dp

this year's budgeted time, by month

S_B8

short num

2dp

this year's budgeted time, by month

S_B9

short num

2dp

this year's budgeted time, by month

S_B10

short num

2dp

this year's budgeted time, by month

S_B11

short num

2dp

this year's budgeted time, by month

S_B12

short num

2dp

this year's budgeted time, by month

S_LSTYR_1

short num

2dp

last year's billable dollars, by month

S_LSTYR_2

short num

2dp

last year's billable dollars, by month

S_LSTYR_3

short num

2dp

last year's billable dollars, by month

S_LSTYR_4

short num

2dp

last year's billable dollars, by month

S_LSTYR_5

short num

2dp

last year's billable dollars, by month

S_LSTYR_6

short num

2dp

last year's billable dollars, by month

S_LSTYR_7

short num

2dp

last year's billable dollars, by month

S_LSTYR_8

short num

2dp

last year's billable dollars, by month

S_LSTYR_9

short num

2dp

last year's billable dollars, by month

S_LSTYR_10

short num

2dp

last year's billable dollars, by month

S_LSTYR_11

short num

2dp

last year's billable dollars, by month

S_LSTYR_12

short num

2dp

last year's billable dollars, by month

S_OFFICE_PHONE

char

12

office phone

S_HOURS_WEEK

number

2dp

planned hours per week

S_FACE

short int

(0 to 255)

picture of this resource

S_TYPE

short int

(0 to 255)

0=Staff; 1=Freelance; 2=Equipment; 3=Materials; 4=Other

S_NOTES

char

2000

resource notes

S_DEPT

char

15

department

S_HOURS_ACT

number

2dp

actual hours this week

S_TEAM

char

10

x

account team, member of

S_PLAN_WEEK

number

2dp

hours planned to work each week

S_PLAN_MONDAY

number

2dp

hours planned - Monday

S_PLAN_TUESDAY

number

2dp

hours planned - Tuesday

S_PLAN_WEDNESDAY

number

2dp

hours planned - Wednesday

S_PLAN_THURSDAY

number

2dp

hours planned - Thursday

S_PLAN_FRIDAY

number

2dp

hours planned - Friday

S_REQ_TIME

short int

(0 to 255)

require daily time sheet?

S_ACT_MONDAY

short num

2dp

actual hours on Monday

S_ACT_TUESDAY

short num

2dp

actual hours on Tuesday

S_ACT_WEDNESDAY

short num

2dp

actual hours on Wednesday

S_ACT_THURSDAY

short num

2dp

actual hours on Thursday

S_ACT_FRIDAY

short num

2dp

actual hours on Friday

S_ACT_SATURDAY

short num

2dp

actual hours on Saturday

S_ACT_SUNDAY

short num

2dp

actual hours on Sunday

S_PLAN_SATURDAY

short num

2dp

hours planned - Saturday

S_PLAN_SUNDAY

short num

2dp

hours planned - Sunday

S_REQ_PLAN

short int

(0 to 255)

require users to enter day's planned hours on time cards

S_HOME_PHONE

char

12

S_OT_COST_RATE

short num

2dp

overtime cost rate

S_OT_BILL_RATE

short num

2dp

overtime bill rate

S_TITLE

char

20

title

S_ACTIVE

short int

(0 to 255)

active employee?

S_EMAIL

char

40

staffer's e-mail address

S_BACKUP_PERSON

char

4

a staffer's backup person

S_FREELANCE

short int

(0 to 255)

free-lancer? yes/no

S_PERIOD

short int

(0 to 255)