EMPLIDPrompt Table: SSR_ANID_EMP_VW
SSR_IAMCREATEVW(SQL View) |
Index Back |
|---|---|
ActivityID Created View |
| SELECT A.SCC_ROW_ADD_DTTM , A.EMPLID , A.SSR_ACTIVITY_ID , B.CRSE_ID FROM PS_SSR_IAM A , PS_SSR_ACT_XREF B WHERE A.SSR_ACTIVITY_ID = B.SSR_ACTIVITY_ID AND 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
Prompt Table: SSR_ANID_EMP_VW |
| 2 | SSR_ACTIVITY_ID | Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 3 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 4 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |