SAA_RPT_TYP_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Advisement Report Type
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRFORMAL	Character(50)	VARCHAR2(50) NOT NULL	Formal Description field
6	INC_SPEC_ADVIS_RPT	Character(1)	VARCHAR2(1) NOT NULL	Include Spec Advis Report Y/N Table Edit Default Value: N
7	EXCL_IP_COURSES	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify if in-progress courses are available to be used in a specific advising report. Y/N Table Edit Default Value: N
8	SAA_RPT_AVAIL_SS	Character(1)	VARCHAR2(1) NOT NULL	Check box variable used to identify any advising report types that are available in self-service. Y/N Table Edit Default Value: N
9	SS_STDNT_AVAIL_TP	Character(1)	VARCHAR2(1) NOT NULL	Checkbox variable for a view to retrieve valid transcript types for student self-service applications. Y/N Table Edit Default Value: N
10	SS_ADVIS_AVAIL_TP	Character(1)	VARCHAR2(1) NOT NULL	Checkbox variable for a view to retrieve valid transcript types for advisor self-service applications. Y/N Table Edit Default Value: N
11	USE_CMPLT_MODEL	Character(1)	VARCHAR2(1) NOT NULL	This fiels is a flag that is passed in the what-if report request for academic advisement to flag whether or not to include the completed transfer credit models when running an advisement report. N=No Y=Yes Default Value: N
12	AA_SSTC_MODEL	Character(1)	VARCHAR2(1) NOT NULL	This field is a flag used to identify transcript requests that use all self-reported transfer credit models. Y/N Table Edit Default Value: N
13	SAA_DISPLAY_TOPIC	Character(1)	VARCHAR2(1) NOT NULL	This field is used in the setup table TRANSCRIPT_TYPE to determine if course topics are to be displayed for the specific transcript type record for Academic Advisement reports. Y/N Table Edit Default Value: N
14	SAA_RPT_MAX_KEEP	Number(2,0)	SMALLINT NOT NULL	This field contains the maximum number of reports to keep in the reports results tables for a specific report type. Default Value: 1
15	SAA_PLNR_RPT	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify if a specific advisement report type is the one to be used in conjunction with the Student Planner. Y/N Table Edit Default Value: N
16	SAA_WHIF_PLNR_RPT	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify if a specific "What-If" advisement report type is the one to be used in conjunction with the Student Planner. Y/N Table Edit Default Value: N
17	SAA_SSS_CRS_WHATIF	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate if a student is allowed to create course what-ifs for a specific advisement report. Y/N Table Edit Default Value: N
18	SAA_SSS_PRG_WHATIF	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate if a student is allowed to create program and plan what-ifs for a specific advisement report. Y/N Table Edit Default Value: N
19	SAA_SSA_CRS_WHATIF	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate if an advisor is allowed to create course what-ifs for a specific advisement report. Y/N Table Edit Default Value: N
20	SAA_SSA_PRG_WHATIF	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate if a advisor is allowed to create program and plan what-ifs for a specific advisement report. Y/N Table Edit Default Value: N
21	SAA_INCL_PLNR_CRSE	Character(1)	VARCHAR2(1) NOT NULL	Check box variable used to identify any advising report types that are available in self-service. Y/N Table Edit Default Value: N
22	SAA_INCL_SHOP_CRSE	Character(1)	VARCHAR2(1) NOT NULL	Check box variable used to identify any advising report types that are available in self-service. Y/N Table Edit Default Value: N
23	SAA_INCL_WHIF_INFO	Character(1)	VARCHAR2(1) NOT NULL	Check box variable used to identify any advising report types that are available in self-service. Y/N Table Edit Default Value: N
24	SAA_DYN_ASOF_DATE	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify if an advising reort type allows for the as of date to be automatically updated with today's date at run time. 1=Current Date 2=Installation Default Date 3=Select Date on Request Default Value: 2
25	SAA_DYN_RPT_DATE	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify if an advising reort type allows for the report date to be automatically updated with today's date at run time. 1=Current Date 2=Select Date on Request Default Value: 2
26	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.
27	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.