S_NC_RPT_CRDC_STU_ENR (ver. 20.7.1)
This table is a stand alone table that stores information about enrollment of students that are reported on the PowerSchool CRDC Preview Report collection .
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ENTRYCODE | 20.7.1 | VARCHAR2(10 CHAR) | Entry Code |
| ENTRYDATE | 20.7.1 | DATE | Entry Date |
| EXITCODE | 20.7.1 | VARCHAR2(10 CHAR) | Exit Code |
| EXITDATE | 20.7.1 | DATE | Exit Date |
| RPT_RUN_ID | 20.7.1 | NUMBER(10,0) | 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. |
| SCHOOLNAME | 20.7.1 | VARCHAR2(60 CHAR) | The name of the school |
| STUDENTDCID | 20.7.1 | NUMBER(10,0) | Student DCID. |
| STUDENTID | 20.7.1 | NUMBER(10,0) | Student ID. |
| STUDENTNAME | 20.7.1 | VARCHAR2(135 CHAR) | Student Name. |
| STUDENTNUMBER | 20.7.1 | FLOAT | Student Number. |