RE_LS_TRM_ESC(SQL Table) |
Index Back |
---|---|
Lease Term EscalationsLease 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. |