Data Dictionary

Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.

HSI Objects

Object Label	Object API Name	Object Description
Client	Account	Stores the client information
Client Interaction	Case	Stores the interaction for every line of business
Article View Stat	Article_Views_Stats__c	????
Service Delivery	Client_Application__c	Stores the client applications
Exception Log	Exception_Log__c	Stores exceptions created in HSI procsess
Service Delivery To Client	Services_to_client__c	It's a junction object connecting Client and Client Application objects
Tempvs	Tempvs__c	Depreciate: stores temporary Presto Card info to import
HSI Auto subject rule	HSI_Auto_subject_rule__c	Stores the predefined interaction information
HSI FP TTC Transfer Data	HSI_FP_TTC_Transfer_Data__c	Stores the TTC Transfer data
HSI Weighted	HSI_Weighted__c	Stores the performance rate for users
HSI OW Rate	HSI_OW_Rate__c	Stores the data used in the HSIF-2983 project
user login	user_login__c
HSI External File	HSI_External_File__c	Stores the external files information.

EarlyON Attendance(With Guest)	Earlyon_Attendance_With_Guest__c
EarlyON Center	Earlyon_Centers__c
EarlyON Registered Member group	Earlyon_Registered_Member_group__c
EarlyON Registered Member	Earlyon_Registered_Members__c

HSI Fields

OBJECT_NAME	OBJECT_API_NAME	FIELD_NAME	FIELD_API_NAME	FIELD_TYPE	IS_EXTERNAL IS_UNIQUE	FIELD_PICKLIST_VALUE
Client	Account	Gender	gender__c	PICKLIST	false-false	Male, Female
Client	Account	Salutation	salutation	PICKLIST	false-false	Mr., Ms., Mrs., Dr., Prof.
Client	Account	Billing Geocode Accuracy	billinggeocodeaccuracy	PICKLIST	false-false	Address, NearAddress, Block, Street, ExtendedZip, Zip, Neighborhood, City, County, State, Unknown
Client	Account	Shipping Geocode Accuracy	shippinggeocodeaccuracy	PICKLIST	false-false	Address, NearAddress, Block, Street, ExtendedZip, Zip, Neighborhood, City, County, State, Unknown
Client	Account	Industry	industry	PICKLIST	false-false	Agriculture, Apparel, Banking, Biotechnology, Chemicals, Communications, Construction, Consulting, Education, Electronics, Energy, Engineering, Entertainment, Environmental, Finance, Food & Beverage, Government, Healthcare, Hospitality, Insurance, Machinery, Manufacturing, Media, Not For Profit, Other, Recreation, Retail, Shipping, Technology, Telecommunications, Transportation, Utilities
Client	Account	Client Rating	rating	PICKLIST	false-false	Hot, Warm, Cold
Client	Account	Mailing Geocode Accuracy	personmailinggeocodeaccuracy	PICKLIST	false-false	Address, NearAddress, Block, Street, ExtendedZip, Zip, Neighborhood, City, County, State, Unknown
Client	Account	Client Source	accountsource	PICKLIST	false-false	Website, CSIS2, Ontario Works, Housing/Shelter
Client	Account	Mobile Voice Mail	mobile_voice_mail__c	PICKLIST	false-false	Yes, No, Prefer not to answer
Client	Account	Other Phone Voicemail	other_phone_voicemail__c	PICKLIST	false-false	Yes, No, Prefer not to answer
Client	Account	Salutation	salutation__c	PICKLIST	false-false	Mr., Mrs., Ms., Prof., Dr.
Client Interaction	Case	Client Interaction Type	type	PICKLIST	false-false	Problem, Feature Request, Question
Client Interaction	Case	Interaction Status	status	PICKLIST	false-false	New, Closed, New - ID Match
Client Interaction	Case	Client Interaction Reason	reason	PICKLIST	false-false	User didn't attend training, Complex functionality, Existing problem, Instructions not clear, New problem
Client Interaction	Case	Service Request Channel	origin	PICKLIST	false-false	Phone, Web, Virtual, Other (mail/fax)
Client Interaction	Case	Language	language	PICKLIST	false-false	en_US, de, es, fr, it, ja, sv, ko, zh_TW, zh_CN, pt_BR, nl_NL, da, th, fi, ru, es_MX, no
Client Interaction	Case	Priority	priority	PICKLIST	false-false	High, Medium, Low, Critical
Client Interaction	Case	Primary Purpose	primary_purpose__c	PICKLIST	false-false	Application, File Support, General Information, Online Account, Feedback, Application Support
Client Interaction	Case	Primary Purpose	anonymous_primary_purpose__c	PICKLIST	false-false	General Information, Application Support, Feedback
Client Interaction	Case	Activity	activity__c	PICKLIST	false-false	App - New Application, App - Reapplication, App - Hardship/Priority Application, App - Renewal/Reinstate, FS - Enquiry Info, FS - File Update, FS - Admin/Account, FS - Divisional Transfer, FS - Benefit Request, FS - File Transfer, Inquiry, Admin - Appointment/Meeting
Client Interaction	Case	Line of Business	line_of_business__c	PICKLIST	false-false	Ontario Works, Child Care - Fee Subsidy/Full Fee, Rent Geared to Income, Welcome Policy, Medical Benefits, Fair Pass, Temporary Care Assistance, Emergency Energy Fund, T5, Funeral, Dropped Call / Dead Air, Other
Client Interaction	Case	Interaction Outcome	outcome__c	PICKLIST	false-false	Complete, Incomplete, Withdrawn, Ineligible, Additional Review
Client Interaction	Case	Quality Control Review Outcome	quality_control_review_outcome__c	PICKLIST	false-false	Follow Up Required, Review Completed - No Issues, QC Issue Resolved
Client Interaction	Case	FP Eligibility Review Outcomes	fp_eligibility_review_outcomes__c	PICKLIST	false-false	Eligible - OW, Eligible - ODSP, Eligible - CCFS, Eligible - RGI, Ineligible - OW, Ineligible - ODSP, Ineligible - CCFS, Ineligible - RGI, Ineligible - Not an active client
Client Interaction	Case	Apply FP Discount Program	apply_fp_discount_program__c	PICKLIST	false-false	No - Not Required, Yes - Apply Discount to Card
Client Interaction	Case	Concession Issue	concession_issue__c	PICKLIST	false-false	Dropped Concession, Other
Client Interaction	Case	WP Review Outcome	wp_review_outcome__c	PICKLIST	false-false	Eligible - OW, Eligible - ODSP, Eligible - Low Income, Potentially Eligible, Ineligible - OW, Ineligible - ODSP, Ineligible - Not Low Income, Duplicate Application
Client Interaction	Case	WP Subsidy	wp_subsidy__c	PICKLIST	false-false	Subsidy Issued, Subsidy Renewed, Subsidy Not Issued (pre-existing), Subsidy Cancelled, No Subsidy Issued
Service Delivery	Client_Application__c	Application Type	application_type__c	PICKLIST	false-false	RGI, Children Services, Ontaro Works, Fair Pass
Service Delivery	Client_Application__c	Funding Stream	funding_stream__c	PICKLIST	false-false	Full, Partial, REG
Service Delivery	Client_Application__c	Application Source	application_source__c	PICKLIST	false-false	Web, Migration
Service Delivery	Client_Application__c	Province	province__c	PICKLIST	false-false	Ontario
Service Delivery	Client_Application__c	Fair pass PVS Status	pvs_upload_status__c	PICKLIST	false-false	Success, Failure, In progress
Service Delivery	Client_Application__c	CRM Status	crm_status__c	PICKLIST	false-false	New, Application Submitted, Eligible, Ineligible, Active, Active Pending renewal, Closed
Client Interactions Process	Client_Interactions_Process__c	Activity	activity__c	PICKLIST	false-false	App - New Application, App - Reapplication, App - Renewal/Reinstate, App - Hardship/Priority Application, FS - Enquiry Info, FS - File Update, FS - Admin/Account, FS - Divisional Transfer, FS - Benefit Request, FS - File Transfer, Admin - Appointment/Meeting, Inquiry
Client Interactions Process	Client_Interactions_Process__c	Line of Business	line_of_business__c	PICKLIST	false-false	Ontario Works, Child Care - Fee Subsidy/Full Fee, Rent Geared to Income, Welcome Policy, Medical Benefits, Fair Pass, Temporary Care Assistance, Emergency Energy Fund, T5, Funeral, Dropped Call / Dead Air, Other
Client Interactions Process	Client_Interactions_Process__c	Interaction Outcome	interaction_outcome__c	PICKLIST	false-false	Complete, Incomplete, Withdrawn, Ineligible, Additional Review
Client Interactions Process	Client_Interactions_Process__c	Service Request Channel	service_request_channel__c	PICKLIST	false-false	Phone, Web, Virtual, Other (mail/fax)
EarlyON Attendance(With Guest)	Earlyon_Attendance_With_Guest__c	EarlyON Guest type	earlyon_guest_type__c	PICKLIST	false-false	Adult, Child
EarlyON Center	Earlyon_Centers__c	Centre Ward	center_ward__c	PICKLIST	false-false	1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25
EarlyON Center	Earlyon_Centers__c	Organization Name	agency_short_name__c	PICKLIST	false-false	ACCESS ALLIANCE, ADVENTURE PLACE, AGINCOURT COMMUNITY SERVICES, ALEXANDRA PARK RESIDENTS, ANNIE'S PLACE, APPLEGROVE COMMUNITY COMPLEX, BIRCHMOUNT BLUFFS, BOB RUMBALL, BRAEBURN, CANADIAN MOTHERCRAFT, CENTRAL EGLINTON CENTRE, CENTRE FRANCOPHONE, CHILD DEVELOPMENT INSTITUTE, CLIFFCREST COMM. CENTR., COLLEGE-MONTROSE CHILDREN, CONSEIL SCOLAIRE -VIAMONDE, CREATING TOGETHER PARKDALE, DAVENPORT-PERTH NEIGHBOURHOOD, DAY CARE CONNECTION, DELTA FAMILY RESOURCE, EAST END CHILDREN'S CENTRE, EAST SCARB B. & G. CLUB, EASTVIEW NEIGHBOURHOOD, ENAGB YOUTH PROGRAM, FAMILY DAY CARE SERVICES, GEORGE HULL -ISLINGTON VILLAGE, JANE/FINCH COMMUNITY CENTRE, LAMP, MACAULAY CHILD DEVELOPMENT, MALVERN FAMILY RESOURCE CENTRE, MASSEY CENTRE, MORE THAN CHILD'S PLAY, NATIVE CANADIAN CENTRE, NATIVE CHILD, NORTHWOOD NEIGHBOURHOOD, OJIBIIKAAN, PARENT RESOURCES, REGENT PARK, RYERSON UNIVERSITY, SCADDING COURT COMMUNITY CTR, SCARBOROUGH CENTRE, SICKKIDS, SOUTH RIVERDALE CHILD CENTRE, ST. CHRISTOPHER HOUSE, SYME-WOOLNER NEIGHBOURHOOD, T.C.D.S.B. SCHOOL BOARD, TDSB, THE 519 CHURCH ST. CENTRE, THE CHILDREN'S STOREFRONT, TNO, WEST SCARBOROUGH, YES I CAN, YWCA TEEN MOTHER'S PROGRAM
Earlyon Exception Day	Earlyon_Exception_Day__c	Type	type__c	PICKLIST	false-false	STH, CLS
Earlyon Operation Hours	Earlyon_Operation_Hours__c	Program Type	program_type__c	PICKLIST	false-false	DROPIN, REGIST, VIRTUAL
EarlyON Registered Member	Earlyon_Registered_Members__c	Member Type	member_type__c	PICKLIST	false-false	Adult, Child
EarlyON Registered Member	Earlyon_Registered_Members__c	Race_Deprecated	race__c	PICKLIST	false-false	Black, Asian, First Nations
EarlyON Registered Member	Earlyon_Registered_Members__c	Sexual Orientation	sexual_orientation__c	PICKLIST	false-false	Heterosexual or Straight, Bisexual, Gay, Lesbian, Queer, Unsure, Not listed, please describe, Prefer not to answer
EarlyON Registered Member	Earlyon_Registered_Members__c	Two Spirit question	two_spirit_question__c	PICKLIST	false-false	Yes, No, Prefer not to answer
EarlyON Registered Member	Earlyon_Registered_Members__c	Race	member_race__c	PICKLIST	false-false	Arab, Middle Eastern or West Asian (examples: Afghan, Armenian, Iranian, Lebanese, Persian, Turkish), Black (examples: African, African-Canadian, Afro-Caribbean), East Asian (examples: Chinese, Japanese, Korean), First Nations (status, non-status, treaty or non-treaty), Inuit or Métis, Latin American (examples: Brazilian, Colombian, Cuban, Mexican, Peruvian), South Asian or Indo-Caribbean (examples: Indian, Indo-Guyanese, Indo-Trinidadian, Pakistani, Sri Lankan), Southeast Asian (examples: Filipino, Malaysian, Singaporean, Thai, Vietnamese), White (examples: English, Greek, Italian, Portuguese, Russian, Slovakian), More than one race category or mixed race, Not Listed, Prefer not to answer
EarlyON Registered Member	Earlyon_Registered_Members__c	Age	age__c	PICKLIST	false-false	10-19, 20-24, 25-29, 30-54, 55-64, 65+, Prefer not to answer
EarlyON Registered Member	Earlyon_Registered_Members__c	Canadian-born	canadian_born__c	PICKLIST	false-false	Yes, No, Prefer not to answer
EarlyON Registered Member	Earlyon_Registered_Members__c	Disability	disability__c	PICKLIST	false-false	Yes, No, Don't know, Prefer not to answer
EarlyON Registered Member	Earlyon_Registered_Members__c	Household Income	household_income__c	PICKLIST	false-false	0 - $29,999, $30,000-$49,999, $50,000-$69,999, $70,000-$99,999, $100,000-149,999, $150,000 or more, Don't know, Prefer not to answer
EarlyON Registered Member	Earlyon_Registered_Members__c	Time of immigration	time_of_immigration__c	PICKLIST	false-false	0-5 years, 6-10 years, More than 10 years, Don't know, Prefer not to answer
EarlyON Registered Member	Earlyon_Registered_Members__c	Gender	gender__c	PICKLIST	false-false	Prefer not to answer, Woman, Man, Trans woman, Trans man, Gender non-binary (including gender fluid, genderqueer, androgynous), Two-Spirit, Not listed
EarlyON Registered Member	Earlyon_Registered_Members__c	Indigenous Identity	indigenous_identity__c	PICKLIST	false-false	Yes, No, Prefer not to answer
EarlyON Registered Member	Earlyon_Registered_Members__c	Member sexual orientation	member_sexual_orientation__c	PICKLIST	false-false	Bisexual, Gay, Heterosexual or Straight, Lesbian, Not listed, Prefer not to answer, Queer, Unsure
HSI Auto subject rule	HSI_Auto_subject_rule__c	Activity	activity__c	PICKLIST	false-false	App - New Application, App - Reapplication, App - Renewal/Reinstate, App - Hardship/Priority Application, FS - Enquiry Info, FS - File Update, FS - Admin/Account, FS - Divisional Transfer, FS - Benefit Request, FS - File Transfer, Admin - Appointment/Meeting, Inquiry
HSI Auto subject rule	HSI_Auto_subject_rule__c	Line of Business	line_of_business__c	PICKLIST	false-false	Ontario Works, Child Care - Fee Subsidy/Full Fee, Rent Geared to Income, Welcome Policy, Medical Benefits, Fair Pass, Temporary Care Assistance, Emergency Energy Fund, T5, Funeral, Dropped Call / Dead Air, Other
HSI Auto subject rule	HSI_Auto_subject_rule__c	Interaction Outcome	interaction_outcome__c	PICKLIST	false-false	Complete, Incomplete, Withdrawn, Ineligible, Additional Review
HSI Auto subject rule	HSI_Auto_subject_rule__c	Service Request Channel	service_request_channel__c	PICKLIST	false-false	Phone, Web, Virtual, Other (mail/fax)
Service Delivery To Client	Services_to_client__c	CRM Status	service_delivery_status__c	PICKLIST	false-false	Active, Approved, Closed, Pending Closure, Submitted, Suspended