Table Columns#
| Column name | Data Type / Size | Mand. | Notes |
|---|---|---|---|
| ID | Number(10) | Used internally to define a unique identification for the record. This field would not be loaded. | |
| GL_FUND_CODE | Varchar2(16) | Y | |
| DESCRIPTION | Varchar2(50) | ||
| ENTITY_CODE | Varchar2(16) | Y | |
| DEPARTMENT_CODE | Varchar2(16) | ||
| DISTRIBUTION_MASK | Varchar2(50) | ||
| GL_SEGMENT_NUMBER | Number(5) | ||
| LEVEL_OF_SEG_TOTAL | Number(5) | ||
| START_DATE | Date() | Y | |
| END_DATE | Date() | ||
| PROGRAM_CODE | Varchar2(16) | ||
| PROGRAM_DESC | Varchar2(50) | ||
| FUND_TYPE | Varchar2(30) | ||
| GRANT_CODE | Varchar2(16) | ||
| GRANT_TYPE | Varchar2(30) | ||
| ACTIVITY_CODE | Varchar2(16) | ||
| ACCOUNT_MANAGER | Varchar2(50) | ||
| RESPONSIBLE_PERSON | Varchar2(50) | ||
| FUND_CALC_METHOD | Varchar2(30) | ||
| USER_CALC_CODE | Varchar2(16) | ||
| USER_NAME | Varchar2(30) | ||
| LAST_EVAL_DATE | Date() | ||
| FUND_GIVEN | Number(18) | ||
| FUND_ACTUAL | Number(18) | ||
| FUND_BALANCE | Number(18) | ||
| BALANCE_TO_COMPLETE | Number(18) | ||
| BALANCE_SENT_TODATE | Number(18) | ||
| FUND_ELEMENT_CODE1 | Varchar2(16) | ||
| FUND_ELEMENT_TYPE1 | Varchar2(30) | ||
| FUND_ELEMENT_DESCRIPTION1 | Varchar2(50) | ||
| FUND_ELEMENT_AMOUNT1 | Number(18) | ||
| FUND_ELEMENT_CODE2 | Varchar2(16) | ||
| FUND_ELEMENT_TYPE2 | Varchar2(30) | ||
| FUND_ELEMENT_DESCRIPTION2 | Varchar2(50) | ||
| FUND_ELEMENT_AMOUNT2 | Number(18) | ||
| FUND_ELEMENT_CODE3 | Varchar2(16) | ||
| FUND_ELEMENT_TYPE3 | Varchar2(30) | ||
| FUND_ELEMENT_DESCRIPTION3 | Varchar2(50) | ||
| FUND_ELEMENT_AMOUNT3 | Number(18) | ||
| CREATE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CREATE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CHANGE_DATE | Date() | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. | |
| CHANGE_USER | Varchar2(30) | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |
