Export to OCIUS File Layout

When the Export to OCIUS option is selected from the eSite—Processing menu, the system creates an export file and saves it to your output directory (C:\amsiweb\esiteweb\output). (Refer to the Export to OCIUS Tab.)

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
Property ID	Property Identification
PropertyName	Property Name
AddressLine1	Property Address Line 1
AddressLine2	Property Address Line 2
City	Property City
State	Property State
Zip	Property Zipcode

Column	Description
Property ID	Property Identification
Building ID	Building Identification
UnitID	Unit Identification
UnitNumber	Unit Code (as reference by property user) Note: UnitNumber will be the same as the UnitID.
UnitSqFt	Net Unit Square Feet

Column	Description
PropertyID	Property Identification Example: Property Number—123
BuildingID	Building Identification Example: Building Number—01
UnitID	Unit Identification Example: Unit Number—101
ResidentID	Resident Identification Example: Resident Number—001
BillingName	Resident Name
BillingAddress1	Resident Address—Line 1
BillingAddress2	Resident Address—Line 2
BillingCity	Resident Address—City
BillingState	Resident Address—State
BillingZipCode	Resident Address—Zip Code
LeaseBeginDate	Lease Start Date
LeaseEndDate	Lease End Date
MoveInDate	Move In Date
MoveOutDate	Move Out Date
LateDayOfMonth	Date Resident is Late Note: Specified, only if applicable.
LateChargeFixedAmount	Fixed Late Fee Note: Specified, only if applicable.
LateChargePerDay	Daily Late Fee
LateChargePercentage	Percentage Late Fee (if applicable)
CurrentBalance	Resident Current Ledger Balance
TotalPaid	Sum of Resident Payments for Last Calendar Month Note: This is the total amount paid for the Current Accounting Period.
OccupancyStatus	Resident Status Example: Applicant, Current, Previous, etc.
PermissionDate	Utility Start Date Note: This is the date the resident moved in.
NumberOfOccupants	Total Number of Occupants, including Resident

Column	Description
PropertyID	Property Identification Example: Property Number—123
BuildingID	Building Identification Example: Building Number—01
UnitID	Unit Identification Example: Unit Number—101
ResidentID	Resident Identification Example: Resident Number—001
ChargeCategory	Recurring Charge Code Note: This is the income code applied to the recurring charge amount.
ChargeDescription	Recurring Charge Description
ChargeAmount	Recurring Charge Amount
ChargeStartDate	Recurring Charge Start Date Note: This is the date the recurring charge starts being billed.
ChargeEndDate	Recurring Charge End Date Note: This is the date the recurring charge stops being billed.