SSR_TSRSLT_HDR(SQL Table) |
Index Back |
---|---|
Transcript RecordTranscript 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 |