SSR_ENRL_SYNCVW

(SQL View)
 Index Back

Student Enrollment Table

This table contains student enrollment information by term for the student.

SELECT A.ENRL_REQUEST_ID , A.ENRL_REQ_DETL_SEQ ,A.EMPLID , A.ACAD_CAREER , A.INSTITUTION , A.STRM , A.CLASS_NBR ,A.SCC_AUDIT_ACTN ,A.ENRL_ACTION_LAST ,A.PROCESS_INSTANCE , B.CRSE_CAREER , B.SESSION_CODE , B.SESSN_ENRL_CNTL , B.STDNT_ENRL_STATUS , B.ENRL_STATUS_REASON , B.ENRL_ACTION_LAST , B.ENRL_ACTN_RSN_LAST , B.ENRL_ACTN_PRC_LAST , B.STATUS_DT , B.ENRL_ADD_DT , B.ENRL_DROP_DT , B.UNT_TAKEN , B.UNT_PRGRSS , B.UNT_PRGRSS_FA , B.UNT_BILLING , B.CRSE_COUNT , B.GRADING_BASIS_ENRL , B.GRADING_BASIS_DT , B.OVRD_GRADING_BASIS , B.CRSE_GRADE_OFF , B.CRSE_GRADE_INPUT , B.GRADE_DT , B.REPEAT_CODE , B.REPEAT_DT , B.CLASS_PRMSN_NBR , B.ASSOCIATED_CLASS , B.STDNT_POSITIN , B.AUDIT_GRADE_BASIS , B.EARN_CREDIT , B.INCLUDE_IN_GPA , B.UNITS_ATTEMPTED , B.GRADE_POINTS , B.GRADE_POINTS_FA , B.GRD_PTS_PER_UNIT , B.MANDATORY_GRD_BAS , B.RSRV_CAP_NBR , B.RQMNT_DESIGNTN , B.RQMNT_DESIGNTN_OPT , B.RQMNT_DESIGNTN_GRD , B.INSTRUCTOR_ID , B.DROP_CLASS_IF_ENRL , B.ASSOCIATION_99 , B.OPRID , B.TSCRPT_NOTE_ID , B.TSCRPT_NOTE_EXISTS , B.NOTIFY_STDNT_CHNG , B.REPEAT_CANDIDATE , B.VALID_ATTEMPT , B.GRADE_CATEGORY , B.SEL_GROUP , B.DYN_CLASS_NBR , B.UNT_EARNED , B.LAST_UPD_DT_STMP , B.LAST_UPD_TM_STMP , B.LAST_ENRL_DT_STMP , B.LAST_ENRL_TM_STMP , B.LAST_DROP_DT_STMP , B.LAST_DROP_TM_STMP , B.ENRL_REQ_SOURCE , B.LAST_UPD_ENREQ_SRC , B.GRADING_SCHEME_ENR , B.RELATE_CLASS_NBR_1 , B.RELATE_CLASS_NBR_2 , B.ACAD_PROG , %Truncate((((A.ENRL_REQ_DETL_SEQ - 1) / C.SSR_ENR_SYNC_COMMT) + 1),0) AS SSR_ENR_SYNC_GROUP FROM PS_SSR_ENRL_BEVNT A INNER JOIN PS_INSTALLATION_SA C ON A.INSTITUTION = C.INSTITUTION LEFT OUTER JOIN PS_STDNT_ENRL B ON A.EMPLID = B.EMPLID AND A.ACAD_CAREER = B.ACAD_CAREER AND A.INSTITUTION = B.INSTITUTION AND A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR

  • Parent record: STDNT_CAREER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ENRL_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Enrollment Request ID
    2 ENRL_REQ_DETL_SEQ Number(6,0) INTEGER NOT NULL Enrollment Req Detail Sequence
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    4 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

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: TERM_TBL

    7 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

    Prompt Table: CLASS_TBL_VW

    8 SCC_AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action
    A=Add
    C=Change
    D=Delete
    9 ENRL_ACTION_TMP Character(2) VARCHAR2(2) NOT NULL Enrollment Action
    D=Drop
    N=Manual Add
    10 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    11 CRSE_CAREER Character(4) VARCHAR2(4) NOT NULL Course Career

    Default Value: CLASS_TBL_VW.ACAD_CAREER

    12 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2

    Default Value: CLASS_TBL_VW.SESSION_CODE

    13 SESSN_ENRL_CNTL Character(3) VARCHAR2(3) NOT NULL Enrollment Control Session
    14 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
    D=Dropped
    E=Enrolled
    W=Waiting

    Default Value: E

    15 ENRL_STATUS_REASON Character(4) VARCHAR2(4) NOT NULL Enrollment Status Reason
    ADRP=Administrative Drop
    ALIM=Appointment Limit Exceeded
    CANC=Dropped (class cancelled)
    CREQ=Co-Requisite Enrollment
    DROP=Dropped (was enrolled)
    DRWL=Dropped (was wait listed)
    ENRL=Enrolled
    EWAT=Enrolled from Wait List
    FULL=Section is Full
    RCAP=Reserve Slots Full
    RCMP=Related Component
    SLIM=Session Limit Exceeded
    TIME=Time Conflict Exsists
    TIMR=Time Conflict Resolved
    TLIM=Term Limit Exceeded
    WDRW=Withdrawn from Class

    Default Value: ENRL

    16 ENRL_ACTION_LAST Character(2) VARCHAR2(2) NOT NULL Last Enrollment Action

    Prompt Table: XL_ENRL_ACTN_VW

    17 ENRL_ACTN_RSN_LAST Character(4) VARCHAR2(4) NOT NULL Last Enrl Action Reason

    Prompt Table: ENRL_RSN_TBL

    18 ENRL_ACTN_PRC_LAST Character(2) VARCHAR2(2) NOT NULL Last Enrollment Action Process
    C=Course Cancelled
    E=Enrollment
    G=Grade Post
    R=Enrollment Request

    Default Value: E

    19 STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: %date

    20 ENRL_ADD_DT Date(10) DATE Enrollment Add Date

    Default Value: %date

    21 ENRL_DROP_DT Date(10) DATE Enrollment Drop Date
    22 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    23 UNT_PRGRSS Number(6,2) DECIMAL(5,2) NOT NULL Units Taken-Academic Progress
    24 UNT_PRGRSS_FA Number(6,2) DECIMAL(5,2) NOT NULL Units Taken-Fin Aid Progress
    25 UNT_BILLING Number(6,2) DECIMAL(5,2) NOT NULL Billing Units
    26 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
    27 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis

    Prompt Table: %EDITTABLE

    28 GRADING_BASIS_DT Date(10) DATE Grading Basis Date

    Default Value: %date

    29 OVRD_GRADING_BASIS Character(1) VARCHAR2(1) NOT NULL Override Grading Basis

    Default Value: N

    30 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade

    Prompt Table: GRADE_TBL_VW

    31 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A

    Prompt Table: GRADE_TBL_VW

    32 GRADE_DT Date(10) DATE Grade Date
    33 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
    NTEA=No Taking Exam/Assessment

    Prompt Table: REPEAT_CODE_TBL

    34 REPEAT_DT Date(10) DATE Repeat Date
    35 CLASS_PRMSN_NBR Number(6,0) INTEGER NOT NULL Class Permission Nbr
    36 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class

    Default Value: CLASS_TBL_VW.ASSOCIATED_CLASS

    37 STDNT_POSITIN Number(8,0) INTEGER NOT NULL Student Position
    38 AUDIT_GRADE_BASIS Character(1) VARCHAR2(1) NOT NULL Audit Grading Basis

    Y/N Table Edit

    Default Value: GRADE_BASIS_VW.AUDIT_GRADE_BASIS

    39 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit

    Y/N Table Edit

    40 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA

    Y/N Table Edit

    41 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
    I=In Progress
    N=No
    Y=Yes
    42 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
    43 GRADE_POINTS_FA Number(10,3) DECIMAL(9,3) NOT NULL Financial Aid Grade Points
    44 GRD_PTS_PER_UNIT Number(10,3) DECIMAL(9,3) NOT NULL Grade Points Per Unit
    45 MANDATORY_GRD_BAS Character(1) VARCHAR2(1) NOT NULL Mandatory Grading Basis

    Y/N Table Edit

    Default Value: N

    46 RSRV_CAP_NBR Number(3,0) SMALLINT NOT NULL Reserve Capacity Sequence
    47 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.

    Prompt Table: RQMNT_DESIG_TBL

    48 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
    N=No
    Y=Yes
    49 RQMNT_DESIGNTN_GRD Character(1) VARCHAR2(1) NOT NULL Requirement Designation Grade
    N=Not Satisfied
    S=Satisfied
    50 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID

    Prompt Table: %EDITTABLE2

    51 DROP_CLASS_IF_ENRL Number(5,0) INTEGER NOT NULL Drop This Class if Enrolled

    Prompt Table: CLASS_TBL_VW

    52 ASSOCIATION_99 Character(1) VARCHAR2(1) NOT NULL Association 99

    Y/N Table Edit

    Default Value: N

    53 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_CS.OPRID

    54 TSCRPT_NOTE_ID Character(4) VARCHAR2(4) NOT NULL Transcript Note ID

    Prompt Table: TSCRPT_NOTE_TBL

    55 TSCRPT_NOTE_EXISTS Character(1) VARCHAR2(1) NOT NULL Transcript Note Exists Flag

    Y/N Table Edit

    Default Value: N

    56 NOTIFY_STDNT_CHNG Character(2) VARCHAR2(2) NOT NULL Notify Student of Change
    DP=Dropped/Class Canceled
    WE=Enrolled From WaitList
    WL=WaitList Status Change
    57 REPEAT_CANDIDATE Character(1) VARCHAR2(1) NOT NULL Repeat Candidate Flag

    Y/N Table Edit

    Default Value: N

    58 VALID_ATTEMPT Character(1) VARCHAR2(1) NOT NULL Valid Attempted Grade
    59 GRADE_CATEGORY Character(4) VARCHAR2(4) NOT NULL The default value of NONE is delivered with the system and should not be deleted.
    TXFR=Transfer Pass (Sample)
    60 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group
    61 DYN_CLASS_NBR Number(5,0) INTEGER NOT NULL Dynamic Class Nbr
    62 UNT_EARNED Number(6,2) DECIMAL(5,2) NOT NULL Units Earned
    63 LAST_UPD_DT_STMP Date(10) DATE Last Update Date Stamp
    64 LAST_UPD_TM_STMP Time(15) TIMESTAMP Last Update Time Stamp
    65 LAST_ENRL_DT_STMP Date(10) DATE Last Enrollment Date Stamp
    66 LAST_ENRL_TM_STMP Time(15) TIMESTAMP Last Enrollment Time Stamp
    67 LAST_DROP_DT_STMP Date(10) DATE Last Drop Date Stamp
    68 LAST_DROP_TM_STMP Time(15) TIMESTAMP Last Drop Time Stamp
    69 ENRL_REQ_SOURCE Character(2) VARCHAR2(2) NOT NULL Enrollment Request Source
    CR=Class Roll
    E=Enrollment Request
    EN=Enrollment
    FE=Fluid Cls Srch Enrl non-SFF
    FF=Fluid Cls Srch Enrl SFF
    FS=Fluid Self Service SFF
    FX=Fluid Self Service non-SFF
    IL=Grade Lapse
    ME=Mass Enrollment
    PB=Post Enrl Req Chk Batch
    PD=Req Chk Drop Online
    PO=Post Enrl Req Chk Online
    PX=Req Chk Drop Batch
    QE=Quick Enroll
    SE=Self-Service Enrollment
    SF=Student Financials Batch
    SG=Self Service Grade Posting
    TA=Test Administration (NLD)
    WD=Term Withdrawal Engine
    WL=Wait List Engine
    70 LAST_UPD_ENREQ_SRC Character(2) VARCHAR2(2) NOT NULL Enrollment Request Source
    CC=Class Cancellation
    E=Enrollment Request
    EN=Enrollment
    FA=FA Progress Unit Update
    GP=Grade Posting
    IL=Incomplete Lapse
    ME=Mass Enrollment
    PB=Post Enrl Req Chk Batch
    PD=Req Chk Drop Online
    PO=Post Enrl Req Chk Online
    PX=Req Chk Drop Batch
    QE=Quick Enroll
    RC=Repeat Checking
    SE=Self-Service Enrollment
    SF=Student Financials Batch
    WD=Term Withdrawal Engine
    WL=Wait List Engine
    71 GRADING_SCHEME_ENR Character(3) VARCHAR2(3) NOT NULL Grading Scheme
    72 RELATE_CLASS_NBR_1 Number(5,0) INTEGER NOT NULL Related Class Number 1
    73 RELATE_CLASS_NBR_2 Number(5,0) INTEGER NOT NULL Related Class Number 2
    74 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Default Value: STDNT_CAR_TERM.ACAD_PROG_PRIMARY

    Prompt Table: SSR_ACPRG_AC_VW

    75 SSR_ENR_SYNC_GROUP Number(6,0) INTEGER NOT NULL Enrollment Sync Group