Database
Reports
PfDataFile

PfDataFile

Documentation for the PfDataFile database schema.

Fields

FieldData TypeUsage
companyIdObjectIdUnique reference to company.
original_filenameStringThe name or title of the pfdatafile.
filePathStringTimestamp/Date for filePath.
monthNumberStores the month data.
minNumberStores the min data.
maxNumberStores the max data.
yearNumberStores the year data.
establishmentIdStringUnique reference to establishment.
returnFileIdStringUnique reference to return File.
ecrNameStringThe name or title of the pfdatafile.
metadataMixedTimestamp/Date for metadata.
uploadedByObjectIdStores the uploaded by data.
uploadDateDateTimestamp/Date for uploadDate.
isDeletedBooleanStores the is deleted data.
statusBooleanTimestamp/Date for status.
deletedByObjectIdStores the deleted by data.
deletedTimeDateTimestamp/Date for deletedTime.