WKCLASSRES

Classification Resources

Field Name

Caption

Mask

Description

Field Type

CS_ALLYR

All Year Availability

 

All Year Availability

Boolean

CS_APR_P

April %

nnn.

April Percent

Double

CS_AREA_CD

Area

10x

Area Code

Text

CS_AREA_TY

Area Text

40x

Area Description

Text

CS_AUG_P

August %

nnn.

August Percent

Double

CS_CL_ID

Classification Rec #

nnnnnnnn

Link to WKUCLASS.CL_ID

Long Integer

CS_CRT_BY

Created By

25x

Created By

Text

CS_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

CS_DEC_P

December %

nnn.

December Percent

Double

CS_DIV_CD

Division

10x

Division Code

Text

CS_DIV_TY

Division Text

40x

Division Description

Text

CS_DPT_CD

Department

10x

Department Code

Text

CS_DPT_TY

Department Text

50x

Department Description

Text

CS_EM_ID

Employee Rec #

nnnnnnnn

Link to WKUEMP.EM_ID

Long Integer

CS_END_DT

End Date

mm/dd/yyyy

End Date

Date/Time

CS_EQ_ID

Equipment Rec #

nnnnnnnn

Link to WKUEQT.EQ_ID

Long Integer

CS_EVENDIS

Evenly Distributed

 

Evenly Distributed

Boolean

CS_FEB_P

February %

nnn.

February Percent

Double

CS_ID

Resource Rec #

nnnnnnnn

Auto ID

Long Integer

CS_JAN_P

January %

nnn.

January Percent

Double

CS_JUL_P

July %

nnn.

July Percent

Double

CS_JUN_P

June %

nnn.

June Percent

Double

CS_MAR_P

March %

nnn.

March Percent

Double

CS_MAY_P

May %

nnn.

May Percent

Double

CS_MOD_BY

Last Modified By

25x

Last Modified By

Text

CS_MOD_DT

Last Modified Date

mm/dd/yyyy

Modification Date

Date/Time

CS_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

CS_NOV_P

November %

nnn.

November Percent

Double

CS_OCT_P

October %

nnn.

October Percent

Double

CS_PERC

% FTE

nnn

Percentage of FTE in the classification

Integer

CS_RES_CD

Resource

20x

Resource

Text

CS_RES_TY

Resource Text

75x

Resource Text

Text

CS_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

CS_SAREACD

Sub-Area

10x

Sub-Area Code

Text

CS_SAREATY

Sub-Area Text

40x

Sub-Area Description

Text

CS_SDIV_CD

Sub-Division

10x

SubDivision Code

Text

CS_SDIV_TY

Sub-Division Text

40x

SubDivision Description

Text

CS_SEP_P

September %

nnn.

September Percent

Double

CS_STARTDT

Start Date

mm/dd/yyyy

Start Date

Date/Time