RE_LS_PRFCTG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LS_NBR	Character(10)	VARCHAR2(10) NOT NULL	Lease Number, User Enterable or Generated Sequence Number
3	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
4	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
5	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
6	LEASE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Name
7	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
8	PROFILE_ID2	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID Prompt Table: RE_PRF_DVW
9	CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Asset Category
10	CATEGORY_2	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: RE_AM_CAT_DVW
11	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.
12	LEASE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Lease Status 1=Pending 2=Active 3=Canceled 4=Disputed 5=Expired 6=Holdover 7=Closed 8=Transferred
13	PRINCIPAL_ID	Character(15)	VARCHAR2(15) NOT NULL	Landlord/Tenant
14	LEASE_START_DT	Date(10)	DATE	Lease Start Date
15	LEASE_END_DT	Date(10)	DATE	Lease End Date
16	LS_ADMIN	Number(10,0)	DECIMAL(10) NOT NULL	Lease Administrator
17	PRTFL_MGR	Number(10,0)	DECIMAL(10) NOT NULL	Portfolio Manager
18	LSE_TYPE_CD	Character(10)	VARCHAR2(10) NOT NULL	This field contains the code for the Lease Types
19	RECOGNITION_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Exempt from Recognition Flag Y/N Table Edit