SSR_ACTY_ID_SRCHINSTITUTIONC=Complete
L=Complete - Locked
P=Pending
Default Value: C
Y/N Table Edit
Default Value: N
SSR_ACT_ROOT_VW(SQL View) |
Index Back |
|---|---|
Activity Root ViewActivity Root View. |
| SELECT R.SSR_ACTIVITY_ID ,R.INSTITUTION ,R.SSR_AC_CONTENT_ID ,R.SSR_AC_EFFDT ,R.CRS_TOPIC_ID ,R.SSR_ACT_STATUS ,R.SSR_AM_LOCK FROM PS_SSR_ACT_ROOTEXT R |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_ACTY_ID_SRCH |
Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 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: C |
| 7 | SSR_AM_LOCK | Character(1) | VARCHAR2(1) NOT NULL |
Locked
Y/N Table Edit Default Value: N |