We created metadata for a database and for some reason, the ...

[Diana Watkins]

We created metadata for a database and for some reason, the dates are 2 days off between the actual db table and the metadata.

For example, when you sql the table, the dates that return look like:

ENTRYID ADFACCIDENTDATE

7039 2020-12-08

7040 2020-12-08

7044 2020-12-07

The dates that return in WebFOCUS are:

ENTRYID ADFACCIDENTDATE

7039 2020/12/06

7040 2020/12/06

7044 2020/12/05

The date fields in the metadata table are set up as:

FIELDNAME=ADFACCIDENTDATE, ALIAS=ADFAccidentDate, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

So I am not sure what the issue could be. Usually if it is a format issue, the dates would be just completely wrong instead of consistently a couple of days off.

Any suggestions

[Martin Yergeau]

Look at you acx file to see where does it read from

You may have more than one master file defined which reside in a path that has priority on the one that you think that is used

Perform a WHENCE < yourMasterFileName > MASTER

This will tell you where the master file exist

[Toby Mills]

Hi Diana

That seems pretty odd - I could get it being off by up to 24 hours maybe just time zone differences or something.

As Martin said - see what the access (acx) file says.

Meantime, what type of database is this Just wondering what adapter youre using to reach it.

[Diana Watkins]

The WHENCE DM_ACCIDENT MASTER results are what I expected to see:

/home/iadminv82/ibi/apps/shipsdm/dm_accident.mas

The database is an SQL db, nothing out of the ordinary.

[Martin Yergeau]

Try creating back the master file dm_accident.mas

[Diana Watkins]

Hmmm no, I deleted and recreated & still get the same results.

[Martin Yergeau]

Can you share the acx, mas and the TABLE file used

Do you have a time zone defined in the RS Locale settings

[Diana Watkins]

Sorry, not familiar. Where would I go to check that

[Martin Yergeau]

If you have Admin access

 

image.png984615 179 KB

[Diana Watkins]

How do I get here I am on v8202M (sorry, should have specified)

[Diana Watkins]

I found LOCALE in the server console, but I dont see a setting for TIMEZONE

 

image.png432519 31.9 KB

[Martin Yergeau]

TimeZone has been intruduced in 8207 I think

Can you share the acx, mas and the TABLE FILE DM_ACCIDENT used

[Diana Watkins]

What is the best way to do that Sorry, I have only been using WF for a year & still learning

[Martin Yergeau]

Copy from text editor and paste here using the code tag, the sixth on the ribbon that look like </>

Or type (without spaces)

[ code ]

pasted your code in between

[/ code ]

[Diana Watkins]

DM_Accident.acx:

SEGNAME=DM_ACCIDENT,

TABLENAME=ShipsDM.dbo.DM_Accident,

CONNECTION=EBECON01,

KEY=ENTRYID, $

FIELD=ENTRYID,

AUTOINCREMENT=YES,

START=1,

INCREMENT=1, $

INDEX_NAME=PK_DM_Accident,

INDEX_UNIQUE=Y,

INDEX_COLUMN=EntryID,

INDEX_ORDER=ASC, $

DV_TEMPLATE=ADFREPORTCLOSEDDATE_YQMD,

BASE=ADFREPORTCLOSEDDATE,

DV_CAPTION=ADFREPORTCLOSEDDATE,Simple,

COMPONENTS=ADFREPORTCLOSEDDATE_YEAR/ADFREPORTCLOSEDDATE_QUARTER/ADFREPORTCLOSEDDATE_MONTH/ADFREPORTCLOSEDDATE_DAY, $

DV_TEMPLATE=ADFREPORTCLOSEDDATE_Y_YQMD,

BASE=ADFREPORTCLOSEDDATE,

DV_CAPTION=ADFREPORTCLOSEDDATE,Compound,

COMPONENTS=ADFREPORTCLOSEDDATE_YEAR_Y/ADFREPORTCLOSEDDATE_YEAR_Q/ADFREPORTCLOSEDDATE_YEAR_M/ADFREPORTCLOSEDDATE_YEAR_D, $

DV_TEMPLATE=ADFDRIVERDOB_YQMD,

BASE=ADFDRIVERDOB,

DV_CAPTION=ADFDRIVERDOB,Simple,

COMPONENTS=ADFDRIVERDOB_YEAR/ADFDRIVERDOB_QUARTER/ADFDRIVERDOB_MONTH/ADFDRIVERDOB_DAY, $

DV_TEMPLATE=ADFDRIVERDOB_Y_YQMD,

BASE=ADFDRIVERDOB,

DV_CAPTION=ADFDRIVERDOB,Compound,

COMPONENTS=ADFDRIVERDOB_YEAR_Y/ADFDRIVERDOB_YEAR_Q/ADFDRIVERDOB_YEAR_M/ADFDRIVERDOB_YEAR_D, $

DV_TEMPLATE=ADFDRIVERSTARTDATE_YQMD,

BASE=ADFDRIVERSTARTDATE,

DV_CAPTION=ADFDRIVERSTARTDATE,Simple,

COMPONENTS=ADFDRIVERSTARTDATE_YEAR/ADFDRIVERSTARTDATE_QUARTER/ADFDRIVERSTARTDATE_MONTH/ADFDRIVERSTARTDATE_DAY, $

DV_TEMPLATE=ADFDRIVERSTARTDATE_Y_YQMD,

BASE=ADFDRIVERSTARTDATE,

DV_CAPTION=ADFDRIVERSTARTDATE,Compound,

COMPONENTS=ADFDRIVERSTARTDATE_YEAR_Y/ADFDRIVERSTARTDATE_YEAR_Q/ADFDRIVERSTARTDATE_YEAR_M/ADFDRIVERSTARTDATE_YEAR_D, $

DV_TEMPLATE=DTDATECOMPLETED_YQMD,

BASE=DTDATECOMPLETED,

DV_CAPTION=DTDATECOMPLETED,Simple,

COMPONENTS=DTDATECOMPLETED_YEAR/DTDATECOMPLETED_QUARTER/DTDATECOMPLETED_MONTH/DTDATECOMPLETED_DAY, $

DV_TEMPLATE=DTDATECOMPLETED_Y_YQMD,

BASE=DTDATECOMPLETED,

DV_CAPTION=DTDATECOMPLETED,Compound,

COMPONENTS=DTDATECOMPLETED_YEAR_Y/DTDATECOMPLETED_YEAR_Q/DTDATECOMPLETED_YEAR_M/DTDATECOMPLETED_YEAR_D, $

DV_TEMPLATE=ADFTEMPBDAY_YQMD,

BASE=ADFTEMPBDAY,

DV_CAPTION=ADFTEMPBDAY,Simple,

COMPONENTS=ADFTEMPBDAY_YEAR/ADFTEMPBDAY_QUARTER/ADFTEMPBDAY_MONTH/ADFTEMPBDAY_DAY, $

DV_TEMPLATE=ADFTEMPBDAY_Y_YQMD,

BASE=ADFTEMPBDAY,

DV_CAPTION=ADFTEMPBDAY,Compound,

COMPONENTS=ADFTEMPBDAY_YEAR_Y/ADFTEMPBDAY_YEAR_Q/ADFTEMPBDAY_YEAR_M/ADFTEMPBDAY_YEAR_D, $

DV_TEMPLATE=ADFACCIDENTDATE_YQMD,

BASE=ADFACCIDENTDATE,

DV_CAPTION=ADFACCIDENTDATE,Simple,

COMPONENTS=ADFACCIDENTDATE_YEAR/ADFACCIDENTDATE_QUARTER/ADFACCIDENTDATE_MONTH/ADFACCIDENTDATE_DAY, $

DV_TEMPLATE=ADFACCIDENTDATE_Y_YQMD,

BASE=ADFACCIDENTDATE,

DV_CAPTION=ADFACCIDENTDATE,Compound,

COMPONENTS=ADFACCIDENTDATE_YEAR_Y/ADFACCIDENTDATE_YEAR_Q/ADFACCIDENTDATE_YEAR_M/ADFACCIDENTDATE_YEAR_D, $

DV_TEMPLATE=ADFCURRENTDATE_YQMD,

BASE=ADFCURRENTDATE,

DV_CAPTION=ADFCURRENTDATE,Simple,

COMPONENTS=ADFCURRENTDATE_YEAR/ADFCURRENTDATE_QUARTER/ADFCURRENTDATE_MONTH/ADFCURRENTDATE_DAY, $

DV_TEMPLATE=ADFCURRENTDATE_Y_YQMD,

BASE=ADFCURRENTDATE,

DV_CAPTION=ADFCURRENTDATE,Compound,

COMPONENTS=ADFCURRENTDATE_YEAR_Y/ADFCURRENTDATE_YEAR_Q/ADFCURRENTDATE_YEAR_M/ADFCURRENTDATE_YEAR_D, $

DV_TEMPLATE=ADFDATENOTIFIED_YQMD,

BASE=ADFDATENOTIFIED,

DV_CAPTION=ADFDATENOTIFIED,Simple,

COMPONENTS=ADFDATENOTIFIED_YEAR/ADFDATENOTIFIED_QUARTER/ADFDATENOTIFIED_MONTH/ADFDATENOTIFIED_DAY, $

DV_TEMPLATE=ADFDATENOTIFIED_Y_YQMD,

BASE=ADFDATENOTIFIED,

DV_CAPTION=ADFDATENOTIFIED,Compound,

COMPONENTS=ADFDATENOTIFIED_YEAR_Y/ADFDATENOTIFIED_YEAR_Q/ADFDATENOTIFIED_YEAR_M/ADFDATENOTIFIED_YEAR_D, $

DV_TEMPLATE=DASDATE_YQMD,

BASE=DASDATE,

DV_CAPTION=DASDATE,Simple,

COMPONENTS=DASDATE_YEAR/DASDATE_QUARTER/DASDATE_MONTH/DASDATE_DAY, $

DV_TEMPLATE=DASDATE_Y_YQMD,

BASE=DASDATE,

DV_CAPTION=DASDATE,Compound,

COMPONENTS=DASDATE_YEAR_Y/DASDATE_YEAR_Q/DASDATE_YEAR_M/DASDATE_YEAR_D, $

DV_TEMPLATE=ACEACCIDENTDATE_YQMD,

BASE=ACEACCIDENTDATE,

DV_CAPTION=ACEACCIDENTDATE,Simple,

COMPONENTS=ACEACCIDENTDATE_YEAR/ACEACCIDENTDATE_QUARTER/ACEACCIDENTDATE_MONTH/ACEACCIDENTDATE_DAY, $

DV_TEMPLATE=ACEACCIDENTDATE_Y_YQMD,

BASE=ACEACCIDENTDATE,

DV_CAPTION=ACEACCIDENTDATE,Compound,

COMPONENTS=ACEACCIDENTDATE_YEAR_Y/ACEACCIDENTDATE_YEAR_Q/ACEACCIDENTDATE_YEAR_M/ACEACCIDENTDATE_YEAR_D, $

DV_TEMPLATE=SELFPAIDSTATUS_YQMD,

BASE=SELFPAIDSTATUS,

DV_CAPTION=SELFPAIDSTATUS,Simple,

COMPONENTS=SELFPAIDSTATUS_YEAR/SELFPAIDSTATUS_QUARTER/SELFPAIDSTATUS_MONTH/SELFPAIDSTATUS_DAY, $

DV_TEMPLATE=SELFPAIDSTATUS_Y_YQMD,

BASE=SELFPAIDSTATUS,

DV_CAPTION=SELFPAIDSTATUS,Compound,

COMPONENTS=SELFPAIDSTATUS_YEAR_Y/SELFPAIDSTATUS_YEAR_Q/SELFPAIDSTATUS_YEAR_M/SELFPAIDSTATUS_YEAR_D, $

DV_TEMPLATE=DAAPPEALSIGDATA_DT_YQMD,

BASE=DAAPPEALSIGDATA_DT,

DV_CAPTION=DAAPPEALSIGDATA_DT,Simple,

COMPONENTS=DAAPPEALSIGDATA_DT_YEAR/DAAPPEALSIGDATA_DT_QUARTER/DAAPPEALSIGDATA_DT_MONTH/DAAPPEALSIGDATA_DT_DAY, $

DV_TEMPLATE=DAAPPEALSIGDATA_DT_Y_YQMD,

BASE=DAAPPEALSIGDATA_DT,

DV_CAPTION=DAAPPEALSIGDATA_DT,Compound,

COMPONENTS=DAAPPEALSIGDATA_DT_YEAR_Y/DAAPPEALSIGDATA_DT_YEAR_Q/DAAPPEALSIGDATA_DT_YEAR_M/DAAPPEALSIGDATA_DT_YEAR_D, $

DV_TEMPLATE=CITATIONDT_YQMD,

BASE=CITATIONDT,

DV_CAPTION=CITATIONDT,Simple,

COMPONENTS=CITATIONDT_YEAR/CITATIONDT_QUARTER/CITATIONDT_MONTH/CITATIONDT_DAY, $

DV_TEMPLATE=CITATIONDT_Y_YQMD,

BASE=CITATIONDT,

DV_CAPTION=CITATIONDT,Compound,

COMPONENTS=CITATIONDT_YEAR_Y/CITATIONDT_YEAR_Q/CITATIONDT_YEAR_M/CITATIONDT_YEAR_D, $

DV_TEMPLATE=DTENTERED_YQMD,

BASE=DTENTERED,

DV_CAPTION=DTENTERED,Simple,

COMPONENTS=DTENTERED_YEAR/DTENTERED_QUARTER/DTENTERED_MONTH/DTENTERED_DAY, $

DV_TEMPLATE=DTENTERED_Y_YQMD,

BASE=DTENTERED,

DV_CAPTION=DTENTERED,Compound,

COMPONENTS=DTENTERED_YEAR_Y/DTENTERED_YEAR_Q/DTENTERED_YEAR_M/DTENTERED_YEAR_D, $

[Diana Watkins]

DM_ACCIDENT.mas:

FILENAME=DM_ACCIDENT, SUFFIX=SQLMSS , $

SEGMENT=DM_ACCIDENT, SEGTYPE=S0, $

FIELDNAME=ENTRYID, ALIAS=EntryID, USAGE=I11, ACTUAL=I4, FIELDTYPE=R, $

FIELDNAME=USERID, ALIAS=UserID, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DRIVERID, ALIAS=DriverID, USAGE=I11, ACTUAL=I4,

MISSING=ON, $

FIELDNAME=DRIVERCODE, ALIAS=DriverCode, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=VALID, ALIAS=Valid, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFDOTREPORTABLE, ALIAS=ADFDOTReportable, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFACCIDENTNUM, ALIAS=ADFAccidentNum, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFINSURANCEFILENUM, ALIAS=ADFInsuranceFileNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPHOTOSRECEIVED, ALIAS=ADFPhotosReceived, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFREPORTSENTTONONTRUCK, ALIAS=ADFReportSentToNonTruck, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFREPORTSENT, ALIAS=ADFReportSent, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFSENDTONONTRUCKING, ALIAS=ADFSendToNonTrucking, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFNOPHOTOS, ALIAS=ADFNoPhotos, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFNOSTATEMENT, ALIAS=ADFNoStatement, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFREPORTCLOSED, ALIAS=ADFReportClosed, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFREPORTCLOSEDDATE, ALIAS=ADFReportClosedDate, USAGE=HYYMDs, ACTUAL=HYYMDs,

MISSING=ON, $

FIELDNAME=ADFREPORTCLOSEDBY, ALIAS=ADFReportClosedBy, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFREPORTFINAL, ALIAS=ADFReportFinal, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFSETUPDEDUCTIBLE, ALIAS=ADFSetUpDeductible, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFSENDTOINSURANCE, ALIAS=ADFSendToInsurance, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFHOLDOPEN, ALIAS=ADFHoldOpen, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFUNKNOWNCAUSE, ALIAS=ADFUnknownCause, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOSTCOMPLETE, ALIAS=ADFCostComplete, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDOCSRECEIVED, ALIAS=ADFDocsReceived, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFRELATIONSHIP, ALIAS=ADFRelationship, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERADDRESS, ALIAS=ADFDriverAddress, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERCELLPHONE, ALIAS=ADFDriverCellPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERCITY, ALIAS=ADFDriverCity, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERDOB, ALIAS=ADFDriverDOB, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=ADFDRIVERHOMEPHONE, ALIAS=ADFDriverHomePhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERSTARTDATE, ALIAS=ADFDriverStartDate, USAGE=HYYMDs, ACTUAL=HYYMDs,

MISSING=ON, $

FIELDNAME=ADFDRIVERSTATE, ALIAS=ADFDriverState, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERSTATEMENTRECEIVED, ALIAS=ADFDriverStatementReceived, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERPASSENGER, ALIAS=ADFDriverPassenger, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFDRIVERPASSENGERPHONE, ALIAS=ADFDriverPassengerPhone, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFDRIVERZIP, ALIAS=ADFDriverZip, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERTYPE, ALIAS=ADFDriverType, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERTERMINAL, ALIAS=ADFDriverTerminal, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERDIVISION, ALIAS=ADFDriverDivision, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERMANAGER, ALIAS=ADFDriverManager, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFDRIVERFLEET, ALIAS=ADFDriverFleet, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERFLEETMANAGER, ALIAS=ADFDriverFleetManager, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFFUELSPILL, ALIAS=ADFFuelSpill, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFHAZMATCHECK, ALIAS=ADFHazMatCheck, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFHAZMATSPILL, ALIAS=ADFHazMatSpill, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFHAZMATFILENUM, ALIAS=ADFHazMatFileNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDRIVERFULLNAME, ALIAS=ADFDriverFullName, USAGE=A150V, ACTUAL=A150V, $

FIELDNAME=ADFTIMENOTIFIED, ALIAS=ADFTimeNotified, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPREVSTATUS, ALIAS=ADFPrevStatus, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFVEHDMG, ALIAS=ADFVehDmg, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFPROPDMG, ALIAS=ADFPropDmg, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ADFLOCATION, ALIAS=ADFLocation, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DTCLINICADDRESS, ALIAS=DTClinicAddress, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DTCLINICPHONE, ALIAS=DTClinicPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DTCOMPANYCONTACTED, ALIAS=DTCompanyContacted, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DTDATECOMPLETED, ALIAS=DTDateCompleted, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=DTGENERALNOTES, ALIAS=DTGeneralNotes, USAGE=A1000V, ACTUAL=A1000V, $

FIELDNAME=TRIPNUM, ALIAS=TripNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TRUCKNUM, ALIAS=TruckNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFTEMPBDAY, ALIAS=ADFTempBDay, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=ADFACCIDENTDATE, ALIAS=ADFAccidentDate, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=ADFACCIDENTTIME, ALIAS=ADFAccidentTime, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFACCIDENTTIMEAMPM, ALIAS=ADFAccidentTimeAMPM, USAGE=A10V, ACTUAL=A10V, $

FIELDNAME=ADFACCIDENTTIMECALC, ALIAS=ADFAccidentTimeCalc, USAGE=HHISsm, ACTUAL=HHISsm,

MISSING=ON, $

FIELDNAME=ADFACCIDENTWEEKDAY, ALIAS=ADFAccidentWeekday, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCURRENTDATE, ALIAS=ADFCurrentDate, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=ADFDATENOTIFIED, ALIAS=ADFDateNotified, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=ADFLOCATIONCODE, ALIAS=ADFLocationCode, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFLOCATIONOFACCIDENT, ALIAS=ADFLocationOfAccident, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFLOCATIONNAME, ALIAS=ADFLocationName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFLOCATIONPHONE, ALIAS=ADFLocationPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPERSONREPORTING, ALIAS=ADFPersonReporting, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFINSUREDLOCADDY, ALIAS=ADFInsuredLocAddy, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFACCIDENTADDRESS, ALIAS=ADFAccidentAddress, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFACCIDENTCITY, ALIAS=ADFAccidentCity, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFACCIDENTSTATE, ALIAS=ADFAccidentState, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFACCIDENTZIP, ALIAS=ADFAccidentZip, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFAUTHORITIES, ALIAS=ADFAuthorities, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFREPORTNUM, ALIAS=ADFReportNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFOFFICERSNAME, ALIAS=ADFOfficersName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPOLICEPHONE, ALIAS=ADFPolicePhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFVIOLATIONSGIVEN, ALIAS=ADFViolationsGiven, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFNOCITATIONS, ALIAS=ADFNoCitations, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCITATIONTYPE, ALIAS=ADFCitationType, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFDESCRIPTION, ALIAS=ADFDescription, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=ADFCLEANUP, ALIAS=ADFCleanup, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCLEANUPPHONE, ALIAS=ADFCleanupPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEYEAR, ALIAS=ADFCompanyVehicleYear, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLETOWED, ALIAS=ADFCompanyVehicleTowed, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEMAKE, ALIAS=ADFCompanyVehicleMake, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEMODEL, ALIAS=ADFCompanyVehicleModel, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEOWNER, ALIAS=ADFCompanyVehicleOwner, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFCOMPANYVEHICLESTATE, ALIAS=ADFCompanyVehicleState, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEPLATE, ALIAS=ADFCompanyVehiclePlate, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEVIN, ALIAS=ADFCompanyVehicleVin, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEUNITNUM, ALIAS=ADFCompanyVehicleUnitNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TRAILERNUM, ALIAS=TrailerNum, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEUSE, ALIAS=ADFCompanyVehicleUse, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEOWNLEASE, ALIAS=ADFCompanyVehicleOwnLease, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEESTREPAIR, ALIAS=ADFCompanyVehicleEstRepair, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLESEEN, ALIAS=ADFCompanyVehicleSeen, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFCOMPANYVEHICLEDAMAGEDESC, ALIAS=ADFCompanyVehicleDamageDesc, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFPROPERTYDAMAGE, ALIAS=ADFPropertyDamage, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=ADFPROPERTYADDRESS, ALIAS=ADFPropertyAddress, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPROPERTYOWNER, ALIAS=ADFPropertyOwner, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPROPERTYPHONE, ALIAS=ADFPropertyPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPROPERTYCITY, ALIAS=ADFPropertyCity, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPROPERTYSTATE, ALIAS=ADFPropertyState, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPROPERTYZIP, ALIAS=ADFPropertyZip, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFOTHERPARTYOWNER, ALIAS=ADFOtherPartyOwner, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFOTHERPARTYPHONE, ALIAS=ADFOtherPartyPhone, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFOTHERPARTYCITY, ALIAS=ADFOtherPartyCity, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFOTHERPARTYPROPERTYDMG, ALIAS=ADFOtherPartyPropertyDmg, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFINJURIES, ALIAS=ADFInjuries, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFFATALITIES, ALIAS=ADFFatalities, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RMPADAATFATALITIES, ALIAS=RMPADAATFatalities, USAGE=I11, ACTUAL=I4, $

FIELDNAME=DASFIRSTNAME, ALIAS=DASFirstName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASLASTNAME, ALIAS=DASLastName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASCODRIVER, ALIAS=DASCoDriver, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASDATE, ALIAS=DASDate, USAGE=YYMD, ACTUAL=DATE,

MISSING=ON, $

FIELDNAME=DASTIME, ALIAS=DASTime, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASADDRESS, ALIAS=DASAddress, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=DASCITY, ALIAS=DASCity, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASSTATE, ALIAS=DASState, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASZIP, ALIAS=DASZip, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=DASUNITNUM, ALIAS=DASUni

[Diana Watkins]

FIELDNAME=RM_DRIVERDETAILS, ALIAS=RM_DriverDetails, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_MOTEL_HOSPITALINFO, ALIAS=RM_Motel_hospitalInfo, USAGE=A500V, ACTUAL=A500V, $

FIELDNAME=RM_AGENCYTYPE, ALIAS=RM_AgencyType, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_ERIREPORT, ALIAS=RM_ERIReport, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_ERIPHONE, ALIAS=RM_ERIPhone, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_AGENCYNAME, ALIAS=RM_AgencyName, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_OFFICERNAME, ALIAS=RM_OfficerName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_BADGE, ALIAS=RM_Badge, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_CITATIONISSUED, ALIAS=RM_CitationIssued, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_CITATIONDETAIL, ALIAS=RM_CitationDetail, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_ARREST, ALIAS=RM_Arrest, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_IMPOUND, ALIAS=RM_Impound, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_NOTES, ALIAS=RM_Notes, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=ADFCOMPANYVEHICLEUNITTOWED, ALIAS=ADFCompanyVehicleUnitTowed, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLECOSTCENTER, ALIAS=ADFCompanyVehicleCostCenter, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEDIVISION, ALIAS=ADFCompanyVehicleDivision, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEDAMAGEDETAIL, ALIAS=ADFCompanyVehicleDamageDetail, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFCOMPANYVEHICLEST, ALIAS=ADFCompanyVehicleST, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLETRAILERTOWED, ALIAS=ADFCompanyVehicleTrailerTowed, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEREPAIRCOST, ALIAS=ADFCompanyVehicleRepairCost, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEREPAIRPAID, ALIAS=ADFCompanyVehicleRepairPaid, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYVEHICLEREPAIRSUBRO, ALIAS=ADFCompanyVehicleRepairSubro, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYTRAILERREPAIRCOST, ALIAS=ADFCompanyTrailerRepairCost, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYTRAILERREPAIRPAID, ALIAS=ADFCompanyTrailerRepairPaid, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCOMPANYTRAILERREPAIRSUBRO, ALIAS=ADFCompanyTrailerRepairSubro, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TIVIN, ALIAS=TIVIN, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TIPLATE, ALIAS=TIPlate, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TIST, ALIAS=TIST, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TIDIVISION, ALIAS=TIDivision, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TICOSTCENTER, ALIAS=TICostCenter, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TITRAILERTOWED, ALIAS=TITrailerTowed, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TITRAILERDAMAGE, ALIAS=TITrailerDamage, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCARGOPHOTOS, ALIAS=ADFCargoPhotos, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCARGODAMAGED, ALIAS=ADFCargoDamaged, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFCARGODIVISION, ALIAS=ADFCargoDivision, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFWRECKERNEEDED, ALIAS=ADFWreckerNeeded, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFSAFETYPERSON, ALIAS=ADFSafetyPerson, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFOTHERVECHILEDAMAGED, ALIAS=ADFOtherVechileDamaged, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=ADFREPORTEDBY, ALIAS=ADFReportedBy, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RMCC, ALIAS=RMCC, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RMCO, ALIAS=RMCO, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_CARGODAMAGE, ALIAS=RM_CargoDamage, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=RM_BRIEFDESCRIPTION, ALIAS=RM_BriefDescription, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=RM_LANES, ALIAS=RM_Lanes, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_DAYSSINCELOSS, ALIAS=RM_DaysSinceLoss, USAGE=I11, ACTUAL=I4, FIELDTYPE=R,

MISSING=ON, $

FIELDNAME=RM_TYPEOFLOSS, ALIAS=RM_TypeofLoss, USAGE=A100V, ACTUAL=A100V, $

FIELDNAME=RM_DIRECTION, ALIAS=RM_Direction, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_TEST, ALIAS=RM_Test, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=ADFPHOTOS, ALIAS=ADFPhotos, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=RM_ALERTEMAILBODY, ALIAS=RM_AlertEmailBody, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=TPAADJUSTERNAME, ALIAS=TPAAdjusterName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TPAADJUSTEREMAIL, ALIAS=TPAAdjusterEmail, USAGE=A200V, ACTUAL=A200V, $

FIELDNAME=TPAADJUSTERPHONE, ALIAS=TPAAdjusterPhone, USAGE=A20V, ACTUAL=A20V, $

FIELDNAME=TPAADJUSTERFILENUMBER, ALIAS=TPAAdjusterFileNumber, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TPAADJUSTERCOMPANYNAME, ALIAS=TPAAdjusterCompanyName, USAGE=A50V, ACTUAL=A50V, $

FIELDNAME=TPAADJUSTERNOTES, ALIAS=TPAAdjusterNotes, USAGE=TX50, ACTUAL=TX, $

FIELDNAME=RISKTYPE01, ALIAS=RiskType01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE02, ALIAS=RiskType02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE03, ALIAS=RiskType03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE04, ALIAS=RiskType04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE05, ALIAS=RiskType05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE06, ALIAS=RiskType06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE07, ALIAS=RiskType07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RISKTYPE08, ALIAS=RiskType08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS01, ALIAS=InsuranceStatus01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS02, ALIAS=InsuranceStatus02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS03, ALIAS=InsuranceStatus03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS04, ALIAS=InsuranceStatus04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS05, ALIAS=InsuranceStatus05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS06, ALIAS=InsuranceStatus06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS07, ALIAS=InsuranceStatus07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=INSURANCESTATUS08, ALIAS=InsuranceStatus08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=LOADSHIFT, ALIAS=Loadshift, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE01, ALIAS=UnitDamage01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE02, ALIAS=UnitDamage02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE03, ALIAS=UnitDamage03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE04, ALIAS=UnitDamage04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE05, ALIAS=UnitDamage05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE06, ALIAS=UnitDamage06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE07, ALIAS=UnitDamage07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=UNITDAMAGE08, ALIAS=UnitDamage08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE01, ALIAS=TrailerDamage01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE02, ALIAS=TrailerDamage02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE03, ALIAS=TrailerDamage03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE04, ALIAS=TrailerDamage04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE05, ALIAS=TrailerDamage05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE06, ALIAS=TrailerDamage06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE07, ALIAS=TrailerDamage07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=TRAILERDAMAGE08, ALIAS=TrailerDamage08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION01, ALIAS=RoadCondition01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION02, ALIAS=RoadCondition02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION03, ALIAS=RoadCondition03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION04, ALIAS=RoadCondition04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION05, ALIAS=RoadCondition05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION06, ALIAS=RoadCondition06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION07, ALIAS=RoadCondition07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION08, ALIAS=RoadCondition08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION09, ALIAS=RoadCondition09, USAGE=I11, ACTUAL=I4, $

FIELDNAME=ROADCONDITION10, ALIAS=RoadCondition10, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION01, ALIAS=WeatherCondition01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION02, ALIAS=WeatherCondition02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION03, ALIAS=WeatherCondition03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION04, ALIAS=WeatherCondition04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION05, ALIAS=WeatherCondition05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION06, ALIAS=WeatherCondition06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION07, ALIAS=WeatherCondition07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION08, ALIAS=WeatherCondition08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION09, ALIAS=WeatherCondition09, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION10, ALIAS=WeatherCondition10, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION11, ALIAS=WeatherCondition11, USAGE=I11, ACTUAL=I4, $

FIELDNAME=WEATHERCONDITION12, ALIAS=WeatherCondition12, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING01, ALIAS=ReservesPending01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING02, ALIAS=ReservesPending02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING03, ALIAS=ReservesPending03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING04, ALIAS=ReservesPending04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING05, ALIAS=ReservesPending05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING06, ALIAS=ReservesPending06, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING07, ALIAS=ReservesPending07, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING08, ALIAS=ReservesPending08, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING09, ALIAS=ReservesPending09, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING10, ALIAS=ReservesPending10, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING11, ALIAS=ReservesPending11, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING12, ALIAS=ReservesPending12, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING13, ALIAS=ReservesPending13, USAGE=I11, ACTUAL=I4, $

FIELDNAME=RESERVESPENDING14, ALIAS=ReservesPending14, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE01, ALIAS=CargoDamage01, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE02, ALIAS=CargoDamage02, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE03, ALIAS=CargoDamage03, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE04, ALIAS=CargoDamage04, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE05, ALIAS=CargoDamage05, USAGE=I11, ACTUAL=I4, $

FIELDNAME=CARGODAMAGE06, ALIAS=CargoDamage06, USAGE=I11, A

[Diana Watkins]

Is that what you needed

[Martin Yergeau]

Asking back Toby question :

 

 

 

toby.mills:

 

Meantime, what type of database is this Just wondering what adapter youre using to reach it.

 

 

Is it as a simple SQL table . Is that a view

[Diana Watkins]

Those are the text views of the .acx & .mas for DM_Accident

[Toby Mills]

Hi Diana

I think what Martin is wonder is if TABLENAME=ShipsDM.dbo.DM_Accident is a sql server View or is that a table

I also have to ask if your other date fields are working okay

Thanks

[Martin Yergeau]

If you are performing a Data Sample on the master file, does ADFACCIDENTDATE display properly according to what you think it should be

Does the connection EBECON01 is pointing to the proper server/instance/db

[Diana Watkins]

Yes, sorry, TABLENAME=ShipsDM.dbo.DM_Accident is a table. When I generate sample data the results are the same - the date is 2 days off. The EBECON01 is pointing to the proper server instance - we have other applications pointing to that adapter as well and they are just fine.

I did do some more poking around and there are other dates within that table formatted as HYYMDs - those dates are correct. I tried reformatting the ones that are YYMD to HYYMDs but got the same results.

[Toby Mills]

Thats interesting too. If other dates are working and this one is not, that says theres something special about it.

I think Id start by narrowing down your Master file to temporarily get rid of all your DEFINE fields.

The goal is to make it as simple as possible.

Make a simple fex that returns just a few records so you can see if it matches what youre seeing with SQL Server Management Studio.

Next capture your generated SQL just to see if theres anything odd there.

Let me see if I remember the commands for that from memory:

SET TRACEALL=OFF

SET TRACEUSER=CLIENT

SET TRACEON=STMTRACE//CLIENT

SET TRACESTAMP=OFF

then

TABLE FILE DM_ACCIDENT

PRINT

ENTRYID

ADFACCIDENTDATE

-* Id also add a known good date field for comparison

DTDATECOMPLETED

WHERE ENTRYID EQ 7039

END

The hope is for you to just get a simple result. Grab the generated SQL and copy/paste it into SQL Server Management Studio.

If you still give different values (which it sounds like you will), then youve got a nice tidy reproduction of your issue to open a case with.

Let us know how that little test goes.

[Diana Watkins]

Good afternoon Toby,

Yeah, ran that little test and got the same results. WF shows the dates to b 2 days earlier than the actual date. I turned in a case with Tibco so maybe they can be of assistance.

Thanks so much!