S_NC_RPT_RPG_DETAIL (ver 13.6.0)
This table is a stand alone table that stores information used in the Retention Promotion Detail View.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| AGE | 13.6.0 | NUMBER(2,0) | The age of the student calculated on the run date. |
| EIXT_CODE | 13.6.0 | VARCHAR2(10) | The student's exit code. |
| EOSS_STATUS | 13.6.0 | VARCHAR2(4) | The student's end of summer school promotion/retention status. |
| EOY_MLD | 13.6.0 | CHAR | The student's membership on the last day status. |
| EOY_STATUS | 13.6.0 | VARCHAR2(4) | The student's end of year promotion/retention status. |
| ETHNIC_DESC | 13.6.0 | VARCHAR2(50) | The description of the student's ethnicity. |
| GENDER | 13.6.0 | VARCHAR2(2) | The student's gender. |
| GRADE_CODE | 13.6.0 | VARCHAR2(4) | The state grade level code for the student. |
| GRADE_LEVEL | 13.6.0 | VARCHAR2(4) | The PowerSchool grade level code for the student. |
| HAS_FATALS | 13.6.0 | CHAR | Indicates that data on this record will cause a fatal. |
| LAST_FIRST | 13.6.0 | VARCHAR2(100) | The student's last name. |
| PRIM_EXCP | 13.6.0 | VARCHAR2(50) | The student's primary EC exceptionality. |
| RPT_RUN_ID | 13.6.0 | NUMBER(,) | Indicates the unique report run ID for this run. This links to the S_NC_RPT_RUN table to identify the LEA, School, Report Type, Instance ID, and Year ID. |
| SS_TYPE | 13.6.0 | VARCHAR2(4) | Indicates if the student's summer school type is LOCS or not. They must have a course in stored grades coded in How Taken as LOCS. |
| STATE_ETHNIC_CODE | 13.6.0 | VARCHAR2(1) | The student's ethnicity code. |
| STATE_STUDENTID | 13.6.0 | VARCHAR2(20) | The student's state student number. |
| STUDENTID | 13.6.0 | NUMBER(,) | The internal student id. |
| W4_STUDENT | 13.6.0 | VARCHAR2(10) | Indicates if the student was an early/mid-year graduate. |