S_NC_RPT_ALP_DETAIL (ver 13.6.0)
This table is a standalone table that stores information about the detail of the Alternative Learning Program Collection.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| AGE | 13.6.0 | CHAR | Indicates the age of the student at the time of the collection. |
| DOB | 13.6.0 | DATE | Indicates the student's date of birth. |
| ENTRYCODE | 13.6.0 | VARCHAR2(10) | Indicates the entry code for the particular alternative learning program enrollment. |
| ENTRYDATE | 13.6.0 | DATE | The student's entry date in the alternative learning program. |
| ENTRYREASON | 13.6.0 | VARCHAR2(100) | The reason the student was enrolled in the alternative learning program. |
| ETHNIC_DESC | 13.6.0 | VARCHAR2(50) | The description of the student's ethnic code. |
| EXITDATE | 13.6.0 | DATE | The student's exit date from the alternative learning program. |
| FIRST_NAME | 13.6.0 | VARCHAR2(50) | The student's first name. |
| GENDER | 13.6.0 | VARCHAR2(2) | The student's gender. |
| GRADE_CODE | 13.6.0 | VARCHAR2(4) | The North Carolina grade code for the student. |
| GRADE_LEVEL | 13.6.0 | VARCHAR2(4) | The PowerSchool grade level for the student. |
| HAS_FATALS | 13.6.0 | CHAR | Indicates if the student has fatals for this particular run ID. |
| LAST_NAME | 13.6.0 | VARCHAR2(50) | The student's last name. |
| PRIM_EXCP | 13.6.0 | VARCHAR2(4) | Indicates the student's primary exceptionality if available. |
| 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. |
| STATE_ETHNIC_CODE | 13.6.0 | VARCHAR2(1) | Indicates the student's state ethnic code. |
| STATE_STUDENTID | 13.6.0 | VARCHAR2(20) | Indicates the state student number for the student. |
| STUDENTID | 13.6.0 | NUMBER(,) | The internal student id. |