SSR_RES_MAPVW(SQL View) |
Index Back |
|---|---|
Activity Management ResultsThis record contains result mapping information for Activity Management (Activity Setup). |
| SELECT SETID , SSR_RES_MAP_ID , EFFDT , END_EFFDT , EFF_STATUS , SSR_RES_MARK_OPT , SSR_RES_MARK_INTGR , SSR_RES_MARK_DECML , SSR_RES_MARK_MIN , SSR_RES_MARK_MAX , SSR_RES_MK_RNG_OPT , SSR_RES_SCORE_OPT , SSR_RES_SCORE_TYPE , SSR_RES_SCORE_INTG , SSR_RES_SCORE_DECM , SSR_RES_DESCR_OPT , SSR_RES_GRADE_OPT , SSR_RES_OUTCME_OPT FROM PS_SSR_RES_MAP_TBL |
| # | 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 | END_EFFDT | Date(10) | DATE | End Effdt |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 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 |