SAD_RUN_OWO_NLD (SQL Table)	Index Back
Run control OWO create /print Run control record, used for creating and printing the OWO ICE1301744000 - June 22nd 2005: Field student career number has flexible prompt table now (edittable2).

SAD_RUN_OWO_NLD

(SQL Table)

Run control OWO create /print

Run control record, used for creating and printing the OWO ICE1301744000 - June 22nd 2005: Field student career number has flexible prompt table now (edittable2).

# 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: INSTITUTN_SCRTY

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: HCR_PERSON_NM_I

5 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
Prompt Table: %EDITTABLE2

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

7 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
Default Value: OPR_DEF_TBL_CS.ACAD_CAREER
Prompt Table: ACAD_CAR_SCRTY

8 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
Prompt Table: ACAD_PROG_SCTY

9 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
Prompt Table: HOME_CAMPUS_VW

10 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
Prompt Table: HCR_ADDR_TYP_I

11 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
Prompt Table: HCR_NM_TYP_I

12 SEL_CRITERIA_LBL Character(1) VARCHAR2(1) NOT NULL Selection Criteria
Y/N Table Edit
Default Value: N

13 COUNT_TOTAL Number(2,0) SMALLINT NOT NULL Award Count

14 SAD_LASTFILEDT_NLD Date(10) DATE Last run date of the OWO print process

15 SAD_OWO_GRPSEL_NLD Character(1) VARCHAR2(1) NOT NULL Edit table for OWO selection pages (student group table, enrollment block header of class table)
B=Student block header
C=Class table
G=Student Group table

16 SAD_OWO_GROUP_NLD Character(5) VARCHAR2(5) NOT NULL The OWO group used in OWO selection pages. The contents depends on the selection made (class, block or group), see field SAD_OWO_GRPSEL_NLD
Prompt Table: %EDITTABLE

17 END_DATE Date(10) DATE End Date

18 START_DATE Date(10) DATE Start Date for Gen Standing PO

19 CURRENT_DT Date(10) DATE Current Effective Date
Default Value: %date

20 SAD_NW_CONTRCT_NLD Character(1) VARCHAR2(1) NOT NULL Indicator (Y/N) in run control record to set the status of the current contract to inactive and create a new one with a new contract number.
Y/N Table Edit
Default Value: N

21 STDNT_ENRL_BLOCK Character(5) VARCHAR2(5) NOT NULL Student Enrollment Block

22 SAD_AVB_NLD Character(1) VARCHAR2(1) NOT NULL Indicator for selecting the default AVB appendix or manual selection of appendixes from the AVB appendix table.

#	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: INSTITUTN_SCRTY
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: HCR_PERSON_NM_I
5	STDNT_CAR_NBR	Number(3,0)	SMALLINT NOT NULL	Student Career Nbr Prompt Table: %EDITTABLE2
6	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: TERM_TBL
7	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 Default Value: OPR_DEF_TBL_CS.ACAD_CAREER Prompt Table: ACAD_CAR_SCRTY
8	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: ACAD_PROG_SCTY
9	CAMPUS	Character(5)	VARCHAR2(5) NOT NULL	Campus Prompt Table: HOME_CAMPUS_VW
10	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type Prompt Table: HCR_ADDR_TYP_I
11	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name Prompt Table: HCR_NM_TYP_I
12	SEL_CRITERIA_LBL	Character(1)	VARCHAR2(1) NOT NULL	Selection Criteria Y/N Table Edit Default Value: N
13	COUNT_TOTAL	Number(2,0)	SMALLINT NOT NULL	Award Count
14	SAD_LASTFILEDT_NLD	Date(10)	DATE	Last run date of the OWO print process
15	SAD_OWO_GRPSEL_NLD	Character(1)	VARCHAR2(1) NOT NULL	Edit table for OWO selection pages (student group table, enrollment block header of class table) B=Student block header C=Class table G=Student Group table
16	SAD_OWO_GROUP_NLD	Character(5)	VARCHAR2(5) NOT NULL	The OWO group used in OWO selection pages. The contents depends on the selection made (class, block or group), see field SAD_OWO_GRPSEL_NLD Prompt Table: %EDITTABLE
17	END_DATE	Date(10)	DATE	End Date
18	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
19	CURRENT_DT	Date(10)	DATE	Current Effective Date Default Value: %date
20	SAD_NW_CONTRCT_NLD	Character(1)	VARCHAR2(1) NOT NULL	Indicator (Y/N) in run control record to set the status of the current contract to inactive and create a new one with a new contract number. Y/N Table Edit Default Value: N
21	STDNT_ENRL_BLOCK	Character(5)	VARCHAR2(5) NOT NULL	Student Enrollment Block
22	SAD_AVB_NLD	Character(1)	VARCHAR2(1) NOT NULL	Indicator for selecting the default AVB appendix or manual selection of appendixes from the AVB appendix table.