EXTERNAL CREDIT RULE Table
A dimension table for the External Test Credit Result Star Schema. It contains the credit rule names and categories.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CREDIT_RESULT_CATEGORY |
Credit rule category. Some of the categories are: 'IB' - international baccalaureate, 'AL' - GCE A-Level, 'AP' - Advanced Placement, 'TC' - Transfer Credit. |
VARCHAR2 |
2 |
CREDIT_RESULT_DESC |
Description of the credit result rule. |
VARCHAR2 |
50 |
CREDIT_RESULT_NAME |
Name of the credit result rule. |
VARCHAR2 |
20 |
EXTERNAL_CREDIT_RULE_KEY |
Use this field to join together the EXTERNAL CREDIT RULE and the EXTERNAL CREDIT RESULT DETAIL tables. |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |