SSR_EV_RQ_VW

(SQL View)
Index Back

Enrollmnt Verification Request


SELECT A.EMPLID , A.ENRL_VER_SEQ , A.REQUEST_DT , A.OPRID , A.INSTITUTION , A.REQUEST_PROCESS_DT , A.REQUEST_COMPLETED , A.DATE_TO_BE_PRINTED , A.FROM_TERM , A.TO_TERM , A.EARNED_DEGREES , A.CUM_AND_TERM_GPA , A.CURRENT_PROGRAM , B.SSR_EV_SEL_OPT FROM PS_ENRL_VER_REQST A, PS_SSR_EV_OPT_FL B WHERE A.EMPLID = B.EMPLID AND A.ENRL_VER_SEQ = B.ENRL_VER_SEQ

  • 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

    14 SSR_EV_SEL_OPT Character(1) VARCHAR2(1) NOT NULL Select Option
    N=Request Institution to Mail
    Y=Allow to Print from My Browser

    Default Value: Y