SSR_IAM_ACTANVW

(SQL View)
 Index Back

AnonGrading Resit View


SELECT INSTITUTION , EMPLID , SSR_ACTIVITY_ID , SSR_ACT_ID_SEQ_NBR , SSR_ACT_ID_ROOT , SSR_IAM_RESIT_FLAG FROM PS_SSR_IAM a WHERE EXISTS ( SELECT 'X' FROM PS_SSR_ACMCONT_ITM B WHERE a.INSTITUTION = B.INSTITUTION AND a.SSR_ACT_ID_ROOT = B.SSR_ACTIVITY_ID AND B.SSR_BLIND_GRADED = 'Y' AND a.SSR_ACTIVITY_ID = B.SSR_ACTIVITY_ID) UNION SELECT INSTITUTION , EMPLID , SSR_ACTIVITY_ID , SSR_ACT_ID_SEQ_NBR , SSR_ACT_ID_ROOT , ssr_iam_resit_flag FROM PS_SSR_IAM A WHERE EXISTS ( SELECT 'X' FROM PS_SSR_ACMCONT_ITM B WHERE A.INSTITUTION = B.INSTITUTION AND A.SSR_ACT_ID_ROOT = B.SSR_ACTIVITY_ID AND B.SSR_BLIND_GRADED = 'Y' AND A.SSR_ACTIVITY_ID <> B.SSR_ACTIVITY_ID) AND SSR_IAM_RESIT_FLAG = 'Y' AND SSR_IAM_ACT_STATUS = 'SR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: SSR_IAM_EMPLVW

3 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID

Prompt Table: SSR_ACT_ROOTVW3

4 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number
5 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID

Prompt Table: SSR_ACT_ROOTVW3

6 SSR_IAM_RESIT_FLAG Character(1) VARCHAR2(1) NOT NULL Resit