SETIDPrompt Table: SETID_TBL
SSR_RES_MAP_IDEFFDTDefault Value: %date
GRADING_SCHEME1Prompt Table: GRADESCHEME_TBL
GRADING_BASIS_LISTPrompt Table: SSR_BASIS_XL_VW
CRSE_GRADE_INPUTA=A
Prompt Table: GRADE_TBL
SSR_RES_MAP_VW2(SQL View) |
Index Back |
|---|---|
Result Mapping Detail RecordThis record contains detailed result mapping information for a specified result map for Activity Management (Activity Setup). |
| SELECT DISTINCT SETID ,SSR_RES_MAP_ID , EFFDT , GRADING_SCHEME , GRADING_BASIS , CRSE_GRADE_INPUT FROM PS_SSR_RES_MAP_DTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
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 | GRADING_SCHEME1 |
Character(3) | VARCHAR2(3) NOT NULL |
Grading Scheme
Prompt Table: GRADESCHEME_TBL |
| 5 | GRADING_BASIS_LIST |
Character(3) | VARCHAR2(3) NOT NULL |
Grading Basis
Prompt Table: SSR_BASIS_XL_VW |
| 6 | CRSE_GRADE_INPUT |
Character(3) | VARCHAR2(3) NOT NULL |
Grade Input
A=A Prompt Table: GRADE_TBL |