SSR_IAM_TREEWKV

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSR_EXPAND_COLLAPS	Character(1)	VARCHAR2(1) NOT NULL	Expand / Collapse
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	SSR_DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This field is used for holding the 80 character description used in the xml file for post enrollment requisite check reports.
4	BACK_PB	Character(1)	VARCHAR2(1) NOT NULL	Back
5	PAGE_NUM	Number(4,0)	SMALLINT NOT NULL	Page #
6	PAGEID	Character(18)	VARCHAR2(18) NOT NULL	Page ID for discounts and perks category pages.
7	FORWARD_SW	Character(1)	VARCHAR2(1) NOT NULL	Forward
8	SSR_ACTIVITY_ID	Character(11)	VARCHAR2(11) NOT NULL	Academic Activity ID
9	SSR_ACT_ID_SEQ_NBR	Number(4,0)	SMALLINT NOT NULL	Activity ID Sequence Number
10	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
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
13	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
14	SESSION_CODE	Character(3)	VARCHAR2(3) NOT NULL	Session 1=Regular Academic Session 10W=10 Week 12W=Twelve Week 4W1=Four Week - First 4W2=Four Week - Second 4W3=Four Week - Third 4W4=Four Week - Fourth 6W1=Six Week - First 6W2=Six Week - Second 8W1=Eight Week - First 8W2=Eight Week - Second A11=Medical Period 1, 4 Weeks A12=Medical Period 1, 8 Weeks A13=Medical Pd 1, 12 Weeks A21=Medical Period 2, 4 Weeks A22=Medical Period 2, 8 Weeks A23=Medical Period 2, 12 Week FYR=Full Year MIN=Mini Session OEE=Open Entry/Open Exit SM1=Semester 1 SM2=Semester 2
15	CLASS_SECTION	Character(4)	VARCHAR2(4) NOT NULL	Class Section
16	ASSOCIATED_CLASS	Number(4,0)	SMALLINT NOT NULL	Class Association
17	CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Class Nbr
18	SSR_CW_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Mandatory
19	SSR_AC_DEFAULT	Character(1)	VARCHAR2(1) NOT NULL	Default Mark
20	SSR_ACT_ID_ROOT	Character(11)	VARCHAR2(11) NOT NULL	Course Root Activity ID
21	SSR_ACO_TREE_LVL	Number(3,0)	SMALLINT NOT NULL	Level 1 Row
22	SSR_SEQ_NBR7	Number(7,0)	INTEGER NOT NULL	Sequence Number
23	SSR_CW_XTRA_CR	Character(1)	VARCHAR2(1) NOT NULL	Extra Credit
24	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
25	SSR_ACM_IND_CONT	Character(1)	VARCHAR2(1) NOT NULL	Individualized Content
26	SSR_PERIOD_ID	Character(12)	VARCHAR2(12) NOT NULL	Academic Period ID
27	SSR_SUP_RESIT	Character(1)	VARCHAR2(1) NOT NULL	This field indicates if resits are allowed.
28	SSR_AC_REQ_COND	Number(3,0)	SMALLINT NOT NULL	Select
29	SSR_AC_CONNECTOR	Character(1)	VARCHAR2(1) NOT NULL	Connector (=Open Parenthesis )=Close Parenthesis A=And O=Or
30	SSR_CW_CONF_REQ	Character(1)	VARCHAR2(1) NOT NULL	Confirmation Required
31	SSR_AC_CONTENT_TP	Character(20)	VARCHAR2(20) NOT NULL	Academic Content Type
32	SSR_AC_ITEM_ID	Character(10)	VARCHAR2(10) NOT NULL	Content Item ID
33	PAGE_NUM_THRU	Number(4,0)	SMALLINT NOT NULL	Thru Page Number
34	SSR_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	Display in Self Service
35	SSR_IAM_OR_CONNECT	Character(1)	VARCHAR2(1) NOT NULL	OR Connector
36	SSR_PAGE_NUM_FROM	Number(4,0)	SMALLINT NOT NULL	Page From
37	SSR_PAGE_SCROLL_TO	Number(4,0)	SMALLINT NOT NULL	Scroll To
38	SSR_COMPONENT	Character(3)	VARCHAR2(3) NOT NULL	Course Component. CLN=Clinical CON=Continuance DIS=Discussion FLD=Field Studies IND=Independent Study LAB=Laboratory LEC=Lecture PRA=Practicum RSC=Research SEM=Seminar SUP=Supervision THE=Thesis Research TUT=Tutorial
39	SSR_AC_CONTENT_ID	Character(13)	VARCHAR2(13) NOT NULL	Activity Registry ID
40	SSR_CW_ASMT_CD	Character(4)	VARCHAR2(4) NOT NULL	Content Code
41	SSR_ACR_SHORT_LBL	Character(8)	VARCHAR2(8) NOT NULL	Content Code
42	ASSESSED	Character(1)	VARCHAR2(1) NOT NULL	Assessed Y/N Table Edit
43	SSR_CW_WEIGHT	Number(6,2)	DECIMAL(5,2) NOT NULL	Weighting Multiplier
44	SSR_MANDATORY_PASS	Character(1)	VARCHAR2(1) NOT NULL	Mandatory Pass Required Y/N Table Edit
45	SSR_PENALTY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Late Penalty Type C=Capped D=Daily Penalty F=Fixed N=No Penalty O=One Time W=Weekly
46	SSR_NO_MARK_DEF	Character(1)	VARCHAR2(1) NOT NULL	No Mark Option I=Blank Mark - Include T=Below Threshold - Exclude X=Blank Mark - Exclude
47	SSR_ACTIVTY_ID_PAR	Character(11)	VARCHAR2(11) NOT NULL	Parent Activity ID
48	SSR_GRIDCOLUMN_LOC	Number(5,0)	INTEGER NOT NULL	Grid Location
49	SSR_IAM_OR_SELCTED	Number(5,0)	INTEGER NOT NULL	Selected OR Activity
50	SSR_RES_MAP_ID	Character(12)	VARCHAR2(12) NOT NULL	Result Scale
51	SSR_RSLT_SEQ	Number(3,0)	SMALLINT NOT NULL	Result Sequence Nbr
52	SSR_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit
53	SSR_SELECT_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	Select Limits for Appointment 1=Use Program Term/Session Limit 2=Use Appointment Limit ID 3=Set Maximum Units
54	SSR_CONFIRM	Character(1)	VARCHAR2(1) NOT NULL	Confirmed Y/N Table Edit
55	SSR_RESITS_ALLOWED	Character(1)	VARCHAR2(1) NOT NULL	This field indicates if resits are allowed.
56	SSR_AM_LSTTXN_DTTM	DateTime(26)	TIMESTAMP	Last Change Transaction DTTM
57	SSR_IAM_SYNC_REQD	Character(1)	VARCHAR2(1) NOT NULL	Sync Required
58	SSR_EXAMPRD_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Exam Period Type REG=Regular Period RES=Resit Period
59	SSR_DESCRLONG	Long Character	CLOB	Description