| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
TEST
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
TEST
|
|
TEST
|
Test type.
|
VARCHAR2(63)
|
TEST
|
TEST
|
NO
|
NO
|
TEST
|
|
TEST_KEY
|
Key for the test dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
TEST
|
|
TEST_LD
|
Long description for the type of test.
|
VARCHAR2(255)
|
TEST
|
TEST_DESC
|
NO
|
NO
|
TEST
|
|
TEST_SCORE_RANGE
|
Range within the test score fits.
|
VARCHAR2(63)
|
TEST
|
TEST_SCORE
|
NO
|
NO
|
TEST
|
|
TEST_SCORE_RANGE_LD
|
Long description for the test score range.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
TEST
|
|
TEST_SCORE_RANGE_SD
|
Short description for the test score range.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
TEST
|
|
TEST_SD
|
Short description for the type of test.
|
VARCHAR2(255)
|
TEST
|
TEST_DESC
|
NO
|
NO
|
TEST
|
|
TEST_SOURCE
|
Test score source, or how the test score was entered. For example, magnetic tape, self-reported, etc.
|
VARCHAR2(63)
|
TEST
|
TEST_SOURCE
|
NO
|
NO
|
TEST
|
|
TEST_SOURCE_LD
|
Long description for the test source.
|
VARCHAR2(255)
|
TEST
|
TEST_SOURCE_DESC
|
NO
|
NO
|
TEST
|
|
TEST_SOURCE_SD
|
Short description for the test source.
|
VARCHAR2(255)
|
TEST
|
TEST_SOURCE_DESC
|
NO
|
NO
|
TEST
|