S_PA_SCH_AED_C (ver 17.5.0)
This table is a child table of the [Schools] table, and is used to complete the PIMS Location Fact Template for Automatic External Defibrillator (AED).
Column Name | Version | Data Type | Description |
|---|---|---|---|
CONDITION | 17.5.0 | Varchar2(10) | Condition of AED unit - NA,NEW,GOOD,FAIR, or POOR |
INDICATOR_YN | 17.5.0 | Varchar2(1) | Indicator whether currently in service (Y/N). |
SERVICE_DATE | 17.5.0 | Date | School Year being reported - must be '06/30/YYYY' of the current school year. |
INSPECTION_EXPIRES_DATE | 17.5.0 | Date | The date on which the current AED inspection expires. |
PLACEMENT | 17.5.0 | Varchar2(3000) | Description of the location of the AED within the school. |
RECNO | 17.5.0 | Varchar2(2) | AED number - '01' through '16'. |
YEARID | 17.5.0 | Number(10) | Yearid |
| NO_AED_UNIT | 17.11.0 | Number(1,0) | Indicator whether an AED unit exists or not. |