SSR_ACTIVITY_IDINSTITUTIONC=Complete
L=Complete - Locked
P=Pending
Default Value: P
Y/N Table Edit
Default Value: N
SSR_ACT_ROOTEXT(SQL Table) |
Index Back |
|---|---|
Activity Root ExtensionActivity Root Extension Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_ACTIVITY_ID |
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: P |
| 7 | SSR_AM_LOCK | Character(1) | VARCHAR2(1) NOT NULL |
Locked
Y/N Table Edit Default Value: N |