EXTERNAL CREDIT GENERATED Table
View exposing generated external credit records associated with students, including recognized transfer, prior, or external academic credit used for student records reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPLY_CREDIT_MESSAGE |
Apply credit message associated with the record. |
VARCHAR2 |
150 |
APP_CREDIT_SUBJECT_CODE |
Code identifying app credit subject. |
VARCHAR2 |
20 |
APP_CREDIT_SUBJECT_NUMBER |
App credit subject number associated with the record. |
VARCHAR2 |
20 |
APP_CREDIT_UNITS |
App credit units associated with the record. |
VARCHAR2 |
20 |
CREDIT_RESULT_CATEGORY |
Credit result category associated with the record. |
VARCHAR2 |
2 |
CREDIT_RESULT_DESC |
Description of credit result. |
VARCHAR2 |
50 |
CREDIT_RESULT_NAME |
Credit result name associated with the record. |
VARCHAR2 |
20 |
CREDIT_RULE_DATE |
Date associated with credit rule. |
DATE |
|
EXTERNAL_CREDIT_GENERATED_KEY |
Surrogate key identifying the external credit generated. |
VARCHAR2 |
19 |
GEN_CREDIT_SUBJECT_CODE |
Code identifying gen credit subject. |
VARCHAR2 |
20 |
GEN_CREDIT_SUBJECT_NUMBER |
Gen credit subject number associated with the record. |
VARCHAR2 |
20 |
GEN_CREDIT_UNITS |
Gen credit units associated with the record. |
VARCHAR2 |
20 |
REG_SUBJECT_CODE |
Code identifying reg subject. |
VARCHAR2 |
3 |
REG_SUBJECT_NUMBER |
Reg subject number associated with the record. |
VARCHAR2 |
4 |
REG_UNITS |
Reg units associated with the record. |
NUMBER |
2 |
TRANSFER_CREDIT_SCHOOL_NAME |
Transfer credit school name associated with the record. |
VARCHAR2 |
100 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |