PROCESS_INSTANCEINSTITUTIONSSR_ACTIVITY_IDSSR_IAMSCAL_AVW(SQL View) |
Index Back |
|---|---|
IAM Calc by student data |
| SELECT DISTINCT PROCESS_INSTANCE , INSTITUTION , SSR_ACTIVITY_ID FROM PS_SSR_IAMSCAL_PRC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | SSR_ACTIVITY_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |