| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SSR_TST_ID_NLD |
Character(8) |
VARCHAR2(8) NOT NULL |
Test ID
Default Value: 00000000
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
SSR_UNITS1_NLD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Units 1
|
| 6 |
SSR_UNITS2_NLD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Units 2
|
| 7 |
GRADING_BASIS |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Basis
ANC=ABC/NC Grading
AUD=Audit
BMT=Multi-Term Course: Not Graded
CNC=Credit / No Credit
EQV=Equivalent
GRD=Graded
HSC=Hundred Point Scale (NLD)
LAW=Law
MED=Medical School Grades
NOG=No Grade Associated
NON=Non-Graded Component
NQF=NQF Scale
OPT=Student Option
PNP=Pass/Not Pass
SUS=Satisfactory/Unsatisfactory
TRN=Transfer Grading Basis
TSC=Ten Point Scale (NLD)
Default Value: GRD
|
| 8 |
COURSE_TITLE_LONG |
Character(100) |
VARCHAR2(100) NOT NULL |
Long Course Title
Default Value: SSR_TST_CAT_NLD.DESCR
|
| 9 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTN_SCRTY
|
| 10 |
ACAD_ORG |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Organization
Prompt Table:
ACAD_ORG_SRCH
|
| 11 |
ACAD_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Group
Default Value: OPR_DEF_TBL_CS.ACAD_GROUP
Prompt Table:
ACAD_GROUP_TBL
|
| 12 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Default Value: OPR_DEF_TBL_CS.ACAD_CAREER
Prompt Table:
ACAD_CAR_SCRTY
|
| 13 |
CATALOG_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Catalog Nbr
|
| 14 |
COURSE_APPROVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Course Approved
A=Approved
D=Denied
P=Pending
Default Value: P
|
| 15 |
SUBJECT |
Character(8) |
VARCHAR2(8) NOT NULL |
Subject Area
Default Value: SUBJECT_TBL.SUBJECT
Prompt Table:
SUBJECT_TBL
|
| 16 |
HEGIS_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
HEGIS Code
Prompt Table:
HEGIS_CODE_TBL
|
| 17 |
SSR_TST_CAT_TP_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Type : Test or Calculated Result
C=Calculated Result
T=Test
Default Value: T
|
| 18 |
SSR_GRADE_VAL_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Grade Valid
A=Years After Term End
U=Unlimited
Default Value: U
|
| 19 |
SSR_GRD_VAL_YR_NLD |
Number(2,0) |
SMALLINT NOT NULL |
Number of years a grade is valid after term end
A=Years after Term end:
E=End of Year
T=Ten Year end period
U=Unlimited
|
| 20 |
SSR_TST_EXAMTP_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Test examination type
B=Combination Grade
C=Central End Exam
E=End Exam
Q=Qualification
S=School Exam
U=Partial Qualification
|
| 21 |
SSR_TST_LEVEL_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Level
A=A level
B=B level
C=C level
D=D level
|
| 22 |
SSR_CAL_PRES_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
SSR_CAL_PRES_NLD required field for rounding purposes
R=Round
T=Truncate
Default Value: R
|
| 23 |
SSR_DECIMALS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
number of decimals
0=No Decimals
1=1 Decimal
2=2 Decimals
Default Value: 2
|
| 24 |
SSR_EMPTY_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Handle Insufficient Grades
C=Conditional
E=Exclude from Calculation
I=Include in Calculation
N=Do Not Calculate
Default Value: N
|
| 25 |
SSR_MINTESTREQ_NLD |
Number(2,0) |
SMALLINT NOT NULL |
Minimum Tests Required
|
| 26 |
SSR_MINSUMREQ_NLD |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Minimal Sum Total Value
|
| 27 |
SSR_CALC_INSTR_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Only Grades within Term
Y/N Table Edit
Default Value: N
|
| 28 |
SSR_SUM_GRD_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sum Grades
Y/N Table Edit
Default Value: N
|
| 29 |
CRSE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Course ID
Prompt Table:
SSR_TST_CRS_VW
|
| 30 |
CRSE_OFFER_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Course Offering Nbr
Prompt Table:
SSR_TST_OFR_VW
|
| 31 |
SSR_CREATE_UPD_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Create/Update Student Enroll
C=Create
U=Update Existing Only
Default Value: U
|
| 32 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 33 |
SAD_BR_PAPER_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Paper
Y/N Table Edit
Default Value: N
|