OPEXAUDIT_IDDefault Value: 0
REVISION_NBRDefault Value: 100
RE_OPEXADT_REV(SQL Table) |
Index Back |
|---|---|
OpexAudit RevisionOpexAudit Revision |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPEXAUDIT_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Primary Key for Operating Expense Audit (Auto Generated Number)
Default Value: 0 |
| 2 | REVISION_NBR |
Number(3,0) | SMALLINT NOT NULL | Sales Report Revision Number - Number (3) |
| 3 | OCCUPANCY_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL |
Occupancy Percentage.
Percent Period the Property was occupied during the Audit Period.
Default Value: 100 |
| 4 | NOTES_1000 | Long Character(1000) | VARCHAR2(1000) | Represents a field that allows free form text on the instrument definition panels. |
| 5 | SUBMIT_BY | Character(15) | VARCHAR2(15) NOT NULL | Submitted By |
| 6 | SUBMIT_DATE | DateTime(26) | TIMESTAMP | Submit Date |
| 7 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
| 8 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
| 9 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 10 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |