Budget DescrBudget NameBudget StatusBudget TypeBudget Version IdBudget Version NumLedger CodeLedger DescrLedger IdStatus Descr
| Business Data Model Data Model |
| Description | An entity that describes the details of a specific budget, its ledger code, description, and version information. |
| Attributes | |
| Budget Descr |
|
| Budget Name |
|
| Budget Status |
|
| Budget Type |
|
| Budget Version Id |
|
| Budget Version Num |
|
| Ledger Code |
|
| Ledger Descr |
|
| Ledger Id |
|
| Status Descr |
|
| Relationship | |
 Budget_Budget_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Budget Descr
| Description | Describes the general ledger budget. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Budget Name
| Description | Indicates the general ledger budget name. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Budget Status
| Description | Indicates the general ledger budget status. For example: Proposed Approved |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Budget Type
| Description | Indicates the general ledger budget type. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Budget Version Id
| Description | Indicates the general ledger budget Version ID. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Budget Version Num
| Description | Indicates the general ledger budget version number. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Ledger Code
| Description | Indicates the general ledger code. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Ledger Descr
| Description | Indicates the general ledger description text. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Ledger Id
| Description | Indicates the general ledger entry identifier. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Status Descr
| Description | Describes the general ledger budget status. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Budget_Budget_FK
| Description | A self-referencing fk allowing multiple Budget version tracking. |
| Is Identifying Relationship | false |
| Child Table | Budget |
| Child Role Name | version of |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Budget |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |