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.
...
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