Skip to main content
Skip table of contents

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.0Varchar2(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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.