NAMEEMPLIDC=Completed
I=Action Required
X=Inactive
SSR_ACR_ALLVW(SQL View) |
Index Back |
|---|---|
Dyn View for Roster Name SrchDynamic View for Roster Name Search |
| SELECT A.NAME , A.NAME_DISPLAY , A.EMPLID , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_ROOT_ST , A.SSR_ANONYMOUS_ID , CASE WHEN A.SSR_ANONYMOUS_ID IS NOT NULL THEN A.NAME_DISPLAY %Concat ' - ' %Concat A.EMPLID %Concat ' - ' %Concat %NumToChar(A.SSR_ANONYMOUS_ID) ELSE A.NAME_DISPLAY %Concat ' - ' %Concat A.EMPLID END FROM PS_SSR_ACR_ALLXVW A |
| # | 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 |