RE_LSA_OPX_CAP(SQL Table) |
Index Back |
|---|
| # | 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 | TERM_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Financial Term ID |
| 4 | UPDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Update Flag
0=No Modification 1=Add 2=Change 3=Delete Default Value: 0 |
| 5 | CAP_APPLIED_TO | Character(1) | VARCHAR2(1) NOT NULL |
CAP Applied To
1=Landlord Expense 2=Tenant Share Default Value: 2 |
| 6 | CAP_APPLIED | Character(1) | VARCHAR2(1) NOT NULL |
CAP Applied
1=After Fee 2=Before Fee Default Value: 2 |
| 7 | CAP_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
CAP Basis
1=Prior Year Restricted 2=Prior Year Actuals Default Value: 1 |
| 8 | SBSQ_YR_CAP_COMP | Character(1) | VARCHAR2(1) NOT NULL |
CAP Compare To
1=Base 2=Last Default Value: 1 |
| 9 | SBSQ_YR_CAP_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Subsequent Year CAP Method
1=Percent 2=Index 3=Lesser of Percent and Index 4=None Default Value: 3 |
| 10 | SBSQ_YR_CAP_PERC | Number(6,2) | DECIMAL(5,2) NOT NULL | Subsequent Year CAP Percentage |
| 11 | SBSQ_YR_CAP_INDEX | Character(10) | VARCHAR2(10) NOT NULL |
Subsequent Year CAP Index
Prompt Table: RE_IDX_DEFN |
| 12 | SBSQ_YR_MIN_COMP | Character(1) | VARCHAR2(1) NOT NULL |
Min Compare To
1=Base 2=Last Default Value: 1 |
| 13 | SBSQ_YR_MIN_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Subsequent Yar MIN Method
1=Percent 2=Index 3=Lesser of Percent and Index 4=None Default Value: 3 |
| 14 | SBSQ_YR_MIN_PERC | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Subsequent Year MIN Percentage |
| 15 | SBSQ_YR_MIN_INDEX | Character(10) | VARCHAR2(10) NOT NULL |
Subsequent Year MIN Index
Prompt Table: RE_IDX_DEFN |
| 16 | NOTES_1000 | Long Character(1000) | VARCHAR2(1000) | Represents a field that allows free form text on the instrument definition panels. |