SAA_ARSLT_RGVW (SQL View)	Index Back
Analysis DB Results Table This table contains the results for academic structure and requirement processing level data in the Academic Advisement Analysis Database.

SAA_ARSLT_RGVW

(SQL View)

Analysis DB Results Table

This table contains the results for academic structure and requirement processing level data in the Academic Advisement Analysis Database.

SELECT a.EMPLID , a.ANALYSIS_DB_SEQ , a.SAA_CAREER_RPT , a.RQRMNT_GROUP , a.SAA_ENTRY_SEQ , a.RPT_DATE , a.TSCRPT_TYPE , a.SAA_RPT_IDENTIFIER , a.ENTRY_R_TYPE , a.ACAD_CAREER , a.ACAD_PROG , a.ACAD_PLAN , a.ACAD_SUB_PLAN , a.RQ_DATE , a.RQ_GRP_LINE_NBR , a.REQUIREMENT , a.RQ_LINE_NBR , a.RQRMNT_LIST_SEQ , a.RQ_GRP_LINE_TYPE , a.REQ_LINE_TYPE , a.DISP_SELECT_LINE , a.PARTITION_FAIL , a.UNITS_REQUIRED , a.SAA_UNITS_USED , a.UNITS_NEEDED , a.CRSES_REQUIRED , a.SAA_CRSES_USED , a.CRSES_NEEDED , a.SAA_CRSE_COUNT , a.GPA_REQUIRED , a.GPA_ACTUAL , a.SAA_DISPLAY_GPA , a.SAA_DISPLAY_UNITS , a.SAA_DISPLAY_CRSCNT , a.RQ_OVRD_ACTION , a.OLD_MIN_UNITS , a.NEW_MIN_UNITS , a.OLD_MAX_UNITS , a.NEW_MAX_UNITS , a.OLD_MIN_CRSES , a.NEW_MIN_CRSES , a.OLD_MAX_CRSES , a.NEW_MAX_CRSES , a.REF_RQMT_GROUP , a.REF_REQUIREMENT , a.ITEM_R_STATUS , a.RQ_AA_OVERRIDE , a.ASOF_DATE , a.SAA_PRINT_CNTL , a.SAA_DISPLAY_OPTION , a.OPRID , a.SAA_OPRID_NAME , a.DESCR254A , a.SAA_HIDE_STATUS FROM PS_SAA_ADB_RESULTS a WHERE a.ENTRY_R_TYPE = 'KEYRQG' AND a.RQRMNT_GROUP <> ' ' AND a.SAA_PRINT_CNTL <> 'NVR' AND a.SAA_PRINT_CNTL <> 'SKP'

Parent record: SAA_ADB_REPORT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 ANALYSIS_DB_SEQ Number(4,0) SMALLINT NOT NULL Analysis DB Sequence

3 SAA_CAREER_RPT Character(4) VARCHAR2(4) NOT NULL This field is used in academic advisement as a key to the results tables.
Prompt Table: ACAD_CAR_TBL

4 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
Prompt Table: RQ_GRP_TBL

5 SAA_ENTRY_SEQ Number(4,0) SMALLINT NOT NULL This field is used in Academic Advisement to track the position of the output in the report.

6 RPT_DATE Date(10) DATE Report Date

7 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type

8 SAA_RPT_IDENTIFIER Character(10) VARCHAR2(10) NOT NULL This field is used to identify a specific run of Academic Advisement Reports within a report type.

9 ENTRY_R_TYPE Character(6) VARCHAR2(6) NOT NULL Entry Type

10 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table: ACAD_CAR_TBL

11 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

12 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

13 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

14 RQ_DATE Date(10) DATE Requirement Date

15 RQ_GRP_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Group Line Nbr

16 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement
Prompt Table: RQ_MAIN_TBL

17 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr

18 RQRMNT_LIST_SEQ Number(3,0) SMALLINT NOT NULL This field contains the reporting sequence value used to process and display requirement groups in advisement reports.

19 RQ_GRP_LINE_TYPE Character(4) VARCHAR2(4) NOT NULL Group Line Type
COND=Condition
CRSE=Course
CRSW=Wild Card Course
RQ=Requirement

20 REQ_LINE_TYPE Character(3) VARCHAR2(3) NOT NULL Line Type
CND=Condition Requirement
GLM=Global Limit
GSQ=Global Sequential Restriction
LIM=Unit, Course or GPA Limit
MT=Course Requirement
SC=Specified Courses
SEQ=Sequential Restriction

21 DISP_SELECT_LINE Character(1) VARCHAR2(1) NOT NULL Display Select Line
Y/N Table Edit

22 PARTITION_FAIL Character(1) VARCHAR2(1) NOT NULL Partition fail
Y/N Table Edit

23 UNITS_REQUIRED Number(7,2) DECIMAL(6,2) NOT NULL Units required

24 SAA_UNITS_USED Number(7,2) DECIMAL(6,2) NOT NULL This field is used in Academic Advisement to report the number of units used by a requirement.

25 UNITS_NEEDED Number(7,2) DECIMAL(6,2) NOT NULL Units needed

26 CRSES_REQUIRED Number(7,2) DECIMAL(6,2) NOT NULL Courses required

27 SAA_CRSES_USED Number(7,2) DECIMAL(6,2) NOT NULL This field is used in Academic Advisement to report the number of courses used by a particular requirement.

28 CRSES_NEEDED Number(7,2) DECIMAL(6,2) NOT NULL Courses needed

29 SAA_CRSE_COUNT Number(4,0) SMALLINT NOT NULL This field is used in Academic Advisement to report the number of courses used by a particular requirement.

30 GPA_REQUIRED Number(7,3) DECIMAL(6,3) NOT NULL Minimum GPA

31 GPA_ACTUAL Number(7,3) DECIMAL(6,3) NOT NULL GPA actual

32 SAA_DISPLAY_GPA Character(1) VARCHAR2(1) NOT NULL This field is used to track if the GPA is to be displayed on an Academic Advisement report if the processing level is satisfied.
Y/N Table Edit

33 SAA_DISPLAY_UNITS Character(1) VARCHAR2(1) NOT NULL This field is used to track if the calculated units are to be displayed on an Academic Advisement report if the processing level is satisfied.
Y/N Table Edit

34 SAA_DISPLAY_CRSCNT Character(1) VARCHAR2(1) NOT NULL This field is used to track if the calculated course counts are to be displayed on an Academic Advisement report if the processing level is satisfied.
Y/N Table Edit

35 RQ_OVRD_ACTION Character(4) VARCHAR2(4) NOT NULL This field is used to report the status of an override in academic advising. It contains the same values as are found in RQ_AA_OVRD_OPCODE.
DRCT=Course Directive
REQC=Requirement Change
REQO=Requirement Override
REQW=Requirement Waiver

36 OLD_MIN_UNITS Number(7,2) DECIMAL(6,2) NOT NULL Old Minimum units

37 NEW_MIN_UNITS Number(7,2) DECIMAL(6,2) NOT NULL New minimum units

38 OLD_MAX_UNITS Number(7,2) DECIMAL(6,2) NOT NULL Old Maximum units

39 NEW_MAX_UNITS Number(7,2) DECIMAL(6,2) NOT NULL New maximum units

40 OLD_MIN_CRSES Number(7,2) DECIMAL(6,2) NOT NULL Old minimum courses

41 NEW_MIN_CRSES Number(7,2) DECIMAL(6,2) NOT NULL New minimum courses

42 OLD_MAX_CRSES Number(7,2) DECIMAL(6,2) NOT NULL Old maximum courses

43 NEW_MAX_CRSES Number(7,2) DECIMAL(6,2) NOT NULL New maximum courses

44 REF_RQMT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
Prompt Table: RQ_GRP_TBL

45 REF_REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement
Prompt Table: RQ_MAIN_TBL

46 ITEM_R_STATUS Character(4) VARCHAR2(4) NOT NULL Item Status
COMP=Complete
EXMP=Exempted
FAIL=Fail

47 RQ_AA_OVERRIDE Character(9) VARCHAR2(9) NOT NULL Advisement Override

48 ASOF_DATE Date(10) DATE This field is used all over campus solutions to hold the value of an as of date to be used in different processing.

49 SAA_PRINT_CNTL Character(4) VARCHAR2(4) NOT NULL This field is used to control if certain reporting levels are to be displayed when creating an Academic Advisement Report.
ALW=Print on audit reports
IFDT=Print if there is line detail
NCRS=Do not print line detail
NVR=Do not print
SKP=Skip printing of this level

50 SAA_DISPLAY_OPTION Character(1) VARCHAR2(1) NOT NULL This field will control if items will print/display in Academic Advisement Reports
N=Display Name
O=Display Operator
X=Do Not Display

51 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

52 SAA_OPRID_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to display the name of the oprid when requesting advising reports.

53 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description

54 SAA_HIDE_STATUS Character(1) VARCHAR2(1) NOT NULL This field is used to determine if the status description is to print on AA reports for the processing level.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	ANALYSIS_DB_SEQ	Number(4,0)	SMALLINT NOT NULL	Analysis DB Sequence
3	SAA_CAREER_RPT	Character(4)	VARCHAR2(4) NOT NULL	This field is used in academic advisement as a key to the results tables. Prompt Table: ACAD_CAR_TBL
4	RQRMNT_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Requirement Group Prompt Table: RQ_GRP_TBL
5	SAA_ENTRY_SEQ	Number(4,0)	SMALLINT NOT NULL	This field is used in Academic Advisement to track the position of the output in the report.
6	RPT_DATE	Date(10)	DATE	Report Date
7	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transcript Type
8	SAA_RPT_IDENTIFIER	Character(10)	VARCHAR2(10) NOT NULL	This field is used to identify a specific run of Academic Advisement Reports within a report type.
9	ENTRY_R_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Entry Type
10	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic Career BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine Prompt Table: ACAD_CAR_TBL
11	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program
12	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan
13	ACAD_SUB_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Sub-Plan
14	RQ_DATE	Date(10)	DATE	Requirement Date
15	RQ_GRP_LINE_NBR	Character(4)	VARCHAR2(4) NOT NULL	Group Line Nbr
16	REQUIREMENT	Character(9)	VARCHAR2(9) NOT NULL	Academic Requirement Prompt Table: RQ_MAIN_TBL
17	RQ_LINE_NBR	Character(4)	VARCHAR2(4) NOT NULL	Line Nbr
18	RQRMNT_LIST_SEQ	Number(3,0)	SMALLINT NOT NULL	This field contains the reporting sequence value used to process and display requirement groups in advisement reports.
19	RQ_GRP_LINE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Group Line Type COND=Condition CRSE=Course CRSW=Wild Card Course RQ=Requirement
20	REQ_LINE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Line Type CND=Condition Requirement GLM=Global Limit GSQ=Global Sequential Restriction LIM=Unit, Course or GPA Limit MT=Course Requirement SC=Specified Courses SEQ=Sequential Restriction
21	DISP_SELECT_LINE	Character(1)	VARCHAR2(1) NOT NULL	Display Select Line Y/N Table Edit
22	PARTITION_FAIL	Character(1)	VARCHAR2(1) NOT NULL	Partition fail Y/N Table Edit
23	UNITS_REQUIRED	Number(7,2)	DECIMAL(6,2) NOT NULL	Units required
24	SAA_UNITS_USED	Number(7,2)	DECIMAL(6,2) NOT NULL	This field is used in Academic Advisement to report the number of units used by a requirement.
25	UNITS_NEEDED	Number(7,2)	DECIMAL(6,2) NOT NULL	Units needed
26	CRSES_REQUIRED	Number(7,2)	DECIMAL(6,2) NOT NULL	Courses required
27	SAA_CRSES_USED	Number(7,2)	DECIMAL(6,2) NOT NULL	This field is used in Academic Advisement to report the number of courses used by a particular requirement.
28	CRSES_NEEDED	Number(7,2)	DECIMAL(6,2) NOT NULL	Courses needed
29	SAA_CRSE_COUNT	Number(4,0)	SMALLINT NOT NULL	This field is used in Academic Advisement to report the number of courses used by a particular requirement.
30	GPA_REQUIRED	Number(7,3)	DECIMAL(6,3) NOT NULL	Minimum GPA
31	GPA_ACTUAL	Number(7,3)	DECIMAL(6,3) NOT NULL	GPA actual
32	SAA_DISPLAY_GPA	Character(1)	VARCHAR2(1) NOT NULL	This field is used to track if the GPA is to be displayed on an Academic Advisement report if the processing level is satisfied. Y/N Table Edit
33	SAA_DISPLAY_UNITS	Character(1)	VARCHAR2(1) NOT NULL	This field is used to track if the calculated units are to be displayed on an Academic Advisement report if the processing level is satisfied. Y/N Table Edit
34	SAA_DISPLAY_CRSCNT	Character(1)	VARCHAR2(1) NOT NULL	This field is used to track if the calculated course counts are to be displayed on an Academic Advisement report if the processing level is satisfied. Y/N Table Edit
35	RQ_OVRD_ACTION	Character(4)	VARCHAR2(4) NOT NULL	This field is used to report the status of an override in academic advising. It contains the same values as are found in RQ_AA_OVRD_OPCODE. DRCT=Course Directive REQC=Requirement Change REQO=Requirement Override REQW=Requirement Waiver
36	OLD_MIN_UNITS	Number(7,2)	DECIMAL(6,2) NOT NULL	Old Minimum units
37	NEW_MIN_UNITS	Number(7,2)	DECIMAL(6,2) NOT NULL	New minimum units
38	OLD_MAX_UNITS	Number(7,2)	DECIMAL(6,2) NOT NULL	Old Maximum units
39	NEW_MAX_UNITS	Number(7,2)	DECIMAL(6,2) NOT NULL	New maximum units
40	OLD_MIN_CRSES	Number(7,2)	DECIMAL(6,2) NOT NULL	Old minimum courses
41	NEW_MIN_CRSES	Number(7,2)	DECIMAL(6,2) NOT NULL	New minimum courses
42	OLD_MAX_CRSES	Number(7,2)	DECIMAL(6,2) NOT NULL	Old maximum courses
43	NEW_MAX_CRSES	Number(7,2)	DECIMAL(6,2) NOT NULL	New maximum courses
44	REF_RQMT_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Requirement Group Prompt Table: RQ_GRP_TBL
45	REF_REQUIREMENT	Character(9)	VARCHAR2(9) NOT NULL	Academic Requirement Prompt Table: RQ_MAIN_TBL
46	ITEM_R_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Item Status COMP=Complete EXMP=Exempted FAIL=Fail
47	RQ_AA_OVERRIDE	Character(9)	VARCHAR2(9) NOT NULL	Advisement Override
48	ASOF_DATE	Date(10)	DATE	This field is used all over campus solutions to hold the value of an as of date to be used in different processing.
49	SAA_PRINT_CNTL	Character(4)	VARCHAR2(4) NOT NULL	This field is used to control if certain reporting levels are to be displayed when creating an Academic Advisement Report. ALW=Print on audit reports IFDT=Print if there is line detail NCRS=Do not print line detail NVR=Do not print SKP=Skip printing of this level
50	SAA_DISPLAY_OPTION	Character(1)	VARCHAR2(1) NOT NULL	This field will control if items will print/display in Academic Advisement Reports N=Display Name O=Display Operator X=Do Not Display
51	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
52	SAA_OPRID_NAME	Character(50)	VARCHAR2(50) NOT NULL	This field is used to display the name of the oprid when requesting advising reports.
53	DESCR254A	Character(254)	VARCHAR2(254) NOT NULL	Long Description
54	SAA_HIDE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	This field is used to determine if the status description is to print on AA reports for the processing level.