SSR_EXM_DETVWLN

(SQL View)
 Index Back

My Exams Details View

Related Language for SSR_EXM_DET_VW

SELECT DISTINCT IAM.EMPLID , MT.INSTITUTION , IAM.SSR_ACT_ID_ROOT , MT.SSR_ACTIVITY_ID , TBL.LANGUAGE_CD , HDR.DESCR50 , TBL.DESCR , PERLNG.DESCR , CONT.DESCR50 FROM PS_SSR_PERIOD_TBL PERIOD , PS_SSR_PERIOD_LNG PERLNG , PS_SSR_ACMEXAM_EXT EXT , PS_SSR_IAM IAM , PS_SSR_ACM_SCTN_MT MT , PS_SSR_ACTIVITY ACT , PS_SSR_ACT_XREF XREF , PS_INSTITUTION_LNG TBL , PS_SSR_AIR_H_CRSE CRSE , PS_SSR_APT_ITEM ITEM , PS_SSR_AIR_HDR_LN HDR , PS_SSRACMCONTITLNG CONT WHERE PERIOD.INSTITUTION = EXT.INSTITUTION AND PERIOD.SSR_PERIOD_ID = EXT.SSR_PERIOD_ID AND PERIOD.SSR_PERIOD_TYPE = 'EXAM' AND PERLNG.INSTITUTION = PERIOD.INSTITUTION AND PERLNG.SSR_PERIOD_ID = PERIOD.SSR_PERIOD_ID AND IAM.INSTITUTION = EXT.INSTITUTION AND EXT.SSR_ACTIVITY_ID = IAM.SSR_ACTIVTY_ID_PAR AND MT.INSTITUTION = EXT.INSTITUTION AND MT.SSR_ACTIVITY_ID = IAM.SSR_ACTIVITY_ID AND ACT.SSR_ACTIVITY_ID = EXT.SSR_ACTIVITY_ID AND ACT.INSTITUTION = EXT.INSTITUTION AND XREF.SSR_ACTIVITY_ID = ACT.SSR_ACTIVITY_ID AND CRSE.INSTITUTION = IAM.INSTITUTION AND CRSE.CRSE_ID = XREF.CRSE_ID AND %EffdtCheck(SSR_AIR_H_CRSE CRSE_ED, CRSE, %CurrentDateIn) AND ITEM.EMPLID = IAM.EMPLID AND ITEM.INSTITUTION = IAM.INSTITUTION AND ITEM.SSR_ITEM_ID = CRSE.SSR_ITEM_ID AND HDR.INSTITUTION = ITEM.INSTITUTION AND HDR.SSR_ITEM_ID = ITEM.SSR_ITEM_ID AND %EffdtCheck(SSR_AIR_HDR HDR_ED, CRSE, %CurrentDateIn) AND TBL.INSTITUTION = PERIOD.INSTITUTION AND %EffdtCheck(INSTITUTION_TBL TBL_ED, TBL, %CurrentDateIn) AND CONT.INSTITUTION = ACT.INSTITUTION AND CONT.SSR_ACTIVITY_ID = MT.SSR_ACTIVITY_ID AND IAM.SSR_IAM_ACT_STATUS IN ('A', 'ED','EE','S', 'EC')

  • Related Language Record for SSR_EXM_DET_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
    4 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    9 SSR_AM_DESCR50 Character(50) VARCHAR2(50) NOT NULL This field is used to display the requisite enrollment type for the xml file for the post enrollment requisite check report.