DW Field | Oracle Field/Calc
| Description (Sample) | Snowflake Import Status |
---|---|---|---|
TERM |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
SEMESTER |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
STUDENTID |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
SSN |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
PIDM |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
LASTNAME |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
FIRSTNAME |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
MIDINIT |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
STUDENTNAME |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
ADDRESS |
| Address at the start of the record’s term | NEEDED |
CITY |
| City at the start of the record’s term | NEEDED |
STATE |
| State at the start of the record’s term | NEEDED |
ZIP |
| Zip at the start of the record’s term | NEEDED |
PHONE |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
STATUS |
| Description of Student Status. See the STVSTYP lookup table in the Appendix. This is the full description of the status. (Continuing Student, Returning Student) There is also the CAST code (shrttrm_cast_code) which is included at the end of the record. | NEEDED |
PROGRAM |
| The program of the major | NEEDED |
PROG_DEPT |
| Department code for student’s program Has snapshot data on SGASTDN instead of the maintained data on SOACURR. | NEEDED |
PROG_GE_PATTERN |
| Student’s GE pattern for programs | NEEDED |
IN_STATE_IND |
|
| NOT NEEDED Data Steward Disagreement |
MAJOR_CODE |
| Numeric code for the student’s major | NEEDED |
MAJOR |
| Description of the | NEEDED |
GOAL |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NOT NEEDED |
GOAL_INFORMED_EFF_TERM |
| The term at which the Informed Goal codes became effective. | NOT NEEDED |
FIN_AID_IND_BY_MJR |
| This is a Financial Aid indicator based on the major code. ('Y', 'N') | NEEDED |
CTE_IND_BY_MJR |
| This is a CTE indicator based on the major code. ('Y', 'N') | NEEDED |
GOAL_INFORMED_CODES |
| Most recent Informed Goal codes. Up to 10 codes, no delimiter. See Goal Codes in Appendix. | NOT NEEDED |
GENDER |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
BIRTHDATE |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
AGE |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
AGEATTERM |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
CENSUSAGEGROUP |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NOT NEEDED |
MARITAL_CODE |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED |
ETHNICITY |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NOT NEEDED |
NEW_ETHNICITY |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NOT NEEDED |
RACES |
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NOT NEEDED |
RACES_DESC |
| Description of | NOT NEEDED |
RACE_ETHN_CDE
|
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED - JL OVERRIDE |
RACE_ETHN_CDE_DESC
|
|
Error rendering macro 'excerpt-include' : No link could be created for 'Common Definitions'.
| NEEDED - JL OVERRIDE |
General
Content
Integrations
0 Comments