S_NC_RPT_PMR_DETAIL (ver 21.1.2)
This table is a stand alone table that stores information used in the Principal Monthly Report Detail View.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ABSENT_TOTAL_MINUTE | 21.1.2 | NUMBER(10,0) | Total absent minute calculated in a PMR Interval. |
| ADA_VALUE | 13.6.0 | FLOAT | Indicates the student's average daily attendance for the interval - number of days present non-violation /number of days in the interval. |
| ADMISSION_STATUS_CODE | 13.6.0 | VARCHAR2(6) | The admission status code for this student for this PMR interval. |
| ADM_VALUE | 13.6.0 | FLOAT | Indicates the student's average daily membership for the interval - number of days in membership non-violation/total number of days in the interval. |
| ATT_MEMBERSHIO_VIO | 13.6.0 | NUMBER(11,0) | The number of days the student was in membership with violations during the interval. |
| ATT_MEMBERSHIP_NVIO | 13.6.0 | NUMBER(11,0) | The number of days the student was in membership with no violations during the interval. |
| DAILY_1H_ABS | 13.6.0 | NUMBER(11,0) | Indicates the number of days the student was absent during the interval with an absence code of 1H. |
| DAILY_NON_1H_ABS | 13.6.0 | NUMBER(11,0) | Indicates the number of days the student was absent during the interval excluding the 1H absence codes. |
| DAILY_PRESENT | 13.6.0 | NUMBER(11,0) | Indicates the number of days the student was present during this interval. |
| E1_CARRY_FORWARD | 13.6.0 | CHAR(1,0) | If a student's entry date is less than or equal to the last date of the PMR interval and the student's exit date is greater than the PMR interval start date this value is an N; else it is a Y. |
| ENTRYCODE | 13.6.0 | VARCHAR2(10) | The student's enter code for this record. |
| ENTRYDATE | 13.6.0 | DATE | The student's entry date. |
| EXITCODE | 13.6.0 | VARCHAR2(10) | The student's exit code for this record. |
| EXITDATE | 13.6.0 | DATE | The student's exit date. |
| GENDER | 13.6.0 | VARCHAR2(2) | The gender for the students on this record. |
| GRADE_CODE | 13.6.0 | VARCHAR2(4) | The student's PowerSchool grade level. |
| HAS_FATALS | 13.6.0 | CHAR(1,0) | Indicates if the record has data that causes a fatal exception. This record will not be included in the final summary reports. |
| ORIG_ENTRYCODE | 13.6.0 | VARCHAR2(10) | The student's original enter code for the school year. |
| PMR_COLLECTION | 13.6.0 | NUMBER(11,0) | The number for the PMR collection for this record - value is 1 to 9. |
| PMR_DURATION | 13.6.0 | NUMBER(11,0) | The number of days in the PMR interval for this record. |
| PMR_INTERVAL | 13.6.0 | NUMBER(11,0) | 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. |
| POTENTIAL_TOTAL_MINUTE | 20.9.3 | NUMBER(10,0) | Total minute calculated in a PMR Interval. |
| R1_TOTAL_MINUTE | 20.9.3 | NUMBER(10,0) | Total minute calculated for the attendance code 1R in a PMR Interval. |
| RPT_RUN_ID | 13.6.0 | NUMBER(11,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. |
| SCHOOL_MONTH_BEGIN_DATE | 13.6.0 | DATE | The first day of the PMR interval. |
| SCHOOL_MONTH_END_DATE | 13.6.0 | DATE | The last day of the PMR interval. |
| STATE_ENTRYCODE | 13.6.0 | VARCHAR2(4) | The state code that is mapped to the enter code. |
| STATE_ETHNIC_CODE | 13.6.0 | VARCHAR2(1) | The student's state ethnicity code. |
| STATE_EXITCODE | 13.6.0 | VARCHAR2(4) | The state code that is mapped to the exit code. |
| STATE_GRADE_CODE | 13.6.0 | VARCHAR2(4) | The state grade level for the students on this record. |
| STATE_STUDENTID | 13.6.0 | VARCHAR2(20) | The state student number for this student. |
| STUDENTID | 13.6.0 | NUMBER(11,0) | The student number for this student. |
| STU_MMBR_LASTDAY_NVIO | 13.6.0 | VARCHAR2(1) | Indicates if the student was in membership or not on the last day of the interval and is not in violation. |
| STU_MMBR_LASTDAY_VIO | 13.6.0 | VARCHAR2(1) | Indicates if the student was in membership or not on the last day of the interval and is in violation. |
| TRACK | 13.6.0 | VARCHAR2(10) | The track indicator for this student. |