DED Table and #

STUDENT BASIC SB037

Name

STUDENT'S FIRST APPLICATION TERM FOR CAREER

Short Name

APP_FIRSTTERM

Definition for UGRD

This is the term of the student's earliest effective dated application to one of San Diego Community College District's three credit colleges through CCCApply.

Definition for CE

CE students may apply through either the online CE application or paper application. Data for CE students is fed straight to PS_ACAD_PROG through a batch process or ADD/UPDATE A PERSON. We are capturing the first recorded term of this process.

Definition for CEHS

Same as CE

Origin

New element

DED Entry Last Updated

7/2/2020

Record(s)

X_IR_STBA_DAT

Field Name

X_IR_APP_FIRSTTERM

Heading Text

First App

Front-End Path

Student Admissions > Application Maintenance > Maintain Applications > Application Data Page, Application Date

OLDEST effective-dated row (Include History and scroll to the last record)

Format

Char4

Value Labels for UGRD

The term in MYYT format abbreviates the four-digit year by removing the hundred's place and T identifies the term.

First character: Millennium (M)
Second, Third : two - digit Year (YY)
Fourth: Term Identifier (T)

Term Identifiers:
Spring = 3
Summer = 5
Fall = 7

Example: 2197 = Fall 2019

Value Labels for CE

Same as UGRD

Value Labels for CEHS

Same as UGRD

Derived element?

Yes

Key element?

No