S_TX_SEC_ADD_STAFF_C (ver 16.12.1)
This table is a child of the Sections table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| E0721_ROLE_ID | 16.12.1 | VARCHAR2(3) | The role id of the staff member. |
| E1065_BEGIN_DATE | 16.12.1 | DATE | The date the staff began their role on this section. |
| E1066_END_DATE | 16.12.1 | DATE | The date the staff ended their role on this section. |
| E1067_CLASS_ROLE_ID | 16.12.1 | VARCHAR2(2) | The class role for this staff member for this section. |
| ID | 16.12.1 | NUMBER(10,0) | Primary Key |
| SECTIONSDCID | 16.12.1 | NUMBER(10,0) | The foreign key that links the table to the Sections table. |
| SECTIONS_STAFF_TEACHER_NAME | 16.12.1 | VARCHAR2(50) | The name of the staff person. |
| SECTIONS_STAFF_TEACHER_NUM | 16.12.1 | VARCHAR2(25) | The teacher number of the staff person. |