'Who column' exclusions

CA TDM includes 'Who columns' (columns that refer to the creation of the data and and therefore do not create meaningful relationships with the data) in the Data Model, but only their foreign key relationships to the rest of the data are included in relationship discovery.
tdm46
CA TDM includes 'Who columns' (columns that refer to the creation of the data and and therefore do not create meaningful relationships with the data) in the Data Model, but only their foreign key relationships to the rest of the data are included in relationship discovery.
'Who columns' excluded from Relationship Discovery
The following columns refer only to the creation of data. Although CA TDM includes these columns in the Data Model, only their foreign key relationships to the rest of the model are included in relationship discovery:
Excluded columns
CREATIONDATE
CREATION_DATE
CREATED_BY
DATE_CREATED
CREATEDDATE
CREATED_DATE
ENDTIME
ENDDATE
ENDDATETIME
ENDTIMESTAMP
STARTTIME
STARTDATE
STARTDATETIME
STARTTIMESTAMP
DATE_UPDATED
UPDATEDDATE
UPDATED_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
UPDATED_BY
MODIFIEDDATE
MODIFIED_DATE
PROGRAM_CREATED
PROGRAM_UPDATED
WHO_CREATED
WHO_UPDATED
Making changes to the list of 'Who columns'
You can add entries to the 
gtrep_datamodel_who_columns 
table. CA TDM then excludes these entries from relationship discovery.
The
gtrep
depository contains system data. You should only make changes to the gtrep depository if you understand the risks of this action. Contact CA Support if you are unsure how to proceed.
Examples
  • Add 'MODIFIED_BY' column to list of WHO columns
    INSERT INTO gtrep_datamodel_who_columns values (15,'MODIFIED_BY');
    CA TDM excludes 'MODIFIED_BY' column from relationship discovery.
  • Update 'MODIFIEDDATE' column to 'MODIFIED_DATE'
    UPDATE gtrep_datamodel_who_columns set name = 'MODIFIED_DATE' where name = 'MODIFIEDDATE';
    CA TDM excludes 'MODIFIED_DATE' column from relationship discovery.
  • Delete 'MODIFIED_DATE' column from list of WHO columns
    DELETE FROM gtrep_datamodel_who_columns where name = 'MODIFIED_DATE';
    CA TDM does not excludes 'MODIFIED_DATE' column from relationship discovery.