SSR_IAM_RTEXTVW(SQL View) |
Index Back |
|---|---|
IAM Root Ext ViewIAM Root Extension View |
| SELECT EMPLID , INSTITUTION , SSR_ACTIVITY_ID , SSR_ACT_ID_SEQ_NBR , SSR_ACT_ID_ROOT_ST , SSR_IAM_LOCK , SSR_CREATE_RSLTROW , SSR_IAM_ANONYMS_ID FROM PS_SSR_IAM_ROOTEXT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | SSR_ACT_ID_ROOT |
Character(11) | VARCHAR2(11) NOT NULL | Course Root Activity ID |
| 4 | SSR_ACT_ID_SEQ_NBR | Number(4,0) | SMALLINT NOT NULL |
Activity ID Sequence Number
Default Value: 1 |
| 5 | SSR_ACT_ID_ROOT_ST | Character(1) | VARCHAR2(1) NOT NULL |
Course Root Status
C=Completed I=Action Required X=Inactive Default Value: I |
| 6 | SSR_IAM_LOCK | Character(1) | VARCHAR2(1) NOT NULL |
Locked
Y/N Table Edit Default Value: N |
| 7 | SSR_CREATE_RSLTROW | Character(1) | VARCHAR2(1) NOT NULL |
Create Initial Result Row
N=Do Not Create Initial Result X=Do not use this option Y=Create Initial Result Y/N Table Edit Default Value: Y |
| 8 | SSR_IAM_ANONYMS_ID | Number(7,0) | INTEGER NOT NULL | Anonymous ID |