SSR_IAM_CAL_AET (SQL Table)	Index Back
Batch IAM Result Calculation This table is a state record used by Batch IAM Result Calculation

SSR_IAM_CAL_AET

(SQL Table)

Batch IAM Result Calculation

This table is a state record used by Batch IAM Result Calculation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 SCCPS_POP_SEL Character(1) VARCHAR2(1) NOT NULL Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.
Y/N Table Edit
Default Value: Y

5 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool
Prompt Table: SCCPS_TOOL_VW

6 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection
Prompt Table: %EDITTABLE

7 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context
Prompt Table: SCCPS_CNTXT_VW

8 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

10 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name

11 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

12 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table: ACAD_CAR_TBL

13 STRM Character(4) VARCHAR2(4) NOT NULL Term
Prompt Table: TERM_TBL

14 SSR_PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Academic Period ID

15 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

16 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr

17 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID

18 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section

19 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

20 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

21 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr

22 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

23 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID

24 SSR_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Manager Status
C=Complete
L=Complete - Locked
P=Pending

25 SSR_AC_EXAM_ONLY Character(1) VARCHAR2(1) NOT NULL Exam Only Course

26 SSR_USE_FILTER_SEL Character(1) VARCHAR2(1) NOT NULL This field is used as a Y/N flag for deciding if classes can be manually entered for the class pop select.

27 SSR_IAM_CALC_NEW Character(1) VARCHAR2(1) NOT NULL Calculate New Result

28 SSR_IAM_CALC_BLANK Character(1) VARCHAR2(1) NOT NULL Prevent Calculation

29 SSR_IAM_CALC_CRSE Character(1) VARCHAR2(1) NOT NULL Course Content
Y/N Table Edit
Default Value: Y

30 SSR_IAM_CALC_COMP Character(1) VARCHAR2(1) NOT NULL Component Content
Y/N Table Edit
Default Value: Y

31 SSR_IAM_CALC_CAT Character(1) VARCHAR2(1) NOT NULL Category Content
Y/N Table Edit
Default Value: Y

32 SSR_IAM_CALC_EXAM Character(1) VARCHAR2(1) NOT NULL Exam Content
Y/N Table Edit
Default Value: Y

33 SSR_IAM_CALC_EXSEC Character(1) VARCHAR2(1) NOT NULL Exam Section Content
Y/N Table Edit
Default Value: Y

34 SSR_IAM_CALC_ATTD Character(1) VARCHAR2(1) NOT NULL Attendance Content
Y/N Table Edit
Default Value: Y

35 SSR_IAM_CALC_ASSM Character(1) VARCHAR2(1) NOT NULL Assessment Content
Y/N Table Edit
Default Value: Y

36 SSR_IAM_CALC_COND Character(1) VARCHAR2(1) NOT NULL Condition Content
Y/N Table Edit
Default Value: Y

37 SSR_DATE Date(10) DATE This field is used in the application engine program to process post enrollment requisite check reports and in other processes in student records.

38 SSR_TIME Time(15) TIMESTAMP This field is used by the application engine process to process post enrollment requisite check reports and in other processes in student records.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	SCCPS_POP_SEL	Character(1)	VARCHAR2(1) NOT NULL	Population Selection checkbox - used to incidate on run controls that pop selection was selected for use. Y/N Table Edit Default Value: Y
5	SCCPS_TOOL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Tool ID - the unique key for a pop select tool Prompt Table: SCCPS_TOOL_VW
6	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection Prompt Table: %EDITTABLE
7	SCCPS_CNTXT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Context ID - the unique key that identifies the pop selection context Prompt Table: SCCPS_CNTXT_VW
8	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
9	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
10	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name
11	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
12	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic Career BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine Prompt Table: ACAD_CAR_TBL
13	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: TERM_TBL
14	SSR_PERIOD_ID	Character(12)	VARCHAR2(12) NOT NULL	Academic Period ID
15	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
16	CRSE_OFFER_NBR	Number(2,0)	SMALLINT NOT NULL	Course Offering Nbr
17	CRS_TOPIC_ID	Number(3,0)	SMALLINT NOT NULL	Course Topic ID
18	CLASS_SECTION	Character(4)	VARCHAR2(4) NOT NULL	Class Section
19	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
20	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area
21	CATALOG_NBR	Character(10)	VARCHAR2(10) NOT NULL	Catalog Nbr
22	ACAD_ORG	Character(10)	VARCHAR2(10) NOT NULL	Academic Organization
23	SSR_ACTIVITY_ID	Character(11)	VARCHAR2(11) NOT NULL	Academic Activity ID
24	SSR_ACT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Activity Manager Status C=Complete L=Complete - Locked P=Pending
25	SSR_AC_EXAM_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Exam Only Course
26	SSR_USE_FILTER_SEL	Character(1)	VARCHAR2(1) NOT NULL	This field is used as a Y/N flag for deciding if classes can be manually entered for the class pop select.
27	SSR_IAM_CALC_NEW	Character(1)	VARCHAR2(1) NOT NULL	Calculate New Result
28	SSR_IAM_CALC_BLANK	Character(1)	VARCHAR2(1) NOT NULL	Prevent Calculation
29	SSR_IAM_CALC_CRSE	Character(1)	VARCHAR2(1) NOT NULL	Course Content Y/N Table Edit Default Value: Y
30	SSR_IAM_CALC_COMP	Character(1)	VARCHAR2(1) NOT NULL	Component Content Y/N Table Edit Default Value: Y
31	SSR_IAM_CALC_CAT	Character(1)	VARCHAR2(1) NOT NULL	Category Content Y/N Table Edit Default Value: Y
32	SSR_IAM_CALC_EXAM	Character(1)	VARCHAR2(1) NOT NULL	Exam Content Y/N Table Edit Default Value: Y
33	SSR_IAM_CALC_EXSEC	Character(1)	VARCHAR2(1) NOT NULL	Exam Section Content Y/N Table Edit Default Value: Y
34	SSR_IAM_CALC_ATTD	Character(1)	VARCHAR2(1) NOT NULL	Attendance Content Y/N Table Edit Default Value: Y
35	SSR_IAM_CALC_ASSM	Character(1)	VARCHAR2(1) NOT NULL	Assessment Content Y/N Table Edit Default Value: Y
36	SSR_IAM_CALC_COND	Character(1)	VARCHAR2(1) NOT NULL	Condition Content Y/N Table Edit Default Value: Y
37	SSR_DATE	Date(10)	DATE	This field is used in the application engine program to process post enrollment requisite check reports and in other processes in student records.
38	SSR_TIME	Time(15)	TIMESTAMP	This field is used by the application engine process to process post enrollment requisite check reports and in other processes in student records.