NAMEEMPLIDC=Completed
I=Action Required
X=Inactive
SSR_ACR_ANONVW(SQL View) |
Index Back |
|---|---|
Dyn View for Roster Name SrchDynamic View for Roster Name Search |
| SELECT B.NAME , B.NAME_DISPLAY , A.EMPLID , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_ROOT_ST , C.SSR_ANONYMOUS_ID , C.SSR_ANONYMOUS_ID FROM PS_SSR_IAM_ROOTEXT A , PS_HCR_PERSON_NM_I B , PS_SSR_IAM_ANON_ID C WHERE A.EMPLID = B.EMPLID AND C.INSTITUTION = A.INSTITUTION AND C.EMPLID = A.EMPLID AND C.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NAME |
Character(50) | VARCHAR2(50) NOT NULL | Name |
| 2 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | SSR_ACTIVITY_ID | Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 5 | SSR_ACT_ID_ROOT_ST | Character(1) | VARCHAR2(1) NOT NULL |
Course Root Status
C=Completed I=Action Required X=Inactive |
| 6 | SSR_ANONYMOUS_ID | Number(10,0) | DECIMAL(10) NOT NULL | Anonymous ID |
| 7 | SSR_NAME_AND_ID | Character(80) | VARCHAR2(80) NOT NULL | Name and ID |