NAMEEMPLIDC=Completed
I=Action Required
X=Inactive
SSR_ACR_NAMEVW(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 , B.NAME_DISPLAY %Concat ' - ' %Concat A.EMPLID FROM PS_SSR_IAM_ROOTEXT A , 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_NAME_AND_ID | Character(80) | VARCHAR2(80) NOT NULL | Name and ID |