Model Log

Overview

NOTE: The contents of the log can reflect the model activities within a ninety (90) day window.

The Model Log provides historical information on any successful model creations, modifications, assignments (securities, models, accounts, clients, and groups), and deletions related to your firm during a specified time period of up to 90 days.

Top

Viewing the Model Log

  1. Select Trade > Trading Tools > Portfolio Modeling & Rebalancing to launch Modeling & Rebalancing.
  2. Select Audit > Model Log. The Model Log pop-up screen displays.
  3. Either enter the dates manually or use the Calendar icons to complete the From and To fields, which establish the date range for the log.
  4. Select the Export to CSV button to create a zip file containing five .csv log files. NOTE: The zip filename defaults to ModelLogs<FromDate(MMDDYY format)>-<ToDate(MMDDYY format)>.zip and contains five .csv files: modelMaster.csv (Model Details/Settings), modelElements.csv (Security/Model Assignments), modelAssignments.csv (Account, Client, Group, and Model Assignments), modelAssignmentsHousehold.csv (Household Assignments), and modelAssetClassifications.csv (Asset Class Assignments). Example: ModelLogs101617-102017.zip.
  5. A small pop-up screen displays where you can do one of the following:
    Select the Open button to view the zip file containing five .csv log files.
    OR
    From the Save button, select one of the three options in the drop-down list.
    - Save: Downloads the zip file. A small pop-up screen displays containing three buttons that you can choose to open the file, open the folder containing the file, or view a downloads pop-up screen where you can access the file.
    - Save as: A Save As pop-up screen displays, so you can choose the location where you wish to save the zip file.
    - Save and Open: Opens the zip file and offers the same options as Save.
    OR
    Select the Cancel button to close the pop-up screen without viewing or saving the zip file.
Top

Zip File Content

modelMaster.csv

Label Definition Excel Column Designation Description
AUDIT ID Audit ID A Displays a system-generated ID associated with the log entry.
FIRM_ID Firm ID B Displays the ID of the firm associated with the individual who created/last edited the model.
MODEL NAME Model Name C Displays the name of the model.
MODEL DESCRIPTION Model Description D Displays the description of the model.
SUPER MODEL INDICATOR Super Model Indicator E Indicates whether the model is an Individual or Composite Model. Options are: 0: Individual Model or 1: Composite Model.
ASSET CLASS MODEL INDICATOR Asset Class Model Indicator F Indicates if the model is an Asset Class model. Options are 0: Individual securities model or 1: Asset Class model.
TOLERANCE CODE Tolerance Code G Indicates whether the Min/Max Range is Absolute or Relative. Options are: ABST: Absolute or RLTV: Relative.
BASIS CODE Basis Code H Indicates whether the Target of the model is based on Percentage or on the quantity of Shares. Options are: PCT: Percent or SHR: Shares.
MIN/MAX RANGE Min/Max Range I Displays the Tolerance setting of the model. Options are: % of Model or Share.
MIN TARGET Min Target J Displays the user-entered value in the global Min Tolerance field on the Create Brokerage Model screen.
MAX TARGET Max Target K Displays the user-entered value in the global Max Tolerance field on the Create Brokerage Model screen.
LOG ACTION CODE Log Action Code L Displays the action performed on the model. Options are: CREATE, DELETE, SWAP, and EDIT.
MODEL VALID INDICATOR Model Valid Indicator M Indicates whether the model currently is valid and available for use. Options are: 0: Invalid or 1: Valid.
OLD MODEL NAME Old Model Name N Displays the previous name of the model (if renamed); otherwise <Null>.
CREATED BY Created By O Displays the name of the user who created the model.
IS_TEM_MODEL Is this a TEM Model? P Indicates if the model is a Workplace Investing 403(b)/401(k) model. Options are: 0: No, Brokerage Model or 1: Yes, Workplace Investing Model.
ACTION TIMESTAMP Action Timestamp Q Displays the timestamp associated with the Log Action Code. Format: MM/DD/YYYY HH:MM (24 Hour Clock).
ACCESS Access R Displays the type of access to the model. Options are Public or Private. NOTE: This column displays if entitled.
NODE ID Node Level S Displays the level of the node in the hierarchy.
LOGIN USER ID User ID T Displays the ID of the user who performed the action that was logged.
Top

modelElements.csv

Label Definition Excel Column Designation Description
AUDIT ID Audit ID A Displays a system-generated ID associated with the log entry.
LOG ID Log ID B Displays the system-generated ID associated with the model log entry.
FIRM ID Firm ID C Displays the ID of the firm associated with the individual who created/last edited the model.
MODEL NAME Model Name D Displays the name of the model.
MINIMUM VALUE Minimum Value E Displays the lowest percent or the lowest number of shares you do not want to go below (i.e., the lower threshold), for the listed Security or Model Element.
OR
For Workplace Investing models, displays the lowest percent you do not want to go below (i.e., the lower threshold), for the listed Fund.
MAXIMUM VALUE Maximum Value F Displays the highest percent or the highest number of shares you do not want to go above (i.e., the upper threshold), for the listed Security or Model Element.
OR
For Workplace Investing models, displays the highest percent you do not want to go above (i.e., the upper threshold), for the listed Fund.
TARGET VALUE Target Value G Displays the target percent or the target number of shares for the listed Security or Model Element.
OR
For Workplace Investing models, displays the target percent for the listed Fund.
MODEL INDICATOR Model Indicator H Indicates whether the model currently is valid and available for use. Options are: 0: Invalid or 1: Valid.
ELEMENT ID Element ID I If the Model Element is a Security, displays the security's CUSIP.
OR
If the Model Element is a Model, displays the system-generated ID of the model listed in the Child Model ID field.
SECURITY ID Security ID J If the Model Element is a Security, displays the security's CUSIP; else <Blank>.
OR
For Workplace Investing models, displays the fund's CUSIP.
CHILD MODEL ID Child Model ID K Displays the name of the sub-model associated with the model (if applicable). NOTE: Displays only for Composite Models.
LOG ACTION CODE Log Action Code L Displays the action performed on the model. Options are: CREATE, DELETE, SWAP, and EDIT.
NODE ID Node Level M Displays the level of the node in the hierarchy.
CHILD NODE ID Child Node Level N Displays the level of the child node in the hierarchy (if applicable); else displays <--->.
HIERARCHY ID Security’s Asset Class Hierarchy ID O Displays the Hierarchy ID to which the security belongs within the Asset Class model. NOTE: This information is not visible to the user.
SLEEVE MINIMUM VALUE Security’s Sleeve Minimum P Displays the security's sleeve minimum value. NOTE: This information is not visible to the user.
SLEEVE MAXIMUM VALUE Security’s Sleeve Maximum Q Displays the security's sleeve maximum value. NOTE: This information is not visible to the user.
SLEEVE TARGET VALUE Security’s Sleeve Target Value R Displays the user-entered sleeve target value, as displayed on the Create Asset Class Model screen.
RECLASSIFICATION Asset Class Reclassification Indicator S Indicates whether the security was reclassified. Options are 0: No or 1: Yes.
Top

modelAssignments.csv

Label Definition Excel Column Designation Description
LOG ID Log ID A Displays the system-generated ID associated with the model log entry.
FIRM ID Firm ID B Displays the ID of the firm associated with the individual who created/last edited the model.
MODEL NAME Model Name C Displays the name of the model.
ASSIGNMENT TYPE Assignment Type D Displays the assignment type of the model. Options are: A: Account, C: Client, and G: Group.
GROUP ID Group ID E If Assignment Type is G, displays the system-generated ID of the group assigned to the model; else displays 0.
CLIENT ID Client ID F If Assignment Type is C, displays the system-generated ID of the client assigned to the model; else displays 0.
ACCOUNT NAME Account Name G If Assignment Type is A, displays the number of the account assigned to the model; else <Blank>.
CUSTODIAN ID Custodian ID H Displays the custodian ID associated with the specified account. Options are: FID: Fidelity, and <Blank>: Other.
ACCOUNT SOURCE Account Source Code I If Assignment Type is A, displays a code that identifies the provider of the account information. Some of the options are: Fidelity Brokerage: Fidelity Brokerage Accounts, FPRS: Fidelity 403(b)/401(k) Accounts, NFS: National Financial Accounts, XAVNT: Advent, and BLKD: Black Diamond.
MODEL ASSIGNMENT ID Model Assignment ID J Displays a system-generated ID associated with the model assignment.
LOG ACTION CODE Log Action Code K Displays the action performed on the model. Options are: CREATE, DELETE, SWAP, and EDIT.
TIME STAMP Timestamp L Displays the timestamp associated with the Log Action Code. Format: MM/DD/YYYY HH:MM (24 Hour Clock).
USER ID User ID M Displays the ID of the user who performed the action that was logged.
NODE ID Node Level N Displays the level of the node in the hierarchy.
Top

modelAssignmentsHousehold.csv

Label Definition Excel Column Designation Description
AUDIT ID Audit ID A Displays the system-generated ID associated with the model log entry.
FIRM ID Firm ID B Displays the ID of the firm associated with the individual who created/last edited the model.
CLIENT ID Client ID C Displays the system generated numeric ID associated with the Client being assigned.
LOG ACTION CODE Log Action Code D Displays the action performed on the model. Options are: ADDED_HOUSEHOLD and REMOVED_HOUSEHOLD.
USER ID User ID E Displays the ID of the user who performed the action that was logged.
ACTION TIME STAMP Timestamp F Displays the timestamp associated with the Log Action Code. Format: MM/DD/YYYY HH:MM (24 Hour Clock).

Top

modelAssetClassifications.csv

Label Definition Excel Column Designation Description
AUDIT ID Audit ID A Displays the system-generated ID associated with the model log entry.
MODEL ID Model ID B Displays the system-generated ID associated with the model.
HIERARCHY ID Asset Class Hierarchy ID C Displays the Hierarchy ID for the Asset Class sleeve within the model. NOTE: This information is not visible to the user.
HIERARCHY PARENT ID Asset Class Hierarchy Parent ID D Displays the Hierarchy ID for the parent Asset Class sleeve, based on the model structure.
ASSET CLASS ID Asset Class ID E Displays the unique identifier for the Asset Class. NOTE: This information is not visible to the user.
LEVEL NUMBER Asset Class hierarchy level F Displays the level of the asset class hierarchy element. Lower numbers are the higher levels of the tree, with 1 always being the level of the Asset Mix.
LEAF INDICATOR Asset class hierarchy leaf node G Indicates that the asset class sleeve is a leaf node. Securities may only be placed in leaf nodes. Options are: TRUE and FALSE.
SLEEVE TARGET VALUE Asset Class Sleeve's Sleeve Target Value H Displays the user-entered sleeve target value, as displayed on the Create Asset Class Model screen.
SLEEVE MINIMUM VALUE Asset Mix Minimum I Displays the Asset Mix sleeve's sleeve minimum value, as entered by the user in the Minimum field in the Asset Mix section on the Create Asset Class Model screen.
SLEEVE MAXIMUM VALUE Asset Mix Maximum J Displays the Asset Mix sleeve's sleeve maximum value, as entered by the user in the Maximum field in the Asset Mix section on the Create Asset Class Model screen.
PORTFOLIO TARGET VALUE Asset Class Sleeve's portfolio target value K Displays the value in the Portfolio Target field on the Create Asset Class Model screen.
PORTFOLIO MINIMUM VALUE Asset Mix minimum value L Displays the Asset Mix sleeve's sleeve minimum value, as entered by the user in the Minimum field in the Asset Mix section on the Create Asset Class Model screen.
PORTFOLIO MAXIMUM VALUE Asset Mix maximum value M Displays the Asset Mix sleeve's sleeve maximum value, as entered by the user in the Maximum field in the Asset Mix section on the Create Asset Class Model screen.
ACTION TIMESTAMP Timestamp N Displays the timestamp associated with the Log Action Code. Format: MM/DD/YYYY HH:MM (24 Hour Clock).
LOG ACTION CODE Log Action Code O Displays the action performed on the model. Options are: CREATE, EDIT, and DELETE.
LOG USER ID User ID P Displays the ID of the user who performed the action that was logged.

871231.1.0

Top