RE_LS_TRM_ESC

(SQL Table)
Index Back

Lease Term Escalations

Lease Term Escalations

# 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 TERM_ID Number(10,0) DECIMAL(10) NOT NULL Financial Term ID
3 TERM_ESC_ID Number(10,0) DECIMAL(10) NOT NULL Term Escalation ID
4 EFFDT_FROM Date(10) DATE Effective Date From
5 EFFDT_TO Date(10) DATE Effective Date To
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: RE_LS_WRK.CURRENCY_CD

7 INDEX_BASIS_DATE Date(10) DATE Index Basis Date
8 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index

Prompt Table: RE_IDX_DEFN

9 ESC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Escalation Amount
10 ESC_CALC_MTHD Character(1) VARCHAR2(1) NOT NULL Escalation Calculation Method
1=Base Index
2=Last Index
11 MIN_ESC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Minimum Escalation Amount
12 MAX_AMT Number(27,3) DECIMAL(26,3) NOT NULL Maximum Amount
13 MIN_ESC_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Minimum Escalation Percentage
14 MAX_PCT Number(6,2) DECIMAL(5,2) NOT NULL Maximum Percent
15 RE_STEP_ESC_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Escalation Percentage

Default Value: 0

16 MIN_AMT Number(27,3) DECIMAL(26,3) NOT NULL Minimum Amount
17 MIN_PCT Number(6,2) DECIMAL(5,2) NOT NULL Minimum Percent
18 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
19 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
20 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
21 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.