RE_LS_TRM_ESC(SQL Table) |
Index Back |
|---|---|
Lease Term EscalationsLease Term Escalations |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key | |
| 2 | Number(10,0) | DECIMAL(10) NOT NULL | Financial Term ID | |
| 3 | 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. |