SSR_IAM_ACTBLK1 (SQL Table)	Index Back
Activity Block Selections Activity Block Selections Header for Courses

SSR_IAM_ACTBLK1

(SQL Table)

Activity Block Selections

Activity Block Selections Header for Courses

Related Language Record: SSR_IAM_ACBK1LN

Parent Record Of SSR_IAM_ACMRTVW SSR_IAM_BLACTVW SSR_IAM_BLKRTVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SSR_IAM_ACT_BLK_ID Character(20) VARCHAR2(20) NOT NULL Activity Block ID

3 SSR_IAM_BLK_EXMFLG Character(1) VARCHAR2(1) NOT NULL Display Exam Activities Only
Y/N Table Edit
Default Value: N

4 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.

5 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

6 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

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

8 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

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

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

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

12 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By

13 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created

14 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By

15 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	SSR_IAM_ACT_BLK_ID	Character(20)	VARCHAR2(20) NOT NULL	Activity Block ID
3	SSR_IAM_BLK_EXMFLG	Character(1)	VARCHAR2(1) NOT NULL	Display Exam Activities Only Y/N Table Edit Default Value: N
4	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.
5	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
6	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
7	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection Prompt Table: %EDITTABLE
8	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
9	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
10	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
11	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name
12	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
13	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
14	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
15	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time