OSP ORGANIZATION AUDIT Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AUDIT_ACCEPTED |
XXX |
VARCHAR2 |
3 |
AUDIT_COMMENT |
XXX |
VARCHAR2 |
300 |
FISCAL_YEAR |
The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998) |
VARCHAR2 |
4 |
ORGANIZATION_ID |
The department, for example, Accounting. |
VARCHAR2 |
8 |
UPDATE_TIMESTAMP |
Date that a record was last updated by OSP. |
DATE |
|
UPDATE_USER |
Userid of the person who last updated this record. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |