SSR_IAM_BLK_TGT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	SSR_ACTIVITY_ID	Character(11)	VARCHAR2(11) NOT NULL	Academic Activity ID
5	SSR_ACT_ID_SEQ_NBR	Number(4,0)	SMALLINT NOT NULL	Activity ID Sequence Number
6	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
7	SSR_ACT_ID_ROOT	Character(11)	VARCHAR2(11) NOT NULL	Course Root Activity ID
8	SSR_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Select
9	SSR_REMOVE	Character(1)	VARCHAR2(1) NOT NULL	Removed
10	SSR_CONFIRM	Character(1)	VARCHAR2(1) NOT NULL	Confirmed
11	SSR_IAM_BLK_ERROPT	Character(1)	VARCHAR2(1) NOT NULL	Transaction Violation Action E=Error R=Remove previous selection S=Select to satisfy