SING CONSOLIDATED Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ANNUAL_BUDGET_SGD |
XXX |
NUMBER |
|
ANNUAL_BUDGET_USD |
XXX |
NUMBER |
|
CATEGORY |
Reports grouped together by similar type within a Business Area. One report may appear in more than one Category. |
VARCHAR2 |
50 |
COMMITMENTS_SGD |
XXX |
NUMBER |
|
COMMITMENTS_USD |
XXX |
NUMBER |
|
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 |
7 |
COST_OBJECT_KEY |
XXX |
VARCHAR2 |
12 |
COST_OBJECT_NAME |
XXX |
VARCHAR2 |
40 |
CUMULATIVE_BUDGET_SGD |
XXX |
NUMBER |
|
CUMULATIVE_BUDGET_USD |
XXX |
NUMBER |
|
FILE_LOAD_DATE |
XXX |
DATE |
|
GL_ACCOUNT_ID |
Identifies the GL Account. |
VARCHAR2 |
6 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
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 |
IRG |
XXX |
VARCHAR2 |
50 |
PI |
XXX |
VARCHAR2 |
90 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |