AB_STU_RECORD_DOC
This table stores PASI Student Record Document data
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_STU_RECORD_DOCID | SR_20.7.2.0 | NUMBER(19,0) | The primary key. |
| CREATED_BY_ORG | SR_20.7.2.0 | VARCHAR2(6 CHAR) | Created of by organization value of the document |
| CREATED_UTC_TIME | SR_20.7.2.0 | TIMESTAMP(6) | Created of by organization date and time of the document. |
| DISPOSAL_OVERRIDE_DATE | SR_20.7.2.0 | DATE | Disposal override date of the document. |
| DOC_DATE | SR_20.7.2.0 | DATE | Document date. |
| DOC_LANGUAGE | SR_20.7.2.0 | VARCHAR2(10 CHAR) | Document language. |
| DOC_TYPE | SR_20.7.2.0 | VARCHAR2(50 CHAR) | Document type. |
| EXPIRY_DATE | SR_20.7.2.0 | DATE | Expiry date of the document. |
| IS_DELETED | SR_20.7.2.0 | NUMBER(1) | Indicates whether this document is deleted in PASI. |
| IS_DIGITIZED | 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. |
| IS_EXEMPT_FROM_QA | SR_20.7.2.0 | NUMBER(1) | True if the document is considered exempt from quality assurance. |
| IS_RELEVANT | SR_20.7.2.0 | NUMBER(1) | True if this document is relevant; false if it has been replaced with another document. |
| IS_TEXT_SEARCHABLE | SR_20.7.2.0 | NUMBER(1) | True if the document has associated text that can be searched. |
| LAST_UPDATE_UTC_TIME | SR_20.7.2.0 | TIMESTAMP(6) | Last update date and time of the document. |
| LINKED_TO_ORG | SR_20.7.2.0 | VARCHAR2(6 CHAR) | A reference to the organization that the document is linked to. |
| LOCAL_ID | SR_20.7.2.0 | VARCHAR2(100 CHAR) | The ID of the student document record in PowerSchool. This is the link between the PASI tables and the PowerSchool tables. |
| ORIGINAL_FILE_NAME | SR_20.7.2.0 | VARCHAR2(200 CHAR) | Original file name of the document. |
| PASI_COREVERSION | SR_20.7.2.0 | NUMBER(19) | Core version of the document. |
| REFID | SR_20.7.2.0 | VARCHAR2(36 CHAR) | Reference Id of the document. |
| SCHOOL_YEAR | SR_20.7.2.0 | NUMBER(4) | A number representing which PASI school year the record belongs to, such as 2021 for 2020-2021 PASI school year. |
| STATE_PROVINCE_ID | SR_20.7.2.0 | VARCHAR2(20) | The provincial-assigned student number for the student. In most cases, this number should stay the same from school to school. |
| TITLE | SR_20.7.2.0 | VARCHAR2(200 CHAR) | Title of the document. |
| WhoCreated | SR_20.7.2.0 | Varchar2(100) | The name of the person who created the record. By default, it is 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 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. By default, it is the system date. |