Reviewing the Academic Advisement Analysis Database Tables
At a minimum, tables from the analysis database always contain these column headings: ID, RPT_DATE, RPT_TYPE, and ANALYSIS_DB_SEQ.
The following describes the table R_REPORT:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
WHAT_IF_FL |
NA |
Char |
1 |
What-If Flag |
REPORT_REQUEST_NBR |
NA |
Char |
9 |
Report Request Nbr |
INSTITUTION |
NA |
Char |
5 |
Academic Institution |
TSCRPT_TYPE |
NA |
Char |
5 |
Transcript Type |
The following describes the table, R_ORDER:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
ENTRY_R_TYPE |
NA |
Char |
6 |
Valid Types: Career ('KEYCAR'), Program ('KEYPRG'), Plan ('KEYPLN'), Sub-Plan ('KEYSUB'), Requirement Group ('KEYRQG'), Requirement ('KEYREQ'), and Requirement Line ('KEYRQL'). |
The following describes the table, R_RQRMNT_GROUP:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
RQ_DATE |
NA |
PSDATE |
NA |
Effective Date of Requirement Group |
ENTRY_R_STATUS |
NA |
Char |
4 |
None |
PARTITION_FAIL |
NA |
Char |
1 |
Partition Fail Flag |
The following describes the table, R_RG_LINK:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
The following describes the table, R_TRANSCRIPT:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
CRSE_TAG |
Y |
Char |
4 |
None |
INSTITUTION |
NA |
Char |
5 |
None |
SRC_INSTITUTION |
NA |
Char |
5 |
None |
ACAD_CAREER |
NA |
Char |
4 |
None |
SRC_CAREER |
NA |
Char |
4 |
None |
CRSE_CAREER |
NA |
Char |
4 |
None |
STRM |
NA |
Char |
4 |
Term |
APPLIED_TERM |
NA |
Char |
4 |
None |
TERM_TAKEN |
NA |
Char |
4 |
None |
CLASS_NBR |
NA |
Char |
5 |
None |
STDNT_ENRL_STATUS |
NA |
Char |
2 |
None |
UNT_TAKEN |
NA |
Decimal |
3.2 |
None |
UNT_PRGRSS |
NA |
Decimal |
3.2 |
None |
GRADING_BASIS_ENRL |
NA |
Char |
3 |
None |
CRSE_GRADE_OFF |
NA |
Char |
3 |
None |
REPEAT_CODE |
NA |
Char |
4 |
None |
ASSOCIATED_CLASS |
NA |
Smallint |
4 |
None |
AUDIT_GRADE_BASIS |
NA |
Char |
1 |
None |
EARN_CREDIT |
NA |
Char |
1 |
None |
INCLUDE_IN_GPA |
NA |
Char |
1 |
None |
UNITS_ATTEMPTED |
NA |
Char |
1 |
Valid Choices: In Progress ('I') and Attempted ('Y'). |
GRADE_POINTS |
NA |
Decimal |
6.3 |
None |
CRSE_ID |
NA |
Char |
6 |
None |
CRSE_OFFER_NBR |
NA |
Char |
2 |
None |
SESSION_CODE |
NA |
Char |
3 |
None |
CLASS_SECTION |
NA |
Char |
4 |
None |
ACAD_GROUP |
NA |
Char |
5 |
None |
SUBJECT |
NA |
Char |
8 |
None |
CATALOG_NBR |
NA |
Char |
10 |
None |
DESCR |
NA |
Char |
30 |
None |
COMPONENT |
NA |
Char |
3 |
None |
CRS_TOPIC_ID |
NA |
Decimal |
3 |
None |
EQUIV_CRSE_ID |
NA |
Char |
5 |
None |
OVRD_CRSE_EQUIV_ID |
NA |
Char |
1 |
None |
START_DT |
NA |
PSDATE |
NA |
None |
END_DT |
NA |
PSDATE |
NA |
None |
CRSE_COUNT |
NA |
Decimal |
2.2 |
None |
CLASS_ENRL_TYPE |
NA |
Char |
1 |
None |
RQ_SCHOOL_TYPE |
NA |
Char |
4 |
None |
UNT_EARNED |
NA |
Decimal |
3.2 |
None |
The following describes the table, R_SUBSTITUTION:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
CRSE_TAG |
Y |
Char |
4 |
None |
ACAD_GROUP |
NA |
Char |
5 |
None |
CRSE_ID |
NA |
Char |
6 |
None |
SUBJECT |
NA |
Char |
8 |
None |
CATALOG_NBR |
NA |
Char |
10 |
None |
DESCR |
NA |
Char |
30 |
None |
OPRID |
NA |
Char |
8 |
None |
DESCR254A |
NA |
Char |
254 |
None |
The following describes the table, R_REQUIREMENT:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
REQUIREMENT |
Y |
Char |
9 |
None |
RQ_DATE |
NA |
PSDATE |
NA |
Effective Date of Student's Requirement |
ITEM_R_STATUS |
NA |
Char |
4 |
None |
PARTITION_FAIL |
NA |
Char |
1 |
Partition Fail Flag |
The following describes the table, R_RQRMNT_LINE:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
REQUIREMENT |
Y |
Char |
9 |
None |
RQ_LINE_NBR |
Y |
Char |
4 |
None |
ITEM_R_STATUS |
NA |
Char |
4 |
None |
DISP_SELECT_LINE |
NA |
Char |
1 |
None |
REQ_LINE_TYPE |
NA |
Char |
3 |
None |
The following describes the table, R_CAREER:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
ACAD_CAREER |
Y |
Char |
4 |
None |
CAR_DATE |
NA |
PSDATE |
NA |
None |
ITEM_R_STATUS |
NA |
Char |
4 |
None |
The following describes the table, R_ACAD_PROG:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
ACAD_PROG |
Y |
Char |
5 |
None |
ACAD_CAREER |
NA |
Char |
4 |
None |
ITEM_R_STATUS |
NA |
Char |
4 |
None |
The following describes the table, R_ACAD_PLAN:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
ACAD_PLAN |
Y |
Char |
10 |
None |
ACAD_CAREER |
NA |
Char |
4 |
None |
ACAD_PROG |
NA |
Char |
5 |
None |
ITEM_R_STATUS |
NA |
Char |
4 |
None |
The following describes the table, R_ACAD_SUBPLAN:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
ACAD_SUB_PLAN |
Y |
Char |
10 |
None |
ACAD_CAREER |
NA |
Char |
4 |
None |
ACAD_PROG |
NA |
Char |
5 |
None |
ACAD_PLAN |
NA |
Char |
10 |
None |
ITEM_R_STATUS |
NA |
Char |
4 |
None |
The following describes the table, R_COURSE_USEAGE:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
REQUIREMENT |
Y |
Char |
9 |
None |
RQ_LINE_NBR |
Y |
Char |
4 |
None |
CRSE_TAG |
Y |
Char |
4 |
None |
SEL_PROCESS_TYPE |
NA |
Char |
3 |
Valid Types: Verify ('VER'), Sequence ('SEQ'), Limit ('LIM'), and Standard ('STD'). |
SEL_MODE |
NA |
Char |
1 |
Valid Modes: Selected ('S'), Not Selected ('N'), and Excluded ('X'). |
IN_PROGRESS_GRD |
NA |
Char |
1 |
In Progress Flag: In Progress ('Y'). |
The following describes the table, R_COND_USEAGE:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
REQUIREMENT |
Y |
Char |
9 |
None |
RQ_LINE_NBR |
Y |
Char |
4 |
None |
CONDITION_CODE |
Y |
Char |
3 |
None |
CONDITION_OPERATOR |
Y |
Char |
2 |
None |
CONDITION_DATA |
Y |
Char |
10 |
None |
The following describes the table, R_UNIT_CRSE_GPA:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
UNITS_REQUIRED |
NA |
Decimal |
4.2 |
None |
UNITS_NEEDED |
NA |
Decimal |
4.2 |
None |
CRSES_REQUIRED |
NA |
Decimal |
4.2 |
None |
CRSES_NEEDED |
NA |
Decimal |
4.2 |
None |
GPA_REQUIRED |
NA |
Decimal |
3.3 |
None |
GPA_ACTUAL |
NA |
Decimal |
3.3 |
None |
The following describes the table, R_DESCRIPTION:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
DESCR_LN_NBR |
Y |
Smallint |
NA |
None |
DESCR254 |
NA |
Char |
254 |
None |
The following describes the table, R_OVERRIDE_RG:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
RQ_RG_OVRD_ACTION |
NA |
Char |
4 |
None |
OLD_UNITS |
NA |
Decimal |
4.2 |
None |
NEW_UNITS |
NA |
Decimal |
4.2 |
None |
OLD_CRSES |
NA |
Decimal |
4.2 |
None |
NEW_CRSES |
NA |
Decimal |
4.2 |
None |
REF_RQMT_GROUP |
NA |
Char |
6 |
None |
OPRID |
NA |
Char |
30 |
None |
DESCR254A |
NA |
Char |
254 |
None |
The following describes the table, R_OVERRIDE_RQ:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
REQUIREMENT |
NA |
Char |
9 |
None |
RQ_OVRD_ACTION |
NA |
Char |
4 |
None |
OLD_UNITS |
NA |
Decimal |
4.2 |
None |
NEW_UNITS |
NA |
Decimal |
4.2 |
None |
OLD_CRSES |
NA |
Decimal |
4.2 |
None |
NEW_CRSES |
NA |
Decimal |
4.2 |
None |
REF_REQUIREMENT |
NA |
Char |
9 |
None |
OPRID |
NA |
Char |
30 |
None |
DESCR254A |
NA |
Char |
254 |
None |
The following describes the table, R_OVERRIDE_LN:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
REQUIREMENT |
Y |
Char |
9 |
None |
RQ_LINE_NBR |
Y |
Char |
4 |
None |
RQ_LN_OVRD_ACTION |
NA |
Char |
4 |
None |
OLD_MIN_UNITS |
NA |
Decimal |
4.2 |
None |
NEW_MIN_UNITS |
NA |
Decimal |
4.2 |
None |
OLD_MAX_UNITS |
NA |
Decimal |
4.2 |
None |
NEW_MAX_UNITS |
NA |
Decimal |
4.2 |
None |
OLD_MIN_CRSES |
NA |
Decimal |
4.2 |
None |
NEW_MIN_CRSES |
NA |
Decimal |
4.2 |
None |
OLD_MAX_CRSES |
NA |
Decimal |
4.2 |
None |
NEW_MAX_CRSES |
NA |
Decimal |
4.2 |
None |
OPRID |
NA |
Char |
30 |
None |
DESCR254A |
NA |
Char |
254 |
None |
The following describes the table, R_COURSE_DIREC:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
REQUIREMENT |
Y |
Char |
9 |
None |
RQ_LINE_NBR |
Y |
Char |
4 |
None |
CRSE_TAG |
Y |
Char |
4 |
None |
OPRID |
NA |
Char |
30 |
None |
DESCR254A |
NA |
Char |
254 |
None |
The following describes the table, R_RQDPLN_HEADER:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
PLANS_NEEDED |
NA |
Smallint |
NA |
None |
The following describes the table, R_RQDPLN_DETAIL:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ENTRY_SEQ |
Y |
Smallint |
NA |
None |
RQRMNT_GROUP |
Y |
Char |
6 |
None |
ACAD_CAREER |
Y |
Char |
4 |
None |
ACAD_PROG |
Y |
Char |
5 |
None |
ACAD_PLAN |
Y |
Char |
10 |
None |
ACAD_SUB_PLAN |
Y |
Char |
10 |
None |
The following describes the table, R_WHAT_IF:
Column Name |
Key |
Data Type |
Length |
Comments |
---|---|---|---|---|
ID |
Y |
Char |
11 |
Student's ID |
RPT_DATE |
Y |
PSDATE |
Not applicable (NA) |
Report Date |
RPT_TYPE |
Y |
Char |
4 |
Report Type |
ANALYSIS_DB_SEQ |
Y |
Smallint |
NA |
Report Type Sequence |
ACAD_CAREER |
NA |
Char |
4 |
None |
ACAD_CAREER_OVRD |
NA |
Char |
4 |
None |
CAR_REQ_TERM |
NA |
Char |
4 |
None |
ACAD_PROG |
NA |
Char |
5 |
None |
ACAD_PROG_OVRD |
NA |
Char |
5 |
None |
ACAD_PROG_TERM |
NA |
Char |
4 |
None |
ACAD_PLAN |
NA |
Char |
10 |
None |
ACAD_PLAN_OVRD |
NA |
Char |
10 |
None |
ACAD_PLAN_TERM |
NA |
Char |
4 |
None |
ACAD_SUB_PLAN |
NA |
Char |
10 |
None |
ACAD_SUB_PLAN_OVRD |
NA |
Char |
10 |
None |
ACAD_SUB_PLAN_TERM |
NA |
Char |
4 |
None |