Version: 1.0
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| CONTACT_ID | NUMBER | 22 | Y | Contact Id | Contact technical identifier |
| END_DATE | DATE | 7 | Y | End date | End date of the period |
| END_TIME | TIMESTAMP(3) | 11 | Y | Hour of end date of the period | |
| GUIDE | VARCHAR2 | 808 | Y | Guide | Last name, firstname of guide |
| GUIDE_ID | NUMBER | 22 | N | Technical identifier of guide (contact) | |
| INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
| LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
| ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of guide organization | |
| PERIOD_DATE | DATE | 7 | Y | Period date | Date within period. There is therefore a record by date included in the period. |
| PERIOD_DURATION | NUMBER | 22 | Y | Period duration | Duration of availability or unavailability (in seconds) |
| PERIOD_END_TIME | VARCHAR2 | 8 | Y | Period end time | Hour of end date of the period (ex: 03:00 pm) |
| PERIOD_START_TIME | VARCHAR2 | 8 | Y | Period start time | Hour of start date of the period (ex: 10:00 am) |
| PERIOD_TYPE | VARCHAR2 | 4000 | Y | Period type | Type of period ( availability / unavailability ) |
| REASON_AVAILABILITY | VARCHAR2 | 4000 | Y | Reason availability | Reason for unavailability. Possible values are: - Holiday - Absence - Other |
| RESOURCEPERIOD_ID | NUMBER | 22 | N | Technical identifier for period | |
| START_DATE | DATE | 7 | Y | Start date | Start date of the period |
| START_TIME | TIMESTAMP(3) | 11 | Y | Hour of start date of the period (ex: 10.01.71 18:00:00.000000000) | |
| T_PERIOD_TYPE | VARCHAR2 | 25 | Y | Type of period ( availability / unavailability ) | |
| WEEK_DAY | VARCHAR2 | 25 | Y | Day of the week |