Introduction In CMS CMS, a Batch tch proc proces ess s is requi equirred to post post Monet onetar ary y trans ransa actio ctions ns (li (like sale/p sale/paym ayment ent,, debit/ debit/cre credit dit adjust adjustmen ments ts or refund refunds s etc) etc) as ell ell as !on Moneta Monetary ry tran transa sact ction ions s (lik (like e chan chan"e "e of addr address ess or tele telepho phone ne numb number er)) to the the cust custom omer er#s #s account, calculate date$dri%en delinquency, calculate finance char"es and late fees, "enerate "enerate statements statements,, and other functions& functions& 'he batch process is streamline streamlined d and capa capabl ble e of proc proces essi sin" n" lar" lar"e e accou account nt base bases s ith ithin in comp compre ress ssed ed ni"ht ni"htly ly batc batch h indos& urin" the batch process, all master files are closed to online maintenance so that the batch update update can occur& occur& 'o accomm accommodat odate e certai certain n data data proces processin" sin" requir requiremen ements, ts, is ision ion *+S *+S enable enables s the credi creditt staff staff to acces access s and/or and/or manipul manipulate ate cardhol cardholder der accoun accountt data data after after the master master files files are are closed closed and batch batch proces processin sin" " be"ins (in the after hours mode)& 'he batch processin" of accounts can be classified into - broad cate"ories as. ) !on monetary batch flo -) Monetary batch flo
Non Monetary Batch Flow 0t any point of time, if the card holder ould like to chan"e his/her details in the master files of the Issuer bank, he/she can call up the Customer Ser%ice Centre (also called 0SM or 0ccount 0ccount Ser%ice Mana"ement) Mana"ement) of the Issuer Bank and request request for the required chan"e& 1&"&. 0ddress, 'elephone number etc& 'hese chan"es are directly updated to the ori"inal master files throu"h the online by the customer ser%ice representati%e and a lo" file (0M+ file that is e2tracted as 0'+ usin" the 034-4 pro"ram in batch) ill be maintained ith the before and after %alue of each of the chan"ed fields& 'his acti%ity ould be performed online for the specific accounts requested for& 5n the other hand, if the issuer bank ould like to do bulk chan"es of field %alues for bunch bunch of account accounts, s, instea instead d of updati updatin" n" throu"h throu"h online online trans transact action ions, s, they they are are created throu"h a ser input file (0') and then fed into the batch for updatin" the master files& 1&"&. *ostal code of a city chan"es, !ame of a city chan"es etc& 6ere it is important to make sure that the ser pro%ided 0' files are pre$edited before they are fed in the ni"htly batch to update the master files& ARU040 (Non Monetary User Input Pre-edit) 03474 pro"ram ill do the pre$edits of all the non$monetary ser inputs& 0ll the non monetary user inputs are fed into the system throu"h 0' (isk)/ 0'' ('ape) files and they are pre$edited by the pro"ram 03474& Some e2amples of pre$edits are. & If the input record record is an 80dd !e 0ccount9 0ccount9 and the account e2ists e2ists on either either the 0MBS or the 0MBI (Inacti%e 0ccount Base Se"ment) files, the pro"ram reject the input record& -& If the input record is a maintenance function to an e2istin" account and if the account is not on
the 0ccount Base Se"ment file or on the inacti%e file (if the maintenance is base se"ment maintenance), the pro"ram rejects the input record& :& 'he input record can also be rejected based on the ;ield Security +e%el record for this or"ani
AR!040 (File Maintenance "ournal) 'he actual non$monetary maintenance happens in the 03474 pro"ram& 'he %alid 0'I file from 03474 is fed as input to 03474 pro"ram, and this pro"ram updates the actual master files hen it is run in the user$input mode& It also "enerates the detailed report ith before and after %alues of fields that are updated online, pro%ided it is run in the journal mode (the input file in this mode ill be 0'+ hich is e2tracted from 0M+ usin" pro"ram 034-4)& 03474 can be run in three modes > ?53!0+, *0'1 @ *0'1& "#URNA$ %ode > "enerates report of all non monetary updates that ha%e happened throu"h online& 'hat means all online accepted non monetary transactions in the input 0'+ file, that affects any of the master files ill be reported& UP!A&' U %ode pdates the master files usin" 0' (isk ;ile)/ 0'' ('ape ;ile)& In the pdate (also called as user$input mode), the pro"ram can do selecti%e updates on CMS master files& In this mode, the pro"ram opens only the 0MBS, 0M1C, 0M1, 0M!0, 0M*M, and 0MSC files for direct updates& Correspondin" updates are made to 0M!A (!ame Aey ;ile) and 0MB= (Customer to Base Se"ment Cross reference file), if applicable& 0lso it creates different output files like 0'! (!ame Aey pdate ;ile), 0''S (*romotion Statistics 'a" ;ile), 0'5 (C'0 'a" Maintenance ;ile), 0'!M (aily !ame/0ddress Maintenance ;ile), 0';3 (;raud 3eport ;ile) hich can be used by other subsystems for different purposes& UP!A&' %ode - Is used for disaster reco%ery (3eload files from backup $ 0B';)& 'he update mode can be used for data reco%ery operations& In this mode, the %alid
transactions that are resident on the 0M+ file ill be applied to the concerned CMS master files durin" the e2ecution of 03474& 03474 is composed of %arious dynamically called pro"rams& 1ach of these called pro"rams processes and passes print file information to 03474 in both the update and journal modes& 'hese pro"rams are specifically named as 03474==, here == stands for the file name acronym& 1&"&. 03474BS. (0ccount Base Se"ment 3ecord Maintenance ?ournal) ill be called from 03474 for 0MBS file maintenance 03474!0. (!ame and 0ddress ;ile Maintenance ?ournal) ill be called from 03474 for 0M!0 file maintenance
ARU*0 (Na%e +ey Update) 'he 0'! (!ame Aey pdate ;ile) file created by 03474 ill be fed as input to 034 pro"ram hich handles 0lpha search pdate& It rebuilds 0M!A (!ame key file) and 0MB= (base customer =31; file) files& 0M!A file is used to locate a customer by "i%in" first fe alphabets of the name usin" the online 03!+ transaction& 3ebuildin" of this file is required hen there are chan"es in !ame and 0ddress file 0M!0& Monetary ,atch low Monetary transactions are those hich affect balances of CMS accounts& Monetary transactions are typically authori
034-4. 5nline 'ransaction 12tract 0344. 'ransaction 1dit Mer"e 0344. Sort 'ransactions to *ostin" 0374. *ostin"
E) 034. Monetary 6istory pdate F) 03E. Multiple 3eject *rocessin" ) 03-44. Build 3eject 3eentry 'he 0''/0''' file from '30MS is initially processed throu"h the folloin" set of pro"rams G G G
0344. '30MS monetary balancin" report 034. Sort 0'' file for CMS 0344. Monetary user input pre$edit
'he output of 0344, 0''I file is fed to 0344 alon" ith 0'' created by 034-4 and the processin" continues from 0344 throu"h 03-44&
ARU0.0 ( Master ile ,ac/upreload) *ro"ram 034-4 is used to take backup or reload all master files& 'he backup ill be taken into tape file 0BM;& 'his is a control card dri%en pro"ram in hich e can specify options for backup/reload as ell as the file for hich e need to perform the operation& If somethin" "oes ron" durin" the batch or for any other reason, if it is required to restore all the master files as is before the batch, 034-4 ould be run in the reload mode and usin" the 0BM; as the input file, all the master files ould be restored&
AR!0.0 ( #nline &ransaction '1tract ) *ro"ram 034-4 e2tracts all online monetary transactions that ere fed throu"h 030'/030* screens throu"hout the day& 0ll these transactions ill be added to the 0M' file& 0lso e ha%e the rejected monetary transactions form the pre%ious dayHs batch in the 0M?file, the transferred transactions in 0M=' file& 'his pro"ram e2tracts all these files and ill create output transactions files 0'', 0'? and 0'='& 0lso this pro"ram takes the backup of all the transaction files into tape file 0B';& 'his tape backup 0B'; can be used to reload the transaction files in later sta"e if required &'his Backup and reload process is dri%en by settin" the control card parameters& AR!020AR!023 (!ate Roll!ate Roll Account) 0ll the master files in the system ha%e a date and/or timestamp in the header record& In the batch run, all the master files are updated ith current system date and time on hich the batch is runnin"& ser can make the system bump to any future date by "i%in" a future date in the control card& 'his ould not happen in a normal production en%ironment but ould be required in the 'est 1n%ironment for testin" specific functionality (like testin" delinquency, calculatin" future interest etc)& 5therise the system ill increment the date by one from the current date in the 0MC3 file& 034F4/034FE pro"rams ill handle the date roll in CMS& 'his ill update all the files ith correct processin" date for the system and the or"ani
*ro"ram 034 sorts the monetary transaction comin" from '30MS and rites into 0'' file and pass the file to pro"ram 0344& 034 sorts the records in the correct sequence i&e& batch headers at the top folloed by the transaction records& 'he monetary data from the 0SM system is formatted in 0'' layout and passed into 0344 pro"ram for further processin"& ARU0*0 (Monetary User Input Pre-edit)
*ro"ram 0344 handles the pre$edit of monetary transactions from the user input files (0'', 0''' or both) hich are comin" from different sources like '30MS/ 0SM, mer"es the files and rites all %alid transactions into 0''I file& It produces a report, listin" %alid and in%alid batches and transactions and correspondin" error messa"es& 0''I file is then passed to pro"ram 0344& AR!0*0 (&ransaction 'ditMer6e) *ro"ram 0344 mer"es all monetary transactions and creates the files 0'1 (transactions in error are mo%ed to 0'1), 0'!S (all the !e Sale transactions are mo%ed to 0'!S) and 0'' (all other arious 'ransactions are mo%ed to 0'')& 0ll balanced batches ill be ritten into 0'BB file and imbalance batches into 0'IB file& It mer"es the folloin" files. 0'' (today#s transactions from the online system) 0'? (reject reentry items from the online system) 0''I (user input) 0M' (arehoused monetary transactions) 0'=' (today#s transfer transactions) AR!00 (5ort transactions to postin6) 0344 sorts @ mer"e all monetary transactions from 0'!S @ 0'' and creates 0'*' (*osted 'ransactions ;ile) hich ill be used as input for postin" pro"ram (0374)& 0'!S contains all ne sales transactions and 0'' contains all the %arious transactions& 0 delete define step runs that ill delete and define all the temporary master files& 'he intermediate copy step copies the Insurance history master file to the temporary insurance history file& AR!40 (Postin6) 0374 is the *ostin" pro"ram ith multiple functions&'hese functions include postin" transactions to customer accounts,e2aminin" each account for reportable conditions, "eneratin" the necessary report ta" records, producin" statement records , calculatin" fees assessed by the system , accrues the interest, applies the payments to the system, sends accounts for collections and many other tasks& *ro"ram 0374 does the postin" of monetary transactions usin" 0'*' as input and updates the master files&0lso 0374 "enerates se%eral transactions for assessin" fees, billin" interest, interest adjustments etc and post to the customer accounts&'hese "enerated transacations ill be a%ailable in the 0'K' file created by 0374&It updates the postin" fla" in 0'*' and 0'K'files ith any %alue ran"in" from 44 to DD& If the postin" fla" is other than
postin"& 1ach copybook has a prefi2 of 74 and a : or 7 character file name (such as 0MBI) or function name (such as I!S)& ;or e2ample 740MBI is the inacti%e account processin" copybook and 74I!S is the Insurance processin" copybook& 0374 is the top le%el routine and controls the o%erall processin" flo, performin" the %arious functions as necessary& AR!0 (5hopper Pro6ra% 7ontrol Records Update) 034 updates the ;requent Shopper statistics that are accumulated as part of the pro"ram after multiple postin"s are run& 034 updates the ;requent Shopper *ro"ram (0MS*) control file usin" records in the Shopper *rofile pdate (0'S*) file& AR!3 (5ort A&8& and create AB8& Bac/up) 03E sorts and backs up the "enerated transactions hich are created by postin" in the "enerated transaction 0'K' file& AR!*0 (Monetary 9istory Update) 034 processes the %arious monetary transaction files after they ha%e been processed by the postin" pro"ram 0374& It distributes these items to %arious output files dependin" on hether the. • •
'ransaction as posted or non$posted& 'ransactions are to be printed in a statement run today&
'he pro"ram reads each of the four input files $ 0'K', 0'*', 0B0I and 0MI& ependin" on the postin" status and the statement status, the transaction ill be routed to either of the fi%e output files. a) napplied or nonposted transactions from the 0'*' file are routed to the 0''0 file& b) Monetary transactions from both 0'*' and 0'K' files to be arehoused are routed to the 0M' file& c) 0ccumulated history back up transactions are routed to the 0B05 file& 'his file contains all posted transactions from the 0'*' file, the 0'K' file, and the 0B0I file for those accounts not printin" on statements today d) Statement monetary transactions are routed to the 0'S' file& 'his file contains the same transactions as the 0B05 file described abo%e for those accounts printin" on statements today& It also contains any disputed items from the 0MI file for the indicated accounts& e) nstatemented posted monetary transactions are routed to the 0M5S file& ARU020 (Initiali:e &ransaction Files) 034F4 pro"ram initiali
03D4 creates the Multiple 3eject 0MM file ith one record each for e%ery reject reason usin" 0'M(temporary multiple reject reasons) file as input& It also "enerates the Multiple 3eject 3eport& AR!.00 (Build Re;ect Reentry) 03-44 loads the rejected transactions from the day#s batch run to the 3eject Master (0M?) file& It also "enerates the 3eject 3eentry Batches 3eport& It uses 0MC3, 0''0 and 0'1 as input and "enerates 0M? and takes the tape backup in the 3ejected 'ransactions Backup file 0B?& 'hese rejected transactions can be corrected thru online ( 03M') baed on the reject reasons so that they can come into the system in the ne2t days batch processin"& 7M5 !aily Batch ;iles from different sub systems (like I'S, 0SM etc) are fed to the CMS batch and hence those jobs are e2ecuted first and and their ouputs are fed to the CMS batch& 'he I'S batch is split up into - sub batches as also the CMS batch that is split up into 7 sub batches (CMS, CMS-, CMS: and CMS7) dependin" upon the kind of processin" that is done in each batch& ;0S processin" takes place alon" ith CMS and CMS: hile the 0SM (0ccount Ser%ice Mana"ement), SSC (Security Sub System), C'0 (Collection 'rackin" and 0nalysis), CM (Credit ecision Mana"ement), MBS (Merchant Bankin" Sub System) and +'S (+etter 'rackin" Sub System) sub$system batches run only once durin" the ni"htly batch cycle at specific instances& 'he batch cycle can be split up into 7 phases and different sub system jobs run in each phase as detailed belo. Phase . Be"in Batch (CMS 5nlines are still up and normal day processin" still a%ailable) I'S '30MS I'SPhase . . 0fter 6ours (CMS onlines are brou"ht don, Selecti%e file maintenance a%ailable) 0SM and SSC
CMS (;0S) CMS- C'0, CM and MBS
Phase = . pdate (CMS onlines still don, no processin" a%ailable) CMS: (;0S) and +'S Phase 4 . Be"in 5nline ay (CMS onlines are brou"ht up a"ain and normal day processin" a%ailable)
CMS7 'he processin" done in each sub$system is briefly e2plained belo. I'S > 'he char"e backs and retrie%al requests that are entered online in CMS ill be e2tracted and routed to '30MS& '30MS > 'he input monetary transactions are %alidated and routed to the %arious sub$systems here& In addition to this the out"oin" requests to %arious e2ternal interfaces like schemes are also handled here& I'S- > 'he incomin" retrie%al requests and char"e backs from other schemes and other sources are routed to the I'S system&
0SM > 'he batch processin" for 0SM happens here& 12ternal inputs to 0SM and the daily house$keepin" of 0SM records occur here& CMS > !on$monetary and monetary updates happen in this application& In addition to this interface files to e2ternal systems like +MS and C'0 "et "enerated here& CMS- > *rocessin" of 5pen item billin", update of frequent shopper points, Monetary transaction update, Inacti%e file processin", Statement file "eneration, card issue and reject re$entry processin" happens here& CMS:$ 0ll the monetary and non$monetary updates that happened durin" the after$ hours mode ill be applied to the main CMS files durin" this period& CMS7$ 3eport and statement "eneration happens here& Ater 9ours 'nd o !ay urin" the day, hen the onlines are up, all the master files are updated (addition of ne accounts, file maintainence etc)& In order to tri""er the ni"htly batch cycle 035C transaction needs to be fired& 035C transaction is the after hours processin" screen used to select a processin" mode for CMS master files& 'hree processin" modes are a%ailable in this . 1. 2.
3.
Nor%al Processin6 $ 0ll CMS master files are open& Ater hours processin6 > 0ll CMS master files are closed and 0fter hours files are opened for 3ead only& Shado files are opened for pdations& No processin6 $ 0ll CMS master files are closed to all processin" (03C0 mode)&
035C (or 03C6) transaction (5pen ;or 0fter 6ours 0$6 *rocessin") is fired to close all the CMS files and also open the after hours files& In after hours mode, only certain non$monetary transactions are alloed, monetary transactions are not alloed& 035C internally tri""ers 5;1 transaction that sets the 1nd of ay for the ;0S sub system (;0S and CMS "o hand$in$hand hence at any "i%en point of time, they should be runnin" in the same mode)& *ro"ram 5;444 loads control card ;CC into file ;'CC& arious ;0S pro"rams read the control cards file for e2ecution control& 0fter the control card load , 5;44 is tri""ered& It is the first batch pro"ram in the ;0S end$of$day batch process& 'his pro"ram "enerates a user input file for the ision*+S CMS daily run and "enerates a backup of the ;0S lo" file (;B+K)& 'his pro"ram also produces and passes a report file to 5;4 here all reports are "enerated& It reads 0MC3, ;MSC, ;M+0, ;M+B and ;'CC control card file (that as "enerated by 5;444) and creates the folloin" output files. ;B+K . +o" file ('ape Backup) 0'I0 . CMS authori (Account Recei?a,le !aily 7M5) ARU000 (7ontrol 7ard $oad) 12ecution of 03444 pro"ram starts the CMS&
03444 loads the pro"ram control cards (SCC) to the control cards 0'CC$, 0'CC$ - and 0'CC$: files& arious pro"rams read the control cards files for e2ecution control& AR!000 (File Inte6rity) Before e2ecutin" any batch it is important to %erify that all the files used in the system are in sync ith each other i&e& the date and time stamp of these files should match ith each other& 'he pro"ram hich does this file inte"rity check in CMS batch is 03444& It ensures the inte"rity of date and time stamps on all the master files& It also ensures the inte"rity of the Keneral +ed"er (0MK+) file and the Monetary 'ransaction (0MMC) file& 'he pro"ram opens and reads the first record hich contains the current date and time stamps from System Control Master (0MC3) file& 'he pro"ram then opens and reads the first record of each master file& If it is a header record, the pro"ram checks the date and time stamps to ensure that they match the date and time stamps on the System Control Master ;ile& It "enerates a file inte"rity report for each file ith the reason of M0'C6# or !5 M0'C6#& 1%en if there is a sin"le H!5 M0'C6H the pro"ram abends& ;ile Inte"rity check ensures all the master files in the system has same date and time and confirm that all the master files are in sync and last batch processin" as successful& ARU0.0 (Master File Beore Bac/upReload) 034-4 pro"ram performs either a backup of all the master files or a reload of the master files to their appropriate se"ments& 'he option of takin" the backup or reloadin" the data is controlled by the 0'CC control card& 'he control card also determines the files to be processed& 'he system produces a report that shos the control card ima"e used and the number of records processed by file& It takes the back up into the tape file 0BM;& 'he backup of the master files needs to be taken tice, once before the batch is tri""ered (i&e& after file inte"rity and before monetary and non monetary updates are applied to the files) and once after the postin" and statement jobs are completed& 'his is required because in case anythin" "oes ron" durin" the batch run, system can "et the correct data before the batch started by reloadin" the master files from 0BM; file AR!0.0 (#nline &ransaction '1tract) 034-4 e2tracts the online transactions from S0M files 0M+, 0M+:, 0M', 0M? and 0M=' and "enerates sequential files for batch processin"& 0 backup function loads the transactions to a tape file and a reload function "enerates the sequential disk files from the backup tape& AR!020 (!ate Roll) 034F4 establishes the correct processin" dates for the system and or"ani
hen the pro"ram completes this process, it prints the report line for this file and updates the date and time stamps for non$se"mented master files used by the system and also prints the report line for all the files& In the '1S' en%ironment (future interest or delinquency testin") some future date could be entered in the control card file and the system ould process for that future date& Monetary User Input (AR!0@ ARU0*0@ AR!0*0) 0fter the file inte"rity, master file backup and date roll, the batch does the processin" of the monetary user inputs (that are fed to the CMS throu"h '30MS)& 'he monetary user inputs are handled by the pro"rams. 034 0344 and 0344 etails of these pro"rams has been already co%ered in the Monetary Batch ;lo part earlier& AR!023 (!ate Roll Account) 034FE updates the time and date stamps for the account$based master files of the system& 'he pro"ram opens and reads the system record from the 0MC3 file& 'hen it opens and reads each account based master file to ensure that it is a header record& It a"ain does a date and time stamp check and abends for mis$match& 6ere, since the date and time stamp of the 0MC3 file is already rolled o%er (by 034F4) the check is done ith the last processed date and last time stamp from the 0MC3 file& If the date and time stamps match, the pro"ram mo%es the ne date and time stamp from the system record to the fileHs *35C$0'1 and 'IM1$S'0M* fields and then closes the file& AR!040 is run twice in a daily ,atch •
•
once in the journal mode to "enerate a file maintenance journal report of the non monetary updates that ere done in onlines durin" the day& 5nce in the ser Input (pdate ) mode to update the master files&
User Non-%onetary (ARU040@ AR!040@ ARU*0) etails of these pro"rams has been already co%ered in the !on$Monetary Batch ;lo part earlier& AR!00 (5ort &ransactions to postin6) 0344 sorts the monetary transactions to the *ostin" pro"ram > 0374& 'he pro"ram reads the records in the 0'!S (!e Sales) and 0'' (arious 'ransactions) files alon" ith the rele%ant master files, and passes the records to the sort file& 'he pro"ram assi"ns each record a secondary key in addition to the primary sort key& 'he sort sequence done by 0344 is %ery important as it ould decide the manner in hich %arious monetary transactions ould be applied by postin" in the system that ould affect the balances on hich interest and other dues ould be calculated& 'he initial sortin" is done on the or"ani
0'!S Credit 'ransactions. ;irst, all the credits comin" in for ne sales needs to be applied in the system as those ould affect the balances on hich interest and other due calculations are done& 0'!S ebit 'ransactions. It should be folloed by ne sales that come in on that day as these need to be applied in second hi"hest order of priority& 0'!S Memo 'ransactions. 'he ne2t in sequence ould be all the ne sale memos& 0'' Credit 'ransactions. 0ll the credits comin" in for %arious transactions need to be applied in the system after all the ne sale related transactions are applied&& 0'' ebit 'ransactions. ;inally the %arious transactions debits need to be applied& 'he output procedure of the sort builds the header record for the 0'*' file, returns the sort records and rites them to the 0'*' file, and builds the trailer record for the 0'*' file, hich in turn ill be passed to the postin" pro"ram > 0374& 0'*' contains all the monetary records that are ready for postin" into the master files& 0 delete define step runs that ill delete and define all the temporary master files& 'he intermediate copy step copies the Insurance history master file to the temporary insurance history file& AR!40 (Postin6) 'he 0374 postin" pro"ram is the most %ital pro"ram in CMS and performs multiple functions& 'hese functions include postin" transactions to the customer accounts, e2aminin" each account for reportable conditions, "eneratin" the necessary report ta" records, producin" statement records, and calculatin" fees assessed by the system& 'he pro"ram can be run in to modes. ) isk$in$disk$out . In this mode, the master files are re$ritten to temporary datasets and the rest of the CMS processin" uses these temporary files for further processin" and at the end of the batch, the master files are rippled ith these temporary files& -) pdate mode. In this mode, the master files are updated directly& 'he e2ecution of postin" completes the CMS and CMS- starts ith the e2ecution of 03& AR!AI$>. (Account Recei?a,le !aily 7M5.) AR! (Account7ard uarterly report 5ort) 03 reads all of the se"ments of the 0ccount Base Se"ment file (0MBS), all of the se"ments of the Inacti%e 0ccount Base Se"ment file (0MBI), and the 1mbossin" ata file (0M1)& 'he pro"ram creates a sorted sequential file (0'L3) that is input to the Cardholder Luarterly 3eport ;ile pdate pro"ram (03D)& AR!* (Update 7ardholder uarterly Report File) 03 updates the Cardholder Luarterly 3eport (0MCL) file from the temporary quarterly reportin" file "enerated durin" postin"&
AR!< (7ardholder uarterly Report File Update) 03D updates the card totals and account totals for all re"ions of quarterly reportin"& 'he pro"ram processes each or"ani
AR!44 (5plit Relationship'%,osser Update File) 0377 e2amines relationship ta" records based on record type(embosser or embosser statistics or relationship or relationship statistics) and splits the records into the appropriate ta" files& 'hese files are processed in the later CMS pro"rams in the batch& 'his pro"ram takes the 0'3' (relationship ta") file and "enerates the embosser, relationship and embosser statistics files& 3elationship ta" file is the output from the postin" pro"ram hich has the data for the embosser and relationship statisitics& 'his pro"ram also updates the relationship cross reference file (0M0=) AR!30 (Update AM7R and produce daily ,alancin6 report) 0fter processin" the 0377 pro"ram, the ne2t pro"ram in the flo is 03E4 pro"ram hich updates the system control record and the rate table file& 03E4 performs the folloin" functions. ) 0ccumulates the balancin" totals from the postin" run and updates the system control file (i&e 0MC3) ith these totals& -) 3esets the options on the processin" control record on the system control file& :) *roduces the daily balancin" report (3:-)& 7) 'he one time options hich are set on 0MC3 ill be discontinued& AR!3< (#pen Ite% &ransaction &a6 5ort) 03ED sorts the open item transaction ta" (0'5') records into a specific account number sequence to support the open item billin" transaction processin"& 0'5' file is a output file from the postin" pro"ram hich contains the transactions for the open item billin" account& 'he records in the 0'5' file are sorted in the ascendin" order and the primary sort key is or" and account number& AR!20 (#pen Ite% &ransaction File Update) 03F4 reads the 5pen Item Billin" 'ransaction file (0M5I) and the open item transactions ta" (0'5') file and ill do the open item billin" processin" for the day& 'he open item billin" transactions ill be ritten to the 0'5I file& 'he open item statemented transactions are ritten to 0'5S file& AR!0 (5hopper Pro6ra% 7ontrol Records Update) 034 updates the ;requent Shopper statistics that are accumulated as part of the pro"ram after multiple postin"s are run& 'he updates to the ;requent Shopper *ro"ram (0MS*) control file ill be done usin" records in the Shopper *rofile pdate
(0'S*) file& 0'S* file ill be ha%in" the updated data from the postin" and applies the frequent shopper data to the 0MS* file & 'he pre%ious redemption data ill be updated in the 0MS* file& AR!3 (5ort A&8& and 7reate AB8& Bac/up) 03E sorts the 0'K' file& 0'K' file is the "enerated transaction file hich ill contain the data for the system "enerated transactions like membership fee, late char"es, ser%ice char"es etc&, 'he pro"ram also simultaneously "enerates a backup of the ori"inal, unsorted 0'K' file (called 0BK')& 'he 0BK' file may be dummy file that can be i"nored& 'his file can be used hen this pro"ram abnormally terminates due to poer failure, accidental cancellation and so forth& AR!*0 (Monetary 9istory Update) 034 processes the %arious monetary transaction files after they ha%e been processed by the postin" pro"ram 0374& It distributes these items to %arious output files dependin" on hether the. • •
'ransaction as posted or non$posted& 'ransactions are to be printed in a statement run today&
'he pro"ram reads the each of the four input files $ 0'K', 0'*', 0B0I and 0MI 'he input file files ill ha%e the folloin" data. 0'*' ) *osted monetary tranasactions (*ostin" fla" N 44) -) arehoused tranasctions (postin" fla" N D) :) !onposted tranasctions (*ostin" fla" N 4 to D) 0MI 'his file ill contain the data for the disputed items 0'K' ) *osted "enerated monetary transaction (postin" fla" N 44) -) Statement notification (0'K'$M'$'O*1 N S) :) arehoused 0C6 payments (*ostin" fla" N D) 0B0I 'his file conatins all pre%iously posted monetary transactions that ere not billed or printed on statements ependin" on the postin" status and the statement status, the transaction ill be routed to either of the fi%e output files& a) napplied transactions are routed to the 0''0 file& b) arehouse monetary transactions are routed to the 0M' file& c) 0ccumulated history back up transactions are routed to the 0B05 file& d) Statement monetary transactions are routed to the 0'S' file& e) nstatemented posted monetary transactions are routed to the 0M5S file& ARU020 (Initiali:e &ransaction Files) 034F4 pro"ram initiali
AR!*3 (Multiple Re;ect Processin6) 03E pro"ram takes rejected transactions from the napplied 'ransaction (0''0 file) created by postin" and "enerates Multiple reject records& (one record each for each of reject reasons)& sin" the Inputs shon in the slide, this pro"ram creates 0'M (Multiple 3eject 'ransaction) file and updates 0''0 files& AR!<0 (Build AMM File) *ro"ram 03D4 builds Multiple reject transactions (0MM) file ith one record each for e%ery reject reason usin" file 0'M as input& 0'M is the multiple reject transactions file from 03E pro"ram& 03D4 pro"ram prints the multiple reject report (3:F)& 'he records ritten into the 0MM file ill be in the sorted order of batch date, batch source, batch number and sequence of report records& AR!.00 (Build Re;ect Reentry) 03-44 handles the reject$reentry and also creates the rejected monetary transactions (0M?) file takin" the rejected transactions from today#s run& It also takes the backup of 0M? file into 0B?(tape file)& 3ejected monetary transaction file (0M?) is build from the 1dited transactions (0'1) file and napplied transactions (0''0) file as input& 'his pro"ram also "enerates the reject reentry batches report (3E)& AR!.0 (Fraud Reports Print) 03-4 pro"ram prints the non monetary fraud report from ;raud report (0';3) file , updates the fraud suspect (0M;;) file and clears the fraud file statistics at the month end and year end&
AR!.30 ( Acti?eInacti?e Account Processin6) 03-E4 processes the mi"ration of base se"ment records beteen the 0ccount Base Se"ment (0MBS) and the Inacti%e 0ccount Base Se"ment (0MBI) files& 03-E4 also transfers account history records from the Base 6istory (0M6B) file to the Inacti%e 6istory (0M6I) file hen the 0ccount Base Se"ment record (0MBS) is transferred to the Inacti%e account base se"ment record (0MBI) file& 'he acti%e and inacti%e account mi"ration is dri%en by a control card hich either mi"rates from acti%e to inacti%e or inacti%e to acti%e& 0'0I (0cti%e/Inacti%e ta") file ill ha%e the information of the accounts hich need to be mi"rated& AR!4.0 (Acti?ity Recap Update) 037-4 posts the acti%ity recap transactions "enerated by the *ostin" pro"ram (0374) to the 0cti%ity 3ecap master file& 'his pro"ram is dri%en by the control card hich desi"nates the end of month for the "eneral led"er and the or"anisations to be e2tracted& 'he 0'03 file ill be checked ith the acti%ity recap master file (0M0M) file and the data ill be ritten into the sequntial recap master file (0'0M) file& 0n updated %ersion of the master file ill be "enerated in 03774 pro"ram&
AR!440 (Acti?ity Recap Restore) 03774 replaces the prior 0cti%ity 3ecap master file ith the updated file "enerated by the 0cti%ity 3ecap pdate pro"ram (037-4)& 'his pro"ram sorts the updated 0cti%ity 3ecap master (0'0M) file into key sequence and "enerates the S0M (0M0M) master file& AR!200 (Pro%otion 5tatistical Update) 03F44 updates the 0M'* (*romotion statistics) file usin" the 0''S (promotion statistics ta") file "enerated by 037:& 'his pro"ram applies the statistical transactions "enerated by 037: to the 0M'* file& 0'CC control card is "enerated for each or" at the end of the month hich ill be used by 03F-4 to print the promotional statistical analysis reports& AR!..0 (5et 7ondition 7ode or #nline 5tate%ents) 03--4 pro"ram sets a condition code in the daily batch run to In this mode it creates the 0BS5 file (Small statement backup file)& -) 3eload > In this mode it creates the 0MSS file by takin" the data from the 0BSI file& :) Backup > In this mode it takes the backup of 0MSS file into 0BS5& 7) Mer"e > In this mode it takes the 0BSI, 0'SM, 0'S' files to "enerate the 0BS5 and 0MSS file& E) 3eset > In this mode it "enerates an 0BS5 master file that contains only the file header and trailer& In the e2ample shon on the screen, the 03-74 pro"ram runs in the mer"e mode& It creates 0MSS and 0BS5 files by takin" 0BSI, 0'SM and 0'S' files as input& AR!.=0 (Reset 7ondition 7ode to ero) 03-:4 pro"ram unconditionally resets the condition code to
ARU0.0 (Master File Ater Bac/upReload) 034-4 pro"ram does to functions . 0s mentioned 034-4 is e2ecuted tice in any ni"htly batch& 6ere it e2ecuted the second time to take the after backups of the master files& ARU<0 (5ortMer6e '%,ossin6 A&'I and A&'# Files) 03D4 pro"ram sorts and mer"es the 1mbossin" issue (0'1I) and 1mbosser issue multi attempt (0'15) files and creates the 1mbosser mer"ed accounts (0'1M) file& 'his pro"ram produces Mer"e 0'1I/0'15 records report ('D4)& ARU.00 (7ard Issue) 03-44 pro"ram "enerates the embosser, card mailer, *I! mailer files required to satisfy the card issue requirements& 0'CC control card is used to control the processin" of card issue for all the or"s and lo"os or selected or"s and lo"os& It takes the 0'1M file, 0M1 file based on the or"s and lo"os selected and determines the action to be performed (ne , replacement, additional cards or *I! mailer)& 0MBS, 0M!0, 0MC3 files are read to pro%ide ith the information hich is missin" from the embosser data file& If the ne, replacement or additional card is requested then this pro"ram rites a user input tape file (0''), hich is used to update the issue fla" on the 0MBS file& 'he output files "enerated from this pro"ram are. & *in mailer issue file (0'I:) -& 1mbossin" tape file (0'1') :& ser input non monetary (0'') and 7& 1mbosser issue multi attempt (0'15) files 'he e2ecution of 03-44 pro"ram completes CMS- and CMS: starts by firin" the 035C(03C0) online transaction& AR!AI$>= (Account Recei?a,le !aily 7M5=) 035C (Close all CMS files) > By selectin" this option, it closes all the CMS files and after hours files& urin" this process it suspends the ;0S online processin", delete the CMS master files, renames the temporary CMS files, the fas lo" files ill be sitched off beteen ;M+0 and ;M+B& 03C0 initiates 5;06& 'his sets the ;0S end of processin"& 'his ill suspend the online processin" due to after hours transaction update& 0fter this 5;-44 is run hich sitches the lo" files, re$initiali
urin" the 03C0 mode (Close 0ll !o *rocessin"), the CMS master files (0MBS, 0M!0 etc&,) ill be deleted& 'his ill only happen if the update sitch on the system record (0MC3$S$0CC'$MS'3$*0'1$S is set to #) is ISA I! ISA 5'& 'he CMS temporary files thus created in the ni"htly batch cycle ( like 0'BS, 0'!0 etc&,) ill be renamed to the CMS master files (like 0MBS etc&,)& AR!..0 (5et 7ondition 7ode For #nline 5tate%ents) 03--4 pro"ram sets the condition code in the daily batch run to
AR!AI$>4 (Account Recei?a,le !aily 7M54) ARU<00 (Initiali:e Ater hours Master Files) 0fter the online are brou"ht up by tri""erin" 035C/0350, all the 0fter 6ours Shado Master ;iles need to be initiali
ARU00 (Initiali:e 5hadow Alpha Na%e /ey) 'he ne2t pro"ram in sequence is the 0344 that initiali
normally a tape file& 'his file is considered to be the +ar"e Statement master file, and the 0MS+ file is a copy of this file placed on S0M disk for access by the online portion of the system& 5nce the 0B+5 file is "enerated, the 3eload function of this pro"ram must be run to initiali
