Alias: DGFD#
Unique Keys: _Child Table: _
Parent Table: _
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | Y | |
| DGF_ID | Number(10) | ID | Y | link to P2K_CM_GL_FUNDS |
| MUC_ID | Number(10) | ID | link to P2K_AM_USER_CALCS | |
| START_DATE | Date() | DATE | Y | |
| END_DATE | Date() | DATE | Y | |
| FUND_TYPE | Varchar2(2) | X_FUND_TYPE | ||
| GRANT_CODE | Varchar2(16) | CODE | ||
| GRANT_TYPE | Varchar2(2) | X_GRANT_TYPE | ||
| PROGRAM_CODE | Varchar2(16) | CODE | ||
| PROGRAM_DESC | Varchar2(50) | VARCHAR50 | ||
| ACTIVITY_CODE | Varchar2(16) | CODE | ||
| ACCOUNT_MANAGER | Varchar2(50) | VARCHAR50 | ||
| RESPONSIBLE_PERSON | Varchar2(50) | VARCHAR50 | ||
| FUND_CALC_METHOD | Varchar2(2) | X_FUND_CALC_METHOD | ||
| LAST_EVAL_DATE | Date() | DATE | ||
| FUND_GIVEN | Number(18) | AMT12V6 | ||
| FUND_ACTUAL | Number(18) | AMT12V6 | ||
| FUND_BALANCE | Number(18) | AMT12V6 | ||
| BALANCE_TO_COMPLETE | Number(18) | AMT12V6 | ||
| BALANCE_SENT_TODATE | Number(18) | AMT12V6 | ||
| CREATE_DATE | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y |
Derived Fields#
| Column Name |
|---|
| DRV_AS_OF_DATE |
User Fields: Allowed
Audit Logging: Allowed
