S_AB_DOC_PROBLEM_REPORT_C (ver SR_20.7.2.0)
This is a child table of Students table that stores student's classroom accommodations.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | SR_20.7.2.0 | NUMBER(10,0) | Primary Key |
S_AB_STU_RECORD_DOC_CID | SR_20.7.2.0 | NUMBER(10,0) | DCID of the S_AB_STU_RECORD_DOC_C table. |
| PROBLEMREPORTREFID | SR_20.7.2.0 | VARCHAR2(30) | Reference id from the problem report. |
| PROBLEMRESOLUTION | SR_20.7.2.0 | VARCHAR2(100) | Depict the resolution of the problem report. |
| PROBLEMTYPE | SR_20.7.2.0 | VARCHAR2(100) | Depict the type of problem report identified on the student record document. |
| REPORTEDONUTCTIME | SR_20.7.2.0 | DATE | The UTC time when the problem is reported. |
| REPORTINGUSEREMAIL | SR_20.7.2.0 | VARCHAR2(100) | The email of the user who reported the student record document problem. |
| REPORTEDBYUSER | SR_20.7.2.0 | VARCHAR2(100) | The name of the person who created the problem report. |
| RESOLVEDONUTCTIME | SR_20.7.2.0 | DATE | The UTC time when the problem report is resolved. |
| RESOLVEDBYUSER | SR_20.7.2.0 | VARCHAR2(100) | The name of the person who resolved the problem report. |
| USERSCHOOLCODE | SR_20.7.2.0 | VARCHAR2(10) | The school code of the selected school of the login user. |
| WhoCreated | SR_20.7.2.0 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
| WhenCreated | SR_20.7.2.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | SR_20.7.2.0 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
| WhenModified | SR_20.7.2.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. |