FRC COGNOS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_AMOUNT |
The paid dollar amount of the line item. |
NUMBER |
13,2 |
CALENDAR_PERIOD_DESCRIPTION |
Text associated with CALENDAR_PERIOD (Example: January 1996, October 1999). |
VARCHAR2 |
30 |
COST_COLLECTOR_ID |
7-digit number which uniquely identifies the Cost Collector. |
VARCHAR2 |
7 |
COST_COLLECTOR_NAME |
The name of the Cost Collector. |
VARCHAR2 |
40 |
COST_OBJECT_ID_NAME |
XXX |
VARCHAR2 |
50 |
COUPA_NUMBER |
XXX |
VARCHAR2 |
35 |
DOCUMENT_DATE |
The date entered by the user when creating the document. Generally the date the financial transaction occurred, but see also the definition for document line date. |
DATE |
|
DOCUMENT_LINE_ITEM |
Document Line Item Number. |
NUMBER |
|
DOCUMENT_NUMBER |
The number in SAP that uniquely identifies a detailed transaction document. |
VARCHAR2 |
10 |
DOCUMENT_TYPE_DESC |
XXX |
VARCHAR2 |
26 |
DOCUMENT_TYPE_DESCRIPTION |
Text describing what the document is (Example: Alumni Credit Memo, Asset Posting, Customer Document, Accounting Document, etc.?) |
VARCHAR2 |
20 |
DOCUMENT_TYPE_ID |
2 characters which are used to identify the type of document (Example: A1 - Alumni Credit Memo, AA - Asset Posting, DA - Customer Document, AB - Accounting Document, etc.?) |
VARCHAR2 |
3 |
FINANCIAL_DETAIL_KEY |
XXX |
VARCHAR2 |
17 |
FISCAL_PERIOD |
The fiscal year and month. For example: 199709 = March 1997. |
VARCHAR2 |
6 |
GL_ACCOUNT_ID |
Identifies the GL Account. |
VARCHAR2 |
6 |
GL_ACCOUNT_ID_NAME |
XXX |
VARCHAR2 |
59 |
GL_ACCOUNT_NAME |
The text name associated with the GL_ACCOUNT_ID. For example: Telephone-Data Facilities, Materials and Services, and outside purchases. |
VARCHAR2 |
50 |
GL_CATEGORY |
XXX |
VARCHAR2 |
40 |
GL_CATEGORY_SORT |
XXX |
NUMBER |
6 |
HIGH_RISK |
XXX |
VARCHAR2 |
1 |
IS_BLANKET_PO |
XXX |
VARCHAR2 |
1 |
IS_DOC_TYPE_SA |
XXX |
VARCHAR2 |
1 |
IS_DOC_TYPE_SI |
XXX |
VARCHAR2 |
1 |
IS_EQUIPMENT |
XXX |
VARCHAR2 |
1 |
IS_OVER_LIMIT |
XXX |
VARCHAR2 |
1 |
IS_SELECTED_FOR_FRC_REVIEW |
XXX |
VARCHAR2 |
1 |
IS_UNALLOWABLE_GL_POSTING |
XXX |
VARCHAR2 |
1 |
LINE_ITEM_DISPLAY_TEXT |
XXX |
VARCHAR2 |
120 |
PROFIT_CENTER_ID |
A unique key that identifies the profit center. |
VARCHAR2 |
7 |
PURCHASE_ORDER_NUMBER |
Identifies the purchase order. In SAP this is the Document Number for a Purchasing Document. |
VARCHAR2 |
10 |
REFERENCE |
XXX |
VARCHAR2 |
30 |
REVIEW_ITEM |
XXX |
CHAR |
|
STATUS |
In the GRADUATE APPOINTMENT TYPE table, this field indicates the status of the appointment: whether Cancelled or Actual. In the ALUMNI BY COURSE table, this field carries one of these statuses: "Active", "Lost", "Purgable" regarding the MIT alumnus/alumnae. |
VARCHAR2 |
25 |
SUPERVISOR |
The name of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
30 |
SUPERVISOR_MIT_ID |
The 9 digit MIT identification number of the person responsible for this project, cost center, internal order, or cost center. |
VARCHAR2 |
9 |
TOTAL_ACTUAL_AMOUNT |
XXX |
NUMBER |
13,2 |
TRANSACTION_DETAIL |
XXX |
VARCHAR2 |
144 |
TRANSACTION_TYPE |
Type of transactions in Request Tracker. |
VARCHAR2 |
7 |
TRANSACTION_TYPE_DESC |
XXX |
VARCHAR2 |
50 |
USE_FRC_ROLE_FLAG |
XXX |
VARCHAR2 |
1 |