SSR_INS_RES_MAP(SQL View) |
Index Back |
|---|---|
Institution Result Scale |
| SELECT a.SETID , b.SSR_RSLT_TYPE , b.EFFDT , a.SSR_RES_MAP_ID , a.EFF_STATUS , a.DESCR50 , a.SSR_RES_MARK_OPT , a.SSR_RES_MARK_INTGR , a.SSR_RES_MARK_DECML , a.SSR_RES_MARK_MIN , a.SSR_RES_MARK_MAX , a.SSR_RES_MK_RNG_OPT , a.SSR_RES_SCORE_OPT , a.SSR_RES_SCORE_TYPE , a.SSR_RES_SCORE_INTG , a.SSR_RES_SCORE_DECM , a.SSR_RES_DESCR_OPT , a.SSR_RES_GRADE_OPT , a.SSR_RES_OUTCME_OPT , b.DEFAULT_FLAG FROM PS_SSR_RES_MAP_TBL a , PS_SSR_RSLT_INST b , PS_SSR_RSLT_TBL c WHERE a.SETID = b.INSTITUTION AND a.SSR_RES_MAP_ID = b.SSR_RES_MAP_ID AND a.EFFDT = c.EFFDT AND (a.SSR_RES_MARK_OPT = 'Y' OR a.SSR_RES_SCORE_OPT = 'Y') AND b.SSR_RSLT_TYPE = c.SSR_RSLT_TYPE AND b.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SSR_RSLT_INST d WHERE b.SSR_RSLT_TYPE = c.SSR_RSLT_TYPE AND B.EFFDT <=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID_CAREER Prompt Table: SETID_TBL |
| 2 | SSR_RSLT_TYPE |
Character(20) | VARCHAR2(20) NOT NULL | Result Type |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | SSR_RES_MAP_ID |
Character(12) | VARCHAR2(12) NOT NULL | Result Scale |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | SSR_RES_MARK_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Mark
Y/N Table Edit Default Value: Y |
| 8 | SSR_RES_MARK_INTGR | Number(1,0) | SMALLINT NOT NULL | Integer Positions |
| 9 | SSR_RES_MARK_DECML | Number(1,0) | SMALLINT NOT NULL | Decimal Positions |
| 10 | SSR_RES_MARK_MIN | Number(19,9) | DECIMAL(18,9) NOT NULL | Minimum Mark |
| 11 | SSR_RES_MARK_MAX | Number(19,9) | DECIMAL(18,9) NOT NULL | Maximum Mark |
| 12 | SSR_RES_MK_RNG_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Display Mark Range
Y/N Table Edit Default Value: N |
| 13 | SSR_RES_SCORE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Score
Y/N Table Edit Default Value: N |
| 14 | SSR_RES_SCORE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Score Value Field Type
C=Character N=Numeric Default Value: C |
| 15 | SSR_RES_SCORE_INTG | Number(1,0) | SMALLINT NOT NULL | Score Integer Positions |
| 16 | SSR_RES_SCORE_DECM | Number(1,0) | SMALLINT NOT NULL | Score Decimal Positions |
| 17 | SSR_RES_DESCR_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Description
Y/N Table Edit Default Value: N |
| 18 | SSR_RES_GRADE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Grade
Y/N Table Edit Default Value: Y |
| 19 | SSR_RES_OUTCME_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Outcome
Y/N Table Edit Default Value: Y |
| 20 | DEFAULT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Set As Default |