| # |
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 |
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 |
SSR_RES_ROUND_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Decimal Rounding Option
R=Rounded
T=Truncated
Default Value: R
|
| 21 |
SSR_RES_ROUND_DEC |
Number(1,0) |
SMALLINT NOT NULL |
Decimal Places
Default Value: 0
|
| 22 |
SSR_RES_COURSE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Course Mark Option in Reult Scale Set-up
Y/N Table Edit
Default Value: N
|
| 23 |
SSR_MAND_PASS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandatory Pass Result Scale
Y/N Table Edit
Default Value: N
|
| 24 |
SSR_MAND_PASS_SCLE |
Character(12) |
VARCHAR2(12) NOT NULL |
Mandatory Pass Result Scale
Prompt Table:
SSR_RES_MAP_VW4
|
| 25 |
SSR_MANPSS_CLC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandatory Pass Calc Options
C=Use Course Result Scale
M=Use Mandatory Pass Rsult Scale
Default Value: C
|
| 26 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 27 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 28 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 29 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|