SSR_APP_REP_NLD

(SQL Table)
Index Back

Evaluation Report

Evaluation Report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_TST_ID_NLD Character(8) VARCHAR2(8) NOT NULL Test ID
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 STRM Character(4) VARCHAR2(4) NOT NULL Term
4 SSR_TST_DATE_NLD Date(10) DATE Test Date
5 SSR_SECTION_NLD Character(5) VARCHAR2(5) NOT NULL Test Section
6 SSR_EXA_SES_NLD Character(3) VARCHAR2(3) NOT NULL Examinationtype Session
CE1=Central Examination 1
CE2=Central Examination 2
EN1=End Examination 1
EN2=End Examination 2
SCE=School Examination
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
9 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

Prompt Table: ACAD_CAR_SCRTY

10 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
11 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
12 EFFDT_TO Date(10) DATE Effective Date To
13 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
14 SSR_REQ_ID_NLD Character(8) VARCHAR2(8) NOT NULL Requisite ID
15 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
16 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number
17 SSR_APP_RESULT_NLD Character(1) VARCHAR2(1) NOT NULL Approval Result
0=Not Passed
1=Passed
18 SSR_RESULT_DT_NLD Date(10) DATE Result Date
19 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
20 TREE_EFFDT Date(10) DATE Effective date of the Tree
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 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
23 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
24 SSR_TST_CAT_TP_NLD Character(1) VARCHAR2(1) NOT NULL Test Type : Test or Calculated Result
C=Calculated Result
T=Test
25 SSR_EXAMSUBST_NLD Character(1) VARCHAR2(1) NOT NULL Replace Exam Result
26 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
27 SSR_TEXT1_NLD Character(100) VARCHAR2(100) NOT NULL Comments
28 SSR_TEXT2_NLD Character(150) VARCHAR2(150) NOT NULL Additional Comments
29 SSR_GRD_NO_CAL_NLD Character(1) VARCHAR2(1) NOT NULL No Calculation
N=Not Relevant
Q=No Qualification On Diploma
R=Reference to Term
W=Withdrawn
30 SSR_GRD_ATTR_NLD Character(1) VARCHAR2(1) NOT NULL Grade Attribute
B=Exempt Combination Grade
D=Different Qualification
E=Exemption
X=Exemption Excluded Calc
31 CORRECTION_REQD Character(1) VARCHAR2(1) NOT NULL Correction Required
32 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A
33 SELECT_CHK Character(1) VARCHAR2(1) NOT NULL Select