EXTERNAL CREDIT GENERATED Table
This table "integrates" the test scores with the credit results generated. Join this table with the EXTERNAL TEST SCORE DETAIL table to get the credit results generated from the tests.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
APPLY_CREDIT_MESSAGE |
Message/note associated with an applied credit. Some of the more common messages are: "No credit because registered for subject" (ie. the student is qualifed for a generated and an applied credit for the subject but did not get a credit because he had already registered for the subject.) and "Credit was manually applied" (ie. the credit was manually applied, and in this case, the APP CREDIT SUBJECT CODE field usually contains the value 'APPL', and the APP CREDIT SUBJECT NUMBER field contains a 'MAN'). |
VARCHAR2 |
150 |
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 |
APP_CREDIT_UNITS |
Applied credit units. |
VARCHAR2 |
20 |
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 |
CREDIT_RULE_DATE |
Date when the credit rule was last updated. |
DATE |
8 |
EXTERNAL_CREDIT_GENERATED_KEY |
Use this field to join together the EXTERNAL CREDIT GENERATED and the EXTERNAL TEST SCORE DETAIL tables for the credits that are associated (generated and/or applied) with the external tests. |
VARCHAR2 |
19 |
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 |
GEN_CREDIT_UNITS |
Generated credit units. |
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 |
REG_UNITS |
Number of registration units for the applied credit in the student's academic record. |
NUMBER |
2 |
TRANSFER_CREDIT_SCHOOL_NAME |
The name of the school from where the transfer credit is granted. |
VARCHAR2 |
100 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |