TCRPT_REQ_SECVW

(SQL View)
 Index Back

Transcript Request View

Combines transcript request record and transcript type security.

SELECT B.OPRID , A.EMPLID , A.TRANSCRIPT_SEQ_NO , A.REQUEST_DT , A.INSTITUTION , A.TS130_CONTROL , A.TSCRPT_TYPE , A.FUTURE_RELEASE , A.ACAD_CAREER , A.STRM , A.DATE_TO_BE_PRINTED , A.REQUEST_REASON_CD , A.REQUEST_REASON_TXT , A.OUT_DEST , A.OVRD_SRVC_INDIC , A.REQUEST_PROCESS_DT , A.REQUEST_COMPLETED , A.OPRID , A.MAIL_TO_REQUESTOR , A.USE_EXT_ORG , A.EXT_ORG_ID , A.ORG_LOCATION , A.MAIL_TO_NAME , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.NUM1 , A.NUM2 , A.HOUSE_TYPE , A.ADDR_FIELD1 , A.ADDR_FIELD2 , A.ADDR_FIELD3 , A.COUNTY , A.STATE , A.POSTAL , A.GEO_CODE , A.IN_CITY_LIMIT , A.EDI_SEND_OPTIONS , A.TS130_EMAIL_ADDR , A.FILE_NAME , A.FILE_PATH , A.DESCRLONG FROM PS_TRANSCRIPT_REQ A , PS_SCRTY_TSCRPT B WHERE B.INSTITUTION = A.INSTITUTION AND (B.TSCRPT_TYPE = A.TSCRPT_TYPE OR B.TSCRPT_TYPE= 'ALL') AND B.ACCESS_CD = 'Y'

  • Related Language Record: TCRPTREQSECVWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID2 Character(30) VARCHAR2(30) NOT NULL User ID
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    3 TRANSCRIPT_SEQ_NO Number(3,0) SMALLINT NOT NULL Transcript Seq No
    4 REQUEST_DT Date(10) DATE NOT NULL Request Date

    Default Value: %date

    5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    6 TS130_CONTROL Number(9,0) DECIMAL(9) NOT NULL TS130 processing - counter used to produce unique file names.
    7 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type

    Default Value: OPR_DEF_TBL_CS.TSCRPT_TYPE

    Prompt Table: %EDITTABLE

    8 FUTURE_RELEASE Character(2) VARCHAR2(2) NOT NULL Future Release
    DG=Degree Confer Date
    GP=Grades Post
    HD=Specific Date
    HO=Hold
    IP=Immediate Processing
    TP=Transfer Credit Post
    9 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: STDNT_CAR_I_VW4

    10 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: ACAD_CALTRM_VW4

    11 DATE_TO_BE_PRINTED Date(10) DATE Future print date.

    Default Value: %date

    12 REQUEST_REASON_CD Character(3) VARCHAR2(3) NOT NULL Request Reason
    DCH=Data Change
    EOT=End of Term Print
    ERQ=External Request
    GRD=Graduation
    SRQ=Student's Request
    WEB=Web Transcript Request
    13 REQUEST_REASON_TXT Character(50) VARCHAR2(50) NOT NULL Request Reason
    14 OUT_DEST Character(1) VARCHAR2(1) NOT NULL Output Destination
    1=Printer
    2=Page
    3=Electronic Transfer

    Default Value: 2

    15 OVRD_SRVC_INDIC Character(1) VARCHAR2(1) NOT NULL Override Service Indicator

    Y/N Table Edit

    Default Value: N

    16 REQUEST_PROCESS_DT Date(10) DATE Request process date.
    17 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

    18 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    19 MAIL_TO_REQUESTOR Character(1) VARCHAR2(1) NOT NULL Flag to default requestor address into address fields.

    Y/N Table Edit

    Default Value: N

    20 USE_EXT_ORG Character(1) VARCHAR2(1) NOT NULL Specify External Org ID

    Y/N Table Edit

    Default Value: N

    21 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    22 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr

    Prompt Table: ORG_LOC_ADDR_VW

    23 MAIL_TO_NAME Character(30) VARCHAR2(30) NOT NULL "Send to" name.
    24 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    25 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    26 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    27 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    28 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    29 CITY Character(30) VARCHAR2(30) NOT NULL City
    30 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    31 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    32 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    33 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    34 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    35 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    36 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    37 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    38 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    39 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    40 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    41 EDI_SEND_OPTIONS Character(1) VARCHAR2(1) NOT NULL Sending Options for EDI Transcripts.
    D=Place File in Directory
    E=Email

    Default Value: D

    42 TS130_EMAIL_ADDR Character(254) VARCHAR2(254) NOT NULL TS130 E-Mail address.
    43 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
    44 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path

    Default Value: TS130_CONTROL.FILE_PATH

    45 DESCRLONG Long Character CLOB Long Description