@X V j 3 z; ~X 4 %/ G_IMFAST.SPR G_IM2171.SPR G_ImObl.SPR G_IMPAY.SPR G_IMEMP.SPR N_LXL.SPR N_IMACT.SPR N_EXACT.SPR N_APC.SPR T
PeB T
PeBG 5 ' J (
!
" J (
# # T
FF
8# T
FF
8# T
FF
8 %F
= T
F$ % MYR ACTUALS.DBF PAYROLL.DBF8
T
& e
T
/
T
' / T
T
( T
) *
%F m.pvImportIDf N T
\ $ % BBC T
|#30 Import Payroll Data |#21 Import Personnel Data |- |#10 Import Pay Tables3 |#51 Import Navy Job Orders from KX90098.CNRF_JON |#52 Import Army APCs $ % MYR\T
, |#35 Import Obligations - FASTDATA FDD Files( |#34 Import Obligations - NC 2171 format9 |#34 Import Obligations - STARS-FL QMF KX90098.CNRF_JCOCC* |#34 Import Obligations - USMC FAMR Report |-3 |#34 Import Documents - STARS-FL QMF KX90098.DCCSCC4 |#34 Import Documents - FASTDATA Document Status Log |-6 |#51 Import Job Orders - STARS/FL QMF KX90098.CNRF_JON |#52 Import Army APCs %$ % REC T
" E T
F/ 0FF F
` Import Data+ %F
B T
FF
`k
_F
T
/ T
, T
- T
. F T/ F
1 0 .DBF T2 3 4 T
3 4 T
SCH;TXTx%F Import Pay Tables T @ 3.6, 2 SAY 'Imports DOD CPMS FWS and Titles 5 and 38 special pay tables.'SIZE 2,65A @ 4.6, 2 SAY 'FWS wage grade tables must be named like WFA*.SCH' o @ 5.6, 2 SAY 'Special rate tables must be named SPEC_yy.TXT where yy is the year tables were issued.' SIZE 3,65" @ 9.0,23 GET m.lsInFile SIZE 1,40V @ 8.75, 4 GET m.csButton1 PICTURE "@*HN \
Done. \n\n* T
>
>
Update file: F
- T
>
> \nMaster file: F3 4 ; T
>
> \n\nUpdated F
9 ? pay tables? T
>
> \nAdded F
8 ? new pay tables\n\nO F
> < //Title Fini //FUNCTION "\!\Q FFFD for the & A A G(( pt_id #) F
PAY_MAST^ >_ & A A G(( PT_ID
T` F/ ~K F/ Ta / A Tb / B Tc Fb \m Td / X Te REALFFc ^D Tf RDFFc ^D$ Tg FFF/ L ^ 0/ F Th PTSFFc ^D Fi Ea
%F6
> R,a 0 <-- new table being appended to pay rates file. F PAY_CHGS&A
a %Fc , - GW REPLACE &tgtmemo WITH updtmemo, &tgtspec WITH updtspec, &tgtdt WITH updtdt
F / j Fi < F Done.\n\nTime FF. <
^ minL //Title Fini //FUNCTION "\!\s F u v w t %
n PPD >x F z ey $ >{ F{ CTRANS COSTXFER >| } { F >} { F > { F > { FB > F ` F `{ F FF @ + > F z } AR
(
F
! j F
k j = B
%|$ J(
T
! F
1 0 .DB1 T
F
1 0 .DB2 T
FF3
T
/T %FF3 jFF3 j
FF3 jFF3 j
F3 F3 T G The current working files are not permitted to export data to FASTDATA. \n\nF3 \nF3 E \n\nOnly the files listed in Setup may be used to export to FASTDATA. \n\nF3 \nF3 ; F * //SCHEME 7 //ICON CAUTION //ALIGNMENT LEFTp B %F3 2
q F Master Budget file F3
not found.\n3 Please select a valid Budget file before exporting.p B %F3 2
4o F Master OPTAR file F3
not found.\n2 Please select a valid OPTAR file before exporting.p B 4 % OKF FASTDATA Export N_EXACT.SPR5 p B u +
^ YesF! Is FASTDATA floppy disk in drive F
A:\ B:\
//ICON CAUTION %4 % OKF FASTDATA Export N_EXACT.SPR5 ! B . T
F
A:\ B:\F
\ T
3
T
FDDBOPT.DBF! T
FDDBAUTH.DBF! T
FDDMATCH.DBF? T
F
CURRENT FIRST SECOND .LAB F
j F
j F
j F CURRENT.LABj F FIRST.LABj F
SECOND.LABj D(
RFYw h1
C C C( C( C( C N6h1
CHARACTER CHARACTER CHARACTER CHARACTER CHARACTER NUMERIC NUMERIC NUMERIC NUMERIC NUMERIC CHARACTER CHARACTER h1
CHARACTER CHARACTER CHARACTER CHARACTER CHARACTER = F
FDDBOPT^ F
FDDBAUTH^ F
FDDMATCH^ F3 BGT^ F3 OPT^ f o BGTF k F
6 F F # OPTF k
AERROR % @ T
FASTDATA Export Results FF$+ FbF
F
F #) ~F U T
No OPTAR: F
^F
#) ~F W T
No BudLine: F
^F
#) ~F
F
j T
OPTAR not found in OPTAR file: F
^F
F
EXPORT.TXT
% YesF+ Some data could not be exported because of ) missing or invalid information.\nDetails ' are provided in the file EXPORT.TXT\n\n, The remaining data can be exported properly. \n\nWould you like to proceed? //ICON CAUTION = B 0 F? Exporting to FASTDATA... F + I (
F k F
F
ASORT^ N (
! T
F
1 0 .DBF o
! F k
F
F
" OPTF k 1
T
F ? %
! > !, > > F? T
F
1 0 .DB9H o
! 1
F ? T
F
1 0 .DBF{ o F U OPTF k
OPTAR 1
T
F333333? F
Fffffff? F
F? F
F
! j F
j F
j F
j F
j =
F F Export is complete.\nF
? authorizations lines in F
? FY F
? OPTARS were exported.@ B
""'
T
e T
T
F$ T
T
%F
G%F T
F F
Import Obligations TXT G_ImObl.SPR %F
C% B m% T
T
/ %$ % REC '
T X T G \nFiles downloaded from CA-View may differ slightly from other files.\n: T ) \n\nAre you importing files from CA-View? T \n\n\n{ T
F
b //FUNCTION "\!\ T
F
A:\FDDBDAU.DBF B:\FDDBDAU.DBF
% %F UPDATE
/6
+ B 9 F? FastData Import Initializing... T
*
T*
T*
T*
T*
T*
&08 T
F DBF Select Obligation file Select %F
, B ! % 38F
38
-_ T
\nF
? is not an obligation file in FASTDATA FDDBJOFA format.\n\n\n\n+ F
//ICON stop //scheme 5 p B ( T
FF
OBLIG .DBF: \1 {End}{LeftArrow}{LeftArrow}{LeftArrow}{LeftArrow} % OKF FASTDATA Import 9 @ 4, 5 SAY 'FDDBJOFA obligation file selected for import' @ 5, 5 SAY m.lsInfile style 'B'5 @ 7, 5 SAY 'Enter a name for the new obligation file'. @ 9, 5 GET m.lsOutFile SIZE 1, 55 PICTURE '@!'5 . B T
! F
1 0 .DBF o
1
! %F
AAAq
@0 F
! j B S
! >FF `F$ F
! j R = F
AAA_FDJO B
2
J ( T
T
T
/
T
/ T
F
FF$\m
T
& e
T
e T
EMPLOYEE.DBF T
!F
%F BBMIM21.MEM21 @ BBMIM21 T
@ T
F
! Import Employees TXT G_ImEmp.spr %F
2 B ! T
FF
|# T
$F |
T
!
D( BBMIm21 m* T
%
T
&F
1 0 .DBF
"6 T
' T
( T
T e T
) T
* T
+ T
, Full Detail0 T
-
,FF
) -
)8 T
T
T
!F
%F BBMIM30.MEM23 @ BBMIM30 T
? T
F
! Import Payroll TXT G_imPay.spr %F
,4 B ! T
!FF
|# D( BBMIm30 m*
T X T G \nFiles downloaded from CA-View may differ slightly from other files.\n< T + \n\nAre you importing files from CA-View?\n{ T
F
b //FUNCTION "\!\gh1
! = C > C? C@ CA CB CC CD CE CF CG CH CI CJ CK CL CM CN CO CP CQ CR CS C R,:F working 1<
= JOB ORDER F=` F=` F=` F=` -= = ----------- 3
4v@gh1
! = C? CG CT CU CJ CK CV CW CX CQ CY C Z C[ C\ C> C(] CR C^ CD C_ C` Ca C
%F
JOBORDERq
@ B R,:F working 2< S
! R,:F working 3<
@=C
3mA >IFF=`F$ >bFA` >AFA` >`FF? D R8
4=C! >IFF=?F$F= >IF=?F=
>AFWdF[d >=F=`% >`F? 0 3 D R8 %F
7
7 0 ;B I
7 %F
8
8 0 B T
c mcFF8 0+ replace all &lsFld4mdep with MNFDDAUTH
%F
9
9 0 9C T
d mcFF9 0K replace all &lsFld4ams with subs(mcpe,val(m.lmAPCpos),val(m.lmAPCchar))
R,:F working 4< F?9 T
eF
1 0 .DBF & =f G(( mcJOU
(
e S G((
e R,:F working 5< %
4QD %FQ MDB F/ No records were imported \nfor fiscal year -->
7p B F M_IDg R,:F working 6< = F
! j F
ej = R / ThFF m.lsTotTimef C
i 8 Tj Done. h@ Tjj \nJO/APC file F
has been created.Y TjjH \nYou may use Assign Budget Codes to enter these codes into other files.@ Tjj \n\nWould you like to open F
now? Tjj \n\n\nT % YesF j8 //Title Done //SCHEME 7 //ICON CAUTION //ALIGNMENT LEFT WF F
B
pFKG $ % BBCF %
F T
k EE T
lF3 m F T
k PPD T
lF3 n ( $ % MYR $ % REC ?G T
k AAA T
lF3 2KG B
\GG
G T
l
G> T
FFF
F
8F
DBF5 %F
kq
G B S Q %
& lQ T
%
o(F |
hQ T
F
o |# %
H T
F
DBF5 %
#H$ %F IMPORT
6
H . T
pF
q T
IO $ % BBC\N %
J T
rF
%
r ED
I % YesFF
( does not appear to be a DCPDS text file, .\nWould you like to import the file anyway? //ICON CAUTION I . XNP T
FF F
p?, A41 B42 C14 F43 L15 M16 N18 R44 V45 T46 G47sk %
%K % YesF The file F
has an invalid format code : F
p?8 .\nWould you like to skip this file and continue import? //ICON CAUTION K . !K B $ %F
p A BF
L % YesF "F
p? " does not appear to be the correct format code for F
, .\nWould you like to import the file anyway? //ICON CAUTION K . T
FF
p`k TtFFF$` TuFFtk? ! %F
? FFF$`L T
FFtF
? k: L T
FFuF
? k: 4 T
FFF
p`kFF
p`k
- %F
v
F
,/
TN)% YesF The file F
is named for F
++ , which is not the end of a pay period.\n\nb Note: The payroll file name must contain the last digit of the calendar year, not fiscal year.\n\n9 Would you like to skip this file and continue import?\n\n //ICON CAUTION DN . PN B ( $ % MYR $ % REC O %
#O T
FF
k %
{O % YesF The file F
+ is is not a recognized obligations file.\n5 Would you like to skip this file and continue import? //ICON CAUTION kO . wO B +
w
o(F |
P1 %FF
qFFF
w |#qP FL Import cannot proceed because two of the input files will generate the file
[ \n\nPlease rename the TXT or HTM file so that the resulting DBFs will have different names.p B T
*
T*
T*
T*
T*
T*
p %
Q B T
xF
o(
"U T
F
o* T
F
o* T
F
o* T
F
o* T
pF
o* y F?
Importing F
- File F
o? of F
? Fy - Preparing for import... %
R' T
F
o
%
&8 %
AS %F
keq
5S B S Q z =
F , %F
)*+,.T F
PPD^ >x F z ey Fx >{F| %
*
T > F z } %
+
rT! > F `{ F! > F `{ F
}
Q~ - %
o U
F
%
&F F
&j T
%
F F
! j F
" j G
iUU% FF
8U F3 >3 m
B 21% FF
8 U F3 >3 n
B 30 %
'
X
Tj %F
lnImportIdf NV %
VK Tjj: Audit is recommended for personnel files after import.\n\n %
WN Tjj Import completed in Fy
# \n\nOpen new file now?\n\n W Tjj Import completed in Fy
# a \n\nOpen new file now?\n\n( When more than one file was imported the last file may be opened. )\n * % YesF j //ICON CAUTION X! TF
8 F
( wX %F
sXM F Import is complete.\nF
? file(s) have been imported.@ UPVIMPORTIDPSIMINFILEPSIMOUTFILG_IMFAST SPR
! *G_IM2171 G_IMOBL G_IMPAY . G_IMEMP 3N_LXL 2 N_IMACT N_EXACT !N_APC _REFOX_ IFORMAT IIMFILE LBSHOWNEWFLNIMFILES LNIMPORTIDLNOFFSET LNYEAR @LNYRDIGIT LSDETAILDELSFILTDESCLSIMMENU LSIMNAME LSINFILE LSOUTFILE LSOUTPUTDELSPROMPTTYLSTAGFILESCSBUTTON1 LSUPDATEFILSMIDFILE LSMID2FILELSOTHERMESSYSTEM LE SYS_APPCD LBMULTIPLELBSHOWUPDALSIMOPENVILNCOMOBLCOLAIMPORT POPMENU DLNLOWFY WFLNHIGHFY ST_TIME ! PAY_CHGS ZTMPNAME GSTMPDIR PAY_MASTERPREFS PF_TT ! ASKFOR TTYFILECHK ZEXT FILE LNNEWTABLELNUPDATEDTLBSUCCESS SSR
!GS_UPDT S OPENSYS LSMSG ! ALLSTR E ZMSGBOX LEPT_ID GS EFFECT_DT MATRIX IMAGE ! SOURCE tPT_PLANS ISSUE_DATESUPERSE_DTORDER_DATEBEGIN_DT PT_FMT |!PT_1STGRD PT_LASTGRDPT_GRADES PT_STEPS PT_LINES RAREA ! GR_LIST EQ_INT TYPE_SCHEDTYPE_DATA WORDING DIFF REAL HTAG HS_KEY TT _MASTERPAY_IMP2 ALL IX S OPEN1 ! PT_TAG LE NEW_MASTERTGTID GS UPDTDT S DIGIT _DT UPDTMEMO TGTMEMO TGTDT UPDTSPEC TGTSPEC PAY_MAST HSERASE LSTEMPFILELSHSID R LLHS LSIMALIAS TRANTYPE ZALERT AS FILE_NE2 EBATCH AS EAREA PAYAREA ETABLE2 tELAA ETABLE PPACCT AS DCPS2REQ PPCD PPBATCH !PPRID H PPCIVTYPE FOR T ! PPEOE H E PPLINE PPPESFX .PPPE F PAY2EOR PPWKSCH PPTEMPPOS PPAGENCY LNDEST TIDLNFYRADIO LSSORTFILELSPATH R tZPATH WIPF_AAA pecPF_BGT EWFPF_BGTMASTPF_OPT PF_OPTMASTLCMSG MASTZMSGYN ASTCASEOF ne.RFY TH FFPF_CURFY LSBOPTFILELSBAUTHFILLSMATCHFILLSLABFILE OPT_CODE EOPT_TITLE OPT_ADDR1 OPT_ADDR2 OPT_ADDR3 OPT_UIC BOPT_FY AU_OPTCODEAU_BUDLINEAU_SUBSAG AU_EXPELE AU_DESC S AU_1ST_QTRAU_2ND_QTRAU_3RD_QTRAU_4TH_QTRAU_TOTAL tAU_FENCED AU_CEILINGM_BUDLINE M_JOBORDERM_COSTACC M_BA TMASTM_EXPELE TBGT PT FILBFY OF ne.BAMDNR FFBUDLINE BOPTID ILEAOPTID FILOPT TCHFILAFY BFILE AERROR E ELSERRTEXT BFOLDID T BNAME DR2 BNOA DDR3 ZPUTSTR T ZTHERMO T LSTMPAUTH BSAG DLINEBEOE BSAG BQ1 ESC E BQ2 ST_QTRBQ3 ND_QTRBQ4 RD_QTRLNRECCOUNTLSTMPMATCHBJO DLINE BCAN ORDERBBA STACC LSTMPOPT HATITLE E RA_ADD2 LE A_ADD3 R1 A_ADD4 R2 A_UIC DR3 A_RECTYPE LNOPTCOUNTFDDBAUTH FDDMATCH FDDBOPT CHMNIMOPTOUTLDASOFDATELN2171COL CDSOURCE G_IMLIST SMSG1 PPCD LSBOXCHOICLBCAVIEWIMLMSBSYM DALMSOBAN H LMSRESPCENLMDASOFDATCNIMOPTOUTLMNSOURCE LMSFILE ENBBMIMACT TGETFILE2 DGUESS LE HZFNAME E FA_ID IR JFAID ACC RC_ID PT HJRESPCEN RAPPROP_CD JAPPN R1 SUB_HEAD JSUBH DR3 BCN CTYPE JOBAN OUNTSUFFIX H JSUFFIX SITE_ID CHJSITEID UTOPTAR_ID EJOPTID OL AUTH_ID JBUDLINE SJON_ID CD JJO XCHOICJON_DESC MJREM REIMB_ID A1 RESPCENLABOR_CD TA3 MOPTOUTCLOSE_DATEA4 FILE ENCAC MACT TJCAN LE2 DC_UIC LE HJUIC E E SAG D IR JSAG ACC FUNCTION HJFSF CEN REXP_ELE D JEE1 R1 OBJ_CLASS JOC2 DR3 OBLIGATED JDOLS OUNTJTOTAL ED LOCAL_CD JFDLOCALCDJFY DFILE JOFY _ID EBBVIEW E MAIMDIN IDMNIMSERVICMBIMAMS D MBIMVAC ICCDIMVAC MCVDATE MSINPATH BBMIM21 NSTOKEN LESLNTAGGED SCSMASTER SCSSNAPSHOTLNYTD RTIDLNSECTIONSCSIMFILTVACSIMFILTFICSIMFILTEXCSIMDETAILCSIMOPTPPDBBMIM30 CLB1STLFIELLB1STMFIELLSSPR IR MBIMJAR IDMBIMAF ED MBIMDFAS TZREPLEXT BBAPC RTIDLMAPCFY CDLMAPCMDEP LMAPCAMS ELMAPCPOS LMAPCCHAR NADA ERVICMCJO FILE MCDESC ICMCRSC C MMNFSF MCDEPT H MCOBAN NMNSUFFIX SMCUIC ED SMCSAG ER SMNCAN SHOTMNSEGM TIDMCATYPE NSMCFY ILTVAMCBSYM TFIMCSUBH TEXMCRDOC AILMCRAPPN PDMCRSUBH CMCRSVC IELMCROBAN ELMCAAA IR MNFDDAUTH THEEND ED MCDPT LE SP1A EXT SP2 BH TIDMNSITEID DSP2A MDEP MCPE MS ESP5 CPOS MNFDDOPT SP6 ERVICSP7 SC LE SP8 DAUTH S99 C C MMCDR SP99 MNSCC RTIDLSFLD4MDEPLSFLD4AMS LSMID2 S MCJOU IR SERIES IDLSMSGTIME LSTOTTIME LCMSG1 ls LSOUTALIASLSOUTWORKIPF_EE EXPOPF_PPD RKII IMFILES CSBATCH E ZSTEM expoLSGUESS IDZRIGHT TIDLSCDECADE LSPDECADE ISPPS J INFILE DCNSTARTTIMREPORTTIMEBIGCASE ASPPFTPCODE PAY2STAT iFIREHRS ICPPD URCE LATEMPINFOTEXTINFO bUPDATEEMP FULLDBFPAT 5 G 1
do ImpStop
1
H T
F
D %
$ T
F
%F B T
F
( +F
DCPDS_02 T
F
%F
*
F
B
F
e
J ( 9 T & DCPDS_02 EDCPDSDT C 10 09 T & V9A_FILEID EPPI C 1 09 T & BAA_SSAN ESSN C 9 09 T & BBA_NAME ENAME C 27 09 T & JQJ_PLAN EPLAN C 5 09 T & JA0_GRADE EGRADE C 2 09 T & M0E_STEP ESTEP C 2 09 T & JQN_PAYTABLE ETABLE2 C 15 09 T & JQP_SERIES ESERIES C 9 09 T
& JPC_TITLE EPTITLE C 54 09 T & J4B_HOURS_WEEK EWKHRS N 2 09 T & JZX_WORK_SCHED ESKED C 1 09 T
& S1A_APPOINTMENT EAPPT2 C 2 09 T & M0O_WGI_DUE EWGI_DT D 8 09 T & JNA_CPCN ECPCN C 15 09 T & JEB_MANPOWER EPOSN2 C 10 09 T & BCA_PAS PAS_BCA C 8 09 T & JEE_PAS PAS_JEE C 8 09 T & BCE_EMPACT UIC2 C 6 09 T & JES_UNITID ID_CODE C 6 09 T & JEJ_ORG EORG C 7 09 T & JAR_NAVYORG ORG_CODE C 6 09 T & JPH_OFFSYM EOFFSYM C 8 09 T & JEK_FAC EFAC C 8 09 T & JEL_PROGELE EPE C 6 09 T & JPE_GEOLOC EGEOLOC C 9 09 T & JRC_MAJCMD EMAJCMD C 2 09 T & JRB_AGENCY EAGENCY C 2 09 T & R0A_RETIREMENT ERETCODE C 1 09 T & M2B_FEHBPLAN EFEHB C 3 09 T & M2C_ENROLLMENT EFEHBENRL C 1 09 T & M2F_FEHBDATE EFEHB_DT D 8 09 T !& TSE_TSPPCT ETSP C 2 09 T "& TSF_TSPAMT ETSPDOL C 4 09 T #& TSM_TSPDATE ETSPEFF D 8 09 T $& TSN_TSPELIG ETSPELIG D 8 09 T %& M1A_FEGLI EFEGLI C 2 09 T && JPX_LOCPCT ELOCPCT N 5 29 T '& JPY_LOCAREA ELAA C 2 09 T (& JQH_TGTGRADE ETGTGRADE C 2 09 T )& JQU_PREMIUM EPREMFLAG C 1 09 T *& M0G_PAYDETERM EPAYDETERM C 1 09 T +& M5Q_RETEN_ALLOW ERTNALLOW C 5 09 T ,& M5V_RETEN_PCT ERTNPCT C 2 09 T -& R1A_ANNUITANT EANNUITANT C 1 09 T .& SBA_EMPLOYMENT EEMPLOY C 1 09 T /& C5E_DUTYSTATUS EDUTYSTAT C 2 09 T 0& GA2_PROMOTED EDTLASTPRM D 8 09 T 1& GA6_EXPIRES EDTPROMEXP D 8 09 T 2& J4D_PARTTIME EPARTTIME C 1 09 T 3& J6A_POSITION EDTENTPOSN D 8 09 T 4& JNB_SUPERV ESUPV C 1 09 T 5& JQL_BASIS EBASIS C 2 09 T 6& JQW_FLSA EFLSA C 1 09 T 7& PEA_AMT_PCT EFOREIGN N 7 09 T 8& PEC_ENTITLEMENT EFORGNFLAG C 1 09 T 9& S0C_TENURE ETENURE C 1 09 T :& S1F_LQIDATE ELWIGDT D 8 09 T ;& S1G_TEMPNTE EDTAPPTEND D 8 09 T <& S1H_LIMNTE EDLAPPTEXP D 8 09 T =& S1K_SCD EDSERVCOMP D 8 09 T >& M5E_SALARY ESALARY C 12 09 T ?& M5F_LOCAMT ELOCALITY N 5 09 T @& M5G_ADJUST EADJSALARY C 12 09 T A& V7D_PREMIUM EPREMIUM N 7 09 T B& X1B_AMS AMS C 11 09 T C& X1M_TDALINE LINE C 3 09 T D& X1N_TDAPARA PARAGRAPH C 4 09 T E& XDV_APC APC C 4 09 T F& JAQ_DFASCAC ECAC C 14 09 T G& XEE_DFASLINE ELINEITEM C 4 09 T H& XOB_JON EJO C 11 09 T I& AL_BALANCE EALBALANCE N 6 29 T J& AL_EARNED EALEARNED N 6 29 T K& AL_FORFEIT EALFORFEIT N 6 29 T L& AL_USED EALUSED N 6 29 T M& AL_USEDPP EALUSEDPP N 6 29 T N& SL_ACCRUE ESLACCRPP N 6 29 T O& SL_BALANCE ESLBALANCE N 6 29 T P& SL_EARNED ESLEARNED N 6 29 T Q& SL_FROZEN ESLFROZEN N 6 29 T R& SL_USED ESLUSED N 6 29 T S& CT_BALANCE ECTBALANCE N 6 29 T T& CT_EARNED ECTEARNED N 6 29 T U& CT_USED ECTUSED N 6 29 T V& ML_BALANCE EMLBALANCE N 6 29 T W& ML_EARNED EMLEARNED N 6 29 T X& ML_USED EMLUSED N 6 29 T Y& TO_BALANCE ETOBALANCE N 6 29 T Z& TO_USED ETOUSED N 6 29 T [& HM_ACCRUE EHLACCR N 6 29 T \& HM_AUTH EHLAUTH N 6 29 T ]& HM_ELIGDT EHLELIGDT N 6 29 T ^& HM_EFFDT EHLEFFDT N 6 29 T _& RHF_RTABLE ERTTABLEID C 4 09 T `& RHD_RSTEP ERTSTEP C 2 09 T a& RGE_RGRADE ERTGRADE C 2 09 T b& RGD_RPLAN ERTPAYPLAN C 2 09 T c& RGC_RGEXPIRES ERTGRENDDT D 8 09 T d& RGB_RGBEGINS ERTGRBEGDT D 8 09 T e& XXX_UIC EUIC C 6 0 T
F
F F T
FF
(
% T
FFF
F j T
F
%
, T
FILLERF
T
C T
T
, T
FFF
` T
C2 T
FFFF
`k T
T
(
$ T
F
| T
(F @ T
FFF
` %F
|
<
T
, T
FFF
`. T
FFFF
`k. T
FFFF
%`k T
F?9 T
F
.DBF h1
F #) }(
F #$ > F , F , #)- > F FF @`F k = > F FF @? .FF UFF k '- > F FF @`F k = > F FF @? .FF UFF k '
" > ! >" F# F$
A >% & '
v " > F( `F( `
> '
> ) >* F* F+ Q< F?/F- - Creating employee layout..., %F
/ EEe.
; B S Q Q
/ 0 8 F333333?/F- - Appending DCPDS data...,
I< 1 2 (
Q0 Q
3 & 1 4 G(( OneSSN
(
/ Q
/ 0 E Fffffff?/F- ' - Processing within grade increases..., (
Q
3 F0 #) T
5 ~E# %
K >6 F ` F `7 F ` F ` %
>8 9 >: F
5 ; T
5
5 2 >< REG= USD> D? " >@ F B C D E F A >0 G FF0 I `H # >0 J F0 E 0 F 0 @ K >0 L F0 B M " >N FO 3 T P8 %FP kQ!
1!! Q HO!
>R Q <m!
>R x Q 8!
>R p >Q FQ (I %F@ j HOURLY%"% T
S FB WM '8B >T F
S 8U
V ! %FW
@ HOURLY A#F %@ AC- FFD k @ AC- FFD k =#! >U V W ^ F3 $ T
D FFF
D k 0 T
U
W T
V # T
X WGI from F
Y _ F0 5 F?/F- - Serializing data.1..,
+ >X
Gain from F
Y FX >Z $ >[ 2 F[ d d 8 F H_ID\ F
^ ] F
] %F_ F
` $L T
` = \n\nSee the ALERT batch for problems corrected during import. H ^
^6 T # DCPDS_N1 Character 6 6 T # DCPDS_N2 Character 2 6 T # DATA_DT Character 8 6 T # BAA ESSN Character 9 6 T # BCA PAS_BCA Character 2 6 T # EUIC Character 6 6 T # BBA ENAME Character 27 6 T # JA0 EGRADE Character 2 6 T # M0E ESTEP Character 2 6 T
# JQP ESERIES Character 5 6 T # J4B EWKHRS Character 2 6 T # JQH ETGTGRADE Character 2 6 T
# JZX ESKED Character 1 6 T # S1A EAPPT2 Character 2 6 T # S1G DDTAPPTEND Character 6 6 T # GA6 DDTPROMEXP Character 6 6 T # S1F DDTLASTWGI Character 6 6 T # M0O DDTNEXTWGI Character 6 6 T # GA1 DDTENTGRAD Character 6 6 T # J6A DDTENTPOSN Character 6 6 T # GA2 DDTLASTPRM Character 6 6 T # R0A ERETCODE Character 1 6 T # M2B EFEHB Character 3 6 T # M1A FEGLI1 Character 1 6 T # R1A ANNUIT Character 1 6 T # TSE ETSP Character 2 6 T # TSF ETSPDOL Character 4 6 T # JNB ESUPV Character 1 6 T # S0C ETENURE Character 1 6 T # JPE EGEOLOC Character 9 6 T # SBA DUTY_STAT Character 1 6 T # C5E DUTY_STAT2 Character 2 6 T !# JNA ECPCN Character 10 6 T "# JEB EPOSN2 Character 10 6 T ## XOB EJO Character 11 6 T $# JAR ORG_CODE Character 6 6 T %# JEJ EORG Character 7 6 T &# JPH EOFFSYM Character 8 6 T '# JEK EFAC Character 8 6 T (# JEL PROG_ELE Character 6 6 T )# JES ID_CODE Character 6 6 T *# BCE UIC2 Character 6 6 T +# JRB AGENCY Character 2 6 T ,# JRC MCMD2 Character 2 6 T -# JEE PAS_JEE Character 8 6 T .# JPX LOC_PCT Character 4 6 T /# JPY ELAA Character 2 6 T 0# JQJ EPLAN Character 2 6 T 1# JQL BASIS Character 2 6 T 2# JQN ETABLE2 Character 4 6 T 3# JQW FLSA Character 1 6 T 4# M5E ESALARY Character 8 6 T 5# M5F ELOCALITY Character 5 6 T 6# M5G EADJSALARY Character 8 6 T 7# M0G EPAYDETERM Character 1 6 T 8# V7D EPREMIUM Character 7 6 T 9# JQU EPREMFLAG Character 1 6 T :# PEA EFOREIGN Character 7 6 T ;# PEC EFORGNFLAG Character 1 6 T <# JPC EPTITLE Character 54 6 T =# VV71 ENOA1 Character 3 6 T ># VV91 NOA1DT Character 6 6 T ?# VV72 ENOA2 Character 3 6 T @# VV92 NOA2DT Character 6 6 T A# VV73 ENOA3 Character 3 6 T B# VV93 NOA3DT Character 6 6 T C# VV74 ENOA4 Character 3 6 T D# VV94 NOA4DT Character 6 6 T E# VV75 ENOA5 Character 3 6 T F# VV95 NOA5DT Character 6 6 T G# XDV APC Character 4 6 T H# X1B AMS Character 11 6 T I# X1N PARAGRAPH Character 4 6 T J# X1M LINE Character 3 6 T K# M1A EFEGLI Character 2 6 T L# M2F DFEHB_DT Character 6 6 T M# TSM DTSP_DT Character 6 6 T N# RGB DRTGRBEGDT Character 6 6 T O# RGC DRTGRENDDT Character 6 6 T P# RGD ERTPAYPLAN Character 2 6 T Q# RGE ERTGRADE Character 2 6 T R# RGQ ERTSERIES Character 4 6 T S# RG5 ERTWKSKED Character 4 6 T T# RHA ERTGRDFLAG Character 1 6 T U# RHD ERTSTEP Character 1 6 T V# RHF ERTTABLEID Character 2 6 T W# JAQ DFASCAC Character 14 6 T X# XEE ELINEITEM Character 4 6 T Y# S1K DDSERVCOMP Character 6 6 T Z# R2B DDTENTDUTY Character 6 6 T [# M5V ERTNPCT Character 2 6 T \# M5Q DRTNALLOW Character 5 6 T ]# S1H DTAPPTEXP Character 6 6 T ^# HS___01 Character 4
(F R9, T
FFF
`, T
FFF
`. T
FFFF
`k+ T
FFFF
"`k F?9 T
^ F
.DBF %/J: T
/ DCPDS01.DBF6 % OKF Create DCPDS file N_DCPDS.SPRa 9 B %F NEW
/ b
: B / F? Importing DCPDS-01 data, T
c F 2 F?/F- - Appending text..., h1
^
T
FFe `d 5 F ?/F- - Creating database..., %
%; Q! o
^ F1
1
/ ? F?9 T
F
.DBF T
5 T
f
(
< %FF
g ; . " T
h F FF
g ?
;< F
h 6
V@ >% & '
@ > F( `
@
@ > k oFFFl @Fm %
m A >l n Q Q
3 < F?/F- - Creating employee layout..., %F
/ EEe.
xA B S Q Q
/ 0 8 F333333?/F- - Appending DCPDS data...,
= >o Fo d W F d W F d W Q3 (
Q
3 #)E Fffffff?/F- ' - Processing within grade increases..., T
5 ~#G %
B' >6 F ` F ` %
B
>8 p %F1 D# %
q
Fr Fs =C . > Vac - FFr s r 8D 05E FFE RUS E 8t Ku 5* 105l C0Q (v VACX
Vacancy from F
Y U
w >: F
5 ; T
5
5 2 >< REG= USD> D? >Q FQ (I" >@ F B C D E F A >0 G FF0 I `H # >0 J F0 E 0 F 0 @ K >0 L F0 B M " >N FO 3 T P8 %FP kQ3E
>R %F@ j HOURLYF% T
S FB WM '8L >T F
S 8U FF
]mx V ^ F3 T
V
U T
U FF
]mx _ F0 %FW
GF %@ AC- FFD k @ AC- FFD k G! >U V W ^ F3 $ T
D FFF
D k 0 T
U
W T
V # T
X WGI from F
Y _ F0 4 F?/F- - Serializing data...,
+ >X
Gain from F
Y FX ( >[ 2 d 2 2 &
7 >@ GS2 2 &
@ HOURLY F H_ID\ F
] F
^ ] %F_ F
` HL T
` = \n\nSee the ALERT batch for problems corrected during import.
O T
^ F
.DBF F?/F- , T
y F
ez %
{ J
h1
^ | C} C ~ C C C C C C C C C C C
C C C C K h1
^ } C ~ C C C C C C C C C C C
C C C C F?/F- ,
y 2 > F JV # F JV # 8 F ppRem > 2 > F~ U F ?} LXL2955A F ppUIC F ?/F- , Q
^ N F k FF @ 999999999 F k
F k ` > F - - 8FF ,- F - - 8FF ,- $ >} F} ` /F} ? F ?/F- , T
F
.DBF F
PPD. S
^ H > g g F Suspense reversal
^ D > F Suspense correctionF F?/F- , ( >
}
} > F > FF `F$ ) > REG) > REG F?/F- , F
/ PPD
F
^ ] F
] F
y ]
Y T
^ F
.DBF1 F?/F- - Cleaning text..., T
y F
ez 2 F?/F- - Appending text..., T
BA T
BA %
9Q/h1
^ CF
8 CF
8 C C C C C C C C C C C C C2~ C C 3R h1
^ C CF
8 C C C C C C
C C C C
~ C C
y >~ %
R %
R) >~ F ` 3951 R/ >~ F ` F ` -A ~ F ` IST 8S >~ F ` DI F ppOrg > %
S %
S. > F ` F ? 3951 S4 > F ` F ?F ` -A YT %
*T# > F ` IST UT# > F ` DI F ppUIC %
PPJO PPSSNT Delete For &csImFiltExpr
7 F ?/F- - Processing LXL data..., Q
^ N F k FF @ 999999999 F k
F k ` > F - - 8FF ,- F - - 8FF ,- %
U %
U U* > F `FF ` kV %
0V$ > F ` /F ? gV/ > F ` /FF ` %
V# > FF ` F > F `F Q9 F ?/F- - Updating LXL database..., T
F
.DBF F
PPD. S
^ Q1 F333333?/F- - Totaling data...,
D F?/F- & - Updating dates and batch numbers..., , >
}
> FF `
& > FF \m^F k
6 > FF `
FFF `@ , > F `FFF `@ ' > FF F 8 > F ) > REG) > REG2 F?/F- - Appending data..., F
/ PPD
F
^ ] F
] F
y ]
_ T
^ F
.DBF T
,ppUIC C(6),ppAAA C(6),ppOrg C(7),ppSSN C(9),ppDept C(6),ppFY C(1), ppBSym C(4),ppSubH C(4),ppJO C(11),ppRate N(13,2), ppHrs N(13,2), ppDols N(13,2), ppCd C(2),ppGeoLoc C(9),ppPaySys C(2), ppEmpType C(1),ppGdInd C(1),ppWkSch C(1)0 F?/F- - Reading text..., T
y F
z F
y
^
F$
` - F$
` - ORGANIZATION CODE:$ EMPLOYING ACTIVITY:$ ACCOUNTING ACTIVITY:$ $ SSN:
2 >~ F$ ` ORGANIZATION CODE:$ 3 > F$ (` EMPLOYING ACTIVITY:$ 4 > F$ ]` ACCOUNTING ACTIVITY:$ r > FF$ ` - F$ 4` F$ J` F$ [` F$ i`$ SSN: F PPORG F PPUIC F PPAAA F PPSSN F PPDEPT F PPFY F PPBSYM F PPSUBH F$ ` - ~^< FFRFQ 333333?/F- - Scanning payroll file, > F$ ` FF$ ` - F$ ` F$ ` F$ $` F$ '` F$ , ` FF$ 8 `k FF$ Q`FF$ J`Dk FF$ h`FF$ _ `Dk 2 F?/F- - Appending data..., F
/ PPD
^ > F % > REG > FF
, >
}
F
^ ] F
y ]
;g0 F?/F- - Reading text..., T
^ F
.DBF T
y F
.TXT T
jDocNr C(28), jACRN C(2), s1 C(1), jJO C(11), jEE1 C(1), jOC2 C(3), jQtyOrd N(5), jQtyRecd N(5), jQtyExp N(5), jDols N(13,2), jPayable N(13,2), jExpend N(13,2), jTotal N(13,2), jRem C(30), jFAID C(6), jOPTID C(2), jDR C(1)T
jDocNr C(28), jACRN C(2), s1 C(1), jJO C(11), jEE1 C(1), jOC2 C(3), jQtyOrd N(5), jQtyRecd N(5), jQtyExp N(5), jCommit N(13,2), jDols N(13,2), jPayable N(13,2), jExpend N(13,2), jTotal N(13,2), jRem C(30), jFAID C(6), jOPTID C(2), jDR C(1) T
F
%F Pb
F B T
F
y %F b
F B +F
e T
F
% FA:
cQ T
!
F <> TF
FA:
< %/ d % OPTAR:
cT T
!
F <>
TF
OPTAR:
< %
Reimbursable:
d_ T
!
F <>TF
* Reimbursable:
< 0 %
d/ T
F <
F F >
. T
F
F
F
`
8 T
F
( - F
F
", '
F
F
%
re, CREATE TABLE (m.lsMidFile) ( &lsField2 )
e, CREATE TABLE (m.lsMidFile) ( &lsFields )
y : > joptidF `F j SUBTOTAL FOR OPTAR F JOPTID F JFAID & F ! F j SUBTOTAL 2 F?/F- - Appending data..., F
/ AAA
^ > FF `F$ > FF `F$ ' >
F
F F
^ ] F
y ] T
AAA_NORM
ai T
^ F
.DBF0 F?/F- - Reading text..., h1
^ C C C C C D D C C( C C N
C C C
' F j JREM F F 2 F?/F- - Appending data..., F
/ AAA
^ ' >
V F
^ ] T
AAA_NORM
o T
^ F
.DBF0 F?/F- - Reading text..., %
&lDh1
^ C C C C C C N
C C N
C N
N
N
N
C C C C C C C D C C N
C C C C C C C C C D D D rnDh1
^ C C C C C C N
C C N
C N
N
N
N
C C C C C C C C D C C N
C C C C C C C C D D D
F - F j DCN_ID F j
TITLE_DESC > F i > FF / /FFF / k2
20F / 19F / 8#2 F?/F- - Appending data..., F
/ AAA
^ ' >
G
F
F F
^ ] T
AAA_NORM
t T
^ F
.DBF T
,jFY C(2),jOPTID C(2),jDocNr C(18),jACRN C(2),jJO C(11), jQtyOrd N(5),jQtyRecd N(5),jQtyExp N(5),jDols N(13,2), jPayable N(13,2),jExpend N(13,2),jTotal N(13,2),jRem C(30)0 F?/F- - Reading text..., T
y F
z F
y
^
x F$ F` . F$ S` . F$ `` .
F$ FY: F$ OPTAR CODE:
FF$ ? % > F$ `F$ FY:- > F$ `F$ OPTAR CODE: F JFY F JOPTID + F$ FY: F$ OPTAR CODE: ~s@ FFRFQ 333333?/F- - Scanning obligations file, > F$ ` F$ ` F$ ` FF$ $`k FF$ .`k FF$ 8`k FF$ I`FF$ = `k FF$ V`FF$ J `k FF$ c`FF$ W `k FF$ p`FF$ d `k F$ r` 2 F?/F- - Appending data..., F
/ AAA
^ , > FF k2
20 198F
F
F ' >
F F
^ ] F
y ] T
AAA_NORM
3z T
^ F
.DBF| T
m ,jDept C(6),jDocNr C(18),jACRN C(2),jJO C(11),jCommit N(13,2), jDols N(13,2),jPayable N(13,2),jExpend N(13,2)0 F?/F- - Reading text..., T
y F
z F
y
^
1 F?/F- - Cleaning text..., [ F$ ` . F$ (` . F$ 4` . SUBCOST CENTER$
, FF$ ? SUBCOST CENTER$
0 > FF$ A` SUBCOST CENTER$ > F$ ^ ` F JDEPT F JJO SUBCOST CENTER$ ~w@ FFRFQ ?/F- - Scanning obligations file, w > F$ ` F$ ` FF$ `k FF$ `k FF$ , `k FF$ 8 `k 2 F?/F- - Appending data..., F
/ AAA
^ 2 F=
ףp=?/F- - Replacing data..., > FF `
2 FzG?/F- - Replacing data..., ' >
S2 FQ ?/F- - Replacing data..., > F `2 F)\(?/F- - Counting ACRNs...,
F , F?/F- - Updating...,
F & %F 2 F OPT z* o OPT ASITES F ( > F Q Q F
^ ] F
y ]
} T
AAA_OCC T
^ F
.DBF T
| ,jFY C(2),jDR C(1),jSubH C(4),jJO C(11),jOC2 C(3),jRem C(30), jCommit N(13,2),jDols N(13,2),jPayable N(13,2),jExpend N(13,2)0 F?/F- - Reading text..., T
y F
z F
y
^
A F$ <` . F$ K` . F$ [` .
~|@ FFRFQ 333333?/F- - Scanning obligations file, > F$ ` F$
` F$ ` F$ ` F$ !` FFF$ 3 ` ,k FFF$ @` ,k FFF$ O` ,k FFF$ c` ,k F * F JOC2 F JDR 2 F?/F- - Appending data..., F
/ AAA
^ > FF `F$ ' >
S
F F
^ ] F
y ]
!j T
^ F
.DBF T
,jOBAN C(6),jFY C(4),jAppn C(4),jMajCmd C(6),jSubH C(4),jOPTID C(2), jOC C(4),jOC2 C(3),jCommit N(13,2),jDols N(13,2),jPayable N(13,2), jExpend N(13,2),jAuth N(13,2)0 F?/F- - Reading text..., T
y F
z F
y
^
^ F ???? F$ ? FFF$ ` @ OPBUD:$ PROC ID:$
! $ TOTAL F$ - - PROC ID:$ $ T
F REIMBF$ j / e8 F$ PROC ID: %
f > FF$ ` FF$ ` FF$ &` FF$ 3` FF$ B` FF$ N` OPBUD:$ > FF$ C` FF$
` FF$ ` FF$ R` FF$ ,` FF$ `` OPBUD:$ F JOBAN F JFY F JAPPN F JMAJCMD F JSUBH F JOPTID OPBUD:$ ~@ FFRFQ 333333?/F- - Scanning obligations file, > F$ ` FF$ `FF$
`Dk FF$ /`FF$ "
`Dk FF$ A`FF$ 4
`Dk FF$ Q`FF$ D
`Dk FF$ f`FF$ Y
`Dk > F ?2 F?/F- - Appending data..., F
/ AAA
^
F
F ' >
M F
^ ] F
y ] T
AAA_FAMR
"D T
F
ez T
F
.TXT T
F
.DBF T
F
%F
F T
F
%F .
F * F?/F- - Part 1...,
T T
F
{ e /8 +F
3 T
F
%
τ T
F
` %F
` APPRO~ T
F
` T
F
` T
F
` T
F
4`# T
. a %FF
` FF
`
FF
`
F
TOTAL
/. T
FF
` Z R D8 F
F
F
F # %F
2 F T
, jDols N( 13, 2 ), jFmt C( 1 ), jFY C( 4 ), jAppn C( 9 ), jSubH C( 4 ), jOBAN C( 6 ), jUIC C( 6 ), jDR C( 1 ), jSAG C( 2 ), jFSF C( 2 ), jEoE C( 4 ), jOC C( 3 ), jAG C( 2 ), jBatch C( 8 ), jAsoD_Dt D F
%F2
ч) F Data appears in wrong formati B
Q ~" T
F
ubJ7 > F$ ` F$ ` F$ `F$ ` F$ ` F$ $` F$ (`
F$ -` F$ 0` FFF$
` , k % -F$
` > g * F333333?/F- - Part 6..., ~ > FF ` Z R D8
2
FFF ?k2 19 208F ? > XX XX F
/ AAA
>
T
e F
] F
] F
]
#< F333333? FastData Import Converting data..., T
FF
Y ` T
FF
Y ` T
^ F
.DBF F Q
TF0 Q
t ދ o
FZ 19 208F F
1
^ ~ o
F
1
^ o
F\
F
1
^ J o! " # $ F\ F\ %&' () * +,-./01234 5 6 7 8 8 F$ 9
1
^ 2t F Unknown file typei B > F
Y % > FF `F$ F ?9 T
F
.DBF %F
AAAe.
B S
^ > %
:"5 F333333? FastData Import Updating..., o
^ ; % B F
/ AAA
(F;5 F FF
; F FF
; 3 F?, F
/ AAA %
:{
^
T
e
^ F
^ ]
$; T
^ F
.DBF+ F333333?/ Converting data..., F Q
TF0 Q
@ X o
< % } B ) T
=F
F
FF < U o
= FZ 19 208F F
1
^ O o
< % B ƒ) T
=F
F
FF < U o
= F
1
^ o
F\
F
1
^ 2 F Unknown file typei B > F
Y > FF `F$ T
F
.DBF %F
AAAe.
B S F ?9
^ 5 F333333? FastData Import Updating..., > o
; T>F % 3 B F Q> %F ?2
a B F ? AAA (F;ŕ) F ; F ; 3
T
eF F? FastData Import Updating Obligations file...,
*
) T
^ F
.DBF2 F?/F- - Appending text..., h1
^ $ C C C@ CA C~ C C B C D} D D CC C C C N
N
CD C C C C C E C C C C CF C C C G CH C I C N
$ 3 $ 4 , F?/F- - Scanning..., ~ %$ 3 T
JF$ ` T
KF$ 6` T
LF$ 7` T
MF$ ;` T
NF$ i` T
OF$ d` T
PF$ P` T
QF$ A` W %
PPJO
OF
R
)
PPSSN F$ `F
R
I . %$ 4[ %
*R >
O
NB
J F$ B`D
K F
KF$
L
MH
PI
Q F$ ` FF$ `kd FF$ `kd FF$ (`d @ > F$ E `
NB
J F$ B`D
K F
KF$
L
MH
PI
Q F$ ` FF$ z `kd FF$ j`kd FF$ (`d > F$ .` F$ ` F$ `@F$ `AF$ `~ F$ ` F$ 0` F$ 1` F$ 2`FF$ 3` F$ 4 `CF$ D` F$ E `GF$ ` FF$ =`kd %FFRJ > FFRFQ 333333??/F- - Scanning..., > F?/F- - Deleting temporary records..., ) $ 4
CE
CB Q1 F333333?/F- - Totaling data...,
^ D F?/F- & - Updating dates and batch numbers..., , >
}
2 F?/F- - Appending data..., F
/ PPD
^ > F ) > REG) > REG( >STFS `FS
, >SUFFS `H FS
F F
^ ]
+ T
F
.TXT T
F
.DBF T
F
z T
F
%F
F T
F
%F
F T
VF
' F
( T
W SORTED BY [OAC/OBAN
V0 T
X SORTED BY [OAC/OBAN,FUND-CD
VY T
YD SORTED BY [OAC/OBAN,FUND-CD,BA/PRJ/B,PEC,RC/CC,ORGANZTN,EMP-ACTY,SSN
V T
Z ACCR ID
VH T
[3 SORTED BY [OAC/OBAN,FUND-CD,BA/PRJ/B,RC/CC,PEC,SSN]
V7 T
\" SORTED BY [OAC/OBAN,RC/CC,PEC,SSN]
V; T
]& SORTED BY [OAC/OBAN,FUND-CD,RC/CC,SSN]
V7 T
^" SORTED BY [OAC/OBAN,PEC,RC/CC,SSN]
V1 F333333?/F- - Scanning text..., +F
< T
F
%F
. . % VERSION
SECTION
L . T
_t %F m.lsLineAf C T
`F
_\ - T
a (CONTINUED FROM PREVIOUS PAGE) %
a
> %
\ . :8 T
F
F
a
`F ?F
a@T F
8? %FF
]` FF
^` FF
_` T
`F
_` x %FF
U` FF
V`
FF
X` " F
q` . FF
~`
TOTALS
4 F
`
F
F
%F
2
p B 9 F ?/F- - Importing report text..., F
, ppOBAN C( 6 ), ppDept C( 7 ), ppFm D, ppTo D, ppEnd D, ppUIC C( 6 ), ppOrg C( 8 ), ppFY C( 4 ), ppSSN C( 9 ), ppName C( 27 ), ppJO C( 11 ), ppCd C( 2 ), ppNOAC C( 3 ), ppHrs N( 13, 2 ), ppDols N( 13, 2 ), ppDR C( 1 ), ppBatch C( 8 ), ppPE C( 11 ), ppBSym C( 8 ), ppBA C( 2 ), ppAgency C( 2 ), ppFC C( 2 ), ppSubH C( 4 ), ppEoE C( 3 ), ppESP C( 2 ), ppRID C( 3 ), ppAuWYsFTE N( 13, 2 ), ppAuDols N( 13, 2 ), wk1 C( 4 ) < Fffffff?/F- - Filling database columns...,
%Wd
`
Y>IF$ `bF$ `cF$ ` F$ `HF$ ` F$ `~ F$ ` F$ &` F$ - `BF$ 7` F$ ^`dF$ `` F$ l` FF$ `d F$
_V` FF$
_X`keFF$
_``k FF$
_l`kfFF$
_v`kgF$
_`EF$
_`
^g>IF$ `HF$ ` F$
` F$
` F$ `BF$ ` FF$ I`d F$ E`~ F$ L`bF$ T`cF$ W` F$ ^`dF$ `` F$ l` F$
_V` FF$
_X`keFF$
_``k FF$
_l`kfFF$
_v`kgF$
_`EF$
_`
[*>IF$ `bF$ `cF$ `HF$ ` F$ ` F$ ` F$ `BF$ (` FF$ `d F$ O`~ F$ V` F$ ^`dF$ `` F$ l` F$
_V` FF$
_X`keFF$
_``k FF$
_l`kfFF$
_v`kgF$
_`EF$
_`
]>IF$ `bF$ ` F$ ` F$ ` F$ `BF$ ` F$ A`~ F$ H`cF$ P`HF$ W` F$ ^`dF$ `` F$ l` FF$ `d F$
_V` FF$
_X`keFF$
_``k FF$
_l`kfFF$
_v`kgF$
_`EF$
_`
X>IF$ `bF$ `cF$ `HF$ ` F$ ` F$ ` F$ `BF$ (` FF$ `d F$ O`~ F$ V` F$ ^`dF$ `` F$ l` F$
_V` FF$
_X`keFF$
_``k FF$
_l`kfFF$
_v`kgF$
_`EF$
_` 2`>IF$ ` F$ `HF$
` F$ `BF$ ` F$ E`~ F$ L`bF$ T`cF$ W` F$ ^`dF$ `` F$ l` FF$
_H`d F$
_V` FF$
_X`keFF$
_``k FF$
_l`kfFF$
_v`kgF$
_`EF$
_` >IF$ `HF$ ` F$ E`BF$ ` F$ ` F$ `~ F$ L`bF$ T`cF$ W` F$ ^`dF$ `` F$ l` FF$ `d F$
_V` FF$
_X`k FF$
_l`keFF$
_``kfFF$
_v`kgF$
_`EF$
_` ( > g -F$
_`
`( > g -F$
_p `( >eeg -F$
_h`( >ffg -F$
_~` >h x TOTALS$ >h y EMP=$ Ti off ~ %h x' Ti on %h yM Ti off %h x
i on ~ >h x
Fh
3" > FF ?F$ F
@ F?/F- " - Updating payroll information..., F PPOBAN F PPUIC F PPDEPT F PPJO F PPORG F PPSSN F PPNAME F PPFY F PPEND F PPFC F PPBA F PPPE F PPAGENCY F PPBSYM . > F ` F `F\4 F?/F- - Finalizing batch..., , >
}
F
/ APPDOUT
> F ? 3 T
jFF
k T
l ACCRUAL.DBF
(
l F
l AACCR > e f }
j
mFH`HFH`nF e
ACCRUAL-AF) > REG Fo) > REG) > REG1 Fffffff?/F- - Totaling data..., %
p Only One Delete for &csImFiltExpr
3 F
] F
]
,v T
^ F
.DBF T
q DELIMITED T
q SDF %F
r T
r T
sT
tF CPRRS Import 0 @ 6, 8 SAY 'Import which Hours/Dollars columns:': @ 7.5, 16 GET m.lnYTD PICTURE '@*RVN Current;Year to date'$ @ 10, 8 SAY 'Import which Sections:'X @ 11.5, 16 GET m.lnSections PICTURE '@*RVN Section 1 (D/R);Section 2-5 (Object Classes)'a %
t Cancel B T
u
r( T
vF
s
2345 182 F?/F- - Importing text..., |h1
^ w CA Cx Cy CT CD C C C C Cz C C C C{ C | C } C ~ C N
N
C D} D D C+ Append From (m.lsInFile) &lsAppendParam
Fw FD #) T
Fwk. T
FDkF
8K T
F
F
FF
8D T
F
F
FF
84 F333333?/F- - Selecting totals..., F ?
v# 109 299 399 499 599 < > FF
u } {8k FF
u ~ |8k2 F ?/F- - Applying Dates..., C >
}
F ` Q1 Fffffff?/F- - Totaling data..., , %
p File
p Only One
^ 2 F?/F- - Appending data..., F
/ ACPRRS
^
-_ T
F
.DBF1 F?/F- - Cleaning text..., T
y F
ez 2 F?/F- - Appending text..., T
y , ppAAA C( 6 ), ppSSN C( 9 ), ppname C( 30 ), ppDept C( 2 ), ppJO C( 5 ), Gross C( 10 ), Other C( 10 ), Sever C( 10 ) T
, TSP C( 9 ), BASIC C( 9 ), CSRS C( 9 ), FERS C( 9 ), SEGURO C( 9 ), MEDICARE C( 9 ), FEHB C( 9 ), FEGLI C( 9 ), SERS C( 9 ), PD1 C( 1 ), PD2 C( 1 ), x2 C( 1 ) T
F
y
>$ F$ 6 > B B F333333?/F- $ - Distriuting header information..., FF$ $ * $F$ jK > F$ F PROGRAM DIRECTOR$ ` PROGRAM DIRECTORF$ j( > FF$ ` FSN:F$ j F ppAAA ? >BF$ `FF$ @8 F -F$ `
' |B *B :B 7 > FF$ ` - F -F$ `0 > FF$ `F -F$ ` T
T
~F
gross other sever& ' TSP0
) BASIC0
( CSRS0
( FERS0
* SEGURO0
, MEDICARE0
( FEHB0
) FEGLI0
( SERS0
F ppDept F ppName F F
/ APPDOUT T
F
.DBF( R+ Gross
ףp=
?( T+ OtherGz?( YP SeverR Q?& UI TSP(\?( UD BASIC?' UB CSRS=
ףp=?' UC FERS333333?) UJ SEGURO)\(?+ UF MEDICARE Q ?' UH FEHB(\?( UG FEGLI Q?' UU SERSGz? >nF e > F / > FF} \m F
] F
y ] F
]
. T
^ F
.DBFT
,ppUIC C(6) ,ppDept C(6) ,ppSSN C(9) ,ppHrs N(13,2) ,ppDols N(13,2) ,OT N(13,2) ,OTHER N(13,2) ,TOTAL N(13,2) ,ACCEL N(13,2)
,ppCd C(2) ,ppJO C(11)
,ppOC C(9) ,ppCAN C(4) ,ppFmt C(1)
,ppDR C(1)
,pp04 C(2)
,pp03 C(3) ,ppRWO C(3) ,ppRSC C(1) ,ppFm D ,ppTo D
,ppBatch C(8) ,ppNOAC C(3)
,ppFY C(4)
,ppFC C(2) F?/F- , T
y F
z F
y
^
6 TOTAL$ F .$
AAC:$
F333333?/F- , # > F$
`$ FOR# > F$ `$ FOR F PPUIC F PPDEPT = $ FOR
$ BADGE $ ----
$ F > F$ ` F PPSSN F?/F- , >F$ `bFF$ ` FF$ ` F$ `F$ ` F$ !`F$ '`F$ +` FF$ 0 `k FF$ = `kFF$ K `kFF$ Y `kFF$ g `kFF$ u `k T
FF
\m^_ > 1FF D R8}
F333333?/F- , F?9 T
F
.DBF F?9 T
F
.DBF F?9 T
F
.DBF F?9 T
F
.DBFD (
* (
(
(
F
AREG ' > R+ REG F
AOT ' > O+ OT$ F
AOTHER ) > T+ F? F
AACCEL ) > X+ F?2 F?/F- - Appending data..., F
/ PPD
) > REG) > REG F
^ ] F
] F
] F
] F
]
/ T
^ F
.DBFT
,ppFC C(6) ,RECAP C(4)
,ppPE C(6) ,ppOBAN C(4)
,ppBA C(2)
,ppName C(16) ,ppEoE C(3) ,ppDCPSJO C(16) ,AmtGS N(13,0) ,AmtWG N(13,0) ,AmtGM N(13,0) ,AmtSES N(13,0) ,AmtND N(13,0) ,AmtNI N(13,0) ,AmtNC N(13,0) ,AmtOTH N(13,0) ,AmtTOT N(13,0) ,ppAUDols N(13,0) ,ppPaySys C(2) ,ppAAA C(6)
,ppFY C(4)
,ppBatch C(8) ,ppRWO C(1) F
^
#) %$ BVB T
$ T
File = F
T T
? \n\nThis is not a standard Air Force monthly 1092 payroll file.- T
\nIt cannot be imported. T
\n\nf F
S //TITLE Payroll Audit //ALIGN LEFT //FUNCTION "\!\IF$ `F$ 3`$ OAC# >bF$ $`$ OAC# > F$ `$ OAC- >BFFF$ D `k $ RCS F PPName >B 1FB# >cF$ `$ OAC3 >HF$ `$ OAC
F$ D ***
T
/ ~q
m F$ D ***** RECAP > x
T
e! F$ D MAN YEAR COSTSG > x
T
/ 2m >F
x 8 x $ RCS F ppOBAN F PPFC F PPAAA F ppBA F ppPE b !! $ OAC F$ D TOTAL EMPLOYEES F$ D MAN YEAR F$ D
BASIC AVG SAL& F$ D OVERALL AVERAGE SALARY# - SUMMARY OF PROCESSING$ $ ~1' > F$
`EF$ ` TF$ " `- >FF ,kF - 8 TF$ . `- >FF ,kF - 8 TF$ : `- >FF ,kF - 8 TF$ E
`- >FF ,kF - 8 TF$ O `- >FF ,kF - 8 TF$ Z `- >FF ,kF - 8 TF$ e `- >FF ,kF - 8 TF$ n `- >FF ,kF - 8 TF$ y `- >FF ,kF - 8 F F?9 T
F
.DBF F?9 T
F
.DBF F?9 T
F
.DBF F?9 T
F
.DBF F?9 T
F
.DBF F?9 T
F
.DBF F?9 T
F
.DBF F?9 T
F
.DBF (
(
(
(
(
(
(
(
F
AGS >f GS F
AWG >f WG F
AGM >f GM F
ASES >f SES F
AND >f ND F
ANI >f NI F
ANC >f NC F
AOTH >f OTH F
/ PPDe. S
>B 1FB >B PageFFBe T
V REG HRS PART/INT REG HRS PERM REG HRS TEMP REG PAY PART/INT REG PAY PERM REG PAY TEMP ) T
OVERTIME HRS OVERTIME PAY T
DEBT-CY DEBY-PY ENVIRONMENTL HRS ENVIRONMENTL PAY HOLIDAY HRS HOLIDAY PAY IDEA AWARD INCENTIVE AWARD LUMP SUM LV PAY SEVERANCE PAY SUNDAY PREM HRS SUNDAY PREM PAY TRAUMATIC INJURY NIGHT DIFF HRS NIGHT DIFF PAY OTHR CASH AWARDS T
ALL OTHER BEN ANNUAL PREM PAY CIVIL SVC RETIRE FED HEALTH BEN FEGLI FEHB PREMIUM FERS MEDICARE-CSR OASDI REM WORKSITE ALW RETENTION ALW THRIFT SAV PLAN TRANSFER ALLOW UNIFORM ALLOW VOL SEP INC PAY VSIP 9 PERCENT NONFOREIGN ALLOW ~N > G}
F
k FF
\m^
" > F HRS f8" > F HRS f 8
>f
F > R+ F ( > O+ F MEDICARE-CSRV > UF F FEGLI} > UG# F CIVIL SVC RETIRE > UB! F FED HEALTH BEN > UG F FERS > UC F OASDI, > UG" F THRIFT SAV PLAN] > UD F
RETENTION ALW > Y4# F NONFOREIGN ALLOW > YC= F VOL SEP INC PAY F VSIP 9 PERCENT
> YC" F ANNUAL PREM PAY; > YT# F REM WORKSITE ALWm > YN F > B+ F > T+ 2 > ? % R+
>
> >nF e F
^ ] F
] F
] F
] F
] F
] F
] F
] F
] 2% F This case is not defined B UI IMPORTIDLNIMPORTIDLBMODERN DGUESS ST LSINFILE *LNINHANDLEFERRMSG LSLINE1 . LASTRU DLELNTXTCOLUMLATABLE LSCOLUMNI STOKEN LNROW 1 ALLSTR I LSALLFIELDLNNEXTCOL LSMIDFILE2ZTMPNAME DGSTMPDIR ENAME LE 2EDCPDSDT LDDATADATEALL LTDESCESALARY EADJSALARYFOR SALARYMNIMSERVICEJO TPUTDEAPC OMPTTYEUIC FILESID_CODE 1 EPE DATEFIAMS DFILE EPOSN2 ILEPARAGRAPH LINE M LE EORG ERVICORG_CODE EUIC2 WUPDAPAS_JEE ICECAC ERVICEFEHB E EFEHBENRL ZTHERMO WFREPORTTIMEFILE_NE2 LSOUTFILE EE UTFILE ESSN FILE2EFOREIGN RAMID2 ILE2ONESSN LNEID ILE2EPESFX VICEDEPT ILE E01 SERVICELINEUTEM E_ID CESS PAD_ID
!ENOAC T S EHIRE S EDR G ! EQTY R E ETABLE LEOPMTABLE EPLAN _DT EGRADE ESTEP ! ETABLE2 tELAA ANS ESTATE ATESTATE E_DTEGEOLOC TEEAREA DT PAYAREA !EPAYSYS D PAYSYS GRDEAPPT DES EAPPT2 S ESERIES EWKHRS ! EFIRE T LNFYHOURS ERATE CHEDEFM HOURS ETO TADATEEWGI_DT EREM DT HZSTEM ELEAVEDT 2ENFCOLA RSERIES HSERASE LSMIDFILE EERROR LE2LSOTHERMESASKFOR LE FILECHK CNSTARTTIMCTOD3 DATEDATA_DT LSEXTRAS 2MAIMDIN IDINSTRU ZALERT U MBIMAMS DFASCAC ICEFEGLI LAFEGLILENFEGLI1 LENEPREMIUM 2ELINEITEM MBIMVAC EPTITLE S ECPCN ERETCODE ETSP E2 tEBATCH CDIMVAC GS_HIST S LSCLEANTEXCLEANTEXT LBCAVIEWIMS6 IDFILE PPTO TYPE PPORG T ! PPEMPTYPE PPSSN PPCD PPDEPT PPJO OR PPPLAN PPSC PPOS S1 GENCY PPHRS TIDPPDOLS IO S4 ORTFILEPPDCPSJO tPPUIC WIPPREM pecZRIGHT TEXFILL_DN STLSMID2FILEPPBATCH CSBATCH STPPFM CH MEPPEND ne.PPNOAC FFDCPS2REQ PPFY TFILEJOFY THFILPPHRSNONWYOPEN1 TIMELBNEWFRINGCDSOURCE LBNEWLABORPPGDIND E LB1STLFIELS2 O ABORS3 D Y PPPAYSYS PPRATE LB1STMFIELS21 YSYS PPLINE S CSIMFILTFIPAYDETAIL CPRRS O ELSFIELDS TXT2DBF PPAAA DS PPBSYM INGPPSUBH NE PPWKSCH E PPGEOLOC LSFIELD2 XLNOUTHANDLLSLINE DLEZBETW DLEZLEFT FFLNCOMOBLCOJDOCNR TEXFILL_UP ILJFY DFILE JJO FILE JBATCH E EJASOD_DT LDASOFDATEJFMT DR2 ACRNFILL LSIMOPENVIF1 IDFILE F2 JOPTID JFYMO SAG JDATE2 T JREM R QTRF10 ND_QTRF11 RD_QTRJDOLS OUNTJLOCAL TCHJFAID ILE JSITEID ERJTYPECD C JACRN PT HJEE1 E E RJEXPEND E JFCNT_EXP JFCNT_REC JOCSUB R3 JQTYEXP E JQTYORD NTJQTYRECD JPAYABLE F16 OPT CHF17 OPTOUTF18 OFDATEF20 71COL JDOCDATEC JFDLOCALCDF24 PPCD JSTATUSCD JCONTNR IMJCONTAMT AJCONTFIN JOPTNAME JOC2 OFDATF19 OPTOUTJRESPCEN JDR ID ENF36 NR T TF37 ILE2 DJDOCDATE HFDACTUAL EJTOTAL EJDEPT TIMEJCOMMIT MEPREFS AL EPF_OPT CD DISTINCT AFY INCT AOPTID R3 AKEY TYPE ASITEID NTOPT IX H ASITES AAA _ID CHJSUBH TIMELBDIRECT JOBAN CT JAPPN D JMAJCMD SJOC RTTIMEJAUTH HOICLSCLEANTXTLSMID1TXT LSMID1DBF LNMID1HANDLSPARENT ELB2171CAVIJUIC E AVILAMID1SIZELSFILLFIELLNDOLSTARTCASEOF E HLN2171COL JSAG IR JFSF ACC JEOE ION HLBSHOWNEWFLSOBAN IDLSRESPCEN LNFDDFIELDLMSBSYM LDM SBSYM D JBSYM M NTLMDASOFDATAU_OBLIG AU_BUDLINEJBUDLINE AU_FY ID ELMSRESPCENLMSOBAN DOBLIGATE TAUTHORIZ FY_ID NE COPTAR_ID MBCN D_DT TFA_ID IELDRC_ID APPROP_CD SUB_HEAD SSUFFIX R SJSUFFIX OTSITE_ID IDAUTH_ID SJON_ID E AJON_DESC IREIMB_ID XA1 MDETAILLABOR_CD DA3 IM30 CCLOSE_DATEA4 STMFIELCAC R IR JCAN AR IDC_UIC ED SAG FAS TFUNCTION EXP_ELE IDOBJ_CLASS OBLIGATED LOCAL_CD MNIMOPTOUTLADELETE LAFY1 LE DLSFLOPPYBAATEMP TE EPF_AAA MPPAGENCY PPMAJCMD PPNAME PPENVOT SPPYR S SPPEOE R SPPTEMPPOS PPCIVTYPE PPPE PE NSPPOBAN TVALS3NAME MELS3YEAR EXLS3BS AILLS3SUBH PDLS3PD H CLS3JO IELLS3PE N ELLS3OBAN CSIMFILTVAPPD AC NWYPPST LE PPSTATE LSHEADER LBOBANSEQ LBOBANFUNDLBOBANETC LBNEWFORMALBOBANKIRTLBOBANSCOTLBOBANHICKLBOBANGUNTLNPART1 LELSLINEA LSPHRASE PPFC N TC PPBA 4MDEPPPESP MS PPAUWYSFTEPPAUDOLS PPRID 1 IDWK1 RT1 ETOGGLE ME LDACCREOM BOM TALIASLSACCRFILEPPPESFX PPACCT RKIAPPDOUT WYCSIMDETAILLSAPPENDPALNYTD NDPALNSECTIONSLSCHOICE LBYTD CE LSKILLSECTPPMO FILE F3 AJCMD MF4 ORTTIMEPPREG ASCURHRS DE CURDOLS iYTDHRS ICYTDDOLS END D H FOLNMONTH bLNYEAR CVDATE FPP AR ES CDPPFM S BOPP R LSMID1FILELSFILLF1 ELSFILLF2 PD1 LFIELPD2 G1 ls LNCOLWIDE LNSTARTPOSAVKFIELD OLSMID2 LE AVK_APPENDPP03 TTIMEPPOC expoPPCAN S IDPP04 TIDPPRWO ADE PPRSC ADE OT E S OTHER LE DTOTAL TTIMACCEL TIMELSFY E ASPPFMT CE PPDR TAT iLSMIDREG ELSMIDOT LSMIDOTHERLSMIDACCELLCMSG DS ZMSGBOX OPENSYS S LBMARK S RECAP XXX JO EAMTGS F1 EAMTWG F2 AMTGM FIELAMTSES ls AMTND IDE AMTNI TPOSAMTNC LD OAMTOTH LE AMTTOT ENDLSMIDGS ELSMIDWG oLSMIDGM DLSMIDSES DLSMIDND LSMIDNI LSMIDNC LSMIDOTH DLSREG1 H LSOT1 TIMELSOTHER ASLSBEN1 E DBMSG TH
Input File K T
FFF
F
8 Select input file Select %F
T
Dates
" F
m.ldPPFrom m.ldPPTo U CSBUTTON1 LSNEWFILE GETFILE2 DLSPROMPTTYZEXT ILE *LSINFILE EN_DATES 1 4 I T
FFF
F
8 Select filename Select %F
x T
U PSOLDFILE LSNEWFILE GETFILE2 DLSPROMPTTYZEXT ILE *Z 4 $ T
F
Select folder3 %F
S T
U PSOLDPATH LSNEWPATH 4 T
PeB T
PeB F X h1 mid1 C C C C C appe from &sourcefile sdf
Q # Importing
d U SOURCEFILEOUTFILE H _REFOX_ H MID1 X_ TYF1 T ILE *F2 EWFILE F3 ATES 1 F4 INE1 . F5 TRU DLEGAUGE OLUMAF8_SQL ` 4 oF\ F\ F ` F ` F 9` F <` F ?` F E`
F ` FF \` /F ^` /F Z`# F |`
F ` F\ mid1e1 temp1 F E_ID > %F EE U S
temp1 #) ~MK > ( USD REG
P ZERO %F
I 0000 > RUS 01352 > AC-0135R 2I > GS 3 B U INFILE ILEOUTFILE H E_ID X_ H H_ID X_ TYF1 T ILE *ESSN FILE ENAME S 1 EPLAN 1 . EGRADE DLEESTEP OLUMESERIES ETABLE2 LEEWGI_DT EAPPT 1 ESKED I E07 LFIELDMID1 TCOL TEMP1 ILE2SERIES E DALL PDIR FILE_NE2 2EWKHRS EHIRE DATEENOAC DESCG_ID Y EQTY ALARYETABLE RY8 4
REGX , T bp_h AS pphrs, bp_p AS ppdols OT , T ot_h AS pphrs, ot_p AS ppdols LSL , T lsl_h AS pphrs, lsl_p AS ppdols 110 T # oth_h AS pphrs, oth_p+pcs AS ppdols 13[. T ! oc13_h AS pphrs, oc13_p AS ppdols AWD T award AS ppdols 12/ T " oth_oc12+fringe+uniform AS ppdols ` SELECT psCode AS ppcd, &item, pd AS ppto, p AS ppjo FROM (psSourceFile) into table temp0
B U PSCODE ILEPSSOURCEFIITEM E H 4 5 T
F
.TMP T
( %F
~
T
F
T
? T
T
- T
F
%F
F T
F
%F 0
F +F
T
FF
3 T
FF
?
F
` F
F
F
B
U
PSINFILE EPBCHECKFIRLSOUTFILE LSSTRIP TYLNINHANDLELNOUTHANDLZTMPNAME GSTMPDIR I STRIP LELNFIRSTPARLSSTRIPSTAFERRMSG ELSLINE DLE ] T
F/ 7 Text File|Text File without page breaks|Printer|Preview %F
r B F % >
=
T
/ F # 61.0
T
e U CSOUTPUT EPOPMENU IRREPORTS ALL RTS TYRI_LONUMB PREFS ANDLPF_CURFY LNFYRADIO FOR RIP LERI_REC PARGBRPTSETUPBBREPORT E 4 5 T 000
/ HQ T 221 F YC YNz T 222 YT T 223- ZG
ZH
ND T 224 F E1 FZ T 225 S% T 226 Y8 YA YV YXQ T 232 UAt T 233 YW T 234 18
4 R T 201 O T 202 P T 203 24 T 201 2
W Ry T 205 O T 206 P T 207 2 T 205 3z
v R T 209 O< T 210 P^ T 211 2v T 209 4
R T 213 O T 214 P T 215 2 T 213 5
: R\ T 217 O~ T 218 P T 219 2 T 217 2 T 001 B U PSSC PUT EPSCD NU IRRETNVAL 4 T FF \` T FF k % FF \`i
B ~
B U PSFY PUT EPSDATE IRLSFYDECADELSPYDECADEALLSTR MB 4 % tBA
K ) BF 6789 199 2008 | ) BF 6789 200 2018 U PSFY PUT EPSDATE IR 4 5 " T
F
%F
M B %F
AUPDATE
t B >
F F
EE Feee
F
3 F
Q
U PSMASTER EPSNEWDCPDSPDDEFAULT I PYDECADELSUPDATEFIENEWREG DEGSCOMPFIELOPEN1 TEFIALL DATEFIEFM EC PARFOR FAULT EFOLDER ELSINFILE PEE UTFILE HSERASE I " G
F B( U OPENSYS EZTHERMO DSBBMENUM T 4 5 T
F
.DBF T
F
APAY
_
Only One %F
f U S Delete for &csImFiltExpr
B
File T
''
DCPS Emp Act T
PPUIC
DCPS ORGJ T
PPORG
JO/APCv T
PPJO 2 B 3 % DCPS Type Hour
F PPCDf U T
+PPCD T
F
+ , %
''
(
F* Sort on &lsSortExpr to (m.lsMidDetail)
F
ASORTED Q ( Total on &lsTotExpr to (m.psPayData)
F
F
APAY U PSPAYDATA LSMIDDETAIZTMPNAME IGSTMPDIR ELSTOTEXPR OPEN1 G DECSIMDETAILCSIMFILTFILSSORTEXPRAPAY DETAIHSERASE T l 4 5 %F
(F0i %FF jFF
1e ! T
T
T T F0
( a #6 T FF
1 +F
] %FFF
14 T F
1 REPLACE &temp WITH fill_val
O T FF
1
H B U PSUP_FLD FILL_VAL IFLDNR1 E IFLDNR2 R EI TOTEXPR TEMP G DE 4
$ b2 00 F
00 F k T
HOURLYO GS
GG
IP 0000
0491
02
AT T
ATL 05
BO + T
BOS 08
CH ] T
CHI 11
CI T
CIN 14
CL T
CLE 15
CO T
COL 17
DA % T
DFW 20
DG W T
DAY 23
DN T
DEN 26
DT T
DET 28
HA T
HAR 29
HO T
HOU 32
HU Q T
HNT 35
IN T
IND 38
KC T
KC 41
LA T
LA 42
ML T
MIL 43
MM I T
MSP 45
MI { T
MFL 47
NY T
NY 51
OR T
ORL 55
PI T
PIT 56
PH B T
PHL 57
PO t T
POR 58
RI T
RCH 59
SA T
SAC 62
SL
T
STL 71
SD ; T
SD 74
SJ l T
SF 77
ST T
SEA 80
WA T
DCB 88
ZX T
RUS 98
ZY 4 T
RUS 99
ZZ e T
GS 2 T
RUS 0 GS
GG 0000 T
F W X E %
W & T
AC-0F
` R A T
AC-
R 2b T
HOURLY ; %
GS
0491 F
j HOURLY T
F
(LEO) B
U PSPLAN D PSGRADE IPSSTEP E IPSTABLE2 EPSLAA XPR LSRETURN E 4 4 Replace &psField with subs(line,pnCol,pnColWide)
if '-' $ &psField C Replace &psField with '-'+alltrim(subs(&psField,1,pnColWide-1))
B U PSFIELD PNCOL E IPNCOLWIDE k 4 C F
/F - Distributing AVK column :
... SELECT psCode as ppCD, Val( &psField ) as ppDols, ppSSN, ppAAA, ppJO, ppName, ppDept, m.csBatch as ppBatch, m.cdSource - 13 as ppFm, m.cdSource as ppTo, m.cdSource as ppEnd WHERE Val( &psField ) != 0 FROM (m.lsMid1File) INTO TABLE (m.lsMid2)
F
U PSCODE PSFIELD IPNSTATUS ZTHERMO EREPORTTIMEAPPDOUT ELSMID2 L T
#
FF$m(FF$mS ! T
|F
T
|0
B T
F/ F
`F Fiscal Year B U LSYEARMENUIYEAR D IALLSTR ENULMAPCFY NUPOPMENU MEi $ T 0|1|2|3|4|5|6|7|8|9|10|= T
F/ MDEP Local Field U LSOPTS ENULMAPCMDEP POPMENU NUh $ T 0|1|2|3|4|5|6|7|8|9|10|< T
F/ AMS Local Field U LSOPTS ENULMAPCAMS POPMENU NUBIGCASE MNHg VBUTTON1 MN!` VFILE COLUMRa VPATH COLUb IMP_AF8 BANyb AF8_SQL BAc BUDPAYSQL BOg CLEANTEXT i PREVIEWEXP l XCPRRS fWm JOFY ILL ]r XJOFY ODS s UPDATEEMP s IMPSTOP PER.u PAYDETAIL Rru FILL_UP DENx OPMTABLE DNQz AVKFIELD ODa AVK_APPEND - VYEAR2 ZALE VMDEP PROԆ VAMS f CD_ 0
52!!!#!A cauq 311A Z q sB r VA A B B 3 !a'A A CA A c q q B B @1B y t A s D A Q q s rBs A SvB B v q cr B B 3 c q!!qRA!!0 QA A B |A pQO cDC&F 21r C 6X I
A A 3A A 1A A CA A RAA A A 311Syns gagq S QA S qA S A q A A B s qq
R3 A ST Sq Rq Rq 31111s $F 5 aA A B s qA a A A A `1 A A 7y ! QA A A gA A A DA A B #\A A Q4A A A A A A 1A A A 3Q q A 3 a A A A a3@ a A A A a A a A A 6 ! A A 3A A A Qt 1q1 A A A 4 AA aA 21111!1A A A !!A A A B B 2q A 3q C A A A 3ca3f5_A A B C 2 A a 2!A A A r 31s S qBA A C q2A "AB !A A A 12A A A A B Q37AA A A A gQ r6bqA A A 1d
A A A B L
B A B hq A JA A A B B 75T
A A A B B B A B A TQB F :A A rB A A A A B y t m A A B A3B B 11a Qq ! Rq ! B 1A A 1 Q A AA A A ; v S a ! 7 A rqA A RQ "A A AA RQRA A 5! S A CAQ 1$22'2 2C cC A A A A g A S Au Q 3E 3 A AQ'%3s'3 A A (^( A ba q Q BQ1b q A A C S J31A aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaacaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaB 2 cA A A A B (! R3C 3 cA A & 2 3B A QA )B 122c22B A B A A A A AQ R 3sA 4 A 3A A A M B CQ'$#3s*< A Wc q Q Rb q A ba q Q BQ1b q A A C C r33A D 7q A #! !! CaA C3a 211q$3 !A 1 A A A ! 1 AA 1 1A B !A s 3 A A A B 32A B aA B B
dfw8'a 2116Daw #1A&#!!!111s
E #a 3S3133 A A 3 A A 3rgA BA A A A A 3B B 6 A 1"c#a v 31q4qs#a u3q2A$ pA$A #a v 3q3 aS1 B #a u31q3aa& yD #a ""t#a# gs B 513da ] B )a y 313C acA A #!A!1C B 3#a u31q4x3 A 3 A 22 aA 2A A B A 1 B C A $L A O b 2113s A @ Ppp A A SA 4A A A 5RA A gSA A A Sa6q A 23s A A B m
A B ]@ A A TA A A 3 R A A 3A aF A sB b#@! #qqqqqqqqA tA A $1 aB qA SA B A B$a 3B3 ? A 4 A { qs53A A B A 1A Q A !B B B B B (A A A A A A A G !K ! A "A A A A %1!1!!1!Q1C 3 A at A A 214! EA A A a#SQ CCQ1#5A A # 3q" rc$ !qs rA 21 aqqqqCC3114@qac11!1c!1111Bqqqqqaq#a 211113S A AAaq A A a!A111q31 A A 2!a2Q sSRRRRRRRRA 71121111sqqqqqqqcaaqbaaqvA s[! A #! 1 1 1 q ! 1 ! 1 2 1 A 3 A 3B 611111111 Rq A C 5 "Q A "Q A 3 r "Q A 3 r B"Q A 3 gax F 8 PQ vA S A A QQQ A B A B A 5 A1A11A1B @A 3 4 A A c 3 A 3 A 32!A 3 A A q RR 1 3 s !2"22" !!! A " !!! A " !!! A " !!! A " !!! A A 1 q A 4 s A 3 s #A A A A S3r A 3 3 f q 3 w t s aA A A rAA1 A B 8A X A 3s4 s wA A A A Q 1 R 1A A A A 7 @q 'R !!!!!!!!!!!!!!!!!!!!!!!!!!!# !A Ca A SD A 8 D1A A 3 2.r 3 1A q"R A 3 CQ 5 CQ 1 = C M W
%
0
k
K( }
,
.
2
4
> =
WC n L ^Y S ([ $ Y ^ > b ` M f 4a W
M+ / + %16 4 s 5
%F 2
R,
Missing file B
j F COMMPRA F SRTB F SPEC_ F D0 F E0 8 T GS_SPEC F WFAa T SCH 2$ R, Unknown file type --> B T
F
.DBFb T
U , li_cat C(6), li_len N(3), source C(20), first10 C(10), c1 N(3), c15 N(3) F
! Q Q ># F\ F / T " empty(line) or allt(line)==chr(12) delete for &cond
GS_REG) ># FFR^ TABLEF% <` GS_SPECq F%
TABLE NUMBER: F% EFFECTIVE DATE:1 ># FFR^
TABLE NUMBER:F% <` SCHT ># FFR^ WAGE FIXING AUTHORITY% DOD CIVILIAN PERSONNELF% j & li_cat* o# F# # # F
(F F -# F
%F6 T FR T
T
FF$+ Fb F?9 T
' F
.DBF' (' % + # F
# $ (( % + # F
% ^$ R, problem: no array created ! T
FF( I T
T
F) T
F* ' J (
+
,
-
. % SCHN T
+ F ISSUE/ T
, F SUPER/ T
- F ORDER/ T
. F BEGIN/ o R,: Importing table F
effective F
+ from F
F\FF0 <
^ min T
T
T
T
T
T
T
T
T
1 T
F
2 T
FF
3 k T
FF
3 k T
F4 % GS_SPEC T
F
6 5 T
T
T
T
F7 >
>
3 >+
+ ,
, -
- .
. >
>
>
>
>
>
>8
>9
>
>
>:
>
>
; ' F ' < <( F Q F < # R,:FF0 <
^ min B U= PSTXT1 ADD_STEPS APPEND_ID COND DIFF_TBL EFFECT_DT EQUAL_INT GRADE_LISTGRDS I LEADER1 MAT_MEMO MID1 PPD_FLDS PT_1STGRD PT_FMT PT_GRADES PT_ID PT_LASTGRDPT_LINES PT_LIST PT_PLANS PT_STEPS RAISE RAREA REAL SOURCE TEMP THIS_REC ZFNAME FILE_FMT ZTMPNAME GSTMPDIR TXT2DBF ALL LDS LI_CAT FOR AT T LINE FILL_DN TEMP_TXT ARR_PT C GETPTID GETEFFDT ISSUE_DATESUPERSE_DTORDER_DATEBEGIN_DT FWS_DATE EST_TIME T MATRIX1 TWORDS WORDNUM D LEADER STPATTERN MISS_CHAR PAY_CHGS MATRIX S DGR_LIST EQ_INT ES IMAGE NT HSERASE ` 5
T (
P
N L GS_REG6 T
1 T SALARY TABLE NO. T TABLE NO. % FF j2 T F F F @! T
FFF ` %
. T
hr # GS_SPEC F
T
2 T
TABLE NUMBER: % FF j/ T
FFFF j TABLENUMBER: %F
@ T
E
SCHL# T DOD CIVILIAN PERSONNEL" T WAGE FIXING AUTHORITY0 % FF j FF j H! T
FFF ` %F
` T
AC-0F
` %F
@ T
F
U + T
B T F
0 B U II3 T1 PT_ID1 PS PX END_ID PX_END PY F_TBL TEMP T_DT PT_LINES FILE_FMT TPT_FMT ARR_PT PT_ID T C T
% SCH (1 T F P 8) T FF k' T
F 8 1 %
T
F
T
$ T
F
1234567890 B
U LEADER_CHAFILE_FMT II4 ND_ID MXX_COLS PT_FMT L VALX T_DT WORDNUM MAT_MEMO TEQ_CHAR HAUNEQ_CHAR GRDS T PT_LASTGRDPT_1STGRD FULL_LIST MISSING D GRADE_LISTMISS_CHAR Q
4
5 %FE
T
T " (F
A T F
T T F
%F kF k=
T # F k(F k( T FF ^D T B U
NUM_LIST AMARK FMT II4 ND_ID II5 COLS MISSING1 NEW_LIST WORD1 M WORD2 MO TWORDS ST AWORDNUM 4 5
T
(F @ %F
` T " T F
F `_ B U PATTERN_STVALUE_STR PAT_MARKERI2 COLS I SSING1 ( " T F SCH 8 (
F o GS_
T
T
T T SCH 2
T % P
T
T
T .
T
T
T SCH
T % P
T
T
T
T
T
T SCH c T % P0
T
T
T
_
T
T
T 2o R
P T
RNFL T
2 T
( T
(
%F
J , %FF
K) %FF
P { . , % SCH
T FF
=`
T
T T F P 8 )" T FF
$,GS-
T ( " %
D
E T F F T F T F k! T FF ^ + T F F
T ! (F # T F F F G T $ % GS_SPEC F
T FF k F - GS ( 4 T F GS
GSF ^F ^ PUB %F e T F ! ! %
" T ~ F# T
T
$
$ T
% F ' T
&
& F 8 % T< T
'
' F F ( ) 8 ; T
*
* F ^F ^ F
% SCHG % ! T+ F `F ^
T+ , (F + - C T. FF + , k T
/
/ FF. J % SCH T0 RATE %0 FF
j
T
1 FF
T
1 F
1 T
1 FF
1 j RATES T
1 FF
1 j PAY T
1 F
1 ` T0
WAGE AREA OF %0 FF
jz 4 T
2 FF
F0 FF
j F0 @(` ' T0 US ARMY ENGINEER DISTRICT & %0 FF
j F
2 4 T
2 FF
F0 FF
j F0 @(` 2 T0 % U.S. CIVIL SERVICE WAGE EMPLOYEES ON & %0 FF
j F
2
4 T
2 FF
F0 FF
j F0 @(` & T0 US ARMY ENGINEER DIVISION& %0 FF
j F
2 2 T
2 FF
F0 F
F0 @(` B U3 NR_SECTIONFILE_FMT SECTION EROFFSET NST_COL 1 END_COL STHI_GRADE PT_FMT E TNR_CUTOFF GRADE_COUNII2 LIST PT_LINES DNUMBERS D ARR_PT ST LETTERS NLINEX COUNTHIS_GLINESTEPVAL HAIX COL RDPT_ID L WORDX T STOKEN S WORDNUM PT_LEN NEPT_DEC AVG_INT MAX_DIFF EFFECT_DT THIS_GRADETT EX M PAY_AMT GETRATE ADD_STEPS SPCRYPT S I L LDS MID1 TEPS PT_GRADES PT_STEPS EQUAL_INT GRADE_LISTEQ_CHAR TUNEQ_CHAR MAT_MEMO ADD_STRINGII7 _GLINEWORDS DATENUMBER1 NGREAL TRINGPX E_FMT PT_PLANS TRAREA S P 4 5 %F (F0a %F jF 1] !
T
T
T T F0
G(( 0 ( E #) T FF 1 ~A %FFF 1$ T F 1 REPLACE &temp WITH fill_val
= T FF 1 B U DOWN_FLD NFILL_VAL FLDNR1 ERFLDNR2 NI _COL 1 TEMP OL ST} 4 T
) ISSUEW T ISSUE DATE: SUPER T ULE ISSUED ORDER T ORDER DATE: BEGIN T ON OR AFTER (
k % FF jg4 T
FF F FF j F @` T
F
! B
U FWS_TYPE NDATE2 AL PX _TYPE RII3 TYPE NPT_LINES ARR_PT STWORD2 AL CTOD2 E TP 4 5 %F= T ., T
T
F
T
F
+F
T
F
+
" F
T
F
e. T
F
F
` 2 T F
. T
F
F
`
+ %F
% T
F
F
` ' T
T
F
B
U STRG YPE NW_NUM AL BKSTRG E RRET_STR NS1 LINES STRT_POS T 4 5
# ^ F < B F^ T
., ! T
F
FF
@\ T
F
+F
T
F
BF
U S1 G YPE NBK_STRG 5 T
%F,F
H T
g GS_REG~ GS_SPEC ! T FFF
`k" T
FF 1/1/F ^# SCH (
T EFFECTIVE DATE: % FF j4 T
FF F FF j F @` T
F
! %F
$ T
FF 1/1/FFF$\m^# B
U EFFECTDT1 EFF_WD II3 TRG RPX _STR NTEMP NES THIS_SOURCMID1 SOURCSOURCE E TFILE_FMT LNTABLEYEAZSTEM ST PSTXT1 S DFPP CTDT1 PT_LINES AARR_PT NCTOD2 DT1 GETPTID MRX LEADER * MISSING RD PATTERN MATRIX1 MR FILL_DN ! FWS_DATE RDh# WORDNUM 9% WORDS MR' GETEFFDT ( r 1A A A AA A 'eF A qBCC 5v u !6v FAA A |BA u sA u Q 4 q B A v A 3A : qa1qA A 4QaA D B3!A Ra A B B A 3 ArqA A BA 4 A !a 1A A A 3 !A A 4 )q ! A ! A ! A B A ! Q A cB A A !A Rs# A A 1A Dsu uFXqC A 2!A B r B TQQqA E A A A C BqaA BA uaBB $aBB ca!A A B A A 5 r saQA A A A rQ 2 A A A A 5 r Q aaaaA BbA A A 5 A 1A 1 ! A 1Q A A 2 4 !A 1A b3 Q A q!DDaA B A AA B 3 v 8( < G1 5 7 : i e 7i * &m L .r { t M T K2[ 4 T
FF jk T
F
is an invalid filename.F
/ Valid names are like SPEC_yy, D0nn_yy, E0nn_yy. %FF
@
R,
B/ M %F
` E0 F
` D0 F
` SPEC R,
B/ %F
` _-
O R,
B/ . %FF
` FF
`
R,
B/ T
FFF `k? T
FF
2
l8! T
TT.RealF
T
x T
? T
T
R,: start Fb F TT G(( pt_ID T
F
! %FF `k
T
TABLE NUMBER T
NUMBER +F
T
FF
%F
j
N Replace &lsField2update with m.lsTable, TT.pt_Desc with Proper( m.lsDesc )
R,: ... working ... T
T
? T
! %FF `k
4. T
FFF
:F
j f* T
FFF
F
j %F
. >
? 2 T
. %F
j
OCCUPATIONt T
FF :
T
FF
#?" T
F FF
$` / T
FF
,
8 L %F
( FF
U FF
jU VARIES
%
+
T
F
T
F
= T
F
$ T
F
,< T
GFF =
0 =F =
T
F
N Replace &lsField2update with m.lsTable, TT.pt_Desc with Proper( m.lsDesc )
F
B U PSSSRFILE LSTXTFILE ZFNAME LSMSG ILE ZSTEM ILE OPENSYS E LNFY1 LNFY FILE LSFIELD2UPALLSTR LSTABLEID LSDESC LSTABLE LSLINE OPEN1 PREFS PF_TT PT_ID LNINHANDLELSNUMBERPHLNUPDATEDTSTOKEN ID ZRIGHT TT ABLEID PT_ST EID PT_FMT LNNEWTABLELSDESC1 LELSDESC2 ZLEFT u c q A q A q A q A s cR 2 QA 5v Q A $Q QA A B !A cA sqB B B 3 n K } (r;v 5
%F TALKz ONE G2 T
ON _ T
OFF T
F
COMPATIBLEz GA T
F
READBORDERz Gj 5 s, d ~ @ Arial z, Gj %F
_2tt0umem1 t, t, n
@
MS Sans Serif @*IHN /1
# Name@ ArialA T5
癙: Size(KB)@ ArialA T5
33H Modified@ ArialA T0
33X Tag@ ArialA TZ 7
ffi
B ( l A 16DC Z 盤 ffi
B (d
l A 16DC v 3DBOX @@K75@;@ ! @ d[ 癙 1. Choose directory F
and tag file(s) to import@ Arial @7@ e 盤 癙
B Steps @ Arial
A BI6 ȶ 癙 2. Choose Output@ Arial ff o New files will beF
created with a DBFF
extension in same F
directory as the F
source files.@ Arial @3333334@ e 6 ff
B Notes @ Arial
A BI 癙 o DBF files with the F
same name will be F
replaced.@ Arial @ 4@ 5 $
癙 3. Click Import@ Arials 7I 癙#
@ ArialʡE?)@M? @*VN \ i L (r; 5
%F TALKz ONE G2 T
ON _ T
OFF T
F
COMPATIBLEz GA T
F
READBORDERz Gj 5 s, d ~ @ Arial z, Gj %F
_2tt0umevl t, t, n
@
MS Sans Serif @*IHN /U 6 1
@ FoxFont ? @$@FFN @ 9.857,36.400 GET m.iFile PICTURE "@&N" FROM caImFiles SIZE 18.417,39.625 DEFAULT 1 FONT "FoxFont", 9 WHEN wList() VALID vTag() COLOR RGB(0,0,0,255,255,255),RGB(0,0,0,255,255,255)
$ ffd
BB
@ Arial' @*RVN YTD Obligations;Month Obligations}
l
@ Arial ? $@M? @*VN \!\ - 33
B(- 33 Cx v
@
MS Sans Serif
A B ? @ ? @*VN X*F n
@
MS Sans Serif @*IHN /
%F
_2tt0umfev
t, 9F <, SET READBORDER &rborder
%
ON G2 %
ON GA U CURRAREA TALKSTAT COMPSTAT RBORDER _2TT0UMFEVSCNOBJ1 EVCSBUTTON VBUTTON CSOBUTTON VOK TTON VTAG TON VFILEACT LSPATH CASEOF MNIMOPTOUTPREFS PF_EE LSOUTFILE MNIMSERVICSCNEND1 WDRESS CSWINTITLE_2TT0UMFFC 5 JF( - %Fa
_2TT0UMFEV Fa * t, * ( d [ * F
@ ArialA T ? M@ 7 * (7 d 7 * F
0 Create one database (DBF) for each snapshot file% Update current employee master file (F ) with imported snapshots. Create a single, consolidated employee File -
@ ArialA T ? M@ %F
t, U CURRWIND _2TT0UMFEVLSPATH T CASEOF MNIMOPTOUTPREFS 1 EVPF_EE ON LSOUTFILE _2TT0UMFFC
0Qa !A a a Q a A 6v$U
dRSS A Ra A Qa A 1 q dA A 1 ? /
1 (r; 5
%F TALKz ONE G2 T
ON _ T
OFF T
F
COMPATIBLEz GA T
F
READBORDERz Gj 5 s, d[ d @ Arial z, Gj %F
_2tt0umfp5 t, t, v 3DBOX @S㥻6@V-?'1 bP@```r $ ff
B
@ Arial ? P@ @!FFN | d
@ Arial}?5^I?333333/@? @*HN \@V-? Zd@```j 7I ff
B
@ Arial ? @FFN J 7I Offset for foriegn characters@ ArialA T %F
_2tt0umfp5
t, SET READBORDER &rborder
%
ON G2 %
ON GA U CURRAREA TALKSTAT COMPSTAT RBORDER _2TT0UMFP5LSINFILE 5BLANK 0j CSBUTTON1 VBUTTON1 LDPPFROM LDPPTO 0TEXT3 ON1 LSBATCH PREFS PF_PPD LNOFFSET D0Qa !A a a Q a A a'vaa'Saa A Ra A Qa A 1 y : (r;% C 5
%F TALKz ONE G2 T
ON _ T
OFF T
F
COMPATIBLEz GA T
F
READBORDERz Gj 5 s, - ffu @ Arial z, Gj %F
_2tt0umfy5 t, t, b $ 癙
B Import From @ Arial A BIB d
Operating Budget - OB@ ArialA TS Q ;
B(Q o A 1CE $ ff
B($ o A 1C9 7I 33 Basic Symbol@ ArialA T@ 33 Date of Obligations@ ArialA Th 7 33
B Obligation Data @ Arial A BIG d[ 癙 Responsibility Center - RC@ ArialA Tv 3DBOXS"@+=@S?jtD @```v d[ 癙
B
@ FoxFont ? @ @K!KFFN v 3DBOXFx%@+=@S?Kw#@```{
癙
B
@ FoxFont ? @ @K! XXXXXFFN v 3DBOXw/(@+=@S?x&1@```x 癙
B
@ FoxFont ? @ @K! XXFFN v 3DBOXK7+@+=@S? r1@```u - 癙
B
@ FoxFont ? @$@ @KKFFN k - 癙
@ ArialA T2 @*RVN A: FDDBDAU.DBF;B: FDDBDAU.DBF;Other LocationP m 33 FF j@ ArialA B ? S@S
B( rp A 1CE d
B(d 33p A 1Ch $ ; This import will update the working actual obligation file.@ ArialA T` 6
B
Purpose @ Arial A BIv 3DBOXT㥛`3@vL@
ףp=
?]J@```z - :
B
@
MS Sans Serif ?33333I@ @!FFN | 癙0
@ Arial}?5^I? @? @*HN \ t, 2 6 ff MDEP@ Arial A BT1 d ff AMS@ Arial A BT d ff @ The full AMS is always imported to the Budget Builder AMS field.F
R In addition, you may also import up to 8 characters of the AMS into a local field.@ ArialA T @YS@ "6 ff @ The MDEP code may be imported into a Budget Builder local field.F
E Enter a local code field nr to import the MDEP into that local field.F
2 Enter 0 to not import the MDEP into a local field.@ ArialA T @ffffffO@ l ff FiscalF
Year@ Arial A BT @/$@ ff 9 Enter the fiscal year to import APCs from that year only.F
% Enter 0 to import APCs for all years.@ ArialA T @J@ > m 癙9 Starting position@ ArialA T= d 癙9 Nr of characters@ ArialA Ta - -
@ FoxFont ? @ @K !!!!FFN _
-
@ FoxFont ? @ @K XXFFN _ 盤 -
@ FoxFont ? @ @K XXFFN _ 癙K
@ FoxFont ? @ @K XxFFN ^ 癙K
@ FoxFont ? @ @K XFFN q d[ ff
@ Arial}?5^I?3333335@? @*HN Fiscal Year*F z d ff
@ Arial}?5^I?3333335@? @*HN Local Field for MDEP*F y m ff
@ Arial}?5^I?3333335@? @*HN Local Field for AMS*F %F
_2tt0wt3vc
t, SET READBORDER &rborder
%
ON G2 %
ON GA U CURRAREA ETALKSTAT COMPSTAT RBORDER I_2TT0WT3VCVYEAR2 3VCMAIN_IMP LMAPCFY VCBLANK LMAPCMDEP LMAPCAMS ELMAPCPOS LMAPCCHAR NADA XSETVMDEP MD VAMS 0Qa !A a a Q 1A m A #5& A Ra A Qa A 1 \(dev)\prg\main_imp.prg c:\windows\temp\ MAIN_IMP.FXP \(dev)\prg\pay_imp2.prg PAY_IMP2.FXP \(dev)\prg\ssr.prg SSR.FXP \(dev)\scx\g_imfast.spr G_IMFAST.SPX \(dev)\scx\g_im2171.spr G_IM2171.SPX \(dev)\scx\g_imobl.spr G_IMOBL.SPX \(dev)\scx\g_imemp.spr G_IMEMP.SPX \(dev)\scx\n_lxl.spr N_LXL.SPX \(dev)\scx\n_imact.spr N_IMACT.SPX \(dev)\scx\n_exact.spr N_EXACT.SPX \(dev)\scx\g_impay.spr G_IMPAY.SPX \(dev)\scx\n_apc.spr N_APC.SPX * E ) E t N t n n n #$ #$ 0 < 0 9 _ 9 ;L ;L V