SSR_GR_STDCARVW

(SQL View)
 Index Back

Student Career Term Table

This table contains student information by Academic Career, Institution and Term. To have an entry in this table, the student must have at least one entry in the Academic Program table.

SELECT EMPLID ,ACAD_CAREER ,INSTITUTION ,STRM ,STDNT_CAR_NBR ,ACAD_PROG_PRIMARY ,ACAD_LOAD_APPR ,ACADEMIC_LOAD ,ACAD_LEVEL_PROJ ,ACAD_LEVEL_BOT ,ACAD_LEVEL_EOT ,UNT_TAKEN_PRGRSS ,UNT_PASSD_PRGRSS ,UNT_TAKEN_GPA ,UNT_PASSD_GPA ,UNT_TAKEN_NOGPA ,UNT_PASSD_NOGPA ,UNT_INPROG_GPA ,UNT_INPROG_NOGPA ,GRADE_POINTS ,UNT_AUDIT ,UNT_TRNSFR ,TRF_TAKEN_GPA ,TRF_TAKEN_NOGPA ,TRF_PASSED_GPA ,TRF_PASSED_NOGPA ,TRF_GRADE_POINTS ,UNT_TEST_CREDIT ,UNT_OTHER ,UNT_TAKEN_FA ,UNT_PASSD_FA ,UNT_TAKEN_FA_GPA ,GRADE_POINTS_FA ,UNT_TERM_TOT ,RESET_CUM_STATS ,TOT_TAKEN_PRGRSS ,TOT_PASSD_PRGRSS ,TOT_TAKEN_GPA ,TOT_PASSD_GPA ,TOT_TAKEN_NOGPA ,TOT_PASSD_NOGPA ,TOT_INPROG_GPA ,TOT_INPROG_NOGPA ,TOT_AUDIT ,TOT_TRNSFR ,TOT_TEST_CREDIT ,TOT_OTHER ,TOT_CUMULATIVE ,TOT_GRADE_POINTS ,TOT_TAKEN_FA ,TOT_PASSD_FA ,TOT_TAKEN_FA_GPA ,TOT_GRD_POINTS_FA ,CUR_GPA ,CUM_GPA ,SSR_TRF_CUR_GPA ,SSR_COMB_CUR_GPA ,SSR_CUM_EN_GPA ,SSR_TOT_EN_GRDPTS ,SSR_TOT_EN_TKNGPA ,SSR_CUM_TR_GPA ,SSR_TOT_TR_GRDPTS ,SSR_TOT_TR_TKNGPA FROM PS_STDNT_CAR_TERM

  • Parent record: STDNT_CAREER

    • # 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 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: STDNT_CAREER

    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    5 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

    Prompt Table: %EDITTABLE

    6 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
    7 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time

    Default Value: F

    8 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    P=Enrolled Part-Time
    T=Three Quarter Time

    Default Value: N

    Prompt Table: ACAD_LOAD_TBLVW

    9 ACAD_LEVEL_PROJ Character(3) VARCHAR2(3) NOT NULL Academic Level - Projected

    Prompt Table: ACAD_LEVEL_TBL

    10 ACAD_LEVEL_BOT Character(3) VARCHAR2(3) NOT NULL Academic Level - Term Start

    Prompt Table: ACAD_LEVEL_TBL

    11 ACAD_LEVEL_EOT Character(3) VARCHAR2(3) NOT NULL Academic Level - Term End

    Prompt Table: ACAD_LEVEL_TBL

    12 UNT_TAKEN_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Units Taken for Progress
    13 UNT_PASSD_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Units Passed for Progress
    14 UNT_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Units Taken Toward GPA
    15 UNT_PASSD_GPA Number(9,3) DECIMAL(8,3) NOT NULL Units Passed Toward GPA
    16 UNT_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Units Taken Not Toward GPA
    17 UNT_PASSD_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Units Passed Not Toward GPA
    18 UNT_INPROG_GPA Number(9,3) DECIMAL(8,3) NOT NULL Units In Progress - GPA
    19 UNT_INPROG_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Unit In Progress - Not for GPA
    20 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
    21 UNT_AUDIT Number(9,3) DECIMAL(8,3) NOT NULL Units Audited
    22 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
    23 TRF_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Term Units for GPA of Transfer Credits
    24 TRF_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Taken Not for GPA
    25 TRF_PASSED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
    26 TRF_PASSED_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
    27 TRF_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Term Grade Points of Transfer Credits.
    28 UNT_TEST_CREDIT Number(9,3) DECIMAL(8,3) NOT NULL Units from Test Credit
    29 UNT_OTHER Number(9,3) DECIMAL(8,3) NOT NULL Units from Other Credit
    30 UNT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Taken
    31 UNT_PASSD_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Passed
    32 UNT_TAKEN_FA_GPA Number(9,3) DECIMAL(8,3) NOT NULL FA Units Taken Toward GPA
    33 GRADE_POINTS_FA Number(10,3) DECIMAL(9,3) NOT NULL Financial Aid Grade Points
    34 UNT_TERM_TOT Number(9,3) DECIMAL(8,3) NOT NULL Total Term Units
    35 RESET_CUM_STATS Character(1) VARCHAR2(1) NOT NULL Reset Cum Stats at Term Start

    Y/N Table Edit

    Default Value: N

    36 TOT_TAKEN_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Total Taken for Progress
    37 TOT_PASSD_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Total Passed for Progress
    38 TOT_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative Units for GPA of Enrollments and Transfer Credits
    39 TOT_PASSD_GPA Number(9,3) DECIMAL(8,3) NOT NULL Total Passed Toward GPA
    40 TOT_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Total Taken Not Toward GPA
    41 TOT_PASSD_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Total Passed Not Toward GPA
    42 TOT_INPROG_GPA Number(9,3) DECIMAL(8,3) NOT NULL Total In Progress - GPA
    43 TOT_INPROG_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Total In Progress -Not for GPA
    44 TOT_AUDIT Number(9,3) DECIMAL(8,3) NOT NULL Total Audited
    45 TOT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Total Transferred
    46 TOT_TEST_CREDIT Number(9,3) DECIMAL(8,3) NOT NULL Total From Test Credit
    47 TOT_OTHER Number(9,3) DECIMAL(8,3) NOT NULL Total from Other Credit
    48 TOT_CUMULATIVE Number(9,3) DECIMAL(8,3) NOT NULL Total Cumulative Units
    49 TOT_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Cumulative Grade Points of Enrollment and Transfer Credits
    50 TOT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Fin Aid Units Taken
    51 TOT_PASSD_FA Number(9,3) DECIMAL(8,3) NOT NULL Total Fin Aid Units Passed
    52 TOT_TAKEN_FA_GPA Number(9,3) DECIMAL(8,3) NOT NULL Total Fin Aid Taken Toward GPA
    53 TOT_GRD_POINTS_FA Number(10,3) DECIMAL(9,3) NOT NULL Total Fin Aid Grade Points
    54 CUR_GPA Number(9,3) DECIMAL(8,3) NOT NULL Current GPA
    55 CUM_GPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative GPA
    56 SSR_TRF_CUR_GPA Number(9,3) DECIMAL(8,3) NOT NULL Term GPA of Transfer Credits
    57 SSR_COMB_CUR_GPA Number(9,3) DECIMAL(8,3) NOT NULL Term GPA of Enrollments and Transfer Credits
    58 SSR_CUM_EN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative Enrollment GPA
    59 SSR_TOT_EN_GRDPTS Number(10,3) DECIMAL(9,3) NOT NULL Cumulative Enrollment Grade Points
    60 SSR_TOT_EN_TKNGPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative Enrollment Units for GPA
    61 SSR_CUM_TR_GPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative GPA of Transfer Credits
    62 SSR_TOT_TR_GRDPTS Number(10,3) DECIMAL(9,3) NOT NULL Cumulative Transfer Credits Grade Points
    63 SSR_TOT_TR_TKNGPA Number(9,3) DECIMAL(8,3) NOT NULL Cumulative Transfer Credits Units for GPA