SSR_AC_EXTNDLN2 (SQL View)	Index Back
Extenuating Circumstances Dtl Extenuating Circumstances Detail

SSR_AC_EXTNDLN2

(SQL View)

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_IAM = 'Y'

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

#	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