SAA_ACOND_USEVW

(SQL View)
Index Back

Analysis DB Conditions

This table contains the results for condition processing in the Academic Advisement Analysis Database.

SELECT a.EMPLID , a.ANALYSIS_DB_SEQ , a.SAA_CAREER_RPT , a.RQRMNT_GROUP , a.REQUIREMENT , a.RQ_LINE_NBR , a.SAA_ENTRY_SEQ , a.SAA_CONDITION_SEQ , a.RPT_DATE , a.TSCRPT_TYPE , a.SAA_RPT_IDENTIFIER , a.RQ_GRP_LINE_NBR , a.CONDITION_CODE , a.CONDITION_OPERATOR , a.CONDITION_DATA , a.TEST_ID , a.TEST_COMPONENT , a.SCORE , a.ENTRY_R_STATUS FROM PS_SAA_ADB_CONDUSE a

  • Parent record: SAA_ADB_RESULTS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 ANALYSIS_DB_SEQ Number(4,0) SMALLINT NOT NULL Analysis DB Sequence
    3 SAA_CAREER_RPT Character(4) VARCHAR2(4) NOT NULL This field is used in academic advisement as a key to the results tables.

    Prompt Table: ACAD_CAR_TBL

    4 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

    Prompt Table: RQ_GRP_TBL

    5 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement

    Prompt Table: RQ_MAIN_TBL

    6 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr
    7 SAA_ENTRY_SEQ Number(4,0) SMALLINT NOT NULL This field is used in Academic Advisement to track the position of the output in the report.
    8 SAA_CONDITION_SEQ Number(3,0) SMALLINT NOT NULL This field is used in the table SAA_ADB_CONDUSE to track multiple conditions at the same entry sequence position in the table.
    9 RPT_DATE Date(10) DATE NOT NULL Report Date
    10 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
    11 SAA_RPT_IDENTIFIER Character(10) VARCHAR2(10) NOT NULL This field is used to identify a specific run of Academic Advisement Reports within a report type.
    12 RQ_GRP_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Group Line Nbr
    13 CONDITION_CODE Character(3) VARCHAR2(3) NOT NULL This field is used to track which type of condition will be used as either a condition or pre-condition in Academic Advisement.
    AST=Academic Standing
    CGA=Cumulative Grade Point Avg.
    GRP=Student Group
    GRS=Student Groups
    LVL=Academic Level
    NA=None
    PL=Academic Plan
    PLS=Academic Plans
    PPL=Primary Academic Plan
    PPR=Primary Academic Program
    PR=Academic Program
    PRS=Academic Programs
    SPL=Academic Sub Plan
    SPS=Academic Sub Plans
    TBL=Dynamic Condition
    TST=Test Score
    14 CONDITION_OPERATOR Character(2) VARCHAR2(2) NOT NULL Condition Operator
    EQ=Equal
    GE=Greater or Equal
    GT=Greater Than
    IN=In
    LE=Less or Equal
    LT=Less Than
    NE=Not Equal
    NI=Not In
    15 CONDITION_DATA Character(10) VARCHAR2(10) NOT NULL Condition Data
    16 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID
    17 TEST_COMPONENT Character(5) VARCHAR2(5) NOT NULL Test Component
    18 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    19 ENTRY_R_STATUS Character(4) VARCHAR2(4) NOT NULL Item Status
    COMP=Complete
    EXMP=Exempted
    FAIL=Fail