Content Comparison

EFFDT

Effective date is when a table row becomes effective, or the date that an action begins.

Effective dates in Student Administration provide the ability to define a record as in effect or planned, depending on the system or current date. Effective dates also maintain historical information in the database.

05/07/2023

01/01/1900 Lenora Barnes

01/01/1901 Lenora Barnes Consider Effective Date the “As of” date. With most setup tables, Effective Date goes hand in hand with Effective Status--this allows you to control when a set of rules should or will be “turned on” or “turned off”. For transactional tables, Effective Date informs the user what set of student states and/or attributes are in effect.

Effective Date Effective Status Translates to

01/01/2024 Active This row in the table is active as of 01/01/2024

07/01/2025 Inactive This row in the table will be inactive as of 07/01/2025

This is an example of one student’s undergraduate academic program record. It is sorted chronologically from oldest to newest.

The Action Date is the date the information was input into the system. The Eff Date (Effective Date) is the date the action becomes effective.

Consider today’s date to be 4/1/2023, this student’s status today would be DC - Discontinued. See record in red text. This student is not considered AC - Active until 5/8/2023, the effective date of the record, even though it’s its Action Date is 3/31/2023 which is prior to “today”.

Consider today’s date to be 4/1/2023. The last row in the example below, is known as future-dated. This action, entered on 3/31/2023, will take effect on 5/8/2023.

Career Eff Date Acad Prog Status Prog Actn Action Date
UGRD 12/7/2015 UACES AP APPL 12/7/2015
UGRD 2/20/2016 UACES AD ADMT 2/20/2016
UGRD 3/16/2016 UACES PM DEIN 3/16/2016
UGRD 5/12/2016 UACES AC MATR 5/12/2016
UGRD 8/26/2018 UACES DC VDIS 9/11/2018
UGRD 4/12/2022 UACES AC RADM 4/12/2022
UGRD 5/8/2022 UCLAS AC PRGC 4/29/2022
UGRD 1/16/2023 UCLAS DC VDIS 1/31/2023
UGRD 5/8/2023 UCLAS AC RADM 3/31/2023

• Data in the Student Administration DataMart (SADM) is current data. Future-dated rows are not loaded into the SADM tables.

• Future-dated

• Action Date