SAA_ADB_REPORT

(SQL Table)
 Index Back

Analysis DB Report Information

This table contains the data for a specific report in the Academic Advisement Analysis Database.

  • Parent record: SAA_RPT_RQST

    • # 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 RPT_DATE Date(10) DATE NOT NULL Report Date
    5 RPT_TYPE Character(4) VARCHAR2(4) NOT NULL This field is the type of Academic Advisement report and is used by the tables in the Analysis Database. This field is reserved for use by SA.
    SPC=Special Report
    STD=Standard Report
    6 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.
    7 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    8 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type

    Prompt Table: TRANSCRIPT_TYPE

    9 WHAT_IF_FL Character(1) VARCHAR2(1) NOT NULL Use Career Simulation

    Y/N Table Edit

    10 ASOF_DATE Date(10) DATE This field is used all over campus solutions to hold the value of an as of date to be used in different processing.
    11 REPORT_REQUEST_NBR Character(9) VARCHAR2(9) NOT NULL Report Request Nbr

    Prompt Table: SA_REQUEST_HDR

    12 SAA_RPT_DTTM_STAMP DateTime(26) TIMESTAMP This field is used to track the date time stamp of when an advising report was processed.