REPORT_REQUEST_NBRREQUEST_SEQ_NBRREPORT_NUMBERCOPY_NUMBERDefault Value: 1
SA_RPT_RSLT_HDR(SQL Table) |
Index Back |
|---|
| # | 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 | 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 |
| 5 | TSCRPT_TITLE | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 6 | TSCRPT_INS_ADDR1 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 7 | TSCRPT_INS_ADDR2 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 8 | TSCRPT_INS_ADDR3 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 9 | TSCRPT_INS_ADDR4 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 10 | TSCRPT_INS_ADDR5 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 11 | TSCRPT_INS_ADDR6 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 12 | TSCRPT_INS_ADDR7 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 13 | TSCRPT_EM_ADDR1 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 14 | TSCRPT_EM_ADDR2 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 15 | TSCRPT_EM_ADDR3 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 16 | TSCRPT_EM_ADDR4 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 17 | TSCRPT_EM_ADDR5 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 18 | TSCRPT_EM_ADDR6 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 19 | TSCRPT_EM_ADDR7 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 20 | TSCRPT_EM_ADDR8 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 21 | TSCRPT_EM_ADDR9 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 22 | TSCRPT_EM_ADDR10 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |
| 23 | TSCRPT_EM_ADDR11 | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |