TSCRPT_TEXT

(SQL Table)
 Index Back

Student Transcript Text

This table contains supplemental information that need to be added to the transcript. It could be used to store data that could not be kept in any of the other system tables.

  • Parent record: TSCRPT_TEXT_LOC

    • # 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 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

    Default Value: STDNT_CAREER.ACAD_CAREER

    Prompt Table: STDNT_CAREER

    3 PRINT_LOC_SEQ Number(3,0) SMALLINT NOT NULL Print Location Seq Nbr
    4 TEXT_SEQ_NBR Number(2,0) SMALLINT NOT NULL Text Seq Nbr
    5 TRANSCRIPT_LEVEL Character(2) VARCHAR2(2) NOT NULL Transcript level
    00=Never Print
    20=Print on Official
    40=Print on Unofficial
    60=Print on Student Life
    80=Print on Degree Progress
    6 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type

    Prompt Table: SCRTY_TSCRPT_VW

    7 TSCRPT_TYPE2 Character(5) VARCHAR2(5) NOT NULL Report Type

    Prompt Table: SSR_SCRTY_TS_VW

    8 TRANSCRIPT_TEXT Character(90) VARCHAR2(90) NOT NULL Transcript Text
    9 SSR_TRANSCRIPT_TXT Long Character(1000) VARCHAR2(1000) Transcript Text