SSR_RES_MAP_VW1(SQL View) |
Index Back |
|---|---|
Activity Management ResultsThis record contains result mapping information for Activity Management (Activity Setup). |
| SELECT a.SETID , a.SSR_RES_MAP_ID , a.EFFDT , 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 FROM PS_SSR_RES_MAP_TBL a WHERE a.SSR_RES_MARK_OPT = 'Y' OR a.SSR_RES_SCORE_OPT = 'Y' |
| # | 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_RES_MAP_ID |
Character(12) | VARCHAR2(12) NOT NULL | Result Scale |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 6 | SSR_RES_MARK_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Mark
Y/N Table Edit Default Value: Y |
| 7 | SSR_RES_MARK_INTGR | Number(1,0) | SMALLINT NOT NULL | Integer Positions |
| 8 | SSR_RES_MARK_DECML | Number(1,0) | SMALLINT NOT NULL | Decimal Positions |
| 9 | SSR_RES_MARK_MIN | Number(19,9) | DECIMAL(18,9) NOT NULL | Minimum Mark |
| 10 | SSR_RES_MARK_MAX | Number(19,9) | DECIMAL(18,9) NOT NULL | Maximum Mark |
| 11 | SSR_RES_MK_RNG_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Display Mark Range
Y/N Table Edit Default Value: N |
| 12 | SSR_RES_SCORE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Score
Y/N Table Edit Default Value: N |
| 13 | SSR_RES_SCORE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Score Value Field Type
C=Character N=Numeric Default Value: C |
| 14 | SSR_RES_SCORE_INTG | Number(1,0) | SMALLINT NOT NULL | Score Integer Positions |
| 15 | SSR_RES_SCORE_DECM | Number(1,0) | SMALLINT NOT NULL | Score Decimal Positions |
| 16 | SSR_RES_DESCR_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Description
Y/N Table Edit Default Value: N |
| 17 | SSR_RES_GRADE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Grade
Y/N Table Edit Default Value: Y |
| 18 | SSR_RES_OUTCME_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Outcome
Y/N Table Edit Default Value: Y |