WKPTASK

Planning by Tasks for Category

Field Name	Caption	Mask	Description	Field Type
PT_APR_D	April $ Required	nnnnnnnn.	April Dollars Requirement Estimate	Double
PT_APR_DA	April $ Actual	nnnnnnnn.	April Dollars Actual	Double
PT_APRALD	Apr Labor Days Actual	nnnnn.nn	April Labor Days Actual	Double
PT_APRAMT	April Amount	nnnnnnnn.n	April Completion Amount Estimate	Double
PT_APRAQ	Apr Amount Completed	nnnnnnnn.n	April Amount Completed	Double
PT_APRPCT	April Percentage	nnn.nn	April Completion Percentage Estimate	Double
PT_APRPLD	Apr Labor Days Planned	nnnnn.nn	April Labor Days Planned	Double
PT_AREA_CD	Area	10x	Area Code	Text
PT_AREA_TY	Area Text	40x	Area Description	Text
PT_ASSET	Asset	25x	Asset	Text
PT_AUCOST	Actual Unit Cost	nnnnn.nn	Actual Unit Cost	Double
PT_AUG_D	August $ Required	nnnnnnnn.	August Dollars Requirement Estimate	Double
PT_AUG_DA	August $ Actual	nnnnnnnn.	August Dollars Actual	Double
PT_AUGALD	Aug Labor Days Actual	nnnnn.nn	August Labor Days Actual	Double
PT_AUGAMT	August Amount	nnnnnnnn.n	August Completion Amount Estimate	Double
PT_AUGAQ	Aug Amount Completed	nnnnnnnn.n	August Amount Completed	Double
PT_AUGPCT	August Percentage	nnn.nn	August Completion Percentage Estimate	Double
PT_AUGPLD	Aug Labor Days Planned	nnnnn.nn	August Labor Days Planned	Double
PT_AUH	Total Units/Hour Act YTD	nnnnnnn.nn	Total Units/Hour Actual YTD	Double
PT_AUNITS	Units of Asset	nnnnnnnn.	Units of Asset	Double
PT_AUOM_CD	Asset UOM	5x	Asset Unit of Measure	Text
PT_AUOM_TY	Asset UOM Text	25x	Asset Unit of Measure Text	Text
PT_CAT_CD	Category	10x	Category Code	Text
PT_CAT_TY	Category Description	60x	Category Description	Text
PT_CLOSED			Closed	Boolean
PT_CONTR	Contractor $	nnnnnnn.	Contractor $ per FY	Double
PT_CREWDAY	Crew Days Needed	nnnnnnnn.nn	Crew Days Needed to complete annual amount	Double
PT_CREWNO	# Crews Available	nnn.n	No of Crews Available	Double
PT_CRT_BY	Created By	25x	Created By	Text
PT_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
PT_DAYQUAN	Daily Quantity	nnnnnnnn.	Daily Quantity estimated to be performed	Double
PT_DEC_D	December $ Required	nnnnnnnn.	December Dollars Requirement Estimate	Double
PT_DEC_DA	December $ Actual	nnnnnnnn.	December Dollars Actual	Double
PT_DECALD	Dec Labor Days Actual	nnnnn.nn	December Labor Days Actual	Double
PT_DECAMT	December Amount	nnnnnnnn.n	December Completion Amount Estimate	Double
PT_DECAQ	Dec Amount Completed	nnnnnnnn.n	December Amount Completed	Double
PT_DECPCT	December Percentage	nnn.nn	December Completion Percentage Estimate	Double
PT_DECPLD	Dec Labor Days Planned	nnnnn.nn	December Labor Days Planned	Double
PT_DIV_CD	Division	10x	Division Code	Text
PT_DIV_TY	Division Text	40x	Division Description	Text
PT_DOC_FLG	Document Available		Document Available	Boolean
PT_DPT_CD	Department	10x	Department Code	Text
PT_DPT_TY	Department Text	50x	Department Description	Text
PT_EQUIP	Equipment $	nnnnnnn.	Equipment $ per FY	Double
PT_EVENDST	Even Monthly Distribution		Even Monthly Distribution	Boolean
PT_EXP_PCT	% of Budget Used	nnn.n	% of Budget Expended in FY	Double
PT_FEB_D	February $ Required	nnnnnnnn.	February Dollars Requirement Estimate	Double
PT_FEB_DA	February $ Actual	nnnnnnnn.	February Dollars Actual	Double
PT_FEBALD	Feb Labor Days Actual	nnnnn.nn	February Labor Days Actual	Double
PT_FEBAMT	February Amount	nnnnnnnn.n	February Completion Amount Estimate	Double
PT_FEBAQ	Feb Amount Completed	nnnnnnnn.n	February Amount Completed	Double
PT_FEBPCT	February Percentage	nnn.nn	February Completion Percentage Estimate	Double
PT_FEBPLD	Feb Labor Days Planned	nnnnn.nn	February Labor Days Planned	Double
PT_FLUIDS	Fluid $	nnnnnnn.	Fluid $ per FY	Double
PT_FTECDAY	Min Crew Days	nnnnnnnn.nn	Minimum Days needed if all Available crews were assigned	Double
PT_FY_ID	Fiscal Year Rec #	nnnnnnnn	Link to WKFYEAR.FY_ID	Long Integer
PT_FYEAR	Fiscal Year	nnnn	Fiscal Year	Integer
PT_GUIDE	Modify Guidelines		Modify Guidelines	Boolean
PT_HRPDAY	MHs Reqd/CrewDay	nnnn.	Total Manhours required per crew day	Double
PT_ID	Auto Number	nnnnnnnn	AutoNumber	Long Integer
PT_IMG_FLG			Image Available	Boolean
PT_JAN_D	January $ Required	nnnnnnnn.	January Dollars Requirement Estimate	Double
PT_JAN_DA	January $ Actual	nnnnnnnn.	January Dollars Actual	Double
PT_JANALD	Jan Labor Days Actual	nnnnn.nn	January Labor Days Actual	Double
PT_JANAMT	January Amount	nnnnnnnn.n	January Completion Amount Estimate	Double
PT_JANAQ	Jan Amount Completed	nnnnnnnn.n	January Amount Completed	Double
PT_JANPCT	January Percentage	nnn.nn	January Completion Percentage Estimate	Double
PT_JANPLD	Jan Labor Days Planned	nnnnn.nn	January Labor Days Planned	Double
PT_JUL_D	July $ Required	nnnnnnnn.	July Dollars Requirement Estimate	Double
PT_JUL_DA	July $ Actual	nnnnnnnn.	July Dollars Actual	Double
PT_JULALD	Jul Labor Days Actual	nnnnn.nn	July Labor Days Actual	Double
PT_JULAMT	July Amount	nnnnnnnn.n	July Completion Amount Estimate	Double
PT_JULAQ	Jul Amount Completed	nnnnnnnn.n	July Amount Completed	Double
PT_JULPCT	July Percentage	nnn.nn	July Completion Percentage Estimate	Double
PT_JULPLD	Jul Labor Days Planned	nnnnn.nn	July Labor Days Planned	Double
PT_JUN_D	June $ Required	nnnnnnnn.	June Dollars Requirement Estimate	Double
PT_JUN_DA	June $ Actual	nnnnnnnn.	June Dollars Actual	Double
PT_JUNALD	Jun Labor Days Actual	nnnnn.nn	June Labor Days Actual	Double
PT_JUNAMT	June Amount	nnnnnnnn.n	June Completion Amount Estimate	Double
PT_JUNAQ	Jun Amount Completed	nnnnnnnn.n	June Amount Completed	Double
PT_JUNPCT	June Percentage	nnn.nn	June Completion Percentage Estimate	Double
PT_JUNPLD	Jun Labor Days Planned	nnnnn.nn	June Labor Days Planned	Double
PT_LABOR	Labor $	nnnnnnn.	Labor $ per FY	Double
PT_MAR_D	March $ Required	nnnnnnnn.	March Dollars Requirement Estimate	Double
PT_MAR_DA	March $ Actual	nnnnnnnn.	March Dollars Actual	Double
PT_MARALD	Mar Labor Days Actual	nnnnn.nn	March Labor Days Actual	Double
PT_MARAMT	March Amount	nnnnnnnn.n	March Completion Amount Estimate	Double
PT_MARAQ	Mar Amount Completed	nnnnnnnn.n	March Amount Completed	Double
PT_MARPCT	March Percentage	nnn.nn	March Completion Percentage Estimate	Double
PT_MARPLD	Mar Labor Days Planned	nnnnn.nn	March Labor Days Planned	Double
PT_MAT	Material $	nnnnnnn.	Material $ per FY	Double
PT_MAY_D	May $ Required	nnnnnnnn.	May Dollars Requirement Estimate	Double
PT_MAY_DA	May $ Actual	nnnnnnnn.	May Dollars Actual	Double
PT_MAYALD	May Labor Days Actual	nnnnn.nn	May Labor Days Actual	Double
PT_MAYAMT	May Amount	nnnnnnnn.n	May Completion Amount Estimate	Double
PT_MAYAQ	May Amount Completed	nnnnnnnn.n	May Amount Completed	Double
PT_MAYPCT	May Percentage	nnn.nn	May Completion Percentage Estimate	Double
PT_MAYPLD	May Labor Days Planned	nnnnn.nn	May Labor Days Planned	Double
PT_MISC	Misc $	nnnnnnn.	Misc $ per FY	Double
PT_MOD_BY	Last Modified By	25x	Last Modified By	Text
PT_MOD_DT	Last Modified Date	mm/dd/yyyy	Last Modified Date	Date/Time
PT_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
PT_MOV_FLG			Movie Available	Boolean
PT_NOV_D	November $ Required	nnnnnnnn.	November Dollars Requirement Estimate	Double
PT_NOV_DA	November $ Actual	nnnnnnnn.	November Dollars Actual	Double
PT_NOVALD	Nov Labor Days Actual	nnnnn.nn	November Labor Days Actual	Double
PT_NOVAMT	November Amount	nnnnnnnn.n	November Completion Amount Estimate	Double
PT_NOVAQ	Nov Amount Completed	nnnnnnnn.n	November Amount Completed	Double
PT_NOVPCT	November Percentage	nnn.nn	November Completion Percentage Estimate	Double
PT_NOVPLD	Nov Labor Days Planned	nnnnn.nn	November Labor Days Planned	Double
PT_OCT_D	October $ Required	nnnnnnnn.	October Dollars Requirement Estimate	Double
PT_OCT_DA	October $ Actual	nnnnnnnn.	October Dollars Actual	Double
PT_OCTALD	Oct Labor Days Actual	nnnnn.nn	October Labor Days Actual	Double
PT_OCTAMT	October Amount	nnnnnnnn.n	October Completion Amount Estimate	Double
PT_OCTAQ	Oct Amount Completed	nnnnnnnn.n	October Amount Completed	Double
PT_OCTPCT	October Percentage	nnn.nn	October Completion Percentage Estimate	Double
PT_OCTPLD	Oct Labor Days Planned	nnnnn.nn	October Labor Days Planned	Double
PT_OHITEM	Overhead Item		Overhead Item - if checked these Task costs do not get rolled up in Department or FY	Boolean
PT_OU_PCT	% Over/Under	-nnn.n	% of Budget Over or Under in FY	Double
PT_PD_ID	Department Record #	nnnnnnnn	Link to WKPDEPT.PD_ID	Long Integer
PT_PUCOST	Planned Unit Cost	nnnnn.nn	Planned Unit Cost	Double
PT_PUH	Total Planned Units/Hour	nnnnnnn.nn	Total Planned Units/Hour	Double
PT_PYDAD	% Labor Days YTD vs Plan	nnnn.nn	Perc Labor Days YTD vs Plan	Double
PT_PYDAQT	% Quantity YTD vs Actual	nnnn.nn	Percent Quantity YTD vs Actual	Double
PT_REMAIN	Remaining Budget	-nnnnnnnn.	Remaining Budget	Double
PT_ROWVER			Rowversion for optimistic locking	Date/Time
PT_SAREACD	Sub-Area	10x	Sub-Area Code	Text
PT_SAREATY	Sub-Area Text	40x	Sub-Area Description	Text
PT_SDIV_CD	Sub-Division	10x	SubDivision Code	Text
PT_SDIV_TY	Sub-Division Text	40x	SubDivision Description	Text
PT_SEP_D	September $ Required	nnnnnnnn.	September Dollars Requirement Estimate	Double
PT_SEP_DA	September $ Actual	nnnnnnnn.	September Dollars Actual	Double
PT_SEPALD	Sep Labor Days Actual	nnnnn.nn	September Labor Days Actual	Double
PT_SEPAMT	September Amount	nnnnnnnn.n	September Completion Amount Estimate	Double
PT_SEPAQ	Sep Amount Completed	nnnnnnnn.n	September Amount Completed	Double
PT_SEPPCT	September Percentage	nnn.nn	September Completion Percentage Estimate	Double
PT_SEPPLD	Sep Labor Days Planned	nnnnn.nn	September Labor Days Planned	Double
PT_TCONV	Conversion Factor	nnn.nn	Conversion factor for Asset UOM to Task UOM	Double
PT_TK_ID	Task Setup Rec #	nnnnnnnn	Link to WKUTASK.TK_ID	Long Integer
PT_TOTAL	Total $	nnnnnnn.	Task Total $ per FY	Double
PT_TSK_CD	Work Task	15x	Work Task Code	Text
PT_TSK_TY	Work Task Description	50x	Work Task Description	Text
PT_TUNITS	Task Asset Units	nnnnnnnn.	Units of Asset based on TASK UOM	Double
PT_TUOM_CD	Task UOM	5x	Task Unit of Measure	Text
PT_TUOM_TY	Task UOM Text	25x	Task Unit of Measure Text	Text
PT_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
PT_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
PT_USER12	User 12	mm/dd/yyyy	User 12	Date/Time
PT_USER13	User 13		User 13	Boolean
PT_USER14	User 14		User 14	Boolean
PT_USER15	User 15		User 15	Boolean
PT_USER1CD	User 1	nnn	User 1	Integer
PT_USER1TY	User 1 Text	25x	User 1 Text	Text
PT_USER2CD	User 2	nnn	User 2	Integer
PT_USER2TY	User 2 Text	25x	User 2 Text	Text
PT_USER3CD	User 3	nnn	User 3	Integer
PT_USER3TY	User 3 Text	25x	User 3 Text	Text
PT_USER4	User 4	30x	User 4	Text
PT_USER5	User 5	30x	User 5	Text
PT_USER6	User 6	30x	User 6	Text
PT_USER7	User 7	-nnnnnnnn.nn	User 7	Double
PT_USER8	User 8	-nnnnnnnn.nn	User 8	Double
PT_USER9	User 9	-nnnnnnnn.nn	User 9	Double
PT_YR_D	Total $ Required	nnnnnnnn.	Annual Dollars Requirement Estimate	Double
PT_YRAMT	Annual Completion Est.	nnnnnnnn.n	Annual Completion Amount Estimate	Double
PT_YRPCT	Total Percentage	nnn.nn	Annual Completion Percentage Estimate	Double
PT_YRPLD	Total Labor Days Planned	nnnnn.nn	Total Labor Days Planned	Double
PT_YTDALD	Tot Labor Days Actual YTD	nnnnn.nn	Total Labor Days Actual YTD	Double
PT_YTDQNT	YTD Completed Quantity	nnnnnnnn.n	YTD Completed Quantity	Double