MLSTN_TMPL_SVWL(SQL View) |
Index Back |
---|---|
Milestone Template RLang ViewThis view is used to retrieve milestone templates based on user access. |
SELECT D.OPRID , A.INSTITUTION , A.ACAD_CAREER , A.ACAD_PROG , A.ACAD_PLAN , A.EFFDT , B.MILESTONE_NBR , C.LANGUAGE_CD , C.DESCR , C.DESCRFORMAL FROM %Table(MLSTN_TMPL) A , %Table(MLSTN_TMPL_DETL) B , %Table(MLSTN_TMPL_D_LG) C , %Table(SCRTY_TBL_MLSTN) D WHERE A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND A.ACAD_PROG = B.ACAD_PROG AND A.ACAD_PLAN = B.ACAD_PLAN AND A.EFFDT = B.EFFDT AND B.INSTITUTION = C.INSTITUTION AND B.ACAD_CAREER = C.ACAD_CAREER AND B.ACAD_PROG = C.ACAD_PROG AND B.ACAD_PLAN = C.ACAD_PLAN AND B.EFFDT = C.EFFDT AND B.MILESTONE_NBR = C.MILESTONE_NBR AND B.INSTITUTION = D.INSTITUTION AND D.ENTRY_USE_IND = 'Y' AND (D.MILESTONE = 'ALL' OR (B.MILESTONE = D.MILESTONE AND NOT EXISTS ( SELECT 'X' FROM %Table(SCRTY_TBL_MLSTN) D1 WHERE D1.OPRID = D.OPRID AND D1.INSTITUTION = D.INSTITUTION AND D1.MILESTONE = 'ALL' AND D1.ENTRY_USE_IND = 'Y'))) |
# | 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 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
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 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
5 | ACAD_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Academic Plan |
6 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |
7 | MILESTONE_NBR | Number(4,0) | SMALLINT NOT NULL | Milestone Nbr |
8 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
10 | DESCRFORMAL | Character(50) | VARCHAR2(50) NOT NULL | Formal Description field |