| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
FUNDING_PURPOSE
|
General funding area supported by one or more designations.
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_KEY
|
|
NUMBER
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_LD
|
Funding purpose long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_LEVEL_1
|
Funding purpose level one used for hierarchical reporting.
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_LEVEL_1_LD
|
Funding purpose level one long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_LEVEL_1_SD
|
Funding purpose level one short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_LEVEL_2
|
Funding purpose level two used for hierarchical reporting.
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_LEVEL_2_LD
|
Funding purpose level two long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_LEVEL_2_SD
|
Funding purpose level two short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_LEVEL_3
|
Funding purposed level three used for hierarchical reporting.
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_LEVEL_3_LD
|
Funding purpose level three long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_LEVEL_3_SD
|
Funding purpose level two three description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_SD
|
Funding purpose short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_TYPE
|
An overall grouping mechanism for one or more funding purposes.
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_TYPE_LD
|
Funding purpose type long description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
FUNDING_PURPOSE_TYPE_SD
|
Funding purpose type short description.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_01
|
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_01_LD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_01_SD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_02
|
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_02_LD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_02_SD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_03
|
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_03_LD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_03_SD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_04
|
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_04_LD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_04_SD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_05
|
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_05_LD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
USER_ATTRIBUTE_05_SD
|
|
VARCHAR2(255)
|
|
|
|
NO
|
|