Skip to main content
Skip table of contents

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


Data Type


AGE13.6.0 CHAR

Indicates the age of the student at the time of the collection.

DOB13.6.0 DATEIndicates the student's date of birth.
ENTRYCODE13.6.0 VARCHAR2(10)Indicates the entry code for the particular alternative learning program enrollment.
ENTRYDATE13.6.0 DATEThe student's entry date in the alternative learning program.
ENTRYREASON13.6.0 VARCHAR2(100)The reason the student was enrolled in the alternative learning program.
ETHNIC_DESC13.6.0 VARCHAR2(50)The description of the student's ethnic code.
EXITDATE13.6.0 DATEThe student's exit date from the alternative learning program.
FIRST_NAME13.6.0 VARCHAR2(50)The student's first name.
GENDER13.6.0 VARCHAR2(2)The student's gender.
GRADE_CODE13.6.0 VARCHAR2(4)The North Carolina grade code for the student.
GRADE_LEVEL13.6.0 VARCHAR2(4)The PowerSchool grade level for the student.
HAS_FATALS13.6.0 CHARIndicates if the student has fatals for this particular run ID.
LAST_NAME13.6.0 VARCHAR2(50)The student's last name.
PRIM_EXCP13.6.0 VARCHAR2(4)Indicates the student's primary exceptionality if available.
RPT_RUN_ID13.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_CODE13.6.0 VARCHAR2(1)Indicates the student's state ethnic code.
STATE_STUDENTID13.6.0 VARCHAR2(20)Indicates the state student number for the student.
STUDENTID13.6.0 NUMBER(,)The internal student id.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.