SAA_WHIF_TYP_VW

(SQL View)
Index Back

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 WHERE SAA_INCL_WHIF_INFO = 'Y'

  • 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 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.