SSR_AC_EXTNDLN1

(SQL View)
 Index Back

Extenuating Circumstances Dtl

Extenuating Circumstances Detail

SELECT A.SSR_AC_CONTX_TYPE ,A.SSR_AC_CONTENT_TP ,A.SSR_AC_EXTN_CODE ,A.EFFDT ,L.LANGUAGE_CD ,L.DESCR50 FROM PS_SSR_AC_EXTN_DTL A , PS_SSR_AC_EXTN_TBL B , PS_SSR_AC_EXTNTBLN L WHERE B.SSR_AC_CONTX_TYPE = A.SSR_AC_CONTX_TYPE AND B.SSR_AC_EXTN_CODE = A.SSR_AC_EXTN_CODE AND B.EFFDT = A.EFFDT AND L.SSR_AC_CONTX_TYPE = B.SSR_AC_CONTX_TYPE AND L.SSR_AC_EXTN_CODE = B.SSR_AC_EXTN_CODE AND L.EFFDT = B.EFFDT AND B.SSR_AC_EXTN_RSLT = 'Y'

  • Related Language Record for SSR_AC_EXTNDVW1

  • Parent record: SSR_AC_EXTN_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_AC_CONTX_TYPE Character(4) VARCHAR2(4) NOT NULL Academic Content Context Type
    CRSE=Coursework
    2 SSR_AC_CONTENT_TP Character(20) VARCHAR2(20) NOT NULL Academic Content Type

    Prompt Table: SSR_AC_ITEMTYPE

    3 SSR_AC_EXTN_CODE Character(12) VARCHAR2(12) NOT NULL Extenuating Circumstances
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50