SSR_IAM_ROOTVW

#	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	SSR_ACT_ID_SEQ_NBR	Number(4,0)	SMALLINT NOT NULL	Activity ID Sequence Number Default Value: 1
6	SSR_IAM_ACTIVE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag Y/N Table Edit Default Value: Y
7	SSR_IAM_ATTMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Valid Attempt Y/N Table Edit Default Value: Y
8	SSR_SEQ_NBR7	Number(7,0)	INTEGER NOT NULL	Sequence Number
9	SSR_ACO_TREE_LVL	Number(3,0)	SMALLINT NOT NULL	Level 1 Row
10	SSR_ACTIVTY_ID_PAR	Character(11)	VARCHAR2(11) NOT NULL	Parent Activity ID
11	SSR_ACT_PAR_SQ_NBR	Number(4,0)	SMALLINT NOT NULL	Parent Activity ID Seq NBR Default Value: 1
12	SSR_ACTIVTY_ID_ORG	Character(11)	VARCHAR2(11) NOT NULL	Original Parent Activity ID
13	SSR_ACT_ORG_SQ_NBR	Number(4,0)	SMALLINT NOT NULL	Original Activity ID Seq NBR Default Value: 1
14	SSR_IAM_ACTID_RSIT	Character(11)	VARCHAR2(11) NOT NULL	Resit Activity
15	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
16	SSR_IAM_LOCK	Character(1)	VARCHAR2(1) NOT NULL	Locked Y/N Table Edit Default Value: N
17	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
18	SSR_IAM_RESIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Resit Y/N Table Edit Default Value: N
19	SSR_AC_INSF_INC	Character(1)	VARCHAR2(1) NOT NULL	Insufficient Mark Options Y/N Table Edit Default Value: N
20	SSR_AC_ATT_INC	Character(1)	VARCHAR2(1) NOT NULL	Attendance Tracking Options Y/N Table Edit Default Value: N
21	SSR_AC_LATE_INC	Character(1)	VARCHAR2(1) NOT NULL	Late Content Penalty Options Y/N Table Edit Default Value: N
22	SSR_AC_DATES_INC	Character(1)	VARCHAR2(1) NOT NULL	Dates and Durations Y/N Table Edit Default Value: N
23	SSR_AC_DEVS_INC	Character(1)	VARCHAR2(1) NOT NULL	Content Devices Y/N Table Edit Default Value: N
24	SSR_AC_ENROLL_INC	Character(1)	VARCHAR2(1) NOT NULL	Enrollment Related Options Y/N Table Edit Default Value: N
25	SSR_AC_EXTN_CODE	Character(12)	VARCHAR2(12) NOT NULL	Extenuating Circumstances Prompt Table: SSR_AC_EXTNDVW2
26	SSR_AM_LSTTXN_DTTM	DateTime(26)	TIMESTAMP	Last Change Transaction DTTM Default Value: %datetime
27	SSR_IAM_ACT_STATSV	Character(2)	VARCHAR2(2) NOT NULL	Saved Activity Status
28	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
29	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
30	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
31	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time