EMPLIDENRL_VER_SEQENRL_VER_DET_SEQCOPY_NUMBERENRL_VER_PRT_HD(SQL Table) |
Index Back |
|---|---|
Enrl Ver Print HeaderHeader Record for the Enrollment Verification output. Keeps header data (addresses etc.) and copy #. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ENRL_VER_SEQ |
Number(3,0) | SMALLINT NOT NULL | Enrollment verification request number. |
| 3 | ENRL_VER_DET_SEQ |
Number(3,0) | SMALLINT NOT NULL | Detail Seq #. |
| 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. |
| 5 | ENRL_VER_INS_ADDR1 | Character(80) | VARCHAR2(80) NOT NULL | Institution address. |
| 6 | ENRL_VER_INS_ADDR2 | Character(80) | VARCHAR2(80) NOT NULL | Institution address. |
| 7 | ENRL_VER_INS_ADDR3 | Character(80) | VARCHAR2(80) NOT NULL | Institution address. |
| 8 | ENRL_VER_INS_ADDR4 | Character(80) | VARCHAR2(80) NOT NULL | Institution address. |
| 9 | ENRL_VER_INS_ADDR5 | Character(80) | VARCHAR2(80) NOT NULL | Institution address. |
| 10 | ENRL_VER_INS_ADDR6 | Character(80) | VARCHAR2(80) NOT NULL | Institution address. |
| 11 | ENRL_VER_INS_ADDR7 | Character(80) | VARCHAR2(80) NOT NULL | Institution address. |
| 12 | ENRL_VER_SND_ADDR1 | Character(80) | VARCHAR2(80) NOT NULL | "Send to" address. |
| 13 | ENRL_VER_SND_ADDR2 | Character(80) | VARCHAR2(80) NOT NULL | "Send to" address. |
| 14 | ENRL_VER_SND_ADDR3 | Character(80) | VARCHAR2(80) NOT NULL | "Send to" address. |
| 15 | ENRL_VER_SND_ADDR4 | Character(80) | VARCHAR2(80) NOT NULL | "Send to" address. |
| 16 | ENRL_VER_SND_ADDR5 | Character(80) | VARCHAR2(80) NOT NULL | "Send to" address. |
| 17 | ENRL_VER_SND_ADDR6 | Character(80) | VARCHAR2(80) NOT NULL | "Send to" address. |
| 18 | ENRL_VER_SND_ADDR7 | Character(80) | VARCHAR2(80) NOT NULL | "Send to" address. |
| 19 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 20 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 21 | REQUEST_PROCESS_DT | Date(10) | DATE | Request process date. |
| 22 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 23 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 24 | ENRL_VER_ERROR_FL | Character(1) | VARCHAR2(1) NOT NULL | Flag for print header record, to mark for Enrollment Verification error report. |
| 25 | SSR_DATE_STRING | Character(10) | VARCHAR2(10) NOT NULL | Date String |