SCC_RUN_STD_GRP (SQL Table)	Index Back
Batch Student Group Run Ctl Record used to initial the Batch Student Group App Engine Program. This record also utilizes the Population Selection sub record.

SCC_RUN_STD_GRP

(SQL Table)

Batch Student Group Run Ctl

Record used to initial the Batch Student Group App Engine Program. This record also utilizes the Population Selection sub record.

Parent record: PRCSRUNCNTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID

3 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

4 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

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

6 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

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

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

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

10 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTN_SCRTY

11 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group
Prompt Table: INST_STGPU_SCTY

12 ASOFDATE Date(10) DATE NOT NULL As of Date
Default Value: %date

13 SCC_EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

14 STDNT_OVRD Character(1) VARCHAR2(1) NOT NULL Student Override
Default Value: N

15 TUIT_CALC_REQ_LBL Character(1) VARCHAR2(1) NOT NULL Tuition Calc Required
Y/N Table Edit
Default Value: N

16 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPR_DEF_TBL_CS.OPRID
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Default Value: PRCSRUNCNTL.RUN_CNTL_ID
3	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
4	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
5	SCCPS_QUERY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Query / Section name used by population selection Prompt Table: %EDITTABLE
6	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
7	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
8	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
9	SCCPS_FILE_PATH	Character(254)	VARCHAR2(254) NOT NULL	Pop Select File Path and Name
10	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTN_SCRTY
11	STDNT_GROUP	Character(4)	VARCHAR2(4) NOT NULL	Student Group Prompt Table: INST_STGPU_SCTY
12	ASOFDATE	Date(10)	DATE NOT NULL	As of Date Default Value: %date
13	SCC_EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
14	STDNT_OVRD	Character(1)	VARCHAR2(1) NOT NULL	Student Override Default Value: N
15	TUIT_CALC_REQ_LBL	Character(1)	VARCHAR2(1) NOT NULL	Tuition Calc Required Y/N Table Edit Default Value: N
16	COMMENTS	Long Character	CLOB	Comment