S_AB_STU_RECORD_DOC_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 |
STUDENTSDCID | SR_20.7.2.0 | NUMBER(10,0) | DCID of the Students table. |
| DOCDATE | SR_20.7.2.0 | DATE | Document date. |
| DOCLANGUAGE | SR_20.7.2.0 | VARCHAR2(10) | Document language. |
| DOCTYPE | SR_20.7.2.0 | VARCHAR2(50) | Document type. |
| EXPIRYDATE | SR_20.7.2.0 | DATE | Expiry date of the document. |
| ISDIGITIZED | SR_20.7.2.0 | NUMBER(1) | True when this document is a digitized version of a physical (hard copy) document. False when the document was created by a system and imported directly into PASI. |
| ISEXEMPTFROMQA | SR_20.7.2.0 | NUMBER(1) | True if the document is considered exempt from quality assurance. |
| ISQAALREADYPERFORMED | SR_20.7.2.0 | NUMBER(1) | True if the document has already gone through quality assurance prior to import and does not need any additional quality assurance in PASI. |
| ISRELEVANT | SR_20.7.2.0 | NUMBER(1) | True if this document is relevant; false if it has been replaced with another document. |
| ISTEXTSEARCHABLE | SR_20.7.2.0 | NUMBER(1) | True if the document has associated text that can be searched. |
| LINKEDTOORG | SR_20.7.2.0 | VARCHAR2(6) | A reference to the organization that the document is linked to. |
| LINKEDTOSCHOOLYEAR | SR_20.7.2.0 | NUMBER(11) | The school year this document is applicable to. |
| ORIGINALFILENAME | SR_20.7.2.0 | VARCHAR2(200) | Original file name of the document. |
| TITLE | SR_20.7.2.0 | VARCHAR2(200) | Title of the document. |
| USERSCHOOLCODE | SR_20.7.2.0 | VARCHAR2(10) | The school code of the selected school of the login user. |
| LINKTOIDENTITY | SR_20.7.2.0 | NUMBER(1) | True if the document can be linked to a student's identity. |
| ISONLYRELEVANT | SR_20.7.2.0 | NUMBER(1) | True if the document is considered as the only relevant one for documents of the same type. |
| REFID | SR_20.7.2.0 | VARCHAR2(36) | Reference Id of the document. |
| PASICOREVERSION | SR_20.7.2.0 | NUMBER(11) | Core version of the document. |
| CREATEDBYORG | SR_20.7.2.0 | VARCHAR2(6) | Created of by organization value of the document. |
| DOCSIZE | SR_20.7.2.0 | NUMBER(11) | The file size of the document in bytes. |
| DOCMETADATAID | SR_20.10.2.0 | NUMBER(11) | Store document metadata ID, only used for document integration functionality. |
| SOURCE | SR_23.4.3.0 | VARCHAR2(100) | Source. |
| 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. |