ENRL_VER_REQST

(SQL Table)
Index Back

Enrollmnt Verification Request

Enrollment Verification Request header record.

  • Parent record: PERSON
  • # 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