RE_AM_GU_RES_VW

(SQL View)
 Index Back

Term Distribution

Term Distribution

SELECT A.LS_KEY , A.AMND_NBR , A.ASSET_SEQ_NBR , A.PROPERTY_ID , A.BUSINESS_UNIT_AM , A.LS_MAP_ID , A.RATE_MULT , A.RATE_DIV , A.CF_SEQNO , SUM(A.AMOUNT_ALLOC_GUAR) FROM PS_RE_LSA_PPTY A WHERE A.AMND_NBR = ( SELECT MAX(X.AMND_NBR) FROM PS_RE_LSA_PPTY X WHERE A.BUSINESS_UNIT_AM = X.BUSINESS_UNIT_AM AND A.ASSET_ID = X.ASSET_ID ) GROUP BY LS_KEY , A.AMND_NBR , A.ASSET_SEQ_NBR , A.PROPERTY_ID , A.BUSINESS_UNIT_AM , A.LS_MAP_ID , A.RATE_MULT , A.RATE_DIV , A.CF_SEQNO UNION SELECT A.LS_KEY , A.AMND_NBR , A.ASSET_SEQ_NBR , A.PROPERTY_ID , A.BUSINESS_UNIT_AM , A.LS_MAP_ID , B.RATE_MULT , B.RATE_DIV , A.CF_SEQNO , SUM(A.AMOUNT_ALLOC_GUAR) FROM PS_RE_LSA_AST_DST A , PS_RE_LSA_PPTY B WHERE A.LS_KEY = B.LS_KEY AND A.AMND_NBR = B.AMND_NBR AND A.ASSET_SEQ_NBR = B.ASSET_SEQ_NBR AND A.PROPERTY_ID = B.PROPERTY_ID AND B.AMND_NBR = ( SELECT MAX(X.AMND_NBR) FROM PS_RE_LSA_PPTY X WHERE B.BUSINESS_UNIT_AM = X.BUSINESS_UNIT_AM AND B.ASSET_ID = X.ASSET_ID ) GROUP BY A.LS_KEY , A.AMND_NBR , A.ASSET_SEQ_NBR , A.PROPERTY_ID , A.BUSINESS_UNIT_AM , A.LS_MAP_ID , B.RATE_MULT , B.RATE_DIV , A.CF_SEQNO

# 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 ASSET_SEQ_NBR Number(5,0) INTEGER NOT NULL Asset Sequence Number
4 PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Property ID
5 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
6 LS_MAP_ID Character(12) VARCHAR2(12) NOT NULL Field For Lease Map ID
7 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
8 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
9 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
10 AMOUNT_ALLOC_GUAR Signed Number(28,3) DECIMAL(26,3) NOT NULL Allocated Guar Residual