EMPLIDSSR_ACTIVITY_IDSSR_ANIDACT_SCH(SQL View) |
Index Back |
|---|---|
Activity ID Seacrh View |
| SELECT A.EMPLID , A.SSR_ACTIVITY_ID , D.DESCR50 FROM PS_SSR_IAM_ROOTEXT A , PS_SSR_ACTBGRD_VW B , PS_SSR_ACTIVITY C , PS_SSR_AC_CONT_ITM D WHERE A.SSR_ACTIVITY_ID = B.SSR_ACTIVITY_ID AND A.INSTITUTION = B.INSTITUTION AND B.SSR_ACTIVITY_ID = C.SSR_ACTIVITY_ID AND C.SSR_AC_CONTENT_ID = D.SSR_AC_CONTENT_ID AND D.SSR_AC_CONTENT_TP = '1000' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SSR_ACTIVITY_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |