3.6 Perform Segment Pre End of Day Check – Execute Pre EOD

This topic provides the systematic instructions to fetch Pre EOD checks count and execute Pre EOD at both segment level and FMG level.

Segment Pre-EOD checks

To recall, the Pre-End of Day checks will indicate any activities that are pending, that must be executed and completed by the Fund Manager before the End of Day process can be run. These pending activities can be viewed in the Fund Manager Pre-EOD Processing screen.

The pre-EOD checks could indicate unauthorized transactions, missing fund maintenance or processing information such as fund prices, exchange rates, signing off branches, and so on. The Fund Manager must complete these activities before the End of Day processes can be run.

The list of Segment Pre-EOD checks applicable for Pension Administration are as follows:

Table 3-4 Segment Pre-EOD checks

Serial Number Activity Description Mandatory/ Optional Segmented
1 Number of Agency Branches which have not signed-off. Mandatory FMG Level
4 Number of Non Pre-Settled Funds for which Fund Price has not been entered. Optional FMG Level
5 Number of Pre-Settled Funds for which Fund Price has not been entered. Optional FMG Level
12 Number of Standing Instructions for which Action is not taken after generating the First Reminder. Optional FMG Level
13 Number of Standing Instruc\u0002tions for which Action is not taken after generating the Last Reminder. Mandatory FMG Level
17 Number of unauthorised IPO/ SUBs/REDs of portfolio type which are not authorised till date. Mandatory FMG Level
18 Number of Transactions of PortfolioType which are Maturing Today and FundPrice not entered. Mandatory FMG Level
22 Number of unauthorised Income Distribution Setup for Entities Mandatory FMG Level
25 Number of broker details that have been amended or created. Mandatory FMG Level
26 Number of brokers for whom commission payment is due. Mandatory FMG Level
27 Number of Unauthorised BrokerType. Mandatory FMG Level
35 Number of Different LEP Fiscal Year Maintained for Products Mandatory FMG Level
101 Number of Unauthorised Products. Mandatory FMG Level
102 Number of Unauthorised Plan. Mandatory FMG Level
103 Number of Unauthorised Plan Transactions. Mandatory FMG Level
104 Number of Authorized Plan which are on Hold. Optional FMG Level
107 Number of Rejected Products. Mandatory FMG Level
108 Number of Rejected Policies. Mandatory FMG Level
109 Number of Rejected Policy Transactions. Mandatory FMG Level
110 Number of Unauthorised Policy Cessions. Mandatory FMG Level
112 Number of Unauthorised Policy Status Changes. Mandatory FMG Level
113 Number of Unauthorised Policy Loans Mandatory FMG Level
114 Number of Unauthorised Policy Loan Repayments Mandatory FMG Level
118 Number of Unauthorised Records In Broker Journal Mandatory FMG Level
155 Number of unauthorized entities Mandatory FMG Level
156 Number of unauthorized Bulk Client Transaction Defaults Records Mandatory FMG Level
158 Number of unauthorized Basis Definition Records Mandatory FMG Level
159 Number of unauthorized Source Records Mandatory FMG Level
160 Number of unauthorized Country Currency Records Mandatory FMG Level
161 Number of unauthorized Currency Records Mandatory FMG Level
164 Number of unauthorized Fund Family Records Mandatory FMG Level
168 Number of Unauthorized Periodic Load Records Mandatory FMG Level
169 Number of Unauthorized Switch Privilege Setup Records Mandatory FMG Level
171 Number of Unauthorized Holiday Records Mandatory FMG Level
172 Number of Unauthorized Load Records Mandatory FMG Level
173 Number of Unauthorized Group definitions Mandatory FMG Level
176 Uncleared Check details to bank - BO Report schedule Optional FMG Level
177 Number of unauthorized Fund sale restrictions Mandatory FMG Level
178 No of Groups for which Load has not been mapped Optional FMG Level
181 Number of Unauthorised Incoming SWIFT Messages Optional FMG Level
182 Number of Unprocessed/ Repaired Messages that have not been Processed Optional FMG Level
183 Number of Unauthorised Outgoing SWIFT Messages Optional FMG Level
184 Number of Ungenerated / Repaired Messages that have not been Generated Optional FMG Level
187 Number of unauthorized Bulk Client Unitholder Defaults Records Mandatory FMG Level
188 Number of unauthorized Bulk Client Transaction Load Override Defaults Record Mandatory FMG Level
190 Number of unauthorized Bulk Client SI Defaults Records Mandatory FMG Level
191 Number of unauthorized Bulk Client IDS Defaults Records Mandatory FMG Level
192 Number of unauthorized Bulk Client Fund Price Defaults Records Mandatory FMG Level
193 Number of unauthorized Bulk Client Fund Rule Defaults Records Mandatory FMG Level
199 Number of Unauthorised Fund Switch Restrictions. Mandatory FMG Level
203 Number of Unauthorized Customer Information Files (CIF) Optional FMG Level
204 Number of Unauthorized Entity Payment Details Mandatory FMG Level
205 Number of Unauthorized Entity Commission Share setup Mandatory FMG Level
208 Number of Distributors with pending EOD process Mandatory FMG Level
209 Number of Transactions due for hand off Mandatory FMG Level
210 Number of Brokers for whom payment is held back Optional FMG Level
212 Number of Unauthorized GL Setup Records Mandatory FMG Level
214 Number of Enities For Whom Commission Payment Is Due. Mandatory FMG Level
240 Number of Unauthorised Policy Journal. Mandatory FMG Level
248 Number of brokers who does not have IDS maintenance Mandatory FMG Level
249 Number of brokers who does not have preferred currency maintenance Mandatory FMG Level
2095 Number of Modules which do not have enrichment Optional FMG Level
3003 Number of Unauthorised UH Category Parameter Maintenance Mandatory FMG Level
3004 Number of Unauthorised Maintenance Record Mandatory FMG Level
3005 Number of Users Logged In Mandatory FMG Level
3007 Number of entities pending classification more than threshold day Optional FMG Level
3008 Number of transactions which are yet to be generated in Global order Mandatory FMG Level
3009 Number of global order which are yet to be confirmed Optional FMG Level
3015 Number of Segments which have not Completed EOD. Mandatory FMG Level
3021 Number of Unauthorized activities scheduled for executio Mandatory FMG Level
3022 Number of Future Dated Transactions falling on holiday Mandatory FMG Level
3023 Number of unauthorized IPO units overridden records Mandatory FMG Level
3025 Number of funds for which fund preference is not maintained Mandatory FMG Level
3050 Number of IDS setup with pay out option, for PAS investment accounts Mandatory FMG Level
2 Number of Unauthorised Fund Rules. Mandatory Segment Level
3 Number of Unauthorised Fund Prices. Mandatory Segment Level
4 Number of Non Pre-Settled Funds for which Fund Price has not been entered. Mandatory Segment Level
5 Number of Pre-Settled Funds for which Fund Price has not been entered. Mandatory Segment Level
10 Number of Transactions for which Redemption Confirmations are due. Optional Segment Level
11 Number of Unalloted IPO/Subscription Transactions for which Cheque has been cleared or rejected. Optional Segment Level
14 Number of Back-dated Transactions which have not been alloted. Optional Segment Level
15 Number of Unverified Transactions generated by Standing Instruction. Optional Segment Level
16 Number of Funds with Daily Payments for which Daily Dividends have not been processed Mandatory Segment Level
19 Number of unauthorised overriden loads Mandatory Segment Level
24 Number of Authorized Funds whose Fund bank Accounts are not maintained for their Fund Base Currency Mandatory Segment Level
28 Number of Currency Pairs for which Exchange Rates have not been maintained Mandatory Segment Level
36 Number of Unauthorized EOD Maintenance Mandatory Segment Level
115 Number of Unauthorised Records In Limits Maintenance Optional Segment Level
117 Number of Unauthorised Records In LOI Setup Mandatory Segment Level
150 Number of Unauthorised Fund Dividends. Mandatory Segment Level
153 Number of Unprocessed Dividends Of Previous Cycle Mandatory Segment Level
154 Number of Funds for which Reinvestment Processing is pending Optional Segment Level
157 Number of unauthorized AutoSwitch Setup Records Mandatory Segment Level
162 Number of unauthorized Fund Account Records Mandatory Segment Level
163 Number of unauthorized Fund Agency Branch BackDating Limit Setup Records Mandatory Segment Level
165 Number of Unauthorized Fund SubAccount Records Mandatory Segment Level
167 Number of Unauthorized WHTax SetUp Records Mandatory Segment Level
170 Number of Unauthorized Exchange Rate Records Mandatory Segment Level
174 Number of funds for which fund preference is not maintained Optional Segment Level
179 No of Funds for which Maturity Date Settlement is not done Mandatory Segment Level
180 Number of Global orders due for confirmation Optional Segment Level
185 Number of funds for which creation price has not be entere Optional Segment Level
186 Number of funds for which Liquidation price has not be entered Optional Segment Level
194 Number of optional pending activities for the start of Corporate Actions Processing Optional Segment Level
195 Number of mandatory pending activities for the start of Corporate Actions Processing Mandatory Segment Level
196 Number of Funds whose IPO End date has reached Optional Segment Level
197 Number of unauthorized IPO units overridden records Mandatory Segment Level
198 Number of UnProcessed Selective UH Dividend Payment Reversal Mandatory Segment Level
200 Number of Transactions violating Min/Max Amount/Unit checks at a CIF Level Mandatory Segment Level
201 Number of customers whose holdings might go below minimum holdings setup for the fund Optional Segment Level
202 Number of Unprocessed Dividends Optional Segment Level
207 Number of Fund Rule Interface due for hand off Mandatory Segment Level
211 Number of NPI Applicable Funds for which NPI Trust Category Fund Bank Account is not maintained Mandatory Segment Level
213 Number of Unauthorized Trading Transaction Mandatory Segment Level
215 Number of unauthorized Unit Holder Deals Mandatory Segment Level
216 Number of Future Dated Transactions falling on holiday Mandatory Segment Level
217 Number of unauthorized transaction Mandatory Segment Level
218 Number of Failed Default UH Bank Accounts Optional Segment Level
219 Number of Unauthorized UHPortfolio Readjustments Mandatory Segment Level
229 Number of unauthorized Fund Investment Component Mandatory Segment Level
3001 Number of Unauthorized High Water Mark records Mandatory Segment Level
3002 Number of invalid hedge funds Mandatory Segment Level
3006 Number of Unitholders pending FATCA classification Optional Segment Level
3010 Number of COE transaction with non COE funds Mandatory Segment Level
3011 Number of non COE transaction with COE funds Mandatory Segment Level
3014 Funds for which Value of Dilution Levy Applicable At in Fund Preference is incorrect Mandatory Segment Level
3016 Number of Agency Branches which have not signed-off. Mandatory Segment Level
3017 Number of Users Logged In. Mandatory Segment Level
3018 Number of Unauthorised Maintenance Records Mandatory Segment Level
3019 Number of Unauthorized GL Setup Records Mandatory Segment Level
3020 Number of Unauthorized activities scheduled for execution Mandatory Segment Level
3024 Number of Unauthorized WHTax SetUp Records Mandatory Segment Level
5000 Number of Unauthorized Maintenance Records From Other Branches Optional Segment Level
5001 Number of Unauthorized Transactions From Other Branches Optional Segment Level
5002 Number of CIF Conversion Maintenances which are Ready for Conversion Mandatory Segment Level
5003 Number of Unauthorized Capital Call Tranche Mandatory Segment Level

Segment Pre End of Day Check – Execute Pre EOD

  1. On Home screen, type UTDSGPED in the text box, and click Next.
    The Segment Pre End of Day Check – Execute Pre EOD screen is displayed.

    Figure 3-6 Segment Pre End of Day Check – Execute Pre EOD



  2. On Segment Pre End of Day Check – Execute Pre EOD screen, click New to enter the details.
    For more information on fields, refer to the field description table.

    Table 3-5 Segment Pre End of Day Check – Execute Pre EOD - Field Description

    Field Description
    Segment ID Alphanumeric; 12 Characters; Mandatory

    Specify the Segment ID. Alternatively, you can select the Segment ID from the option list. The list displays all valid Segment IDs maintained in the system.

    Segment Description Display

    The system displays the description of the selected Segment ID.

  3. Click the Fetch Pre-EOD Count button in this screen.
    The following information message window is displayed.

    Figure 3-7 Segment Pre End of Day Check - Execute Pre EOD_Fetch Pre-EOD Count_Information Message



  4. Click OK to return to the following screen in which the View Pre-EOD Results and Execute Pre-EOD button will be enabled.
    The following screen is displayed.

    Figure 3-8 Segment Pre End of Day Check - Execute Pre EOD_View Pre EOD Results



  5. Click the View Pre EOD Results button in this screen to display the activities that are pending completion before the segment level end of day operations can be executed.
    The following information message window is displayed.

    Figure 3-9 Segment Pre End of Day Check - Execute Pre EOD_View Pre EOD Results_Information Message



  6. Click Ok to view the results in the Segment Pre-End of Day Check – Execute Pre EOD screen.
    You can view the following fields in this screen:

    Table 3-6 Segment Pre End of Day Check – Execute Pre EOD

    Field Description
    Serial Number Mandatory

    This is a number that indicates the particular activity.

    No two Activities can have the same Serial Number.

    Description Display

    Describes the various activities scheduled for EOD.

    Mandatory Display

    Indicates whether the activity is mandatory or can be skipped.

    Count Display

    Describes the count of various activities scheduled for EOD.

  7. Click the Detail button to view the details of the selected activity in the Pre EOD Details screen:

    The system displays the following details of the chosen activity in this screen:

    • Name of the selected activity
    • Description of the selected activity
    • Additional Description of the selected activity
    • Module ID of the selected activity

    Figure 3-10 Segment Pre End of Day Check - Execute Pre EOD_Pre EOD Fetch Results_Detail



  8. Click the Execute Pre EOD button to process Pre EOD execution.