| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SITE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 2 |
SITE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Site Type
|
| 3 |
SITE_NAME |
Character(125) |
VARCHAR2(125) NOT NULL |
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 5 |
PROPERTY_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary Use
1=Residential
2=Serviced Apartments
3=Apartment
4=Individual
5=Mixed Use
6=Commercial
7=Retail
8=Warehouse
9=Other
|
| 6 |
MANAGER_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Manager Rating
1=Good
2=Average
3=Excellent
4=Fair
5=Poor
|
| 7 |
OWNERSHIP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Ownership Type
1=Leased
2=Owned
3=Rent
4=Sale
Default Value: 1
|
| 8 |
LOCATION_TYPE |
Character(60) |
VARCHAR2(60) NOT NULL |
Location Type
1=R-3
2=DR-1
3=R-2
|
| 9 |
LOCATION_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Location Rating
1=Good
2=Average
3=Excellent
4=Fair
5=Poor
|
| 10 |
ADA_COMPLIANT |
Character(1) |
VARCHAR2(1) NOT NULL |
ADA compliant
Y/N Table Edit
|
| 11 |
OFFERED_BY |
Character(60) |
VARCHAR2(60) NOT NULL |
Offered By
|
| 12 |
SITE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Site Status
1=New
2=Open
3=Evaluating
4=Negotiating
5=Operating
6=Disposed
7=Archived
Default Value: 1
|
| 13 |
PROPERTY_OWNER |
Character(60) |
VARCHAR2(60) NOT NULL |
Property Owner
|
| 14 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 15 |
PROPERTY_MNGR |
Character(60) |
VARCHAR2(60) NOT NULL |
Property Manager
|
| 16 |
OCCPNT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Occupant Name
|
| 17 |
PRINCIPAL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Landlord/Tenant
|
| 18 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 19 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 20 |
DESCR150_MIXED |
Character(150) |
VARCHAR2(150) NOT NULL |
Description
|
| 21 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 22 |
LATITUDE |
Signed Number(12,7) |
DECIMAL(10,7) NOT NULL |
Latitude
|
| 23 |
LONGITUDE |
Signed Number(12,7) |
DECIMAL(10,7) NOT NULL |
Longitude
|
| 24 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 25 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 26 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 27 |
TAX_AUTHORITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Authority
|
| 28 |
TAX_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Group
|
| 29 |
PARCEL_NUMBER |
Character(30) |
VARCHAR2(30) NOT NULL |
Parcel Number
|
| 30 |
ANCHR_100FT |
Number(3,0) |
SMALLINT NOT NULL |
Anchor 100 Feet
|
| 31 |
ANCHR_250FT |
Number(3,0) |
SMALLINT NOT NULL |
Anchor 250 Feet
|
| 32 |
ANCHR_500FT |
Number(3,0) |
SMALLINT NOT NULL |
Anchor 500 Feet
|
| 33 |
DIST_COMPTOR |
Number(14,3) |
DECIMAL(13,3) NOT NULL |
Nearest Competitor
|
| 34 |
DIST_COMPANY |
Number(14,3) |
DECIMAL(13,3) NOT NULL |
Nearest Company Office
|
| 35 |
HVAC_CONDITION |
Character(1) |
VARCHAR2(1) NOT NULL |
HVAC Condition
1=Good
2=Average
3=Excellent
4=Fair
5=Poor
|
| 36 |
FLOOR_LEVELS |
Number(3,0) |
SMALLINT NOT NULL |
Floor Levels
|
| 37 |
AUDIT_DATE |
Date(10) |
DATE |
Audit Report Date
|
| 38 |
CLOSING_COSTS |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Closing Costs
|
| 39 |
DEPOSIT_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Deposit Amount
|
| 40 |
EST_ANNL_UTIL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Annual Utilities
|
| 41 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 42 |
LOC_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Accessibility
1=Good
2=Average
3=Excellent
4=Fair
5=Poor
|
| 43 |
LOC_VISIBILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Visibility
1=Excellent
2=Good
3=Average
4=Fair
5=Poor
|
| 44 |
ADJ_USES |
Character(30) |
VARCHAR2(30) NOT NULL |
Adjacent Uses
1=Excellent
2=Good
3=Average
4=Fair
5=Poor
|
| 45 |
LOC_QUALITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Neighborhood Quality
1=Excellent
2=Good
3=Average
4=Fair
5=Poor
|
| 46 |
PROPERTY_AGE |
Number(4,0) |
SMALLINT NOT NULL |
Property Age
|
| 47 |
PROP_CONDITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Property Condition
1=Good
2=Average
3=Excellent
4=Fair
5=Poor
|
| 48 |
RISK_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Risk Category
1=Maximum
2=High
3=Medium
4=Low
5=Minimum
|
| 49 |
SITE_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Site Access
1=24 Hours
2=Business Hours only
|
| 50 |
CONSTR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Construction Type
1=Steel
2=Wood
3=Other
|
| 51 |
CONSTR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Construction Year
|
| 52 |
RENOV_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Renovation Year
|
| 53 |
OPER_HOURS |
Character(30) |
VARCHAR2(30) NOT NULL |
Operating Hours
|
| 54 |
OPER_DAYS |
Character(30) |
VARCHAR2(30) NOT NULL |
Operating Days
|
| 55 |
UTIL_CONDITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Utilities Condition
1=Good
2=Average
3=Excellent
4=Fair
5=Poor
|
| 56 |
WIRE_CONDITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Wire Condition
1=Good
2=Average
3=Excellent
4=Fair
5=Poor
|
| 57 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 58 |
REGION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table:
RE_REGION
|
| 59 |
MAX_OCCUPANCY |
Number(8,0) |
INTEGER NOT NULL |
Maximum Occupancy
|
| 60 |
TOTAL_AREA |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Total Area
|
| 61 |
PPTY_RENT_AREA |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Property Rentable Area
|
| 62 |
PPTY_USE_AREA |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Property Usable Area
|
| 63 |
PARKING_NOS |
Number(5,0) |
INTEGER NOT NULL |
No. of Parking Spaces
|
| 64 |
ELEV_NOS |
Number(5,0) |
INTEGER NOT NULL |
No. of Elevators
|
| 65 |
STAIR_NOS |
Number(5,0) |
INTEGER NOT NULL |
No. of Stairs
|
| 66 |
FLOOR_NOS |
Number(3,0) |
SMALLINT NOT NULL |
No. of Floors
|
| 67 |
PLOT_SIZE |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Plot Size
|
| 68 |
SPACE_DIV |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Space Divisible
|
| 69 |
CEILING_HT |
Number(18,3) |
DECIMAL(17,3) NOT NULL |
Ceiling Height
|
| 70 |
AVAIL_DATE |
Date(10) |
DATE |
Availability Date
|
| 71 |
SIGNED_DT |
Date(10) |
DATE |
Signed Date
|
| 72 |
LEASE_START_DT |
Date(10) |
DATE |
Lease Start Date
|
| 73 |
LEASE_END_DT |
Date(10) |
DATE |
Lease End Date
|
| 74 |
LEASE_TERM |
Number(6,0) |
INTEGER NOT NULL |
Lease Term (Periods)
|
| 75 |
OCCUPANCY_DT |
Date(10) |
DATE |
Occupancy Date
|
| 76 |
OPEN_DT |
Date(10) |
DATE |
Date Opened
|
| 77 |
AUDIT_DT |
Date(10) |
DATE |
Date of Audit
|
| 78 |
RENEW_OPTION |
Date(10) |
DATE |
Option to Renew
|
| 79 |
SURRENDER_DT |
Date(10) |
DATE |
Surrender Date
|
| 80 |
CONSTR_DT |
Date(10) |
DATE |
Construction Date
|
| 81 |
FOLLOWUP_DT |
Date(10) |
DATE |
Follow-up Date
|
| 82 |
ALLOW_DUE_DT |
Date(10) |
DATE |
Allowance Due Date
|
| 83 |
ALLOW_RECV_DT |
Date(10) |
DATE |
Allowance Received Date
|
| 84 |
CONSTR_APPR_DT |
Date(10) |
DATE |
Construction Approval Date
|
| 85 |
MTM_LEASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Month to Month Lease
|
| 86 |
CONSTR_COST |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Construction Cost
|
| 87 |
REMODAL_COST |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Remodel Costs
|
| 88 |
ORIG_SELL_PRICE |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Original Selling Price
|
| 89 |
CURR_SELL_PRICE |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Current Selling Price
|
| 90 |
UNIT_PRICE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Unit Price
|
| 91 |
RENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Rent Amount
|
| 92 |
ANN_OPEX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Annual Operating Expenses
|
| 93 |
DEPOSIT_AMT |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Deposit Amount
|
| 94 |
EST_SALES_TOT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Annual Sales
|
| 95 |
TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 96 |
EST_ANNL_INSURE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Annual Insurance
|
| 97 |
EST_ANNL_MAINT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Annual Maintenance
|
| 98 |
TENANT_ALLOW |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tenant Allowance
|
| 99 |
COMM_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Commission %
|
| 100 |
SALE_PRICE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The sales price for a buy/sellback transaction.
|
| 101 |
APPRAISED_VAL |
Number(30,3) |
DECIMAL(29,3) NOT NULL |
Appraised Value
|
| 102 |
ADMIN_FEE_PERC |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Admin Fee Percentage
|
| 103 |
WEIGHTAGE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Weighting
|
| 104 |
PRINCIPAL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Landlord/Tenant
|