S_NC_RPT_PMR_SUMMARY (ver 13.6.0)
This table is a stand alone table that stores information used in the Principal Monthly Report Summary View.
Column Name | Version | Data Type | Description |
---|---|---|---|
ADA | 13.6.0 | NUMBER(,) | The average daily attendance for this grade level/school. |
ADM | 13.6.0 | NUMBER(,) | The average daily membership for this grade level/school. |
ADMISSION_STATUS_CODE | 13.6.0 | VARCHAR2(4) | The admission status code for this grade level/school record. |
ATT_NVIO | 13.6.0 | NUMBER(,) | The total number of days |
ATT_VIO | 13.6.0 | NUMBER(,) | |
COUNT_E1 | 13.6.0 | NUMBER(,) | The number of students that have an entry code of E1. |
COUNT_E2 | 13.6.0 | NUMBER(,) | The number of students that have an entry code of E2. |
COUNT_R1 | 13.6.0 | NUMBER(,) | The number of students that have an entry code of R1. |
COUNT_R2 | 13.6.0 | NUMBER(,) | The number of students that have an entry code of R2. |
COUNT_R3 | 13.6.0 | NUMBER(,) | The number of students that have an entry code of R3. |
COUNT_W1 | 13.6.0 | NUMBER(,) | The number of students that have an exit code of W1. |
COUNT_W2 | 13.6.0 | NUMBER(,) | The number of students that have an exit code of W2. |
COUNT_W3 | 13.6.0 | NUMBER(,) | The number of students that have an exit code of W3. |
COUNT_W4 | 13.6.0 | NUMBER(,) | The number of students that have an exit code of W4. |
DAYS_ABSENT_1H | 13.6.0 | NUMBER(,) | The number of days absent where the attendance code is 1H. |
DAYS_ABSENT_NON_1H | 13.6.0 | NUMBER(,) | The number of days absent where the attendance code is not 1H. |
DAYS_PRESENT | 13.6.0 | NUMBER(,) | The number of days present for this grade level/school. |
MEMBERSHIP_LASTDAY_NVIO | 13.6.0 | NUMBER(,) | The number of students in membership on the last day of the interval that are not in violation. |
MEMBERSHIP_LASTDAY_VIO | 13.6.0 | NUMBER(,) | The number of students in membership on the last day of the interval that are in violation. |
PMR_COLLECTION | 13.6.0 | NUMBER(,) | The number for the PMR collection for this record - value is 1 to 9. |
PMR_DURATION | 13.6.0 | NUMBER(,) | The number of days in the PMR interval. |
PMR_INTERVAL | 13.6.0 | NUMBER(,) | The PMR interval code for this record. For PMR collection 2, the interval is either 1 or 2. For PMR collection 9, the interval can be 1-9. |
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. |
SCHOOL_MONTH_BEGIN_DATE | 13.6.0 | DATE | Indicates the first day of the interval. |
SCHOOL_MONTH_END_DATE | 13.6.0 | DATE | Indicates the last day of the interval. |
STATE_GRADE_CODE | 13.6.0 | VARCHAR2(4) | Indicates the grave level cod for this record. |