SSR_BCDEL_LFFVL

(SQL View)
 Index Back

SR Browse Cat Del Rel Lng LFF

Student Records Browse Catalog Delete Related Language Record for Large 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 ,ACL.DESCR ,H.XLATLONGNAME ,O.CAMPUS ,AO.DESCR ,O.CRSE_ATTR ,O.CRSE_ATTR_VALUE ,O.SSR_NUM_UNITS_ES ,ATL.LANGUAGE_CD ,CASE WHEN ATL.DESCR1 <> ' ' THEN CASE WHEN OP.SSR_CLSCFG_ATTRVAL = 'Y' THEN ATL.DESCR1 || '/' || ATL.DESCR2 ELSE ATL.DESCR1 END ELSE '' END ,ATL.DESCR1 ,ATL.DESCR2 FROM PS_SSR_BCDEL_LFF O LEFT OUTER JOIN PS_SSR_CRATTAUD_VL ATL ON O.CRSE_ID = ATL.CRSE_ID AND O.EFFDT = ATL.EFFDT AND O.CRSE_OFFER_NBR = ATL.CRSE_OFFER_NBR AND O.CRSE_ATTR = ATL.CRSE_ATTR AND O.CRSE_ATTR_VALUE = ATL.CRSE_ATTR_VALUE ,PS_ACAD_CAR_TBL AC ,PS_ACAD_CAR_LANG ACL ,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 AC.INSTITUTION = ACL.INSTITUTION AND AC.ACAD_CAREER = ACL.ACAD_CAREER AND AC.EFFDT = ACL.EFFDT AND ACL.LANGUAGE_CD = ATL.LANGUAGE_CD 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 for SSR_BCDEL_LFFVW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    17 SSR_CRS_ATTR_FL Character(70) VARCHAR2(70) NOT NULL Course Attribute
    18 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    19 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2