INSTITUTIONSSR_RSLT_TYPEEFFDTA=Active
I=Inactive
SSR_APTSYN_RSVW(SQL View) |
Index Back |
|---|
| SELECT B.INSTITUTION , A.SSR_RSLT_TYPE , A.EFFDT , A.EFF_STATUS , B.SSR_RES_MAP_ID FROM PS_SSR_RSLT_TBL A , PS_SSR_RSLT_INST B WHERE A.SSR_RSLT_TYPE = B.SSR_RSLT_TYPE AND A.EFFDT = B.EFFDT AND ((A.SSR_VAL_FIELDTYPE = '80' AND B.DEFAULT_FLAG = 'Y') OR A.SSR_VAL_FIELDTYPE <> '80') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_RSLT_TYPE |
Character(20) | VARCHAR2(20) NOT NULL | Result Type |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | SSR_RES_MAP_ID | Character(12) | VARCHAR2(12) NOT NULL | Result Scale |