R_COND_USEAGE

#	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	RPT_DATE	Date(10)	DATE NOT NULL	Report Date
3	RPT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field is the type of Academic Advisement report and is used by the tables in the Analysis Database. This field is reserved for use by SA. SPC=Special Report STD=Standard Report
4	ANALYSIS_DB_SEQ	Number(4,0)	SMALLINT NOT NULL	Analysis DB Sequence Default Value: 1
5	ENTRY_SEQ	Number(3,0)	SMALLINT NOT NULL	Entry Sequence
6	RQRMNT_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Requirement Group Prompt Table: RQ_GRP_TBL
7	REQUIREMENT	Character(9)	VARCHAR2(9) NOT NULL	Academic Requirement Prompt Table: RQ_MAIN_TBL
8	RQ_LINE_NBR	Character(4)	VARCHAR2(4) NOT NULL	Line Nbr
9	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
10	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
11	CONDITION_DATA	Character(10)	VARCHAR2(10) NOT NULL	Condition Data
12	TEST_ID	Character(11)	VARCHAR2(11) NOT NULL	Test ID
13	TEST_COMPONENT	Character(5)	VARCHAR2(5) NOT NULL	Test Component
14	SCORE	Number(7,2)	DECIMAL(6,2) NOT NULL	Test Score
15	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.
16	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