S_PA_DIST_AED_S (ver 17.11.0)
This table is a stand alone table, and is used to complete the PIMS Location Fact Template for Automatic External Defibrillator (AED) For District Only.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 17.11.0 | Number(11,0) | System generated Primary Key. |
CONDITION | 17.11.0 | Varchar2(10) | Condition of AED unit - NA,NEW,GOOD,FAIR, or POOR |
INDICATOR_YN | 17.11.0 | Varchar2(1) | Indicator whether currently in service (Y/N). |
SERVICE_DATE | 17.11.0 | Date | Service Date. |
INSPECTION_EXPIRES_DATE | 17.11.0 | Date | The date on which the current AED inspection expires. |
PLACEMENT | 17.11.0 | Varchar2(3000) | Description of the location of the AED within the school. |
RECNO | 17.11.0 | Varchar2(2) | AED number - '01' through '16'. |
YEARID | 17.11.0 | Number(10) | Yearid |
| NO_AED_UNIT | 17.11.0 | Number(1,0) | Indicator whether an AED unit exists or not. |