SAA_CND_TSTAVW

(SQL View)
 Index Back

Valid Condition Test View

This view is used as a prompt for selecting valid tests to be used in defining academic requirements.

SELECT A.INSTITUTION , A.RQRMNT_USEAGE , A.TEST_ID , A.EFFDT , A.EFF_STATUS , A.SAA_MAX_VALID_AGE , A.SAA_TST_AGE_OVRD , A.SAA_BEST_TEST_OPT , A.SAA_BEST_TST_OVRD , B.DESCR FROM PS_SAA_CND_TST_TBL A , PS_SA_TEST_TBL B WHERE A.TEST_ID = B.TEST_ID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_SA_TEST_TBL B1 WHERE B.TEST_ID = B1.TEST_ID AND B1.EFFDT <= A.EFFDT AND B1.EFF_STATUS = 'A')

  • Related Language Record: SAA_CND_TSTAVLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    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

    Prompt Table: RQRMNT_USE_TBL

    3 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

    Prompt Table: SA_TEST_TBL

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 SAA_MAX_VALID_AGE Number(3,0) SMALLINT NOT NULL This field is used to track the maximum age of a test score in months for Academic Advisement.
    7 SAA_TST_AGE_OVRD Character(1) VARCHAR2(1) NOT NULL This field is a flag used to identify if a test score maximum valid age is allowed to be overridden on the setup pages.

    Y/N Table Edit

    Default Value: N

    8 SAA_BEST_TEST_OPT Character(2) VARCHAR2(2) NOT NULL This field is used to track the method to select the correct test score in Academic Advisement when multiple versions of the same test are found.
    AV=Average of All Scores Taken
    FT=First Test Taken
    HS=Highest Score
    LS=Lowest Score
    LT=Last Test Taken
    9 SAA_BEST_TST_OVRD Character(1) VARCHAR2(1) NOT NULL This field is a flag used to identify if the process to calculate the best test score is allowed to be overridden on the setup pages.

    Y/N Table Edit

    Default Value: N

    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description