| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACCOUNT_DESCR
|
ACCOUNT DESCRIPTION
|
sourced from ODSMGR.OPERATING_LEDGER.ACCOUNT_DESC, ODSMGR.GENERAL_LEDGER.ACCOUNT_DESC
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
ACCOUNT_TYPE_LEVEL_1
|
ACCOUNT TYPE LEVEL 1
|
sourced from ODSMGR.OPERATING_LEDGER.ACCOUNT_TYPE_LEVEL_1 , ODSMGR.GENERAL_LEDGER.ACCOUNT_TYPE_LEVEL_1
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
ATTRIBUTE_TYPE
|
ATTRIBUTE TYPE
|
sourced from ODSMGR.ACCOUNT_ATTRIBUTES
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
ATTRIBUTE_VALUE
|
ATTRIBUTE VALUE
|
sourced from ODSMGR.ACCOUNT_ATTRIBUTES.ATTRIBUTE_VALUE
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
FISCAL_PERIOD
|
FISCAL PERIOD
|
sourced from ODSMGR.OPERATING_LEDGER, ODSMGR.GENERAL_LEDGER
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
FISCAL_YEAR
|
FISCAL YEAR
|
sourced from ODSMGR.OPERATING_LEDGER.FISCAL_YEAR, ODSMGR.GENERAL_LEDGER.FISCAL_YEAR
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
FUND
|
FUND
|
sourced from ODSMGR.OPERATING_LEDGER, ODSMGR.GENERAL_LEDGER
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
FUND_TYPE_DESC_1
|
FUND TYPE DESCRIPTION
|
sourced from ODSMGR.OPERATING_LEDGER.FUND_TYPE_DESC_1, ODSMGR.GENERAL_LEDGER.FUND_TYPE_DESC_1
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
LEDGER CODE
|
LEDGER CODE NUMBER
|
sourced from ODSMGR.OPERATING_LEDGER.CONSTANT, ODSMGR.GENERAL_LEDGER.CONSTANT
|
VARCHAR2 (2 CHAR)
|
|
|
|
|
LEDGER_ACCOUNT
|
LEDGER ACCOUNT
|
sourced from ODSMGR.OPERATING_LEDGER, ODSMGR.GENERAL_LEDGER.ACCOUNT
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
LINE_DESCRIPTION
|
LINE_DESCRIPTION
|
calculated from ODSMGR.OPERATING_LEDGER, ODSMGR.GENERAL_LEDGER,ODSMGR.ACCOUNT_ATTRIBUTES
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
LINE_DESCRIPTION
|
|
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
LINE_DESCRIPTION_TYPE
|
LINE DESCRIPTION TYPE
|
calculated from ODSMGR.OPERATING_LEDGER, ODSMGR.GENERAL_LEDGER, ODSMGR.ACCOUNT_ATTRIBUTES
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
LINE_REFERENCE
|
LINE REFERENCE
|
calculated from ODSMGR.OPERATING_LEDGER, ODSMGR.GENERAL_LEDGER,ODSMGR.ACCOUNT_ATTRIBUTES
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
LINE_SORT
|
LINE SORT
|
calculated from ODSMGR.OPERATING_LEDGER, ODSMGR.GENERAL_LEDGER,ODSMGR.ACCOUNT_ATTRIBUTES
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
ORG_CODE
|
ORGANIZATION CODE
|
sourced from ODSMGR.OPERATING_LEDGER.ORGANIZATION_CODE
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
ORG_DESCR
|
ORGANIZATION DESCRIPTION
|
sourced from ODSMGR.OPERATING_LEDGER.ORGANIZATION_DESC
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
PROGRAM_CODE
|
PROGRAM CODE
|
sourced from ODSMGR.OPERATING_LEDGER.PROGRAM_LEVEL_1
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
PROGRAM_CODE_LEVEL_2
|
PROGRAM CODE LEVEL 2
|
sourced from ODSMGR.OPERATING_LEDGER.PROGRAM_LEVEL_2
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
SUM_YEAR_TO_DATE_ACTIVITY
|
SUMMARY YEAR TO DATE ACTIVITY
|
sourced from ODSMGR.OPERATING_LEDGER.SUM_YEAR_TO_DATE_ACTIVITY
caluclated from ODSMGR.GENERAL_LEDGER
|
NUMBER
|
|
|
|