RE_LSA_CLSE

#	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_CLSE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Clause ID
4	UPDATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Update Flag 0=No Modification 1=Add 2=Change 3=Delete Default Value: 0
5	CLAUSE_CD	Character(10)	VARCHAR2(10) NOT NULL	Clause Type Code Prompt Table: RE_CLAUSE_TYPE
6	SCLAUSE_CD	Number(10,0)	DECIMAL(10) NOT NULL	Clause Sub-type Prompt Table: RE_CLAUSE_STYPE
7	CLSE_KEYWORD	Character(30)	VARCHAR2(30) NOT NULL	Clause Keyword
8	REFERENCE_TEXT	Character(30)	VARCHAR2(30) NOT NULL	Reference Text
9	DESCRLONG	Long Character	CLOB	Long Description
10	SELECT_CHKBOX	Character(1)	VARCHAR2(1) NOT NULL	Check Box Selection Y/N Table Edit Default Value: N
11	CLS_COMP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Clause Compliance Status 1=Incomplete 2=In Progress 3=Complete Default Value: 1
12	CLS_COMP_DEADLINE	Date(10)	DATE	Clause Compliance Deadline
13	CLS_COMP_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Clause Compliance Action 1=Notify Only 2=Notify and Hold Transactions 3=Notify and Dispute Lease Default Value: 1
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.