RE_PROPERTY_LG

(SQL View)

SELECT PROPERTY_ID ,LANGUAGE_CD ,PROPERTY_NM ,PROPERTY_DESCR FROM PS_ASSET_PROP_LG

Related Language Record for RE_PROPERTY RE_PROP_AREA_NM RE_PROP_BLDG_NM RE_PROP_FLOR_NM RE_PROP_SITE_NM RE_PROP_SPC_NM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Property ID

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 PROPERTY_NM Character(50) VARCHAR2(50) NOT NULL Used to store an Asset Property Name

4 PROPERTY_DESCR Character(50) VARCHAR2(50) NOT NULL Property Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROPERTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Property ID
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	PROPERTY_NM	Character(50)	VARCHAR2(50) NOT NULL	Used to store an Asset Property Name
4	PROPERTY_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Property Description