NAMEEMPLIDC=Completed
I=Action Required
X=Inactive
SSR_ACR_ALLXVW(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 FROM PS_SSR_IAM_ROOTEXT A LEFT OUTER JOIN PS_SSR_IAM_ANON_ID C ON A.EMPLID = C.EMPLID AND A.INSTITUTION = C.INSTITUTION AND A.SSR_ACTIVITY_ID = C.SSR_ACTIVITY_ID , PS_HCR_PERSON_NM_I B WHERE A.EMPLID = B.EMPLID |
| # | 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 |