WKPDEPT

Planning by Department

Field Name

Caption

Mask

Description

Field Type

PD_APPROVE

Approved Budget

nnnnnnnn.

Approved Budget

Double

PD_APR_D

April $ Required

nnnnnnnn.

April Dollars Requirement Estimate

Double

PD_APR_DA

April $ Actual

nnnnnnnn.

April Dollars Actual

Double

PD_APR_WD

Apr Working Days

nn

April Working Days

Integer

PD_APRALD

Apr Labor Days Actual

nnnnn.nn

April Labor Days Actual

Double

PD_APRPLD

Apr Labor Days Planned

nnnnn.nn

April Labor Days Planned

Double

PD_AREA_CD

Area

10x

Area Code

Text

PD_AREA_TY

Area Text

40x

Area Description

Text

PD_AUG_D

August $ Required

nnnnnnnn.

August Dollars Requirement Estimate

Double

PD_AUG_DA

August $ Actual

nnnnnnnn.

August Dollars Actual

Double

PD_AUG_WD

Aug Working Days

nn

August Working Days

Integer

PD_AUGALD

Aug Labor Days Actual

nnnnn.nn

August Labor Days Actual

Double

PD_AUGPLD

Aug Labor Days Planned

nnnnn.nn

August Labor Days Planned

Double

PD_CLOSED

 

 

Closed

Boolean

PD_CONTR

Contractor $

nnnnnnn.

Contractor $ per FY

Double

PD_CRT_BY

Created By

25x

Created By

Text

PD_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

PD_DEC_D

December $ Required

nnnnnnnn.

December Dollars Requirement Estimate

Double

PD_DEC_DA

December $ Actual

nnnnnnnn.

December Dollars Actual

Double

PD_DEC_WD

Dec Working Days

nn

December Working Days

Integer

PD_DECALD

Dec Labor Days Actual

nnnnn.nn

December Labor Days Actual

Double

PD_DECPLD

Dec Labor Days Planned

nnnnn.nn

December Labor Days Planned

Double

PD_DIV_CD

Division

10x

Division Code

Text

PD_DIV_TY

Division Text

40x

Division Description

Text

PD_DOC_FLG

Document Available

 

Document Available

Boolean

PD_DPT_CD

Department

10x

Department Code

Text

PD_DPT_TY

Department Text

50x

Department Description

Text

PD_EQUIP

Equipment $

nnnnnnn.

Equipment $ per FY

Double

PD_EXP_PCT

% of Budget Used

nnn.n

% of Budget Expended in FY

Double

PD_FEB_D

February $ Required

nnnnnnnn.

February Dollars Requirement Estimate

Double

PD_FEB_DA

February $ Actual

nnnnnnnn.

February Dollars Actual

Double

PD_FEB_WD

Feb Working Days

nn

February Working Days

Integer

PD_FEBALD

Feb Labor Days Actual

nnnnn.nn

February Labor Days Actual

Double

PD_FEBPLD

Feb Labor Days Planned

nnnnn.nn

February Labor Days Planned

Double

PD_FLUIDS

Fluid $

nnnnnnn.

Fluid $ per FY

Double

PD_FY_ID

Fiscal Year Rec #

nnnnnnnn

Link to WKFYEAR.FY_ID

Long Integer

PD_FYEAR

Fiscal Year

nnnn

Fiscal Year

Integer

PD_HRPDAY

Hours/Day

nn

Hours Per Day

Integer

PD_ID

Auto Number

nnnnnnnn

AutoNumber

Long Integer

PD_IMG_FLG

 

 

Image Available

Boolean

PD_JAN_D

January $ Required

nnnnnnnn.

January Dollars Requirement Estimate

Double

PD_JAN_DA

January $ Actual

nnnnnnnn.

January Dollars Actual

Double

PD_JAN_WD

Jan Working Days

nn

January Working Days

Integer

PD_JANALD

Jan Labor Days Actual

nnnnn.nn

January Labor Days Actual

Double

PD_JANPLD

Jan Labor Days Planned

nnnnn.nn

January Labor Days Planned

Double

PD_JUL_D

July $ Required

nnnnnnnn.

July Dollars Requirement Estimate

Double

PD_JUL_DA

July $ Actual

nnnnnnnn.

July Dollars Actual

Double

PD_JUL_WD

Jul Working Days

nn

July Working Days

Integer

PD_JULALD

Jul Labor Days Actual

nnnnn.nn

July Labor Days Actual

Double

PD_JULPLD

Jul Labor Days Planned

nnnnn.nn

July Labor Days Planned

Double

PD_JUN_D

June $ Required

nnnnnnnn.

June Dollars Requirement Estimate

Double

PD_JUN_DA

June $ Actual

nnnnnnnn.

June Dollars Actual

Double

PD_JUN_WD

Jun Working Days

nn

June Working Days

Integer

PD_JUNALD

Jun Labor Days Actual

nnnnn.nn

June Labor Days Actual

Double

PD_JUNPLD

Jun Labor Days Planned

nnnnn.nn

June Labor Days Planned

Double

PD_LABOR

Labor $

nnnnnnn.

Labor $ per FY

Double

PD_MAR_D

March $ Required

nnnnnnnn.

March Dollars Requirement Estimate

Double

PD_MAR_DA

March $ Actual

nnnnnnnn.

March Dollars Actual

Double

PD_MAR_WD

Mar Working Days

nn

March Working Days

Integer

PD_MARALD

Mar Labor Days Actual

nnnnn.nn

March Labor Days Actual

Double

PD_MARPLD

Mar Labor Days Planned

nnnnn.nn

March Labor Days Planned

Double

PD_MAT

Material $

nnnnnnn.

Material $ per FY

Double

PD_MAY_D

May $ Required

nnnnnnnn.

May Dollars Requirement Estimate

Double

PD_MAY_DA

May $ Actual

nnnnnnnn.

May Dollars Actual

Double

PD_MAY_WD

May Working Days

nn

May Working Days

Integer

PD_MAYALD

May Labor Days Actual

nnnnn.nn

May Labor Days Actual

Double

PD_MAYPLD

May Labor Days Planned

nnnnn.nn

May Labor Days Planned

Double

PD_MISC

Misc $

nnnnnnn.

Misc $ per FY

Double

PD_MOD_BY

Last Modified By

25x

Last Modified By

Text

PD_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

PD_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

PD_MOV_FLG

 

 

Movie Available

Boolean

PD_NOV_D

November $ Required

nnnnnnnn.

November Dollars Requirement Estimate

Double

PD_NOV_DA

November $ Actual

nnnnnnnn.

November Dollars Actual

Double

PD_NOV_WD

Nov Working Days

nn

November Working Days

Integer

PD_NOVALD

Nov Labor Days Actual

nnnnn.nn

November Labor Days Actual

Double

PD_NOVPLD

Nov Labor Days Planned

nnnnn.nn

November Labor Days Planned

Double

PD_OCT_D

October $ Required

nnnnnnnn.

October Dollars Requirement Estimate

Double

PD_OCT_DA

October $ Actual

nnnnnnnn.

October Dollars Actual

Double

PD_OCT_WD

Oct Working Days

nn

October Working Days

Integer

PD_OCTALD

Oct Labor Days Actual

nnnnn.nn

October Labor Days Actual

Double

PD_OCTPLD

Oct Labor Days Planned

nnnnn.nn

October Labor Days Planned

Double

PD_OU_PCT

% Over/Under

-nnn.n

% of Budget Over or Under in FY

Double

PD_PAB

Planned Ann Budget

nnnnnnnn.

Planned Annual Budget

Double

PD_PYDAD

% Labor Days YTD vs Plan

nnnn.nn

Percent Labor Days YTD vs Actual

Double

PD_REMAIN

Remaining Budget

-nnnnnnnn.

Remaining Budget

Double

PD_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

PD_SAREACD

Sub-Area

10x

Sub-Area Code

Text

PD_SAREATY

Sub-Area Text

40x

Sub-Area Description

Text

PD_SDIV_CD

Sub-Division

10x

SubDivision Code

Text

PD_SDIV_TY

Sub-Division Text

40x

SubDivision Description

Text

PD_SEP_D

September $ Required

nnnnnnnn.

September Dollars Requirement Estimate

Double

PD_SEP_DA

September $ Actual

nnnnnnnn.

September Dollars Actual

Double

PD_SEP_WD

Sep Working Days

nn

September Working Days

Integer

PD_SEPALD

Sep Labor Days Actual

nnnnn.nn

September Labor Days Actual

Double

PD_SEPPLD

Sep Labor Days Planned

nnnnn.nn

September Labor Days Planned

Double

PD_TOT_WD

Total Days

nnn

Total Working Days

Integer

PD_TOTAL

Total Spent $

nnnnnnn.

Department Total $ per FY

Double

PD_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

PD_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

PD_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

PD_USER13

User 13

 

User 13

Boolean

PD_USER14

User 14

 

User 14

Boolean

PD_USER15

User 15

 

User 15

Boolean

PD_USER1CD

User 1

nnn

User 1

Integer

PD_USER1TY

User 1 Text

25x

User 1 Text

Text

PD_USER2CD

User 2

nnn

User 2

Integer

PD_USER2TY

User 2 Text

25x

User 2 Text

Text

PD_USER3CD

User 3

nnn

User 3

Integer

PD_USER3TY

User 3 Text

25x

User 3 Text

Text

PD_USER4

User 4

30x

User 4

Text

PD_USER5

User 5

30x

User 5

Text

PD_USER6

User 6

30x

User 6

Text

PD_USER7

User 7

-nnnnnnnn.nn

User 7

Double

PD_USER8

User 8

-nnnnnnnn.nn

User 8

Double

PD_USER9

User 9

-nnnnnnnn.nn

User 9

Double

PD_YR_D

Total $ Required

nnnnnnnn.

Annual Dollars Requirement Estimate

Double

PD_YRPLD

Total Labor Days Planned

nnnnn.nn

Total Labor Days Planned

Double

PD_YTDALD

Total Labor Days Act YTD

nnnnn.nn

Total Labor Days Actual YTD

Double