SSR_AC_EXTNDVW2

(SQL View)
Index Back

Extenuating Circum Detail View

Extenuating Circumstances Detail View

SELECT A.SSR_AC_CONTX_TYPE ,A.SSR_AC_CONTENT_TP ,A.SSR_AC_EXTN_CODE ,A.EFFDT ,B.DESCR50 ,B.SSR_AC_EXTN_IAM ,B.SSR_AC_EXTN_RSLT FROM PS_SSR_AC_EXTN_DTL A , PS_SSR_AC_EXTN_TBL B 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 B.SSR_AC_EXTN_IAM = 'Y'

  • Parent record: SSR_AC_EXTNDLN2
  • # 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 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 SSR_AC_EXTN_IAM Character(1) VARCHAR2(1) NOT NULL Activity Status

    Y/N Table Edit

    Default Value: N

    7 SSR_AC_EXTN_RSLT Character(1) VARCHAR2(1) NOT NULL Result Status

    Y/N Table Edit

    Default Value: N