SAA_WHIF_TYP_VW

#	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	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.
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	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
13	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
14	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
15	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
16	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
17	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
18	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
19	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.