SSR_IAM_VIEW (SQL View)	Index Back
View of SSR_IAM View of SSR_IAM

SSR_IAM_VIEW

(SQL View)

View of SSR_IAM

SELECT EMPLID ,INSTITUTION ,SSR_ACTIVITY_ID ,SSR_ACT_ID_SEQ_NBR ,SSR_IAM_ACTIVE_FLG ,SSR_IAM_ATTMPT_FLG ,SSR_SEQ_NBR7 ,SSR_ACO_TREE_LVL ,SSR_ACTIVTY_ID_PAR ,SSR_ACT_PAR_SQ_NBR ,SSR_ACTIVTY_ID_ORG ,SSR_ACT_ORG_SQ_NBR ,SSR_IAM_ACTID_RSIT ,SSR_IAM_ACT_STATUS ,SSR_IAM_LOCK ,SSR_IAM_ACT_SOURCE ,SSR_IAM_RESIT_FLAG ,SSR_ACT_ID_ROOT ,SSR_AC_EXTN_CODE ,SSR_AM_LSTTXN_DTTM ,SSR_IAM_ACT_STATSV FROM PS_SSR_IAM

# 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_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID

4 SSR_ACT_ID_SEQ_NBR Number(4,0) SMALLINT NOT NULL Activity ID Sequence Number
Default Value: 1

5 SSR_IAM_ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Active Flag
Y/N Table Edit
Default Value: Y

6 SSR_IAM_ATTMPT_FLG Character(1) VARCHAR2(1) NOT NULL Valid Attempt
Y/N Table Edit
Default Value: Y

7 SSR_SEQ_NBR7 Number(7,0) INTEGER NOT NULL Sequence Number

8 SSR_ACO_TREE_LVL Number(3,0) SMALLINT NOT NULL Level 1 Row

9 SSR_ACTIVTY_ID_PAR Character(11) VARCHAR2(11) NOT NULL Parent Activity ID

10 SSR_ACT_PAR_SQ_NBR Number(4,0) SMALLINT NOT NULL Parent Activity ID Seq NBR
Default Value: 1

11 SSR_ACTIVTY_ID_ORG Character(11) VARCHAR2(11) NOT NULL Original Parent Activity ID

12 SSR_ACT_ORG_SQ_NBR Number(4,0) SMALLINT NOT NULL Original Activity ID Seq NBR
Default Value: 1

13 SSR_IAM_ACTID_RSIT Character(11) VARCHAR2(11) NOT NULL Resit Activity

14 SSR_IAM_ACT_STATUS Character(2) VARCHAR2(2) NOT NULL Activity Status
A=Assigned
AC=Assigned - confirmed
AX=Assigned - requires confirmtn
D=Dropped
E=Enrolled
EC=Enrolled - Confirmed
ED=Enrolled by Default
EE=Enrolled
EX=Enrolled - Confirmation Req'd
RA=Resit Allowed
RC=Resit Candidate
RD=Resit Delete
RN=Resit Not Allowed
RR=Reassessed
RS=Resit Select
S=Selected
SC=Selected - confirmed
SD=Selected by Default
SR=Selected as Resit
SX=Selected - requires confirmatn
WD=Withdrawn
WL=Waitlisted
X=Inactive

15 SSR_IAM_LOCK Character(1) VARCHAR2(1) NOT NULL Locked
Y/N Table Edit
Default Value: N

16 SSR_IAM_ACT_SOURCE Character(3) VARCHAR2(3) NOT NULL Enrollment Source
A=Admin
AM=Activity Management Sync
APT=Batch APT
B=Batch
BLK=Block Process
RST=Resit Evaluation
SE=Batch Student Enroll
SS=Self Service
Default Value: A

17 SSR_IAM_RESIT_FLAG Character(1) VARCHAR2(1) NOT NULL Resit
Y/N Table Edit
Default Value: N

18 SSR_ACT_ID_ROOT Character(11) VARCHAR2(11) NOT NULL Course Root Activity ID

19 SSR_AC_EXTN_CODE Character(12) VARCHAR2(12) NOT NULL Extenuating Circumstances
Prompt Table: SSR_AC_EXTNDVW2

20 SSR_AM_LSTTXN_DTTM DateTime(26) TIMESTAMP Last Change Transaction DTTM
Default Value: %datetime

21 SSR_IAM_ACT_STATSV Character(2) VARCHAR2(2) NOT NULL Saved Activity Status

#	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_ACTIVITY_ID	Character(11)	VARCHAR2(11) NOT NULL	Academic Activity ID
4	SSR_ACT_ID_SEQ_NBR	Number(4,0)	SMALLINT NOT NULL	Activity ID Sequence Number Default Value: 1
5	SSR_IAM_ACTIVE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag Y/N Table Edit Default Value: Y
6	SSR_IAM_ATTMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Valid Attempt Y/N Table Edit Default Value: Y
7	SSR_SEQ_NBR7	Number(7,0)	INTEGER NOT NULL	Sequence Number
8	SSR_ACO_TREE_LVL	Number(3,0)	SMALLINT NOT NULL	Level 1 Row
9	SSR_ACTIVTY_ID_PAR	Character(11)	VARCHAR2(11) NOT NULL	Parent Activity ID
10	SSR_ACT_PAR_SQ_NBR	Number(4,0)	SMALLINT NOT NULL	Parent Activity ID Seq NBR Default Value: 1
11	SSR_ACTIVTY_ID_ORG	Character(11)	VARCHAR2(11) NOT NULL	Original Parent Activity ID
12	SSR_ACT_ORG_SQ_NBR	Number(4,0)	SMALLINT NOT NULL	Original Activity ID Seq NBR Default Value: 1
13	SSR_IAM_ACTID_RSIT	Character(11)	VARCHAR2(11) NOT NULL	Resit Activity
14	SSR_IAM_ACT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Activity Status A=Assigned AC=Assigned - confirmed AX=Assigned - requires confirmtn D=Dropped E=Enrolled EC=Enrolled - Confirmed ED=Enrolled by Default EE=Enrolled EX=Enrolled - Confirmation Req'd RA=Resit Allowed RC=Resit Candidate RD=Resit Delete RN=Resit Not Allowed RR=Reassessed RS=Resit Select S=Selected SC=Selected - confirmed SD=Selected by Default SR=Selected as Resit SX=Selected - requires confirmatn WD=Withdrawn WL=Waitlisted X=Inactive
15	SSR_IAM_LOCK	Character(1)	VARCHAR2(1) NOT NULL	Locked Y/N Table Edit Default Value: N
16	SSR_IAM_ACT_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Enrollment Source A=Admin AM=Activity Management Sync APT=Batch APT B=Batch BLK=Block Process RST=Resit Evaluation SE=Batch Student Enroll SS=Self Service Default Value: A
17	SSR_IAM_RESIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Resit Y/N Table Edit Default Value: N
18	SSR_ACT_ID_ROOT	Character(11)	VARCHAR2(11) NOT NULL	Course Root Activity ID
19	SSR_AC_EXTN_CODE	Character(12)	VARCHAR2(12) NOT NULL	Extenuating Circumstances Prompt Table: SSR_AC_EXTNDVW2
20	SSR_AM_LSTTXN_DTTM	DateTime(26)	TIMESTAMP	Last Change Transaction DTTM Default Value: %datetime
21	SSR_IAM_ACT_STATSV	Character(2)	VARCHAR2(2) NOT NULL	Saved Activity Status