RE_SITE_ATTR

(SQL Table)
Index Back

Maintain Site Attribute

Maintain Site Attribute Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 SITE_TYPE Character(3) VARCHAR2(3) NOT NULL Site Type

Prompt Table: RE_SITE_TYPE_VW

3 SPACE_UOM Character(3) VARCHAR2(3) NOT NULL Space Unit of measure (Sq Feet or Sq Meters)

Default Value: 1

Prompt Table: UNITS_TBL

4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: USD

Prompt Table: CURRENCY_CD_TBL

5 DISTANCE_TYPE Character(1) VARCHAR2(1) NOT NULL Distance Type
3=Metres
K=Kilometers
M=Miles

Default Value: K

6 LENGTH_UM Character(3) VARCHAR2(3) NOT NULL Asset Length Unit of Measure

Prompt Table: UNITS_TBL

7 HEIGHT_UM Character(3) VARCHAR2(3) NOT NULL Asset Height Unit of Measure

Prompt Table: UNITS_TBL

8 WIDTH_UM Character(3) VARCHAR2(3) NOT NULL Asset Width Unit of Measure

Prompt Table: UNITS_TBL

9 WEIGHTAGE Number(6,2) DECIMAL(5,2) NOT NULL Supplemental Data Weighting

Default Value: 1