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 | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |||
| CHANGE_DATE | Date() | DATE | Y | |||
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y |
User Fields: Allowed
Audit Logging: Allowed
