SSS_CRSPLN_ITEM

(SQL View)
 Index Back

My Planner


SELECT a.EMPLID , a.ACAD_CAREER , a.INSTITUTION , a.SAA_PLNR_SEQ , a.STRM , a.SUBJECT , a.CATALOG_NBR , a.SAA_PLNR_CRSE_SEQ , a.CRSE_ID , a.CRSE_OFFER_NBR , a.CRS_TOPIC_ID , a.UNT_TAKEN , a.SAA_ADD_RG , a.SAA_ADD_RQ , a.SAA_ADD_RQL , a.SAA_USED_RG , a.SAA_USED_RQ , a.SAA_USED_RQL , a.LASTUPDOPRID , a.LASTUPDDTTM FROM PS_SSS_CRSE_PLNR a

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

Prompt Table: STDNT_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
4 SAA_PLNR_SEQ Number(2,0) SMALLINT NOT NULL Planner Sequence Number
5 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_TBL

6 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

Prompt Table: SUBJECT_TBL

7 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
8 SAA_PLNR_CRSE_SEQ Number(3,0) SMALLINT NOT NULL Planner Course Sequence Number
9 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

Prompt Table: CRSE_CATALOG

10 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
11 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
12 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
13 SAA_ADD_RG Character(6) VARCHAR2(6) NOT NULL Added RG

Prompt Table: RQ_GRP_TBL

14 SAA_ADD_RQ Character(9) VARCHAR2(9) NOT NULL Added RG

Prompt Table: RQ_MAIN_TBL

15 SAA_ADD_RQL Character(4) VARCHAR2(4) NOT NULL Added RG

Prompt Table: RQ_LINE_TBL

16 SAA_USED_RG Character(6) VARCHAR2(6) NOT NULL Added RG

Prompt Table: RQ_GRP_TBL

17 SAA_USED_RQ Character(9) VARCHAR2(9) NOT NULL Added RG

Prompt Table: RQ_MAIN_TBL

18 SAA_USED_RQL Character(4) VARCHAR2(4) NOT NULL Added RG

Prompt Table: RQ_LINE_TBL

19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.