EXTERNAL CREDIT SUBJECT Table
A dimension table for the External Test Credit Result Star Scema. It contains the generated, applied and registration subject codes and numbers for the credit results.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APP_CREDIT_SUBJECT_CODE |
Applied credit subject code. |
VARCHAR2 |
20 |
APP_CREDIT_SUBJECT_NUMBER |
The subject number in the applied credit subject. (Eg. "01" in the subject "18.01") |
VARCHAR2 |
20 |
EXTERNAL_CREDIT_SUBJECT_KEY |
Use this field to join together the EXTERNAL CREDIT RESULT DETAIL and the EXTERNAL CREDIT SUBJECT tables for the generated, applied and registrered subject information associated with the external test credit result. |
VARCHAR2 |
30 |
GEN_CREDIT_SUBJECT_CODE |
Generated credit subject code. |
VARCHAR2 |
20 |
GEN_CREDIT_SUBJECT_NUMBER |
The subject number in the generated credit subject. (Eg. "01" in the subject "18.01") |
VARCHAR2 |
20 |
REG_SUBJECT_CODE |
Registration subject code. This represents the subject code for applied credit in the student's academic record. |
VARCHAR2 |
3 |
REG_SUBJECT_NUMBER |
Registration subject number. This represents the subject number of a subject for applied credit in the student's academic record. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |