| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACCOUNT DESCRIPTION
|
ACCOUNT DESCRIPTION
|
sourced from ODSMGR.OPERATING_LEDGER.ACCOUNT_DESC_4
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
ACCT
|
ACCOUNT
|
source from ODSMGR.OPERATING_LEDGER.ACCOUNT
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
ATTRIBUTE VALUE
|
ATTRIBUTE VALUE
|
sourced from ODSMGR.ACCOUNT_ATTRIBUTES.ATTRIBUTE_VALUE
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
COL REF
|
Col Def
|
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.OPERATING_LEDGER.FISCAL_PERIOD
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
FISCAL YEAR
|
FISCAL YEAR
|
sourced from ODSMGR.OPERATING_LEDGER.FISCAL_YEAR
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
FUND
|
FUND
|
sourced from ODSMGR.OPERATING_LEDGER.FUND
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
LEDGER CODE
|
LEDGER CODE
|
sourced from ODSMGR.OPERATING_LEDGER.LEDGER_CODE
|
VARCHAR2 (2 CHAR)
|
|
|
|
|
LINE DESCRIPTION
|
LINE DESCRIPTION
|
Categorize attribute values into logical row descriptions
sourced from ODSMGR.ACCOUNT_ATTRIBUTES
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
LINE DESCRIPTION TYPE
|
LINE DESCRIPTION TYPE
|
Category Revenues and Expenses
source code ODSMGR.ACCOUNT_ATTRIBUTES
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
LINE REF
|
LINE REFERENCE
|
derived from ODSMGR.ACCOUNT_ATTRIBUTES
SUBSTR(AATTR.ATTRIBUTE_VALUE,5,LENGTH(AATTR.ATTRIBUTE_VALUE))
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
ORG LEVEL 8
|
ORGANIZATION LEVEL 8
|
source from ODSMGR.OPERATING_LEDGER.ORGANIZATION_LEVEL_8
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
PRGM
|
PROGRAM
|
sourced from ODSMGR.OPERATING_LEDGER.PROGRAM
|
VARCHAR2 (63 CHAR)
|
|
|
|