Any datetime2 column needs to be cast in the framework manager package. We will only update the data items on the business layer.
Scott compiled a list of a columns that have the datetime2 datatype in dss_kfs (Informatica tables). We are unable to tell if a view is using a datetime2 column from the originating table, so we will have to manually check each one that is used by a package.
Columns to exclude:
created_ew_dttm - Not used in any reports
timestamp? - not sure if they are being used
List of projects in Framework Manager:
AP_Foreign_Payments
AP_Performance
DSS KFS v04
KFS Source System COA Lookup
KFS_AP_NRAT
KFS_Credit_Memo
KFS_Metadata
KFS_PO
KFS_PO_PCard
KFS_SBS
KFS_SMSFeed