Export to RUBS File Layout

When the Export to RUBS option is selected from the eSite—Data Transfer menu, the system creates an export file and saves it to your output directory (C:\amsiweb\esiteweb\output). To avoid overwriting an existing file, the new file is given a unique file name that includes the user ID, file type, date, and time stamp, as follows:

Column	Description
Company	Company Identification Example: 01
Property	Property Identification Example: 001
CurrentPeriod	Current Period Example: YYYYMM

Column	Description
Company	Company Identification Example: Company Number—01
Property	Property Identification Example: Property Number—001
Building	Building Identification Example: Building Number—01
Unit	Unit Identification Example: Unit Number—101
ID	Resident Identification Example: Resident Number—01
Name	Resident Name Example: Green, William
Address	Resident Address—Line 1 Example: 1234 Oak Street Apt 101
City	Resident Address—City Example: Atlanta
State	Resident Address—State Example: GA
Zip	Resident Address—Zip Code Example: 12345
SQFT	Square footage Example: 950
Status	Status Example: C
MoveIn	Move In Date Example: MM/DD/YYYY
MoveOut	Move Out Date Note: MM/DD/YYYY
LeaseBegin	Date Lease Begins Example: MM/DD/YYYY
LeaseEnds	Fixed Late Fee Example: MM/DD/YYYY
Bedrooms	Number of bedrooms Example: 2