SSR_BCDEL_SFFVW

(SQL View)
 Index Back

SR Browse Cat Del Rec Vw SFF

Student Records Browse Catalog Delete Record View for Small Form Factor.

SELECT O.CRSE_ID ,O.CRSE_OFFER_NBR ,O.EFFDT ,O.SUBJECT ,O.SSR_CRSE_TYPOFF_CD ,G.XLATLONGNAME ,O.RQMNT_DESIGNTN ,F.XLATLONGNAME ,AC.DESCR ,H.XLATLONGNAME ,O.CAMPUS ,AO.DESCR ,O.CRSE_ATTR ,O.CRSE_ATTR_VALUE ,O.SSR_NUM_UNITS_ES ,O.UNITS_MINIMUM ,O.UNITS_MAXIMUM ,CASE WHEN AT.DESCR1 <> ' ' THEN CASE WHEN OP.SSR_CLSCFG_ATTRVAL = 'Y' THEN AT.DESCR1 || '/' || AT.DESCR2 ELSE AT.DESCR1 END ELSE '' END ,O.SSR_COMPONENT ,O.INSTITUTION ,O.ACAD_CAREER ,' ' ,AT.DESCR1 ,AT.DESCR2 ,CASE WHEN O.SSR_CRSE_TYPOFF_CD <> ' ' THEN 'Y' ELSE 'N' END ,O.GRADING_BASIS ,O.OEE_IND FROM PS_SSR_BCDEL_SFF O LEFT OUTER JOIN PS_SSR_CRATTAUD_VW AT ON O.CRSE_ID = AT.CRSE_ID AND O.EFFDT = AT.EFFDT AND O.CRSE_OFFER_NBR = AT.CRSE_OFFER_NBR AND O.CRSE_ATTR = AT.CRSE_ATTR AND O.CRSE_ATTR_VALUE = AT.CRSE_ATTR_VALUE ,PS_ACAD_CAR_TBL AC ,PS_ACAD_ORG_TBL AO ,PS_SSR_BC_GEN_OPTS OP ,PSXLATITEM F ,PSXLATITEM G ,PSXLATITEM H WHERE AC.INSTITUTION = O.INSTITUTION AND AC.ACAD_CAREER = O.ACAD_CAREER AND AC.EFFDT = ( SELECT MAX(AC2.EFFDT) FROM PS_ACAD_CAR_TBL AC2 WHERE AC2.INSTITUTION = AC.INSTITUTION AND AC2.ACAD_CAREER = AC.ACAD_CAREER AND AC2.EFFDT <= O.EFFDT) AND AO.ACAD_ORG = O.ACAD_ORG AND AO.EFFDT = ( SELECT MAX(AO2.EFFDT) FROM PS_ACAD_ORG_TBL AO2 WHERE AO2.ACAD_ORG = AO.ACAD_ORG AND AO2.EFFDT <= O.EFFDT) AND AO.EFF_STATUS = 'A' AND F.FIELDNAME = 'ALLOWABLE_IND' AND F.FIELDVALUE = O.OEE_IND AND F.EFFDT = ( SELECT MAX(F2.EFFDT) FROM PSXLATITEM F2 WHERE F2.FIELDNAME = F.FIELDNAME AND F2.FIELDVALUE = F.FIELDVALUE AND F2.EFFDT <= O.EFFDT) AND G.FIELDNAME = 'GRADING_BASIS' AND G.FIELDVALUE = O.GRADING_BASIS AND G.EFFDT = ( SELECT MAX(G2.EFFDT) FROM PSXLATITEM G2 WHERE G2.FIELDNAME = G.FIELDNAME AND G2.FIELDVALUE = G.FIELDVALUE AND G2.EFFDT <= O.EFFDT) AND H.FIELDNAME = 'SSR_COMPONENT' AND H.FIELDVALUE = O.SSR_COMPONENT AND H.EFFDT = ( SELECT MAX(H2.EFFDT) FROM PSXLATITEM H2 WHERE H2.FIELDNAME = H.FIELDNAME AND H2.FIELDVALUE = H.FIELDVALUE AND H2.EFFDT <= O.EFFDT)

  • Related Language Record: SSR_BCDEL_SFFVL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    5 SSR_CRSE_TYPOFF_CD Character(10) VARCHAR2(10) NOT NULL Course Typically Offered
    6 SSR_GRADING_BASIS Character(30) VARCHAR2(30) NOT NULL Grading Basis
    7 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.
    8 SSR_OEE_IND_DESCR Character(3) VARCHAR2(3) NOT NULL Open Entry/Exit Indicator Description
    9 SSR_CAREER_DESC_ES Character(30) VARCHAR2(30) NOT NULL Career Description
    10 SSR_COMPO_DESCR_ES Character(30) VARCHAR2(30) NOT NULL Component Description
    11 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    12 SSR_ACAD_ORG_DESCR Character(30) VARCHAR2(30) NOT NULL Academic Organization Description
    13 CRSE_ATTR Character(4) VARCHAR2(4) NOT NULL Course Attribute
    14 CRSE_ATTR_VALUE Character(10) VARCHAR2(10) NOT NULL Course Attribute Value
    15 SSR_NUM_UNITS_ES Character(30) VARCHAR2(30) NOT NULL Number of Units
    16 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    17 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
    18 SSR_CRS_ATTR_FL Character(70) VARCHAR2(70) NOT NULL Course Attribute
    19 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
    CLN=Clinical
    CON=Continuance
    DIS=Discussion
    FLD=Field Studies
    IND=Independent Study
    LAB=Laboratory
    LEC=Lecture
    PRA=Practicum
    RSC=Research
    SEM=Seminar
    SUP=Supervision
    THE=Thesis Research
    TUT=Tutorial
    20 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    21 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
    22 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    23 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    24 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    25 SSR_CRSE_TYPOFF_YN Character(1) VARCHAR2(1) NOT NULL Student Records Course Typically Offered Yes or No
    N=No
    Y=Yes
    26 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
    ANC=ABC/NC Grading
    AUD=Audit
    BMT=Multi-Term Course: Not Graded
    CNC=Credit / No Credit
    EQV=Equivalent
    GRD=Graded
    HSC=Hundred Point Scale (NLD)
    LAW=Law
    MED=Medical School Grades
    NOG=No Grade Associated
    NON=Non-Graded Component
    NQF=NQF Scale
    OPT=Student Option
    PNP=Pass/Not Pass
    SUS=Satisfactory/Unsatisfactory
    TRN=Transfer Grading Basis
    TSC=Ten Point Scale (NLD)
    27 OEE_IND Character(1) VARCHAR2(1) NOT NULL Allow OEE Enrollment