TRANSCRIPT_TEXT - Data Element Index . Tables and Data Elements . Student Records Data Home . Data Warehouse Home

TRANSCRIPT TEXT Table

(dwst.transcript_text)

Explanation

This table contains one row per transcript text position per student per career, as entered on SRS screen 124.

Common Uses

• Finding students who have specific types of text comments on their transcript..

Schema Name

DWST

Cautions.

• Currently the data warehouse does not have a system decode table for Position_code values. For the most current list of valid values, please consult the Student Records System, screen 124.
• Students can have multiple careers. The transcript text is specific to a position on a transcript for the specified career.
• Position 'G' is not a valid value for screen 124; it is used on the 14x screens in SRS to identify system-generated notations for the transcript. These are not extracted to the TRANSCRIPT_TEXT table.
• Position 'H' is used for Honors comments. Text in that position can be found in the TRANSCRIPT_HONORS table, not in the TRANSCRIPT_TEXT table.

TRANSCRIPT_TEXT - Data Element Index . Tables and Data Elements . Student Records Data Home . Data Warehouse Home