SSR_TSRSLT_HDR

(SQL Table)
Index Back

Transcript Record

Transcript result header record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_REQUEST_NBR Character(9) VARCHAR2(9) NOT NULL Report Request Nbr
2 REQUEST_SEQ_NBR Number(5,0) INTEGER NOT NULL Request Seq Nbr
3 REPORT_NUMBER Number(2,0) SMALLINT NOT NULL Report Number
4 NUMBER_OF_COPIES Number(2,0) SMALLINT NOT NULL Number of Copies
5 COPY_NUMBER Number(3,0) SMALLINT NOT NULL This field is part of a header record key when printing multiple copies of one form, i.e. enrollment verifications or transcripts. Separate header records are created for each requested report and copy, and when joined with the detail records the right number of copies is produced.

Default Value: 1

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
9 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
10 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
11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
12 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field
13 REQUEST_PRT_DT Date(10) DATE Requested Print Date
14 DETAIL_ORG Character(1) VARCHAR2(1) NOT NULL Detail Organization
C=Order by Career
T=Chronological across Careers
15 FERPA Character(1) VARCHAR2(1) NOT NULL FERPA
16 SSR_TSRPT_FERPA Character(50) VARCHAR2(50) NOT NULL FERPA information on transcript report
17 SSR_DATE_MASK Character(10) VARCHAR2(10) NOT NULL Date Mask