SAA_RPT_TYP_VW (SQL View)	Index Back
Advisement Report Type Table The Advisement Report Type table contains the attributes of a specific advisement report type.

SAA_RPT_TYP_VW

(SQL View)

Advisement Report Type Table

The Advisement Report Type table contains the attributes of a specific advisement report type.

SELECT INSTITUTION , TSCRPT_TYPE , EFFDT , DESCR , DESCRFORMAL , INC_SPEC_ADVIS_RPT , EXCL_IP_COURSES , SAA_RPT_AVAIL_SS , SS_STDNT_AVAIL_TP , SS_ADVIS_AVAIL_TP , USE_CMPLT_MODEL , SAA_DISPLAY_TOPIC , SAA_RPT_MAX_KEEP , SAA_PLNR_RPT , SAA_WHIF_PLNR_RPT , SAA_INCL_PLNR_CRSE , SAA_INCL_SHOP_CRSE , SAA_INCL_WHIF_INFO , INFO_FOR_STDNTS FROM PS_SAA_RPT_TYP_TBL

Related Language Record: SAA_RPT_TYP_LNV

# 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 Transcript 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.

#	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	Transcript 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.