UPG_SAA_RQU_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RQRMNT_USEAGE	Character(4)	VARCHAR2(4) NOT NULL	This field is used to specify how the requirement will be used. The value 'SHR1' is reserved for use in a future release. ADV=Academic Advisement ENR=Requisite/Restriction PLNR=Student Planner Report SHR=Rq Course Share Restrictn SHR1=Entity Course Share Restrictn STD=Student Individualized Plan
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	CONDITION_SPEC	Character(6)	VARCHAR2(6) NOT NULL	Condition Specification
5	SAA_CONDITION_NEXT	Character(6)	VARCHAR2(6) NOT NULL	This field contains the next condition id to be used in academic advisement.
6	RQ_ENTITY_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Academic Entity Group
7	SAA_ENT_GRP_NEXT	Character(6)	VARCHAR2(6) NOT NULL	This field contains the next entity group id to be used in academic advisement.
8	COND_LINE_SEQ	Number(3,0)	SMALLINT NOT NULL	Condition Line Sequence
9	ENT_GRP_ITEM_NBR	Number(3,0)	SMALLINT NOT NULL	Entity Group Item Number
10	RQRMNT_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Requirement Group
11	REQUIREMENT	Character(9)	VARCHAR2(9) NOT NULL	Academic Requirement
12	RQ_LINE_KEY_NBR	Character(4)	VARCHAR2(4) NOT NULL	Background Key
13	RQ_LINE_DET_SEQ	Number(3,0)	SMALLINT NOT NULL	Line Detail Sequence
14	CONDITION_SPEC_UPD	Character(6)	VARCHAR2(6) NOT NULL	This field is a copy of the condition code used for updating dynamic conditions with new dynamic condition values.
15	CONDITION_DATA	Character(10)	VARCHAR2(10) NOT NULL	Condition Data
16	UPG_STGRHD_INS_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
17	UPG_STGRHD_UPD_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
18	UPG_STGRDT_INS_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
19	UPG_STGRDT_UPD_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
20	UPG_ENT_GR_INS_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
21	UPG_ENT_GR_UPD_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
22	UPG_ENGRDT_INS_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
23	UPG_COND_INS_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
24	UPG_COND_UPD_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
25	UPG_CND_LN_INS_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
26	UPG_CND_LN_UPD_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
27	UPG_CNLNDT_INS_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
28	UPG_RQ_GRP_UPD_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
29	UPG_RG_DTL_UPD_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
30	UPG_RQMNT_UPD_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
31	UPG_RQ_LN_UPD_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
32	UPG_RQLNDT_UPD_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR11.
33	UPG_SAA_DTTM	DateTime(26)	TIMESTAMP	Date used to track the start and finish of AA conversion scripts.
34	SAA_ROW_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by academic advisement.
35	UPG_PRCSS_AE_SCTN	Character(1)	VARCHAR2(1) NOT NULL	This field is used in the upgrade of academic advisement to 9.0 in order to control when to run the logic needed to make the test score processing work correctly. Y/N Table Edit Default Value: Y
36	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
37	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transcript Type
38	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
39	DESCRFORMAL	Character(50)	VARCHAR2(50) NOT NULL	Formal Description field
40	PROG_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Academic Program Status AC=Active in Program AD=Admitted AP=Applicant CM=Completed Program CN=Cancelled DC=Discontinued DE=Deceased DM=Dismissed LA=Leave of Absence PM=Prematriculant SP=Suspended WT=Waitlisted
41	UPG_RPTTYP_PRG_CNT	Number(10,0)	DECIMAL(10) NOT NULL	This field is a row counter used by upgrade programs UPG_SR801 and UPG_SR89 academic advisement sections starting with SRAAR12.
42	INFO_FOR_STDNTS	Long Character	CLOB	A long text used by transcript type table used to display a message to students using the self-service transcript request pages.