S_NC_ACADEMIC (ver 19.10.1)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Acad_Disadv | 13.6.0 | Varchar2(1) | Student is considered academically disadvantaged |
Bound_For_Code | 13.6.0 | Number(11,0) | Post-graduate intention, including college, military, trade school, employment. Values are stored in the GEN table. |
| Calc_UNC | 16.7.0 | Varchar2(1) | Flag for re-calculating UNC |
| Calc_Endorsements | 16.7.0 | Varchar2(1) | Flag for recalculating endorsements |
Career_Dev_Plan | 13.6.0 | Varchar2(1) | |
Career_Dev_Plan_Plus | 13.6.0 | Varchar2(1) | |
Case_Manager | 13.6.0 | Varchar2(30) | Name of the case manager for this student. |
College_Bound | 13.6.0 | Varchar2(1) | Indicates the student is expected to go to a higher education institution. |
Counselor | 13.6.0 | Varchar2(30) | Name of staff assigned to counsel student. |
CTE_Override | 14.5.0 | Varchar2(1) | |
CTE_Override_Audit | 14.5.0 | Varchar2(4000) | |
CTE_Override_Notes | 14.5.0 | Varchar2(4000) | |
CTE_Plan | 14.5.0 | Varchar2(6) | Indicates the CTE plan for the student. |
Diploma_Issued | 13.6.0 | Date | Date diploma was issued. |
Diploma_Type_Code | 13.6.0 | Varchar2(6) | Type of diploma issued (e.g. GCER, OCS, CRP, CTP, CTCP) |
Displ_Homemaker | 13.6.0 | Varchar2(1) | Indicates if the student qualifies as a Displaced Homemaker. |
| Endorsement_Audit | 15.40 | Varchar2(4000) | |
| Endsorsement_Notes | 15.4.0 | Varchar2(4000) | |
| Endorsement_Override | 15.4.0 | Varchar2(4000) | |
Grade_9_Entry_Date | 13.6.0 | Date | The first day of school entering Grade Level 9. |
Granted_Date | 13.6.0 | Date | Date the diploma was granted. |
Home_Language_Survey | 13.6.0 | Varchar2(1) | Indicates if the home language survey is on file. |
Home_Lang_Survey_Date | 13.6.0 | Date | Indicates the date the home language survey was received. |
Instructional_Setting_Code | 13.6.0 | Varchar2(6) | |
Mentor_Advisor | 13.6.0 | Varchar2(30) | Name of staff that is the mentor advisor for this student. |
| OCS_Date | 15.4.0 | Date | |
| OCS_Status | 15.4.0 | Varchar2(1) | |
Override_Audit | 14.5.0 | Varchar2(4000) | |
Override_IND | 13.6.0 | Varchar2(1) | |
Override_notes | 14.5.0 | Varchar2(4000) | |
| Plan_of_Intent | 15.4.0 | Varchar2(4000) | |
Program_Code | 13.6.0 | Number(11,0) | |
Prog_504 | 13.6.0 | Varchar2(1) | Student qualifies under federal Program 504. |
Proj_Grad_Year | 13.6.0 | Number(11,0) | Projected graduation year. |
Service_Learning_Hours | 13.6.0 | Number(11,0) | Total service learning hours. |
Single_Parent | 13.6.0 | Varchar2(1) | Indicates that this student is a single parent. |
STUDENTSDCID | 13.6.0 | Number(19,0) | A foreign key link to STUDENTS.DCID |
User_Defined_1 | 14.5.0 | Varchar2(4000) | |
User_Defined_2 | 14.5.0 | Varchar2(4000) | |
User_Defined_3 | 14.5.0 | Varchar2(4000) | |
User_Defined_4 | 14.5.0 | Varchar2(4000) | |
User_Defined_5 | 14.5.0 | Varchar2(4000) | |
| ECS_STATUS | 18.8.0 | Varchar2(1) | |
| ECS_DATE | 18.8.0 | Date | |
| USER_DEFINED_6 | 19.10.1 | Varchar2(4000) | |
| USER_DEFINED_7 | 19.10.1 | Varchar2(4000) | |
| USER_DEFINED_8 | 19.10.1 | Varchar2(4000) | |
| USER_DEFINED_9 | 19.10.1 | Varchar2(4000) | |
| USER_DEFINED_10 | 19.10.1 | Varchar2(4000) | |
| USER_DEFINED_11 | 19.10.1 | Varchar2(4000) | |
| USER_DEFINED_12 | 19.10.1 | Varchar2(4000) | |
| USER_DEFINED_13 | 19.10.1 | Varchar2(4000) | |
| USER_DEFINED_14 | 19.10.1 | Varchar2(4000) | |
| USER_DEFINED_15 | 19.10.1 | Varchar2(4000) |