INSTITUTIONB=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
SSR_PROGTREE_VW(SQL View) |
Index Back |
|---|---|
Tree Definition name and effdtTree Definition name and effdt |
| SELECT DISTINCT A.INSTITUTION , A.ACAD_PROG , A.CAMPUS , A.ACAD_LOAD_APPR , A.STRM , A.TREE_NAME , A.TREE_EFFDT , B.DESCR FROM PS_SSR_PRGTRLN_NLD A , PSTREEDEFN B WHERE A.TREE_NAME = B.TREE_NAME AND A.TREE_EFFDT = B.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
| 3 | CAMPUS | Character(5) | VARCHAR2(5) NOT NULL | Campus |
| 4 | ACAD_LOAD_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Approved Academic Load
B=Vocational Coaching (NLD) D=Dual (NLD) E=Part-time Vocational Tr (NLD) F=Full-Time O=Vocational Training (NLD) P=Part-Time |
| 5 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 6 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 7 | TREE_EFFDT | Date(10) | DATE | Effective date of the Tree |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |