S_NC_EOY_CONTACT_INFO_S (ver 17.3.0)
This table is a stand alone table used by the state to store End Of Year contact information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 17.3.0 | NUMBER(19,0) | Primary key. |
| LAST_DATE_LAST_SCHOOL_ENDING | 17.3.0 | DATE | The latest date that any school in the LEA will end for the current year. |
| PRIM_CON_ADMIN_USERNAME | 17.3.0 | VARCHAR2(20) | The primary contact's administrative user name who will be responsible for the End of Year processes at the LEA. |
| PRIM_CON_ALT_PHONE | 17.3.0 | VARCHAR2(50) | The primary contact's alternate phone number who will be responsible for the End of Year processes at the LEA. |
| PRIM_CON_EMAIL_ADDR | 17.3.0 | VARCHAR2(256) | The primary contact's email address who will be responsible for the End of Year processes at the LEA. |
| PRIM_CON_FIRST_NAME | 17.3.0 | VARCHAR2(50) | The primary contact's first name who will be responsible for the End of Year processes at the LEA. |
| PRIM_CON_LAST_NAME | 17.3.0 | VARCHAR2(50) | The primary contact's last name who will be responsible for the End of Year processes at the LEA. |
| PRIM_CON_PHONE | 17.3.0 | VARCHAR2(50) | The primary contact's phone number who will be responsible for the End of Year processes at the LEA. |
| PRIM_CON_TITLE | 17.3.0 | VARCHAR2(50) | The primary contact's title who will be responsible for the End of Year processes at the LEA. |
| SEC_CON_ADMIN_USERNAME | 17.3.0 | VARCHAR2(20) | The secondary contact's administrative user name who will be responsible for the End of Year processes at the LEA. |
| SEC_CON_ALT_PHONE | 17.3.0 | VARCHAR2(50) | The secondary contact's alternate phone number who will be responsible for the End of Year processes at the LEA. |
| SEC_CON_EMAIL_ADDR | 17.3.0 | VARCHAR2(256) | The secondary contact's email address who will be responsible for the End of Year processes at the LEA. |
| SEC_CON_FIRST_NAME | 17.3.0 | VARCHAR2(50) | The secondary contact's first name who will be responsible for the End of Year processes at the LEA |
| SEC_CON_LAST_NAME | 17.3.0 | VARCHAR2(50) | The secondary contact's last name who will be responsible for the End of Year processes at the LEA. |
| SEC_CON_PHONE | 17.3.0 | VARCHAR2(50) | The secondary contact's phone number who will be responsible for the End of Year processes at the LEA |
| SEC_CON_TITLE | 17.3.0 | VARCHAR2(50) | The secondary contact's title who will be responsible for the End of Year processes at the LEA. |
| WHO_IS_RUNNING | 17.3.0 | VARCHAR2(5) | The ID number of the person who is running the End of Year Process. |