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