CAN_RPT_STD_CRS

(SQL Table)
 Index Back

CAN Student Course Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 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
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

4 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_TBL

5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

Prompt Table: CRSE_CATALOG

6 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number

Default Value: 1

7 CAN_ESIS_CR_COST Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)

Default Value: CAN_RPT_CRSE.CAN_ESIS_CR_COST

8 CAN_ESIS_CR_BROK Character(1) VARCHAR2(1) NOT NULL Brokered Course * Sac-r75-19990831
1=Yes-Institution is Sponsor
2=Yes- Institution is Host
3=No
9=Unknown

Default Value: CAN_RPT_CRSE.CAN_ESIS_CR_BROK

9 CAN_ESIS_CR_DIST Character(1) VARCHAR2(1) NOT NULL Dist. Ed * Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
10 CAN_ESIS_CR_ROOM Character(1) VARCHAR2(1) NOT NULL Class Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
11 CAN_ESIS_CR_CORR Character(1) VARCHAR2(1) NOT NULL Correspondence * Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
12 CAN_ESIS_CR_INTR Character(1) VARCHAR2(1) NOT NULL Internet * Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
13 CAN_ESIS_CR_VID Character(1) VARCHAR2(1) NOT NULL Video Conf. Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
14 CAN_ESIS_CR_AUD Character(1) VARCHAR2(1) NOT NULL Audio Conf. * Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
15 CAN_ESIS_CR_TV Character(1) VARCHAR2(1) NOT NULL Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
16 CAN_ESIS_CR_RAD Character(1) VARCHAR2(1) NOT NULL Radio * Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)
17 CAN_ESIS_CR_OTHR Character(1) VARCHAR2(1) NOT NULL Other * Sac-r75-19990831
1=Yes
2=No
9=Unknown
N=No (A)
U=Unknown (A)
Y=Yes (A)