EM ALGORITHM PLAN RUN SNAPSHOT Table
View exposing snapshot records of enrollment management algorithm plan runs used to support registration, reservation, and waitlist processing analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALGORITHM_ID |
Business identifier for the algorithm. |
VARCHAR2 |
32 |
ALGORITHM_ID_RUN_DATE |
Date associated with algorithm id run. |
VARCHAR2 |
50 |
ALGORITHM_PLAN_RUN_KEY |
Surrogate key identifying the algorithm plan run. |
VARCHAR2 |
100 |
ASSIGNED_PROJECTED_FRESHMEN |
Assigned projected freshmen associated with the record. |
NUMBER |
5 |
CIH_ATTRIBUTE |
Cih attribute associated with the record. |
VARCHAR2 |
10 |
FINAL_RUN |
Final run associated with the record. |
VARCHAR2 |
2 |
MASTER_SUBJECT_ID |
Business identifier for the master subject. |
VARCHAR2 |
10 |
PROJECTED_FRESHMEN_INCL |
Projected freshmen incl associated with the record. |
VARCHAR2 |
2 |
RUN_DATE |
Date associated with run. |
DATE |
|
SECTION |
Section associated with the record. |
VARCHAR2 |
5 |
SECTION_CAP |
Section cap associated with the record. |
VARCHAR2 |
6 |
SECTION_REGISTRATION |
Section registration associated with the record. |
VARCHAR2 |
2 |
SNAPSHOT_NAME |
Snapshot name associated with the record. |
VARCHAR2 |
25 |
STUDENTS_ASSIGNED |
Students assigned associated with the record. |
NUMBER |
5 |
SUBJECT_CAP |
Subject cap associated with the record. |
NUMBER |
5 |
TERM_CODE |
Code identifying term. |
VARCHAR2 |
8 |
WAREHOUSE_CREATE_DATE |
Date associated with warehouse create. |
DATE |
|
WAREHOUSE_CREATE_USER |
Warehouse create user associated with the record. |
VARCHAR2 |
1 |
WAREHOUSE_OS_USER |
Warehouse os user associated with the record. |
VARCHAR2 |
1 |
WAREHOUSE_UPDATE_DATE |
Date associated with warehouse update. |
DATE |
|
WAREHOUSE_UPDATE_USER |
Warehouse update user associated with the record. |
VARCHAR2 |
1 |