SSR_RUN_GDPST_H (SQL Table)	Index Back
Run Control for Grade Posting SSR_RUN_GDPST_H contains fields that are used as input parameters for the Grade Posting Process. Input data is retrieved from this record when this process is initiated from the Process Scheduler.

SSR_RUN_GDPST_H

(SQL Table)

Run Control for Grade Posting

SSR_RUN_GDPST_H contains fields that are used as input parameters for the Grade Posting Process. Input data is retrieved from this record when this process is initiated from the Process Scheduler.

# 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

3 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

4 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
Prompt Table: ACAD_ORG_TBL_VW

5 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
Prompt Table: SUBJECT_TBL

6 GRADE_ROSTER_TYPE Character(4) VARCHAR2(4) NOT NULL Grade Roster
FIN=Final Grade
MID=Mid-Term Grade
Default Value: FIN

7 OVRD_GRD_RSTR_OPT Character(1) VARCHAR2(1) NOT NULL Override Existing Grade Roster
C=Class Specific
N=No
Y=Yes
Default Value: N

8 PARTIAL_POST_OPT Character(3) VARCHAR2(3) NOT NULL Partial Post Option
N=No
Y=Yes
Default Value: N

9 END_DT Date(10) DATE end date

10 TOT_GRD_RSTR_TYPE Number(3,0) SMALLINT NOT NULL Total Grade Roster Type
Default Value: 1

11 BEGIN_DT Date(10) DATE Begin Date

#	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
3	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
4	ACAD_ORG	Character(10)	VARCHAR2(10) NOT NULL	Academic Organization Prompt Table: ACAD_ORG_TBL_VW
5	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area Prompt Table: SUBJECT_TBL
6	GRADE_ROSTER_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Grade Roster FIN=Final Grade MID=Mid-Term Grade Default Value: FIN
7	OVRD_GRD_RSTR_OPT	Character(1)	VARCHAR2(1) NOT NULL	Override Existing Grade Roster C=Class Specific N=No Y=Yes Default Value: N
8	PARTIAL_POST_OPT	Character(3)	VARCHAR2(3) NOT NULL	Partial Post Option N=No Y=Yes Default Value: N
9	END_DT	Date(10)	DATE	end date
10	TOT_GRD_RSTR_TYPE	Number(3,0)	SMALLINT NOT NULL	Total Grade Roster Type Default Value: 1
11	BEGIN_DT	Date(10)	DATE	Begin Date