Package updates for Informatica conversion

Any datetime2 column needs to be cast in the framework manager package. We will only update the data items on the business layer.

To cast a field in a Cognos project/package, use the following function:

cast(<fieldname>, timestamp)

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:

Project Name	Used in Reports?	Assigned To?	Complete on dev?	Tested?	Comments
AP_Foreign_Payments	Yes	Matt
AP_Performance	Yes	Matt
DSS KFS v04	Yes	Scott
KFS Source System COA Lookup	Yes	Matt			Pointing to Oracle?
KFS_AP_NRAT	No	Eufemia			Not in production, yet. Report is in Ready for Test but no datetime2 columns.
KFS_Credit_Memo	Yes	Scott	Yes	Yes
KFS_Metadata		Durendal
KFS_PO	Yes	Matt
KFS_PO_PCard	No	Matt
KFS_SBS		Tammy
KFS_SMSFeed		Valerie
KFS_TEM	Yes	Scott	NA*	NA*	*no datetime2 columns in DSS_KFS table other than CREATED_EW_DTTM
KFSPOCODS_MDA		Durendal
KFSReconciliation		Tammy
Kuali_Disbursement	Yes	Scott	Yes	Yes
Kuali_USBank Card Transactions - Production v2	Yes	Eufemia			Does contain datetime2 columns
Kuali_Workflow	No, as far as we are aware	Eufemia			Pointing to KFSINT
Med_Cntr_Use_Tax	Yes	Eufemia
SCRENP GL Entry		Durendal
Fund Group Management		Durendal
KualiBudgetODSv2	Yes	Eufemia			Entries and Tracker

datetime2_columns_in_dss_kfs.xlsx