DataExport_SharedGrantLink

The SharedGrantLink Data Export for the UsageSharedGrantLink table in Usage databases is available through the E-Support website. This data export will produce a zip file containing an ASCII file (.csv).  This ASCII/csv file will contain the full contents of the UsageSharedGrantLink table from the selected usage database according to the standard SharedGrantLink Data Export.

The file naming convention for the SharedGrantLink Export is as follows:

• With date and time stamp:

  • SGL###_[CustID]_[ dbName]_yyyymmdd_HHMM.zip

  • SGL###_[CustID]_[ dbName]_yyyymmdd_HHMM.csv

• Without date and time stamp:

  • SGL###_[CustID]_[ dbName].zip

  • SGL###_[CustID]_[ dbName].csv

The ### is a unique ID to denote which specific Data Export it is, and will be the same if the same Data Export is chosen.

• “SGL100” will be the file prefix if for the standard SharedGrantLink Data Export on CostGuard versions 9.07x and above

• “SGL101” will be the file prefix if for the standard SharedGrantLink Data Export on CostGuard pre-9.07 versions

The two tables below indicate the exported record format for 9.07x and above and pre-9.07 and below CostGuard Usage files according to the standard SharedGrantLink Data Export.

SharedGrantLink (9.07x) file format  (SGL100)

Sharedgrantlink (Pre-9.07) file format (SGL101)