S_NC_RPT_SAR_TEACHDEMO (ver 13.6.0)
This table is a stand alone table that stores information used in the School Activity Report Detail view.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ETH_RACE | 13.6.0 | Varchar2(20) | The ethnicity code for the staff record. |
| FIRST_NAME | 13.6.0 | Varchar2(20) | The first name of the staff person. |
| GENDER | 13.6.0 | Varchar | The gender of the staff person. |
| LAST_NAME | 13.6.0 | Varchar2(20) | The last name of the staff person. |
| MIDDLE_NAME | 13.6.0 | Varchar2(20) | The middle name of the staff person. |
| PRIM_STAFF_ROLE | 13.6.0 | Varchar2(2) | This is not collected. |
| 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_ID | 13.6.0 | Number(10,0) | The school Number for this record. |
| SSN | 13.6.0 | Varchar2(11) | The staff person's social security Number. |
| STAFF_UID | 13.6.0 | Varchar2(20) | The state staff id Number. |
| TEACHER_ID | 13.6.0 | Number(10,0) | The internal teacher id for this staff person. |
| TEACHER_NUMBER | 13.6.0 | Varchar2(20) | The teacher Number for this staff person. |
| TEACHER_USERS_DCID | 13.6.0 | Number(10,0) | Foreign key that links to the Users table. |