Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
ACCT
|
ACCOUNT
|
sourced from
ODSMGR.GENERAL_LEDGER.ACCOUNT
|
VARCHAR2 (63 CHAR)
|
|
|
|
ATTRIBUTE VALUE
|
Attribute Value
|
sourced from ODSMGR.ACCOUNT_ATTRIBUTES.ATTRIBUTE_VALUE
|
VARCHAR2 (63 CHAR)
|
|
|
|
COL REF
|
COLUMN DEFINITION
|
Organize Orgs and Funds into logic column groupings
derived from ODSMGR.ACCOUNT_ATTRIBUTES, ODSMGR.ORGANIZATION_LEVEL_8
|
VARCHAR2 (63 CHAR)
|
|
|
|
FISCAL PERIOD
|
FISCAL PERIOD
|
sourced from ODSMGR.GENERAL_LEDGER.FISCAL_PERIOD
|
VARCHAR2 (63 CHAR)
|
|
|
|
FISCAL YEAR
|
FISCAL YEAR
|
sourced from ODSMGR.GENERAL_LEDGER.FISCAL_YEAR
|
VARCHAR2 (63 CHAR)
|
|
|
|
FUND
|
FUND
|
sourced from ODSMGR.GENERAL_LEDGER.FUND
|
VARCHAR2 (63 CHAR)
|
|
|
|
LEDGER CODE
|
LEDGER CODE
|
sourced from ODSMGR.GENERAL_LEDGER.LEDGER
|
VARCHAR2 (2 CHAR)
|
|
|
|
LINE DESCRIPTION
|
LINE DESCRIPTION
|
Categorize attribute values into logical row descriptions.
derived from ODSMGR.ACCOUNT_ATTRIBUTES
|
VARCHAR2 (63 CHAR)
|
|
|
|
LINE DESCRIPTION TYPE
|
LINE DESCRIPTION TYPE
|
Category Revenues and Expenses
Sourced from ODSMGR.ACCOUNT_ATTRIBUTES
|
VARCHAR2 (63 CHAR)
|
|
|
|
LINE REF
|
LINE REFERENCE
|
derived form ODSMGR.ACCOUNT_ATTRIBUTES
SUBSTR(AATTR.ATTRIBUTE_VALUE,5,LENGTH(AATTR.ATTRIBUTE_VALUE))
|
VARCHAR2 (63 CHAR)
|
|
|
|
ORG LEVEL 8
|
ORGANIZATION LEVEL 8
|
sourced from ODSMGR.OPERATING_LEDGER.ORGANIZATION_LEVEL_8
|
VARCHAR2 (63 CHAR)
|
|
|
|
PRGM
|
PROGRAM
|
sourced from ODSMGR.OPERATING_LEDGER.PROGRAM
|
VARCHAR2 (63 CHAR)
|
|
|
|