ENRL_VER_REQST(SQL Table) |
Index Back |
|---|---|
Enrollmnt Verification RequestEnrollment Verification Request header record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
|
| 2 | Number(3,0) | SMALLINT NOT NULL | Enrollment verification request number. | |
| 3 | REQUEST_DT | Date(10) | DATE NOT NULL |
Request Date
Default Value: %date |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: STDNT_CAR_I_VW3 |
| 6 | REQUEST_PROCESS_DT | Date(10) | DATE | Request process date. |
| 7 | REQUEST_COMPLETED | Character(1) | VARCHAR2(1) NOT NULL |
Request Complete Status.
A=Acknowledgement Received C=Completed G=Generated N=On Request P=Printed R=Reissue Requested Default Value: N |
| 8 | DATE_TO_BE_PRINTED | Date(10) | DATE |
Future print date.
Default Value: %date |
| 9 | FROM_TERM | Character(4) | VARCHAR2(4) NOT NULL |
From Term
Prompt Table: SS_EN_TERM_SRC2 |
| 10 | TO_TERM | Character(4) | VARCHAR2(4) NOT NULL |
To Term
Prompt Table: SS_EN_TERM_SRC2 |
| 11 | EARNED_DEGREES | Character(1) | VARCHAR2(1) NOT NULL |
Flag for enrollment verification request.
Y/N Table Edit Default Value: Y |
| 12 | CUM_AND_TERM_GPA | Character(1) | VARCHAR2(1) NOT NULL |
Flag for enrollment verification request.
Y/N Table Edit Default Value: N |
| 13 | CURRENT_PROGRAM | Character(1) | VARCHAR2(1) NOT NULL |
Flag for enrollment verification request.
Y/N Table Edit Default Value: Y |