RUN_CNTL_CONTRM (SQL Table)	Index Back
Run Control Term Category This is the run control term category record for the Academic Statistics Consolidation process.

RUN_CNTL_CONTRM

(SQL Table)

Run Control Term Category

This is the run control term category record for the Academic Statistics Consolidation process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 TERM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Term Category
0=Full Year
1=1st Semester
2=2nd Semester
3=Summer Session AUS
4=Winter Session AUS
C=Medical Clinical
I=Intersession Term
M=Medical Level 1
R=Regular Term
S=Summer Term
W=Winter Term

5 SSR_NSC_TERM_SKIP Character(1) VARCHAR2(1) NOT NULL NSC - Identify if term category should be skipped.
Y/N Table Edit
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
4	TERM_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Term Category 0=Full Year 1=1st Semester 2=2nd Semester 3=Summer Session AUS 4=Winter Session AUS C=Medical Clinical I=Intersession Term M=Medical Level 1 R=Regular Term S=Summer Term W=Winter Term
5	SSR_NSC_TERM_SKIP	Character(1)	VARCHAR2(1) NOT NULL	NSC - Identify if term category should be skipped. Y/N Table Edit Default Value: Y