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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
2 | ENRL_VER_SEQ | 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 |