AM_LEASE_SUMVW (SQL View)	Index Back
Lease End Summary View

AM_LEASE_SUMVW

(SQL View)

Lease End Summary View

SELECT LESSOR , %Abs(%datediff(%datepart(DTTM_STAMP),EXPIRATION_DT)) , DESCR , LEASE_ID , DTTM_STAMP FROM PS_AM_LEASE_SUM WHERE EXPIRATION_DT IS NOT NULL AND EXPIRATION_DT >= %CurrentDateIn AND %Abs(%datediff(%datepart(DTTM_STAMP),EXPIRATION_DT)) < 999

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LESSOR Character(30) VARCHAR2(30) NOT NULL Lessor Name

2 DAYS_BEFORE_END_DT Number(3,0) SMALLINT NOT NULL Days Before End Date

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 LEASE_ID Character(30) VARCHAR2(30) NOT NULL Lease ID

5 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LESSOR	Character(30)	VARCHAR2(30) NOT NULL	Lessor Name
2	DAYS_BEFORE_END_DT	Number(3,0)	SMALLINT NOT NULL	Days Before End Date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	LEASE_ID	Character(30)	VARCHAR2(30) NOT NULL	Lease ID
5	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.