SSR_TSCRPT_SGPA

(SQL Table)
Index Back

Transcript CareersTable

The Transcript Careers table contains the list of careers that use this transcript type.

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

    Prompt Table: INSTITUTION_TBL

    2 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type

    Prompt Table: TRANSCRIPT_TYPE

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 CAREER_SEQ_NBR Number(3,0) SMALLINT NOT NULL Career Sequence Number
    5 GPA_TYPE Character(4) VARCHAR2(4) NOT NULL GPA Type

    Prompt Table: SSR_SPCLGPA_VW

    6 SSR_TSTYPE_SGPAPRT Character(1) VARCHAR2(1) NOT NULL Print With
    C=Cumulative Statistics
    T=Term Statistics

    Default Value: T