RE_LSA_OPTION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
2	AMND_NBR	Number(3,0)	SMALLINT NOT NULL	Amendment Number
3	LS_OPTION_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Lease Option Sequence Key
4	UPDATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Update Flag 0=No Modification 1=Add 2=Change 3=Delete Default Value: 0
5	OPT_DATE	Date(10)	DATE	Option Date
6	OPT_EFFDT	Date(10)	DATE	Option EffectivevDate
7	START_DT	Date(10)	DATE	Start Date
8	OPT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Option Status 2=Inactive 3=Active 4=Expired Default Value: 2
9	ENABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag indicates whether this row is enabled or not. Y/N Table Edit Default Value: N
10	OPTION_CD	Character(20)	VARCHAR2(20) NOT NULL	This is used as a Key in the RE_LSE_OPTION record Prompt Table: RE_OPTION
11	SCHEDULE_KEY	Number(10,0)	DECIMAL(10) NOT NULL	Schedule key Prompt Table: RE_OPT_SCHED
12	MESSAGE_TEXT_254	Character(254)	VARCHAR2(254) NOT NULL	Message Text
13	DESCRLONG	Long Character	CLOB	Long Description
14	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
15	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
16	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
17	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.