LESSORLEASE_IDAM_LEASE_SUM(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LESSOR |
Character(30) | VARCHAR2(30) NOT NULL | Lessor Name |
| 2 | LEASE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Lease ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | ASSET_COUNT | Number(5,0) | INTEGER NOT NULL | Count Work Field |
| 5 | EXPIRATION_DT | Date(10) | DATE | Expiration Date |
| 6 | RESPONSIBILITY | Character(30) | VARCHAR2(30) NOT NULL | Responsibility |
| 7 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 8 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |