ADM_SS_CLST1_VW

(SQL View)
Index Back

HA Admissions Checklist View

HTML Access Admissions Checklist View

SELECT A.COMMON_ID ,A.INSTITUTION ,D.ACAD_CAREER ,D.STDNT_CAR_NBR ,D.ADM_APPL_NBR FROM PS_PERSON_CHECKLST A , PS_CS_CHKLST_TBL B , PS_VAR_DATA_ADMA D WHERE A.CHECKLIST_CD = B.CHECKLIST_CD AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_CS_CHKLST_TBL C WHERE C.CHECKLIST_CD = A.CHECKLIST_CD AND A.CHECKLIST_STATUS = 'I' AND C.EFFDT <= %CurrentDateIn ) AND ( A.ADMIN_FUNCTION = 'ADMA' OR A.ADMIN_FUNCTION = 'ADMP' ) AND B.SCC_CHECKLIST_TYPE = 'RQL' AND A.COMMON_ID = D.COMMON_ID AND A.VAR_DATA_SEQ = D.VAR_DATA_SEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 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
4 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
5 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr