EM002 Last Catnum

Attribute Description

OD Report and #

Enrollment Management EM002

Name

Last Catnum

Purpose

Intermediate field to isolate the last character from the catalog number field so it can be used as an exclusion in the EM Sections field. 

Business Owner

Vice Chancellor of Educational Services

Location

Stg_Course_Section

Stage

 

Formula

= Table.AddColumn(#"Added GEMP", "Last Catnum", each Text.End([Catnum], 1), type text) 

Pipeline

 

Dependencies

None;  uses Catnum and function to extract last character 

Notes

 

Last Updated

2/24/2023

Metric

No

Known Issues, Related Details, and Other Notes

·         None