| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPEXAUDIT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Primary Key for Operating Expense Audit (Auto Generated Number)
|
| 2 |
REVISION_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Sales Report Revision Number - Number (3)
|
| 3 |
PRTA_BASIS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Prorata Basis ID
|
| 4 |
PRORATA_BASIS |
Character(10) |
VARCHAR2(10) NOT NULL |
Prorata Basis
|
| 5 |
TENANT_AREA |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Tenant Area
|
| 6 |
TOT_RENT_AREA |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Rentable Area
|
| 7 |
OCCUPIED_AREA |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Occupied Area
|
| 8 |
OCCUPANCY_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Occupancy Percentage.
Percent Period the Property was occupied during the Audit Period.
|
| 9 |
FLOOR_PERC |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Floor Percentage
|
| 10 |
PRORATA_SHARE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Prorata Share
|