ࡱ> /. FI\p W. Harless Ba==h,8X@"1Arial1Arial1Arial1Arial1& Courier New1& Courier New1Arial1Arial1 Arial1$Arial1 Arial1& Courier New"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"                + ) , *    X  H "         "X   X  "   H   h  `Sheet18Sheet29Sheet3`i Column TitleColumn ContentsDCPDS_02 Current Date V9A_FILEIDBAA_SSANSSANBBA_NAMENameJQJ_PLANCurrent Pay Plan JA0_GRADEGradeM0E_STEPStep JQN_PAYTABLE Pay Table ID JQP_SERIESSeries JPC_TITLEPosition TitleJ4B_HOURS_WEEKHours Scheduled WeekJZX_WORK_SCHED Work ScheduleS1A_APPOINTMENTAppt Type Code M0O_WGI_DUE Date WGI DueJNA_CPCNCiv Pers Control Number JEB_MANPOWERAF Manpower ControlBCA_PASPAS Code (BCA)JEE_PASPAS Code (JEE) BCE_EMPACTEmploying Activity UIC JES_UNITID Unit Id CodeJEJ_ORG DCPS Org Code JAR_NAVYORG Navy Org Code JPH_OFFSYM Office SymbolJEK_FACFunctional Activity Code JEL_PROGELEProgram Element Code JPE_GEOLOCGSA Geo Location JRC_MAJCMDMajor Command Code JRB_AGENCY Agency CodeR0A_RETIREMENTRetirement Plan Code M2B_FEHBPLAN FEHB PlanM2C_ENROLLMENTFEHB Enrollment M2F_FEHBDATEFEHB Effective Date TSE_TSPPCTThrift Savings Plan percent TSF_TSPAMTThrift Savings Plan amount TSM_TSPDATETSP Effective Date M1A_FEGLI FEGLI code JPX_LOCPCTLocality Percent JPY_LOCAREALocality Pay Area JQH_TGTGRADE Target Grade JQU_PREMIUMPremium Pay Indicator M0G_PAYDETERMPay Rate DeterminantM5Q_RETEN_ALLOWRetention Allowance M5V_RETEN_PCTRetention Percentage R1A_ANNUITANTAnnuitant StatusSBA_EMPLOYMENTType Of EmploymentC5E_DUTYSTATUS Duty Status GA2_PROMOTEDDate Last Promotion GA6_EXPIRESDate Temp Prom Expires J4D_PARTTIMEPart Time Indicator J6A_POSITIONDate Start Present Position JNB_SUPERVSupv Level of Position JQL_BASIS Pay BasisJQW_FLSAFLSA Applicability PEA_AMT_PCTEntitlement Amt PctPEC_ENTITLEMENTEntitlement Code S0C_TENURE Tenure Catgy S1F_LQIDATEDate Last Equiv Step Inc S1G_TEMPNTEDate Temp Appt ExpiresS1K_SCDService Comp Date M5E_SALARYBasic Salary Rate M5F_LOCAMTLocality Pay Amount M5G_ADJUSTAdjusted Salary V7D_PREMIUMPremium Pay AmountX1B_AMSArmy AMS X1M_TDALINE Army TDA Line X1N_TDAPARAArmy TDA ParagraphXDV_APCArmy APC JAQ_DFASCACDFAS Cost Account Code XEE_DFASLINEDFAS Line Item NumberXOB_JONJob Order Number AL_BALANCEAnnual Leave Ending Balance AL_EARNEDAnnual Leave Hrs Earned PP AL_FORFEITAnnual Leave Forfeit BalanceAL_USEDAnnual Leave Used YTD AL_USEDPPPP Annual Leave Used SL_ACCRUESick Leave Accrued PP SL_BALANCESick Leave Ending Balance SL_EARNEDSick Leave Earned PP SL_FROZENFrozen Sick Leave Bal FERSSL_USEDSick Leave Used Year To Date CT_BALANCECompensatory Time Earned CT_EARNEDCompensatory Time UsedCT_USED Compensatory Time Ending Balance ML_BALANCEMilitary Leave Balance ML_EARNEDMilitary Leave Earned YTDML_USED Military Leave Used Year To Date TO_BALANCETime Off Award Ending BalanceTO_USEDTime Off Award Used Yr To Date HM_ACCRUEHome Leave Accrual Days/YearHM_AUTHHome Leave Days Authorized HM_ELIGDTHome Leave Eligibility DateHM_EFFDTHome Leave Date Effective RHF_RTABLERetained Pay Table Id RHD_RSTEPRetained Step in Grade Civ RGE_RGRADERetained Grade Civ RGD_RPLANRetained Pay Plan RGC_RGEXPIRESDate Retained Grade Expires RGB_RGBEGINSDate Retained Grade Begins File ID FlagItem TSN_TSPELIG S1H_LIMNTETSP Eligibility DateDate Limited Appt Expires File Format4Leave data elements are specified in plain language._Data elements are listed below. If a data element is not available, the column may be omitted.`DINs are used in the first three characters of column names to precisely identify data elements. Date FormatMAll dates in the text file should contain 10 characters in mm/dd/yyyy format. File NameSyymmdd identifies the date the file was created (i.e. the date the query was run). \BByymmdd.TXT is a recommended name for the resulting text file sent to Budget Builder users. File ContentsData Element ListPText file (Tab delimited) with a header row using the column titles shown below.6The header row must be the first line in the TXT file.HDCPDS_02 Budget Builder file format for the Modern DCPDS (15 June 2001)7 qq F t I q F  c  }3R'_4b7  h 9  [    FI  x"3*K28  dMbP?_*+%;&C&F&RPage &P of &N(= ףp=?)Gz?MHP LaserJet 4P@gX@MSUDHP LaserJet 4P<d "dX?Gz?U} *} } '} U Column DXx,,,   ,  ,,                   ~ ?    ~ @    ~ @    ~ @    ~ @   ~ @   ~ @   ~  @    ~ "@    ~ $@    ~ &@    ~ (@    BzX    ************ !"#$%&'()*+,-./0123456789:;<=>?~ *@    ~ !,@ !  ! ~ ".@ "  " ~ #0@ #  # ~ $1@ $ ! $ "~ %2@ % # % $~ &3@ & % & &~ '4@ ' ' ' (~ (5@ ( ) ( *~ )6@ ) + ) ,~ *7@ * - * .~ +8@ + / + 0~ ,9@ , 1 , 2~ -:@ - 3 - 4~ .;@ . 5 . 6~ /<@ / 7 / 8~ 0=@ 0 9 0 :~ 1>@ 1 ; 1 <~ 2?@ 2 = 2 >~ 3@@ 3 ? 3 @~ 4@@ 4 A 4 B~ 5A@ 5 C 5 D~ 6A@ 6 E 6 F 6~ 7B@ 7 7 7~ 8B@ 8 G 8 H 8~ 9C@ 9 I 9 J~ :C@ : K : L~ ;D@ ; M ; N~ <D@ < O < P~ =E@ = Q = R~ >E@ > S > T~ ?F@ ? U ? VDl**********************888******@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_~ @F@ @ W @ X~ AG@ A Y A Z~ BG@ B [ B \~ CH@ C ] C ^~ DH@ D _ D `~ EI@ E a E b~ FI@ F c F d~ GJ@ G e G f~ HJ@ H g H h~ IK@ I i I j~ JK@ J k J l~ KL@ K m K n~ LL@ L o L p~ MM@ M q M r~ NM@ N s N t~ ON@ O! O O~ PN@ P u P v~ QO@ Q w Q x~ RO@ R y R z~ SP@ S { S |~ T@P@ T } T ~~ UP@ U  U ~ VP@ V V ~ WQ@ W W ~ X@Q@ X X ~ YQ@ Y Y ~ ZQ@ Z Z ~ [R@ [ [ ~ \@R@ \ \ ~ ]R@ ] ] ~ ^R@ ^ ^ ~ _S@ _ _ Dl***************:***************`abcdefghijklmnopqrstuvw~ `@S@ ` ` ~ aS@ a a ~ bS@ b b ~ cT@ c c ~ d@T@ d d ~ eT@ e e ~ fT@ f f f~ gU@ g g g~ h@U@ h h h~ iU@ i i ~ jU@ j j ~ kV@ k k ~ l@V@ l l ~ mV@ m m ~ nV@ n n ~ oW@ o o ~ p@W@ p p ~ qW@ q q ~ rW@ r r ~ sX@ s s ~ t@X@ t t ~ uX@ u u ~ vX@ v v ~ wY@ w w 4******444**************>@w7 FI 9  dMbP?_*+%"??U>@7 FI :  dMbP?_*+%"??U>@7 ZOh+'0HPh| Wayne Harlessx W. HarlesssMicrosoft Excel@N@ W@ÖNZ՜.+,0 PXt | Harless SoftwarekshA Sheet1Sheet2Sheet3  Worksheets  !"#$%'()*+,-Root Entry FWorkbook:SummaryInformation(DocumentSummaryInformation8&