TRANSCRIPT_TYPE

(SQL Table)
 Index Back

Transcript Type Table

The Transcript Type table contains the attributes of a transcript type. It defines the elements that will be included in the transcript, and the order in which they will be printed.

  • Related Language Record: TRANSCRIPT_LANG

  • Parent Record Of SCC_TRNSCARS_VW SSR_TSCAR_SRCH SSR_TSTYPE_SORT SSR_TS_SORT_VW1 SSR_TS_SORT_VW2 SSR_TS_SORT_VW3 SSR_TS_SORT_VW4 TRANSCRIPTCARLN TRANSCRIPT_CARS TSCRPTCARSRCHLN TSCRPT_CAR_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field
    6 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

    Default Value: 20

    7 DETAIL_ORG Character(1) VARCHAR2(1) NOT NULL Detail Organization
    C=Order by Career
    T=Chronological across Careers

    Default Value: C

    8 CHK_SRVC_IND Character(1) VARCHAR2(1) NOT NULL Check Service Indicators

    Y/N Table Edit

    Default Value: N

    9 SRVC_IMPACT_1 Character(5) VARCHAR2(5) NOT NULL Service Impacts

    Prompt Table: SRVC_IMPACT_VW

    10 SRVC_IMPACT_2 Character(5) VARCHAR2(5) NOT NULL Service Impact to Check

    Prompt Table: SRVC_IMPACT_VW

    11 SRVC_IMPACT_3 Character(5) VARCHAR2(5) NOT NULL Service Impact to Check

    Prompt Table: SRVC_IMPACT_VW

    12 INCL_DEGR_PRGRSS Character(1) VARCHAR2(1) NOT NULL Include Degree Progress

    Y/N Table Edit

    Default Value: N

    13 INC_SPEC_ADVIS_RPT Character(1) VARCHAR2(1) NOT NULL Include Spec Advis Report

    Y/N Table Edit

    Default Value: N

    14 EXCL_IP_COURSES Character(1) VARCHAR2(1) NOT NULL This field is used to identify if in-progress courses are available to be used in a specific advising report.

    Y/N Table Edit

    Default Value: N

    15 INSTITUTION_PA Character(2) VARCHAR2(2) NOT NULL Institution Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW1

    16 INSTITUTION_PN Number(3,0) SMALLINT NOT NULL Institution Print Area Seq
    17 INST_ADDR Character(1) VARCHAR2(1) NOT NULL Print Institution Address

    Y/N Table Edit

    Default Value: N

    18 INST_ID_FL Character(1) VARCHAR2(1) NOT NULL Print Institution ID

    Y/N Table Edit

    Default Value: N

    19 INST_ID Character(6) VARCHAR2(6) NOT NULL Institution ID
    20 STDNT_ID_PA Character(2) VARCHAR2(2) NOT NULL Student Information Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW1

    21 STDNT_ID_PN Number(3,0) SMALLINT NOT NULL Student Info Print Area Seq
    22 STDNT_SSN Character(1) VARCHAR2(1) NOT NULL Print Student SSN

    Y/N Table Edit

    Default Value: N

    23 STDNT_BDAY Character(1) VARCHAR2(1) NOT NULL Print Student Birthday

    Y/N Table Edit

    Default Value: N

    24 STDNT_SEX Character(1) VARCHAR2(1) NOT NULL Print Student Sex

    Y/N Table Edit

    Default Value: N

    25 STDNT_ADDR Character(1) VARCHAR2(1) NOT NULL Print Student Address

    Y/N Table Edit

    Default Value: N

    26 ADM_PA Character(2) VARCHAR2(2) NOT NULL Admit Term Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW2

    27 ADM_PN Number(3,0) SMALLINT NOT NULL Admit Term Print Area Seq
    28 ATT_PA Character(2) VARCHAR2(2) NOT NULL Attendance Dates Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW2

    29 ATT_PN Number(3,0) SMALLINT NOT NULL Attendance Dates Print Seq
    30 LOCAL_DEGR_PA Character(2) VARCHAR2(2) NOT NULL Local Degrees Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW3

    31 LOCAL_DEGR_PN Number(3,0) SMALLINT NOT NULL Local Degrees Print Area Seq
    32 LOCAL_DEGR_GPA Character(1) VARCHAR2(1) NOT NULL Print Degree GPA

    Y/N Table Edit

    Default Value: N

    33 LOCAL_DEGR_RANK Character(1) VARCHAR2(1) NOT NULL Print Degree Rank

    Y/N Table Edit

    Default Value: N

    34 LOCAL_DEGR_HONORS Character(1) VARCHAR2(1) NOT NULL Print Degree Honors

    Y/N Table Edit

    Default Value: N

    35 LOCAL_DEGR_PL_GPA Character(1) VARCHAR2(1) NOT NULL Print Degree Plan GPA

    Y/N Table Edit

    Default Value: N

    36 LOCAL_DEGR_PL_RANK Character(1) VARCHAR2(1) NOT NULL Print Degree Plan Rank

    Y/N Table Edit

    Default Value: N

    37 LOCAL_DEGR_SUBPLAN Character(1) VARCHAR2(1) NOT NULL Print Degree Sub-Plan

    Y/N Table Edit

    Default Value: N

    38 PROG_PA Character(2) VARCHAR2(2) NOT NULL Academic Program Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW4

    39 PROG_PN Number(3,0) SMALLINT NOT NULL Academic Program Print Seq
    40 PROG_ST_APPLICANT Character(1) VARCHAR2(1) NOT NULL Prog Status - Applicant

    Y/N Table Edit

    Default Value: N

    41 PROG_ST_WAITLISTED Character(1) VARCHAR2(1) NOT NULL Prog Status - Waitlisted

    Y/N Table Edit

    Default Value: N

    42 PROG_ST_ADMITTED Character(1) VARCHAR2(1) NOT NULL Prog Status - Admitted

    Y/N Table Edit

    Default Value: N

    43 PROG_ST_PREMATRIC Character(1) VARCHAR2(1) NOT NULL Prog Status - Prematric

    Y/N Table Edit

    Default Value: N

    44 PROG_ST_ACTIVE Character(1) VARCHAR2(1) NOT NULL Prog Status - Active

    Y/N Table Edit

    Default Value: Y

    45 PROG_ST_CANCELLED Character(1) VARCHAR2(1) NOT NULL Prog Status - Cancelled

    Y/N Table Edit

    Default Value: N

    46 PROG_ST_DISCONTD Character(1) VARCHAR2(1) NOT NULL Prog Status - Discontinued

    Y/N Table Edit

    Default Value: N

    47 PROG_ST_COMPLETED Character(1) VARCHAR2(1) NOT NULL Prog Status - Completed

    Y/N Table Edit

    Default Value: N

    48 PROG_ST_LOA Character(1) VARCHAR2(1) NOT NULL Prog Status - LOA

    Y/N Table Edit

    Default Value: N

    49 PROG_ST_SUSPENDED Character(1) VARCHAR2(1) NOT NULL Prog Status - Suspended

    Y/N Table Edit

    Default Value: N

    50 PROG_ST_DISMISSED Character(1) VARCHAR2(1) NOT NULL Prog Status - Dismissed

    Y/N Table Edit

    Default Value: N

    51 PROG_ST_DECEASED Character(1) VARCHAR2(1) NOT NULL Prog Status - Deceased

    Y/N Table Edit

    Default Value: N

    52 PROG_PRT Character(1) VARCHAR2(1) NOT NULL What to Print
    A=Active Program for Term
    P=All Plan Changes
    S=Changes in Program Status

    Default Value: S

    53 PROG_PLAN Character(1) VARCHAR2(1) NOT NULL Print Plans with Program

    Y/N Table Edit

    Default Value: N

    54 ENRL_PA Character(2) VARCHAR2(2) NOT NULL Enrollment Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW7

    55 ENRL_PN Number(3,0) SMALLINT NOT NULL Enrollment Print Area Seq
    56 ENRL_PRT_TERM Character(1) VARCHAR2(1) NOT NULL Term Title to Use
    L=Long Description
    S=Short Description
    57 ENRL_CRSE_TOPIC Character(1) VARCHAR2(1) NOT NULL Print Course Topic

    Y/N Table Edit

    Default Value: N

    58 ENRL_CRSE_ATTR Character(1) VARCHAR2(1) NOT NULL Print Course Attributes

    Y/N Table Edit

    Default Value: N

    59 ENRL_INSTRUCTOR Character(1) VARCHAR2(1) NOT NULL Print Instructor Name

    Y/N Table Edit

    Default Value: N

    60 ENRL_TSCRPT_NOTES Character(1) VARCHAR2(1) NOT NULL Print Transcript Notes

    Y/N Table Edit

    Default Value: N

    61 ENRL_SORT Character(1) VARCHAR2(1) NOT NULL Course List Sort Order
    C=Subj Area and Catlg Nbr
    S=Session / Subj
    62 ENRL_SESSION Character(1) VARCHAR2(1) NOT NULL Session Title to Use
    L=Long Description
    S=Short Description
    63 ENRL_CLASS_END_DT Character(1) VARCHAR2(1) NOT NULL Print Class Dates

    Y/N Table Edit

    Default Value: N

    64 ENRL_OEE_CLASS_DT Character(1) VARCHAR2(1) NOT NULL Print OEE Class Dates

    Y/N Table Edit

    Default Value: N

    65 ENRL_OBEY_ENPRT_DT Character(1) VARCHAR2(1) NOT NULL Obey Enrllmnt on Transcript Dt

    Y/N Table Edit

    Default Value: N

    66 ENRL_OBEY_FGRD_DT Character(1) VARCHAR2(1) NOT NULL Obey Fully Graded Date

    Y/N Table Edit

    Default Value: N

    67 ENRL_HIST_DATA Character(1) VARCHAR2(1) NOT NULL Include Historical Enrollment

    Y/N Table Edit

    68 TERM_STAT_PA Character(2) VARCHAR2(2) NOT NULL Term Statistics Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW6

    69 TERM_STAT_PN Number(3,0) SMALLINT NOT NULL Term Stat Print Area Seq
    70 TERM_STAT_OBEY_DT Character(1) VARCHAR2(1) NOT NULL Obey Show Stats on Tscript Dt

    Y/N Table Edit

    Default Value: N

    71 CUM_STAT_EOT Character(1) VARCHAR2(1) NOT NULL Print Cums at End of Term

    Y/N Table Edit

    Default Value: N

    72 CUM_STAT_COP Character(1) VARCHAR2(1) NOT NULL Print Cums at Change of Pgm

    Y/N Table Edit

    Default Value: N

    73 CUM_STAT_EOX Character(1) VARCHAR2(1) NOT NULL Print Cums at End of Tscript

    Y/N Table Edit

    Default Value: N

    74 TERM_HON_PA Character(2) VARCHAR2(2) NOT NULL Term Honors Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW6

    75 TERM_HON_PN Number(3,0) SMALLINT NOT NULL Term Honors Print Area Seq
    76 ACAD_STDNG_PA Character(2) VARCHAR2(2) NOT NULL Academic Standing Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW6

    77 ACAD_STDNG_PN Number(3,0) SMALLINT NOT NULL Academic Standing Print Seq
    78 WITHDRAWAL_PA Character(2) VARCHAR2(2) NOT NULL Withdrawal Info Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW7

    79 WITHDRAWAL_PN Number(3,0) SMALLINT NOT NULL Withdrawal Info Print Area Seq
    80 MILESTONE_PA Character(2) VARCHAR2(2) NOT NULL Milestones Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW8

    81 MILESTONE_PN Number(3,0) SMALLINT NOT NULL Milestones Print Area Seq
    82 ISSUE_PRTDT_PA Character(2) VARCHAR2(2) NOT NULL Issuance Print Date Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW1

    83 ISSUE_PRTDT_PN Number(3,0) SMALLINT NOT NULL Issuance Print Area Seq
    84 ISSUE_RQSTR_PA Character(2) VARCHAR2(2) NOT NULL Requester Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW2

    85 ISSUE_RQSTR_PN Number(3,0) SMALLINT NOT NULL Requester Print Area Seq
    86 ISSUE_REASON_PA Character(2) VARCHAR2(2) NOT NULL Request Reason Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW2

    87 ISSUE_REASON_PN Number(3,0) SMALLINT NOT NULL Request Reason Print Area Seq
    88 ISSUE_RECIPIENT_PA Character(2) VARCHAR2(2) NOT NULL Recipient Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW2

    89 ISSUE_RECIPIENT_PN Number(3,0) SMALLINT NOT NULL Recipient Print Area Seq
    90 EXT_INST_ATT_PA Character(2) VARCHAR2(2) NOT NULL Other Institutions Attended PA

    Default Value: ND

    Prompt Table: PRINT_AREA_VW2

    91 EXT_INST_ATT_PN Number(3,0) SMALLINT NOT NULL Other Inst Att Print Area Seq
    92 EXT_DEGR_PA Character(2) VARCHAR2(2) NOT NULL External Degrees Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW2

    93 EXT_DEGR_PN Number(3,0) SMALLINT NOT NULL External Degree Print Area Seq
    94 EXT_DEGR_HONS Character(1) VARCHAR2(1) NOT NULL Print Honors

    Y/N Table Edit

    Default Value: N

    95 TRNSFR_CR_PA Character(2) VARCHAR2(2) NOT NULL Transfer Credit Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW10

    96 TRNSFR_CR_PN Number(3,0) SMALLINT NOT NULL Transfer Credit Print Area Seq
    97 TRNSFR_CR_I_LEVEL Character(1) VARCHAR2(1) NOT NULL Level of Detail
    D=Detail
    S=Summary
    98 TRNSFR_CR_I_DETAIL Character(1) VARCHAR2(1) NOT NULL Details to Print
    B=External and Internal
    E=External Courses
    I=Internal Equivalent Course
    99 TRNSFR_CR_C_LEVEL Character(1) VARCHAR2(1) NOT NULL Level of Detail
    D=Detail
    S=Summary
    100 TRNSFR_CR_C_DETAIL Character(1) VARCHAR2(1) NOT NULL Details to Print
    B=External and Internal
    E=External Courses
    I=Internal Equivalent Course
    101 TRNSFR_CR_OBEY_EXT Character(1) VARCHAR2(1) NOT NULL Obey External Org Parms

    Y/N Table Edit

    102 TRNSFR_CR_LEVEL Character(1) VARCHAR2(1) NOT NULL Level of Detail
    D=Detail
    S=Summary
    103 TRNSFR_CR_DETAIL Character(1) VARCHAR2(1) NOT NULL Details to Print
    B=External and Internal
    E=External Courses
    I=Internal Equivalent Course
    104 TRNSFR_CR_POSTED Character(1) VARCHAR2(1) NOT NULL Print Posted Models Only

    Y/N Table Edit

    Default Value: N

    105 TRNSFR_CR_SUM_OPT Character(1) VARCHAR2(1) NOT NULL This field is used to track which way the summary information for transfer credit courses will be calculated and displayed in a transcript.

    Y/N Table Edit

    Default Value: Y

    106 TEST_CR_PA Character(2) VARCHAR2(2) NOT NULL Test Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW9

    107 TEST_CR_PN Number(3,0) SMALLINT NOT NULL Test Print Area Seq
    108 TEST_CR_LEVEL Character(1) VARCHAR2(1) NOT NULL Level of Detail
    D=Detail
    S=Summary
    109 TEST_CR_DETAIL Character(1) VARCHAR2(1) NOT NULL Details to Print
    B=Test and Internal Equiv
    E=Test Credits
    I=Internal Equivalent Course
    110 TEST_CR_POSTED Character(1) VARCHAR2(1) NOT NULL Print Posted Models Only

    Y/N Table Edit

    Default Value: N

    111 TEST_CR_SUM_OPT Character(1) VARCHAR2(1) NOT NULL This field is used to track which way the summary information for transfer credit tests will be calculated and displayed in a transcript.

    Y/N Table Edit

    Default Value: Y

    112 OTHER_CR_PA Character(2) VARCHAR2(2) NOT NULL Other Credits Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW9

    113 OTHER_CR_PN Number(3,0) SMALLINT NOT NULL Other Credits Print Area Seq
    114 OTHER_CR_LEVEL Character(1) VARCHAR2(1) NOT NULL Level of Detail
    D=Detail
    S=Summary
    115 OTHER_CR_DETAIL Character(1) VARCHAR2(1) NOT NULL Details to Print
    B=Other Cr and Internal
    E=Other Credits
    I=Internal Equivalent Course
    116 OTHER_CR_POSTED Character(1) VARCHAR2(1) NOT NULL Print Posted Models Only

    Y/N Table Edit

    Default Value: N

    117 OTHER_CR_SUM_OPT Character(1) VARCHAR2(1) NOT NULL This field is used to track which way the summary information for transfer credit tests will be calculated and displayed in a transcript.

    Y/N Table Edit

    Default Value: Y

    118 BOM_PA Character(2) VARCHAR2(2) NOT NULL BOM Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW2

    119 BOM_PN Number(3,0) SMALLINT NOT NULL BOM Print Area Seq
    120 AWARD_PA Character(2) VARCHAR2(2) NOT NULL Award Print Area

    Default Value: ND

    Prompt Table: PRINT_AREA_VW2

    121 AWARD_PN Number(3,0) SMALLINT NOT NULL Award Print Seq
    122 AWARD_AID_YEAR_PRT Character(1) VARCHAR2(1) NOT NULL Print Aid Year

    Y/N Table Edit

    Default Value: N

    123 AWARD_AMOUNT_PRT Character(1) VARCHAR2(1) NOT NULL Print Amount
    A=Accepted Amount
    D=Disbursed Amount
    124 SS_STDNT_AVAIL_TP Character(1) VARCHAR2(1) NOT NULL Checkbox variable for a view to retrieve valid transcript types for student self-service applications.

    Y/N Table Edit

    Default Value: N

    125 SS_ADVIS_AVAIL_TP Character(1) VARCHAR2(1) NOT NULL Checkbox variable for a view to retrieve valid transcript types for advisor self-service applications.

    Y/N Table Edit

    Default Value: N

    126 TERM_ACTIVE_ONLY Character(1) VARCHAR2(1) NOT NULL Term Activated Careers Only

    Y/N Table Edit

    Default Value: N

    127 USE_CMPLT_MODEL Character(1) VARCHAR2(1) NOT NULL This fiels is a flag that is passed in the what-if report request for academic advisement to flag whether or not to include the completed transfer credit models when running an advisement report.
    N=No
    Y=Yes

    Default Value: N

    128 SSR_SORT_MLSTN Character(1) VARCHAR2(1) NOT NULL Sort Milestones by Program on the Transcript

    Y/N Table Edit

    Default Value: N

    129 INFO_FOR_STDNTS Long Character CLOB A long text used by transcript type table used to display a message to students using the self-service transcript request pages.
    130 SAA_DISPLAY_TOPIC Character(1) VARCHAR2(1) NOT NULL This field is used in the setup table TRANSCRIPT_TYPE to determine if course topics are to be displayed for the specific transcript type record for Academic Advisement reports.

    Y/N Table Edit

    Default Value: N