DocMetaData (ver8.0.0)
This table associates students to documents in the S3 repository and contains file details for the Student Attachments page.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Alias | 8.0.0 | Varchar2(2000) | Optional user specified title, which prefixes the filename for the purpose of sorting. |
DocDistrictID | 8.0.0 | Varchar2(12) | Value representing the associated DocDistrict record. Required. Indexed. |
DocSize | 8.0.0 | Number(19,0) | Number of bytes the uploaded file uses in the S3. Defaults to 0. |
EntityType | 8.0.0 | Number(1,0) | Number representing the table association for the document. Valid values: 1 – students. Required. |
ID | 8.0.0 | Number(19,0) | Unique sequential number generated by the application. Required. Indexed. |
MetaData | 8.0.0 | CLOB | JSON object describing the attachment. Required. |
Name | 8.0.0 | Varchar2(2000) | Name of the uploaded file. Required. |
PluginIdentifier | 10.0.0 | Varchar2(256) | Identifies the specific instance of a plugin. |
S3Path | 8.0.0 | Varchar2(2000) | Path within the S3 where the document is stored. Required. Indexed. |
StudentsDCID | 8.0.0 | Number(10,0) | DCID of the associated Students record. Indexed. |
UploadStatus | 8.0.0 | Varchar2(30) | Valid values: Active and Pending. Active files are confirmed on S3. Pending are transit. Required. Indexed. |
WhenCreated | 8.0.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 8.0.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 8.0.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 8.0.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |
WhenUploaded | 8.0.0 | Timestamp(6) | Date and time the file is sent to S3. Indexed. |