FRC RISKS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
The total actual dollar amount charged for the fiscal period or periods selected. In GRADUATE AWARDS, this field contains the graduate award (RA, TA, etc.) amount. |
NUMBER |
15,2 |
COST_COLLECTOR_ID |
7-digit number which uniquely identifies the Cost Collector. |
VARCHAR2 |
12 |
COST_OBJECT |
a seven digit number used to categorize the costs and revenues associated with a particular project or activity at MIT; The terms cost object and cost collector are used interchangeably. |
VARCHAR2 |
22 |
DOCUMENT_LINE_ITEM |
Document Line Item Number. |
NUMBER |
|
DOCUMENT_NUMBER |
The number in SAP that uniquely identifies a detailed transaction document. |
VARCHAR2 |
10 |
FINANCIAL_DETAIL_KEY |
XXX |
VARCHAR2 |
20 |
FISCAL_PERIOD |
The fiscal year and month. For example: 199709 = March 1997. |
VARCHAR2 |
2 |
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 |
FRC_RISK |
XXX |
VARCHAR2 |
10 |
FRC_RISK_REASON |
XXX |
VARCHAR2 |
50 |
REFERENCE_DOCUMENT_ITEM |
XXX |
NUMBER |
|
REFERENCE_DOCUMENT_NUMBER |
For FINANCIAL_DETAIL: The reference number of the associated financial document. A value of %N means that there is no backup for the journal voucher. For COMMITMENT tables, the document number from which the commitment was generated. |
VARCHAR2 |
10 |
RE_ID |
XXX |
VARCHAR2 |
14 |
WAREHOUSE_INSERT_TIMESTAMP |
XXX |
DATE |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
XXX |
DATE |