RE_LS_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	LS_CLSE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Clause ID
3	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
4	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
5	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
6	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.
7	CLAUSE_CD	Character(10)	VARCHAR2(10) NOT NULL	Clause Type Code Prompt Table: RE_CLAUSE_TYPE
8	SCLAUSE_CD	Number(10,0)	DECIMAL(10) NOT NULL	Clause Sub-type Prompt Table: RE_CLAUSE_STYPE
9	CLSE_KEYWORD	Character(30)	VARCHAR2(30) NOT NULL	Clause Keyword
10	REFERENCE_TEXT	Character(30)	VARCHAR2(30) NOT NULL	Reference Text
11	DESCRLONG	Long Character	CLOB	Long Description
12	SELECT_CHKBOX	Character(1)	VARCHAR2(1) NOT NULL	Check Box Selection Y/N Table Edit Default Value: N
13	CLS_COMP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Clause Compliance Status 1=Incomplete 2=In Progress 3=Complete Default Value: 1
14	CLS_COMP_DEADLINE	Date(10)	DATE	Clause Compliance Deadline
15	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