RQ_LINE_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REQUIREMENT	Character(9)	VARCHAR2(9) NOT NULL	Academic Requirement
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	RQ_LINE_KEY_NBR	Character(4)	VARCHAR2(4) NOT NULL	Background Key
4	RQ_LINE_NBR	Character(4)	VARCHAR2(4) NOT NULL	Line Nbr
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	FULL_SET_RPN	Character(1)	VARCHAR2(1) NOT NULL	Override Standard Set Logic Y/N Table Edit Default Value: N
8	SPECIAL_PROCESSING	Character(1)	VARCHAR2(1) NOT NULL	Special Circumstances 1=Yes N=No Y=Yes Y/N Table Edit Default Value: N
9	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
10	RQ_CONNECT	Character(4)	VARCHAR2(4) NOT NULL	Detail Connector AND=And OR=Or
11	CREDIT_INCL_MODE	Character(4)	VARCHAR2(4) NOT NULL	Credit Include Mode ALL=Include In All Statistics NGPA=Exclude From GPA VER=Verify Only, Never Include Default Value: RQ_MAIN_TBL.CREDIT_INCL_MODE
12	REQ_CRSSELECT_METH	Character(3)	VARCHAR2(3) NOT NULL	Course Ranking Scheme BG=Grade Points CN=Course Catalog CR=Chronological LST=Course List Order (future use) RCN=Reverse Course Catalog RCR=Reverse Chronological Default Value: RQ_MAIN_TBL.REQ_CRSSELECT_METH
13	CT_COND_COMPLEMENT	Character(1)	VARCHAR2(1) NOT NULL	Complement of Line Conditions Y/N Table Edit Default Value: N
14	MIN_UNITS_REQD	Number(7,2)	DECIMAL(6,2) NOT NULL	Minimum Units
15	MIN_CRSES_REQD	Number(6,2)	DECIMAL(5,2) NOT NULL	Minimum Courses
16	MAX_UNITS_ALLOWD	Number(7,2)	DECIMAL(6,2) NOT NULL	Maximum Units Allowed
17	MAX_CRSES_ALLOWD	Number(7,2)	DECIMAL(6,2) NOT NULL	Maximum Courses Allowed
18	GRADE_POINTS_MIN	Number(10,2)	DECIMAL(9,2) NOT NULL	Minimum Grade Points Default Value: RQ_MAIN_TBL.GRADE_POINTS_MIN
19	GPA_REQUIRED	Number(7,3)	DECIMAL(6,3) NOT NULL	Minimum GPA
20	GPA_MAXIMUM	Number(7,3)	DECIMAL(6,3) NOT NULL	Maximum GPA Allowed
21	RQ_REPORTING	Character(4)	VARCHAR2(4) NOT NULL	Reporting ALL=Always Report NSAT=Report Only when NOT satisfied SAT=Report only when satisfied Default Value: RQ_MAIN_TBL.RQ_REPORTING
22	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 Default Value: N
23	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 Default Value: N
24	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 Default Value: N
25	CONDITION_CODE	Character(3)	VARCHAR2(3) NOT NULL	This field is used to track which type of condition will be used as either a condition or pre-condition in Academic Advisement. AST=Academic Standing CGA=Cumulative Grade Point Avg. GRP=Student Group GRS=Student Groups LVL=Academic Level NA=None PL=Academic Plan PLS=Academic Plans PPL=Primary Academic Plan PPR=Primary Academic Program PR=Academic Program PRS=Academic Programs SPL=Academic Sub Plan SPS=Academic Sub Plans TBL=Dynamic Condition TST=Test Score Default Value: NA
26	CONDITION_OPERATOR	Character(2)	VARCHAR2(2) NOT NULL	Condition Operator EQ=Equal GE=Greater or Equal GT=Greater Than IN=In LE=Less or Equal LT=Less Than NE=Not Equal NI=Not In Default Value: EQ
27	CONDITION_DATA	Character(10)	VARCHAR2(10) NOT NULL	Condition Data Prompt Table: %EDITTABLE
28	COUNT_ATTEMPTS	Character(1)	VARCHAR2(1) NOT NULL	Count Attempts Y/N Table Edit Default Value: N
29	DISP_SELECT_LINE	Character(1)	VARCHAR2(1) NOT NULL	Display Select Line Y/N Table Edit Default Value: N
30	ENABLE_SPLITTING	Character(1)	VARCHAR2(1) NOT NULL	Enable Splitting Y/N Table Edit Default Value: N
31	RQ_PRINT_CNTL	Character(4)	VARCHAR2(4) NOT NULL	Print Control 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 Default Value: ALW
32	PARENTHESIS	Character(1)	VARCHAR2(1) NOT NULL	Parenthesis (=Left Parenthesis )=Right Parenthesis
33	SAA_COMPLEX_RQ_LN	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify if the requirement line contains complex set logic used to select courses to be used in an advising report. Y/N Table Edit Default Value: N
34	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID Prompt Table: SAA_CND_TST_VW
35	TEST_COMPONENT	Character(5)	VARCHAR2(5) NOT NULL	Test Component Prompt Table: SA_TCMP_REL_TBL
36	SCORE	Number(7,2)	DECIMAL(6,2) NOT NULL	Test Score
37	SAA_MAX_VALID_AGE	Number(3,0)	SMALLINT NOT NULL	This field is used to track the maximum age of a test score in months for Academic Advisement.
38	SAA_BEST_TEST_OPT	Character(2)	VARCHAR2(2) NOT NULL	This field is used to track the method to select the correct test score in Academic Advisement when multiple versions of the same test are found. AV=Average of All Scores Taken FT=First Test Taken HS=Highest Score LS=Lowest Score LT=Last Test Taken
39	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. Y/N Table Edit Default Value: N
40	SAA_DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This field is used to display information in the new student view for academic advisement reports.
41	DESCR254A	Character(254)	VARCHAR2(254) NOT NULL	Long Description
42	SAA_DESCR254	Character(254)	VARCHAR2(254) NOT NULL	This field is used to display information in the new student view for academic advisement reports.
43	SAA_DESCRLONG	Long Character	CLOB NOT NULL	This field is used to display information in the new student view for academic advisement reports.