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 |