SSR_IAM_RES_VW

(SQL View)
 Index Back

SELECT A.INSTITUTION , A.EMPLID , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_ROOT , B.SSR_ACT_ID_ROOTXRF , B.SSR_RSLT_TYPE , B.SSR_IAM_RSLT_STAT FROM PS_SSR_IAM A LEFT OUTER JOIN PS_SSR_IAM_RESULT B ON A.INSTITUTION = B.INSTITUTION AND A.EMPLID = B.EMPLID AND A.SSR_ACTIVITY_ID = B.SSR_ACTIVITY_ID AND A.SSR_ACT_ID_SEQ_NBR = B.SSR_ACT_ID_SEQ_NBR AND B.SSR_INCL_IN_CALC = 'Y'

# 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
3 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
4 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID
5 SSR_ACT_ID_ROOTXRF Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID Xref
6 SSR_RSLT_TYPE Character(20) VARCHAR2(20) NOT NULL Result Type

Prompt Table: SSR_IAM_RTYPVW1

7 SSR_IAM_RSLT_STAT Character(2) VARCHAR2(2) NOT NULL Result Status
00=00-Undetermined
05=05-Manual
07=07-Imported
10=10-Calculated
20=20-Awaiting Approval
30=30-Approved
40=40-Overridden
50=50-Final

Default Value: 00