Contract Variables in the current system
Updated at 2023-02-03
Booking Related
"BOOKING_DELETED_BY": None,
"BOOKING_STATUS_TIME_RESIDENT": None,
"BOOKING_STATUS_TIME_EXPIRED": None,
"BOOKING_DELETED_AT": None,
"BOOKING_CURRENCY": "EUR",
"BOOKING_CANCELLED_REASON": "booking_amendment",
"BOOKING_AMENDMENT_CONTENT": "tenancy_option",
"BOOKING_FREE_CANCELLATION_DEADLINE_DATE": "2020-06-03",
"BOOKING_ID": 513,
"BOOKING_CHECK_OUT_DATE": None,
"BOOKING_STATUS_TIME_TERMS_ACCEPTED": "2020-06-03T12:50:35+00:00",
"BOOKING_REFUND_STATUS": "transferred",
"BOOKING_IS_REBOOKER": False,
"BOOKING_INSTALLMENT_TYPE": "full",
"BOOKING_BUILDING_NAME": "property_3_building_1",
"BOOKING_REFERRAL": None,
"BOOKING_HELD_BY": None,
"BOOKING_DISCOUNT_TYPE": "percentage",
"BOOKING_CHANGE_TENANCY_STAGE": None,
"BOOKING_TERMINATED_REASON": None,
"BOOKING_DISCOUNT_VALUE": Decimal("10.00"),
"BOOKING_PARTNER_REFERENCE_ID": None,
"BOOKING_PROPERTY_ID": 3,
"BOOKING_INSTALLMENT_ID": 1517,
"BOOKING_TOTAL_PRICE_AFTER_SERVICE": None,
"BOOKING_GUARANTOR_REQUIRED": False,
"BOOKING_STATUS_TIME_BOOKING_CONFIRMED": "2020-06-03T12:50:52+00:00",
"BOOKING_BOOKING_FORMS": [],
"BOOKING_UPDATED_AT": "2020-08-20T10:01:02+00:00",
"BOOKING_DEVICE": "desktop",
"BOOKING_SOURCE_BOOKING_ID": None,
"BOOKING_STATUS_TIME_ROOM_SELECTED": "2020-06-02T10:57:21+00:00",
"BOOKING_CATEGORY": "direct_let",
"BOOKING_PRICE_PER_NIGHT_AFTER_SERVICE": None,
"BOOKING_BOOKING_CHAIN_ID": 513,
"BOOKING_STATUS": "cancelled",
"BOOKING_DISCOUNT_CATEGORY": "installment",
"BOOKING_EXPIRED_REASON": None,
"BOOKING_EDITABLE": True,
"BOOKING_IGNORE_AGE_RESTRICTION": True,
"BOOKING_LATEST_AMENDMENT_DETAIL": {"target_booking_id": 6929, "total_price": None,
"deleted_by": None, "guarantor_required": None,
"checked_in": False, "rejected_at": None,
"total_price_original": None,
"type": "tenancy_shorten_later_check_in",
"expired_at": None, "deleted_at": None,
"price_per_night": None,
"amendment_milestone": None, "updated_by": 1,
"has_discount": None,
"accepted_at": "2020-08-20T10:00:59+00:00",
"updated_at": "2020-08-20T12:21:46+00:00",
"id": 85, "total_price_after_tax": None,
"source_booking_id": 513, "installment_type": None,
"created_at": "2020-08-20T09:21:02+00:00",
"booking_chain_id": 513,
"special_rate_offered": None,
"status": "confirmed", "discount_type": None,
"discount_amount": None, "created_by": 9,
"tax_amount": None, "discount_value": None,
"installment_name": None, "installment_id": None,
"tenancy_end_date": None},
"BOOKING_RATE_FLEXIBILITY": "full_flex",
"BOOKING_CANCELLED_BY": 1,
"BOOKING_STATUS_TIME_APPLIED": "2020-06-02T10:24:29+00:00",
"BOOKING_BED_ID": 41805,
"BOOKING_NOMINATION_PLAN_ID": 0,
"BOOKING_RENTAL_TAX_RATE": Decimal("1.00"),
"BOOKING_STUDENT_ID": 113,
"BOOKING_REFUNDED_BY": 1,
"BOOKING_CHECK_IN_DATE": None,
"BOOKING_PRICE_PER_NIGHT": Decimal("181.000000"),
"BOOKING_ROOM_TYPE_NAME": "property_3_room_type_3",
"BOOKING_RENTAL_TAX_RATE_TYPE": "included",
"BOOKING_UPDATED_BY": 1,
"BOOKING_REFUNDED_AT": "2020-08-20T10:01:02+00:00",
"BOOKING_ACADEMIC_YEAR_ID": 629,
"BOOKING_HAS_DISCOUNT": True,
"BOOKING_SERVICE_SELECTIONS": [],
"BOOKING_STATUS_TIME_CANCELLED": "2020-08-20T10:01:02+00:00",
"BOOKING_TENANCY_END_DATE_ORIGINAL": "2021-12-01",
"BOOKING_FLOOR_NAME": "building_1_floor_10",
"BOOKING_TENANCY_OPTION_ID": 1921,
"BOOKING_SPECIAL_RATE_OFFERED": False,
"BOOKING_STATUS_TIME_BOOKING_COMPLETED": None,
"BOOKING_INTERVAL_FOR_TURNAROUND": 0,
"BOOKING_STATUS_TIME_SELECTION_COMPLETED": "2020-06-02T11:19:27+00:00",
"BOOKING_DISCOUNT_AMOUNT": Decimal("3312.30"),
"BOOKING_BOOKING_TIPS": [],
"BOOKING_CREATED_BY": 1,
"BOOKING_TAX_AMOUNT": Decimal("295.16"),
"BOOKING_INSTALLMENT_NAME": "Full Installment",
"BOOKING_PRICE_PER_NIGHT_ORIGINAL": Decimal("181.000000"),
"BOOKING_TOTAL_PRICE": Decimal("29810.70"),
"BOOKING_TOTAL_PRICE_ORIGINAL": Decimal("33123.00"),
"BOOKING_STATUS_BEFORE_DISABLED": "booking_confirmed",
"BOOKING_SOURCE": "student_portal",
"BOOKING_ROOM_TYPE_ID": 9,
"BOOKING_FLAT_NAME": "building_1_floor_10_flat_1",
"BOOKING_EXPIRED_BY": None,
"BOOKING_CHANGE_TENANCY_TYPE": None,
"BOOKING_BED_NAME": "building_1_floor_10_flat_1_room_3_bed_1",
"BOOKING_TOTAL_PRICE_AFTER_TAX": Decimal("33123.00"),
"BOOKING_STATUS_TIME_PAST": None,
"BOOKING_CREATED_AT": "2020-05-29T09:47:32+00:00",
"BOOKING_TENANCY_LENGTH": 183,
"BOOKING_ROOM_NAME": "building_1_floor_10_flat_1_room_3",
"BOOKING_EXTERNAL_ID": None,
"BOOKING_REFUND_AMOUNT": Decimal("300.00"),
"BOOKING_HELD_TO_TIME": None,
"BOOKING_STATUS_TIME_DETAILS_COMPLETED": "2020-06-03T12:50:22+00:00",
"BOOKING_TENANCY_OPTION_NAME": "Fixed Tenancy Options",
"BOOKING_TENANCY_END_DATE": "2021-12-01",
"BOOKING_TENANCY_START_DATE": "2021-06-01",
"CONTRACT_CREATED_YEAR": 2021,
"CONTRACT_CREATED_DATE": "2021-03-10",
"BOOKING_PRICE_PER_WEEK": Decimal("1267.00"),
"BOOKING_BED_TYPE_MAX_OCCUPANCY": 1,
"BOOKING_PRICE_PER_MONTH": Decimal("5430.00"),
"INSTALLMENT_PLANS": [
{"created_at": "2020-05-26T02:12:45+00:00",
"updated_at": "2020-05-26T02:12:45+00:00", "booking_id": 1,
"deducted_by_booking_additional_fee_ids": None, "updated_by": 1,
"amount_due": Decimal("819.57"), "created_by": 1,
"is_due_before_booking_confirmed": True, "due_date": "2020-05-26",
"payment_item_id": None, "id": 1, "deleted_at": None, "deleted_by": None}],
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__FEATURE": None,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__DESCRIPTION": None,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__ADDITIONAL_FEE_CARD_CONFIG_ID": 509,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__BOOKING_ID": 1,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__CREATED_AT": "2020-05-26T02:12:45+00:00",
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__UPDATED_AT": "2020-05-26T02:12:45+00:00",
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__UPDATED_BY": 1,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__ID": 9,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__DUE_AMOUNT_WITH_TAX": Decimal("0.00"),
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__INSTALLMENT_NUMBER": None,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__TAX_RATE_ID": 65,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__DUE_DATE": "2020-05-26",
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__DELETED_AT": None,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__TAX_AMOUNT": Decimal("0.28"),
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__TAX_RATE": Decimal("0.93"),
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__IS_DUE_BEFORE_BOOKING_CONFIRMED": True,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__DUE_AMOUNT": Decimal("30.00"),
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__CREATED_BY": 1,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__PAYMENT_ITEM_ID": None,
"BOOKING_ADDITIONAL_FEES__OTHER_FEE__DELETED_BY": None,
"EXISTING_PROPERTY_NAME": "-",
"EXISTING_BOOKING_BED_NAME": "-",
"EXISTING_BOOKING_FLAT_NAME": "-",
"EXISTING_BOOKING_BUILDING_NAME": "-",
"EXISTING_BOOKING_TENANCY_START_DATE": "-",
"EXISTING_BOOKING_TENANCY_END_DATE": "-",
"EXISTING_CONTRACT_TOTAL_VALUE": "-",
"NEW_PROPERTY_NAME": "-",
"NEW_BOOKING_BED_NAME": "-",
"NEW_BOOKING_FLAT_NAME": "-",
"NEW_BOOKING_BUILDING_NAME": "-",
"NEW_BOOKING_TENANCY_START_DATE": "-",
"NEW_BOOKING_TENANCY_END_DATE": "-",
"NEW_CONTRACT_TOTAL_VALUE": "-",
"EXISTING_INSTALLMENT_PLANS": [],
"NEW_INSTALLMENT_PLANS": [],
CONTRACT_CREATED_DATE
GUARANTOR_FULL_NAME
GUARANTOR_ADDRESS_LINE_1
GUARANTOR_ADDRESS_LINE_2
GUARANTOR_CITY_TOWN
GUARANTOR_COUNTRY_TERRITORY
GUARANTOR_DATE_OF_BIRTH
INSTALLMENT_PLAN_TERM
INSTALLMENT_PLAN_AMOUNT_DUE
INSTALLMENT_PLAN_DUE_DATE
Property Related
"PROPERTY_ID": 109,
"PROPERTY_TIMEZONE": "Europe/London",
"PROPERTY_SYSTEM_EMAIL_ADDRESS": "belatonhouse@thestudenthousingcompany.com",
"PROPERTY_UPDATED_BY": 1,
"PROPERTY_CURRENCY": "GBP",
"PROPERTY_LONGITUDE": -1.85494,
"PROPERTY_BILLING_CYCLE": "weekly",
"PROPERTY_LENGTH_UNIT_OF_MEASUREMENT": "cm",
"PROPERTY_MANAGEMENT_COMPANY_NAME": "The Student Housing Company Limited",
"PROPERTY_ADDRESS_LINE_1": "Belaton House",
"PROPERTY_COUNTRY_ID": 317,
"PROPERTY_CONTACT_AREA_CODE": "+44",
"PROPERTY_ADDRESS_LINE_2": "130-138 Holdenhurst Road",
"PROPERTY_OWNER_REGISTERED_ADDRESS": "Meridian House, 16b Dennyview Road, Abbots Leigh, Bristol, BS8 3RB",
"PROPERTY_LANDLORD_ID": 13,
"PROPERTY_DELETED_AT": None,
"PROPERTY_PROPERTY_TYPE": "purpose_built_student_accommodation",
"PROPERTY_OWNER_NAME": "The Student Housing Company (Ops 2) Limited Partnership. LP020216. acting by its general partner, The Student Housing Company (Ops 2) GP Limited",
"PROPERTY_MANAGEMENT_COMPANY_REGISTERED_ADDRESS": "Meridian House, 16b Dennyview Road, Abbots Leigh, Bristol, BS8 3RB",
"PROPERTY_POSTCODE": "BH8 8AW",
"PROPERTY_CITY_ID": 47829,
"PROPERTY_CREATED_BY": 1,
"PROPERTY_CONTACT_PHONE_NUMBER": "1202941310",
"PROPERTY_ADDITIONAL_CURRENCIES": [],
"PROPERTY_CREATED_AT": "2020-07-29T11:19:32+00:00",
"PROPERTY_CONTACT_EMAIL_ADDRESS": "belatonhouse@thestudenthousingcompany.com",
"PROPERTY_UPDATED_AT": "2020-07-29T11:19:32+00:00",
"PROPERTY_DEFAULT_LANGUAGE": "EN",
"PROPERTY_DELETED_BY": None,
"PROPERTY_LATITUDE": 50.7307,
"PROPERTY_NAME": "Belaton House",
"PROPERTY_TOP_LANDLORD_ID": 1,
"PROPERTY_AREA_UNIT_OF_MEASUREMENT": "sqm",
"PROPERTY_ADDRESS": "Belaton House,130-138 Holdenhurst Road",
"PROPERTY_CITY_NAME": None,
"LANDLORD_NAME": "The Student Housing Company",
Student Related
"STUDENT_MOBILE_PHONE_AREA_CODE": "+1",
"STUDENT_MAJOR": "234234",
"STUDENT_DELETED_BY": None,
"STUDENT_HEARD_SOURCE": None,
"STUDENT_CITY_ID": 92697,
"STUDENT_TOP_LANDLORD_ID": 1,
"STUDENT_COMMUNICATION_PREFERENCES": [],
"STUDENT_UNIVERSITY_CARD_ID": None,
"STUDENT_FIRST_NAME": "Eunice2",
"STUDENT_HOME_PHONE_AREA_CODE": None,
"STUDENT_POSTCODE": "postcode",
"STUDENT_DELETED_AT": None,
"STUDENT_UUID": "573562b3-5a64-434e-9dfe-ba587ce2c27f",
"STUDENT_DESTINATION_UNIVERSITY": "Abraham Lincoln University",
"STUDENT_UPDATED_BY": 1,
"STUDENT_COUNTRY_ID": 21,
"STUDENT_PREFERRED_LANGUAGE": None,
"STUDENT_UPDATED_AT": "2020-06-23T05:30:36+00:00",
"STUDENT_ID": 113,
"STUDENT_DATE_OF_BIRTH": "2005-01-27",
"STUDENT_NATIONALITY": "land Islands",
"STUDENT_TITLE": "Mr", "STUDENT_MOBILE_PHONE": "(+1) 34324234",
"STUDENT_DEGREE_CLASSIFICATION": "undergraduate",
"STUDENT_IS_REBOOKER": False,
"STUDENT_YEAR_OF_STUDY": "fourth",
"STUDENT_PREFERRED_CURRENCY": None,
"STUDENT_CREATED_AT": "2020-05-28T12:22:15+00:00",
"STUDENT_COUNTRY_TERRITORY": "Albania",
"STUDENT_EXTERNAL_ID": None,
"STUDENT_PREFERRED_NAME": "Eunice2",
"STUDENT_GENDER": "male",
"STUDENT_HOME_PHONE_NUMBER": None,
"STUDENT_MOBILE_PHONE_NUMBER": "34324234",
"STUDENT_CREATED_BY": 1, "STUDENT_STUDENT_USER_ID": 113,
"STUDENT_PROFILE_PHOTO_FILE_UUID": "8b1ade63-20e0-47af-8a7f-fab45f320813",
"STUDENT_LAST_NAME": "Chong",
"STUDENT_ADDRESS_LINE_2": "hello",
"STUDENT_CITY_TOWN": "Durres",
"STUDENT_ADDRESS_LINE_1": "3423423",
"STUDENT_FULL_NAME": "Eunice2 Chong",
"STUDENT_MIDDLE_NAME": None,
"STUDENT_CONTACT_EMAIL": "eunice.chong+2@student.com",
"STUDENT_HOME_PHONE": "",
"STUDENT_PREFERRED_LANGUAGE_FULL": None,