SAD_PB_CASOPRVW

(SQL View)
 Index Back

CAS Details

CAS Details

SELECT B.oprid ,A.emplid ,A.institution ,A.sad_pb_rec_type ,A.acad_career ,A.stdnt_car_nbr ,A.sad_pb_rec_number ,A.adm_appl_nbr ,A.appl_prog_nbr ,A.EFFDT ,A.EFFSEQ ,A.sad_pb_cas_number ,A.sad_pb_cas_status ,A.sad_pb_upload ,A.sad_pb_update ,A.sad_pb_report FROM ps_sad_pb_cas A , PSOPRDEFN B

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

4 SAD_PB_REC_TYPE Character(1) VARCHAR2(1) NOT NULL Record Type
A=Applicant
S=Student
5 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

Prompt Table: %EDITTABLE

6 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

Prompt Table: %EDITTABLE2

7 SAD_PB_REC_NUMBER Number(3,0) SMALLINT NOT NULL Record Number
8 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

Prompt Table: %EDITTABLE4

9 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr

Prompt Table: %EDITTABLE5

10 EFFDT Date(10) DATE NOT NULL Effective Date
11 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
12 SAD_PB_CAS_NUMBER Character(14) VARCHAR2(14) NOT NULL CAS Number
13 SAD_PB_CAS_STATUS Character(4) VARCHAR2(4) NOT NULL CAS Status
ASG=ASSIGNED
CNC=CANCELLED
EXP=EXPIRED
OBS=OBSOLETE
USD=USED
WDR=WITHDRAWN
14 SAD_PB_UPLOAD Character(4) VARCHAR2(4) NOT NULL New CAS Record
LCMP=Upload Complete
LRDY=Upload Ready
NEW=New
15 SAD_PB_UPDATE Character(4) VARCHAR2(4) NOT NULL Update Status
DCMP=Update Complete
DRDY=Update Ready
DRQD=Update Required
16 SAD_PB_REPORT Character(4) VARCHAR2(4) NOT NULL Report Status
RCMP=Report Complete
RRDY=Report Ready