EMPLIDINSTITUTIONSSR_ACT_ID_ROOTSSR_ACTIVITY_IDSSR_ACT_ID_SEQ_NBRDefault Value: 1
SSR_AC_RST_TPACAD=Academic Year
CAR=Career
PROG=Academic Program
SSR_IAMRTRLMTVW(SQL View) |
Index Back |
|---|---|
IAM Resit Limit View by RootIAM Resit Limit View by Root. |
| SELECT A.EMPLID , A.INSTITUTION , A.SSR_ACT_ID_ROOT , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , B.SSR_AC_RST_TP , B.SSR_RESIT_LIMIT FROM PS_SSR_IAM A , PS_SSR_ACMRLMT_INC B WHERE A.INSTITUTION = B.INSTITUTION AND A.SSR_ACTIVITY_ID = B.SSR_ACTIVITY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | SSR_ACT_ID_ROOT |
Character(11) | VARCHAR2(11) NOT NULL | Course Root Activity ID |
| 4 | SSR_ACTIVITY_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 5 | SSR_ACT_ID_SEQ_NBR |
Number(4,0) | SMALLINT NOT NULL |
Activity ID Sequence Number
Default Value: 1 |
| 6 | SSR_AC_RST_TP |
Character(4) | VARCHAR2(4) NOT NULL |
Attempt Time Period
ACAD=Academic Year CAR=Career PROG=Academic Program |
| 7 | SSR_RESIT_LIMIT | Number(3,0) | SMALLINT NOT NULL | This field indicates if resits are allowed. |