INSTITUTIONSSR_ACT_ID_ROOTPrompt Table: SSR_ACT_ROOTVW2
C=Complete
L=Complete - Locked
P=Pending
Default Value: P
SSR_ACT_ROOTVW3(SQL View) |
Index Back |
|---|---|
Activity Root ViewActivity Root View. |
| SELECT R.INSTITUTION ,R.SSR_ACTIVITY_ID ,R.SSR_AC_CONTENT_ID ,R.SSR_AC_EFFDT ,R.CRS_TOPIC_ID ,R.SSR_ACT_STATUS ,H.DESCR50 FROM PS_SSR_ACT_ROOTEXT R , PS_SSR_AC_REG_HDR H WHERE R.SSR_AC_CONTENT_ID = H.SSR_AC_CONTENT_ID AND R.INSTITUTION = H.INSTITUTION AND R.SSR_AC_EFFDT = H.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_ACT_ID_ROOT |
Character(11) | VARCHAR2(11) NOT NULL |
Course Root Activity ID
Prompt Table: SSR_ACT_ROOTVW2 |
| 3 | SSR_AC_CONTENT_ID | Character(13) | VARCHAR2(13) NOT NULL | Activity Registry ID |
| 4 | SSR_AC_EFFDT | Date(10) | DATE | Effective Date |
| 5 | CRS_TOPIC_ID | Number(3,0) | SMALLINT NOT NULL | Course Topic ID |
| 6 | SSR_ACT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Activity Manager Status
C=Complete L=Complete - Locked P=Pending Default Value: P |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |